Bug 537709 - YUM: warning: group mysql does not exist - using root
Summary: YUM: warning: group mysql does not exist - using root
Keywords:
Status: CLOSED INSUFFICIENT_DATA
Alias: None
Product: Fedora
Classification: Fedora
Component: 0xFFFF
Version: 12
Hardware: x86_64
OS: Linux
low
medium
Target Milestone: ---
Assignee: Peter Vrabec
QA Contact: Fedora Extras Quality Assurance
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2009-11-15 22:32 UTC by Flóki Pálsson
Modified: 2009-12-03 04:00 UTC (History)
5 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2009-12-03 04:00:01 UTC
Type: ---
Embargoed:


Attachments (Terms of Use)
YUM: RPM Scriptlet: warning: user mysql does not exist - using root - and .. (3.67 KB, text/plain)
2009-11-15 22:32 UTC, Flóki Pálsson
no flags Details

Description Flóki Pálsson 2009-11-15 22:32:01 UTC
Created attachment 369625 [details]
YUM: RPM Scriptlet: warning: user mysql does not exist - using root - and ..

Description of problem:
After installing mysql then it is not possible to start mysqld service.
No mysql user has been created.  see system-config-users. 

Version-Release number of selected component (if applicable):
$ rpm -qa | grep mysql | sort 
libdbi-dbd-mysql-0.8.3-5.fc12.x86_64
mysql-5.1.40-1.fc12.x86_64
mysql-administrator-5.0r14-1.fc12.x86_64
mysql-connector-java-5.1.8-1.fc12.x86_64
mysql-connector-odbc-5.1.5r1144-6.fc12.x86_64
mysql-embedded-5.1.40-1.fc12.x86_64
mysql-gui-common-5.0r14-1.fc12.x86_64
mysql-gui-tools-5.0r14-1.fc12.x86_64
mysql-libs-5.1.40-1.fc12.x86_64
mysql-query-browser-5.0r14-1.fc12.x86_64
mysql-server-5.1.40-1.fc12.x86_64
php-mysql-5.3.0-6.fc12.x86_64

How reproducible:
I do not know.  I have tried to erase mysql-server and reinstall.

Steps to Reproduce:
1.
# service mysqld start 
2.
3.
  
Actual results:
chown: invalid user: `mysql:mysql'
chown: invalid user: `mysql:mysql'
Timeout error occurred trying to start MySQL Daemon.
Ræsi MySQL:                                                [VILLA]  ( error )

Expected results:
service mysql started 

Additional info:
before installing mysql then amarok was installed.
This is no problem in F10 to install mysql. ( amarok not installed )
see attachment

Comment 1 Tom Lane 2009-11-15 23:51:16 UTC
Apparently the preinstall scriptlet for mysql-server failed:

%pre server
/usr/sbin/useradd -M -o -r -d /var/lib/mysql -s /bin/bash \
	-c "MySQL Server" -u 27 mysql > /dev/null 2>&1 || :

That hasn't changed in quite a long time ... any thoughts why?

Comment 2 Flóki Pálsson 2009-11-16 00:28:41 UTC
>%pre server
>/usr/sbin/useradd -M -o -r -d /var/lib/mysql -s /bin/bash \
> -c "MySQL Server" -u 27 mysql > /dev/null 2>&1 || :

> That hasn't changed in quite a long time ... any thoughts why?  


I tried to run  


root@flokipal ~]# /usr/sbin/useradd -M -o -r -d /var/lib/mysql -s /bin/bash \
>  -c "MySQL Server" -u 27 mysql > /dev/null 2>&1 || ^C
[root@flokipal ~]# /usr/sbin/useradd -M -o -r -d /var/lib/mysql -s /bin/bash ^C
[root@flokipal ~]# /usr/sbin/useradd -M -o -r -d /var/lib/mysql -s /bin/bash 
useradd: -o flag is only allowed with the -u flag
Usage: useradd [options] LOGIN

Options:
  -b, --base-dir BASE_DIR       base directory for the home directory of the
                                new account
  -c, --comment COMMENT         GECOS field of the new account
  -d, --home-dir HOME_DIR       home directory of the new account
  -D, --defaults                print or change default useradd configuration
  -e, --expiredate EXPIRE_DATE  expiration date of the new account
  -f, --inactive INACTIVE       password inactivity period of the new account
  -g, --gid GROUP               name or ID of the primary group of the new
                                account
  -G, --groups GROUPS           list of supplementary groups of the new
                                account
  -h, --help                    display this help message and exit
  -k, --skel SKEL_DIR           use this alternative skeleton directory
  -K, --key KEY=VALUE           override /etc/login.defs defaults
  -l, --no-log-init             do not add the user to the lastlog and
                                faillog databases
  -m, --create-home             create the user's home directory
  -M, --no-create-home          do not create the user's home directory
  -N, --no-user-group           do not create a group with the same name as
                                the user
  -o, --non-unique              allow to create users with duplicate
                                (non-unique) UID
  -p, --password PASSWORD       encrypted password of the new account
  -r, --system                  create a system account
  -s, --shell SHELL             login shell of the new account
  -u, --uid UID                 user ID of the new account
  -U, --user-group              create a group with the same name as the user
  -Z, --selinux-user SEUSER     use a specific SEUSER for the SELinux user mapping

[root@flokipal ~]# /usr/sbin/useradd -M -o -r -d /var/lib/mysql -s /bin/bash -c "MySQL Server" -u 27 mysql 
useradd: user 'mysql' already exists
[root@flokipal ~]# service mysqld start 

Timeout error occurred trying to start MySQL Daemon.
Ræsi MySQL:                                                [VILLA]
[root@flokipal ~]# 
[root@flokipal ~]# service mysqld start 
^C
[root@flokipal ~]# service mysqld status
mysqld hefur verið stöðvað
[root@flokipal ~]#

Comment 3 Peter Vrabec 2009-11-18 13:32:24 UTC
hmm, I can't reproduce this problem:

# id mysql
uid=27(mysql) gid=27(mysql) groups=27(mysql)
You have new mail in /var/spool/mail/root
# userdel mysql
# /usr/sbin/useradd -M -o -r -d /var/lib/mysql -s /bin/bash  -c "MySQL Server" -u 27 mysql > /dev/null
# echo $?
0
# id mysql
uid=27(mysql) gid=483(mysql) groups=483(mysql)

Comment 4 Tom Lane 2009-11-19 00:21:09 UTC
I can't reproduce a problem either.  I installed a fresh F-12 machine today and did

sudo yum install mysql mysql-server

which correctly created the mysql user, and then

sudo service mysqld start

which worked fine.

I don't know what yumex is, maybe it is creating an issue?

Comment 5 Flóki Pálsson 2009-11-19 23:47:53 UTC
I dot know how I did this.
I reinstalled F12 and updated.
Then amarok 
and then installed mysql group from yumex.
Now mysql user was created.  No warning in yumex.
I can not recreate now.

Comment 6 Tom Lane 2009-11-20 06:04:30 UTC
Well, since none of the three of us can reproduce it, I think we're going to have to close this bug INSUFFICIENT_DATA.  If you can figure out what you did to make it go wrong, it'd be worth taking another look.

Comment 7 Juan P. Daza P. 2009-12-03 04:00:01 UTC
Closing until reporter provides more information.


Note You need to log in before you can comment on or make changes to this bug.