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?
--
Alastair Sherringham
http://www.sherringham.net