[rt-devel] rt 1.3.78 and postgres

[Martin J. Laubach]

  I have been following the rt progress for a couple of weeks now,
and previous versions didn't do so well with my pet database (postgres),
however, 1.3.78 has really come close to working out of the box.

  I got the web interface to work, can futz around with various settings
and open tickets.

  However, the mail interface does not work at all:

| cactus# ./rt-mailgate -v -q general -a correspond < ~mjl/dead.letter
| Create user failed in mailgateway: Name in use
| Name in useNo recipient addresses found in header
| Couldn't load from the users database.
| Can't call method "fetchrow" on an undefined value at /usr/pkg/lib/perl5/
|	site_perl/5.6.0/DBIx/SearchBuilder/Handle.pm line 352.

  And the log file shows

| cactus# cat /tmp/rt.log
| Create user failed in mailgateway: Name in use
| Name in useUse of uninitialized value in concatenation (.) at
|	/usr/local/rt/lib/RT/CurrentUser.pm line 79.
| Couldn't load from the users database.
| Use of uninitialized value in concatenation (.) at
|	/usr/local/rt/lib/RT/User.pm line 841.
| Use of uninitialized value in concatenation (.) at
|	/usr/local/rt/lib/RT/User.pm line 855.
| DBD::Pg::st execute failed: ERROR:  parser: parse error at or near ")"
| RT::Handle=HASH(0x80f3778) couldn't execute the query 'SELECT COUNT(ACL.id)
| FROM ACL, GroupMembers, Groups WHERE  ((((((RightScope = 'Queue') AND
| (RightAppliesTo = 1))) AND ((RightName = 'CreateTicket'))) OR
| ((RightName = 'SuperUser') AND (RightScope = 'System') AND
| (RightAppliesTo = 0)))  AND (((ACL.PrincipalType = 'Group') AND
| (ACL.PrincipalId = Groups.Id) AND (GroupMembers.GroupId = Groups.Id)  AND
| (GroupMembers.UserId = ))))'ERROR:  parser: parse error at or near ")"
| 
| Can't call method "fetchrow" on an undefined value at /usr/pkg/lib/perl5/
|	site_perl/5.6.0/DBIx/SearchBuilder/Handle.pm line 352.


  Note the "(GroupMembers.UserId = )" in the sql statement above, 
this is the reason it breaks. As to why there is nothing at the right
of the =, no clue...

  Any ideas?

	mjl