[SR-Users] P-CSCF using MYSQL database

[Jason Penton]

In this case you have not successfully registered the B party for some
reason...


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

> Just another couple of questions:
>
> - now the tables are added simply when is run kamdbctl create?
> - the modules read properly the infos from the db or are there others open
> issues (i tried with my db, modified by hand, to registrate a user, and it
> was ok; then i tried to make a call to another user, but i receive a
> Forbidden: you must register with a S-CSCF first)?
>
> Andrea
>
>
> On Fri, Apr 4, 2014 at 10:13 AM, Andrea Meroni <rucola8968 at gmail.com>wrote:
>
>> Ok, thank you very much
>>
>>
>> On Fri, Apr 4, 2014 at 10:06 AM, Jason Penton <jason.penton at smilecoms.com
>> > wrote:
>>
>>> master, yes
>>>
>>> utils/kamctl/mysql/
>>>
>>>
>>> On Fri, Apr 4, 2014 at 11:02 AM, Andrea Meroni <rucola8968 at gmail.com>wrote:
>>>
>>>> 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
>>>>>
>>>>>
>>>>
>>>> _______________________________________________
>>>> 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
>>>
>>>
>>
>
> _______________________________________________
> 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>
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>

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