:: Re: [DNG] Help needed debugging MyS…
Pàgina inicial
Delete this message
Reply to this message
Autor: aitor_czr
Data:  
A: Simon Walter, dng
Assumpte: Re: [DNG] Help needed debugging MySQL install
Hi Simon,

On 07/17/2016 02:00 PM, Simon Walter <simon@???> wrote:
> Hi everyone,
>
> I am having trouble installing mysql-server inside a container (lxc). I
> have the same problem with a fresh Jessie install. so it doesn't seem
> specific to Devuan.
>
> Basic description of problem:You should check the account's password after the package installation."
>
> After unpacking and setting up the packages, mysql is stopped and the
> root use password is to be set. However, the management database does
> not exist and/or cannot be created. There are no files in
> /var/lib/mysql/mysql and it is owned by root. On an successful install
> (not in a container) that dir is owned by mysql.
>
> The log files show:
> 160716 22:32:16 [Note] Plugin 'FEDERATED' is disabled.
> 160716 22:32:16 InnoDB: The InnoDB memory heap is disabled
> 160716 22:32:16 InnoDB: Mutexes and rw_locks use GCC atomic builtins
> 160716 22:32:16 InnoDB: Compressed tables use zlib 1.2.8
> 160716 22:32:16 InnoDB: Using Linux native AIO
> 160716 22:32:16 InnoDB: Initializing buffer pool, size = 128.0M
> 160716 22:32:16 InnoDB: Completed initialization of buffer pool
> InnoDB: The first specified data file ./ibdata1 did not exist:
> InnoDB: a new database to be created!
> 160716 22:32:16 InnoDB: Setting file ./ibdata1 size to 10 MB
> InnoDB: Database physically writes the file full: wait...
> 160716 22:32:17 InnoDB: Log file ./ib_logfile0 did not exist: new to be
> created
> InnoDB: Setting log file ./ib_logfile0 size to 5 MB
> InnoDB: Database physically writes the file full: wait...
> 160716 22:32:17 InnoDB: Log file ./ib_logfile1 did not exist: new to be
> created
> InnoDB: Setting log file ./ib_logfile1 size to 5 MB
> InnoDB: Database physically writes the file full: wait...
> InnoDB: Doublewrite buffer not found: creating new
> InnoDB: Doublewrite buffer created
> InnoDB: 127 rollback segment(s) active.
> InnoDB: Creating foreign key constraint system tables
> InnoDB: Foreign key constraint system tables created
> 160716 22:32:17 InnoDB: Waiting for the background threads to start
> 160716 22:32:18 InnoDB: 5.5.49 started; log sequence number 0
> ERROR: 1146 Table 'mysql.user' doesn't exist
> 160716 22:32:18 [ERROR] Aborting
>
> 160716 22:32:18 InnoDB: Starting shutdown...
> 160716 22:32:19 InnoDB: Shutdown completed; log sequence number 1595675
> 160716 22:32:19 [Note] /usr/sbin/mysqld: Shutdown complete
>
> 160716 22:38:41 mysqld_safe Starting mysqld daemon with databases from
> /var/lib/mysql
> 160716 22:38:41 [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.
> 160716 22:38:41 [Note] /usr/sbin/mysqld (mysqld 5.5.49-0+deb8u1)
> starting as process 1156 ...
> 160716 22:38:41 [Warning] Using unique option prefix myisam-recover
> instead of myisam-recover-options is deprecated and will be removed in a
> future release. Please use the full name instead.
> 160716 22:38:41 [Note] Plugin 'FEDERATED' is disabled.
> /usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
> 160716 22:38:41 [ERROR] Can't open the mysql.plugin table. Please run
> mysql_upgrade to create it.
> 160716 22:38:41 InnoDB: The InnoDB memory heap is disabled
> 160716 22:38:41 InnoDB: Mutexes and rw_locks use GCC atomic builtins
> 160716 22:38:41 InnoDB: Compressed tables use zlib 1.2.8
> 160716 22:38:41 InnoDB: Using Linux native AIO
> 160716 22:38:41 InnoDB: Initializing buffer pool, size = 128.0M
> 160716 22:38:41 InnoDB: Completed initialization of buffer pool
> 160716 22:38:41 InnoDB: highest supported file format is Barracuda.
> 160716 22:38:41 InnoDB: Waiting for the background threads to start
> 160716 22:38:42 InnoDB: 5.5.49 started; log sequence number 1595675
> 160716 22:38:42 [Note] Server hostname (bind-address): '127.0.0.1';
> port: 3306
> 160716 22:38:42 [Note] - '127.0.0.1' resolves to '127.0.0.1';
> 160716 22:38:42 [Note] Server socket created on IP: '127.0.0.1'.
> 160716 22:38:42 [ERROR] Fatal error: Can't open and lock privilege
> tables: Table 'mysql.host' doesn't exist
> 160716 22:38:42 mysqld_safe mysqld from pid file
> /var/run/mysqld/mysqld.pid ended
>
> On a successful install, there are no errors about missing tables:
> 160716 16:27:53 [Note] Plugin 'FEDERATED' is disabled.
> 160716 16:27:53 InnoDB: The InnoDB memory heap is disabled
> 160716 16:27:53 InnoDB: Mutexes and rw_locks use GCC atomic builtins
> 160716 16:27:53 InnoDB: Compressed tables use zlib 1.2.8
> 160716 16:27:53 InnoDB: Using Linux native AIO
> 160716 16:27:53 InnoDB: Initializing buffer pool, size = 128.0M
> 160716 16:27:53 InnoDB: Completed initialization of buffer pool
> InnoDB: The first specified data file ./ibdata1 did not exist:
> InnoDB: a new database to be created!
> 160716 16:27:53 InnoDB: Setting file ./ibdata1 size to 10 MB
> InnoDB: Database physically writes the file full: wait...
> 160716 16:27:53 InnoDB: Log file ./ib_logfile0 did not exist: new to be
> created
> InnoDB: Setting log file ./ib_logfile0 size to 5 MB
> InnoDB: Database physically writes the file full: wait...
> 160716 16:27:53 InnoDB: Log file ./ib_logfile1 did not exist: new to be
> created
> InnoDB: Setting log file ./ib_logfile1 size to 5 MB
> InnoDB: Database physically writes the file full: wait...
> InnoDB: Doublewrite buffer not found: creating new
> InnoDB: Doublewrite buffer created
> InnoDB: 127 rollback segment(s) active.
> InnoDB: Creating foreign key constraint system tables
> InnoDB: Foreign key constraint system tables created
> 160716 16:27:53 InnoDB: Waiting for the background threads to start
> 160716 16:27:54 InnoDB: 5.5.49 started; log sequence number 0
> 160716 16:27:54 InnoDB: Starting shutdown...
> 160716 16:27:55 InnoDB: Shutdown completed; log sequence number 1595675
> 160716 16:27:55 [Warning] Using unique option prefix myisam-recover
> instead of myisam-recover-options is deprecated and will be removed in a
> future release. Please use the full name instead.
>
> Since /var/lib/mysql/mysql is empty, it seems that the entire database
> is not being created. Though some files are being created:
> # ls -l/var/lib/mysql/
> total 28676
> -rw-r--r-- 1 root  root         0 Jul 16 22:32 debian-5.5.flag
> -rw-rw---- 1 mysql mysql 18874368 Jul 16 22:32 ibdata1
> -rw-rw---- 1 mysql mysql  5242880 Jul 16 22:38 ib_logfile0
> -rw-rw---- 1 mysql mysql  5242880 Jul 16 22:32 ib_logfile1
> drwx------ 2 mysql root      4096 Jul 16 22:32 mysql

>
> The container is a "privileged" container. The frontend is interactive.
> It's got the blue screen for accepting the root user's password.
>
> The error on that screen is:
> "Unable to set password for the MySQL "root" user
>
>                                                 An error occurred while
> setting the password for the MySQL administrative user. This may have
> happened because the account already has a password, or because of a
> communication problem with the MySQL server.

>
>
>
> You should check the account's password after the package installation."
>
>
>
> After hitting enter, mysql fails to start.
>
> It's obviously a communication error, because the server is not even
> running according to the log. Why the database is not created is what I
> am not able to understand.
>
> Any ideas?
>
> Kind regards,
>
> Simon
>


Did you consider using PostgreSQL instead of MySQL, which belongs to Oracle?

The substitute for MySQL is MariaDB :)

Aitor.