[SR-Users] P-CSCF using MYSQL database

Mon Apr 7 11:29:55 CEST 2014

I tried to switch to the "old" db_mode 0 (no db at all), and i got the same
error for the call. The registrations seems to works fine: running
ulpcscf.status from kamcmd gives me that in the P-CSCF memory there are
actually 2 AORs, so ... Is it a bug of the new version?? Everything works
fine with 4.1.x ... Or maybe it is a problem of the SIP requests i've
generated??

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

> Here we are (the pcap are captured with Wireshark). I noticed that:
>
> - the users' are correctly inserted in the location table of the pcscf DB
> - the users' are correctly inserted in the contact table of the scscf DB
>  (alice in scscf and bob in scscf2)
>
> However, as you can see, i'm not able to make a call. But if i set db_mode
> to 0 (for ims_usrloc_pcscf) everything work fine. What am i missing? I
> supposed that some checks on some tables' fields fail ... But i can't
> figure out why ... Sorry for the logs, i'll send you asap
>
> Andrea
>
>
> On Fri, Apr 4, 2014 at 1:48 PM, Jason Penton <jason.penton at smilecoms.com>wrote:
>
>> 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.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/20140407/ebbcbdd0/attachment.html>