Last modified: 2011-04-30 01:16:47 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T20626, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 18626 - MySQL Connection dies with error 61
MySQL Connection dies with error 61
Status: RESOLVED INVALID
Product: MediaWiki
Classification: Unclassified
Maintenance scripts (Other open bugs)
1.14.x
All All
: Normal critical (vote)
: ---
Assigned To: Nobody - You can work on this!
http://bp.wikimetru.com
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2009-04-29 22:34 UTC by Seth Rees
Modified: 2011-04-30 01:16 UTC (History)
4 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Seth Rees 2009-04-29 22:34:06 UTC
Here's what I did:

"[wikimetr@buzz1 ~/www/bp/w/maintenance]$ php importDump.php /home/wikimetr/www/bp.xml.gz"

And I got the normal startup routine, like the MIME Type declaration etc., but then the script stopped with this:

"DB connection error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (localhost)"

Please help!
Comment 1 Seth Rees 2009-04-30 21:34:44 UTC
Also seems to affect rebuildall.php, marking as critical due to possible blockage of all MySQL-related maintenance scripts.
Comment 2 Chad H. 2009-05-01 00:07:05 UTC
Does MW run at all? This would sound like an issue with PHP not being able to talk to mySQL. Can you confirm that /tmp/mysql.sock does in fact exist?
Comment 3 Seth Rees 2009-05-01 02:14:35 UTC
MediaWiki works, yet /tmp/mysql.sock doesn't exist.
Comment 4 Brion Vibber 2009-05-01 17:49:47 UTC
Sounds like a local configuration issue -- web and command-line PHP are probably loading different configuration files and have a different MySQL socket set. Check your php.ini file(s).

(Alternatively you may be logging into a different machine than the actual web/database server.)
Comment 5 Seth Rees 2009-05-03 15:05:16 UTC
Nothing's wrong with the php.ini in the MediaWiki direcory: it just defines a session save path.
Comment 6 Brion Vibber 2009-05-08 19:08:37 UTC
Closing this as INVALID; local PHP vs MySQL configuration issue where their socket file paths don't match. (This is common on for instance Mac OS X systems when PHP and MySQL are installed from separate sources -- stock Apple preinstalled PHP and MySQL's package intaller for MySQL. Other Unix-like systems may similarly have installs that default to non-matching locations. Generally shouldn't happen if you installed both from the same package source, but could always be funky!)

See the MySQL and PHP manuals for how to configure them:

http://dev.mysql.com/doc/refman/5.1/en/server-options.html#option_mysqld_socket

http://us3.php.net/manual/en/mysql.configuration.php#ini.mysql.default-socket

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links