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.

Remote mysql server problem

Discussion in 'General Discussion' started by Sh3nKo, Jun 19, 2008.

  1. Sh3nKo

    Sh3nKo Member

    Joined:
    Sep 25, 2007
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    Hello,

    Sorry for my English, i'm French.

    I'm trying to install a remote mysql server but I have multiple errors :

    Code:
    Using Remote mySQL Server
    Copying MySQL Script.....0%.. ..100%.. ...Done
    Running MySQL Script...
    
        Using 91.121.xx.xx as the access ip
        Sync Source: http://httpupdate.cpanel.net/RELEASE/scripts
        Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/scripts/.cpanelsync.lock (0)....@69.72.164.155......connected......receiving......Done
        Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/scripts/.cpanelsync.bz2 (0)....@69.72.164.155......connected......receiving...79%...100%......Done
        Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/scripts/mysqlup.bz2 (0)....@69.72.164.155......connected......receiving...100%......Done
        Got file ./mysqlup ok (md5 matches)
        Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/scripts/pkgacct.static.bz2 (0)....@69.72.164.155......connected......receiving...14%...28%...42%...56%...70%...84%...99%...100%......Done
        Got file ./pkgacct.static ok (md5 matches)
        Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/scripts/updatenow.static.bz2 (0)....@69.72.164.155......connected......receiving...56%...100%......Done
        Got file ./updatenow.static ok (md5 matches)
        Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/scripts/cpanelsync.static.bz2 (0)....@69.72.164.155......connected......receiving...40%...81%...100%......Done
        Got file ./cpanelsync.static ok (md5 matches)
        Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/scripts/updateuserdomains.static.bz2 (0)....@69.72.164.155......connected......receiving...15%...30%...45%...60%...75%...90%...100%......Done
        Got file ./updateuserdomains.static ok (md5 matches)
        Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/scripts/initinstall.static.bz2 (0)....@69.72.164.155......connected......receiving...51%...100%......Done
        Got file ./initinstall.static ok (md5 matches)
        Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/scripts/cPScript/Version.pm.bz2 (0)....@69.72.164.155......connected......receiving...100%......Done
        Got file ./cPScript/Version.pm ok (md5 matches)
        Sync Source: http://httpupdate.cpanel.net/RELEASE/scripts
        Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/scripts/.cpanelsync.lock (0)....@69.72.164.155......connected......receiving......Done
        Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/scripts/.cpanelsync.bz2 (0)....@69.72.164.155......connected......receiving...79%...100%......Done
        Can't locate Cpanel/SafeFile.pm in @INC (@INC contains: /scripts /etc/perl /usr/local/lib/perl/5.8.8 /usr/local/share/perl/5.8.8 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.8 /usr/share/perl/5.8 /usr/local/lib/site_perl .) at /scripts/RcsRecord.pm line 22.
        BEGIN failed--compilation aborted at /scripts/RcsRecord.pm line 22.
        Compilation failed in require at /scripts/cPScript/StringFunc.pm line 17.
        BEGIN failed--compilation aborted at /scripts/cPScript/StringFunc.pm line 17.
        Compilation failed in require at /scripts/cPScript/cPanelFunctions.pm line 16.
        BEGIN failed--compilation aborted at /scripts/cPScript/cPanelFunctions.pm line 16.
        Compilation failed in require at /scripts/mysqlpasswd line 5.
        BEGIN failed--compilation aborted at /scripts/mysqlpasswd line 5.
        Waiting for mysql to restart..............finished.
    
        Can't locate Cpanel/SafeFile.pm in @INC (@INC contains: /scripts /etc/perl /usr/local/lib/perl/5.8.8 /usr/local/share/perl/5.8.8 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.8 /usr/share/perl/5.8 /usr/local/lib/site_perl .) at /scripts/RcsRecord.pm line 22.
        BEGIN failed--compilation aborted at /scripts/RcsRecord.pm line 22.
        Compilation failed in require at /scripts/cPScript/StringFunc.pm line 17.
        BEGIN failed--compilation aborted at /scripts/cPScript/StringFunc.pm line 17.
        Compilation failed in require at /scripts/cPScript/cPanelFunctions.pm line 16.
        BEGIN failed--compilation aborted at /scripts/cPScript/cPanelFunctions.pm line 16.
        Compilation failed in require at /scripts/restartsrv_mysql line 13.
        BEGIN failed--compilation aborted at /scripts/restartsrv_mysql line 13.
    
        Can't locate Cpanel/SafeFile.pm in @INC (@INC contains: /scripts /etc/perl /usr/local/lib/perl/5.8.8 /usr/local/share/perl/5.8.8 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.8 /usr/share/perl/5.8 /usr/local/lib/site_perl .) at /scripts/RcsRecord.pm line 22.
        BEGIN failed--compilation aborted at /scripts/RcsRecord.pm line 22.
        Compilation failed in require at /scripts/cPScript/StringFunc.pm line 17.
        BEGIN failed--compilation aborted at /scripts/cPScript/StringFunc.pm line 17.
        Compilation failed in require at /scripts/cPScript/cPanelFunctions.pm line 16.
        BEGIN failed--compilation aborted at /scripts/cPScript/cPanelFunctions.pm line 16.
        Compilation failed in require at /scripts/restartsrv_mysql line 13.
        BEGIN failed--compilation aborted at /scripts/restartsrv_mysql line 13.
        mysql started ok
    
    
    Done
    Mysqld not running 
    
    213.186.xx.xx is now configured for use as the remote mySQL server.
    I think the problem is perl but I don't know exactly what. Can you help me ?

    Thanks!
     
    #1 Sh3nKo, Jun 19, 2008
    Last edited: Jun 19, 2008
  2. Sh3nKo

    Sh3nKo Member

    Joined:
    Sep 25, 2007
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    Up, no idea ? Can't setup the remote server :(
     
  3. markusikkk

    markusikkk Member

    Joined:
    Sep 26, 2006
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Poland
    Hi,

    I have that same problem. :/ i don't have any idea
     
  4. markusikkk

    markusikkk Member

    Joined:
    Sep 26, 2006
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Poland
    Ok,

    I have idea :)

    you must create symbolic link in remote server

    cd /scripts
    ln -s ./ Cpanel


    bye
     
  5. Sh3nKo

    Sh3nKo Member

    Joined:
    Sep 25, 2007
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    Really, thank you!

    Now seems to be perfect, or almost :

    Code:
    Using Remote mySQL Server
    Copying MySQL Script.....0%.. ..100%.. ...Done
    Running MySQL Script...
    
        Using 91.121.xx.xx as the access ip
        Sync Source: http://httpupdate.cpanel.net/RELEASE/scripts
        Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/scripts/.cpanelsync.lock (0)....@69.72.164.155......connected......receiving......Done
        Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/scripts/.cpanelsync.bz2 (0)....@69.72.164.155......connected......receiving...79%...100%......Done
        Sync Source: http://httpupdate.cpanel.net/RELEASE/scripts
        Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/scripts/.cpanelsync.lock (0)....@69.72.164.155......connected......receiving......Done
        Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/scripts/.cpanelsync.bz2 (0)....@69.72.164.155......connected......receiving...79%...100%......Done
        Waiting for mysql to restart..............finished.
    
        root      5991  0.0  0.0   2664  1320 ?        S    13:39   0:00 /bin/sh /usr/bin/mysqld_safe
        root      6029  0.0  0.0   1564   504 ?        S    13:39   0:00 logger -p daemon.err -t mysqld_safe -i -t mysqld
        mysql     6028  0.8  0.7 126360 16504 ?        Sl   13:39   0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock
    
        mysql started ok
    
    
    Done
    Mysqld not running
    213.186.xx.xx is now configured for use as the remote mySQL server.
    Why "Mysqld not running" ?

    Again, thank you markusikkk !
     
  6. markusikkk

    markusikkk Member

    Joined:
    Sep 26, 2006
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Poland
    what do you have in logs ?
     
  7. Sh3nKo

    Sh3nKo Member

    Joined:
    Sep 25, 2007
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    Mysql can't start, it's the problem. When I do /etc/init.d/mysql start I have :

    Code:
    Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
    And "mysql"

    Code:
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
    I must find why mysql doesn't start before cry after whm :D

    Sorry for my english!
     
  8. markusikkk

    markusikkk Member

    Joined:
    Sep 26, 2006
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Poland
  9. Sh3nKo

    Sh3nKo Member

    Joined:
    Sep 25, 2007
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    Hi,

    Thank you, my precedent problem is solved.

    I have an other problem when I setup my remote server :

    Code:
    Remote MySQL Host Setup
    Using Remote mySQL Server
    Copying MySQL Script.....0%.. ..100%.. ...Done
    Running MySQL Script...
    
        Using 91.121.xx.xx as the access ip
        Sync Source: http://httpupdate.cpanel.net/RELEASE/scripts
        Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/scripts/.cpanelsync.lock (0)....@69.72.164.155......connected......receiving......Done
        Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/scripts/.cpanelsync.bz2 (0)....@69.72.164.155......connected......receiving...79%...100%......Done
        Sync Source: http://httpupdate.cpanel.net/RELEASE/scripts
        Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/scripts/.cpanelsync.lock (0)....@69.72.164.155......connected......receiving......Done
        Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/scripts/.cpanelsync.bz2 (0)....@69.72.164.155......connected......receiving...79%...100%......Done
        ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
        ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
        Waiting for mysql to restart..............finished.
    
        root      5461  0.0  0.0   2664  1320 ?        S    15:47   0:00 /bin/sh /usr/bin/mysqld_safe
        root      5499  0.0  0.0   1560   504 ?        S    15:47   0:00 logger -p daemon.err -t mysqld_safe -i -t mysqld
        mysql     5498  1.0  0.8 127468 17588 ?        Sl   15:47   0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock
    
        /usr/bin/mysqladmin: connect to server at 'localhost' failed
        error: 'Access denied for user 'root'@'localhost' (using password: YES)'
        mysql has failed, please contact the sysadmin (result was "mysql has failed").
    
    
    Done
    Mysqld not running
    213.186.xx.xx is now configured for use as the remote mySQL server.
    What can I do ?

    I can connect (mysql -u root -h 213.186.xx.xx -p) from the "local" server, the web server with ssh access. Why these errors ?

    Thank you and sorry for my English !
     
  10. Sh3nKo

    Sh3nKo Member

    Joined:
    Sep 25, 2007
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    UP please.

    How can I solve please :
    Code:
    /usr/bin/mysqladmin: connect to server at 'localhost' failed
        error: 'Access denied for user 'root'@'localhost' (using password: YES)'
    Thank you.
     
  11. jayh38

    jayh38 Well-Known Member

    Joined:
    Mar 3, 2006
    Messages:
    1,215
    Likes Received:
    0
    Trophy Points:
    36
    Did you set a mysql root password? If not, you may need to do so.
     
  12. Sh3nKo

    Sh3nKo Member

    Joined:
    Sep 25, 2007
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    Yes, root user has a password.


    Code:
    root:~# mysqladmin restart
    mysqladmin: connect to server at 'localhost' failed
    error: 'Access denied for user 'root'@'localhost' (using password: YES)'
     
  13. WebXSolution

    WebXSolution Member

    Joined:
    Sep 5, 2006
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    the operating systems seem to store the default username and password in /root/.my.cnf

    Changing the password here solved the problem you have for me.
     
Loading...

Share This Page