[SR-Users] P-CSCF using MYSQL database

[Jason Penton]

no you don't need the S-CSCF DB support unless you want it.

Can you send debug log of P-CSCF as well as pcap of the same attempt.
Include both registrations and the call.

cheers
Jason


On Fri, Apr 4, 2014 at 2:22 PM, Andrea Meroni <rucola8968 at gmail.com> wrote:

> Ok, using the new scheme the contact records are correctly saved in the DB
> (both for Alice and Bob). But i still get the same error. Perhaps its a
> stupid question ... Should i also add the DB support in the S-CSCFs? Isn't
> enough (for some preliminar tests, just to look at the Kamailio's behavior)
> to add it only for the P-CSCF?
>
> Andrea
>
>
> On Fri, Apr 4, 2014 at 10:47 AM, Andrea Meroni <rucola8968 at gmail.com>wrote:
>
>> 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
>>>
>>>
>>
>
> _______________________________________________
> 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/80ba73ac/attachment.html>