[SR-Users] P-CSCF using MYSQL database

[Andrea Meroni]

Many many thanks ... Is it in examples/pcscf? In the master branch?


On Fri, Apr 4, 2014 at 10:00 AM, Jason Penton <jason.penton at smilecoms.com>wrote:

> Hi Andrea,
>
> I have just added the schema to git repo.
>
> Cheers
> Jason
>
>
> 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.penton
> jason.penton at smilecoms.com <name.surname at smilecoms.com> www.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>
>
>
> _______________________________________________
> 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20140404/7acb711a/attachment.html>