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
** 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
@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
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 |
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
** 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
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.
--
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
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
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
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
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
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
@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
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
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.
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 |
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
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
19 matches
Mail list logo