[SR-Users] Unable to insert impu into table

[eyas barhouk]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20180704/b4e16041/attachment.html>