<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hello,<br>
<br>
don't forget to keep the mailing list cc-ed for the discussions
started there...<br>
<br>
On 12/5/11 8:20 PM, mn3250 mn3250 wrote:
<blockquote
cite="mid:CAJmCRayciEnOPpgsr=d_bEnscAaB7fCswcKp95LPpD6otcLaGA@mail.gmail.com"
type="cite">Had to modify /usr/local/etc/kamailio/kamctlrc and
everything started to work.<br>
</blockquote>
Was it just setting DBENGINE and then running kamdbctl create or was
some other kind of modification?<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<blockquote
cite="mid:CAJmCRayciEnOPpgsr=d_bEnscAaB7fCswcKp95LPpD6otcLaGA@mail.gmail.com"
type="cite"><br>
<div class="gmail_quote">On Mon, Nov 28, 2011 at 4:15 PM,
Daniel-Constantin Mierla <span dir="ltr"><<a
moz-do-not-send="true" href="mailto:miconda@gmail.com">miconda@gmail.com</a>></span>
wrote:<br>
<blockquote style="margin: 0px 0px 0px 0.8ex; padding-left: 1ex;
border-left-color: rgb(204, 204, 204); border-left-width: 1px;
border-left-style: solid;" class="gmail_quote">
<div text="#000000" bgcolor="#FFFFFF"> Hello,<br>
<br>
can you check inside MySQL server if database voip1 has a
table named version?<br>
<br>
What is the kamailio version you are using? How did you
create the database, with kamdbctl create?<br>
<br>
Cheers,<br>
Daniel
<div>
<div class="h5"><br>
<br>
On 11/28/11 2:59 PM, mn3250 mn3250 wrote: </div>
</div>
<blockquote type="cite">
<div>
<div class="h5">
<div>Hi,</div>
<div>Looks like the table "Version" is missing in the
sql create script.</div>
<div> 0(18594) DEBUG: db_mysql [km_my_con.c:94]:
opening connection:
mysql://xxxx:xxxx@localhost/voip1<br>
0(18594) DEBUG: db_mysql [km_my_con.c:121]:
connection type is Localhost via UNIX socket<br>
0(18594) DEBUG: db_mysql [km_my_con.c:122]:
protocol version is 10<br>
0(18594) DEBUG: db_mysql [km_my_con.c:123]: server
version is 5.0.77-log<br>
0(18594) DEBUG: <core> [db_res.c:118]:
allocate 48 bytes for result set at 0x2ba27ac440b0<br>
0(18594) DEBUG: db_mysql [km_res.c:68]: 1 columns
returned from the query<br>
0(18594) DEBUG: <core> [db_res.c:155]:
allocate 8 bytes for result names at 0x2ba27ac44140<br>
0(18594) DEBUG: <core> [db_res.c:165]:
allocate 4 bytes for result types at 0x2ba27ac441a8<br>
0(18594) DEBUG: db_mysql [km_res.c:85]: allocate 16
bytes for RES_NAMES[0] at 0x2ba27ac44210<br>
0(18594) DEBUG: db_mysql [km_res.c:92]:
RES_NAMES(0x2ba27ac44210)[0]=[table_version]<br>
0(18594) DEBUG: db_mysql [km_res.c:100]: use
DB1_INT result type<br>
0(18594) DEBUG: db_mysql [km_res.c:169]: no rows
returned from the query<br>
0(18594) DEBUG: <core> [db.c:385]: no row for
table location found<br>
0(18594) ERROR: <core> [db.c:421]: invalid
version 0 for table location found, expected 1004
(check table structure and table "version")<br>
Anyone has the correct file?</div>
<div>Thanks</div>
<br>
<fieldset></fieldset>
<br>
</div>
</div>
<pre>_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a moz-do-not-send="true" href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>
<a moz-do-not-send="true" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<font color="#888888"> <br>
<pre cols="72">--
Daniel-Constantin Mierla -- <a moz-do-not-send="true" href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
Kamailio Advanced Training, Dec 5-8, Berlin: <a moz-do-not-send="true" href="http://asipto.com/u/kat" target="_blank">http://asipto.com/u/kat</a>
<a moz-do-not-send="true" href="http://linkedin.com/in/miconda" target="_blank">http://linkedin.com/in/miconda</a> -- <a moz-do-not-send="true" href="http://twitter.com/miconda" target="_blank">http://twitter.com/miconda</a></pre>
</font></div>
</blockquote>
</div>
<br>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla -- <a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a>
Kamailio Advanced Training, Dec 5-8, Berlin: <a class="moz-txt-link-freetext" href="http://asipto.com/u/kat">http://asipto.com/u/kat</a>
<a class="moz-txt-link-freetext" href="http://linkedin.com/in/miconda">http://linkedin.com/in/miconda</a> -- <a class="moz-txt-link-freetext" href="http://twitter.com/miconda">http://twitter.com/miconda</a></pre>
</body>
</html>