Hello,

did you upgrade the Kamailio only or also mysql server/client library? Is it Oracle's MySQL or MariaDB?

A while ago, there were a few reports of problems with mysql-client (Oracle) library on Ubuntu 16.04 and 18.04, which typically happened after upgrades of the library, as I understood, the upgrade brought in a dependency on libssl 1.1, while libssl1.0 was used by most of the other packages, resulting in mixed deployments. Upgrading to 20.04 seemed to solve it, as it came with libssl1.1 only.

Cheers,
Daniel

On 02.06.21 20:51, Andrew Chen wrote:
Hi all,

Today I upgraded Kamailio to 5.4.5 and a random crash was just reported in our crash monitoring script.  Below is the output of the crash:

#3  0x00007fa149ebe58d in ?? () from /usr/lib/x86_64-linux-gnu/kamailio/modules/tls.so

#4  0x00007fa14989e277 in ERR_clear_error () from /usr/lib/x86_64-linux-gnu/libcrypto.so.1.1

#5  0x00007fa149933d81 in X509_STORE_set_default_paths () from /usr/lib/x86_64-linux-gnu/libcrypto.so.1.1

#6  0x00007fa10310d374 in ?? () from /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20

#7  0x00007fa10310d9f3 in ?? () from /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20

#8  0x00007fa1030e0427 in mysql_real_connect () from /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20

#9  0x00007fa10368428c in db_mysql_new_connection () from /usr/lib/x86_64-linux-gnu/kamailio/modules/db_mysql.so

#10 0x00007fa1501f96dc in db_do_init2 () from /usr/lib/x86_64-linux-gnu/kamailio/libsrdb1.so.1

#11 0x00007fa1501f83f9 in db_do_init () from /usr/lib/x86_64-linux-gnu/kamailio/libsrdb1.so.1

#12 0x00007fa103689710 in db_mysql_init () from /usr/lib/x86_64-linux-gnu/kamailio/modules/db_mysql.so

#13 0x00007fa15062d35f in carrierroute_db_open () from /usr/lib/x86_64-linux-gnu/kamailio/modules/carrierroute.so

#14 0x00007fa1506719c6 in ?? () from /usr/lib/x86_64-linux-gnu/kamailio/modules/carrierroute.so


Is this crash due to libcrypto or mysql client?
Currently I have the following mysql client installed on the kamailio instance:

ii  libmysqlclient20:amd64               5.7.34-0ubuntu0.18.04.1             amd64        MySQL database client library

ii  mysql-client                         5.7.34-0ubuntu0.18.04.1             all          MySQL database client (metapackage depending on the latest version)

ii  mysql-client-5.7                     5.7.34-0ubuntu0.18.04.1             amd64        MySQL database client binaries

ii  mysql-client-core-5.7                5.7.34-0ubuntu0.18.04.1             amd64        MySQL database core client binaries

ii  mysql-common                         5.8+1.0.4                           all          MySQL database common files, e.g. /etc/mysql/my.cnf

root@ashintgtpsg51:/var/lib/cores # apt-cache madison mysql-client

mysql-client | 5.7.34-0ubuntu0.18.04.1 | http://us-east-1.ec2.archive.ubuntu.com/ubuntu bionic-updates/main amd64 Packages

mysql-client | 5.7.34-0ubuntu0.18.04.1 | http://security.ubuntu.com/ubuntu bionic-security/main amd64 Packages

mysql-client | 5.7.21-1ubuntu1 | http://us-east-1.ec2.archive.ubuntu.com/ubuntu bionic/main amd64 Packages

root@ashintgtpsg51:/var/lib/cores # 


Any suggestions would be greatly appreciated.
Thanks in advance.

--
Andy Chen
Sr. Telephony Lead Engineer



*Confidentiality Notice: The information contained in this e-mail and any
attachments may be confidential. If you are not an intended recipient, you
are hereby notified that any dissemination, distribution or copying of this
e-mail is strictly prohibited. If you have received this e-mail in error,
please notify the sender and permanently delete the e-mail and any
attachments immediately. You should not retain, copy or use this e-mail or
any attachment for any purpose, nor disclose all or any part of the
contents to any other person. Thank you.*
__________________________________________________________
Kamailio - Users Mailing List - Non Commercial Discussions
  * sr-users@lists.kamailio.org
Important: keep the mailing list in the recipients, do not reply only to the sender!
Edit mailing list options or unsubscribe:
  * https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
-- 
Daniel-Constantin Mierla -- www.asipto.com
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio Advanced Training - Online - June 7-10, 2021 (America Timezone)
  * https://www.asipto.com/sw/kamailio-advanced-training-online/