Can't connect to MySQL?

Hi - I'm having trouble connecting to the server - getting this error:

Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/hsphere/local/home/dnaladmin/dnal.co.uk/cms/Connections/localhost.php on line 9 Fatal error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/hsphere/local/home/dnaladmin/dnal.co.uk/cms/Connections/localhost.php on line 9

I thought it might be the 'pconnect' so I changed it to a 'connect' ( non persisent) which has worked in the past but no joy. I have triple checked server names/users/passwords - could it be a flag needs setting on the server .ini file?

thanks
Jim

if you are using 'localhost' for the my sql server name, try using '127.0.0.1' instead.

Hi - yep already tried that - gives a different error ( Tomcat?) - any other ideas - could it be a permissions thing - they're all set to 755?

thanks
Jim

your host may use a different name for the mySQL server.

Check with the host for the MySQL server name to use.

Hi have checked the server name - still giving an error:

users_login.php?accesscheck=%2Fcms%2Fadmin%2Findex.php

Anyone else seen this one before?

Thanks
Jim

..have managed to get it partially working - found a couple of files still set to 777 in the admin area - now brings up the CMS interface fine, have tried to add content but when the page is uploaded I get a bunch of error warnings output:

Warning: include(/home/hsphere/local/home/dnal/dnal.co.uk/cms/WA_CMS/addtosite.php): failed to open stream: No such file or directory in /home/hsphere/local/home/dnaladmin/dnal.co.uk/advertising.php on line 223 Warning: include(): Failed opening '/home/hsphere/local/home/dnal/dnal.co.uk/cms/WA_CMS/addtosite.php' for inclusion (include_path='.:/hsphere/shared/apache/libexec/php5ext/php/') in /home/hsphere/local/home/dnaladmin/dnal.co.uk/advertising.php on line 223 Fatal error: Call to undefined function wa_getcmscontent() in /home/hsphere/local/home/dnaladmin/dnal.co.uk/advertising.php on line 224

Any ideas? Have checked all files are there -

Thanks
Jim

Hi info,

The addtosite.php would normally refer to the Connections/PowerCMSConnection.php file for the correct database connection details, but you don't seem to have 'PowerCMSConnection.php' in your cms/Connections folder, but have 'localhost.php' instead.

If that contains the connection details for the PowerCMS database, you would be required to update all the references to it in your pages, not a good idea.

Easier to ensure you have the correct details in a 'PowerCMSConnection.php' file in your cms/Connections directory.

Have you moved any other pages from their original (relative) location?

Hi Neilo - no as far as I'm aware I haven't moved any files from their original location?
Should that file exist already - or do I need to create it?

thanks
Jim

Hi - fixed the problem - just have to edit the dev notes that CMS generates and delete everything before 'cms/....etc'.

Seems to work - bit of a pain though.

cheers
Jim

did you move the CMS files outside the cms folder after running the installation wizard?

Look in the PowerCMS database, in the wa_settings table, what is the the PCMS Remote Root set to?