5 Dec
2011
5 Dec
'11
8:38 p.m.
Hello,
don't forget to keep the mailing list cc-ed for the discussions started
there...
On 12/5/11 8:20 PM, mn3250 mn3250 wrote:
Had to modify /usr/local/etc/kamailio/kamctlrc and
everything started
to work.
Was it just setting DBENGINE and then running kamdbctl create or was
some other kind of modification?
Cheers,
Daniel
On Mon, Nov 28, 2011 at 4:15 PM, Daniel-Constantin Mierla
<miconda(a)gmail.com <mailto:miconda@gmail.com>> wrote:
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:
--
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
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(a)lists.sip-router.org <mailto: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