<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
And I just enabled log_level=4 </div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
It connects to db (mysql 8.0.26-1debian11) and converting password string to val, then segfault</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:db_mysql:db_mysql_do_prepared_query: conn=0x7f6d33facd80 (tail=140107000235208) MC=0x7f6d33fac560
<div>Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:db_mysql:db_mysql_do_prepared_query: new query=|select password,rpid from subscriber where username=?|</div>
<div>Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:db_mysql:re_init_statement: query is <select password,rpid from subscriber where username=?>, ptr=(nil)</div>
<div>Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:db_mysql:mysql_raise_event: MySQL status has not changed: connected</div>
<div>Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:db_mysql:db_mysql_do_prepared_query: new statement(0x7f6d33faf978) on connection: (0x7f6d33facd80) 0x7f6d33fac4c8</div>
<div>Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:db_mysql:db_mysql_do_prepared_query: set values for the statement run</div>
<div>Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:db_mysql:db_mysql_val2bind: added val (0): len=10; type=254; is_null=0</div>
<div>Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:db_mysql:db_mysql_do_prepared_query: doing BIND_PARAM in...</div>
<div>Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:db_mysql:mysql_raise_event: MySQL status has not changed: connected</div>
<div>Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:db_mysql:db_mysql_do_prepared_query: prepared statement has 2 columns in result</div>
<div>Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:db_mysql:db_mysql_do_prepared_query: doing to BIND_PARAM out ...</div>
<div>Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:core:db_new_result: allocate 48 bytes for result set at 0x7f6d33fadf68</div>
<div>Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:db_mysql:db_mysql_get_columns: 2 columns returned from the query</div>
<div>Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:core:db_allocate_columns: allocate 56 bytes for result columns at 0x7f6d33faf060</div>
<div>Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x7f6d33faf070)[0]=[password]</div>
<div>Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:db_mysql:db_mysql_get_columns: use DB_STRING result type</div>
<div>Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x7f6d33faf080)[1]=[rpid]</div>
<div>Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:db_mysql:db_mysql_get_columns: use DB_STRING result type</div>
<div>Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:core:db_allocate_rows: allocate 80 bytes for result rows and values at 0x7f6d33fb0450</div>
<div>Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:db_mysql:db_mysql_str2val: converting STRING [my@password]</div>
<span>Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: CRITICAL:core:sig_usr: segfault in process pid: 188225, id: 15</span><br>
</div>
<div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="Signature">
<div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
--</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Regards,</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
William Jin<br>
</div>
</div>
</div>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Users <users-bounces@lists.opensips.org> on behalf of William Jin <williamj@exetel.com.au><br>
<b>Sent:</b> Friday, 17 September 2021 2:19 PM<br>
<b>To:</b> Liviu Chircu <liviu@opensips.org>; OpenSIPS users mailling list <users@lists.opensips.org><br>
<b>Subject:</b> Re: [OpenSIPS-Users] opensips 3.2.2 Segfault on debian 11 bullseye</font>
<div> </div>
</div>
<style type="text/css" style="display:none">
<!--
p
{margin-top:0;
margin-bottom:0}
-->
</style>
<div dir="ltr">
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
And just further investigation, looks like it's crashed only after I register my test user. (which can register on debian 10 before upgraded to debian 11 using zoiper softphone)</div>
<div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
And the backtrack also indicate the crash from auth_db??</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div id="x_Signature">
<div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
--</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Regards,</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
William Jin<br>
</div>
</div>
</div>
</div>
<div id="x_appendonsend"></div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="x_divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> Users <users-bounces@lists.opensips.org> on behalf of William Jin <williamj@exetel.com.au><br>
<b>Sent:</b> Friday, 17 September 2021 9:12 AM<br>
<b>To:</b> Liviu Chircu <liviu@opensips.org>; OpenSIPS users mailling list <users@lists.opensips.org><br>
<b>Subject:</b> Re: [OpenSIPS-Users] opensips 3.2.2 Segfault on debian 11 bullseye</font>
<div> </div>
</div>
<style type="text/css" style="display:none">
<!--
p
{margin-top:0;
margin-bottom:0}
-->
</style>
<div dir="ltr">
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Hi Liviu,</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
I attached the backtrace in the init email.</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
I've attached it again.</div>
<div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div id="x_x_Signature">
<div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
--</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Regards,</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
William Jin<br>
</div>
</div>
</div>
</div>
<div id="x_x_appendonsend"></div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="x_x_divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> Liviu Chircu <liviu@opensips.org><br>
<b>Sent:</b> Thursday, 16 September 2021 5:12 PM<br>
<b>To:</b> OpenSIPS users mailling list <users@lists.opensips.org>; William Jin <williamj@exetel.com.au><br>
<b>Subject:</b> Re: [OpenSIPS-Users] opensips 3.2.2 Segfault on debian 11 bullseye</font>
<div> </div>
</div>
<div class="x_x_BodyFragment"><font size="2"><span style="font-size:11pt">
<div class="x_x_PlainText">On 16.09.2021 02:16, William Jin wrote:<br>
> Anyone has any chance to look into this?<br>
<br>
Hi William,<br>
<br>
There is not enough info to look into anything, really:<br>
<br>
* how are you reproducing this crash? can you share a basic <br>
opensips.cfg that causes it?<br>
* are there any useful logs _before_ those "signal 11" logs?<br>
* can you obtain a backtrace out of this crash? See this guide [1] for <br>
some help here<br>
<br>
[1]: <a href="https://www.opensips.org/Documentation/TroubleShooting-Crash">https://www.opensips.org/Documentation/TroubleShooting-Crash</a><br>
<br>
Best,<br>
<br>
-- <br>
Liviu Chircu<br>
<a href="http://www.twitter.com/liviuchircu">www.twitter.com/liviuchircu</a> | <a href="http://www.opensips-solutions.com">
www.opensips-solutions.com</a><br>
<br>
</div>
</span></font></div>
</div>
</div>
</body>
</html>