Author Topic: insufficient permissions Query postgresql  (Read 4047 times)

Offline bab

  • Newbie
  • *
  • Posts: 1
insufficient permissions Query postgresql
« on: September 06, 2006, 11:34:22 AM »
I am not exactly shre where to post becuase I get the exact same error in roundcube_webmail_0.1-beta2.tar.gz  as in the svn from Sept 06

DB Error in /home/bab/public_html/webmail/beta2/program/include/rcube_db.inc (479): DB Error: insufficient permissions Query: SELECT vars, ip, EXTRACT (EPOCH FROM changed) AS changed FROM session WHERE sess_id='39c5f5f5ec7cb6fc7a98626b52d95f9a' [nativecode=ERROR: permission denied for relation session]

Fatal error: Call to a member function on a non-object in /home/bab/public_html/webmail/beta2/program/include/rcube_db.inc on line 367

not really sure what it means


My system stats are
Linux iama.neurd.org 2.6.8-3-686-smp #1 SMP Sat Jul 15 08:52:57 UTC 2006 i686 GNU/Linux
psql (PostgreSQL) 8.1.3
Server version: Apache/2.0.54
Server built:  Jul 28 2006 09:04:55

any help would be greatly appericate any help, I have never had roundcube working

Offline bithive

  • Newbie
  • *
  • Posts: 2
insufficient permissions Query postgresql
« Reply #1 on: July 25, 2008, 02:14:03 PM »
You need to run this in the psql shell:

Code: [Select]
grant select on session to public;