[Bug 230393] Re: Mysql socket file breaks PHP/Perl/etc...
** 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.0 -0400 - +++ mysql 2008-05-14 13:09:58.0 -0400 - @@ -110,6 +110,9 @@ -log_end_msg 0 - else - /usr/bin/mysqld_safe /dev/null 21 - + 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. -- 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
[Bug 230393] Re: Mysql socket file breaks PHP/Perl/etc...
TBH, I think it's more a bug in the perl/php stuff then in mysql. The socket file should sit in /var/run/mysqld and not in /tmp/ More detail: We should fix the packages which are looking for the socket file in /tmp then symlinking the socket file to /tmp. It's a good workaround for the time now, but not for the future. But that's me...what about our -server/ core devs? Any advise? -- 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
Re: [Bug 230393] Re: Mysql socket file breaks PHP/Perl/etc...
On Wed, May 14, 2008 at 05:37:13PM -, Stephan Hermann wrote: I think it's more a bug in the perl/php stuff then in mysql. The socket file should sit in /var/run/mysqld and not in /tmp/ More detail: We should fix the packages which are looking for the socket file in /tmp then symlinking the socket file to /tmp. I agree with Stephan - packages that look for /tmp/mysql.sock should be fixed. status wontfix -- Mathias Gug Ubuntu Developer http://www.ubuntu.com ** Changed in: mysql-dfsg-5.0 (Ubuntu) Status: New = Won't Fix -- 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
[Bug 230393] Re: Mysql socket file breaks PHP/Perl/etc...
Uhm, yeah, Debian/Ubuntu have had the MySQL socket there for ages. Any packaged application looking for it in the wrong place should be fixed. Any non-packaged app is being installed/run by someone who knows what they're doing (in theory) and can specify the socket location manually. -- 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