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(a)skalatan.de>
Sent: Monday, June 8, 2020 4:50 PM
To: Kamailio (SER) - Users Mailing List <sr-users(a)lists.kamailio.org>
Cc: Martin W Woscek <mwoscek(a)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<https://gilawa.com/>
From: sr-users
<sr-users-bounces@lists.kamailio.org<mailto: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<mailto: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