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