Re: [SR-Users] Issue with linking contact to IMPU on SCSCF

2018-01-01 Thread Abdelmuhaimen Seaudi
I am facing the same issue, and it's causing me not to be able to perform
any calls, instead i get user not found n HSS.

Abdelmuhaimen Seaudi, CCIE # 25265
Email: asea...@gmail.com
Skype: aseaudi
LinkedIn: www.linkedin.com/in/aseaudi
Telephone: +2012 84644 733


On Mon, Jan 1, 2018 at 3:17 PM, Rafi A.  wrote:

> Hi there,
>
>
>
> I need some help here to understand why  the query in [usrloc_db.c:1084] is
> empty. This causes the linking of contact to IMPU to fail.
>
> I’m using Kamailio 5.0.4.
>
>
>
>
>
> 10(13882) DEBUG: ims_usrloc_scscf [impurecord.c:1284]:
> unref_subscription_unsafe(): un-reffing subscription [
> r...@mnc001.mcc001.3gppnetwork.org] - was [3]
>
> 10(13882) DEBUG: ims_registrar_scscf [save.c:519]:
> update_contacts_helper(): updating the contacts for IMPU <
> sip:r...@mnc001.mcc001.3gppnetwork.org>
>
> 10(13882) DEBUG: ims_registrar_scscf [save.c:137]: calc_contact_expires():
> Calculated expires for contact is 60
>
> 10(13882) DEBUG: ims_registrar_scscf [save.c:548]:
> update_contacts_helper(): Need to update contact: <
> sip:rafi@192.168.10.48:57230;transport=udp>: q_value [-1],sos:
> [0],expires [60]
>
> 10(13882) DEBUG: ims_registrar_scscf [save.c:550]:
> update_contacts_helper(): packing contact information
>
> 10(13882) DEBUG: ims_registrar_scscf [save.c:556]:
> update_contacts_helper(): adding/updating contact based on prior existence
>
> 10(13882) DEBUG: ims_usrloc_scscf [impurecord.c:748]: get_scontact():
> looking for contact [sip:rafi@192.168.10.48:57230;transport=udp] in slot
> 300
>
> 10(13882) DEBUG: ims_registrar_scscf [save.c:562]:
> update_contacts_helper(): inserting new contact
>
> 10(13882) DEBUG: ims_usrloc_scscf [impurecord.c:562]: insert_scontact():
> INSERTing ucontact in usrloc module
>
> 10(13882) DEBUG: ims_usrloc_scscf [ucontact.c:118]: new_ucontact():
> Checking param [+g.3gpp.cs-voice]
>
> 10(13882) DEBUG: ims_usrloc_scscf [ucontact.c:118]: new_ucontact():
> Checking param [+g.3gpp.icsi-ref]
>
> 10(13882) DEBUG: ims_usrloc_scscf [ucontact.c:118]: new_ucontact():
> Checking param [audio]
>
> 10(13882) DEBUG: ims_usrloc_scscf [ucontact.c:118]: new_ucontact():
> Checking param [+g.oma.sip-im.large-message]
>
> 10(13882) DEBUG: ims_usrloc_scscf [ucontact.c:118]: new_ucontact():
> Checking param [+g.3gpp.smsip]
>
> 10(13882) DEBUG: ims_usrloc_scscf [ucontact.c:118]: new_ucontact():
> Checking param [language]
>
> 10(13882) DEBUG: ims_usrloc_scscf [ucontact.c:118]: new_ucontact():
> Checking param [+g.oma.sip-im]
>
> 10(13882) DEBUG: ims_usrloc_scscf [ucontact.c:118]: new_ucontact():
> Checking param [expires]
>
> 10(13882) DEBUG: ims_usrloc_scscf [ucontact.c:173]: new_ucontact():
> generating hash based on [sip:rafi@192.168.10.48:57230;transport=udp]
>
> 10(13882) DEBUG: ims_usrloc_scscf [impurecord.c:280]:
> mem_insert_scontact(): Created new contact in memory with AOR: [
> sip:rafi@192.168.10.48:57230;transport=udp] and hash [300]
>
> 10(13882) DEBUG: ims_usrloc_scscf [usrloc_db.c:289]: db_insert_ucontact():
> DB: inserting ucontact [sip:rafi@192.168.10.48:57230;transport=udp]
>
> 10(13882) DEBUG: ims_usrloc_scscf [usrloc_db.c:311]: db_insert_ucontact():
> Converted params to string to insert into db: [+g.3gpp.cs-voice;+g.3gpp.icsi
> -ref=urn%3Aurn-7%3A3gpp-application.ims.iari.gsma-vs;audio;+
> g.oma.sip-im.large-message;+g.3gpp.smsip;language=en,fr;+g.
> oma.sip-im;expires=60]
>
> 10(13882) DEBUG: ims_usrloc_scscf [udomain.c:843]: ref_contact_unsafe():
> incrementing ref count on contact [sip:rafi@192.168.10.48:57230;
> transport=udp], was 1
>
> 10(13882) DEBUG: ims_usrloc_scscf [impurecord.c:1225]:
> link_contact_to_impu(): number of contacts for IMPU [
> sip:r...@mnc001.mcc001.3gppnetwork.org] is 1
>
> 10(13882) DEBUG: ims_usrloc_scscf [usrloc_db.c:1065]:
> db_link_contact_to_impu(): DB: linking contact to IMPU
>
> 10(13882) DEBUG: ims_usrloc_scscf [usrloc_db.c:1084]:
> db_link_contact_to_impu(): QUERY IS [] and len is 0
>
> 10(13882) ERROR: db_mysql [km_dbase.c:128]: db_mysql_submit_query():
> driver error on query: Query was empty (1065)
>
> 10(13882) ERROR:  [db_query.c:181]: db_do_raw_query(): error while
> submitting query
>
> 10(13882) ERROR: ims_usrloc_scscf [usrloc_db.c:1086]:
> db_link_contact_to_impu(): Unable to link impu-contact in DB - impu [
> sip:r...@mnc001.mcc001.3gppnetwork.org], contact [
> sip:rafi@192.168.10.48:57230;transport=udp]
>
> 10(13882) ERROR: ims_usrloc_scscf [impurecord.c:1227]:
> link_contact_to_impu(): Failed to update DB linking contact [
> sip:rafi@192.168.10.48:57230;transport=udp] to IMPU [
> sip:r...@mnc001.mcc001.3gppnetwork.org]...continuing but db will be out
> of sync!
>
> 10(13882) DEBUG: ims_usrloc_scscf [udomain.c:852]: unref_contact_unsafe():
> decrementing ref count on contact [sip:rafi@192.168.10.48:57230;
> transport=udp], was 2
>
>
>
> Best Regards,
>
> Rafael A.
>
>
>
>
>
> ___
> Kamailio (SER) - Users Mailing List
> sr-users@lists.kamailio.org
> htt

Re: [SR-Users] Kamailio fail to start with db_mongodb and ndb_mongodb modules

2018-01-01 Thread Abdul Basit
Hi,

My last email was help for admin review.

Sharing logs through pastebin https://pastebin.com/6HhdYLJK

Interesting part will start from line 983 where it start initializing
ndb_mongodb.



On 1 January 2018 at 20:32, Abdul Basit  wrote:

> Hi,
>
> I enabled but kamailio didn't generate any dump file
> To enable code dump followed https://www.kamailio.org/dokuwiki/doku.php/
> troubleshooting:corefiles
>
> I also un-commented lines in /etc/init.d/kamailio script
>
> if test "$DUMP_CORE" = "yes" ; then
> # set proper ulimit
> ulimit -c unlimited
>
> # directory for the core dump files
> COREDIR=/tmp/corefiles
> [ -d $COREDIR ] || mkdir -p $COREDIR
> chmod 777 $COREDIR
> echo "$COREDIR/core.%e.sig%s.%p" > /proc/sys/kernel/core_pattern
> fi
>
>
> I think reason is that kamailio process didn't exit after crash and keep
> on restarting. each time with new PID.
>
> However, debug file is attached. I hope this will help.
>
>
> --
> regards,
>
> abdul basit
>
> On 29 December 2017 at 20:11, M S  wrote:
>
>> Hi,
>>
>> Enable core dump and provide backtrace of sigfault. See this for more
>> info,
>>
>> https://sourceware.org/gdb/onlinedocs/gdb/Backtrace.html
>>
>> Thank you.
>>
>>
>>
>> On Fri, Dec 29, 2017 at 12:25 PM, Abdul Basit 
>> wrote:
>>
>>> Adding further from https://stackoverflow.com/ques
>>> tions/2549214/interpreting-segfault-messages
>>>
>>> error 6 means, fault is
>>>
>>> *  bit 2 == 1 means kernel, 1 means user-mode
>>> *  bit 4 == 1 means fault was an instruction fetch
>>>
>>> That looks like kamailio is trying to invoke for db connection where
>>> libmongo-c don't like to be.
>>>
>>> --
>>> regards,
>>>
>>> abdul basit
>>>
>>>
>>> On 29 December 2017 at 15:39, Abdul Basit  wrote:
>>>
 Hi,

 I am trying to setup mongo db as database engine for kamailio as
 described at
 
 http://www.kamailio.org/wiki/tutorials/kamailio-and-mongodb
 and
 https://telerain.com/kamailio

 OS: Debian GNU/Linux 8.10 (jessie)
 MongoDB server version: 3.4.10
 mongo-c-driver-1.9.0.tar.gz compiled with
 ./configure --disable-static --disable-silent-rules
 --enable-debug-symbols --enable-ssl=no --enable-sasl=yes
 --with-libbson=bundled --enable-optimizations 
 --disable-automatic-init-and-c
 leanup

 version: kamailio 5.0.4 (x86_64/linux)
 flags: STATS: Off, USE_TCP, USE_TLS, USE_SCTP, TLS_HOOKS,
 DISABLE_NAGLE, USE_MCAST, DNS_IP_HACK, SHM_MEM, SHM_MMAP, PKG_MALLOC,
 Q_MALLOC, F_MALLOC, TLSF_MALLOC, DBG_SR_MEMORY, USE_FUTEX,
 FAST_LOCK-ADAPTIVE_WAIT, USE_DNS_CACHE, USE_DNS_FAILOVER, USE_NAPTR,
 USE_DST_BLACKLIST, HAVE_RESOLV_RES
 ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN 16,
 MAX_URI_SIZE 1024, BUF_SIZE 65535, DEFAULT PKG_SIZE 8MB
 poll method support: poll, epoll_lt, epoll_et, sigio_rt, select.
 id: unknown
 compiled on 20:45:44 Dec 27 2017 with gcc 4.9.2

 include_modules= utils app_lua db_postgres json evapi db_mongodb
 ndb_mongodb

 Kamailio is crashing with segfault as soon as it try to load libmongo-c

 Dec 28 04:44:14 sipserver systemd[1]: Starting Kamailio (OpenSER) - the
 Open Source SIP Server...
 Dec 28 04:44:14 sipserver kamailio: INFO:  [core/sctp_core.c:75]:
 sctp_core_check_support(): SCTP API not enabled - if you want to use it,
 load sctp module
 Dec 28 04:44:14 sipserver kamailio: INFO: 
 [core/tcp_main.c:4671]: init_tcp(): using epoll_lt as the io watch method
 (auto detected)
 Dec 28 04:44:14 sipserver kamailio[11685]: Listening on
 Dec 28 04:44:14 sipserver kamailio[11685]: udp: 127.0.0.1:5060
 Dec 28 04:44:14 sipserver kamailio[11685]: udp: 192.168.10.20:5060
 Dec 28 04:44:14 sipserver kamailio[11685]: tcp: 127.0.0.1:5060
 Dec 28 04:44:14 sipserver kamailio[11685]: tcp: 192.168.10.20:5060
 Dec 28 04:44:14 sipserver kamailio[11685]: Aliases:
 Dec 28 04:44:14 sipserver kamailio[11685]: tcp: localhost:5060
 Dec 28 04:44:14 sipserver kamailio[11685]: udp: localhost:5060
 Dec 28 04:44:14 sipserver /usr/local/sbin/kamailio[11687]: INFO: rr
 [../outbound/api.h:52]: ob_load_api(): unable to import bind_ob - maybe
 module is not loaded
 Dec 28 04:44:14 sipserver /usr/local/sbin/kamailio[11687]: INFO: rr
 [rr_mod.c:175]: mod_init(): outbound module not available
 Dec 28 04:44:14 sipserver /usr/local/sbin/kamailio[11687]: INFO:
  [core/udp_server.c:153]: probe_max_receive_buffer(): SO_RCVBUF is
 initially 212992
 Dec 28 04:44:14 sipserver /usr/local/sbin/kamailio[11687]: INFO:
  [core/udp_server.c:203]: probe_max_receive_buffer(): SO_RCVBUF is
 finally 425984
 Dec 28 04:44:14 sipserver /usr/local/sbin/kamailio[11687]: INFO:
  [core/udp_server.c:153]: probe_max_receive_buffer(): SO_RCVBUF is
 initially 212992
 Dec 28 04:44:14 sipserver 

[SR-Users] Issue with linking contact to IMPU on SCSCF

2018-01-01 Thread Rafi A.
Hi there,

 

I need some help here to understand why  the query in [usrloc_db.c:1084] is
empty. This causes the linking of contact to IMPU to fail.

I'm using Kamailio 5.0.4.

 

 

10(13882) DEBUG: ims_usrloc_scscf [impurecord.c:1284]:
unref_subscription_unsafe(): un-reffing subscription
[r...@mnc001.mcc001.3gppnetwork.org] - was [3]

10(13882) DEBUG: ims_registrar_scscf [save.c:519]: update_contacts_helper():
updating the contacts for IMPU 

10(13882) DEBUG: ims_registrar_scscf [save.c:137]: calc_contact_expires():
Calculated expires for contact is 60

10(13882) DEBUG: ims_registrar_scscf [save.c:548]: update_contacts_helper():
Need to update contact: :
q_value [-1],sos: [0],expires [60]

10(13882) DEBUG: ims_registrar_scscf [save.c:550]: update_contacts_helper():
packing contact information

10(13882) DEBUG: ims_registrar_scscf [save.c:556]: update_contacts_helper():
adding/updating contact based on prior existence

10(13882) DEBUG: ims_usrloc_scscf [impurecord.c:748]: get_scontact():
looking for contact [sip:rafi@192.168.10.48:57230;transport=udp] in slot 300

10(13882) DEBUG: ims_registrar_scscf [save.c:562]: update_contacts_helper():
inserting new contact

10(13882) DEBUG: ims_usrloc_scscf [impurecord.c:562]: insert_scontact():
INSERTing ucontact in usrloc module

10(13882) DEBUG: ims_usrloc_scscf [ucontact.c:118]: new_ucontact(): Checking
param [+g.3gpp.cs-voice]

10(13882) DEBUG: ims_usrloc_scscf [ucontact.c:118]: new_ucontact(): Checking
param [+g.3gpp.icsi-ref]

10(13882) DEBUG: ims_usrloc_scscf [ucontact.c:118]: new_ucontact(): Checking
param [audio]

10(13882) DEBUG: ims_usrloc_scscf [ucontact.c:118]: new_ucontact(): Checking
param [+g.oma.sip-im.large-message]

10(13882) DEBUG: ims_usrloc_scscf [ucontact.c:118]: new_ucontact(): Checking
param [+g.3gpp.smsip]

10(13882) DEBUG: ims_usrloc_scscf [ucontact.c:118]: new_ucontact(): Checking
param [language]

10(13882) DEBUG: ims_usrloc_scscf [ucontact.c:118]: new_ucontact(): Checking
param [+g.oma.sip-im]

10(13882) DEBUG: ims_usrloc_scscf [ucontact.c:118]: new_ucontact(): Checking
param [expires]

10(13882) DEBUG: ims_usrloc_scscf [ucontact.c:173]: new_ucontact():
generating hash based on [sip:rafi@192.168.10.48:57230;transport=udp]

10(13882) DEBUG: ims_usrloc_scscf [impurecord.c:280]: mem_insert_scontact():
Created new contact in memory with AOR:
[sip:rafi@192.168.10.48:57230;transport=udp] and hash [300]

10(13882) DEBUG: ims_usrloc_scscf [usrloc_db.c:289]: db_insert_ucontact():
DB: inserting ucontact [sip:rafi@192.168.10.48:57230;transport=udp]

10(13882) DEBUG: ims_usrloc_scscf [usrloc_db.c:311]: db_insert_ucontact():
Converted params to string to insert into db:
[+g.3gpp.cs-voice;+g.3gpp.icsi-ref=urn%3Aurn-7%3A3gpp-application.ims.iari.g
sma-vs;audio;+g.oma.sip-im.large-message;+g.3gpp.smsip;language=en,fr;+g.oma
.sip-im;expires=60]

10(13882) DEBUG: ims_usrloc_scscf [udomain.c:843]: ref_contact_unsafe():
incrementing ref count on contact
[sip:rafi@192.168.10.48:57230;transport=udp], was 1

10(13882) DEBUG: ims_usrloc_scscf [impurecord.c:1225]:
link_contact_to_impu(): number of contacts for IMPU
[sip:r...@mnc001.mcc001.3gppnetwork.org] is 1

10(13882) DEBUG: ims_usrloc_scscf [usrloc_db.c:1065]:
db_link_contact_to_impu(): DB: linking contact to IMPU

10(13882) DEBUG: ims_usrloc_scscf [usrloc_db.c:1084]:
db_link_contact_to_impu(): QUERY IS [] and len is 0

10(13882) ERROR: db_mysql [km_dbase.c:128]: db_mysql_submit_query(): driver
error on query: Query was empty (1065)

10(13882) ERROR:  [db_query.c:181]: db_do_raw_query(): error while
submitting query

10(13882) ERROR: ims_usrloc_scscf [usrloc_db.c:1086]:
db_link_contact_to_impu(): Unable to link impu-contact in DB - impu
[sip:r...@mnc001.mcc001.3gppnetwork.org], contact
[sip:rafi@192.168.10.48:57230;transport=udp]

10(13882) ERROR: ims_usrloc_scscf [impurecord.c:1227]:
link_contact_to_impu(): Failed to update DB linking contact
[sip:rafi@192.168.10.48:57230;transport=udp] to IMPU
[sip:r...@mnc001.mcc001.3gppnetwork.org]...continuing but db will be out of
sync!

10(13882) DEBUG: ims_usrloc_scscf [udomain.c:852]: unref_contact_unsafe():
decrementing ref count on contact
[sip:rafi@192.168.10.48:57230;transport=udp], was 2

 

Best Regards,

Rafael A.

 

 

___
Kamailio (SER) - Users Mailing List
sr-users@lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users


Re: [SR-Users] error when brining up scscf in kamailio 5.1

2018-01-01 Thread Abdelmuhaimen Seaudi
Hi, I solved this issue by loading presence module first before loading
ims_usrloc_scscf.

Jan  1 06:52:49 olc-dd kamailio[20800]: DEBUG: 
[core/sr_module.c:982]: init_mod(): ims_usrloc_scscf
Jan  1 06:52:49 olc-dd kamailio[20800]: INFO: ims_usrloc_scscf
[hslot.c:69]: ul_init_locks(): locks array size 512
Jan  1 06:52:49 olc-dd kamailio[20800]: INFO: ims_usrloc_scscf
[contact_hslot.c:67]: init_contacts_locks(): locks array size 512
Jan  1 06:52:49 olc-dd kamailio[20800]: INFO: ims_usrloc_scscf
[hslot_sp.c:70]: subs_init_locks(): locks array size 512
Jan  1 06:52:49 olc-dd kamailio[20800]: DEBUG: 
[core/sr_module.c:707]: find_mod_export_record(): found export of
 in module presence
[/usr/local/lib64/kamailio/modules/presence.so]
Jan  1 06:52:49 olc-dd kamailio[20800]: DEBUG: 
[core/sr_module.c:707]: find_mod_export_record(): found export of
 in module ims_dialog
[/usr/local/lib64/kamailio/modules/ims_dialog.so]
Jan  1 06:52:49 olc-dd kamailio[20800]: DEBUG: ims_usrloc_scscf
[ims_usrloc_scscf_mod.c:397]: mod_init():  DLGCB_CREATED created
successfully


Abdelmuhaimen Seaudi, CCIE # 25265
Email: asea...@gmail.com
Skype: aseaudi
LinkedIn: www.linkedin.com/in/aseaudi
Telephone: +2012 84644 733


On Mon, Jan 1, 2018 at 12:31 AM, Abdelmuhaimen Seaudi 
wrote:

> Hi,
>
> After configuring scscf.cfg + kamailio.cfg + scscf.xml, I cannot start
> scscf, as I get the below error " can't bind presence"
>
> I tried commenting out the lines loading the presence module, but it seems
> this is not relevant.
>
> How can I try troubleshoot this issue ?
>
> Dec 31 17:22:55 olc-dd scscf[6659]: DEBUG:  [core/sr_module.c:982]:
> init_mod(): ims_usrloc_scscf
> Dec 31 17:22:55 olc-dd scscf[6659]: INFO: ims_usrloc_scscf [hslot.c:69]:
> ul_init_locks(): locks array size 512
> Dec 31 17:22:55 olc-dd scscf[6659]: INFO: ims_usrloc_scscf
> [contact_hslot.c:67]: init_contacts_locks(): locks array size 512
> Dec 31 17:22:55 olc-dd scscf[6659]: INFO: ims_usrloc_scscf
> [hslot_sp.c:70]: subs_init_locks(): locks array size 512
> Dec 31 17:22:55 olc-dd scscf[6659]: DEBUG:  [core/sr_module.c:714]:
> find_mod_export_record(): export of  not found (flags 0)
> Dec 31 17:22:55 olc-dd scscf[6659]: ERROR: ims_usrloc_scscf
> [ims_usrloc_scscf_mod.c:292]: mod_init(): can't bind presence
> Dec 31 17:22:55 olc-dd scscf[6659]: ERROR:  [core/sr_module.c:984]:
> init_mod(): Error while initializing module ims_usrloc_scscf
> (/usr/local/lib64/kamailio/modules/ims_usrloc_scscf.so)
> Dec 31 17:22:55 olc-dd scscf[6659]: DEBUG: debugger [debugger_api.c:1267]:
> dbg_destroy_mod_levels(): Destroyed _dbg_mod_table, size 32
> Dec 31 17:22:55 olc-dd scscf[6659]: DEBUG: cdp_avp [cdp_avp_mod.c:224]:
> cdp_avp_destroy(): Destroying module cdp_avp
> Dec 31 17:22:55 olc-dd scscf[6659]: INFO: cdp [cdp_mod.c:257]: cdp_exit():
> CDiameterPeer child stopping ...
> Dec 31 17:22:55 olc-dd scscf[6659]: INFO: cdp [diameter_peer.c:364]:
> diameter_peer_destroy(): destroy_diameter_peer(): Terminating all
> children...
> Dec 31 17:22:55 olc-dd scscf[6659]: INFO: cdp [diameter_peer.c:383]:
> diameter_peer_destroy(): destroy_diameter_peer(): All processes terminated.
> Cleaning up.
>
>
> Abdelmuhaimen Seaudi, CCIE # 25265
> Email: asea...@gmail.com
> Skype: aseaudi
> LinkedIn: www.linkedin.com/in/aseaudi
> Telephone: +2012 84644 733
>
>
___
Kamailio (SER) - Users Mailing List
sr-users@lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users


Re: [SR-Users] error when creating scscf database in kamailio 5.1

2018-01-01 Thread Abdelmuhaimen Seaudi
I solved this issue by creating the tables using LATIN1 character set,
which made the key length less than the default limit of 767 bytes.

CREATE TABLE `contact` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `contact` char(255) NOT NULL,
  `params` varchar(255) DEFAULT NULL,
  `path` varchar(255) DEFAULT NULL,
  `received` varchar(255) DEFAULT NULL,
  `user_agent` varchar(255) DEFAULT NULL,
  `expires` datetime DEFAULT NULL,
  `callid` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `contact` (`contact`))
  ENGINE=InnoDB DEFAULT CHARSET=latin1;

Abdelmuhaimen Seaudi, CCIE # 25265
Email: asea...@gmail.com
Skype: aseaudi
LinkedIn: www.linkedin.com/in/aseaudi
Telephone: +2012 84644 733


On Sun, Dec 31, 2017 at 11:17 PM, Abdelmuhaimen Seaudi 
wrote:

> Hi,
>
> i am upgrading from kamailio 4.x to 5.1, and when i try to create the
> scscf databse, i get the below error
>
> I tried correcting this by removing the indexes, but the ims did not work
> properly, with lots of inconsistency in registering, and cannot make calls.
>
> what is the correct way to handle this error ?
>
> root@olc-dd:/usr/local/src/kamailio-5.1/kamailio/utils/kamctl/mysql#
> mysql -uroot scscf < ims_usrloc_scscf-create.sql
> ERROR 1071 (42000) at line 2: Specified key was too long; max key length
> is 767 bytes
>
> Thanks.
>
> Abdelmuhaimen Seaudi, CCIE # 25265
> Email: asea...@gmail.com
> Skype: aseaudi
> LinkedIn: www.linkedin.com/in/aseaudi
> Telephone: +2012 84644 733
>
>
___
Kamailio (SER) - Users Mailing List
sr-users@lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users


[SR-Users] Issue with linking contact to IMPU

2018-01-01 Thread Rafi A.
Hi there,

 

I need some help here to understand why  the query in [usrloc_db.c:1084] is
empty. This causes the linking of contact to IMPU to fail.

I'm using Kamailio 5.0.4.

 

 

10(13882) DEBUG: ims_usrloc_scscf [impurecord.c:1284]:
unref_subscription_unsafe(): un-reffing subscription
[r...@mnc001.mcc001.3gppnetwork.org] - was [3]

10(13882) DEBUG: ims_registrar_scscf [save.c:519]: update_contacts_helper():
updating the contacts for IMPU 

10(13882) DEBUG: ims_registrar_scscf [save.c:137]: calc_contact_expires():
Calculated expires for contact is 60

10(13882) DEBUG: ims_registrar_scscf [save.c:548]: update_contacts_helper():
Need to update contact: :
q_value [-1],sos: [0],expires [60]

10(13882) DEBUG: ims_registrar_scscf [save.c:550]: update_contacts_helper():
packing contact information

10(13882) DEBUG: ims_registrar_scscf [save.c:556]: update_contacts_helper():
adding/updating contact based on prior existence

10(13882) DEBUG: ims_usrloc_scscf [impurecord.c:748]: get_scontact():
looking for contact [sip:rafi@192.168.10.48:57230;transport=udp] in slot 300

10(13882) DEBUG: ims_registrar_scscf [save.c:562]: update_contacts_helper():
inserting new contact

10(13882) DEBUG: ims_usrloc_scscf [impurecord.c:562]: insert_scontact():
INSERTing ucontact in usrloc module

10(13882) DEBUG: ims_usrloc_scscf [ucontact.c:118]: new_ucontact(): Checking
param [+g.3gpp.cs-voice]

10(13882) DEBUG: ims_usrloc_scscf [ucontact.c:118]: new_ucontact(): Checking
param [+g.3gpp.icsi-ref]

10(13882) DEBUG: ims_usrloc_scscf [ucontact.c:118]: new_ucontact(): Checking
param [audio]

10(13882) DEBUG: ims_usrloc_scscf [ucontact.c:118]: new_ucontact(): Checking
param [+g.oma.sip-im.large-message]

10(13882) DEBUG: ims_usrloc_scscf [ucontact.c:118]: new_ucontact(): Checking
param [+g.3gpp.smsip]

10(13882) DEBUG: ims_usrloc_scscf [ucontact.c:118]: new_ucontact(): Checking
param [language]

10(13882) DEBUG: ims_usrloc_scscf [ucontact.c:118]: new_ucontact(): Checking
param [+g.oma.sip-im]

10(13882) DEBUG: ims_usrloc_scscf [ucontact.c:118]: new_ucontact(): Checking
param [expires]

10(13882) DEBUG: ims_usrloc_scscf [ucontact.c:173]: new_ucontact():
generating hash based on [sip:rafi@192.168.10.48:57230;transport=udp]

10(13882) DEBUG: ims_usrloc_scscf [impurecord.c:280]: mem_insert_scontact():
Created new contact in memory with AOR:
[sip:rafi@192.168.10.48:57230;transport=udp] and hash [300]

10(13882) DEBUG: ims_usrloc_scscf [usrloc_db.c:289]: db_insert_ucontact():
DB: inserting ucontact [sip:rafi@192.168.10.48:57230;transport=udp]

10(13882) DEBUG: ims_usrloc_scscf [usrloc_db.c:311]: db_insert_ucontact():
Converted params to string to insert into db:
[+g.3gpp.cs-voice;+g.3gpp.icsi-ref=urn%3Aurn-7%3A3gpp-application.ims.iari.g
sma-vs;audio;+g.oma.sip-im.large-message;+g.3gpp.smsip;language=en,fr;+g.oma
.sip-im;expires=60]

10(13882) DEBUG: ims_usrloc_scscf [udomain.c:843]: ref_contact_unsafe():
incrementing ref count on contact
[sip:rafi@192.168.10.48:57230;transport=udp], was 1

10(13882) DEBUG: ims_usrloc_scscf [impurecord.c:1225]:
link_contact_to_impu(): number of contacts for IMPU
[sip:r...@mnc001.mcc001.3gppnetwork.org] is 1

10(13882) DEBUG: ims_usrloc_scscf [usrloc_db.c:1065]:
db_link_contact_to_impu(): DB: linking contact to IMPU

10(13882) DEBUG: ims_usrloc_scscf [usrloc_db.c:1084]:
db_link_contact_to_impu(): QUERY IS [] and len is 0

10(13882) ERROR: db_mysql [km_dbase.c:128]: db_mysql_submit_query(): driver
error on query: Query was empty (1065)

10(13882) ERROR:  [db_query.c:181]: db_do_raw_query(): error while
submitting query

10(13882) ERROR: ims_usrloc_scscf [usrloc_db.c:1086]:
db_link_contact_to_impu(): Unable to link impu-contact in DB - impu
[sip:r...@mnc001.mcc001.3gppnetwork.org], contact
[sip:rafi@192.168.10.48:57230;transport=udp]

10(13882) ERROR: ims_usrloc_scscf [impurecord.c:1227]:
link_contact_to_impu(): Failed to update DB linking contact
[sip:rafi@192.168.10.48:57230;transport=udp] to IMPU
[sip:r...@mnc001.mcc001.3gppnetwork.org]...continuing but db will be out of
sync!

10(13882) DEBUG: ims_usrloc_scscf [udomain.c:852]: unref_contact_unsafe():
decrementing ref count on contact
[sip:rafi@192.168.10.48:57230;transport=udp], was 2

 

 

 

___
Kamailio (SER) - Users Mailing List
sr-users@lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users


[SR-Users] Happy New Year 2018!

2018-01-01 Thread Daniel-Constantin Mierla
A Happy And Prosperous Year 2018 to everyone using Kamailio and helping
to improve the project!

Looking forward to meeting many of you around this world during 2018 and
collaborate online in a friendly environment!

Daniel

-- 
Daniel-Constantin Mierla
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio Advanced Training - www.asipto.com
Kamailio World Conference - May 14-16, 2018 - www.kamailioworld.com


___
Kamailio (SER) - Users Mailing List
sr-users@lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users