<HTML>
<HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="OPENWEBMAIL" name=GENERATOR>
</HEAD>
<BODY bgColor=#ffffff>
<font size="2"><font size="3">Its still a matter of checking that site's user to make sure it works. The error clearly points to a database call on line 6 of the file "authinfo.inc". You need to look to see what the host, username, and password are for that site (probably inside that authinfo.inc file).
<br />
<br />Once you find that information for that site's database calls, test it from the command line with "mysql -u <span style="font-style: italic;"><username from file></span> -p". It will prompt you for the password - use the one you found in that file. If it doesn't work - you've found the problem. Correct the user, password, or host in the user permissions table in the mysql database.
<br />
<br />If it does work (and you get into mysql), check to make sure you can access that site's database once in. Use the command "use <span style="font-style: italic;"><database name></span>;". If you get an error - the problem is in the permissions "db" table in the mysql database.
<br />
<br />If both do work - go back and double-check the site's authinfo.inc file. Its probably trying some host other than localhost, or on a different port.
<br />
<br />Good luck.
<br />
<br />
<br />Chuck
<br />
<br /></font>
<br /><b>---------- Original Message
-----------</b>
<br />
From: "fastreplies" <fastreplies@shaw.ca>
<br />
To: "BlueOnyx General Mailing List" <blueonyx@blueonyx.it>
<br />
Sent: Thu, 18 Mar 2010 15:10:41 -0600
<br />
Subject: [BlueOnyx:04055] Re: MySQL ERROR
<br />
<br />> Hi Chris,
<br />>
<br />>
As I said, this is the only one site that gives us problem.
<br />>
All other DBs are working just fine
<br />>
<br />>
We login as root and find no error messages of any kind in MySQL.
<br />>
All users has been imported and in place
<br />>
<br />>
Still MySQL for that site is not working
<br />>
<br />>
Cheers
<br />>
<br />>
----- Original Message -----
<br />>
From: "Chris Gebhardt - VIRTBIZ Internet"
<cobaltfacts@virtbiz.com>
<br />>
To: "BlueOnyx General Mailing List" <blueonyx@blueonyx.it>
<br />>
Sent: Thursday, March 18, 2010 1:39 PM
<br />>
Subject: [BlueOnyx:04051] Re: MySQL ERROR
<br />>
<br />>
> fastreplies wrote:
<br />>
>> Hi,
<br />>
>>
<br />>
>> We migrated from RAQ to BlueOnyx last night and everything is working
<br />>
>> including MySQL except for one site MySQL. For some reson it give us
<br />>
>> problems. Here is the error that comes up on site
<br />>
>>
<br />>
>> Warning: mysql_connect() [function.mysql-connect]: Can't connect to
local
<br />>
>> MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in
<br />>
>> /home/sites/site84/web/res/inc/authinfo.inc on line 6
<br />>
>> Could not connect to MySql Can't connect to local MySQL server through
<br />>
>> socket '/var/lib/mysql/mysql.sock' (111)
<br />>
>>
<br />>
>> What should we fix to make it work?
<br />>
>
<br />>
> Did you import your users? Is it a credentials issue, or is MySQL
even
<br />>
> running?
<br />>
>
<br />>
> Try logging into MySQL via CLI and see what you get as root, and also as
<br />>
> your site's user. You may have to recreate (or import) the users into
<br />>
> MySQL.
<br />>
>
<br />>
> --
<br />>
> Chris Gebhardt
<br />>
> VIRTBIZ Internet Services
<br />>
> Access, Web Hosting, Colocation, Dedicated
<br />>
> <a target="_blank" href="http://www.virtbiz.com/">www.virtbiz.com</a> |
toll-free (866) 4 VIRTBIZ
<br />>
> _______________________________________________
<br />>
> Blueonyx mailing list
<br />>
> Blueonyx@blueonyx.it
<br />>
> <a target="_blank" href="http://www.blueonyx.it/mailman/listinfo/blueonyx">http://www.blueonyx.it/mailman/listinfo/blueonyx</a>
<br />>
<br />>
_______________________________________________
<br />>
Blueonyx mailing list
<br />>
Blueonyx@blueonyx.it
<br />>
<a target="_blank" href="http://www.blueonyx.it/mailman/listinfo/blueonyx">http://www.blueonyx.it/mailman/listinfo/blueonyx</a>
<br /><b>------- End of Original Message
-------</b>
<br />
</font>
</BODY>
</HTML>