Problem:

The mysql db issues with the scscf db include: table version, disappearing impu and/or UE data retained in tables when none are registered

 

Workarround:

In order to get over those various mysql issues listed causing the S-CSCF not to come up properly as boot up,

  1. create a fresh new scscf database (kamadbctl [drop|create] scscf and import the msql script from the scscf configs)
  2. back up the new scscf db
  3. modify the init.d startup script for the scscf to restore the fresh db upon each start/restart of the S-CSCF

 

/etc/init.d/kamailio_scscf

..

case "$1" in
  start|debug)
        mysql -u root  --database=scscf < /etc/kamailio/ims_databases/scscf.sql

 

The S-CSCF has been stable and dependable on each boot.

 

_Martin

 

From: Henning Westerholt <hw@skalatan.de>
Sent: Monday, June 8, 2020 4:50 PM
To: Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.org>
Cc: Martin W Woscek <mwoscek@mitre.org>
Subject: [EXT] RE: kamailio 522 S-CSCF failing to start

 

Hello,

 

the error message below is from the DB startup version check. So do you have sometimes DB errors on this virtual machine?

 

Cheers,

 

Henning

 

--

Henning Westerholt – https://skalatan.de/blog/

Kamailio services – https://gilawa.com

 

From: sr-users <sr-users-bounces@lists.kamailio.org> On Behalf Of Martin W Woscek
Sent: Monday, June 8, 2020 2:46 PM
To: Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.org>
Subject: [SR-Users] kamailio 522 S-CSCF failing to start

 

Hello,

There are times that our S-CSCF module just wont start. I’ve tried correlating the issue with some operation such as not de-registering an IMS client (Boghe or imsdroid) prior to shutting down the Kamailio server.  But this isn’t always the case.  Being that we are running this an a Ubuntu Virtual Machine, simply overwriting the image with a backed up VM is the temporary solution.

 

I’ve dropped and created the db for S (kamdbctl) and rearranged the order of loading the presence module with same result.

 

Status of the S-CSCF daemon on failure to start:

# systemctl status kamailio_scscf
● kamailio_scscf.service - LSB: Start the Kamailio SIP proxy server
   Loaded: loaded (/etc/init.d/kamailio_scscf; generated)
   Active: inactive (dead)
     Docs: man:systemd-sysv-generator(8)

Jun 08 08:22:55 ubuntu /usr/local/sbin/kamailio[16511]: INFO: cdp [cdp_mod.c:255]: cdp_exit(): CDiameterPeer child stopping ...
Jun 08 08:22:55 ubuntu /usr/local/sbin/kamailio[16511]: INFO: cdp [cdp_mod.c:257]: cdp_exit(): ... CDiameterPeer child stopped
Jun 08 08:22:55 ubuntu /usr/local/sbin/kamailio[16511]: INFO: <core> [core/sctp_core.c:53]: sctp_core_destroy(): SCTP API not initialized
Jun 08 08:22:55 ubuntu kamailio_scscf[16495]:  *  already running
Jun 08 08:22:55 ubuntu kamailio_scscf[16495]:    ...done.
Jun 08 08:22:55 ubuntu systemd[1]: Started LSB: Start the Kamailio SIP proxy server.
Jun 08 08:24:03 ubuntu systemd[1]: Stopping LSB: Start the Kamailio SIP proxy server...
Jun 08 08:24:03 ubuntu kamailio_scscf[16517]:  * Stopping Kamailio IMS S-CSCF: kamailio_scscf
Jun 08 08:24:03 ubuntu kamailio_scscf[16517]:    ...done.
Jun 08 08:24:03 ubuntu systemd[1]: Stopped LSB: Start the Kamailio SIP proxy server.
root@ubuntu:~/IMS_manual_scripts# systemctl start kamailio_scscf
root@ubuntu:~/IMS_manual_scripts# systemctl status kamailio_scscf
● kamailio_scscf.service - LSB: Start the Kamailio SIP proxy server
   Loaded: loaded (/etc/init.d/kamailio_scscf; generated)
   Active: active (exited) since Mon 2020-06-08 08:27:23 EDT; 58s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 16543 ExecStart=/etc/init.d/kamailio_scscf start (code=exited, status=0/SUCCESS)

Jun 08 08:27:23 ubuntu /usr/local/sbin/kamailio[16559]: ERROR: <core> [db.c:457]: db_check_table_version(): invalid version 0 for table presentity found, expected 5 (check table structure and ta
Jun 08 08:27:23 ubuntu /usr/local/sbin/kamailio[16559]: ERROR: presence [presence.c:367]: mod_init(): error during table version check
Jun 08 08:27:23 ubuntu /usr/local/sbin/kamailio[16559]: ERROR: <core> [core/sr_module.c:898]: init_mod(): Error while initializing module presence (/usr/local/lib64/kamailio/modules/presence.so)
Jun 08 08:27:23 ubuntu /usr/local/sbin/kamailio[16559]: WARNING: <core> [core/mem/q_malloc.c:480]: qm_free(): WARNING: free(0) called from cdp_avp: cdp_avp_mod.c: cdp_avp_destroy(226)
Jun 08 08:27:23 ubuntu /usr/local/sbin/kamailio[16559]: INFO: cdp [cdp_mod.c:255]: cdp_exit(): CDiameterPeer child stopping ...
Jun 08 08:27:23 ubuntu /usr/local/sbin/kamailio[16559]: INFO: cdp [cdp_mod.c:257]: cdp_exit(): ... CDiameterPeer child stopped
Jun 08 08:27:23 ubuntu /usr/local/sbin/kamailio[16559]: INFO: <core> [core/sctp_core.c:53]: sctp_core_destroy(): SCTP API not initialized
Jun 08 08:27:23 ubuntu kamailio_scscf[16543]:  *  already running
Jun 08 08:27:23 ubuntu kamailio_scscf[16543]:    ...done.
Jun 08 08:27:23 ubuntu systemd[1]: Started LSB: Start the Kamailio SIP proxy server.

 

 

Any insight is appreciated.

 

Thanks,

_Martin