Webboard: MySQL connection issues

Author: RACooper
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.



[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=21389>