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