I have installed DA-PgSQL v0.3 on our server with PHPPgAdmin and PostgreSQL 8.2.3. When I change the conf.inc.php and put
// Only show owned databases?
// Note: This will simply hide other databases in the list - this does
// not in any way prevent your users from seeing other database by
// other means. (eg. Run 'SELECT * FROM pg_database' in the SQL area.)
$conf['owned_only'] = true;
I get this error:
SQL error:
ERROR: missing FROM-clause entry for table "pu"
LINE 8: AND pu.usename='thecalls_bas'
^
In statement:
SELECT pdb.datname AS datname, pr.rolname AS datowner, pg_encoding_to_char(encoding) AS datencoding,
(SELECT description FROM pg_catalog.pg_shdescription pd WHERE pdb.oid=pd.objoid) AS datcomment,
(SELECT spcname FROM pg_catalog.pg_tablespace pt WHERE pt.oid=pdb.dattablespace) AS tablespace,
pg_catalog.pg_database_size(pdb.oid) as dbsize
FROM pg_catalog.pg_database pdb LEFT JOIN pg_catalog.pg_roles pr ON (pdb.datdba = pr.oid)
WHERE true
AND NOT pdb.datistemplate
AND pu.usename='thecalls_bas'
ORDER BY pdb.datname
Fatal error: Call to a member function on a non-object in /var/www/html/phpPgAdmin/classes/Misc.php on line 1538
If I put it back to false it runs normal but users can see the databases of other users. Does somebody now how to solve this?
// Only show owned databases?
// Note: This will simply hide other databases in the list - this does
// not in any way prevent your users from seeing other database by
// other means. (eg. Run 'SELECT * FROM pg_database' in the SQL area.)
$conf['owned_only'] = true;
I get this error:
SQL error:
ERROR: missing FROM-clause entry for table "pu"
LINE 8: AND pu.usename='thecalls_bas'
^
In statement:
SELECT pdb.datname AS datname, pr.rolname AS datowner, pg_encoding_to_char(encoding) AS datencoding,
(SELECT description FROM pg_catalog.pg_shdescription pd WHERE pdb.oid=pd.objoid) AS datcomment,
(SELECT spcname FROM pg_catalog.pg_tablespace pt WHERE pt.oid=pdb.dattablespace) AS tablespace,
pg_catalog.pg_database_size(pdb.oid) as dbsize
FROM pg_catalog.pg_database pdb LEFT JOIN pg_catalog.pg_roles pr ON (pdb.datdba = pr.oid)
WHERE true
AND NOT pdb.datistemplate
AND pu.usename='thecalls_bas'
ORDER BY pdb.datname
Fatal error: Call to a member function on a non-object in /var/www/html/phpPgAdmin/classes/Misc.php on line 1538
If I put it back to false it runs normal but users can see the databases of other users. Does somebody now how to solve this?