[SR-Users] P-CSCF using MYSQL database

Mon Apr 7 12:18:28 CEST 2014

Actually, i'm checking the logs while copying and doing my stuff and i'm
not able to find any message from ims_registrar_pcscf ... The debug level
is 5. Should i rise it? Isn't it the maximum?

Andrea

On Mon, Apr 7, 2014 at 11:14 AM, Jason Penton <jason.penton at smilecoms.com>wrote:

> cool, no proble, I suspect that there is a mismatch somewhere when
> searching for the registered contact. I should be able to see from the logs.
>
>
>
> On Mon, Apr 7, 2014 at 12:12 PM, Andrea Meroni <rucola8968 at gmail.com>wrote:
>
>> Ok, sorry but i will do it in a couple of hours because i'm running
>> Kamailio on VMs and i have to retrieve them
>>
>> Andrea
>>
>>
>> On Mon, Apr 7, 2014 at 11:09 AM, Jason Penton <jason.penton at smilecoms.com
>> > wrote:
>>
>>> No, there is no know issue. can you send me the full debug log file?
>>>
>>>
>>> On Mon, Apr 7, 2014 at 12:07 PM, Andrea Meroni <rucola8968 at gmail.com>wrote:
>>>
>>>> Yes, i'm using master. I browsed the tree searching the nested function
>>>> that generates the error (check failed) and it should be getContactP(struct
>>>> sip_msg* _m, udomain_t* _d) in ims_registrar_pcscf/service_routes.c. I will
>>>> try to do other tests searching on which attribute the check fails.
>>>> Meanwhile, if you don't mind, please tell me if the it is a known bug or
>>>> no, so maybe i can fix it :)
>>>>
>>>> Andrea
>>>>
>>>>
>>>> On Mon, Apr 7, 2014 at 11:02 AM, Jason Penton <
>>>> jason.penton at smilecoms.com> wrote:
>>>>
>>>>> Hi Andrea,
>>>>>
>>>>> Are you using master?
>>>>>
>>>>> Cheers
>>>>> Jason
>>>>>
>>>>>
>>>>> On Mon, Apr 7, 2014 at 11:57 AM, Andrea Meroni <rucola8968 at gmail.com>wrote:
>>>>>
>>>>>> Update: even with the UCT IMS client it didn't work, both with db
>>>>>> mode 0 and 1. From Kamailio config file i checked out that the exported
>>>>>> function that generates the issue is pcscf_is_registered. But why the check
>>>>>> fails?
>>>>>>
>>>>>> Andrea
>>>>>>
>>>>>>
>>>>>> On Mon, Apr 7, 2014 at 10:29 AM, Andrea Meroni <rucola8968 at gmail.com>wrote:
>>>>>>
>>>>>>> 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.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>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>>>>>>> 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>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>>>>> 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>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>> 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
>>>
>>>
>>
>> _______________________________________________
>> 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/9f830fad/attachment.html>