[OpenSIPS-Users] strange behaviour of SNMPstats and usrloc with and without mysql backend

[Marc Leurent]

Hello all, I have noticed something strange about snmpstats and usrloc...
Have you got any explanation for me?
Thanks!

When I set the usrloc | db_mode parameter to 0 or 1 (0 - This disables database completely. 1 - Write-Through scheme.)
I can get Contact data through the snmpstats module!
snmpwalk -c public -v 2c 127.0.0.1 .1.3.6.1.4.1.27483
...
OPENSER-SIP-SERVER-MIB::openserSIPContactDisplayName.2.1 = STRING: sip:02131150 at 14.38.160.13:5070
OPENSER-SIP-SERVER-MIB::openserSIPContactURI.1.1 = STRING: DefaultUser
OPENSER-SIP-SERVER-MIB::openserSIPContactURI.2.1 = STRING: sip:02131150 at 14.38.160.13:5070
...


but when I set  usrloc | db_mode parameter to 2 (2 - Write-Back scheme) I don't get anything from the snmpstats module
snmpwalk -c public -v 2c 127.0.0.1 .1.3.6.1.4.1.27483
OPENSER-SIP-SERVER-MIB::openserSIPContactDisplayName.1.1 = STRING: DefaultUser
OPENSER-SIP-SERVER-MIB::openserSIPContactURI.1.1 = STRING: DefaultUser
...

Have a nice day!
++


the part of my opensips.cfg file about usrloc params

# ----- usrloc params -----
/* modparam("usrloc", "db_mode",   X)
   for location entries
        0 - This disables database completely.
        1 - Write-Through scheme. All changes to usrloc are immediately reflected in database too.
        2 - Write-Back scheme. This is a combination of previous two schemes. All changes are made to memory and database synchronization is done in the timer.
        3 - DB-Only scheme. No memory cache is kept, all operations being directly performed with the database.
*/
modparam("usrloc", "db_mode", 1)
modparam("usrloc", "db_url", "mysql://opensips:UqwdwfuJ@localhost/opensips")
modparam("usrloc", "nat_bflag", 6)              # The index of the branch flag to be used as NAT marker (if the contact is or not natted).
modparam("usrloc", "use_domain", 0)             # If the domain part of the user should be also saved and used for identifing the user
modparam("usrloc", "desc_time_order", 0)        # If the user's contacts should be kept timestamp ordered; otherwise the contact will be ordered based on q value.
modparam("usrloc", "timer_interval", 30)        # The module uses timer to delete expired contacts, synchronize with database and other tasks, that need to be run periodically.
modparam("usrloc", "matching_mode", 0)          # What contact matching algorithm to be used. 0 - CONTACT ONLY based matching algorithm
modparam("usrloc", "cseq_delay", 20)            # Delay (in seconds) for accepting as retransmissions register requests with same Call-ID and Cseq.
modparam("usrloc", "fetch_rows", 2000)          # number of the rows to be fetched at once from database when loading the location records.
modparam("usrloc", "hash_size", 9)              # Number of entries of the hash table used by usrloc to store the location records is 2^hash_size.





-- --
Marc LEURENT
Ingénieur VoIP

DECKPOINT SA
Une société du groupe VTX Telecom
================================================================
Rue Eugène-Marziano 15 - 1227 Les Acacias
http://www.vtx.ch - marc.leurent at vtx-telecom.ch
----------------------------------------------------------------
VTX, votre partenaire telecom proche de vous !
================================================================