deb package fails to add user for debian-sys-maint
Bug #454237 reported by
Sergey Petrunia
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
High
|
Hakan Küçükyılmaz | ||
OurDelta |
Fix Released
|
High
|
Arjen Lentz |
Bug Description
deb package fails to add user for debian-sys-maint on installation.
This causes package configuration to fail with an error:
ERROR 1045 (28000): Access denied for user 'debian-
and then this error will show up on any invocation of /etc/init.d/mysql start|stop|etc.
Related branches
lp:~maria-captains/ourdelta/ourdelta-mariadb51-2-montyprogram-fixes
- OurDelta-core: Pending requested
-
Diff: 31 lines1 file modifiedbakery/debian-5.1/dist/Debian/mariadb-server-5.1.files (+24/-0)
- OurDelta-core: Pending requested
-
Diff: 154 lines5 files modifiedbakery/debian-5.1/dist/Debian/control (+8/-10)
bakery/debian-5.1/dist/Debian/mariadb-server-5.1.files (+24/-0)
bakery/debian-5.1/dist/Debian/rules (+2/-2)
bakery/debian-5.1/dist/Ubuntu/control (+4/-4)
bakery/mysql51-ourdelta-centos.spec (+5/-0)
Changed in maria: | |
status: | Confirmed → Fix Committed |
Changed in maria: | |
assignee: | nobody → Hakan Küçükyılmaz (hakan-askmonty) |
tags: | added: 5.1 |
tags: | added: packaging |
Changed in maria: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
It is possible to connect to the server and there one can see that indeed mysql.user table has no debian-sys-maint user.
Failure to add user is because of the following:
bakery/ debian- 5.1/dist/ Ubuntu/ mariadb- server- 5.1.postinst has this command: query=` /bin/echo -e \ sys-maint' , password= password( '$pass' ), " \ priv='Y' , " \ tmp_table_ priv='Y' , Lock_tables_ priv='Y' , Execute_priv='Y', "\ priv='Y' , Repl_client_ priv='Y' , Create_ view_priv= 'Y', "\ routine_ priv='Y' , Alter_routine_ priv='Y' , "\ user_priv= 'Y', Event_priv='Y', Trigger_priv='Y' "`;
replace_
"USE mysql\n" \
"REPLACE INTO user SET " \
" host='localhost', user='debian-
" Select_priv='Y', Insert_priv='Y', Update_priv='Y', Delete_priv='Y', " \
" Create_priv='Y', Drop_priv='Y', Reload_priv='Y', Shutdown_priv='Y', " \
" Process_priv='Y', File_priv='Y', Grant_priv='Y', References_
" Index_priv='Y', Alter_priv='Y', Super_priv='Y', Show_db_priv='Y', "\
" Create_
" Repl_slave_
" Show_view_priv='Y', Create_
" Create_
On a server with all-defaults configuration the command will succeed with three warnings:
Field 'ssl_cipher' doesn't have a default value
Field 'x509_issuer' doesn't have a default value
Field 'x509_subject' doesn't have a default value
However, ourdelta- mariadb51- 2/bakery/ debian- 5.1/additions/ my.cnf has this line:
sql_mode = NO_ENGINE_ SUBSTITUTION, TRADITIONAL
Which will make those warnings to be errors, and the command won't succeed any more.