Closed Bug 285407 Opened 20 years ago Closed 20 years ago

User cannot log in on PostgreSQL

Categories

(Bugzilla :: User Accounts, defect, P1)

2.19.2
defect

Tracking

()

RESOLVED FIXED
Bugzilla 2.20

People

(Reporter: mkanat, Assigned: mkanat)

References

Details

Attachments

(1 file, 1 obsolete file)

This one's pretty easy: DBD::Pg::st execute failed: ERROR: pg_atoi: error in " . [for Statement "SELECT grantor_id FROM group_group_map WHERE member_id=? AND grant_type=' . GROUP_MEMBERSHIP . '"] at Bugzilla/User.pm line 480 Bugzilla::User::derive_groups('Bugzilla::User=HASH(0x8921fec)','undef') called at Bugzilla/User.pm line 138 Bugzilla::User::_create('Bugzilla::User','userid=?',1) called at Bugzilla/User.pm line 57 Bugzilla::User::new('Bugzilla::User',1) called at Bugzilla/Auth/Login/WWW.pm line 71 Bugzilla::Auth::Login::WWW::login('Bugzilla::Auth::Login::WWW',2) called at Bugzilla.pm line 64 Bugzilla::login('Bugzilla',2) called at /var/www/html/dbinstall/query.cgi line 63 Look at the quoting.
Attached patch Fix quoting (obsolete) (deleted) — Splinter Review
I don't even really know how this ran on MySQL. MySQL sure was um... nice to us. :-)
Attachment #176846 - Flags: review?(bugreport)
Status: NEW → ASSIGNED
Target Milestone: --- → Bugzilla 2.20
Actually, I'm going to expand the scope of the bug a little.
Summary: Bugzilla::User::derive_groups cannot run on PostgreSQL → User cannot log in on PostgreSQL
OK, two fixes to User.pm here. This also works on MySQL, tested.
Attachment #176846 - Attachment is obsolete: true
Attachment #176848 - Flags: review?(bugreport)
Attachment #176846 - Flags: review?(bugreport)
Priority: -- → P1
Comment on attachment 176848 [details] [diff] [review] Make it possible to login to a Pg installation r=joel by inspection
Attachment #176848 - Flags: review?(bugreport) → review+
Flags: approval?
Flags: approval? → approval+
Checking in Bugzilla/User.pm; /cvsroot/mozilla/webtools/bugzilla/Bugzilla/User.pm,v <-- User.pm new revision: 1.46; previous revision: 1.45 done
Status: ASSIGNED → RESOLVED
Closed: 20 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.

Attachment

General

Created:
Updated:
Size: