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(a)gmail.com>wrote;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(a)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(a)gmail.com>wrote;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(a)gmail.com>wrote;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(a)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(a)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(a)gmail.com> wrote:
>>>>>
>>>>>> Ok, thank you very much
>>>>>>
>>>>>>
>>>>>> On Fri, Apr 4, 2014 at 10:06 AM, Jason Penton <
>>>>>> jason.penton(a)smilecoms.com> wrote:
>>>>>>
>>>>>>> master, yes
>>>>>>>
>>>>>>> utils/kamctl/mysql/
>>>>>>>
>>>>>>>
>>>>>>> On Fri, Apr 4, 2014 at 11:02 AM, Andrea Meroni <
>>>>>>> rucola8968(a)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(a)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(a)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(a)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(a)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@smilecoms.com<name.surname@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(a)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(a)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(a)smilecoms.com
<name.surname(a)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(a)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(a)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(a)smilecoms.com <name.surname(a)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(a)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(a)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(a)smilecoms.com <name.surname(a)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(a)lists.sip-router.org
>
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>