From 4f25eedf9065f28badf1e5e1df6c925062d8279e Mon Sep 17 00:00:00 2001 From: "mkanat%kerio.com" <> Date: Fri, 8 Jul 2005 09:31:41 +0000 Subject: Bug 285695: [PostgreSQL] Username checks for login, etc. need to be case insensitive Patch By Max Kanat-Alexander r=LpSolit, a=justdave --- checksetup.pl | 9 +++++---- 1 file changed, 5 insertions(+), 4 deletions(-) (limited to 'checksetup.pl') diff --git a/checksetup.pl b/checksetup.pl index cd991d561..42582fa65 100755 --- a/checksetup.pl +++ b/checksetup.pl @@ -4155,7 +4155,7 @@ if ($sth->rows == 0) { } } $sth = $dbh->prepare("SELECT login_name FROM profiles " . - "WHERE login_name = ?"); + "WHERE " . $dbh->sql_istrcmp('login_name', '?')); $sth->execute($login); if ($sth->rows > 0) { print "$login already has an account.\n"; @@ -4258,9 +4258,10 @@ if ($sth->rows == 0) { } # Put the admin in each group if not already - my $userid = $dbh->selectrow_array( - "SELECT userid FROM profiles WHERE login_name = ?", undef, $login); - + my $userid = $dbh->selectrow_array("SELECT userid FROM profiles WHERE " . + $dbh->sql_istrcmp('login_name', '?'), + undef, $login); + # Admins get explicit membership and bless capability for the admin group my ($admingroupid) = $dbh->selectrow_array("SELECT id FROM groups WHERE name = 'admin'"); -- cgit v1.2.3-24-g4f1b