Ok I now have a work-around procedure that seems to work for me.
1. On fresh install of 10.04 create /etc/mysql/ and add debian-start file
(extracted from mysql-server-5.1 package).
- If this step is skipped the configuration of the mysql-cluster-server-5.1
will hang.
2. Install mysql-cluster-server-5.1
# aptitude install mysql-cluster-server-5.1
- This will error out w/ the following error:
<ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost'
(using password: YES)
3. Fix mysql.user table
# mysql -u root
- no password should be required since it did not get set up correctly in
the package configuration.
a. Verify table appears as I posed in previous comment.
mysql> select user,password,host from mysql.user;
b. Delete incomplete entries
mysql> DROP USER ''@'localhost';
mysql> DROP USER ''@'db3';
c. Create debian-sys-maint user
mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD,
SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER,
CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION
CLIENT ON *.* TO 'debian-sys-maint'@'localhost' WITH GRANT OPTION;
d. Set passwords for root & debian-sys-maint users (for debian-sys-maint use
the password listed in /etc/mysql/debian.cnf)
mysql> UPDATE mysql.user SET Password=PASSWORD('NEW-PASSWORD') WHERE
user='debian-sys-maint';
mysql> UPDATE mysql.user SET Password=PASSWORD('NEW-PASSWORD') WHERE
user='root';
mysql> FLUSH PRIVILEGES;
4. Test that debian-sys-maint user is working
# mysql -u debian-sys-maint -pNEW-PASSWORD
5. Restart of database should now work without errors
# /etc/init.d/mysql restart
--
package mysql-cluster-server-5.1 7.0.9-1ubuntu7 failed to install/upgrade:
subprocess installed pre-removal script returned error exit status 1
https://bugs.launchpad.net/bugs/579732
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
