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
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
