[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 07:57
Message generated for change (Settings changed) made by greggmc
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1073727&group_id=8956

Category: SQL
Group: v1.7
>Status: Closed
>Resolution: Works For Me
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

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

Comment By: Massimiliano Pala (madwolf)
Date: 2004-12-03 04:52

Message:
Logged In: YES 
user_id=170877

Access to the DB using the configured user/passwd via pgsql
is ok.
Issuing the command that retrieves the user in the psql it
worked fine. I solved the problem by altering the user's
grant. I gave the user 'superuser' rights by issuing "ALTER
USER unox1 CREATEDB CREATEUSER".

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

Comment By: Matthew Gregg (greggmc)
Date: 2004-12-02 10:59

Message:
Logged In: YES 
user_id=14116

This works ok for me here...
The error reported "ERROR: permission denied for
relation designer"  makes me think it's a Postgresql
permission problem.  Can the same host, user, password
you've configured in phpESP.ini.php connect and access the
"designer" table using the psql client?

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

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