[SR-Users] P-CSCF using MYSQL database

Andrea Meroni rucola8968 at gmail.com
Fri Apr 4 11:47:41 CEST 2014


Well ... Just let me try to explain the situation:

- Alice registers on scscf1 through pcscf: ok
- Bob registers on scscf2 through pcscf: ok (i get a 200 OK after the
challenge), but the Bob's record isn't inserted in the local db of the
pcscf (because probably i mismatch something in the db configuration, that
as i told you i did by hand)
- Alice tries to call Bob: after Alice's has sent the first request to the
proxy i get the error response, from the pcscf.

I guess that even if Bob's record hasn't been inserted in the db Kamailio
could retrieve it from the shared memory ... My only concern was that even
Alice's registration was wrong, or that right now the "usrloc-registrar
engine" for both pcscf and scscf isn't able to manage db access. Has
someone already make some tests about that?

Andrea



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

> 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.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/1e91ed05/attachment.html>


More information about the sr-users mailing list