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.

MySQL and forums

Discussion in 'General Discussion' started by Mini, Apr 19, 2006.

  1. Mini

    Mini Well-Known Member

    Joined:
    Mar 4, 2005
    Messages:
    98
    Likes Received:
    0
    Trophy Points:
    6
    Hello all,

    I used the ELS script, http://www.nsonetworks.com/els.php to upgrade my MySQL version to 4.1 and did other things such as disable MySQL networking and made it a higher prioity and it seems as my PHP forums have stopped working.

    An example of a PHP forum on my server is http://www.bigeyearts.co.uk/forum2.

    I tried downgrading MySQL, but that doesn't help. I am thinking that it's a PHP issue and I will recompile PHP from scratch as a last resort, I have already recompiled it once with PHP support.

    Thanks to anyone who can help me.
     
  2. MMarko

    MMarko Well-Known Member

    Joined:
    Apr 18, 2005
    Messages:
    316
    Likes Received:
    0
    Trophy Points:
    16
    Add in my.cnf this line which enables mysql to use old passwords. Search forums.
     
  3. Blue|Fusion

    Blue|Fusion Well-Known Member

    Joined:
    Sep 12, 2004
    Messages:
    378
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Cleveland, Ohio
    You have to recompile PHP after upgrading to MySQL 4.1 from 4.0 or else PHP will fail, thus apache fails to start. It will complain about a mysql library file not found, and that is the reason behind recompiling it with 4.1 support.
     
  4. celliott

    celliott Well-Known Member

    Joined:
    Jan 2, 2006
    Messages:
    460
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    United Kingdom
    Although these all-in-one scripts are good, I would always advise installing things manually, as its configured based on your server, and it also makes identifying problems much easier.

    You cannot upgrade MySQL to 4.1 and then go back to 4.0 without having major database issues, since during the upgrade process your databases will have been modified.

    Force a reinstall of MySQL 4.1 and then recompile apache

    In your my.cnf add this:

    [mysqld]
    old-passwords

    Then restart mysql and you should be ok.

    You may also need to reinstall Perl so cPanel can properly control the new MySQL. Just grab the latest installer from http://layer2.cpanel.net, extract and execute.

    If you are still unsure you could hire the services of Andy (www.servertune.com) or Chirpy's (www.configserver.com) which both have a very good reputation on these boards.

    Chris
     
Loading...

Share This Page