Re: [DNG] Help needed debugging MySQL install

[Simon Walter]

Thank you, Matt. I appreciate the feedback. I've filed a couple bugs 
against mysql-server and mariadb-server. Either they should depend on 
some syslog or they should their installation scripts should be written 
to detect a logger and function accordingly.


Hopefully someone will get a move on. If not, I've got gafer tape in 
place. Actually it's probably more like chewing gum...!


Cheers,

Simon

On 07/18/2016 08:11 PM, Matthew Melton wrote:

Replying to myself:

http://docs.slackware.com/howtos:databases:install_mariadb_on_slackware

Is probably the order I had to do things. Note the changing of permissions.

Whether this has any relevance to your issue or not I don't know.

I'll be under my rock if you wish to ignore me.

Matt


Sent from my iPhone

On 18 Jul 2016, at 11:57, Matthew Melton > wrote:



This sounds very familiar. Though I think I was using Slackware
installing from slack builds. My hand written notes say something
about mysql_install_db --user=...
Left the /var/lib/mysql/ with the wrong permissions.
Or something.
And something to do with running mysql_secure_installation instead.

Maybe that might help.

It's been a while. And due to the evidence of my handwriting I'm
afraid I appear to have been terribly, terribly, drunk.

Cheers

Matt

Sent from my iPhone

On 18 Jul 2016, at 01:36, Simon Walter > wrote:


On 07/18/2016 08:15 AM, Rick Moen wrote:

Quoting aitor_czr (aitor_...@gnuinos.org
):


> The substitute for MySQL is MariaDB :)

What you said.  ;->  MariaDB is a 100% compatible workalike
(binary drop-in replacement).
https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-compatibility/


Same installation bug(?) with mariadb.

bash /usr/bin/mysql_install_db --rpm --user=mysql --disable-log-bin
2>&1 | $ERR_LOGGER

I thought it would be the case. As it is drop-in replacemen, there is
not really any reason to re-write the package scripts. So I guess I
should report this to two package maintainers.

Thanks for reminding me of mariadb.

Simon
___
Dng mailing list
Dng@lists.dyne.org 
https://mailinglists.dyne.org/cgi-bin/mailman/listinfo/dng

Sent from my iPhone

On 18 Jul 2016, at 01:36, Simon Walter > wrote:


On 07/18/2016 08:15 AM, Rick Moen wrote:

Quoting aitor_czr (aitor_...@gnuinos.org
):


> The substitute for MySQL is MariaDB :)

What you said.  ;->  MariaDB is a 100% compatible workalike
(binary drop-in replacement).
https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-compatibility/


Same installation bug(?) with mariadb.

bash /usr/bin/mysql_install_db --rpm --user=mysql --disable-log-bin
2>&1 | $ERR_LOGGER

I thought it would be the case. As it is drop-in replacemen, there is
not really any reason to re-write the package scripts. So I guess I
should report this to two package maintainers.

Thanks for reminding me of mariadb.

Simon
___
Dng mailing list
Dng@lists.dyne.org 
https://mailinglists.dyne.org/cgi-bin/mailman/listinfo/dng

___
Dng mailing list
Dng@lists.dyne.org 
https://mailinglists.dyne.org/cgi-bin/mailman/listinfo/dng



___
Dng mailing list
Dng@lists.dyne.org
https://mailinglists.dyne.org/cgi-bin/mailman/listinfo/dng


___
Dng mailing list
Dng@lists.dyne.org
https://mailinglists.dyne.org/cgi-bin/mailman/listinfo/dng

Re: [DNG] Help needed debugging MySQL install

[Matthew Melton]

Replying to myself: 

http://docs.slackware.com/howtos:databases:install_mariadb_on_slackware

Is probably the order I had to do things. Note the changing of permissions. 

Whether this has any relevance to your issue or not I don't know. 

I'll be under my rock if you wish to ignore me.

Matt


Sent from my iPhone

> On 18 Jul 2016, at 11:57, Matthew Melton  wrote:
> 
> 
> This sounds very familiar. Though I think I was using Slackware installing 
> from slack builds. My hand written notes say something about mysql_install_db 
> --user=...
> Left the /var/lib/mysql/ with the wrong permissions. 
> Or something. 
> And something to do with running mysql_secure_installation instead. 
> 
> Maybe that might help.
> 
> It's been a while. And due to the evidence of my handwriting I'm afraid I 
> appear to have been terribly, terribly, drunk.
> 
> Cheers
> 
> Matt
> 
> Sent from my iPhone
> 
> On 18 Jul 2016, at 01:36, Simon Walter  wrote:
> 
>>> On 07/18/2016 08:15 AM, Rick Moen wrote:
>>> Quoting aitor_czr (aitor_...@gnuinos.org):
>>> 
 > The substitute for MySQL is MariaDB :)
>>> What you said.  ;->  MariaDB is a 100% compatible workalike
>>> (binary drop-in replacement).
>>> https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-compatibility/
>> 
>> Same installation bug(?) with mariadb.
>> 
>> bash /usr/bin/mysql_install_db --rpm --user=mysql --disable-log-bin 2>&1 | 
>> $ERR_LOGGER
>> 
>> I thought it would be the case. As it is drop-in replacemen, there is not 
>> really any reason to re-write the package scripts. So I guess I should 
>> report this to two package maintainers.
>> 
>> Thanks for reminding me of mariadb.
>> 
>> Simon
>> ___
>> Dng mailing list
>> Dng@lists.dyne.org
>> https://mailinglists.dyne.org/cgi-bin/mailman/listinfo/dng
> Sent from my iPhone
> 
>> On 18 Jul 2016, at 01:36, Simon Walter  wrote:
>> 
>>> On 07/18/2016 08:15 AM, Rick Moen wrote:
>>> Quoting aitor_czr (aitor_...@gnuinos.org):
>>> 
 > The substitute for MySQL is MariaDB :)
>>> What you said.  ;->  MariaDB is a 100% compatible workalike
>>> (binary drop-in replacement).
>>> https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-compatibility/
>> 
>> Same installation bug(?) with mariadb.
>> 
>> bash /usr/bin/mysql_install_db --rpm --user=mysql --disable-log-bin 2>&1 | 
>> $ERR_LOGGER
>> 
>> I thought it would be the case. As it is drop-in replacemen, there is not 
>> really any reason to re-write the package scripts. So I guess I should 
>> report this to two package maintainers.
>> 
>> Thanks for reminding me of mariadb.
>> 
>> Simon
>> ___
>> Dng mailing list
>> Dng@lists.dyne.org
>> https://mailinglists.dyne.org/cgi-bin/mailman/listinfo/dng
> ___
> Dng mailing list
> Dng@lists.dyne.org
> https://mailinglists.dyne.org/cgi-bin/mailman/listinfo/dng
___
Dng mailing list
Dng@lists.dyne.org
https://mailinglists.dyne.org/cgi-bin/mailman/listinfo/dng

Re: [DNG] Help needed debugging MySQL install

[Matthew Melton]

This sounds very familiar. Though I think I was using Slackware installing from 
slack builds. My hand written notes say something about mysql_install_db 
--user=...
Left the /var/lib/mysql/ with the wrong permissions. 
Or something. 
And something to do with running mysql_secure_installation instead. 

Maybe that might help.

It's been a while. And due to the evidence of my handwriting I'm afraid I 
appear to have been terribly, terribly, drunk.

Cheers

Matt

Sent from my iPhone

>> On 18 Jul 2016, at 01:36, Simon Walter  wrote:
>> 
>> On 07/18/2016 08:15 AM, Rick Moen wrote:
>> Quoting aitor_czr (aitor_...@gnuinos.org):
>> 
>>> > The substitute for MySQL is MariaDB :)
>> What you said.  ;->  MariaDB is a 100% compatible workalike
>> (binary drop-in replacement).
>> https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-compatibility/
> 
> Same installation bug(?) with mariadb.
> 
> bash /usr/bin/mysql_install_db --rpm --user=mysql --disable-log-bin 2>&1 | 
> $ERR_LOGGER
> 
> I thought it would be the case. As it is drop-in replacemen, there is not 
> really any reason to re-write the package scripts. So I guess I should report 
> this to two package maintainers.
> 
> Thanks for reminding me of mariadb.
> 
> Simon
> ___
> Dng mailing list
> Dng@lists.dyne.org
> https://mailinglists.dyne.org/cgi-bin/mailman/listinfo/dng
Sent from my iPhone

> On 18 Jul 2016, at 01:36, Simon Walter  wrote:
> 
>> On 07/18/2016 08:15 AM, Rick Moen wrote:
>> Quoting aitor_czr (aitor_...@gnuinos.org):
>> 
>>> > The substitute for MySQL is MariaDB :)
>> What you said.  ;->  MariaDB is a 100% compatible workalike
>> (binary drop-in replacement).
>> https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-compatibility/
> 
> Same installation bug(?) with mariadb.
> 
> bash /usr/bin/mysql_install_db --rpm --user=mysql --disable-log-bin 2>&1 | 
> $ERR_LOGGER
> 
> I thought it would be the case. As it is drop-in replacemen, there is not 
> really any reason to re-write the package scripts. So I guess I should report 
> this to two package maintainers.
> 
> Thanks for reminding me of mariadb.
> 
> Simon
> ___
> Dng mailing list
> Dng@lists.dyne.org
> https://mailinglists.dyne.org/cgi-bin/mailman/listinfo/dng
___
Dng mailing list
Dng@lists.dyne.org
https://mailinglists.dyne.org/cgi-bin/mailman/listinfo/dng

Re: [DNG] Help needed debugging MySQL install

[Simon Walter]

On 07/18/2016 08:15 AM, Rick Moen wrote:

Quoting aitor_czr (aitor_...@gnuinos.org):


> The substitute for MySQL is MariaDB :)

What you said.  ;->  MariaDB is a 100% compatible workalike
(binary drop-in replacement).
https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-compatibility/


Same installation bug(?) with mariadb.

bash /usr/bin/mysql_install_db --rpm --user=mysql --disable-log-bin 2>&1 
| $ERR_LOGGER


I thought it would be the case. As it is drop-in replacemen, there is 
not really any reason to re-write the package scripts. So I guess I 
should report this to two package maintainers.


Thanks for reminding me of mariadb.

Simon
___
Dng mailing list
Dng@lists.dyne.org
https://mailinglists.dyne.org/cgi-bin/mailman/listinfo/dng

Re: [DNG] Help needed debugging MySQL install

[Rick Moen]

Quoting aitor_czr (aitor_...@gnuinos.org):

> The substitute for MySQL is MariaDB :)

What you said.  ;->  MariaDB is a 100% compatible workalike 
(binary drop-in replacement).
https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-compatibility/

I'm personally also very fond of Drizzle, a cleaned-up, simplified fork: 
http://www.drizzle.org/


___
Dng mailing list
Dng@lists.dyne.org
https://mailinglists.dyne.org/cgi-bin/mailman/listinfo/dng

Re: [DNG] Help needed debugging MySQL install

[aitor_czr]

Hi Simon,

On 07/17/2016 02:00 PM, Simon Walter  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 

Re: [DNG] Help needed debugging MySQL install

[Simon Walter]

On 07/17/2016 01:01 PM, Simon Walter 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:
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.


More info:
mysql_install_db does not seem to be running from the postinst script. 
When I run this manually, it succeeds. I think it is failing to run 
because I have no syslog.


ERR_LOGGER="logger -p daemon.err -t mysqld_safe -i"
bash /usr/bin/mysql_install_db --user mysql --rpm 2>&1 | $ERR_LOGGER

I find it strange, because logger does not fail even if there is no 
syslog daemon.


I was wondering why the command is prefixed with "bash". That doesn't 
seem to work

test.sh:
#!/bin/bash
bash /bin/date

#./test.sh
/bin/date: /bin/date: cannot execute binary file

The strange thing is it works when there is a syslog daemon installed.

Any ideas?

Simon
___
Dng mailing list
Dng@lists.dyne.org
https://mailinglists.dyne.org/cgi-bin/mailman/listinfo/dng

[DNG] Help needed debugging MySQL install

[Simon Walter]

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:
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