[SR-Users] P-CSCF using MYSQL database

Jason Penton jason.penton at smilecoms.com
Fri Apr 4 11:00:11 CEST 2014

Hi Andrea,

I have just added the schema to git repo.


On Fri, Apr 4, 2014 at 10:17 AM, Andrea Meroni <rucola8968 at gmail.com> wrote:

> 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
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users


*Jason Penton**Senior Manager: Applications and Services**Smile
Communications Pty (Ltd)**Mobile:*+27 (0) 83 283 7000*Skype:*
jason.barry.pentonjason.penton at smilecoms.com <name.surname at smilecoms.com>


This email is subject to the disclaimer of Smile Communications at http://www.smilecoms.com/home/email-disclaimer/ <http://www.smilecoms.com/disclaimer>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20140404/ea5b946f/attachment.html>

More information about the sr-users mailing list