<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Vlad,<br>
<br>
Thanks again for looking into this issue, you were spot on the mysql
library was different on each server and it came down to the order
in which the packages were installed.<br>
<br>
Just in case anyone else has this issue you need to installed
mysql-devel last, due to an issue with error message files I
reinstalled mysql-libs and mysql again. When I did this it was the
source of the issue as it over wrote libmysqlclient. So by
reinstall mysql-devel and recompiling everything (a re-compile was
required) it now works correctly.<br>
<br>
Regards,<br>
Mark<br>
<br>
On 03/30/11 20:22, Mark Carbonaro wrote:
<blockquote cite="mid:4D92F63B.7010906@iovox.com" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
Thanks, I'll look into the mysql library and see what I can find.<br>
<br>
Mark<br>
<br>
On 03/29/11 22:22, Vlad Paiu wrote:
<blockquote cite="mid:4D91C0E4.2020900@opensips.org" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
Hi,<br>
<br>
Just took a look at the code and it seems to be a problem
somehow related with the mysql library on your machine. <br>
At startup, OpenSIPS tries to fetch all dialog info from DB, and
it first gets the column names and column types from the dialog
table. It seems that in your case, the mysql library can only
succesfully fetch the first column name ( hash_entry ), and then
returns NULL for the second column name, which causes OpenSIPS
to crash, because the case where a column name is NULL is bogus
and should never happen.<br>
<br>
Could you maybe try to reinstall your mysql library or double
check the fact that are no related problems to it ?<br>
<br>
<br>
Regards,<br>
<pre class="moz-signature" cols="72">--
Vlad Paiu
OpenSIPS Developer</pre>
<br>
<br>
On 03/29/2011 12:53 PM, Mark Carbonaro wrote:
<blockquote cite="mid:4D91ABFE.6020908@iovox.com" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
Hi Vlad,<br>
<br>
Thanks for the reply, below is the output of "bt full".<br>
<br>
Mark<br>
<br>
#0 0x00007fb9cd8cde57 in db_mysql_get_columns (_h=<value
optimized out>, <br>
_r=0x796490) at res.c:71<br>
col = 1<br>
fields = <value optimized out><br>
__FUNCTION__ = "db_mysql_get_columns"<br>
#1 0x00007fb9cd8c7e36 in db_mysql_fetch_result (_h=0x7962c8,
<br>
_r=0x7fff2a4a3e68, nrows=128) at dbase.c:849<br>
rows = <value optimized out><br>
i = <value optimized out><br>
__FUNCTION__ = "db_mysql_fetch_result"<br>
#2 0x00007fb9cbf94889 in select_entire_dialog_table (<br>
dlg_hash_size=<value optimized out>) at
dlg_db_handler.c:232<br>
__FUNCTION__ = "select_entire_dialog_table"<br>
#3 load_dialog_info_from_db (dlg_hash_size=<value
optimized out>)<br>
at dlg_db_handler.c:385<br>
res = 0x796490<br>
values = <value optimized out><br>
rows = <value optimized out><br>
i = <value optimized out><br>
nr_rows = <value optimized out><br>
dlg = <value optimized out><br>
callid = {s = 0x3c <Address 0x3c out of bounds>,
len = -870573728}<br>
from_uri = {s = 0xb <Address 0xb out of bounds>,
len = 5153101}<br>
---Type <return> to continue, or q <return> to
quit---<br>
to_uri = {s = 0x1000 <Address 0x1000 out of
bounds>, len = 1}<br>
from_tag = {s = 0x4 <Address 0x4 out of bounds>,
len = -870574432}<br>
to_tag = {s = 0x7fb9cc1c1960 "\264S\005\315\271\177",
len = -870574432}<br>
cseq1 = {s = 0x7fff2a4a3dc0 "\270*S", len =
-846407113}<br>
cseq2 = {s = 0x7fff2a4a3db0 "\303*S", len =
-870577568}<br>
contact1 = {s = 0x7962c8 "\240\026\034��\177", len =
7955600}<br>
contact2 = {s = 0x532ac9 "version", len = 7}<br>
rroute1 = {s = 0x532ab8 "table_name", len = 10}<br>
rroute2 = {s = 0x532ac3 "table_version", len = 13}<br>
next_id = <value optimized out><br>
__FUNCTION__ = "load_dialog_info_from_db"<br>
#4 0x00007fb9cbf961a8 in init_dlg_db (db_url=<value
optimized out>, <br>
dlg_hash_size=4096, db_update_period=60) at
dlg_db_handler.c:182<br>
__FUNCTION__ = "init_dlg_db"<br>
#5 0x00007fb9cbf9046e in mod_init () at dialog.c:696<br>
__FUNCTION__ = "mod_init"<br>
#6 0x000000000047b242 in init_mod (m=0x797788) at
sr_module.c:457<br>
__FUNCTION__ = "init_mod"<br>
#7 0x000000000047b1bf in init_mod (m=0x797ac8) at
sr_module.c:452<br>
__FUNCTION__ = "init_mod"<br>
#8 0x000000000047b1bf in init_mod (m=0x797b98) at
sr_module.c:452<br>
__FUNCTION__ = "init_mod"<br>
#9 0x000000000042b0c1 in main (argc=<value optimized
out>, <br>
---Type <return> to continue, or q <return> to
quit---<br>
argv=0x7fff2a4a4168) at main.c:1356<br>
cfg_log_stderr = 0<br>
cfg_stream = 0x1a09010<br>
c = <value optimized out><br>
r = <value optimized out><br>
tmp = 0x50bd87 "H\215\005.\365#"<br>
tmp_len = <value optimized out><br>
port = <value optimized out><br>
proto = <value optimized out><br>
ret = <value optimized out><br>
seed = 4201309582<br>
rfd = <value optimized out><br>
__FUNCTION__ = "main"<br>
<br>
<br>
On 03/29/11 20:39, Vlad Paiu wrote:
<blockquote cite="mid:4D91A8D4.4030201@opensips.org"
type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
Hello Mark,<br>
<br>
If you still have the core dump, could you please do <br>
gdb <i>path_to_opensips_binary path_to_core_file<br>
<br>
</i>and reply with the output of <br>
bt full<br>
<br>
Thanks. <br>
<br>
<br>
Regards,<br>
<pre class="moz-signature" cols="72">--
Vlad Paiu
OpenSIPS Developer</pre>
</blockquote>
</blockquote>
<br>
<pre wrap=""><fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Users mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
</body>
</html>