<div>You are missing the domain table ... </div>
<div> </div>
<div>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.</div>
<div> </div>
<div>Cesc<br><br> </div>
<div><span class="gmail_quote">On 9/22/05, <b class="gmail_sendername">Skimmer</b> <<a href="mailto:skimmer@mail.ru">skimmer@mail.ru</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Hello!<br><br>Could you help me?<br><br>I try to use ser with dbtext module.<br><br>In ser.cfg I have...<br>
------------------------------------------------<br>...<br>loadmodule "/opt/sfw/lib/ser/modules/dbtext.so"<br>...<br>modparam("usrloc", "db_mode", 2)<br>modparam("usrloc|auth_db", "db_url", "/var/sertdb"
<br>...<br><br>Where /var/sertdb - the path to text files (the tables)<br><br>I have the following tables:<br>-----------------------------------------------<br>root@Solaris>ls -l /var/sertdb/<br>total 6<br>-rw-rw-rw- 1 root other 90 Sep 22 13:04 location
<br>-rw-rw-rw- 1 root other 59 Sep 22 12:26 subscriber<br>-rw-rw-rw- 1 root other 59 Sep 22 13:07 version<br><br>The "Location" file<br>-----------------------------------------------
<br>username(str) domain(str,null) contact(str) expires(int) q(double) callid(str) cseq(int)<br><br>But when I start ser I got the following messages in log:<br>-----------------------------------------------<br>Sep 22 13:32:19 Solaris ser[8611]: [ID 767465
daemon.warning] Warning: uac does not spread accross the whole hash table<br>Sep 22 13:32:19 Solaris ser[8611]: [ID 736066 daemon.error] preload_udomain(): Error while doing db_query<br>Sep 22 13:32:19 Solaris ser[8611]: [ID 247783
daemon.error] register_udomain(): Error while preloading domain 'location'<br>Sep 22 13:32:19 Solaris ser[8611]: [ID 551419 daemon.error] domain_fixup(): Error while registering domain<br><br><br>What is the problem? What I do wrong?
<br><br> Thank you.<br><br>Best regards.<br> Simon.<br><br><br><br><br>-----------------ser.cfg-----------------------------<br>-----------------------------------------------------<br>check_via=no # (cmd. line: -v)
<br>dns=no # (cmd. line: -r)<br>rev_dns=no # (cmd. line: -R)<br>#port=5060<br>#children=4<br>fifo="/tmp/ser_fifo"<br><br># ------------------ module loading ----------------------------------<br><br>
# Uncomment this if you want to use SQL database<br>#loadmodule "/opt/sfw/lib/ser/modules/mysql.so"<br>loadmodule "/opt/sfw/lib/ser/modules/dbtext.so"<br><br>loadmodule "/opt/sfw/lib/ser/modules/sl.so"
<br>loadmodule "/opt/sfw/lib/ser/modules/tm.so"<br>loadmodule "/opt/sfw/lib/ser/modules/rr.so"<br>loadmodule "/opt/sfw/lib/ser/modules/maxfwd.so"<br>loadmodule "/opt/sfw/lib/ser/modules/usrloc.so"
<br>loadmodule "/opt/sfw/lib/ser/modules/registrar.so"<br><br><br># Uncomment this if you want digest authentication<br># mysql.so must be loaded !<br>#loadmodule "/opt/sfw/lib/ser/modules/auth.so"<br>
#loadmodule "/opt/sfw/lib/ser/modules/auth_db.so"<br><br># ----------------- setting module-specific parameters ---------------<br><br># -- usrloc params --<br><br>#modparam("usrloc", "db_mode", 0)
<br><br># Uncomment this if you want to use SQL database<br># for persistent storage and comment the previous line<br><br>modparam("usrloc", "db_mode", 2)<br>modparam("usrloc|auth_db", "db_url", "/var/sertdb"
<br><br>modparam("usrloc", "user_column", "username"<br><br># -- auth params --<br># Uncomment if you are using auth module<br>#<br>#modparam("auth_db", "calculate_ha1", yes)
<br>#<br><br>_______________________________________________<br>Serusers mailing list<br><a href="mailto:Serusers@iptel.org">Serusers@iptel.org</a><br><a href="http://mail.iptel.org/mailman/listinfo/serusers">http://mail.iptel.org/mailman/listinfo/serusers
</a><br></blockquote></div><br>