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 Issue

Discussion in 'General Discussion' started by hyphyent, Feb 8, 2006.

  1. hyphyent

    hyphyent Member

    Joined:
    Jun 11, 2005
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    ive searched the forum but could not find a similar issue.. and if there is already i may have overlooked it so please forgive me.

    the problem im having is i did a fresh Cpanel Install on a Redhat Linux ES V3 Update 2, install went fine and everything runs smooth. only problem i have is with mysql, mysql seems to be running fine however when i goto a sites cpanel and try to add users or a database i get the message that either the user or database was added.. but when i goto WHM and check with phpadmin the database nor the user was added... i tried adding it via the phpadmin but when trying to install scripts such as the PHPBB and other scripts that rely on mysql i always get an install error..

    and help in this matter would be a great help

    i would liek to add im using MySQL-4.0.25
     
    #1 hyphyent, Feb 8, 2006
    Last edited: Feb 8, 2006
  2. rustelekom

    rustelekom Well-Known Member
    PartnerNOC

    Joined:
    Nov 13, 2003
    Messages:
    290
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    moscow
    check what you see in /usr/local/cpanel/logs/error_log file. look as a cpanel perl modules problem or DBI::MySQL not installed or installed incorrect.
     
  3. hyphyent

    hyphyent Member

    Joined:
    Jun 11, 2005
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Internal Error: "" Normal Connection Timeout (Probably closed browser on a HTTP/1.1 session) at cpsrvd.pl line 1470.
    /usr/bin/perl: relocation error: /usr/lib/perl5/site_perl/5.8.7/x86_64-linux/auto/DBD/mysql/mysql.so: undefined symbol: mysql_init
    /usr/bin/perl: relocation error: /usr/lib/perl5/site_perl/5.8.7/x86_64-linux/auto/DBD/mysql/mysql.so: undefined symbol: mysql_init
    /usr/bin/perl: relocation error: /usr/lib/perl5/site_perl/5.8.7/x86_64-linux/auto/DBD/mysql/mysql.so: undefined symbol: mysql_init
    /usr/bin/perl: relocation error: /usr/lib/perl5/site_perl/5.8.7/x86_64-linux/auto/DBD/mysql/mysql.so: undefined symbol: mysql_init
    psql: FATAL: No pg_hba.conf entry for host localhost, user postgres, database template1

    psql: FATAL: No pg_hba.conf entry for host localhost, user postgres, database template1

    psql: FATAL: No pg_hba.conf entry for host localhost, user postgres, database template1

    psql: FATAL: No pg_hba.conf entry for host localhost, user postgres, database template1


    is what i found pertainign to mysql and posgres
     
  4. rustelekom

    rustelekom Well-Known Member
    PartnerNOC

    Joined:
    Nov 13, 2003
    Messages:
    290
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    moscow
    yes, it might give you problem. you should try update cpanel by /scripts/upcp --force.
     
  5. hyphyent

    hyphyent Member

    Joined:
    Jun 11, 2005
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    tried that same problem.. hmmm..
     
  6. hyphyent

    hyphyent Member

    Joined:
    Jun 11, 2005
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    tried to force cpanel update.. it upadated yet im still getting

    /usr/bin/perl: relocation error: /usr/lib/perl5/site_perl/5.8.7/x86_64-linux/auto/DBD/mysql/mysql.so: undefined symbol: mysql_init

    this is french to me.. can anyone translate
     
  7. hyphyent

    hyphyent Member

    Joined:
    Jun 11, 2005
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    ok ive tried

    /scripts/fixmysql
    /scripts/mysqlup --force
    /scripts/upcp --force
    /scripts/perlinstaller --force DBD::mysql
    /scripts/perlinstaller --force DBI::MySQL

    =same thing.. when i try to add users or databases they do not show up in the drop box... and when i restart mysql via WHM i get

    /usr/bin/perl: relocation error: /usr/lib/perl5/site_perl/5.8.7/x86_64-linux/auto/DBD/mysql/mysql.so: undefined symbol: mysql_init

    at the bottom of the table and t says it was restarted ok
     
  8. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,475
    Likes Received:
    20
    Trophy Points:
    38
    Location:
    Go on, have a guess
    This is the main problem:
    The 64bit OS's at this time need a lot of work getting them to work and they're really not (IMX) ready to be used in production servers because of issues with libraries. The problem you're seeing is that DBD::mysql perl module isn't building properly because of library problems with mysql.so. Those need to be resolved and then DBD perl module installed:

    /scripts/perlinstaller --force DBD::mysql

    Watch for errors and fix the original problem and try again.
     
  9. hyphyent

    hyphyent Member

    Joined:
    Jun 11, 2005
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    tried that.. read the the install output i didn;t notice any errors...

    here is the log of that...

    http://www.hyphyentertainment.com/mysql.txt

    :(
     
  10. rustelekom

    rustelekom Well-Known Member
    PartnerNOC

    Joined:
    Nov 13, 2003
    Messages:
    290
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    moscow
    can you post your server config? i am little misunderstand why you have x86_64-linux installed
     
  11. hyphyent

    hyphyent Member

    Joined:
    Jun 11, 2005
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    I have a dell poweredge 800 w/dual core


    Processor InformationProcessor #1 Vendor: GenuineIntel
    Processor #1 Name: Intel(R) Pentium(R) 4 CPU 3.20GHz
    Processor #1 speed: 3200.252 MHz
    Processor #1 cache size: 1024 KB

    Processor #2 Vendor: GenuineIntel
    Processor #2 Name: Intel(R) Pentium(R) 4 CPU 3.20GHz
    Processor #2 speed: 3200.252 MHz
    Processor #2 cache size: 1024 KB



    Memory InformationMemory: 998844k/1040128k available (1822k kernel code, 0k reserved, 1883k data, 228k init)



    System InformationLinux wsip-24-234-166-166.lv.lv.cox.net 2.4.21-37.0.1.EL #1 SMP Wed Jan 11 18:36:58 EST 2006 x86_64 x86_64 x86_64 GNU/Linux



    Physcial Diskshda: SAMSUNG CD-ROM SC-148A, ATAPI CD/DVD-ROM drive



    Current Memory Usage total used free shared buffers cached
    Mem: 1001248 956872 44376 0 174220 209996
    -/+ buffers/cache: 572656 428592
    Swap: 2024180 0 2024180
    Total: 3025428 956872 2068556



    Current Disk UsageFilesystem Size Used Avail Use% Mounted on
    /dev/sda2 228G 6.9G 209G 4% /
    /dev/sda1 99M 23M 71M 25% /boot
    none 489M 0 489M 0% /dev/shm
    /usr/tmpDSK 485M 8.1M 452M 2% /tmp
    /tmp 485M 8.1M 452M 2% /var/tmp
     
  12. rustelekom

    rustelekom Well-Known Member
    PartnerNOC

    Joined:
    Nov 13, 2003
    Messages:
    290
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    moscow
    thank for your updating, i think this is definitely 64 bit library problem and it may be hardly corrected. As last chance before reinstalling O/S (if you need get cpanel working) try install newest version of perl. may be this can correct issue.
     
  13. Curious Too

    Curious Too Well-Known Member

    Joined:
    Aug 31, 2001
    Messages:
    427
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator

    Turn off SELinux, reboot your server, then do a force install of mysql.

    To turn off selinux, in /etc/selinux/conf make sure selinux is disabled:

    SELINUX=disabled
     
  14. hyphyent

    hyphyent Member

    Joined:
    Jun 11, 2005
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    ive reformatted once before figured i borked the instal so re-did it same issue.. prior to cpanel install i updated everything via RHN which took like 2 hours itself.. dont feel liek going thru that process again

    no SElinux on the box checked
     
  15. rustelekom

    rustelekom Well-Known Member
    PartnerNOC

    Joined:
    Nov 13, 2003
    Messages:
    290
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    moscow
    are you have tried install latest version of perl? if problem created by perl installing newest version may be help you. hen reinstall dnd and may dbi perl modules. also, may be would be better if you install it's manually (perl Makefile.PL, make, make install)

    very similar problem just found by google:

    http://www.issociate.de/board/post/13744/Problem_using_placeholders.html
     
  16. hyphyent

    hyphyent Member

    Joined:
    Jun 11, 2005
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    i gave up, reformated my box with FreeBSD 5.4, only probblem i had was with bind, but all it needs it to be reconfigured.. everything else works perfectly fine
     
  17. liquidwebjared

    liquidwebjared Registered
    PartnerNOC

    Joined:
    Oct 12, 2005
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    The problem isn't with the 64 bit libraries, but where they are linking to by default. Normaly if you do a

    Code:
    mysql_config --libs
    It will output:

    Code:
    -L/usr/lib -lmysqlclient -lz -lcrypt -lnsl -lm
    Which is wrong, because mysql on a 64 bit system should have it's libraries linking to /usr/lib64/ not /usr/lib

    Since a cpan install (or a /scripts/realperlinstaller) links against what is displayed from output of mysql_config this will never work correctly in it's current state.

    To fix the problem I went and downloaded the most recent source, untarred it, set my own lib flags, built it and then rebuilt mysql.

    Here's a copy past for anyone not wanting to look all this upp on their own.

    Code:
    cd /usr/src
    wget http://search.cpan.org/CPAN/authors/id/C/CA/CAPTTOFU/DBD-mysql-3.0002.tar.gz
    tar xzvf DBD-mysql-3.0002.tar.gz
    cd DBD-mysql-3.0002
    perl Makefile.PL --libs="-L/usr/lib64/ -lmysqlclient"
    make
    make install
    /scripts/mysqlup --force
    You can now add databases on your 64 bit system using CPanel.

    Hope this helps.
     
  18. hyphyent

    hyphyent Member

    Joined:
    Jun 11, 2005
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    im going to try that on my other box right now
     
  19. hyphyent

    hyphyent Member

    Joined:
    Jun 11, 2005
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    dude i love you.. it worked THANKS
     
  20. liquidwebjared

    liquidwebjared Registered
    PartnerNOC

    Joined:
    Oct 12, 2005
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Glad I could help. :)
     
Loading...

Share This Page