PDA

View Full Version : error messages when connecting to DB


sticks101
08-31-2009, 02:06 PM
I thought I had done everything correctly but...

here is the error message I get when trying to connect to the mySQL database within the setup manager.


Warning: mysql_get_server_info() [function.mysql-get-server-info (http://phoenixville.org/calendar/setup/function.mysql-get-server-info)]: Can't connect to MySQL server on 'localhost' (10061) in E:\CustomerData\webspaces\webspace_00100794\wwwroo t\calendar\setup\integrity.php on line 36

Warning: mysql_get_server_info() [function.mysql-get-server-info (http://phoenixville.org/calendar/setup/function.mysql-get-server-info)]: A link to the server could not be established in E:\CustomerData\webspaces\webspace_00100794\wwwroo t\calendar\setup\integrity.php on line 36
There was an error connecting to the mySQL database.

The error was reported as:

Can't connect to MySQL server on '65.61.37.51'

Thanks for any help, Leo

Brian
08-31-2009, 02:14 PM
Are you using "localhost" as your server name?

sticks101
08-31-2009, 04:20 PM
Maybe not. I did a search in the install instructions and did not find where to enter the server name.

Brian
08-31-2009, 04:23 PM
It's in the Setup Manager on the Database page.

If you can't get in there, try editing the config.inc.php file manually and change the variable in there.

sticks101
08-31-2009, 04:27 PM
Is that the field "database host"?

Brian
08-31-2009, 04:28 PM
Should be $sqlHost="localhost";

sticks101
08-31-2009, 04:34 PM
I was using the IP address where the database is located

sticks101
08-31-2009, 04:37 PM
now I get - Can't connect to MySQL server on 'localhost' (10061)

Brian
08-31-2009, 07:35 PM
Is the SQL server on the same server as your web site?

sticks101
09-01-2009, 08:01 AM
I'm not sure, I will check with my ISP. If not do I need to have them do something specific? thanks for your help...

ve9gra
09-01-2009, 10:12 AM
If your account has access to a MySQL database, then your host will be able to tell you what IP to use. Simply put that IP in the Database section of the Setup Manager.