Hello Folks,
I hope someone can help out here.
I have setup MW 1.22.* successfully on a test server of my own but am now having trouble going into "production" ...
I have a managed Linux server. Via the web panel, I have created a database and a database user. On the command line, I have to connect to the database via a form like :
mysql -u user -S /tmp/mysql5.sock -p database
I have to use the "socket" form (-S) or it fails to connect (access denied). See :
http://faq.1and1.co.uk/web_space__access/mysql/12.html
I am trying to set up MW 1.22.7, running the initial setup (mw-config/index.php) to set up the database I get an error :
1) Using database = localhost
ERROR = DB connection error: Access denied for user: 'dbuser@localhost' (Using password: YES) (localhost).
2) Using database = localhost:/tmp/mysql5.sock
ERROR = DB connection error: Unknown MySQL server host 'localhost:/tmp/mysql5.sock' (1) (localhost:/tmp/mysql5.sock).
I refererred to this page for the 2nd format above :
http://www.mediawiki.org/wiki/Manual:Config_script
"Note: If running MySQL using a different socket file (e.g. mysql on localhost, using --socket=/tmp/mysocketfile), set the database host to:"localhost:/tmp/mysocketfile". Sometimes sockets are called ports. If you have a port number for your database host, follow the same syntax:"my.host.url:port"."
I also see a resolved bug (with code I see I have in 1.22.7 (IP.php)) :
mysqli: Non-standard port handling broken (explicit parameter int $port expected) https://bugzilla.wikimedia.org/show_bug.cgi?id=58153
I tried the command line installer but got problems as well e.g.
php5.5 maintenance/install.php wikiname admin --pass <pass> \
--dbname <database> --dbserver localhost:/tmp/mysql5.sock --dbuser <dbuser> --dbpass <dbpass> \ --scriptpath "/w" X-Powered-By: PHP/5.5.12 Content-type: text/html ... Setting up database DB connection error: Connection refused (localhost:/tmp/mysql5.sock). Check the host, username and password and try again.
Does anyone know how I can get MW connected here?
On Fri, May 30, 2014, at 08:55 AM, Alastair Sherringham wrote:
I have a managed Linux server. Via the web panel, I have created a database and a database user. On the command line, I have to connect to the database via a form like :
mysql -u user -S /tmp/mysql5.sock -p database
I have to use the "socket" form (-S) or it fails to connect (access denied). See :
Regarding the problem I have setting up a new 1.22.7 installation on a managed host where MySQL needs to be accessed via a socket (-S), I see Jesús Martínez Novo has logged a bug yesterday :
Bug 65998 - mysqli: No way to specify the socket location https://bugzilla.wikimedia.org/show_bug.cgi?id=65998
I think this is the same issue I am having and Jesús has beaten me to logging the bug. I will add what information I have and add myself to the Cc list.
Cheers,
mediawiki-l@lists.wikimedia.org