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 <[email protected]>
Sent: Monday, June 8, 2020 4:50 PM
To: Kamailio (SER) - Users Mailing List <[email protected]>
Cc: Martin W Woscek <[email protected]>
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
<[email protected]<mailto:[email protected]>>
On Behalf Of Martin W Woscek
Sent: Monday, June 8, 2020 2:46 PM
To: Kamailio (SER) - Users Mailing List
<[email protected]<mailto:[email protected]>>
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
_______________________________________________
Kamailio (SER) - Users Mailing List
[email protected]
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
