[Bug 230393] Re: Mysql socket file breaks PHP/Perl/etc...

[Ciro]

** Description changed:

  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

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