<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:10pt"><div><span>Hi Bogdan,</span></div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br><span></span></div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><span>appologies for my late reply. I got problem with accessing my email account from home. :(</span></div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br><span></span></div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><span>Thanks for the
help in spotting the mistake I did :'(. I'll fix the location table and see how it goes. :)</span></div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br><span></span></div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><span></span></div> <div class="qtdSeparateBR"><br><br></div><div style="display: block;" class="yahoo_quoted"> <div style="font-family: times new roman, new york, times, serif; font-size: 10pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <font face="Arial" size="2"> On Friday, 6 June 2014, 16:58, Bogdan-Andrei Iancu <bogdan@opensips.org> wrote:<br> </font> </div> <br><br> <div class="y_msg_container"><div id="yiv6450150371"><div>
<div class="yiv6450150371moz-cite-prefix"><tt>no, it is not related to that :) -
see my previous email.<br clear="none">
<br clear="none">
Regards,<br clear="none">
</tt>
<pre class="yiv6450150371moz-signature">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a rel="nofollow" shape="rect" class="yiv6450150371moz-txt-link-freetext" target="_blank" href="http://www.opensips-solutions.com/">http://www.opensips-solutions.com</a></pre>
On 06.06.2014 06:35, Pasan Meemaduma wrote:<br clear="none">
</div>
<div class="yiv6450150371yqt5758786393" id="yiv6450150371yqt79950"><blockquote type="cite">
<div style="color:#000;background-color:#fff;font-family:times new roman, new york, times, serif;font-size:10pt;">
<div class="yiv6450150371" style=""><span class="yiv6450150371" style="">Hi Bogdan,</span></div>
<div class="yiv6450150371" style="color:rgb(0, 0, 0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><br class="yiv6450150371" style="" clear="none">
<span class="yiv6450150371" style=""></span></div>
<div class="yiv6450150371" style="color:rgb(0, 0, 0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><span class="yiv6450150371" style="">I just found that I have got the key
constraint wrong. Will that be the issue ?</span></div>
<div class="yiv6450150371" style="color:rgb(0, 0, 0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><br class="yiv6450150371" style="" clear="none">
<span class="yiv6450150371" style=""></span></div>
<div class="yiv6450150371" style="color:rgb(0, 0, 0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><span class="yiv6450150371" style="">| location | CREATE TABLE `location` (<br class="yiv6450150371" style="" clear="none">
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,<br class="yiv6450150371" style="" clear="none">
`username` char(64) NOT NULL DEFAULT '',<br class="yiv6450150371" style="" clear="none">
`domain` char(64) DEFAULT NULL,<br class="yiv6450150371" style="" clear="none">
`contact` char(255) NOT NULL DEFAULT '',<br class="yiv6450150371" style="" clear="none">
`received` char(128) DEFAULT NULL,<br class="yiv6450150371" style="" clear="none">
`path` char(128) DEFAULT NULL,<br class="yiv6450150371" style="" clear="none">
`expires` datetime NOT NULL DEFAULT '2020-05-28 21:32:15',<br class="yiv6450150371" style="" clear="none">
`q` float(10,2) NOT NULL DEFAULT '1.00',<br class="yiv6450150371" style="" clear="none">
`callid` char(255) NOT NULL DEFAULT 'Default-Call-ID',<br class="yiv6450150371" style="" clear="none">
`cseq` int(11) NOT NULL DEFAULT '13',<br class="yiv6450150371" style="" clear="none">
`last_modified` datetime NOT NULL DEFAULT '1900-01-01
00:00:01',<br class="yiv6450150371" style="" clear="none">
`flags` int(11) NOT NULL DEFAULT '0',<br class="yiv6450150371" style="" clear="none">
`cflags` int(11) NOT NULL DEFAULT '0',<br class="yiv6450150371" style="" clear="none">
`user_agent` char(255) NOT NULL DEFAULT '',<br class="yiv6450150371" style="" clear="none">
`socket` char(64) DEFAULT NULL,<br class="yiv6450150371" style="" clear="none">
`methods` int(11) DEFAULT NULL,<br class="yiv6450150371" style="" clear="none">
`sip_instance` char(255) DEFAULT NULL,<br class="yiv6450150371" style="" clear="none">
`attr` char(255) DEFAULT NULL,<br class="yiv6450150371" style="" clear="none">
PRIMARY KEY (`id`),<br class="yiv6450150371" style="" clear="none">
KEY `account_contact_idx` (`username`,`domain`,`contact`)<br class="yiv6450150371" style="" clear="none">
) ENGINE=MyISAM AUTO_INCREMENT=25375081 DEFAULT
CHARSET=latin1 |<br class="yiv6450150371" style="" clear="none">
</span></div>
<div class="yiv6450150371" style="color:rgb(0, 0, 0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><br clear="none">
<span class="yiv6450150371" style=""></span></div>
<div class="yiv6450150371" style="color:rgb(0, 0, 0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><span class="yiv6450150371" style="">account_contact_idx is missing callid
column. Will this has any relation to crash ?<br class="yiv6450150371" style="" clear="none">
</span></div>
<div class="yiv6450150371qtdSeparateBR"><br clear="none">
<br clear="none">
</div>
<div class="yiv6450150371yahoo_quoted" style="display:block;">
<div class="yiv6450150371" style="font-family:times new roman, new york, times, serif;font-size:10pt;">
<div class="yiv6450150371" style="font-family:times new roman, new york, times, serif;font-size:12pt;">
<div class="yiv6450150371" dir="ltr" style=""> <font class="yiv6450150371" style="" face="Arial" size="2"> On Friday, 6 June 2014, 8:48,
Pasan Meemaduma <a rel="nofollow" shape="rect" class="yiv6450150371moz-txt-link-rfc2396E" ymailto="mailto:pasandev@ymail.com" target="_blank" href="mailto:pasandev@ymail.com"><pasandev@ymail.com></a> wrote:<br class="yiv6450150371" style="" clear="none">
</font> </div>
<br class="yiv6450150371" style="" clear="none">
<br class="yiv6450150371" style="" clear="none">
<div class="yiv6450150371" style="">
<div class="yiv6450150371" id="yiv6450150371" style="">
<div class="yiv6450150371" style="">
<div class="yiv6450150371" style="color:#000;background-color:#fff;font-family:times new roman, new york, times, serif;font-size:10pt;">
<div class="yiv6450150371" style=""><span class="yiv6450150371" style="">Hi
Bogdan,</span></div>
<div class="yiv6450150371" style="color:rgb(0, 0, 0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><br class="yiv6450150371" style="" clear="none">
<span class="yiv6450150371" style=""></span></div>
<div class="yiv6450150371" style="color:rgb(0, 0, 0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><span class="yiv6450150371" style="">Thanks for the reply. I
created the table using normal schema it looks
fine to me. I was refering to the old url you
gave me. There in that table attr was missing
:)<br class="yiv6450150371" style="" clear="none">
</span></div>
<div class="yiv6450150371" style=""><br class="yiv6450150371" style="" clear="none">
this is the url missing attr in location table<br class="yiv6450150371" style="" clear="none">
<tt class="yiv6450150371" style=""><a rel="nofollow" shape="rect" class="yiv6450150371" style="" target="_blank" href="http://www.opensips.org/Documentation/Install-DBSchema-1-10#AEN7254">http://www.opensips.org/Documentation/Install-DBSchema-1-10#AEN7254</a>
<br class="yiv6450150371" style="" clear="none">
<br class="yiv6450150371" style="" clear="none">
<br class="yiv6450150371" style="" clear="none">
below is my table schema,<br class="yiv6450150371" style="" clear="none">
<br class="yiv6450150371" style="" clear="none">
mysql> desc location;<br class="yiv6450150371" style="" clear="none">
+---------------+------------------+------+-----+---------------------+----------------+<br class="yiv6450150371" style="" clear="none">
| Field | Type | Null |
Key | Default | Extra |<br class="yiv6450150371" style="" clear="none">
+---------------+------------------+------+-----+---------------------+----------------+<br class="yiv6450150371" style="" clear="none">
| id | int(10) unsigned | NO |
PRI | NULL | auto_increment |<br class="yiv6450150371" style="" clear="none">
| username | char(64) | NO |
MUL | | |<br class="yiv6450150371" style="" clear="none">
| domain | char(64) | YES
| | NULL | |<br class="yiv6450150371" style="" clear="none">
| contact | char(255) | NO
| | | |<br class="yiv6450150371" style="" clear="none">
| received | char(128) | YES
| | NULL | |<br class="yiv6450150371" style="" clear="none">
| path | char(128) | YES
| | NULL | |<br class="yiv6450150371" style="" clear="none">
| expires | datetime | NO
| | 2020-05-28 21:32:15 | |<br class="yiv6450150371" style="" clear="none">
| q | float(10,2) | NO
| | 1.00 | |<br class="yiv6450150371" style="" clear="none">
| callid | char(255) | NO
| | Default-Call-ID | |<br class="yiv6450150371" style="" clear="none">
| cseq | int(11) | NO
| | 13 | |<br class="yiv6450150371" style="" clear="none">
| last_modified | datetime | NO
| | 1900-01-01 00:00:01 | |<br class="yiv6450150371" style="" clear="none">
| flags | int(11) | NO
| | 0 | |<br class="yiv6450150371" style="" clear="none">
| cflags | int(11) | NO
| | 0 | |<br class="yiv6450150371" style="" clear="none">
| user_agent | char(255) | NO
| | | |<br class="yiv6450150371" style="" clear="none">
| socket | char(64) | YES
| | NULL | |<br class="yiv6450150371" style="" clear="none">
| methods | int(11) | YES
| | NULL | |<br class="yiv6450150371" style="" clear="none">
| sip_instance | char(255) | YES
| | NULL | |<br class="yiv6450150371" style="" clear="none">
| attr | char(255) | YES
| | NULL | |<br class="yiv6450150371" style="" clear="none">
+---------------+------------------+------+-----+---------------------+----------------+<br class="yiv6450150371" style="" clear="none">
<br class="yiv6450150371" style="" clear="none">
<br class="yiv6450150371" style="" clear="none">
attr holds NULL values for all entries.<br class="yiv6450150371" style="" clear="none">
<br class="yiv6450150371" style="" clear="none">
do I have to run below in gdb after running bt
full right ?<br class="yiv6450150371" style="" clear="none">
<br class="yiv6450150371" style="" clear="none">
this is what i got<br class="yiv6450150371" style="" clear="none">
<br class="yiv6450150371" style="" clear="none">
(gdb) f 1<br class="yiv6450150371" style="" clear="none">
#1 0x00007f64823a60a2 in dbrow2info
(contact=0x7fffe0246180, vals=0x7f648287a260)
at udomain.c:306<br class="yiv6450150371" style="" clear="none">
306 in udomain.c<br class="yiv6450150371" style="" clear="none">
(gdb) p (vals+6)->val.string_val<br class="yiv6450150371" style="" clear="none">
$2 = 0x0<br class="yiv6450150371" style="" clear="none">
(gdb) <br class="yiv6450150371" style="" clear="none">
<br class="yiv6450150371" style="" clear="none">
<br class="yiv6450150371" style="" clear="none">
-----------------without running bt full
------------- just in case :)<br class="yiv6450150371" style="" clear="none">
(gdb) f 1<br class="yiv6450150371" style="" clear="none">
#1 0x00007f64823a60a2 in dbrow2info
(contact=0x7fffe0246180, vals=0x7f648287a260)
at udomain.c:306<br class="yiv6450150371" style="" clear="none">
306 udomain.c: No such file or directory.<br class="yiv6450150371" style="" clear="none">
(gdb) p (vals+6)->val.string_val<br class="yiv6450150371" style="" clear="none">
$1 = 0x0<br class="yiv6450150371" style="" clear="none">
<br class="yiv6450150371" style="" clear="none">
</tt></div>
<div class="yiv6450150371" style=""><br class="yiv6450150371" style="" clear="none">
<br class="yiv6450150371" style="" clear="none">
</div>
<div class="yiv6450150371" id="yiv6450150371yqt85628" style="">
<div class="yiv6450150371" style="display:block;">
<div class="yiv6450150371" style="font-family:times new roman, new york, times, serif;font-size:10pt;">
<div class="yiv6450150371" style="font-family:times new roman, new york, times, serif;font-size:12pt;">
<div class="yiv6450150371" dir="ltr" style=""> <font class="yiv6450150371" style="" face="Arial" size="2"> On Thursday, 5 June 2014,
17:07, Bogdan-Andrei Iancu
<a rel="nofollow" shape="rect" class="yiv6450150371moz-txt-link-rfc2396E" ymailto="mailto:bogdan@opensips.org" target="_blank" href="mailto:bogdan@opensips.org"><bogdan@opensips.org></a> wrote:<br class="yiv6450150371" style="" clear="none">
</font> </div>
<br class="yiv6450150371" style="" clear="none">
<br class="yiv6450150371" style="" clear="none">
<div class="yiv6450150371" style="">
<div class="yiv6450150371" id="yiv6450150371" style="">
<div class="yiv6450150371" style="">
<div class="yiv6450150371" style="">Thanks for
the backtrace. In DB, what do you
have for the "attr" value ? NULL
or an empty string ?<br class="yiv6450150371" style="" clear="none">
<br class="yiv6450150371" style="" clear="none">
In gdb, could you do:<br class="yiv6450150371" style="" clear="none">
f 1<br class="yiv6450150371" style="" clear="none">
p (vals+6)->val.string_val<br class="yiv6450150371" style="" clear="none">
<br class="yiv6450150371" style="" clear="none">
Thanks,<br class="yiv6450150371" style="" clear="none">
<pre class="yiv6450150371" style="">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a rel="nofollow" shape="rect" class="yiv6450150371" style="" target="_blank" href="http://www.opensips-solutions.com/">http://www.opensips-solutions.com</a></pre>
On 05.06.2014 06:15, Pasan
Meemaduma wrote:
<div class="yiv6450150371" id="yiv6450150371yqtfd39564" style=""><br class="yiv6450150371" style="" clear="none">
</div>
</div>
<div class="yiv6450150371" id="yiv6450150371yqtfd99965" style="">
<blockquote class="yiv6450150371" style="" type="cite">
<div class="yiv6450150371" style="color:#000;background-color:#fff;font-family:times new roman, new york, times, serif;font-size:10pt;">
<div class="yiv6450150371" style=""><span class="yiv6450150371" style="">oops
sorry I forgot
opensips-dbg :) bt
reattached.</span></div>
<div class="yiv6450150371" style="color:rgb(0, 0, 0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><br class="yiv6450150371" style="" clear="none">
<span class="yiv6450150371" style=""></span></div>
<div class="yiv6450150371" style="color:rgb(0, 0, 0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><span class="yiv6450150371" style="">I have change
some sensitive values with
'x' as below, hope it wont
affect u r investigations</span></div>
<div class="yiv6450150371" style="color:rgb(0, 0, 0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><br class="yiv6450150371" style="" clear="none">
<span class="yiv6450150371" style=""></span></div>
<div class="yiv6450150371" style="color:rgb(0, 0, 0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><span class="yiv6450150371" style=""> contact =
{s = 0xf91eab <a rel="nofollow" shape="rect" class="yiv6450150371" style="" ymailto="mailto:sip:xxxxxxxxxx@xxx.xxx.xxx.xx" target="_blank" href="mailto:sip:xxxxxxxxxx@xxx.xxx.xxx.xx">"sip:xxxxxxxxxx@xxx.xxx.xxx.xx"</a>,
len = 29}<br class="yiv6450150371" style="" clear="none">
</span></div>
<div class="yiv6450150371" style=""><br class="yiv6450150371" style="" clear="none">
<br class="yiv6450150371" style="" clear="none">
</div>
<div class="yiv6450150371" style="display:block;">
<div class="yiv6450150371" style="font-family:times new roman, new york, times, serif;font-size:10pt;">
<div class="yiv6450150371" style="font-family:times new roman, new york, times, serif;font-size:12pt;">
<div class="yiv6450150371" dir="ltr" style=""> <font class="yiv6450150371" style="" face="Arial" size="2"> On
Thursday, 5 June
2014, 8:34, Pasan
Meemaduma <a rel="nofollow" shape="rect" class="yiv6450150371" style="" ymailto="mailto:pasandev@ymail.com" target="_blank" href="mailto:pasandev@ymail.com"><pasandev@ymail.com></a>
wrote:<br class="yiv6450150371" style="" clear="none">
</font> </div>
<br class="yiv6450150371" style="" clear="none">
<br class="yiv6450150371" style="" clear="none">
<div class="yiv6450150371" style="">
<div class="yiv6450150371" id="yiv6450150371" style="">
<div class="yiv6450150371" style="">
<div class="yiv6450150371" style="color:#000;background-color:#fff;font-family:times new roman, new york, times, serif;font-size:10pt;">
<div class="yiv6450150371" style=""><span class="yiv6450150371" style="">Hi
Bogdan,</span></div>
<div class="yiv6450150371" style="color:rgb(0, 0, 0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><br class="yiv6450150371" style="" clear="none">
<span class="yiv6450150371" style=""></span></div>
<div class="yiv6450150371" style="color:rgb(0, 0, 0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><span class="yiv6450150371" style="">I
double checked
the schema and
it is correct.
btw doc needs
fixing its
missing attr
column which
is needed by
1.10 for
location table
otherwise I'll
get below
error.</span></div>
<div class="yiv6450150371" style="color:rgb(0, 0, 0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><br class="yiv6450150371" style="" clear="none">
<span class="yiv6450150371" style=""></span></div>
<div class="yiv6450150371" style="color:rgb(0, 0, 0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;">Jun
5 12:57:26
x/usr/sbin/opensips[30176]:
CRITICAL:db_mysql:wrapper_single_mysql_real_query:
driver error
(1054):
Unknown column
'attr' in
'field list'<br class="yiv6450150371" style="" clear="none">
Jun 5
12:57:26 x
/usr/sbin/opensips[30177]:
DBG:core:db_do_init:
connection
0x7f4dc04c1c28
inserted in
pool as
0x7f4dc04c1d30<br class="yiv6450150371" style="" clear="none">
Jun 5
12:57:26 x
/usr/sbin/opensips[30176]:
ERROR:core:db_do_query:
error while
submitting
query -
[select
username,contact,expires,q,callid,cseq,flags,cflags,user_agent,received,path,socket,methods,last_modified,sip_instance,attr
from location
]<br class="yiv6450150371" style="" clear="none">
Jun 5
12:57:26
anacardium3backup
/usr/sbin/opensips[30176]:
ERROR:usrloc:preload_udomain:
db_query (1)
failed<br class="yiv6450150371" style="" clear="none">
<br class="yiv6450150371" style="" clear="none">
<span class="yiv6450150371" style=""></span></div>
<div class="yiv6450150371" style="color:rgb(0, 0, 0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;">:)<br class="yiv6450150371" style="" clear="none">
<span class="yiv6450150371" style=""></span></div>
<div class="yiv6450150371" style="color:rgb(0, 0, 0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><br class="yiv6450150371" style="" clear="none">
<span class="yiv6450150371" style=""></span></div>
<div class="yiv6450150371" style="color:rgb(0, 0, 0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><span class="yiv6450150371" style="">I got
the backtrace
as you
requested , It
doesn't seems
right to me.
does it make
any sense ? or
did I miss
something
getting it ?</span></div>
<div class="yiv6450150371" style="color:rgb(0, 0, 0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><br class="yiv6450150371" style="" clear="none">
<span class="yiv6450150371" style=""></span></div>
<br class="yiv6450150371" style="" clear="none">
</div>
</div>
</div>
<br class="yiv6450150371" style="" clear="none">
</div>
</div>
</div>
</div>
</div>
</blockquote>
<br class="yiv6450150371" style="" clear="none">
</div>
</div>
</div>
<br class="yiv6450150371" style="" clear="none">
<br class="yiv6450150371" style="" clear="none">
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br class="yiv6450150371" style="" clear="none">
<div class="yiv6450150371" id="yiv6450150371yqt03407" style="">_______________________________________________<br class="yiv6450150371" style="" clear="none">
Users mailing list<br class="yiv6450150371" style="" clear="none">
<a rel="nofollow" shape="rect" class="yiv6450150371" style="" ymailto="mailto:Users@lists.opensips.org" target="_blank" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br class="yiv6450150371" style="" clear="none">
<a rel="nofollow" shape="rect" class="yiv6450150371" style="" target="_blank" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br class="yiv6450150371" style="" clear="none">
</div>
<br class="yiv6450150371" style="" clear="none">
<br class="yiv6450150371" style="" clear="none">
</div>
</div>
</div>
</div>
</div>
</blockquote></div>
<br clear="none">
</div></div><br><br></div> </div> </div> </div> </div></body></html>