You are missing the domain table ...
You may want to give a try to the dbtext-serctl script ... it is available in the openser cvs, or if you search this mail list for previous posts, you should also find it.
Cesc
On 9/22/05, Skimmer <skimmer@mail.ru> wrote:
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)
#
_______________________________________________
Serusers mailing list
Serusers@iptel.org
http://mail.iptel.org/mailman/listinfo/serusers