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

No, there is no know issue. can you send me the full debug log file? On Mon, Apr 7, 2014 at 12:07 PM, Andrea Meroni &lt;rucola8968(a)gmail.com&gt;wrote;wrote: > Yes, i'm using master. I browsed the tree searching the nested > function that generates the error (check failed) and it should be > getContactP(struct sip_msg* _m, udomain_t* _d) in > ims_registrar_pcscf/service_routes.c. I will try to do other tests > searching on which attribute the check fails. Meanwhile, if you don't mind, > please tell me if the it is a known bug or no, so maybe i can fix it :) > > Andrea > > > On Mon, Apr 7, 2014 at 11:02 AM, Jason Penton < > jason.penton(a)smilecoms.com&gt; wrote: > >> Hi Andrea, >> >> Are you using master? >> >> Cheers >> Jason >> >> >> On Mon, Apr 7, 2014 at 11:57 AM, Andrea Meroni &lt;rucola8968(a)gmail.com&gt;wrote;wrote: >> >>> 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 >>> > 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 >>>> > 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 < >>>>>> rucola8968(a)gmail.com&gt; 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.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.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 > > -- *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