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

Update: even with the UCT IMS client it didn't work, both with db mode 0 and 1. From Kamailio config file i checked out that the exported function that generates the issue is pcscf_is_registered. But why the check fails? Andrea On Mon, Apr 7, 2014 at 10:29 AM, Andrea Meroni &lt;rucola8968(a)gmail.com&gt;wrote;wrote: > 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 < >>>> rucola8968(a)gmail.com&gt; 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 >>> >>> >> > _______________________________________________ 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