[BlueOnyx:04057] Re: MySQL ERROR

[Chuck Tetlow]

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). 

Once you find that information for that site's database calls, test it from the command line with "mysql -u <username from file> -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. 

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 <database name>;".  If you get an error - the problem is in the permissions "db" table in the mysql database.

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.

Good luck.

Chuck

---------- Original Message -----------
From: "fastreplies" <fastreplies at shaw.ca> 
To: "BlueOnyx General Mailing List" <blueonyx at blueonyx.it> 
Sent: Thu, 18 Mar 2010 15:10:41 -0600 
Subject: [BlueOnyx:04055] Re: MySQL ERROR

> Hi Chris, 
> 
> As I said, this is the only one site that gives us problem. 
> All other DBs are working just fine 
> 
> We login as root and find no error messages of any kind in MySQL. 
> All users has been imported and in place 
> 
> Still MySQL for that site is not working 
> 
> Cheers 
> 
> ----- Original Message ----- 
> From: "Chris Gebhardt - VIRTBIZ Internet" <cobaltfacts at virtbiz.com> 
> To: "BlueOnyx General Mailing List" <blueonyx at blueonyx.it> 
> Sent: Thursday, March 18, 2010 1:39 PM 
> Subject: [BlueOnyx:04051] Re: MySQL ERROR 
> 
> > fastreplies wrote: 
> >> Hi, 
> >> 
> >> We migrated from RAQ to BlueOnyx last night and everything is working 
> >> including MySQL except for one site MySQL. For some reson it give us 
> >> problems. Here is the error that comes up on site 
> >> 
> >> Warning: mysql_connect() [function.mysql-connect]: Can't connect to local 
> >> MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in 
> >> /home/sites/site84/web/res/inc/authinfo.inc on line 6 
> >> Could not connect to MySql Can't connect to local MySQL server through 
> >> socket '/var/lib/mysql/mysql.sock' (111) 
> >> 
> >> What should we fix to make it work? 
> > 
> > Did you import your users?   Is it a credentials issue, or is MySQL even 
> > running? 
> > 
> > Try logging into MySQL via CLI and see what you get as root, and also as 
> > your site's user.  You may have to recreate (or import) the users into 
> > MySQL. 
> > 
> > -- 
> > Chris Gebhardt 
> > VIRTBIZ Internet Services 
> > Access, Web Hosting, Colocation, Dedicated 
> > www.virtbiz.com | toll-free (866) 4 VIRTBIZ 
> > _______________________________________________ 
> > Blueonyx mailing list 
> > Blueonyx at blueonyx.it 
> > http://www.blueonyx.it/mailman/listinfo/blueonyx 
> 
> _______________________________________________ 
> Blueonyx mailing list 
> Blueonyx at blueonyx.it 
> http://www.blueonyx.it/mailman/listinfo/blueonyx 
------- End of Original Message -------
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.blueonyx.it/pipermail/blueonyx/attachments/20100318/39aecfcb/attachment.html>