[Serusers] dbtext module. - sr-users

22 Sep 2005

Hello!

Could you help me?

I try to use ser with dbtext module.

In ser.cfg I have...
------------------------------------------------
...
loadmodule "/opt/sfw/lib/ser/modules/dbtext.so"
...
modparam("usrloc", "db_mode", 2)
modparam("usrloc|auth_db", "db_url", "/var/sertdb"
...

Where /var/sertdb - the path to text files (the tables)

I have the following tables:
-----------------------------------------------
root@Solaris>ls -l /var/sertdb/
total 6
-rw-rw-rw-   1 root     other         90 Sep 22 13:04 location
-rw-rw-rw-   1 root     other         59 Sep 22 12:26 subscriber
-rw-rw-rw-   1 root     other         59 Sep 22 13:07 version

The "Location" file
-----------------------------------------------
username(str) domain(str,null) contact(str) expires(int) q(double) callid(str) cseq(int)

But when I start ser I got the following messages in log:
-----------------------------------------------
Sep 22 13:32:19 Solaris ser[8611]: [ID 767465 daemon.warning] Warning: uac does not spread
accross the whole hash table
Sep 22 13:32:19 Solaris ser[8611]: [ID 736066 daemon.error] preload_udomain(): Error while
doing db_query
Sep 22 13:32:19 Solaris ser[8611]: [ID 247783 daemon.error] register_udomain(): Error
while preloading domain 'location'
Sep 22 13:32:19 Solaris ser[8611]: [ID 551419 daemon.error] domain_fixup(): Error while
registering domain

What is the problem? What I do wrong? 

                    Thank you.

Best regards.
          Simon.

-----------------ser.cfg-----------------------------
-----------------------------------------------------
check_via=no    # (cmd. line: -v)
dns=no           # (cmd. line: -r)
rev_dns=no      # (cmd. line: -R)
#port=5060
#children=4
fifo="/tmp/ser_fifo"

# ------------------ module loading ----------------------------------

# Uncomment this if you want to use SQL database
#loadmodule "/opt/sfw/lib/ser/modules/mysql.so"
loadmodule "/opt/sfw/lib/ser/modules/dbtext.so"

loadmodule "/opt/sfw/lib/ser/modules/sl.so"
loadmodule "/opt/sfw/lib/ser/modules/tm.so"
loadmodule "/opt/sfw/lib/ser/modules/rr.so"
loadmodule "/opt/sfw/lib/ser/modules/maxfwd.so"
loadmodule "/opt/sfw/lib/ser/modules/usrloc.so"
loadmodule "/opt/sfw/lib/ser/modules/registrar.so"

# Uncomment this if you want digest authentication
# mysql.so must be loaded !
#loadmodule "/opt/sfw/lib/ser/modules/auth.so"
#loadmodule "/opt/sfw/lib/ser/modules/auth_db.so"

# ----------------- setting module-specific parameters ---------------

# -- usrloc params --

#modparam("usrloc", "db_mode",   0)

# Uncomment this if you want to use SQL database
# for persistent storage and comment the previous line

modparam("usrloc", "db_mode", 2)
modparam("usrloc|auth_db", "db_url", "/var/sertdb"

modparam("usrloc", "user_column", "username"

# -- auth params --
# Uncomment if you are using auth module
#
#modparam("auth_db", "calculate_ha1", yes)
#