FW: [Serusers] ser live database and mysql - sr-users

24 Jan 2006


      Frank
Thanks for the reply
I thought that setting "modparam("usrloc", "db_mode", 2)" to 1 did the same
thing. ie it updates the table whenever anything changes. I had it set to 1
but the "location" sql database swelled to over 9000 and ser wouldn't
restart until I truncated the table. My concern is that ser can't delete
records in sql even though I checked the grants and privileges for user ser
and they seem to be ok. Also serctl alias rm doesn't remove the aliases
record from the table, again an issue with grants. But serctl alias add
works.
| Grants for ser@localhost
|
+---------------------------------------------------------------------------
--------+
| GRANT USAGE ON *.* TO 'ser'@'localhost' IDENTIFIED BY PASSWORD
'*******************************' |
| GRANT ALL PRIVILEGES ON `ser`.* TO 'ser'@'localhost'
|
+---------------------------------------------------------------------------
--------+
Got any ideas?
Rick
_____
From: Frank Fischer [mailto:frank.fischer@digitalnomads.ch] 
Sent: Tuesday, January 24, 2006 3:25 AM
To: RThompson@vir2com.com
Subject: RE: [Serusers] ser live database and mysql
ser keeps the location table in memory for performance reasons and does
synchronisation with the backend database sometimes. As far as i understand,
this could lead to differences between in-memory data and in database-data.
To avoid this situation and force SER to write all data to the database, you
could use the experimental module "usrloc-cl". It works fine for me.
- Frank
_____
From: serusers-bounces@iptel.org [mailto:serusers-bounces@lists.iptel.org] On
Behalf Of Richard C. Thompson
Sent: Monday, January 23, 2006 9:55 PM
To: serusers@lists.iptel.org
Subject: [Serusers] ser live database and mysql
Hi all
Hopefully someone can answer this.
I am running ser with mysql and I have noticed that serctl moni shows a
smaller number in "location" than the mysql "location" table.
Eg
serctl moni shows 404 in location
mysql shows 556 in location
I have
modparam("usrloc", "db_mode", 2)
even when I refresh the sql query many times over a long time, the tables
never match.
It seems that ser can't delete some of the entries
Any help or hints would be appreciated
Rick