On Fri, Nov 12, 2010 at 17:43, Kristian Nielsen
<email address hidden> wrote:
> 1. The debian-sys-maint account should be created during install, it is
> used internally by the postinst scripts. My guess is that something went
> wrong with this in the many failed install attempts. It is a huge
> problem that we do not have apt-get'able package repositories at the
> moment, packages need to be installed in a specific order, which is
> _very_ hard to get right manually.
I was sitting next to Colin while doing the install and he warned me
about it actually. I went ahead and did it anyway, cos even though
dpkg sucks for dependencies like this, it shouldn't actually cause
mayhem like this :)
Also, i'll talk to Arjen some more to put the pressure on getting the
OurDelta repo's in shape.

> You may have to create that user manually (or remove --purge + reinstall
> in right order should also work, if you haven't yet put data in).
I'll create manually. This is a test VM for http://fossasia.org, so
i'm not fussed about messign with it :)

> 2. When the postinst script installs the initial database, it runs
> mysqld with special options that disable InnoDB (to reduce risk of
> failing to install due to problems with innodb options), this is nothing
> to worry about (agree it is a bit confusing to see these in the logs,
> and also the warnings about --log-xxx options).
Agreed.

> 3. The failure to shutdown is a consequence of the problem with the
> debian-sys-maint account.
Figured that.

> Looking at the log about the problem with debian-sys-maint ... It says
> 'using password: NO'. This suggests something wrong with the file cat
> /etc/mysql/debian.cnf. Can you show the contents of this file, with any
> password replaced by XXX ? It should look something like this:
db:~# cat /etc/mysql/debian.cnf
# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host     = localhost
user     = debian-sys-maint
password = yomamma
socket   = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host     = localhost
user     = debian-sys-maint
password = yomamma
socket   = /var/run/mysqld/mysqld.sock
basedir  = /usr

> If this looks ok, you can check that `mysqladmin --defaults-
> file=/etc/mysql/debian.cnf ping` works; if not then maybe the account
> inside mariadb is wrong/missing (but the Using password: NO suggests a
> problem with debian.cnf)
The account is missing:
db:~# mysqladmin --defaults-file=/etc/mysql/debian.cnf ping
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using
password: NO)'

MariaDB [(none)]> select user, host, password from mysql.user;
+------+----------------+-------------------------------------------+
| user | host           | password                                  |
+------+----------------+-------------------------------------------+
| root | localhost      | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| root | db.example.com | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| root | 127.0.0.1      | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
+------+----------------+-------------------------------------------+
3 rows in set (0.00 sec)

> (It is also possible that an existing /etc/mysql/debian.cnf file with
> wrong content could have caused this; seeing the content of the file
> should help determine this).
Nope, this was a brand new VM

-- 
Walter Heck

--
follow @walterheck on twitter to see what I'm up to!
--
Check out my new startup: Server Monitoring as a Service @ http://tribily.com
Follow @tribily on Twitter and/or 'Like' our Facebook page at
http://www.facebook.com/tribily