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
