[sr-dev] [kamailio/kamailio] Kamailio failed to autostart on reboot with MySQL database (#925)

[Fyodor]

MYIP = my server ip
MYDOMAIN = my domain name

syslog:
```
Jan 13 04:18:19 kaf kamailio[1153]: loading modules under config path: /usr/lib/x86_64-linux-gnu/kamailio/modules/
Jan 13 04:18:19 kaf kamailio[1153]: Listening on
Jan 13 04:18:19 kaf kamailio[1153]:              udp: MYIP:5776
Jan 13 04:18:19 kaf kamailio[1153]:              tcp: MYIP:5776
Jan 13 04:18:19 kaf kamailio[1153]:              tls: MYIP:5777
Jan 13 04:18:19 kaf kamailio[1153]: Aliases:
Jan 13 04:18:19 kaf kamailio[1153]:              tls: MYDOMAIN:5777
Jan 13 04:18:19 kaf kamailio[1153]:              tcp: MYDOMAIN:5776
Jan 13 04:18:19 kaf kamailio[1153]:              udp: MYDOMAIN:5776
Jan 13 04:18:20 kaf systemd[1]: kamailio.service: Control process exited, code=exited status=255
Jan 13 04:18:20 kaf systemd[1]: Failed to start Kamailio (OpenSER) - the Open Source SIP Server.
Jan 13 04:18:20 kaf systemd[1]: kamailio.service: Unit entered failed state.
Jan 13 04:18:20 kaf systemd[1]: kamailio.service: Failed with result 'exit-code'.
```

`/etc/init.d/mysql-kamailio start` works fine (kamailio starts)
`service kamailio start` - works fine
mysql start fine

kamailio.log:
```
Jan 13 04:18:19 kaf kamailio: INFO: tls [tls_init.c:403]: init_tls_compression(): tls: init_tls: disabling compression...
Jan 13 04:18:19 kaf kamailio: INFO: <core> [sctp_core.c:74]: sctp_core_check_support(): SCTP API not enabled - if you want to use it, load sctp module
Jan 13 04:18:19 kaf kamailio: INFO: <core> [tcp_main.c:4656]: init_tcp(): using epoll_lt as the io watch method (auto detected)
Jan 13 04:18:20 kaf /usr/sbin/kamailio[1276]: INFO: rr [../outbound/api.h:54]: ob_load_api(): Failed to import bind_ob
Jan 13 04:18:20 kaf /usr/sbin/kamailio[1276]: INFO: rr [rr_mod.c:174]: mod_init(): outbound module not available
Jan 13 04:18:20 kaf /usr/sbin/kamailio[1276]: INFO: usrloc [hslot.c:51]: ul_init_locks(): locks array size 1024
Jan 13 04:18:20 kaf /usr/sbin/kamailio[1276]: INFO: auth [auth_mod.c:333]: mod_init(): auth: qop set, but nonce-count (nc_enabled) support disabled
Jan 13 04:18:20 kaf /usr/sbin/kamailio[1276]: INFO: tls [tls_mod.c:362]: mod_init(): With ECDH-Support!
Jan 13 04:18:20 kaf /usr/sbin/kamailio[1276]: INFO: tls [tls_mod.c:365]: mod_init(): With Diffie Hellman
Jan 13 04:18:20 kaf /usr/sbin/kamailio[1276]: INFO: tls [tls_init.c:591]: init_tls_h(): tls: _init_tls_h:  compiled  with  openssl  version "OpenSSL 1.0.2g  1 Mar 2016" (0x1000207f), kerberos support: off, compression: on
Jan 13 04:18:20 kaf /usr/sbin/kamailio[1276]: INFO: tls [tls_init.c:599]: init_tls_h(): tls: init_tls_h: installed openssl library version "OpenSSL 1.0.2g  1 Mar 2016" (0x1000207f), kerberos support: off,  zlib compression: off#012 compiler: cc -I. -I.. -I../include  -fPIC -DOPENSSL_PIC -DOPENSSL_THREADS -D_REENTRANT -DDSO_DLFCN -DHAVE_DLFCN_H -m64 -DL_ENDIAN -g -O2 -fstack-protector-strong -Wformat -Werror=format-security -Wdate-time -D_FORTIFY_SOURCE=2 -Wl,-Bsymbolic-functions -Wl,-z,relro -Wa,--noexecstack -Wall -DMD32_REG_T=int -DOPENSSL_IA32_SSE2 -DOPENSSL_BN_ASM_MONT -DOPENSSL_BN_ASM_MONT5 -DOPENSSL_BN_ASM_GF2m -DSHA1_ASM -DSHA256_ASM -DSHA512_ASM -DMD5_ASM -DAES_ASM -DVPAES_ASM -DBSAES_ASM -DWHIRLPOOL_ASM -DGHASH_ASM -DECP_NISTZ256_ASM
Jan 13 04:18:20 kaf /usr/sbin/kamailio[1276]: WARNING: tls [tls_init.c:653]: init_tls_h(): tls: openssl bug #1491 (crash/mem leaks on low memory) workaround enabled (on low memory tls operations will fail preemptively) with free memory thresholds 7864320 and 3932160 bytes
Jan 13 04:18:20 kaf /usr/sbin/kamailio[1276]: INFO: <core> [cfg/cfg_ctx.c:608]: cfg_set_now(): INFO: cfg_set_now(): tls.low_mem_threshold1 has been changed to 7864320
Jan 13 04:18:20 kaf /usr/sbin/kamailio[1276]: INFO: <core> [cfg/cfg_ctx.c:608]: cfg_set_now(): INFO: cfg_set_now(): tls.low_mem_threshold2 has been changed to 3932160
Jan 13 04:18:20 kaf /usr/sbin/kamailio[1276]: ERROR: db_mysql [km_my_con.c:124]: db_mysql_new_connection(): driver error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Jan 13 04:18:20 kaf /usr/sbin/kamailio[1276]: ERROR: <core> [db.c:318]: db_do_init2(): could not add connection to the pool
Jan 13 04:18:20 kaf /usr/sbin/kamailio[1276]: ERROR: usrloc [dlist.c:637]: register_udomain(): failed to open database connection
Jan 13 04:18:20 kaf /usr/sbin/kamailio[1276]: ERROR: registrar [reg_mod.c:561]: domain_fixup(): failed to register domain
Jan 13 04:18:20 kaf /usr/sbin/kamailio[1276]: ERROR: <core> [route.c:1153]: fix_actions(): fixing failed (code=-1) at cfg:/etc/kamailio/kamailio.cfg:676
Jan 13 04:18:20 kaf /usr/sbin/kamailio[1276]: ERROR: <core> [route.c:1153]: fix_actions(): fixing failed (code=-1) at cfg:/etc/kamailio/kamailio.cfg:678
Jan 13 04:18:20 kaf /usr/sbin/kamailio[1276]: INFO: <core> [sctp_core.c:53]: sctp_core_destroy(): SCTP API not initialized
```






-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/kamailio/kamailio/issues/925
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20170112/37591ad4/attachment-0001.html>