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
