[Serusers] WG: UsrLoc update

[Zeus Ng]

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