Hello community ,
on kamailio server i'm using the module "ims_usrloc_scsc" with the following configuration : ......................................................... modparam("ims_usrloc_scscf", "db_url", "mysql://eyas:eyas@localhost/scscf") modparam("ims_usrloc_scscf", "db_mode", 1) modparam("ims_usrloc_scscf", "enable_debug_file", 0) modparam("ims_usrloc_scscf", "matching_mode", 0) modparam("ims_registrar_scscf", "error_reply_code", 503) ..........................................................
when i'm running kamailio and try to register i found the following :
Jul 04 16:03:59 S-CSCF [S-CSCF][3796]: ERROR: ims_usrloc_scscf [usrloc_db.c:235]: db_insert_impurecord(): Unable to insert impu into table [sip:09876993998148@NET.SYRIATEL] Jul 04 16:03:59 S-CSCF [S-CSCF][3796]: ERROR: ims_usrloc_scscf [udomain.c:580]: insert_impurecord(): error inserting contact into db Jul 04 16:03:59 S-CSCF [S-CSCF][3796]: ERROR: ims_usrloc_scscf [impurecord.c:974]: update_impurecord(): Unable to insert new IMPU for sip:09876993998148@NET.SYRIATEL Jul 04 16:03:59 S-CSCF [S-CSCF][3796]: ERROR: ims_registrar_scscf [save.c:809]: update_contacts(): Unable to update impurecord for sip:09876993998148@NET.SYRIATEL Jul 04 16:03:59 S-CSCF [S-CSCF][3796]: ERROR: ims_registrar_scscf [cxdx_sar.c:253]: async_cdp_callback(): Error processing REGISTER Jul 04 16:03:59 S-CSCF [S-CSCF][3796]: INFO: ims_registrar_scscf [cxdx_sar.c:84]: create_return_code(): created AVP successfully : [saa_return_code] - [-1] Jul 04 16:03:59 S-CSCF [S-CSCF][3796]: ERROR: <script>: SAR failure - error response sent from module Jul 04 16:04:04 S-CSCF [S-CSCF][3697]: INFO: ims_auth [cxdx_mar.c:79]: create_return_code(): created AVP successfully : [maa_return_code] - [-2] Jul 04 16:04:04 S-CSCF [S-CSCF][3814]: INFO: ims_auth [cxdx_avp.c:137]: cxdx_get_avp(): cxdx_get_experimental_result_code: Failed finding avp (avp_code = 297, vendor_id = 0) Jul 04 16:04:04 S-CSCF [S-CSCF][3814]: INFO: ims_auth [cxdx_mar.c:79]: create_return_code(): created AVP successfully : [maa_return_code] - [1] Jul 04 16:04:04 S-CSCF [S-CSCF][3694]: INFO: ims_auth [authorize.c:834]: authenticate(): uri=sip:NET.SYRIATEL;transport=TCP nonce=cae12e7c256b8a052ad9824ebb91fa07 response=ee82f8f8ad6bf4530d210144e Jul 04 16:04:04 S-CSCF [S-CSCF][3694]: INFO: ims_auth [authorize.c:886]: authenticate(): UE said: ee82f8f8ad6bf4530d210144eaf3c413 and we expect ee82f8f8ad6bf4530d210144eaf3c413 ha1 fd5e9c83ecc96ee Jul 04 16:04:04 S-CSCF [S-CSCF][3694]: INFO: ims_registrar_scscf [cxdx_sar.c:84]: create_return_code(): created AVP successfully : [saa_return_code] - [-2] Jul 04 16:04:04 S-CSCF [S-CSCF][3819]: INFO: ims_registrar_scscf [cxdx_avp.c:138]: cxdx_get_avp(): cxdx_get_experimental_result_code: Failed finding avp Jul 04 16:04:04 S-CSCF [S-CSCF][3819]: ERROR: ims_usrloc_scscf [usrloc_db.c:235]: db_insert_impurecord(): Unable to insert impu into table [sip:09876993998048@NET.SYRIATEL] Jul 04 16:04:04 S-CSCF [S-CSCF][3819]: ERROR: ims_usrloc_scscf [udomain.c:580]: insert_impurecord(): error inserting contact into db Jul 04 16:04:04 S-CSCF [S-CSCF][3819]: ERROR: ims_usrloc_scscf [impurecord.c:974]: update_impurecord(): Unable to insert new IMPU for sip:09876993998048@NET.SYRIATEL Jul 04 16:04:04 S-CSCF [S-CSCF][3819]: ERROR: ims_registrar_scscf [save.c:809]: update_contacts(): Unable to update impurecord for sip:09876993998048@NET.SYRIATEL Jul 04 16:04:04 S-CSCF [S-CSCF][3819]: ERROR: ims_registrar_scscf [cxdx_sar.c:253]: async_cdp_callback(): Error processing REGISTER
could any one tell me where was my wrong and why it can't write on the DB & thanks in advance