Error in Mysql

Discussion in 'Installation/Configuration' started by pontifex, Aug 13, 2005.

  1. pontifex

    pontifex New Member

    Hi everyone,
    i tried to install ISPConfig. Durring the installation process an error occured and after rebooting the server ISPCOnfig did not start automatically.

    Therefore i started the server manual:
    Code:
    linux:/etc/init.d # /etc/init.d/ispconfig_server restart
    Shutting down ISPConfig system...
    /root/ispconfig/httpd/bin/apachectl stop: httpd (no pid file) not running
    ISPConfig system stopped!
    Starting ISPConfig system...
    Apache/1.3.33 mod_ssl/2.8.23 (Pass Phrase Dialog)
    Some of your private key files are encrypted for security reasons.
    In order to read them you have to provide us with the pass phrases.
    
    Server 192.168.0.61:81 (RSA)
    Enter pass phrase:
    
    Ok: Pass Phrase Dialog successful.
    /root/ispconfig/httpd/bin/apachectl startssl: httpd started
    
    Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /root/ispconfig/scripts/lib/config.inc.php on line 47
    No results found!ISPConfig system is now up and running!
    linux:/etc/init.d # netstat -tap
    Active Internet connections (servers and established)
    Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name   
    tcp        0      0 *:filenet-tms           *:*                     LISTEN      -                   
    tcp        0      0 *:nfs                   *:*                     LISTEN      -                   
    tcp        0      0 *:sanity                *:*                     LISTEN      5990/rpc.rquotad    
    tcp        0      0 localhost:10024         *:*                     LISTEN      5936/amavisd (maste 
    tcp        0      0 *:5801                  *:*                     LISTEN      5985/xinetd         
    tcp        0      0 localhost:10025         *:*                     LISTEN      5772/master         
    tcp        0      0 *:mysql                 *:*                     LISTEN      5590/mysqld         
    tcp        0      0 *:5901                  *:*                     LISTEN      5985/xinetd         
    tcp        0      0 *:sunrpc                *:*                     LISTEN      5127/portmap        
    tcp        0      0 *:ndmp                  *:*                     LISTEN      5468/perl           
    tcp        0      0 *:hosts2-ns             *:*                     LISTEN      6113/ispconfig_http 
    tcp        0      0 *:883                   *:*                     LISTEN      5797/rpc.mountd     
    tcp        0      0 *:ftp                   *:*                     LISTEN      5677/proftpd: (acce 
    tcp        0      0 localhost:smtp          *:*                     LISTEN      5772/master         
    tcp        0      0 *:imaps                 *:*                     LISTEN      5476/couriertcpd    
    tcp        0      0 *:pop3s                 *:*                     LISTEN      5632/couriertcpd    
    tcp        0      0 localhost:10025         *:*                     LISTEN      5772/master         
    tcp        0      0 *:pop3                  *:*                     LISTEN      5614/couriertcpd    
    tcp        0      0 *:www-http              *:*                     LISTEN      5935/httpd2-prefork 
    tcp        0      0 *:ssh                   *:*                     LISTEN      5800/sshd           
    tcp        0      0 localhost:smtp          *:*                     LISTEN      5772/master 
    Uninstall was not able:

    Code:
    Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /root/ispconfig/scripts/lib/config.inc.php on line 47
    No results found!linux:~/ispconfig # 
    linux:~/ispconfig # 

    what shoud i do now?

    Cheers
    PM
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer


    To uninstall ispconfig:

    Code:
    rm -rf /home/admispconfig
    rm -rf /root/ispconfig
    When you reinstall it, do not encrypt your SSL-Certificates, otherwise ISPConfig cant start automatically when your server boots! Please read the installation manual too.
     
  3. falko

    falko Super Moderator Howtoforge Staff

  4. pasaporte

    pasaporte New Member

    Problem Sorted!

    I had a similar problem and I found out the tables hadn't been loaded on mysql. What I did was manually upload the tables to the server as shown in db_ispconfig.sql and everything works fine with no long waiting removing and restarting and with ssl up and running. I hope this was of help.
     
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    That is not a good idea. If you load the SQL dump manually, all the settings from the installation process where missing and you wont be able to save your server settings.

    I guess you created the mysql database manually before you run the ISPConfig installer? The installation process will fail if the database already exists tht you enter in the ISPonfig installer.
     

Share This Page