[SR-Users] P-CSCF using MYSQL database

[Andrea Meroni]

Edit: i successfully make it working, by adding the proper columns in the
database. However, i still have some issues ... Does anyone know where i
can get a description of the DB structure of Kamailio? Especially the
tables needed for the modules i mentioned in the previous mail?

Andrea


On Thu, Apr 3, 2014 at 2:49 PM, Andrea Meroni <rucola8968 at gmail.com> wrote:

> Hi all,
>
> i am trying to configure an IMS Core Kamailio-based: while configuring the
> P-CSCF, i set up the parameters 'db_url' and 'db_mode' of the module
> ims_usrloc_pcscf respectively to 'mysql://kamailio:kamailiorw@localhost/kamailio'
> and 1 (because i want a DB for persistence). I had created successfully the
> DB using kamdbctl, and loaded the module 'db_mysql' in kamailio.cfg. Then i
> tried to run Kamailio, and i got this error:
>
> ERROR: db_mysql [km_dbase.c:122]: db_mysql_submit_query: driver error on
> query: Unknown column 'aor' in 'field list'
>
> What am i missing? Consider then when i created the DB i answer yes to all
> the questions about creating additional tables ...
>
> Andrea
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20140404/21e8ceb1/attachment.html>