I have a RAQ4 that I recently purchased from rackshack.net - I've installed MySQL 3.23.37 and PHP 4.0.6 through the Control Panel.

I can't get past step 2 installing vBulletin, here are the errors it gives me:

Warning: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in
/home/sites/home/web/boards/admin/db_mysql.php on line 40

Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
in /home/sites/home/web/boards/admin/db_mysql.php on line 40

Warning: Supplied argument is not a valid MySQL-Link resource in /home/sites/home/web/boards/admin/db_mysql.php
on line 47

The database has failed to connect because you do not have permission to connect to the server. Please go back to the last step and ensure that you have entered all your login details correctly.

Here is my PHP info test - http://www.tvlinksonline.com/phpinfo.php

If anybody can help me out with the configuration, please e-mail me at tofull@bellsouth.net or PM me. Thanks.

Have you have set up the config.php file with the correct details? ( server: localhost, make sure username, and password are correct)

Yes, I've tried editing the config.php file multiple times - it always results in the same error. I've used the default raq/mysql password and tried to change it to my own.

Have you updated the php.ini file with the line 'extension=mysql.so' ?

And, hehe, turned on mysql

The problem doesnt seem to be a config problem with the config.php file.

Yes, the php.ini file has been edited. What do you mean by 'turn on' mysql? There's no option to enable it in the control panel like there is for php, cgi-bin, etc. Is there something that I need to do in telnet to enable it?

Is it even installed, by default cobalts don't come with mysql on it. And you'd know how to install it you probably wouldn't have a problem enabling it.

Or did you install the pkg file, if not, you can get a mysql pkg file here http://pkg.nl.cobalt.com/packages/raq/4/#openssh

This will probably also enable mysql bij default.

<edit>i see you used the pkg version, didn't see it :stickout

You can try this with telnet. With my RAQ the sock file sometimes gets screwed up somehow. This may help

touch /var/lib/mysql/mysql.sock

Also do a "top" when logged in with telnet. See if mysql is somewhere there in the list.

If not there do this to start mysql

/etc/rc.d/init.d/mysql start

Or first stop it with
/etc/rc.d/init.d/mysql stop
</edit>

What username/password are you using in the config file of this script? The default .pkg install of MySQL leaves you with something like root/cobalt-mysql. CHANGE IT if you haven't already. I know you tried, but don't know if you did.

OK, so you've changed your root password, now have you created a user on MySQL with correct permissions? I would suggest you create another user other than root for accessing MySQL. Allow that user access from localhost.

Also, check if MySQL is even running.

ps-xwaj | grep mysql

You need shell access for this, the Cobalt GUI is not designed for MySQL administration. A great script for MySQL administration is phpmyadmin. Or at least thats what I think it's called. Get it.

A great source of information for MySQL can be found at

http://www.mysql.com

Originally posted by Lmax
You can try this with telnet. With my RAQ the sock file sometimes gets screwed up somehow. This may help

touch /var/lib/mysql/mysql.sock

Also do a "top" when logged in with telnet. See if mysql is somewhere there in the list.

If not there do this to start mysql

/etc/rc.d/init.d/mysql start

Or first stop it with
/etc/rc.d/init.d/mysql stop
</edit>

When I do touch /var/lib/mysql/mysql.sock in [admin admin] I get "permission denied". When I do that in [root / root] nothing happens.

I've looked in the /var/lib/mysql/ folder in FTP and there is no mysql.sock file - could that be causing the problem? How do I add it?

What do you mean by do a "top"? I'm not familiar with that.

Try uninstalling mysql and reinstalling it.

Before you do an uninstall/install, you might wanna check if MySQL places the socket ind /tmp/.

This once happened to be, but the other way round. I expected it to be in /tmp, when it really was /usr/lib.

If I remember right, this behaviour can be configured in /etc/my.cnf.

Marc

i had the same problem.

i:

shut down mysql.

install phpMyAdmin

setup phpMyAdmin(it won't work quite yet as mysql is down still)

restart safe_mysql with the --skip -grant-tables option

using phpMyAdmin, i edited the password for the ROOT user and removed all other users.

i then shut down safe_mysql

restarted normal mysql, then administered everything regarding mysql with phpMyAdmin


http://www.mysql.com/doc/R/e/Resetting_permissions.html
http://www.mysql.com/doc/G/R/GRANT.html

those are the only two links i have left from when i had to do that. good luck.

When you added:

extension=mysql.so

(without the ' at the end)

Did you restart httpd?

This problem is usually caused by mysql.sock being in one place and the program looking for it in another.

First cd to /tmp and see if mysql.sock is there ... if so then try this easy symlink solution (as root):
ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock

Now see if everything works.