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

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 &lt;rucola8968(a)gmail.com&gt;wrote;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 &lt;rucola8968(a)gmail.com&gt;wrote;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