Ispconfig Mysql installation problem on Debian wheezy

Discussion in 'General' started by laptop_user, Aug 23, 2014.

  1. laptop_user

    laptop_user Member

    Hello all, this vps has new freshly installed Debian 7 OS. I try to install ispconfig from this thread: http://www.howtoforge.com/perfect-server-debian-wheezy-apache2-bind-dovecot-ispconfig-3-p3 on it but failed. The problem is with mysql.

    Code:
    root@server1:/# apt-get install postfix postfix-mysql postfix-doc mysql-client mysql-server openssl getmail4 rkhunter binutils dovecot-imapd dovecot-pop3d dovecot-mysql dovecot-sieve sudo
    Reading package lists... Done
    Building dependency tree
    Reading state information... Done
    binutils is already the newest version.
    dovecot-imapd is already the newest version.
    dovecot-pop3d is already the newest version.
    dovecot-sieve is already the newest version.
    getmail4 is already the newest version.
    postfix is already the newest version.
    postfix-doc is already the newest version.
    rkhunter is already the newest version.
    sudo is already the newest version.
    openssl is already the newest version.
    The following extra packages will be installed:
      libdbd-mysql-perl libmysqlclient18 mysql-client-5.5 mysql-common mysql-server-5.5
    Suggested packages:
      libterm-readkey-perl tinyca
    The following NEW packages will be installed:
      dovecot-mysql libdbd-mysql-perl libmysqlclient18 mysql-client mysql-client-5.5 mysql-common mysql-server mysql-server-5.5 postfix-mysql
    0 upgraded, 9 newly installed, 0 to remove and 0 not upgraded.
    Need to get 753 kB/5622 kB of archives.
    After this operation, 75.2 MB of additional disk space will be used.
    Do you want to continue [Y/n]? y
    Get:1 http://security.debian.org/ wheezy/updates/main mysql-client all 5.5.38-0+wheezy1 [76.7 kB]
    Get:2 http://ftp.de.debian.org/debian/ wheezy/main dovecot-mysql amd64 1:2.1.7-7+deb7u1 [342 kB]
    Get:3 http://security.debian.org/ wheezy/updates/main mysql-server all 5.5.38-0+wheezy1 [76.9 kB]
    Get:4 http://ftp.de.debian.org/debian/ wheezy/main postfix-mysql amd64 2.9.6-2 [257 kB]
    Fetched 753 kB in 2s (359 kB/s)
    debconf: delaying package configuration, since apt-utils is not installed
    Selecting previously unselected package mysql-common.
    (Reading database ... 16673 files and directories currently installed.)
    Unpacking mysql-common (from .../mysql-common_5.5.38-0+wheezy1_all.deb) ...
    Selecting previously unselected package libmysqlclient18:amd64.
    Unpacking libmysqlclient18:amd64 (from .../libmysqlclient18_5.5.38-0+wheezy1_amd64.deb) ...
    Selecting previously unselected package libdbd-mysql-perl.
    Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.021-1+b1_amd64.deb) ...
    Selecting previously unselected package mysql-client-5.5.
    Unpacking mysql-client-5.5 (from .../mysql-client-5.5_5.5.38-0+wheezy1_amd64.deb) ...
    Setting up mysql-common (5.5.38-0+wheezy1) ...
    Selecting previously unselected package mysql-server-5.5.
    (Reading database ... 16773 files and directories currently installed.)
    Unpacking mysql-server-5.5 (from .../mysql-server-5.5_5.5.38-0+wheezy1_amd64.deb) ...
    debconf: unable to initialize frontend: Dialog
    debconf: (No usable dialog-like program is installed, so the dialog based frontend cannot be used. at /usr/share/perl5/Debconf/FrontEnd/Dialog.pm line 76.)
    debconf: falling back to frontend: Readline
    Configuring mysql-server-5.5
    ----------------------------
    
    While not mandatory, it is highly recommended that you set a password for the MySQL administrative "root" user.
    
    If this field is left blank, the password will not be changed.
    
    New password for the MySQL "root" user:
    
    
    
    Repeat password for the MySQL "root" user:
    
    
    Selecting previously unselected package dovecot-mysql.
    Unpacking dovecot-mysql (from .../dovecot-mysql_1%3a2.1.7-7+deb7u1_amd64.deb) ...
    Selecting previously unselected package mysql-client.
    Unpacking mysql-client (from .../mysql-client_5.5.38-0+wheezy1_all.deb) ...
    Selecting previously unselected package mysql-server.
    Unpacking mysql-server (from .../mysql-server_5.5.38-0+wheezy1_all.deb) ...
    Selecting previously unselected package postfix-mysql.
    Unpacking postfix-mysql (from .../postfix-mysql_2.9.6-2_amd64.deb) ...
    Setting up libmysqlclient18:amd64 (5.5.38-0+wheezy1) ...
    Setting up libdbd-mysql-perl (4.021-1+b1) ...
    Setting up mysql-client-5.5 (5.5.38-0+wheezy1) ...
    Setting up mysql-server-5.5 (5.5.38-0+wheezy1) ...
    debconf: unable to initialize frontend: Dialog
    debconf: (No usable dialog-like program is installed, so the dialog based frontend cannot be used. at /usr/share/perl5/Debconf/FrontEnd/Dialog.pm line 76.)
    debconf: falling back to frontend: Readline
    [ ok ] Stopping MySQL database server: mysqld.
    /var/lib/dpkg/info/mysql-server-5.5.postinst: line 146: logger: command not found
    ATTENTION: An error has occured. More info is in the syslog!
    /var/lib/dpkg/info/mysql-server-5.5.postinst: line 236: logger: command not found
    dpkg: error processing mysql-server-5.5 (--configure):
     subprocess installed post-installation script returned error exit status 127
    Setting up dovecot-mysql (1:2.1.7-7+deb7u1) ...
    Setting up mysql-client (5.5.38-0+wheezy1) ...
    dpkg: dependency problems prevent configuration of mysql-server:
     mysql-server depends on mysql-server-5.5; however:
      Package mysql-server-5.5 is not configured yet.
    
    dpkg: error processing mysql-server (--configure):
     dependency problems - leaving unconfigured
    Setting up postfix-mysql (2.9.6-2) ...
    Errors were encountered while processing:
     mysql-server-5.5
     mysql-server
    E: Sub-process /usr/bin/dpkg returned an error code (1)
    root@server1:/#
    I found another post with same problem as mine. The OS is new Debian OS >> http://www.howtoforge.com/forums/showthread.php?p=316744 but solution #3 does not look possible because I don't have previous my.cnf file.

    Please help me with this. Thanks in advance.
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Hos much ram does this vps has? It can bee that mysql ran out of ram during installation.
     
  3. laptop_user

    laptop_user Member

    3 gb. Previously I install on this same vps with Debian 7 but no problem with mysql. For some reason I got this problem after I reinstall. Maybe updated debian 7 image I think, not the same with previous debian 7.
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    I did not had this problem with debian 7 yet. It seems somehow as if the base debian image is broken as apt is not able to initialze the frontent to query you for the mysql password.

    please try:

    apt-get install dialog

    and then run:

    apt-get install --reinstall postfix postfix-mysql postfix-doc mysql-client mysql-server openssl getmail4 rkhunter binutils dovecot-imapd dovecot-pop3d dovecot-mysql dovecot-sieve sudo
     
  5. laptop_user

    laptop_user Member

    I got mysql root password dialog window. I keyin my password but still error.
    After that I ran
    Code:
    apt-get install --reinstall postfix postfix-mysql postfix-doc mysql-client mysql-server openssl getmail4 rkhunter binutils dovecot-imapd dovecot-pop3d dovecot-mysql dovecot-sieve sudo
    but still error?

    Code:
    root@server1:~# apt-get install dialog
    Reading package lists... Done
    Building dependency tree
    Reading state information... Done
    dialog is already the newest version.
    0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
    2 not fully installed or removed.
    After this operation, 0 B of additional disk space will be used.
    Do you want to continue [Y/n]? y
    Setting up mysql-server-5.5 (5.5.38-0+wheezy1) ...
     Package configuration
     ───────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
    
    
    
    
            ┌───────────────────────────────────────────Configuring mysql-server-5.5─────────────────────────────────────────────┐
            │ While not mandatory, it is highly recommended that you set a password for the MySQL administrative "root" user.    │
            │                                                                                                                    │
            │ If this field is left blank, the password will not be changed.                                                     │
            │                                                                                                                    │
            │ New password for the MySQL "root" user:                                                                            │
            │ ┌────────────────────────────────────────────────────────────────────────────────────────────────────────────────┐ │
            │ │                                                                                                                │ │
            ├─└────────────────────────────────────────────────────────────────────────────────────────────────────────────────┘─┤
            │                                                     <  OK  >                                                       │
            └────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┘
    
    
    
    
    
    
    
     Package configuration
     ───────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
    
    
    
    
    
                                               ┌────────Configuring mysql-server-5.5───────────┐
                                               │                                               │
                                               │                                               │
                                               │ Repeat password for the MySQL "root" user:    │
                                               │ ┌───────────────────────────────────────────┐ │
                                               │ │                                           │ │
                                               ├─└───────────────────────────────────────────┘─┤
                                               │                   <  OK  >                    │
                                               └───────────────────────────────────────────────┘
    
    
    
    
    
    
    
    [ ok ] Stopping MySQL database server: mysqld.
    /var/lib/dpkg/info/mysql-server-5.5.postinst: line 146: logger: command not found
    ATTENTION: An error has occured. More info is in the syslog!
    /var/lib/dpkg/info/mysql-server-5.5.postinst: line 236: logger: command not found
    dpkg: error processing mysql-server-5.5 (--configure):
     subprocess installed post-installation script returned error exit status 127
    dpkg: dependency problems prevent configuration of mysql-server:
     mysql-server depends on mysql-server-5.5; however:
      Package mysql-server-5.5 is not configured yet.
    
    dpkg: error processing mysql-server (--configure):
     dependency problems - leaving unconfigured
    Errors were encountered while processing:
     mysql-server-5.5
     mysql-server
    E: Sub-process /usr/bin/dpkg returned an error code (1)
    root@server1:~# apt-get install --reinstall postfix postfix-mysql postfix-doc mysql-client mysql-server openssl getmail4 rkhunter binutils dovecot-imapd dovecot-pop3d dovecot-mysql dovecot-sieve sudo
    Reading package lists... Done
    Building dependency tree
    Reading state information... Done
    0 upgraded, 0 newly installed, 14 reinstalled, 0 to remove and 0 not upgraded.
    2 not fully installed or removed.
    Need to get 0 B/11.7 MB of archives.
    After this operation, 0 B of additional disk space will be used.
    E: Internal Error, No file name for mysql-server:amd64
    
    I looked in syslog but found nothing about mysql.
    Code:
    root@server1:/var/log# cat syslog
    
    Aug 24 12:45:12 server1 kernel: imklog 5.8.11, log source = /proc/kmsg started.
    Aug 24 12:45:12 server1 rsyslogd: [origin software="rsyslogd" swVersion="5.8.11" x-pid="1550" x-info="http://www.rsyslog.com"] start
    Aug 24 12:55:12 server1 ntpd[1996]: ntpd [email protected] Sat May 12 09:54:55 UTC 2012 (1)
    Aug 24 12:55:12 server1 ntpd[1997]: proto: precision = 0.114 usec
    Aug 24 12:55:12 server1 ntpd[1997]: Listen and drop on 0 v4wildcard 0.0.0.0 UDP 123
    Aug 24 12:55:12 server1 ntpd[1997]: Listen and drop on 1 v6wildcard :: UDP 123
    Aug 24 12:55:12 server1 ntpd[1997]: Listen normally on 2 lo 127.0.0.1 UDP 123
    Aug 24 12:55:12 server1 ntpd[1997]: Listen normally on 3 venet0 127.0.0.2 UDP 123
    Aug 24 12:55:12 server1 ntpd[1997]: Listen normally on 4 venet0:0 162.217.248.67 UDP 123
    Aug 24 12:55:12 server1 ntpd[1997]: Listen normally on 5 venet0:1 162.217.248.68 UDP 123
    Aug 24 12:55:12 server1 ntpd[1997]: Listen normally on 6 lo ::1 UDP 123
    Aug 24 12:55:12 server1 ntpd[1997]: peers refreshed
    Aug 24 12:55:12 server1 ntpd[1997]: Listening on routing socket on fd #23 for interface updates
    Aug 24 12:58:34 server1 dovecot: master: Dovecot v2.1.7 starting up (core dumps disabled)
    Aug 24 12:58:34 server1 dovecot: ssl-params: Generating SSL parameters
    Aug 24 12:58:35 server1 dovecot: master: Warning: Killed with signal 15 (by pid=11945 uid=0 code=kill)
    Aug 24 12:58:35 server1 dovecot: master: Dovecot v2.1.7 starting up (core dumps disabled)
    Aug 24 12:58:35 server1 dovecot: master: Warning: Killed with signal 15 (by pid=12108 uid=0 code=kill)
    Aug 24 12:58:35 server1 dovecot: master: Dovecot v2.1.7 starting up (core dumps disabled)
    Aug 24 12:58:36 server1 dovecot: master: Warning: Killed with signal 15 (by pid=12271 uid=0 code=kill)
    Aug 24 12:58:36 server1 dovecot: master: Dovecot v2.1.7 starting up (core dumps disabled)
    Aug 24 12:58:42 server1 postfix/master[12657]: daemon started -- version 2.9.6, configuration /etc/postfix
    Aug 24 12:58:44 server1 dovecot: ssl-params: SSL parameters regeneration completed
    root@server1:/var/log#
    
    After that I check mysql directory and log in /var/log directory but weirdly enough all is empty?
    Code:
    root@server1:/var/log# ls
    alternatives.log  auth.log  daemon.log  dmesg    dpkg.log  fsck      lastlog  mail.err   mail.log   messages  mysql.err  news      syslog  upstart   wtmp
    apt               btmp      debug       dmesg.0  faillog   kern.log  lpr.log  mail.info  mail.warn  mysql     mysql.log  ntpstats  udev    user.log
    root@server1:/var/log# cat mysql.err
    root@server1:/var/log# cat mysql.log
    root@server1:/var/log# cd mysql
    root@server1:/var/log/mysql# ls -al
    total 8
    drwxr-s--- 2 mysql adm  4096 Aug 24 12:58 .
    drwxr-xr-x 8 root  root 4096 Aug 24 12:58 ..
    root@server1:/var/log/mysql#
    Please advise. Thanks in advance Till.
     
  6. laptop_user

    laptop_user Member

    OK so I try to google certain error keyword such as this :
    Code:
    /var/lib/dpkg/info/mysql-server-5.5.postinst: line 146: logger: command not found
    https://www.google.com/?gws_rd=cr&e....5.postinst+line+146+logger+command+not+found

    Interesting enough I found same errors on Debian and Ubuntu OS starting from July. This guy had the same problem as me : http://forums.debian.net/viewtopic.php?f=10&t=116202 but unfortunately he leaves me hanging.

    So scrolling further down I found a Russian article https://translate.google.com/transl...eshenie-oshibki-logger-command-not-found.html with the same error code:

    I translate it to English and use the solution:

    and mysql problem is solved. Apparently
    Code:
    apt-get install bsdutils
    is essential for Debian but missing from my freshly installed OS.

    Thanks everyone and Till :D
     
  7. TechnoRave

    TechnoRave New Member

    Worked for me!

    This finally resolved the same issue for me! VPS bare-bones install was missing bsdutils. Thanks!
     

Share This Page