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) #
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