** Branch linked: lp:debian/postgresql-common
--
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to postgresql-common in Ubuntu.
https://bugs.launchpad.net/bugs/1329227
Title:
pg_createcluster crashes when a username or group is specified that
contains digits
Status in “postgresql-common” package in Ubuntu:
Fix Committed
Bug description:
pg_createcluster accepts options --user and --group to specify under
which credentials a new database cluster should be created. According
to the manual page, one may specify either a name or a UID/GID (as
digits).
The implementation, however, tests whether there is a digit in the
given string, not whether the entire string consists of digits. This
causes problems for me: I have a development system where each
developer creates databases and such per ticket. Users and groups are
created for this purpose, named "ticketNNN" where NNN is the number of
the ticket that the developer has been given to implement or bug fix.
But pg_createcluster does not like these user and group names, for
example "ticket123": it thinks I specified a UID/GID instead of a
name, and does the wrong thing. It crashes later on when tries to use
the string as a number. This is what it says on my Precise system
specifically:
Argument "ticket123" isn't numeric in getpwuid at
/usr/share/postgresql-common/PgCommon.pm line 790.
Argument "ticket123" isn't numeric in scalar assignment at
/usr/share/postgresql-common/PgCommon.pm line 796.
Argument "ticket123" isn't numeric in numeric ne (!=) at
/usr/share/postgresql-common/PgCommon.pm line 799.
This is because the test on line 237 of pg_createcluster:
$owneruid = (getpwnam $owneruid)[2] unless $owneruid =~ /\d+/;
is testing the wrong thing. I think it should read:
$owneruid = (getpwnam $owneruid)[2] unless $owneruid =~ /^\d+$/;
The same happens a few lines down with the group name.
My Ubuntu version information:
Description: Ubuntu 12.04.4 LTS
Release: 12.04
I'm using postgresql-common version 129ubuntu1.
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/postgresql-common/+bug/1329227/+subscriptions
--
Mailing list: https://launchpad.net/~desktop-packages
Post to : [email protected]
Unsubscribe : https://launchpad.net/~desktop-packages
More help : https://help.launchpad.net/ListHelp
