Re: [SR-Users] [EXT] RE: kamailio 522 S-CSCF failing to start -UPDATE

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 &lt;hw(a)skalatan.de&gt; Sent: Monday, June 8, 2020 4:50 PM To: Kamailio (SER) - Users Mailing List &lt;sr-users(a)lists.kamailio.org&gt; Cc: Martin W Woscek &lt;mwoscek(a)mitre.org&gt; 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