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