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 MySQLi

Discussion in 'General Discussion' started by Olate, Sep 2, 2004.

Thread Status:
Not open for further replies.
  1. Olate

    Olate Active Member

    Joined:
    Aug 1, 2003
    Messages:
    42
    Likes Received:
    0
    Trophy Points:
    6
    I'm trying to configure MySQL and MySQLi with PHP5. I can configure either one on their own, but together, it doesn't work. I'm compiling using:

    '--with-mysqli=/usr/bin/mysql_config'

    And hence

    '--with-mysql=/usr/bin'

    But I always get this error:

    configure: error: wrong mysql library version or lib not found. Check config.log for more information.

    Anyone had this problem?
     
  2. Olate

    Olate Active Member

    Joined:
    Aug 1, 2003
    Messages:
    42
    Likes Received:
    0
    Trophy Points:
    6
    This is due to the MySQLi MySQL version 4.1 minimum requirement. I'll have to wait until cPanel add support for 4.1
     
  3. irchs

    irchs Well-Known Member

    Joined:
    Jun 3, 2004
    Messages:
    76
    Likes Received:
    0
    Trophy Points:
    6
    MySQL is on 4.1 now, where is the mysqli choice?! :)

    Jan
     
  4. PanelGuy

    PanelGuy Well-Known Member

    Joined:
    Oct 13, 2004
    Messages:
    106
    Likes Received:
    0
    Trophy Points:
    16
    MySQLi

    I too am having problems figuring out how to add mySQLi support. The lack of support for mySQLi causes older scripts to fail because of the 41bit hash that is now used in place of the 16 bit hash. I really didn't want to downgrade MySQL 4.1 to use the 16 bit hash.

    I've seen several posts around the web about how to add support for bith 41 but and 16 bit hash methods using the old librarya nd mySQLi, but I'm not sure how to change the buildapache script to allow this.

    Does anyone know the best method of adding mySQLi support to PHP 4.3.10 in WHM?
     
    #4 PanelGuy, Mar 19, 2005
    Last edited: Mar 19, 2005
  5. irchs

    irchs Well-Known Member

    Joined:
    Jun 3, 2004
    Messages:
    76
    Likes Received:
    0
    Trophy Points:
    6
    The only way so far is to do it manually.

    Thanks

    Jan
     
  6. irchs

    irchs Well-Known Member

    Joined:
    Jun 3, 2004
    Messages:
    76
    Likes Received:
    0
    Trophy Points:
    6
  7. PanelGuy

    PanelGuy Well-Known Member

    Joined:
    Oct 13, 2004
    Messages:
    106
    Likes Received:
    0
    Trophy Points:
    16
    OK, how do you do that? I can't figure out how to get around it changing back upon build.

    I think I am changing the wrong files since the buildapache script just removes all the ones I am changing.

    I voted for the bug and hope others do to, it's an important change!
     
  8. irchs

    irchs Well-Known Member

    Joined:
    Jun 3, 2004
    Messages:
    76
    Likes Received:
    0
    Trophy Points:
    6
    I recommend doing the buildapache, and then building php again with the same configure only with the extra mysqli stuff, and installing that :)

    Thanks

    Jan
     
  9. b0072k1

    b0072k1 Well-Known Member

    Joined:
    Dec 30, 2004
    Messages:
    133
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Glasgow
    i dont know how to install this nay ideas?
     
  10. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,475
    Likes Received:
    20
    Trophy Points:
    38
    Location:
    Go on, have a guess
    Please don't cross-post or dig up old threads.
     
Loading...
Thread Status:
Not open for further replies.

Share This Page