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@gmail.com> wrote:

Ok, thank you very much

On Fri, Apr 4, 2014 at 10:06 AM, Jason Penton <jason.penton@smilecoms.com> wrote:

master, yes

utils/kamctl/mysql/

On Fri, Apr 4, 2014 at 11:02 AM, Andrea Meroni <rucola8968@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.penton@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 <rucola8968@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 <rucola8968@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.penton@smilecoms.com

www.smilecoms.com

This email is subject to the disclaimer of Smile Communications at http://www.smilecoms.com/home/email-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.penton@smilecoms.com

www.smilecoms.com

This email is subject to the disclaimer of Smile Communications at http://www.smilecoms.com/home/email-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