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,php issues on new install

Discussion in 'General Discussion' started by dave9000, Apr 2, 2006.

  1. dave9000

    dave9000 Well-Known Member

    Joined:
    Apr 7, 2003
    Messages:
    891
    Likes Received:
    1
    Trophy Points:
    16
    Location:
    arkansas
    cPanel Access Level:
    Root Administrator
    Figured I would post this so it may help someone having this problem.

    There is a bug in the liblinker in mysql-devel 4.1.16 or higher. When trying to compile apache,php the compile will error out with liblinker: can not find /usr/lib/mysql/libz.la. The only known fix if you have this issue is to downgrade the mysql-devel-4.1.x to version 4.1.13. We had this issue this morning on a fresh install and upon researching using google its a known bug affecting RHEL3,4 and CentOS 3,4. The bug also is found in mysql 5.0.16. I repeat the only known fix available at this time is to downgrade the mysql-devel rpm to 4.1.13 or install from the src rpm and recompile apache and php.
     
  2. dave9000

    dave9000 Well-Known Member

    Joined:
    Apr 7, 2003
    Messages:
    891
    Likes Received:
    1
    Trophy Points:
    16
    Location:
    arkansas
    cPanel Access Level:
    Root Administrator
    Here is a little more information

    If you upgrade to mysql 4.1.18 which is in the EDGE version of cpanel apache and php will not compile.

    I had upgraded to EDGE before I did my apache phpsuexec recompile and had to back down mysql-devel to 4.1.13 to get a clean compile.

    If you do your apache compiile before upgrading to 4.1.18 then you can upgrade to 4.1.18 and everything will work
     
  3. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,475
    Likes Received:
    20
    Trophy Points:
    38
    Location:
    Go on, have a guess
    Not nice.

    I had a similar issue and had to rename /var/lib/mysql/ out of the way, compile apache, then put that directory back and it worked OK.
     
  4. BianchiDude

    BianchiDude Well-Known Member
    PartnerNOC

    Joined:
    Jul 2, 2005
    Messages:
    619
    Likes Received:
    0
    Trophy Points:
    16
    How do you down grade?
     
  5. dave9000

    dave9000 Well-Known Member

    Joined:
    Apr 7, 2003
    Messages:
    891
    Likes Received:
    1
    Trophy Points:
    16
    Location:
    arkansas
    cPanel Access Level:
    Root Administrator
  6. BianchiDude

    BianchiDude Well-Known Member
    PartnerNOC

    Joined:
    Jul 2, 2005
    Messages:
    619
    Likes Received:
    0
    Trophy Points:
    16
    Thanks dude!
     
  7. dave9000

    dave9000 Well-Known Member

    Joined:
    Apr 7, 2003
    Messages:
    891
    Likes Received:
    1
    Trophy Points:
    16
    Location:
    arkansas
    cPanel Access Level:
    Root Administrator
    your welcome
     
  8. cguimont

    cguimont Well-Known Member

    Joined:
    Jul 13, 2004
    Messages:
    100
    Likes Received:
    0
    Trophy Points:
    16
    Thanks for that hint. It worked
     
  9. binary1

    binary1 Registered

    Joined:
    Jun 26, 2005
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Ah!

    Finaly I can get back to sleep. many, many, many, many, thanx. phew!

    Word.
     
  10. rpmws

    rpmws Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    1,824
    Likes Received:
    5
    Trophy Points:
    38
    Location:
    back woods of NC, USA
    we had a similiar issue going to 5.1.2 and and mysql 5.18. Basically httpd wouldn't start. It was complaining about mysql libs. I ran buildapache again and same issue. Nick helped me with this and we wound up installing mysql 5.21 from a generic RPM and apache would then start. The initial error I was getting when restarting httpd was:

    Cannot load /usr/local/apache/libexec/libphp5.so into server:
    /usr/local/apache/libexec/libphp5.so: symbol zlibVersion, version
    libmysqlclient_15 not defined in file libmysqlclient.so.15 with link time
    reference

    Mostly this was due to buildapache failing to continue to compile past the apache part and it would die before php started to compile.

    At some point soon if not already new sPanel builds will be out for mysql's > 5.18 >not sure if this error is related in the 4.X tree. What I think is buildapache was changed slightly on May12th and my prior builds would run. After using the May12th version it would have the above problem. Something in buildapache makes the problem in mysql show itself. We found the bugs listed at mysql.com that referenced my issue and it was fixed in the later versions.
     
  11. neojones

    neojones Active Member

    Joined:
    Dec 14, 2004
    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    6
    Hey Dave,

    Thanks for the tip. Was really helpful. Cheers
     
  12. JamieW

    JamieW Member

    Joined:
    May 15, 2006
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
  13. jackie46

    jackie46 BANNED

    Joined:
    Jul 25, 2005
    Messages:
    537
    Likes Received:
    0
    Trophy Points:
    0
    Hmm, im running 4.1.18 on RHEL3 with Php; v4.2.2 with no issues whatsoever.
     
  14. MeGaMASTER

    MeGaMASTER Well-Known Member

    Joined:
    May 24, 2003
    Messages:
    49
    Likes Received:
    0
    Trophy Points:
    6
    This appear to be a bug with MySQL 4.1.18. Installing the latest MySQL-devel build (4.1.19) fix the problem. cPanel should update their MySQL version more often.
     
Loading...

Share This Page