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

--

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