Database / MySQL error

[stoute]

I'm getting this message below about 100+ times a day since I moved to my own server from godaddy.

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Host 'p3nlhg550.shr.prod.phx3.secureserver.net' is not allowed to connect to this MySQL server
/home/content/32/4571132/html/sites/green_rom_project/com/includes/class_core.php on line 317

MySQL Error   :
Error Number  :
Request Date  : Saturday, March 9th 2013 @ 08:16:32 AM
Error Date    : Saturday, March 9th 2013 @ 08:16:33 AM
Script        : http://greenromproject.com/reider-team-[premium]/?sort=lastpost&order=asc
Referrer      :
IP Address    : 173.199.115.3
Username      :
Classname     : vB_Database
MySQL Version :

the weird part about these errors are that the host it is on is not the one listed. Thats the old godaddy database which has been deleted.

Host 'p3nlhg550.shr.prod.phx3.secureserver.net'

another thing that is strange is that the location of the file class_config.php is not in that location or even on that server.

/home/content/32/4571132/html/sites/green_rom_project/com/includes/class_core.php

I have cleared the sites cache thinking that the old files were referencing old data.

Does anyone have any ideas?

[ForceHSS]

Host in your config needs changed to localhost as you still have the old godaddy one

[stoute]

Thats what I thought but I have already changed the host in the config file to localhost via local IP (127.0.0.1) with the correct database name, username, password.

Another weird thing is the referenced hostname changes depending on the email I get...

Host 'p3nlhg549.shr.prod.phx3.secureserver.net'

Host 'p3nlhg550.shr.prod.phx3.secureserver.net'

Host 'p3nlhg551.shr.prod.phx3.secureserver.net'

Host 'p3nlhg552.shr.prod.phx3.secureserver.net'

Below is a copy of the section of config file you referenced.

	//	****** MASTER DATABASE SERVER NAME AND PORT ******
	//	This is the hostname or IP address and port of the database server.
	//	If you are unsure of what to put here, leave the default values.
	//
	//	Note: If you are using IIS 7+ and MySQL is on the same machine, you 
	//	need to use 127.0.0.1 instead of localhost
$config['MasterServer']['servername'] = '127.0.0.1';
$config['MasterServer']['port'] = 3306;

maybe I did this wrong?

[Lynne]

Try changing it to:
$config['MasterServer']['servername'] = 'localhost';

[stoute]

I'm not sure why this would make any difference but, I changed the name of the config.php file on the old host to config.php.old a couple hours ago and I haven't received an error email since... I don't know why that would have made any difference but it seems to have resolved the emails.

I also changed the 127.0.0.1 to localhost just now to attempt to help resolve any errors in the future.

Thanks for the assist.

[Lynne]

Originally Posted by stoute

I'm not sure why this would make any difference but, I changed the name of the config.php file on the old host to config.php.old a couple hours ago and I haven't received an error email since... I don't know why that would have made any difference but it seems to have resolved the emails.

Why don't you just remove all the files from the old host? Basically what you've done is 'break' your old vb installation. If you just deleted all the files, it would have stopped the messages also.