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(a)lists.iptel.org
[mailto:serusers-bounces@lists.iptel.org] On Behalf Of Henrik Pfluger
Sent: Thursday, 19 August 2004 9:55 AM
To: serusers(a)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(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers