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 <rucola8...@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 <rucola8...@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.pen...@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 <rucola8...@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 <rucola8...@gmail.com>wrote: >>>> >>>>> Ok, thank you very much >>>>> >>>>> >>>>> On Fri, Apr 4, 2014 at 10:06 AM, Jason Penton < >>>>> jason.pen...@smilecoms.com> wrote: >>>>> >>>>>> master, yes >>>>>> >>>>>> utils/kamctl/mysql/ >>>>>> >>>>>> >>>>>> On Fri, Apr 4, 2014 at 11:02 AM, Andrea Meroni >>>>>> <rucola8...@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.pen...@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 < >>>>>>>> rucola8...@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 < >>>>>>>>> rucola8...@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.pen...@smilecoms.com <name.surn...@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.pen...@smilecoms.com <name.surn...@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.pen...@smilecoms.com <name.surn...@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.pentonjason.pen...@smilecoms.com <name.surn...@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
