Error on install: Error with MySQL

Splinti · Jun 11th 2015

output:

**Nuxwin** · Jun 11th 2015

re;

Result of the following command:

Code

# netstat -plunt

You should try to purge all mysql releated packages again and also the full /etc/mysql directory. Once done, you can retry. I'm wondering if this cannot be related to your debian-sys-maint sql user...

Splinti · Jun 11th 2015

output:

Display Spoiler

root@ewtwserv:/usr/local/src/imscp-1.2.3# netstat -plunt
Aktive Internetverbindungen (Nur Server)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 0.0.0.0:110 0.0.0.0:* LISTEN 25824/dovecot
tcp 0 0 0.0.0.0:143 0.0.0.0:* LISTEN 25824/dovecot
tcp 0 0 0.0.0.0:111 0.0.0.0:* LISTEN 465/rpcbind
tcp 0 0 0.0.0.0:465 0.0.0.0:* LISTEN 27522/master
tcp 0 0 192.168.1.105:53 0.0.0.0:* LISTEN 4572/named
tcp 0 0 127.0.0.1:53 0.0.0.0:* LISTEN 4572/named
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 494/sshd
tcp 0 0 0.0.0.0:25 0.0.0.0:* LISTEN 27522/master
tcp 0 0 127.0.0.1:953 0.0.0.0:* LISTEN 4572/named
tcp 0 0 0.0.0.0:52101 0.0.0.0:* LISTEN 476/rpc.statd
tcp 0 0 0.0.0.0:587 0.0.0.0:* LISTEN 27522/master
tcp 0 0 127.0.0.1:11211 0.0.0.0:* LISTEN 497/memcached
tcp6 0 0 :::110 :::* LISTEN 25824/dovecot
tcp6 0 0 :::143 :::* LISTEN 25824/dovecot
tcp6 0 0 :::111 :::* LISTEN 465/rpcbind
tcp6 0 0 :::80 :::* LISTEN 1228/apache2
tcp6 0 0 :::465 :::* LISTEN 27522/master
tcp6 0 0 :::21 :::* LISTEN 29785/proftpd: (acc
tcp6 0 0 :::53 :::* LISTEN 4572/named
tcp6 0 0 :::22 :::* LISTEN 494/sshd
tcp6 0 0 :::25 :::* LISTEN 27522/master
tcp6 0 0 ::1:953 :::* LISTEN 4572/named
tcp6 0 0 :::443 :::* LISTEN 1228/apache2
tcp6 0 0 :::25565 :::* LISTEN 15089/java
tcp6 0 0 ::1:10024 :::* LISTEN 828/amavisd-new (ma
tcp6 0 0 :::35272 :::* LISTEN 476/rpc.statd
tcp6 0 0 :::587 :::* LISTEN 27522/master
udp 0 0 0.0.0.0:61488 0.0.0.0:* 1054/dhclient
udp 0 0 192.168.1.105:53 0.0.0.0:* 4572/named
udp 0 0 127.0.0.1:53 0.0.0.0:* 4572/named
udp 0 0 0.0.0.0:68 0.0.0.0:* 1054/dhclient
udp 0 0 0.0.0.0:111 0.0.0.0:* 465/rpcbind
udp 0 0 0.0.0.0:58484 0.0.0.0:* 476/rpc.statd
udp 0 0 192.168.1.105:123 0.0.0.0:* 581/ntpd
udp 0 0 127.0.0.1:123 0.0.0.0:* 581/ntpd
udp 0 0 0.0.0.0:123 0.0.0.0:* 581/ntpd
udp 0 0 0.0.0.0:638 0.0.0.0:* 465/rpcbind
udp 0 0 127.0.0.1:652 0.0.0.0:* 476/rpc.statd
udp 0 0 127.0.0.1:11211 0.0.0.0:* 497/memcached
udp6 0 0 :::53 :::* 4572/named
udp6 0 0 :::111 :::* 465/rpcbind
udp6 0 0 fe80::21e:c9ff:fedb:123 :::* 581/ntpd
udp6 0 0 ::1:123 :::* 581/ntpd
udp6 0 0 :::123 :::* 581/ntpd
udp6 0 0 :::638 :::* 465/rpcbind
udp6 0 0 :::41374 :::* 476/rpc.statd
udp6 0 0 :::15865 :::* 1054/dhclient

Edit: Ok, I'll do so.

**Nuxwin** · Jun 11th 2015

Re;

Remove also the /var/run/mysql directory if any.

Splinti · Jun 11th 2015

So I did the following:
apt-get purge mysql*
That went well...
When trying
perl imscp-autoinstall -dr sql
this error showed up:

Display Spoiler

Configuration file `/etc/apparmor.d/usr.sbin.mysqld', does not exist on system.
Installing new config file as you requested.

Configuration file `/etc/init.d/mysql', does not exist on system.
Installing new config file as you requested.

Configuration file `/etc/logcheck/ignore.d.paranoid/mysql-server-5_5', does not exist on system.
Installing new config file as you requested.

Configuration file `/etc/logcheck/ignore.d.server/mysql-server-5_5', does not exist on system.
Installing new config file as you requested.

Configuration file `/etc/logcheck/ignore.d.workstation/mysql-server-5_5', does not exist on system.
Installing new config file as you requested.

Configuration file `/etc/logrotate.d/mysql-server', does not exist on system.
Installing new config file as you requested.

Configuration file `/etc/mysql/conf.d/mysqld_safe_syslog.cnf', does not exist on system.
Installing new config file as you requested.

Configuration file `/etc/mysql/debian-start', does not exist on system.
Installing new config file as you requested.
150611 18:28:48 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
150611 18:28:48 [Note] /usr/sbin/mysqld (mysqld 5.5.43-0+deb8u1) starting as process 1499 ...
Job for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -xn' for details.
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing package mysql-server-5.5 (--configure):
subprocess installed post-installation script returned error exit status 1
Setting up dovecot-mysql (1:2.2.13-11) ...
Setting up proftpd-mod-mysql (1.3.5-1.1+deb8u1) ...
Setting up libsasl2-modules-sql:i386 (2.1.26.dfsg1-13) ...
Setting up php5-mysqlnd (5.6.9+dfsg-0+deb8u1) ...

Creating config file /etc/php5/mods-available/mysqlnd.ini with new version
php5_invoke: Enable module mysqlnd for cli SAPI
php5_invoke: Enable module mysqlnd for cgi SAPI
php5_invoke: Enable module mysqlnd for apache2 SAPI
php5_invoke: Enable module mysqlnd for fpm SAPI

Creating config file /etc/php5/mods-available/mysql.ini with new version
php5_invoke: Enable module mysql for cli SAPI
php5_invoke: Enable module mysql for cgi SAPI
php5_invoke: Enable module mysql for apache2 SAPI
php5_invoke: Enable module mysql for fpm SAPI

Creating config file /etc/php5/mods-available/mysqli.ini with new version
php5_invoke: Enable module mysqli for cli SAPI
php5_invoke: Enable module mysqli for cgi SAPI
php5_invoke: Enable module mysqli for apache2 SAPI
php5_invoke: Enable module mysqli for fpm SAPI

Creating config file /etc/php5/mods-available/pdo_mysql.ini with new version
php5_invoke: Enable module pdo_mysql for cli SAPI
php5_invoke: Enable module pdo_mysql for cgi SAPI
php5_invoke: Enable module pdo_mysql for apache2 SAPI
php5_invoke: Enable module pdo_mysql for fpm SAPI
Processing triggers for libc-bin (2.19-18) ...
Processing triggers for systemd (215-17+deb8u1) ...
Processing triggers for dovecot-core (1:2.2.13-11) ...
Processing triggers for libapache2-mod-php5 (5.6.9+dfsg-0+deb8u1) ...
Processing triggers for php5-fpm (5.6.9+dfsg-0+deb8u1) ...
Errors were encountered while processing:
mysql-server-5.5
E: Sub-process /usr/bin/dpkg returned an error code (1)

autoinstaller::Functions::build: An error occurred while performing build steps

Edit: /var/run/mysql was not present

**Nuxwin** · Jun 11th 2015

Re;

PLEASE purge all releated packages ONE BY ONE. Do not use wildcard.

Splinti · Jun 11th 2015

How can I find all the packagenames I need to purge ?

**Nuxwin** · Jun 11th 2015

Re;

Code

# aptitude purge mysql-client-5.5 mysql-server-5.5 \
mysql-server-core-5.5 mysql-common libmysqlclient18
# rm -r /var/run/mysql
# rm -r /etc/mysql
# aptitude update

Splinti · Jun 11th 2015

Rre;

Did that, tried to reinstall and it failed again
Might be this the issue ?
http://i.gyazo.com/7cdb492c0c0d8f72c05892cd53b6ee82.png

**Nuxwin** · Jun 11th 2015

Ok ;

So here, repeat all the steps as stated in my previous post and do also:

Shell-Script

# rm -r /var/lib/mysql

Error on install: Error with MySQL

Share

Daily visitors