Rt 1.3.78 and postgres


#1

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

#2

Hiya. I just rolled a test release specifically to address your issue.
If you could download rt-1-3-79-test1 and tell me if it works any better.

    -jesseOn Tue, May 22, 2001 at 08:31:22PM +0200, Martin J. Laubach wrote:

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


Rt-devel mailing list
Rt-devel@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel

jesse reed vincent – root@eruditorum.orgjesse@fsck.com
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

Emacs is a pretty good operating system, but Unix has a better editor.