Public bug reported: Binary package hint: mysql-server-5.0
Many projects using (perl) DBI and (php) adodb database APIs are looking for the mysql socket file in /tmp/mysql.sock rather than /var/run/mysqld/mysqld.sock. Changing the .cnf file to return the sock file to /tmp may cause problems with projects already modified to deal with the change. The current workaround is to symlink the socket file so that it is in both locations, but this tends to get wiped out when /tmp is cleared (generally on boot). The workaround I'm using is a local rc file to create the link, but with a minor addition to init.d/mysql the workaround can be made transparent. A minor issue for any one machine, but something of a nuisance when running several dozen Ubuntu servers. --- mysql.dist 2008-05-14 13:10:49.000000000 -0400 +++ mysql 2008-05-14 13:09:58.000000000 -0400 @@ -110,6 +110,9 @@ log_end_msg 0 else /usr/bin/mysqld_safe > /dev/null 2>&1 & + if [ ! -f /tmp/mysql.sock ] ; then + ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock + fi # 6s was reported in #352070 to be too few when using ndbcluster for i in 1 2 3 4 5 6 7 8 9 10 11 12 13 14; do sleep 1 ** Affects: mysql-dfsg-5.0 (Ubuntu) Importance: Undecided Status: New -- Mysql socket file breaks PHP/Perl/etc... https://bugs.launchpad.net/bugs/230393 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs