Hello!
I'm using postgresql for the db backend for my ser instance, after creating and
populating
a few obvious tables by handI seem to have it "mostly working". ( using
ser-0.9.4 )
However, I'm stuck on the following:
Oct 18 21:09:36 server /usr/sbin/ser[23595]: ERROR: permissions: trusted_reload():
Database problem
Oct 18 21:09:36 server /usr/sbin/ser[23595]: init_trusted(): Reload of trusted table
failed
Oct 18 21:09:36 server /usr/sbin/ser[23595]: Error while initializing allow_trusted
function
Scratching my head, trying to figure out what might be causing that, but with no
success - any clues?
What I imagine is the relevant info:
server ser # psql -U ser -W ser
Password for user ser:
Welcome to psql 8.1.4, the PostgreSQL interactive terminal.
ser=# \dt
List of relations
Schema | Name | Type | Owner
--------+------------+-------+-------
public | subscriber | table | ser
public | trusted | table | ser
public | version | table | ser
(3 rows)
ser=# \d trusted
Table "public.trusted"
Column | Type | Modifiers
--------------+-----------------------+-----------
src_ip | character varying(39) | not null
proto | character varying(4) | not null
from_pattern | character varying(64) | not null
Indexes:
"trusted_pkey" PRIMARY KEY, btree (src_ip, proto, from_pattern)
Am I missing a table, or a column somewhere? Is this a ser issue, or a
db/sys-admin/permissions
issue? Should I also provide my ser.cfg?
Many thanks for any help/advice!
( also, is it possible to use the ser-0.10.x ser_postgres.sh/ser_dbtext.sh scripts
for ser-0.9.4, rather than doing it all by hand? )