vb.org Archive - Database / MySQL error

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)

- - Database / MySQL error (https://vborg.vbsupport.ru/showthread.php?t=295935)

Database / MySQL error

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

Code:

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.

Code:

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.

Code:

/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?

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

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

Code:

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

Code:

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

Code:

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

Code:

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

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

Code:

        //        ****** 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?

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

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.

Quote:

Originally Posted by stoute (Post 2409045)

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.

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (8)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02256 seconds Memory Usage 1,729KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (8)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: