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? )
Hi All Do SER supports 'rfc 3262 Reliability of Provisional Responses in SIP'? Is there any list of standards supported by SER available?? Regards Kamal Mann
On Thu, Oct 19, 2006 at 07:40:05AM +0200, Kamal.Mann@t-systems.com wrote:
Kamal,
In-Reply-To: 200610182141.20132.corey@bitworthy.net
please don't use REPLY if u wanna to ask something in the list. Just use "New mail" button!
Hi All Do SER supports 'rfc 3262 Reliability of Provisional Responses in SIP'? Is there any list of standards supported by SER available?? Regards Kamal Mann _______________________________________________ Serusers mailing list Serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
Hello,
Corey wrote:
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
there was a bug in postgres module, and unfortunately the SER packages do not contain the fix. Get the source from CVS (either branch rel_0_9_0 or HEAD) and compile it.
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? )
The database schemas have been changed a lot since 0.9.x, so the files in ser_db subdir describing the schema cannot be used for earlier versions.
Miklos
Serusers mailing list Serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
On Thursday 19 October 2006 01:00, Miklos Tirpak wrote:
Corey wrote:
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
there was a bug in postgres module, and unfortunately the SER packages do not contain the fix. Get the source from CVS (either branch rel_0_9_0 or HEAD) and compile it.
Cool, thanks for the info!
As an aside, I was able to temporarily workaround the problem by changing:
from: modparam("usrloc", "db_mode", 1)
to: modparam("usrloc", "db_mode", 0)
( 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? )
The database schemas have been changed a lot since 0.9.x, so the files in ser_db subdir describing the schema cannot be used for earlier versions.
Ah, ok - so next logical question ( which has probably been seen many times already? ): is there a 0.9.x version/port of the 'ser_mysql.sh' to postgres available anywhere?
Also - approximately how usable is the 0.10.x series at the moment ( for a non-production / experimental server )? "mostly usable/stable"?, "somewhat usable/stable"? "...good luck"?
Thanks again!
-
Alexandr Dubovikov -
Corey -
Kamal.Mann＠t-systems.com -
Miklos Tirpak