MySQL error

[Vile]

Hi,
Ok, I had my forums up and running, but now I keep getting a mysql error:

[/QUOTE]
Warning: Unknown MySQL Server Host 'mysql.mgforums.com' (11) in /c6/mgforums/forums/admin/db_mysql.php on line 38

Warning: MySQL Connection Failed: Unknown MySQL Server Host 'mysql.mgforums.com' (11) in /c6/mgforums/forums/admin/db_mysql.php on line 38

There seems to have been a slight problem with the database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.
We apologise for any inconvenience.
[QUOTE]


The actual URL to the forums is:
URL=http://207.234.140.55/forums/index.php?

Originally when setting up VBB, I had to use a temp mysql server, after that it did not work, so when the mysql server was ready, I changed the info to the new mysql server which is: mysql.mgforums.com. That was working fine until now.

Ideas?

Thanks.

[Steve Machol]

Try changing $servername to 'localhost' in config.php.

[Vile]

Ok, did that, now i get this message:

Warning: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /c6/mgforums/forums/admin/db_mysql.php on line 38

Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /c6/mgforums/forums/admin/db_mysql.php on line 38

[Steve Machol]

Either MySQL crashed or it cannot find the socket. You need to contact your host about this.

http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html

[Vile]

Originally posted by smachol
Either MySQL crashed or it cannot find the socket. You need to contact your host about this.

http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html

Thanks.

Ok, I contacted the host, and he said:

"actually you should be using apus.valueweb.net for the MySQL server name, since it looks like the DNS is not currently pointing to our system. I'm not certain how you're supposed to set that part up if it requires localhost. Basically, you'll want to treat it as a remote server, since the MySQL server is different than your Web server. "

Either way, I tried mysql.mgforums.com, apus.valueweb.net, and localhost, but nothing seems to work. :\

[Steve Machol]

You could try using:

$servername = "localhost:apus.valueweb.net";

[Vile]

Originally posted by smachol
You could try using:

$servername = "localhost:apus.valueweb.net";

Ok, I'll give that a shot. After a while, even apus.valueweb.net stopped working.

Currently its set to mysql.mgforums.com and it's working.
Could I do what you mentioned above, but use "localhost:mysql.mgforums.com"?

Thanks again.

[Steve Machol]

If it's working, don't mess with it. If it stops working it's because your host changed something on you. Then you need to contact them, or try "localhost:mysql.mgforums.com" if you want.

[Vile]

Ok, thanks for all of your help, much appreciated.