I am running Ser 0.8.12 using PostgreSQL. I am using a regular table as the location table and a SQL view as the alias table and configured Ser like this:
modparam("usrloc", "db_mode", 1) modparam("usrloc", "db_url", "sql://*********" ) modparam("usrloc", "timer_interval", 30 )
Location lookup works fine. But when I make changes to the alias view Ser seems to never update its internal database to reflect the changes in the database. Only after restarting Ser it is being updated.
Anyone has experienced this before?
Regards,
Henrik Pfluger
SER build its SQL database content base on the memory version, not the other way around. The only time SER refresh its memory content with SQL database is at startup time. You should use 'serctl' to update the alias and SER will reflect the change in SQL DB. Updating the SQL DB directly will not work.
Zeus
-----Original Message----- From: serusers-bounces@lists.iptel.org [mailto:serusers-bounces@lists.iptel.org] On Behalf Of Henrik Pfluger Sent: Thursday, 19 August 2004 9:55 AM To: serusers@lists.iptel.org Subject: [Serusers] WG: UsrLoc update
I am running Ser 0.8.12 using PostgreSQL. I am using a regular table as the location table and a SQL view as the alias table and configured Ser like this:
modparam("usrloc", "db_mode", 1) modparam("usrloc", "db_url", "sql://*********" ) modparam("usrloc", "timer_interval", 30 )
Location lookup works fine. But when I make changes to the alias view Ser seems to never update its internal database to reflect the changes in the database. Only after restarting Ser it is being updated.
Anyone has experienced this before?
Regards,
Henrik Pfluger
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
At 01:54 AM 8/19/2004, Henrik Pfluger wrote:
I am running Ser 0.8.12 using PostgreSQL. I am using a regular table as the location table and a SQL view as the alias table and configured Ser like this:
modparam("usrloc", "db_mode", 1) modparam("usrloc", "db_url", "sql://*********" ) modparam("usrloc", "timer_interval", 30 )
Location lookup works fine. But when I make changes to the alias view Ser seems to never update its internal database to reflect the changes in the database. Only after restarting Ser it is being updated.
Anyone has experienced this before?
Everybody did. That's how SER's memory cache works. To change aliases access SER's memory cache, e.g., using serctl utility.
-jiri
Regards,
Henrik Pfluger
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
-- Jiri Kuthan http://iptel.org/~jiri/
-
Henrik Pfluger -
Jiri Kuthan -
Zeus Ng