Different MySql confirguration on cold restart

[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

[janeks]

Bump...

What could be wrong?
What to test ?

[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

[janeks]

Looks like that.
At least all Bubbas web interface works.

Janeks

[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

Code: Select all

/etc/init.d/mysql restart

but the change does not persist over a reboot?

/Tor

[janeks]

Yes - exactly

[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

[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

[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.