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@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:
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?