Re: [SR-Users] P-CSCF using MYSQL database

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 &lt;rucola8968(a)gmail.com&gt;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&gt; 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 &lt;rucola8968(a)gmail.com&gt;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 &lt;rucola8968(a)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.penton(a)smilecoms.com&gt; 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&gt; 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&gt; wrote: >>>>>> >>>>>>> Ok, thank you very much >>>>>>> >>>>>>> >>>>>>> On Fri, Apr 4, 2014 at 10:06 AM, Jason Penton < >>>>>>> jason.penton(a)smilecoms.com&gt; wrote: >>>>>>> >>>>>>>> master, yes >>>>>>>> >>>>>>>> utils/kamctl/mysql/ >>>>>>>> >>>>>>>> >>>>>>>> On Fri, Apr 4, 2014 at 11:02 AM, Andrea Meroni < >>>>>>>> rucola8968(a)gmail.com&gt; 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&gt; 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&gt; 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&gt; 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.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 &lt;name.surname(a)smilecoms.com&gt; >>>>> 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 &lt;name.surname(a)smilecoms.com&gt; >> 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 >> >> >