receive the ERROR: req: Permission denied

Good morning,

I trying setup the helpdesk teacup. There is an option to have requesters
to send request through email by adding the following Perl CGI to the
aliases file.

helpdesk: "|/usr/bin/perl /home/httpd/cgi-bin/teacup/teacupmail.pl"

When I sent mail to helpdesk. I get the following error from the database
and email.

ERROR: req: Permission denied
See Email below.
Here are the database tables permissions from the tm=# \dpS and tm=#
select * from req; commands
tm=# \dpS
Access permissions for database "tm"
Relation | Access permissions
----------+-------------------------------------------------
conf | {"=","postgres=arwR","httpd=arwR","mail=r"}
log | {"=","postgres=arwR","httpd=arwR","mail=ar"}
pr | {"=","postgres=arwR","httpd=arwR","mail=ar"}
req | {"=arwR","postgres=arwR","httpd=arwR","mail=r"}
tech | {"=","postgres=arwR","httpd=arwR","mail=r"}
(5 rows)

tm=# select * from req;
***(Single step mode: Verify
query)*********************************************
select * from req;
***(press return to proceed or enter x and return to
cancel)********************

name | value
---------+--------------------------------
Unknown | mmauney(at)fosters(dot)torrentnet(dot)com
(1 row)

I also try to change the privilege for the table req by
tm-#GRANT ALL ON req TO PUBLIC;
Here is the Return email error.

The original message was received at Thu, 13 Sep 2001 11:08:06 GMT
from mmauney(at)localhost

----- The following addresses had permanent fatal errors -----
"|/usr/bin/perl /usr/local/apache/cgi-bin/teacupmail.pl"
(reason: internal software error)
(expanded from: <helpdesk(at)fosters(dot)torrentnet(dot)com>)

----- Transcript of session follows -----
A database error occurred: Error running SQL query select max(id) from pr
where id between '2001090000' and '2001099999': ERROR: pr:
Permission denied.

Your PR was not properly submitted. Please contact the Teacup PRMS
administrator at your site for assistance.

Stack trace:
Exception::Throw (called from
/usr/local/lib/perl5/site_perl/5.005/i386-freebsd/Teacup/Database.pm line
884)
Teacup::Database::dbp_Error (called from
/usr/local/lib/perl5/site_perl/5.005/i386-freebsd/Teacup/Database.pm line
817)
Teacup::Database::dbp_QuerySQL (called from
/usr/local/lib/perl5/site_perl/5.005/i386-freebsd/Teacup/Database.pm line
597)
Teacup::Database::db_GetNextID (called from
/usr/local/lib/perl5/site_perl/5.005/i386-freebsd/Teacup.pm line 241)
Teacup::tc_Submit (called from /usr/local/apache/cgi-bin/teacupmail.pl
line 49)
554 5.3.0 "|/usr/bin/perl /usr/local/apache/cgi-bin/teacupmail.pl"...
Internal error

[ Part 2: "Delivery Status" ]

Reporting-MTA: dns; fosters.torrentnet.com
Arrival-Date: Thu, 13 Sep 2001 11:08:06 GMT

Final-Recipient: RFC822; helpdesk(at)fosters(dot)torrentnet(dot)com
X-Actual-Recipient: X-Unix; |/usr/bin/perl
/usr/local/apache/cgi-bin/teacupmail.pl
Action: failed
Status: 5.5.0
Diagnostic-Code: X-Unix; 70
Last-Attempt-Date: Thu, 13 Sep 2001 11:08:06 GMT

[ Part 3: "Included Message" ]

Thanks

Michael

>