FW: [Serusers] ser live database and mysql

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(a)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(a)iptel.org [mailto:serusers-bounces@lists.iptel.org] On Behalf Of Richard C. Thompson Sent: Monday, January 23, 2006 9:55 PM To: serusers(a)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