Bug 165670 - hsqldb user creates user account with wrong uid
hsqldb user creates user account with wrong uid
Product: Fedora
Classification: Fedora
Component: hsqldb (Show other bugs)
All Linux
medium Severity medium
: ---
: ---
Assigned To: Gary Benson
: 169364 (view as bug list)
Depends On:
Blocks: FC5Blocker
  Show dependency treegraph
Reported: 2005-08-11 06:10 EDT by Mephisto
Modified: 2007-11-30 17:11 EST (History)
5 users (show)

See Also:
Fixed In Version: hsqldb-1.80.1-1jpp_3fc
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed: 2005-10-25 05:12:39 EDT
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)

  None (edit)
Description Mephisto 2005-08-11 06:10:42 EDT
From Bugzilla Helper:
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8b3) Gecko/20050729 Fedora/1.1-0.2.5.deerpark.alpha2 Firefox/1.0+

Description of problem:
During installation, hsqldb creates a user called hsqldb and a group with the same name, but this user got the uid of 501 (in the user account range), causing it to appear on the gdm login screen. The same thing applies to the group id.

Version-Release number of selected component (if applicable):

How reproducible:
Didn't try

Steps to Reproduce:
1. Install hsqldb

Actual Results:  a user has been created with a user-account uid (501 on my system) (same thing for gid)

Expected Results:  a user should have been created with a low uid and gid, like somewhere in the 100's.

Additional info:
Comment 1 Gary Benson 2005-09-30 04:24:07 EDT
*** Bug 169364 has been marked as a duplicate of this bug. ***
Comment 2 Jeremy Katz 2005-10-17 10:56:55 EDT
Gary -- it would be very good to have this fixed for test1 which is fast
Comment 3 Gary Benson 2005-10-18 04:40:04 EDT
What uid and gid should I use?
Comment 4 Chris Lumens 2005-10-20 13:40:51 EDT
In your preinstall scriptlet, use groupadd -r, which will make groupadd use the
first availble gid lower than 499.  You are already using this on the useradd
command so I think you should be good on both counts if you fix up the groupadd.
Comment 5 Willem Riede 2005-10-26 18:59:56 EDT
When I installed fc5-devel on my x86_64, hsqldb %post created an 
ordinary user - as opposed to a system one with uid below 500 - 
which screwed up my NFS mounts as "wriede" is 500 on all my other 

install.log:Installing hsqldb-1.80.1-1jpp_1fc.x86_64.
install.log.syslog:<86>Oct 15 17:18:19 groupadd[4985]: new group: name=hsqldb,
install.log.syslog:<86>Oct 15 17:18:19 useradd[4986]: new user: name=hsqldb,
UID=500, GID=500, home=/var/lib/hsqldb, shell=/bin/sh

I also noted that a skeleton was created in /var/lib/hsqldb:

total 100
drwxr-xr-x   4 hsqldb hsqldb 4096 Oct 15 17:18 .
drwxr-xr-x  19 root   root   4096 Oct 22 11:16 ..
-rw-r--r--   1 hsqldb hsqldb   24 Oct 15 17:18 .bash_logout
-rw-r--r--   1 hsqldb hsqldb  191 Oct 15 17:18 .bash_profile
-rw-r--r--   1 hsqldb hsqldb  124 Oct 15 17:18 .bashrc
drwxr-xr-x   2 hsqldb hsqldb 4096 Aug  4 06:45 data
-rw-r--r--   1 hsqldb hsqldb  120 Oct 15 17:18 .gtkrc
drwxr-xr-x   2 root   root   4096 Oct 15 17:18 lib
-rw-r--r--   1 root   root    289 Aug  4 06:45 server.properties
-rw-------   1 hsqldb hsqldb 4301 Aug  4 06:45 sqltool.rc
-rw-r--r--   1 root   root    315 Aug  4 06:45 webserver.properties
-rw-r--r--   1 hsqldb hsqldb  658 Oct 15 17:18 .zshrc

I believe useradd should be run with both the -r and the -M flag
Comment 6 Gary Benson 2005-10-27 04:48:25 EDT
This should be fixed in hsqldb-1.80.1-1jpp_2fc and later.
Comment 7 Willem Riede 2005-10-27 18:00:14 EDT
I can confirm that this works OK with hsqldb-1.80.1-1jpp_3fc

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