MySql error on mandriva 2006

Discussion in 'Installation/Configuration' started by sshlord, Feb 27, 2007.

  1. sshlord

    sshlord New Member

    Wen i try to install ISPConfig i get this...

    Code:
    Mandriva 2006.0
    Neuinstallation eines ISPConfig-Systems. / Installation of a new ISPConfig system. / Installation d'ISPConfig sur un nouveau système.
    Wählen Sie Ihre Sprache (deutsch/englisch/spanisch/französisch/italienisch/niederländisch/polnisch/schwedisch): / Please choose your language (German/English/Spanish/French/Italian/Dutch/Polish/Swedish):  / Merci de choisir votre langue (Allemand/Anglais/Espagnol/Français/Italien/Néerlandais/Polonais/Suédois):
    1) de
    2) en
    3) es
    4) fr
    5) it
    6) nl
    7) pl
    8) se
    Ihre Wahl: / Your Choice: / Votre Choix:2
    
    With the system installation, some system files are replaced where adjustments were made. This can lead to loss of entries in httpd.conf, named.conf as well as in the Sendmail configuration.
    
    Do you want to continue with the installation? [y/n]y
    
    Please read through the licence carefully:
    
    Copyright (c) 2005, projektfarm GmbH, Till Brehm, Falko Timme
    All rights reserved.
    
    Redistribution and use in source and binary forms, with or without modification,
    are permitted provided that the following conditions are met:
    
        * Redistributions of source code must retain the above copyright notice,
          this list of conditions and the following disclaimer.
        * Redistributions in binary form must reproduce the above copyright notice,
          this list of conditions and the following disclaimer in the documentation
          and/or other materials provided with the distribution.
        * Neither the name of ISPConfig nor the names of its contributors
          may be used to endorse or promote products derived from this software without
          specific prior written permission.
    
    THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
    ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
    WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.
    IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT,
    INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,
    BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
    DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY
    OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
    NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE,
    EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
    
    Do you accept the licence? [y/n]y
    
    Please select the installation mode. In expert mode you have to answer some additional questions. In standard mode standard values are assumed for these questions.
    1) standard
    2) expert
    Your Choice: 1
    
    ########## MAIL SERVER ##########
    
    Checking for MTA...
    which: no postfix in (/sbin:/usr/sbin:/usr/local/sbin:/root/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/usr/local/libexec)
    /usr/sbin/sendmail
    OK
    
    ISPConfig found the following MTA:
    sendmail
    Is this correct? [y/n]y
    
    
    ########## FTP SERVER ##########
    
    Checking if an FTP server is installed...
    /usr/sbin/proftpd
    OK
    
    ISPConfig found the following FTP server:
    proftpd
    Is this correct? [y/n]y
    
    
    ########## PROCMAIL ##########
    
    Checking for package procmail...
    /usr/bin/procmail
    OK
    
    ########## QUOTA ##########
    
    Checking for package quota...
    /usr/bin/quota
    OK
    
    ########## MYSQL SERVER ##########
    
    Checking for package MySQL...
    /usr/bin/mysql
    OK
    
    ########## OPENSSL ##########
    
    Checking for package openssl...
    /usr/bin/openssl
    OK
    
    ########## DNS SERVER ##########
    
    Checking for package bind...
    /usr/sbin/named
    OK
    
    ########## IPTABLES/IPCHAINS/IPFW ##########
    
    Checking for program iptables/ipchains/ipfw...
    /sbin/iptables
    OK
    
    ########## WEB SERVER ##########
    
    Checking for program httpd...
    /usr/sbin/httpd
    OK
    Checking the syntax of the httpd.conf...
    Syntax OK
    The syntax is ok!
    
    ########## gcc ##########
    
    /usr/bin/gcc
    OK
    
    ########## make ##########
    
    /usr/bin/make
    OK
    
    ########## lex ##########
    
    /usr/bin/lex
    OK
    
    ########## g++ ##########
    
    /usr/bin/g++
    OK
    
    ########## INSTALLATION ##########
    
    ERROR: MySQL is not running! Please start your MySQL database and run the ISPConfig setup again.
    
    
    my mysql server is running before i run ./setup
    after this error if i check if mysql is running and i see this :
    Code:
    [[email protected] install_ispconfig]# /etc/init.d/mysqld status
    mysqld (pid 26306) is running...
    
    what is wrong with my server ?

    thank you
     
  2. sshlord

    sshlord New Member

    and one more thing....

    before i run ./setup , mysql run with one pid
    after i run ./setup , mysql run with another pid

    i think he stop and start my mysql.....
     
  3. falko

    falko Super Moderator ISPConfig Developer

  4. sshlord

    sshlord New Member

    Code:
    
    Proto Recv-Q Send-Q Local Address               Foreign Address             State       PID/Program name
    tcp        0      0 *:32769                     *:*                         LISTEN      -
    tcp        0      0 *:nfs                       *:*                         LISTEN      -
    tcp        0      0 *:smux                      *:*                         LISTEN      2637/snmpd
    tcp        0      0 *:netbios-ssn               *:*                         LISTEN      3023/smbd
    tcp        0      0 *:pop3                      *:*                         LISTEN      2752/xinetd
    tcp        0      0 *:imap                      *:*                         LISTEN      2752/xinetd
    tcp        0      0 *:sunrpc                    *:*                         LISTEN      2227/portmap
    tcp        0      0 *:http                      *:*                         LISTEN      11772/httpd
    tcp        0      0 *:10000                     *:*                         LISTEN      5900/perl
    tcp        0      0 *:788                       *:*                         LISTEN      2302/rpc.statd
    tcp        0      0 *:ftp                       *:*                         LISTEN      12089/proftpd: (acc
    tcp        0      0 localhost:5335              *:*                         LISTEN      2578/mDNSResponder
    tcp        0      0 *:890                       *:*                         LISTEN      2831/rpc.mountd
    tcp        0      0 *:411                       *:*                         LISTEN      15693/verlihub
    tcp        0      0 *:https                     *:*                         LISTEN      11772/httpd
    tcp        0      0 *:7741                      *:*                         LISTEN      3229/lisa
    tcp        0      0 *:microsoft-ds              *:*                         LISTEN      3023/smbd
    tcp        0      0 *:ssh                       *:*                         LISTEN      2693/sshd
    
    
    

    this is my netstat -tap


    i tried to configure my mysql from that faq but my my.cnf has no setting skip-networking :confused:
     
  5. falko

    falko Super Moderator ISPConfig Developer

    Ok, that's the problem - networking isn't enabled in MySQL.
    What's in your my.cnf?
     
  6. sshlord

    sshlord New Member

    [​IMG]


    that`s my.cnf
     
  7. jnsc

    jnsc rotaredoM Moderator

    and in
    Code:
    /etc/sysconfig/mysqld
    According to this it's located there for mandriva 2006
     
  8. sshlord

    sshlord New Member

    ok i removed --skip-networking from /etc/sysconfig/mysqld and i restarted my mysql deamon....

    when i run netstat -tap , my mysql is running
    Code:
    Active Internet connections (servers and established)
    Proto Recv-Q Send-Q Local Address               Foreign Address             State       PID/Program name
    tcp        0      0 *:32769                     *:*                         LISTEN      -
    tcp        0      0 *:nfs                       *:*                         LISTEN      -
    tcp        0      0 *:smux                      *:*                         LISTEN      2637/snmpd
    tcp        0      0 *:mysql                     *:*                         LISTEN      2348/mysqld
    tcp        0      0 *:netbios-ssn               *:*                         LISTEN      3023/smbd
    tcp        0      0 *:pop3                      *:*                         LISTEN      2752/xinetd
    tcp        0      0 *:imap                      *:*                         LISTEN      2752/xinetd
    tcp        0      0 *:sunrpc                    *:*                         LISTEN      2227/portmap
    tcp        0      0 *:http                      *:*                         LISTEN      873/httpd
    tcp        0      0 *:10000                     *:*                         LISTEN      5900/perl
    tcp        0      0 *:788                       *:*                         LISTEN      2302/rpc.statd
    tcp        0      0 *:ftp                       *:*                         LISTEN      12089/proftpd: (acc
    tcp        0      0 localhost:5335              *:*                         LISTEN      2578/mDNSResponder
    tcp        0      0 *:890                       *:*                         LISTEN      2831/rpc.mountd
    tcp        0      0 *:https                     *:*                         LISTEN      873/httpd
    tcp        0      0 *:411                       *:*                         LISTEN      15693/verlihub
    tcp        0      0 *:7741                      *:*                         LISTEN      3229/lisa
    tcp        0      0 *:microsoft-ds              *:*                         LISTEN      3023/smbd
    tcp        0      0 *:ssh                       *:*                         LISTEN      2693/sshd
    
    
    but when i run ./setup again i have the same error


    Code:
    ERROR: MySQL is not running! Please start your MySQL database and run the ISPConfig setup again.
    
    after the error i check mysq if is running...

    Code:
    [[email protected] install_ispconfig]# /etc/init.d/mysqld status
    mysqld dead but subsys locked
    
    
     
  9. sshlord

    sshlord New Member

    ok

    i removed port option from my.cfg.... restart mysql and run ./setup...

    works fine

    now i have another problem.. :D

    after install my database is empty...
     
  10. martinfst

    martinfst ISPConfig Developer ISPConfig Developer

    Sure, your database was not up during the 1st attempt to install and the setup aborted. Re-run the install.
     
  11. falko

    falko Super Moderator ISPConfig Developer

    Before you re-run the installation, remove the old installation:
    Code:
    rm -fr /root/ispconfig
    rm -fr /home/admispconfig
    and delete the empty database.
     
  12. xelf

    xelf New Member

    Where is db and how to???

    Where is the DB to delete??
    And what is command???

    thanks!!!
     
  13. till

    till Super Moderator Staff Member ISPConfig Developer

    The database is in /ver/lib/mysql/

    you can just delete the subdirectory that has the same name then the database.

    This is the brute force method, but it works ;) Another method is to login with the mysql command to the mysql server and use sql commands to delete the databse.
     

Share This Page