4 Apr
2014
4 Apr
'14
8:12 p.m.
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;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:
--
*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
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:
_______________________________________________
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
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;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;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.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