receive the ERROR: req: Permission denied - Mailing list pgsql-novice

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@fosters.torrentnet.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@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@fosters.torrentnet.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@fosters.torrentnet.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

>