Right. The problem is that mysql_install_db never gets around to creating the initial root user; the server segfaults when it processes mysql_system_tables_data.sql.
mysql> CREATE TEMPORARY TABLE tmp_user LIKE user; Query OK, 0 rows affected (0.00 sec) mysql> set @current_hostname= @@hostname; Query OK, 0 rows affected (0.00 sec) mysql> CREATE TEMPORARY TABLE tmp_db LIKE db; Query OK, 0 rows affected (0.00 sec) mysql> INSERT INTO db SELECT * FROM tmp_db WHERE @had_db_table=0; ERROR 2013 (HY000): Lost connection to MySQL server during query I'm building a newer package at the moment from lp:~maria-captains/maria/maria-5.1-merge revno 2788. We'll see if the problem persists. -- MariaDB: deb package errors on installation https://bugs.launchpad.net/bugs/452116 You received this bug notification because you are a member of OurDelta- developers, which is the registrant for OurDelta. Status in Maria: New Status in OurDelta - Builds for MySQL,MariaDB: New Bug description: I've tried installing MariaDB from http://master.ourdelta.org/deb/dists/jaunty/mariadb-ourdelta/ on Ubuntu 9.04 amd64. I got HTTP 404 errors on the first attempt, but not on the second. The package asked me to change root password several times during the installation. In all cases, I've just hit 'enter' as an indication that I do not want to change it. As a result, I got this: Setting up mariadb-server-core-5.1 (5.1.38-ourdelta81) ... Setting up mariadb-server-5.1 (5.1.38-ourdelta81) ... * Stopping MariaDB database server mysqld [ OK ] Replacement succeeded for "/usr/sbin/mysqld". * Starting MariaDB database server mysqld [ OK ] * Checking for corrupt, not cleanly closed and upgrade needing tables. ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost' (using password: YES) Setting up libhtml-template-perl (2.9-1) ... Setting up mariadb-server (5.1.38-ourdelta81) ... Processing triggers for libc6 ... ldconfig deferred processing now taking place r...@pylon64:~# r...@pylon64:~# /etc/init.d/mysql status /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)' * r...@pylon64:~# /etc/init.d/mysql start * Starting MariaDB database server mysqld [ OK ] r...@pylon64:~# Further experimentation showed that "/etc/init.d/mysql start" works, while restart and stop commands do not because of permission errors. /etc/mysql/debian.cnf contains the following: [client] host = localhost user = debian-sys-maint password = G4dQ6VLVrD81ilks socket = /var/run/mysqld/mysqld.sock [mysql_upgrade] host = localhost user = debian-sys-maint password = G4dQ6VLVrD81ilks socket = /var/run/mysqld/mysqld.sock basedir = /usr This user/password pair is not accepted by the server. I had to edit /etc/my.cnf and put there 'skip-grant-tables' so that I could log in. After logging in, I can see that mysql.user table is empty. It looks like installer script wasn't successful in adding the debian-stys-maint user? _______________________________________________ Mailing list: https://launchpad.net/~ourdelta-developers Post to : [email protected] Unsubscribe : https://launchpad.net/~ourdelta-developers More help : https://help.launchpad.net/ListHelp
