[phpesp-dev] [ phpesp-Bugs-1073727 ] Unable to load ACL when using postgres

[SourceForge.net <no...@so...>]

Bugs item #1073727, was opened at 2004-11-26 13:57
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1073727&group_id=8956

Category: SQL
Group: v1.7
Status: Open
Resolution: None
Priority: 5
Submitted By: Massimiliano Pala (madwolf)
Assigned to: Nobody/Anonymous (nobody)
Summary: Unable to load ACL when using postgres

Initial Comment:
Hello,

I am trying to integrate phpESP in the UnoX1 project.
But I am
having some troubles with the DB support for PostgreSQL.
I can not access the phpESP admin interface because I
get the following message when loggin in:
============================================
HTTP 503 Service Unavailable
[ Unable to load ACL. (ERROR: permission denied for
relation designer) ]
============================================
I checked the SQL, it is ok (if I execute it on psql
command line I get
the right row):
============================================
SELECT * FROM designer WHERE username = 'root' AND
password = md5('esp') AND disabled = 'N' AND
(expiration = '0' OR expiration > CURRENT_TIMESTAMP)
============================================

Unfortunately the espauth-default.inc at line 137:

============================================
        // Execute the query and put recordset in $accres
        $accres = execute_sql( $sql, "",
ADODB_FETCH_ASSOC );

        if(!$accres) {
            header( 'HTTP/1.0 503 '. _('Service
Unavailable'));
            ....
            return(false);
        }
============================================

returns a '$accres' equal to 0 - this seems to be the
error.
Please let me  know if there is some fix or where I do
make mistakes (username and passwd are the default ones
and are
correct).

Postgresql version is 7.4.5-2 on Fedora Core 3.

Let me know,
Massimiliano Pala

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1073727&group_id=8956