The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Huge MySQL problem

Discussion in 'Database Discussions' started by tenatious, May 31, 2007.

  1. tenatious

    tenatious Member

    Joined:
    Sep 3, 2005
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    Hi,
    I just updated to PHP 5.1.6. And now no connections can be made to old databases.

    www.packagehosts.com/billing/

    I have checked the configuration.php file and even deleted the database and recreated it. This has happened on every old database.

    Anyone know what the problem is? Thanks
     
  2. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Minneapolis, MN
    The first thing you need to do is to check the log files: /var/log/messages and /usr/local/apache/logs/* for any errors that might help in solving the problem.
     
  3. mguindon10

    mguindon10 Active Member

    Joined:
    Aug 23, 2005
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Detroit, MI.
    If you've done an upgrade from php 4 to 5 then read this, it's straight from php.net FAQ's:

    "61.2. Does MySQL work in PHP 5? It seemed to have disappeared.


    MySQL is supported with the only change being that MySQL support is no longer enabled by default in PHP 5. This essentially means that PHP doesn't include the --with-mysql option in the configure line so that you must now manually do this when compiling PHP. Windows users will edit php.ini and enable the php_mysql.dll DLL as in PHP 4 no such DLL existed, it was simply built into your Windows PHP binaries.

    Also, the MySQL client libraries are no longer bundled with PHP. More details on this topic are covered in the following FAQ and be sure to read the MySQL section for details on installing MySQL. An example configure line would be --with-mysql=/usr while Windows users will need the libmySQL.dll available to the system. "

    Like the last post says, check your logs and goto php.net and look at their documentation.
     
Loading...

Share This Page