[Serusers] dbtext module.

[Cesc]

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 at 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 at 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 at iptel.org
> http://mail.iptel.org/mailman/listinfo/serusers
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20050922/9728051e/attachment.htm>