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