Power & Source of Big Ideas

Installing mySQL-server

Moderators: chensy, FATechsupport

Hi,

I am trying to install mysql-server using apt-get install but it doesn't succeed.

Process: 4865 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=1/FAILURE)

Oct 01 22:16:35 NanoPi-Duo systemd[1]: Failed to start MySQL Community Server.
Oct 01 22:16:35 NanoPi-Duo systemd[1]: mysql.service: Unit entered failed state.
Oct 01 22:16:35 NanoPi-Duo systemd[1]: mysql.service: Failed with result 'exit-code'.


Has anybody had any similar issues?
I've no prbolem to install and run mysqlserver

Code: Select all

root@NanoPi-Duo:~#apt-get update
root@NanoPi-Duo:~#apt-get upgrade
root@NanoPi-Duo:~#apt-get install mysql-server
root@NanoPi-Duo:~# systemctl status mysql
● mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
   Active: active (running) since Tue 2017-10-03 11:55:46 CEST; 1min 12s ago
 Main PID: 8691 (mysqld)
   CGroup: /system.slice/mysql.service
           └─8691 /usr/sbin/mysqld
I have just tried a fresh flash of nanopi-duo_ubuntu-core-xenial_4.11.2_20170908
On first bootup through usb ttl adapter connect to wifi and continue through ssh.
Apt-get update
apt-get upgrade
apt -get install mysql-server
Eventually asks for mysql root pasword
Then it comes up with this error:
Setting up mysql-server-5.7 (5.7.19-0ubuntu0.16.04.1) ...
update-alternatives: using /etc/mysql/mysql.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Renaming removed key_buffer and myisam-recover options (if present)
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
invoke-rc.d: initscript mysql, action "start" failed.
● mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: activating (auto-restart) (Result: exit-code) since Tue 2017-10-03 11:47:15 UTC; 517ms ago
Process: 13046 ExecStartPost=/usr/share/mysql/mysql-systemd-start post (code=exited, status=0/SUCCESS)
Process: 13045 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
Process: 13037 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
Main PID: 13045 (code=exited, status=1/FAILURE)

Oct 03 11:47:15 NanoPi-Duo systemd[1]: Failed to start MySQL Community Server.
Oct 03 11:47:15 NanoPi-Duo systemd[1]: mysql.service: Unit entered failed state.
Oct 03 11:47:15 NanoPi-Duo systemd[1]: mysql.service: Failed with result 'e...'.
Oct 03 11:47:15 NanoPi-Duo systemd[1]: mysql.service: Service hold-off time...t.
Oct 03 11:47:15 NanoPi-Duo systemd[1]: Stopped MySQL Community Server.
Oct 03 11:47:15 NanoPi-Duo systemd[1]: Starting MySQL Community Server...
Hint: Some lines were ellipsized, use -l to show in full.
dpkg: error processing package mysql-server-5.7 (--configure):
subprocess installed post-installation script returned error exit status 1
Setting up libhtml-template-perl (2.95-2) ...
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-5.7; however:
Package mysql-server-5.7 is not configured yet.

dpkg: error processing package mysql-server (--configure):
dependency problems - leaving unconfigured
Processing triggers for systemd (229-4ubuntu19) ...
Processing triggers for libc-bin (2.23-0ubuntu9) ...
Errors were encountered while processing:
mysql-server-5.7
mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
root@NanoPi-Duo:~#


Running systemctl status mysql.service:
root@NanoPi-Duo:~# systemctl status mysql.service
● mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: activating (start-post) (Result: exit-code) since Tue 2017-10-03 11:53:20 UTC; 2s ago
Process: 14356 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
Process: 14349 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
Main PID: 14356 (code=exited, status=1/FAILURE); : 14357 (mysql-systemd-s)
CGroup: /system.slice/mysql.service
└─control
├─14357 /bin/bash /usr/share/mysql/mysql-systemd-start post
└─14365 sleep 1

Oct 03 11:53:20 NanoPi-Duo systemd[1]: Starting MySQL Community Server...
Oct 03 11:53:21 NanoPi-Duo systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Made some progress.
mysql-server works now.
Had to add:
innodb_buffer_pool_size = 64M

under section [mysqld] of
/etc/mysql/my.cnf and other .cnf files in the same or subfolders.

The sql server works now but apt is still coming up with the same error although the service runs with no error.

Who is online

In total there are 2 users online :: 0 registered, 0 hidden and 2 guests (based on users active over the past 5 minutes)
Most users ever online was 5185 on Wed Jan 22, 2020 1:44 pm

Users browsing this forum: No registered users and 2 guests