[Bug 153221] Re: MySQL server fails to upgrade in Gutsy - debian-sys-maint user permission denied
After investigating this thoroughly, it turned out debian-sys-maint’s password differed between /etc/mysql/debian.cnt and the database. After a proper SET PASSWORD FOR 'debian-sys-maint'@'localhost' everything seems ok (and the upgrade ran smoothly), so feel free to close this bug. -- MySQL server fails to upgrade in Gutsy - debian-sys-maint user permission denied https://bugs.launchpad.net/bugs/153221 You received this bug notification because you are a member of Ubuntu Bugs, which is the bug contact for Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 153221] Re: MySQL server fails to upgrade in Gutsy - debian-sys-maint user permission denied
** Changed in: mysql-dfsg-5.0 (Ubuntu) Status: Incomplete = Invalid -- MySQL server fails to upgrade in Gutsy - debian-sys-maint user permission denied https://bugs.launchpad.net/bugs/153221 You received this bug notification because you are a member of Ubuntu Bugs, which is the bug contact for Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 153221] Re: MySQL server fails to upgrade in Gutsy - debian-sys-maint user permission denied
@Soren: yes, I stated I figured it out on my own. I can not reproduce it anymore and I think, if that's OK with Shot who had similar problem, we can close it. -- MySQL server fails to upgrade in Gutsy - debian-sys-maint user permission denied https://bugs.launchpad.net/bugs/153221 You received this bug notification because you are a member of Ubuntu Bugs, which is the bug contact for Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
Re: [Bug 153221] Re: MySQL server fails to upgrade in Gutsy
On Tue, Oct 16, 2007 at 02:34:12PM -, Emil Oppeln-Bronikowski wrote: mysql SELECT Host,User,Password FROM user WHERE User = 'debian-sys-maint'; +---+--+--+ | Host | User | Password | +---+--+--+ | localhost | debian-sys-maint | 69006d5d4d87514c | +---+--+--+ 1 row in set (0.00 sec) [EMAIL PROTECTED]:~# cat /etc/mysql/debian.cnf | grep password password = 69006d5d4d87514c password = 69006d5d4d87514c Er, the password in the user table is hashed, so it shouldn't match what's in the .conf file. -- Soren Hansen Ubuntu Server Team http://www.ubuntu.com/ -- MySQL server fails to upgrade in Gutsy https://bugs.launchpad.net/bugs/153221 You received this bug notification because you are a member of Ubuntu Bugs, which is the bug contact for Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
Re: [Bug 153221] Re: MySQL server fails to upgrade in Gutsy
On Tue, Oct 16, 2007 at 04:19:15PM -, Ante Karamatić wrote: (mostly Dapper, couple of Feistys and 3 Hardys). I always upgrade with apt-get. Hardys? Wow, you're more 1337 than I thought! :) -- Soren Hansen Ubuntu Server Team http://www.ubuntu.com/ -- MySQL server fails to upgrade in Gutsy https://bugs.launchpad.net/bugs/153221 You received this bug notification because you are a member of Ubuntu Bugs, which is the bug contact for Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 153221] Re: MySQL server fails to upgrade in Gutsy - debian-sys-maint user permission denied
** Summary changed: - MySQL server fails to upgrade in Gutsy + MySQL server fails to upgrade in Gutsy - debian-sys-maint user permission denied -- MySQL server fails to upgrade in Gutsy - debian-sys-maint user permission denied https://bugs.launchpad.net/bugs/153221 You received this bug notification because you are a member of Ubuntu Bugs, which is the bug contact for Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 153221] Re: MySQL server fails to upgrade in Gutsy
I can confirm this on Feisty with mysql-server upgrade attempt 5.0.38-0ubuntu1 → 5.0.38-0ubuntu1.1 -- MySQL server fails to upgrade in Gutsy https://bugs.launchpad.net/bugs/153221 You received this bug notification because you are a member of Ubuntu Bugs, which is the bug contact for Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 153221] Re: MySQL server fails to upgrade in Gutsy
Thank you for your bug report and helping make Ubuntu better. At this time we do not have enough information to diagnose the bug. Please check your logs in /var/log and attach the log messages pertaining to this issue. It is also possible that the Feisty issue is a different issue, so it would be great to get these logs as well. ** Changed in: mysql-dfsg-5.0 (Ubuntu) Status: New = Incomplete -- MySQL server fails to upgrade in Gutsy https://bugs.launchpad.net/bugs/153221 You received this bug notification because you are a member of Ubuntu Bugs, which is the bug contact for Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 153221] Re: MySQL server fails to upgrade in Gutsy
Did you change permissions for users in mysql.user table? -- MySQL server fails to upgrade in Gutsy https://bugs.launchpad.net/bugs/153221 You received this bug notification because you are a member of Ubuntu Bugs, which is the bug contact for Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 153221] Re: MySQL server fails to upgrade in Gutsy
For what it's worth I was able to update MySQL on Feisty just fine: Setting up mysql-client-5.0 (5.0.38-0ubuntu1.1) ... Setting up mysql-server-5.0 (5.0.38-0ubuntu1.1) ... Installing new version of config file /etc/init.d/mysql ... * Stopping MySQL database server mysqld [ OK ] * Starting MySQL database server mysqld [ OK ] * Checking for corrupt, not cleanly closed and upgrade needing tables. Setting up mysql-server (5.0.38-0ubuntu1.1) ... Setting up mysql-client (5.0.38-0ubuntu1.1) ... I used apt-get update; apt-get upgrade though not aptitude. -- MySQL server fails to upgrade in Gutsy https://bugs.launchpad.net/bugs/153221 You received this bug notification because you are a member of Ubuntu Bugs, which is the bug contact for Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 153221] Re: MySQL server fails to upgrade in Gutsy
I (the Feisty case) didn’t touch mysql.user at all, and all previous
MySQL security upgrades went flawlessly. Also, my Gutsy devel box
(upgraded from Feisty a couple of weeks ago) upgraded just fine this
time.
Note: On my Feisty server, debian-sys-maint seems to have ALL
PRIVILEGES, while on my Gutsy devel laptop it seems to have SELECT,
INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE,
REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY
TABLES, LOCK TABLES, REPLICATION SLAVE, REPLICATION CLIENT, EXECUTE.
On the Feisty machine, all my /var/log/mysql.{log,err}* files are empty
(again, permission issue?). :|
--
MySQL server fails to upgrade in Gutsy
https://bugs.launchpad.net/bugs/153221
You received this bug notification because you are a member of Ubuntu
Bugs, which is the bug contact for Ubuntu.
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 153221] Re: MySQL server fails to upgrade in Gutsy
I was also able to update on Gutsy without issue: Preparing to replace mysql-server-5.0 5.0.45-1ubuntu2 (using .../mysql- server-5.0_5.0.45-1ubuntu3_i386.deb) ... Setting up mysql-server-5.0 (5.0.45-1ubuntu3) ... * Stopping MySQL database server mysqld [ OK ] * Starting MySQL database server mysqld [ OK ] * Checking for corrupt, not cleanly closed and upgrade needing tables. Again, I used sudo apt-get update; sudo apt-get upgrade and not aptitude so I guess it could be an aptitude issue? -- MySQL server fails to upgrade in Gutsy https://bugs.launchpad.net/bugs/153221 You received this bug notification because you are a member of Ubuntu Bugs, which is the bug contact for Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 153221] Re: MySQL server fails to upgrade in Gutsy
Emil: Which command did you use to set debian-sys-maint password ? Can you connect with the mysql client ? -- MySQL server fails to upgrade in Gutsy https://bugs.launchpad.net/bugs/153221 You received this bug notification because you are a member of Ubuntu Bugs, which is the bug contact for Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 153221] Re: MySQL server fails to upgrade in Gutsy
@Emil: Could you check that the user debian-sys-maint existed before the upgrade ? Can you try to connect to the database with its credentials (which are located in /etc/mysql/debian.cnf) ? @Shot: do you see the same error message (debian-sys-maint permission denied) ? If could you try the same test specified above ? -- MySQL server fails to upgrade in Gutsy https://bugs.launchpad.net/bugs/153221 You received this bug notification because you are a member of Ubuntu Bugs, which is the bug contact for Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 153221] Re: MySQL server fails to upgrade in Gutsy
OK, neither OLD_PASSWORD nor PASSWORD didn't produce good results. My mysql.user for debian-sys-maint looks not like this: mysql select User, Password, Host from user where User like 'debian%'; +--+---+--+ | User | Password | Host | +--+---+--+ | debian-sys-maint | *DCE05059E58FA45F45A40420DF3F02D16D103E73 | %| +--+---+--+ 1 row in set (0.00 sec) It still fails to start, but, if I run mysqld by hand, I can log in without problems using same password I did hash from. [EMAIL PROTECTED]:/var/www/swatka$ mysql -p -u debian-sys-maint Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 9 Server version: 5.0.45-Debian_1ubuntu2-log Debian etch distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. I'm 99% sure now that there's a problem with upgrade scripts in package. -- MySQL server fails to upgrade in Gutsy https://bugs.launchpad.net/bugs/153221 You received this bug notification because you are a member of Ubuntu Bugs, which is the bug contact for Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 153221] Re: MySQL server fails to upgrade in Gutsy
OK, I'm fscking dumb! ;-) Good think someone been watching behind my shoulder. The 'password' var in debian.cfg SHOULD NOT CONSIST HASH :D *HEADSHOT* After I changed that to plain text password that matches mysql.user .debian-sys-maint it works again. Lets see if it will process dist- upgrade. OK, it failed to use debian-sys-maint again, but it upgraded. Still, I think there's bug somewhere. Maybe Shot will be able to pin it down. -- MySQL server fails to upgrade in Gutsy https://bugs.launchpad.net/bugs/153221 You received this bug notification because you are a member of Ubuntu Bugs, which is the bug contact for Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 153221] Re: MySQL server fails to upgrade in Gutsy
Ho hum! It seems that after all my mysql.user Password field was different from /etc/mysql/debian.cnf. I've updated password string. mysql SELECT Host,User,Password FROM user WHERE User = 'debian-sys-maint'; +---+--+--+ | Host | User | Password | +---+--+--+ | localhost | debian-sys-maint | 69006d5d4d87514c | +---+--+--+ 1 row in set (0.00 sec) [EMAIL PROTECTED]:~# cat /etc/mysql/debian.cnf | grep password password = 69006d5d4d87514c password = 69006d5d4d87514c And now... MySQL won't even start. [EMAIL PROTECTED]:~# /etc/init.d/mysql start * Starting MySQL database server mysqld [ OK ] /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)' I wonder if that's somehow related to Host field. Maybe I'll change its value to '%'. About logs, same as in Shot comment before, /var/log/mysql.err and .log are empty. Binlogs are also quiet. -- MySQL server fails to upgrade in Gutsy https://bugs.launchpad.net/bugs/153221 You received this bug notification because you are a member of Ubuntu Bugs, which is the bug contact for Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 153221] Re: MySQL server fails to upgrade in Gutsy
What do you mean by it failed to use debian-sys-maint again ? -- MySQL server fails to upgrade in Gutsy https://bugs.launchpad.net/bugs/153221 You received this bug notification because you are a member of Ubuntu Bugs, which is the bug contact for Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 153221] Re: MySQL server fails to upgrade in Gutsy
I can just confirm that update went without problems on 20 servers (mostly Dapper, couple of Feistys and 3 Hardys). I always upgrade with apt-get. -- MySQL server fails to upgrade in Gutsy https://bugs.launchpad.net/bugs/153221 You received this bug notification because you are a member of Ubuntu Bugs, which is the bug contact for Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
