Page 1 of 1
Different MySql confirguration on cold restart
Posted: 19 Oct 2009, 04:51
by janeks
Hi!
How the MySql is getting configuration upon cold start?
I observed following behaviour:
I needet to change bind address in /etc/mysql/my.cnf to use both phpmyadmin and to access database from LAN. Upon mysql restart the changes was in effect.
But upon cold start it looks like configuration is different - I could not acces database neither from phpmyadmin and LAN. Again after mysql restart - all is o'k.
Any hints?
brgds
Janeks
Re: Different MySql confirguration on cold restart
Posted: 25 Oct 2009, 12:12
by janeks
Bump...
What could be wrong?
What to test ?
Re: Different MySql confirguration on cold restart
Posted: 27 Oct 2009, 10:25
by tor
Just to be clear. MySQL is running and you are able to access it locally when it does not work from lan/phpmyadmin?
/Tor
Re: Different MySql confirguration on cold restart
Posted: 27 Oct 2009, 10:29
by janeks
Looks like that.
At least all Bubbas web interface works.
Janeks
Re: Different MySql confirguration on cold restart
Posted: 28 Oct 2009, 04:14
by tor
Hi again,
The web interface does not use Mysql atm so that is no indication that it works locally.
But to summarize, it do work when you do a
but the change does not persist over a reboot?
/Tor
Re: Different MySql confirguration on cold restart
Posted: 28 Oct 2009, 04:24
by janeks
Yes - exactly
Re: Different MySql confirguration on cold restart
Posted: 09 Nov 2009, 13:13
by tor
Hi Janeks,
This one beats me. I have eyed through the startup scripts without finding any indications on your problem. Could you look into the log files and see if there is anything suspicious? Anyone else that have experienced this?
/Tor
Re: Different MySql confirguration on cold restart
Posted: 10 Nov 2009, 06:11
by asparak
A couple of ways the config can change in MySQL:
Starting or restarting it as the wrong user, so it doesn't have permissions for the my.cnf file and runs with a default setup
Starting or running it as a different user that has its own config
corrupt config file
Re: Different MySql confirguration on cold restart
Posted: 10 Nov 2009, 09:30
by janeks
Some records from horde.log:
Code: Select all
...
Oct 19 11:25:07 HORDE [emergency] [kronolith] DB Error: connect failed: [nativecode=Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)] ** Array [pid 4573 on line 723 of "/usr/share/horde3/lib/Horde/Group/sql.php"]
Oct 19 11:25:07 HORDE [error] [kronolith] DB Error: connect failed: [nativecode=Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)] ** Array [pid 4573 on line 191 of "/usr/share/horde3/lib/Horde/Prefs/sql.php"]
Oct 19 11:30:05 HORDE [error] [horde] DB Error: connect failed: [nativecode=Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)] ** Array [pid 4579 on line 138 of "/usr/share/horde3/lib/Horde/Prefs/sql.php"]
Oct 19 11:30:05 HORDE [error] [horde] DB Error: connect failed: [nativecode=Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)] ** Array [pid 4579 on line 138 of "/usr/share/horde3/lib/Horde/Prefs/sql.php"]
Oct 19 11:30:08 HORDE [emergency] [kronolith] DB Error: connect failed: [nativecode=Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)] ** Array [pid 4579 on line 723 of "/usr/share/horde3/lib/Horde/Group/sql.php"]
Oct 19 11:30:08 HORDE [error] [kronolith] DB Error: connect failed: [nativecode=Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)] ** Array [pid 4579 on line 191 of "/usr/share/horde3/lib/Horde/Prefs/sql.php"]
After that no records in horde.log
It seems that I did mySql restart.