Topic: Have i killed mysql?

[cydonia]

Hi,

I followed the info on this thread to move the location of the mysql database:
http://forums.contribs.org/index.php?topic=22215.0

And now i cant connect to the db.  I get my die message for trying to connect with web apps, and i get the below if i try to connect to phpmyadmin.

======================================================

Welcome to phpMyAdmin 2.6.0-alpha1

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.

Error

MySQL said:
Cannot connect: invalid settings.
====================================================


I want to do one of two thing..

1) try to fix this and keep my new db location.

2) cancel the template-custom mod and revert back to original setting, in the hope of getting it to work.


Any ideas?


Thanks.

[mrjhb3]

Did you happen to stop and start the mysqld daemon after you made the changes and expanded the template?  If not, try /etc/rc.d/rc7.d/S90mysqld restart.  

JB

[cydonia]

yikes... i got this when i tried what you said:


[root@centralserver root]# /etc/rc.d/rc7.d/S90mysqld restart

Stopping MySQL:     [ FAILED ]                                          
Starting MySQL:     [   OK   ]                                          


So then i did a status and got this \/.

[root@centralserver root]# service mysqld status
mysqld dead but subsys locked


Doesn't sound too promising to me...

[mrjhb3]

No, that doesn't look too promising.  I did the exact same commands on my live system.

[root@jbesmith root]# /etc/rc.d/rc7.d/S90mysqld restart
Stopping MySQL:  [   OK   ]
Starting MySQL:  [   OK   ]
[root@jbesmith root]# service mysqld status
mysqld (pid 21700 21699 21698 21696) is running...
[root@jbesmith root]#

I googled for your error and here is a link.  I hope it helps.

https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=14947

In my /var/lib directory, here is the attributes for the mysql directory:
drwxr-xr-x    6 mysql    mysql        4096 Aug  9 23:25 mysql

Then, here is what is under my mysql directory on my system:

drwx------    2 mysql    mysql        4096 Aug  1 19:28 test
drwx------    2 mysql    mysql        4096 Aug  2 02:24 mysql
drwx------    2 mysql    mysql        4096 Aug  2 07:07 phpmyadmin
drwxr-xr-x   16 root     root         4096 Aug  2 07:36 ..
drwx------    2 mysql    mysql        4096 Aug  2 21:43 horde
srwxrwxrwx    1 mysql    mysql           0 Aug  9 23:25 mysql.sock
drwxr-xr-x    6 mysql    mysql        4096 Aug  9 23:25 .


Good Luck,

JB

[Shilotsugu]

I may have killed mysql without hope of resurrection as well...

Wanting to learn about and explore the potential of MySQL included in SME, I downloaded MySQL Administrator to get started. It looked interesting (challenging, maybe - but not rocket science). After finding out that it needed version 4.0, I upgraded my server following the steps on this HowTo:

http://forums.contribs.org/index.php?topic=23920.0

and upgraded without incident.

Although I was able to access the databases with ssh, I got the following error with Administrator.

MySQL Error Nr. 1130
Host "pc-000##.xxx.yyy.org" is not allowed to connect to this MySQL server

Thinking that I may not have enabled remote connections properly, I did more searching of the forums. For whatever reason, most people prefer to use PHPmyadmin. At any rate, my trouble started by following the advice on this thread:
http://forums.contribs.org/index.php?topic=23699.0

More specifically

# /sbin/e-smith/config setprop mysqld LocalNetworkingOnly no
# /sbin/e-smith/expand-template /etc/my.cnf
# /etc/rc.d/init.d/mysqld restart

After which I got the following:

No mysqld pid file found. Looked for /var/lib/mysql/<servername>.pid.

*dread*
Foolishly tried to open mysql

# mysql

040918  1:45:54 Warning: Asked for 196608 thread stack, but got 126976
040918  1:45:54 Can't start server: Bind on TCP/IP port: Address already in use
040918  1:45:54 Do you already have another mysqld server running on port: 3306?
040918  1:45:54 Aborting.

The learning curve for this isn't exactly gentle, is it? Have I deleted the databases entirely?