Results 1 to 8 of 8

Thread: Database Error on vBulletin

  1. #1
    Registered
    Join Date
    May 2008
    Posts
    13

    Database Error on vBulletin

    Hallo
    Some week ago I changed my vBullettin hosting for a bigger one with the PHP more updated.
    Everything works but at the beginning I received, an email with a database connection error that slowly diseappeared.

    In these day it has started again to send me this error messages; I copy the text here below:

    Code:
    vBulletin Database Error!
    
    Database error in vBulletin :
    
    mysql_connect(): Host '213-215-228-XXX.hosting.net' is not allowed to connect to this MySQL server
    /var/www/vhosts/dominio.estensione/httpdocs/includes/class_core.php on line 274
    
    MySQL Error  : 
    Error Number : 
    Date         : Friday, July 18th 2008 @ 04:57:19 PM
    Script       : http ://dominio.estensione/1583-post17.html
    Referrer     : 
    IP Address   : 72.36.115.XXX
    Username     : 
    Classname    : vb_database
    I have asked to the Hosting the reason of this error and he answered that the server has no problem and even mysql server works correctly.

    He says that the problem seems to come from the fact that the application tries to connect to db on 213.215.228.XXX (old server?) and being another server is correct that it dosn't allows the connection.

    He suggest to verify that all the Db connection are to "localhost" and not to external DB and he concludes saying that it is surely a problem of my configuration.

    vBullettin is updated to 3.6.8 Patch Level 1 version and vBSEO 3.0.0. is installed.

    Anyone has an Idea to help me solve the problem?

    Thank you very much


    __________________
    You have never see animals gift like these! (cane regalo on italian scuola primaria)

  2. #2
    Administrator Chris's Avatar
    Join Date
    Feb 2003
    Location
    East Lansing, MI USA
    Posts
    7,051
    Did you check to make sure the database was connecting to localhost?

    That is the problem, really. A setting somewhere is trying to get it to connet to an old host.
    Chris Beasley - My Guide to Building a Successful Website[size=1]
    Content Sites: ABCDFGHIJKLMNOP|Forums: ABCD EF|Ecommerce: Swords Knives

  3. #3
    Registered
    Join Date
    May 2008
    Posts
    13
    Then, i'm ri-seeing it the config php.
    Meanwhile thanks.
    Bye bye

  4. #4
    Registered
    Join Date
    May 2008
    Posts
    13
    So, I looked for in file config.php (inside include folder) the entry that can be like the error's one and I found this:

    // ****** 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.
    $config['MasterServer']['servername'] = '213.215.228.XXX;
    $config['MasterServer']['port'] = 3306;
    Really the xxx of the number 213.215.228.XXX hide digits but are not the same as the ones reported in the error.
    I have tried to substitute the file in this way and to upload again on the server:

    // ****** 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.
    $config['MasterServer']['servername'] = 'localhost';
    $config['MasterServer']['port'] = 3306;
    But the problem is that the error stay, even if different...!!

    Database error in vBulletin :

    mysql_connect(): Access denied for user 'pippo'@'localhost' (using password: YES)
    /var/www/vhosts/dominio.estensione/httpdocs/includes/class_core.php on line 274

    MySQL Error :
    Error Number :
    Date : Friday, August 1st 2008 @ 04:46:23 PM
    Script : http ://dominio.estensione/tags/romano/
    Referrer :
    IP Address : 72.36.115.XXX
    Username :
    Classname : vb_database
    How can I solve it?
    Thak you very much

  5. #5
    Registered
    Join Date
    May 2008
    Posts
    13
    I've checked the config.php configuration and everything seems ok but the
    error stay; I don't know what to do now!!!

    I tried to open the file too:
    /var/www/vhosts/dominio.estensione/httpdocs/includes/class_core.php on line 274

    and at line 724 (that the error report) I found this code:
    Code:
    $link = $this->functions[$usepconnect ? 'pconnect' : 'connect']("$servername:$port", $username, $password);
    Could it be useful to understand where and how operating?

    Thank you

  6. #6
    Administrator Chris's Avatar
    Join Date
    Feb 2003
    Location
    East Lansing, MI USA
    Posts
    7,051
    the new error is a username/password error. You've got the wrong database username/password in your vbulletin config file.
    Chris Beasley - My Guide to Building a Successful Website[size=1]
    Content Sites: ABCDFGHIJKLMNOP|Forums: ABCD EF|Ecommerce: Swords Knives

  7. #7
    Registered
    Join Date
    May 2008
    Posts
    13
    Great, I've fixed it!!!

    After a lot of trouble and reading again the vBulletin manual I've found an incoherence in config.php file.

    It's in this section:

    Code:
        //    ****** MASTER DATABASE USERNAME & PASSWORD ******
        //    This is the username and password you use to access MySQL.
        //    These must be obtained through your webhost.
    $config['MasterServer']['username'] = 'root';
    $config['MasterServer']['password'] = '';
    The last two lines were duplicated, the first with a wrong username.

    I can't understand how it can be happened but removing that 2 lines the error doesn't appear anymore.

    Thanks to everybody.

    Bye

  8. #8
    Administrator Chris's Avatar
    Join Date
    Feb 2003
    Location
    East Lansing, MI USA
    Posts
    7,051
    glad it worked otu.
    Chris Beasley - My Guide to Building a Successful Website[size=1]
    Content Sites: ABCDFGHIJKLMNOP|Forums: ABCD EF|Ecommerce: Swords Knives

Similar Threads

  1. In MySQL, possible to use two database in one PHP web application...?
    By jackbabington in forum Website Programming & Databases
    Replies: 6
    Last Post: 07-20-2008, 11:02 AM
  2. Getting ready to launch vBulletin site
    By cinemaeye in forum Community Management
    Replies: 10
    Last Post: 08-22-2006, 02:02 AM
  3. Stretching Vbulletin
    By paul in forum Community Management
    Replies: 2
    Last Post: 01-23-2006, 01:16 AM
  4. Clear my misunderstanding: 1 MySQL database for many programs?
    By iKwak in forum Website Programming & Databases
    Replies: 4
    Last Post: 08-21-2005, 10:40 AM
  5. Database Driven Websites
    By star in forum Website Programming & Databases
    Replies: 6
    Last Post: 10-21-2003, 03:51 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •