[prev in list] [next in list] [prev in thread] [next in thread]
List: sr-users
Subject: Re: [SR-Users] "Version" Table missing
From: Daniel-Constantin Mierla <miconda () gmail ! com>
Date: 2011-11-28 15:15:23
Message-ID: 4ED3A58B.4070607 () gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Hello,
can you check inside MySQL server if database voip1 has a table named
version?
What is the kamailio version you are using? How did you create the
database, with kamdbctl create?
Cheers,
Daniel
On 11/28/11 2:59 PM, mn3250 mn3250 wrote:
> Hi,
> Looks like the table "Version" is missing in the sql create script.
> 0(18594) DEBUG: db_mysql [km_my_con.c:94]: opening connection:
> mysql://xxxx:xxxx@localhost/voip1
> 0(18594) DEBUG: db_mysql [km_my_con.c:121]: connection type is
> Localhost via UNIX socket
> 0(18594) DEBUG: db_mysql [km_my_con.c:122]: protocol version is 10
> 0(18594) DEBUG: db_mysql [km_my_con.c:123]: server version is 5.0.77-log
> 0(18594) DEBUG: <core> [db_res.c:118]: allocate 48 bytes for result
> set at 0x2ba27ac440b0
> 0(18594) DEBUG: db_mysql [km_res.c:68]: 1 columns returned from the query
> 0(18594) DEBUG: <core> [db_res.c:155]: allocate 8 bytes for result
> names at 0x2ba27ac44140
> 0(18594) DEBUG: <core> [db_res.c:165]: allocate 4 bytes for result
> types at 0x2ba27ac441a8
> 0(18594) DEBUG: db_mysql [km_res.c:85]: allocate 16 bytes for
> RES_NAMES[0] at 0x2ba27ac44210
> 0(18594) DEBUG: db_mysql [km_res.c:92]:
> RES_NAMES(0x2ba27ac44210)[0]=[table_version]
> 0(18594) DEBUG: db_mysql [km_res.c:100]: use DB1_INT result type
> 0(18594) DEBUG: db_mysql [km_res.c:169]: no rows returned from the query
> 0(18594) DEBUG: <core> [db.c:385]: no row for table location found
> 0(18594) ERROR: <core> [db.c:421]: invalid version 0 for table
> location found, expected 1004 (check table structure and table "version")
> Anyone has the correct file?
> Thanks
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users@lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla -- http://www.asipto.com
Kamailio Advanced Training, Dec 5-8, Berlin: http://asipto.com/u/kat
http://linkedin.com/in/miconda -- http://twitter.com/miconda
[Attachment #5 (text/html)]
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
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<br>
<br>
On 11/28/11 2:59 PM, mn3250 mn3250 wrote:
<blockquote
cite="mid:CAJmCRax54WcO_Sh45ov9RAkMSF+o5fVqy+g81fc5RkV_MHvU8w@mail.gmail.com"
type="cite">
<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 class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" \
href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a> <a \
class="moz-txt-link-freetext" \
href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</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>
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic