[Serusers] dbt_table_check_row: NULL value not allowed - field 7 - sr-users

2 Mar 2005


      hi,all list
i config dbtext in freebsd 4.10,ser0.8.14,and get
debug
DBT:dbt_table_check_row: NULL value not allowed - field
7
***********************
1(237) check_self - checking if port 5060 matches port
5060
1(237) check_nonce(): comparing [422583e1166b52f1b65007f2701c1f4845ff845f] and
[422583e1166b52f1b65007f2701c1f4845ff845f]
1(237) DBT:db_query: new res with 1
cols
1(237) DBT:dbt_result_new: new res with 1 cols
1(237) HA1 string calculated:
d1500a282a8f414cf66ebfb72c1dc749
1(237) check_response(): Our result =
'33871c1cced77ca171eeb83b402d72d8'
1(237) check_response(): Authorization is OK
1(237)
save_rpid(): rpid value is ''
1(237) parse_headers: flags=-1
1(237) parse_headers:
flags=33554432
1(237) DBT:dbt_table_check_row: NULL value not allowed - field 7
1(237)
DBT:db_insert: cannot insert the new row!!
1(237) DBT:db_insert: make clean!
1(237)
db_insert_ucontact(): Error while inserting contact
1(237) insert_ucontact(): Error while
inserting in database
1(237) insert(): Error while inserting contact
1(237) contacts():
Error while inserting record
1(237) parse_headers: flags=-1
1(237)
check_via_address(192.168.1.100, 192.168.1.100, 0)
1(237) DEBUG:destroy_avp_list:
destroing list 0x0
1(237) receive_msg: cleaning up
***********************
ser.cf
config
***********************
# Uncomment this if you want to use dbtext
database
loadmodule "/usr/local/lib/ser/modules/dbtext.so"
loadmodule
"/usr/local/lib/ser/modules/sl.so"
loadmodule
"/usr/local/lib/ser/modules/tm.so"
loadmodule
"/usr/local/lib/ser/modules/rr.so"
loadmodule
"/usr/local/lib/ser/modules/maxfwd.so"
loadmodule
"/usr/local/lib/ser/modules/usrloc.so"
loadmodule
"/usr/local/lib/ser/modules/registrar.so"
loadmodule
"/usr/local/lib/ser/modules/textops.so"
# Uncomment this if you want digest
authentication
# dbtext.so must be loaded !
loadmodule
"/usr/local/lib/ser/modules/auth.so"
loadmodule "/usr/local/lib/ser/modules/auth_db.so"
#
----------------- setting module-specific parameters ---------------
# -- usrloc params
--
#modparam("usrloc", "db_mode",   0)
# Uncomment this if you want to use dbtext
database
# for persistent storage and comment the previous line
modparam("usrloc",
"db_mode", 1)
modparam("usrloc", "db_url", "/usr/home/ser/db")
modparam("auth_db",
"db_url", "/usr/home/ser/db")
#modparam("usrloc", "db_url",
"dbtext://usr/home/ser/db")
#modparam("auth_db", "db_url", "dbtext://usr/home/ser/db")
#
-- auth params --
# Uncomment if you are using auth module
#
modparam("auth_db",
"calculate_ha1", 1)
#
# If you set "calculate_ha1" parameter to 1 (which true in this
config),
# uncomment also the following parameter)
#
modparam("auth_db",
"password_column", "password")
modparam("auth_db", "user_column",
"username")
modparam("auth_db", "domain_column", "domain")
# -- rr params --
# add value
to ;lr param to make some broken UAs happy
modparam("rr", "enable_full_lr", 1)
if
(!www_authorize("ser.fivewall.com", "subscriber")) {
www_challenge("ser.fivewall.com",
"0");
break;
};
save("location");
break;
};
***********************
aliases   (is all one
line)
***********************
username(str) domn(str,null) contact(str,null)
expires(int,null) q(double,null) callid(str,null) cseq(int,null) last_modified(str)
replicate(int,null) state(int,null) flags(int) user_agent(str)
received(str)
***********************
domain    (is all one
line)
***********************
domain(str,null)
ast_modified(str)
ser.fivewall.com:2005-03-01 09:58:33
***********************
location  (is all one
line)
***********************
username(str) domain(str,null) contact(str,null)
expires(int,null)
q(double,null) callid(str,null) cseq(int,null)
last_modified(str)
replicate(int,null) state(int,null) flags(int) user_agent(str)
received(str)
*********************** 
subscriber (is all one
line)
***********************
username(str) password(str) ha1(str) domain(str)
ha1b(str)
1001:1001:xxx:ser.fivewall.com:xxx
----
ZhongShan Ether Network Security Inc 
---------------------------------------------------------