close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Can't connect to MySQL?

Thread began 6/29/2010 6:10 pm by info360637 | Last modified 7/14/2010 1:19 pm by Jason Byrnes | 1324 views | 9 replies |

info360637

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

Sign in to reply to this post

Jason ByrnesWebAssist

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

Sign in to reply to this post

info360637

Can't connect

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

Sign in to reply to this post

Jason ByrnesWebAssist

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

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

Sign in to reply to this post

info360637

Still no go..

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

Sign in to reply to this post

info360637

update..

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

Sign in to reply to this post

neilo

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?

Sign in to reply to this post

info360637

Can't connect...

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

Sign in to reply to this post

info360637

Sorted

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

Sign in to reply to this post

Jason ByrnesWebAssist

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?

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...