Webboard: MySQL connection issues

Author: Alexander Barkov
Email: [email protected]
Message:
> mysql is connected through stunnel using local port 3307 to forward to the tunnel on the remote server.  that setup works if I use command-line mysql client.

> 

>  [user@server ~]$ mysql -h 127.0.0.1 -P 3307 -u mnogosearch -p mnogosearch

> Enter password: (entered)

> 

> Welcome to the MySQL monitor.  Commands end with ; or \g.

> Your MySQL connection id is 65648

> Server version: 5.1.51-log SUSE MySQL RPM

> 

> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

> 

> mysql> show tables;

> +-----------------------+

> | Tables_in_mnogosearch |

> +-----------------------+

> | bdict                 | 

> | bdicti                | 

> | categories            | 

> | crossdict             | 

> | dict                  | 

> | links                 | 

> | qcache                | 

> | qinfo                 | 

> | qtrack                | 

> | server                | 

> | srvinfo               | 

> | url                   | 

> | urlinfo               | 

> | wrdstat               | 

> +-----------------------+

> 14 rows in set (0.00 sec)

> 

> 

> 

> I can't run the drop command; the user I have been given does not have DROP TABLES permissions.

> 



indexer does need DROP permissions and some other permissions.

I'm quite sure the problem is in too strict permissions.



To make this sure, you'll need to activate MySQL query log

on the remote server and see which SQL query causes the problem.



Another options is to install debug version of mnoGoSearch

and add "DebugSQL=yes" parameter to DBAddr.







> [user@server ~]$ indexer -Ecreate

> (whole lot of output removed)

> ERROR at line 186: MySQL driver: #1050: Table 'bdicti' already exists

> SQL>

> 15 queries sent, 1 succeeded, 14 failed

> 

> [user@server ~]$ indexer -S

> 

>           Database statistics [2012-01-18 11:43:27]

> 

>     Status    Expired      Total

>    -----------------------------

>    -----------------------------

>      Total          0          0

> 

> [user@server ~]$ indexer -n1

> Log has not been opened

> DB err: MySQL driver: #1044: Access denied for user 'mnogosearch'@'%' to database 'mnogosearch' - /etc/mnogosearch/indexer.conf:996: 

> 

> Now, by command line mysql i can use -h localhost IF I also specify --protocol=tcp.  I can't seem to specify that in the DBAddr config.  

> 

> Also, thanks for the hint on escaping the password.



Reply: <http://www.mnogosearch.org/board/message.php?id=21391>