18 Aug
2004
18 Aug
'04
11:54 p.m.
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
19 Aug
19 Aug
1:02 a.m.
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
1:52 p.m.
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(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
--
Jiri Kuthan http://iptel.org/~jiri/
7271
days inactive
7272
days old
2 comments
3 participants
participants (3)
-
Henrik Pfluger -
Jiri Kuthan -
Zeus Ng