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
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
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.comwrote:
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
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.comwrote:
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.comwrote:
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.comwrote:
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 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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
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.comwrote:
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.comwrote:
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.comwrote:
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 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@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
Ok, thank you very much
On Fri, Apr 4, 2014 at 10:06 AM, Jason Penton jason.penton@smilecoms.comwrote:
master, yes
utils/kamctl/mysql/
On Fri, Apr 4, 2014 at 11:02 AM, Andrea Meroni rucola8968@gmail.comwrote:
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.comwrote:
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.comwrote:
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 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@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 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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
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.comwrote:
master, yes
utils/kamctl/mysql/
On Fri, Apr 4, 2014 at 11:02 AM, Andrea Meroni rucola8968@gmail.comwrote:
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.comwrote:
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.comwrote:
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 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@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 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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
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.comwrote:
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.comwrote:
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.comwrote:
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.comwrote:
> 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 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@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 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@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
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.comwrote:
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.comwrote:
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.comwrote:
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.comwrote:
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.comwrote:
> 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.comwrote: > >> 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 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@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 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@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 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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
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.comwrote:
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.comwrote:
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.comwrote:
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.comwrote:
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 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@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 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@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 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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
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@gmail.com 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@gmail.comwrote:
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.comwrote:
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.comwrote:
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.comwrote:
> 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 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@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 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@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 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@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
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@smilecoms.comwrote:
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@gmail.comwrote:
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.comwrote:
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.comwrote:
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.comwrote:
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 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@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 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@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 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@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 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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
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 rucola8968@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@smilecoms.comwrote:
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@gmail.comwrote:
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.comwrote:
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.comwrote:
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.comwrote:
> 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 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@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 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@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 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@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 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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
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 rucola8968@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 rucola8968@gmail.comwrote:
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@smilecoms.comwrote:
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@gmail.comwrote:
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.comwrote:
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.comwrote:
> 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 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@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 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@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 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@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 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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
Hi Andrea,
Are you using master?
Cheers Jason
On Mon, Apr 7, 2014 at 11:57 AM, Andrea Meroni rucola8968@gmail.com 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 rucola8968@gmail.comwrote:
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 rucola8968@gmail.comwrote:
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@smilecoms.com
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@gmail.comwrote:
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.comwrote:
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.pentonjason.penton@smilecoms.comname.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@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 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@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 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@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 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@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
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@smilecoms.comwrote:
Hi Andrea,
Are you using master?
Cheers Jason
On Mon, Apr 7, 2014 at 11:57 AM, Andrea Meroni rucola8968@gmail.comwrote:
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 rucola8968@gmail.comwrote:
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 rucola8968@gmail.comwrote:
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@smilecoms.com> 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@gmail.comwrote:
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.comwrote:
> 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.pentonjason.penton@smilecoms.comname.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@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 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@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 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@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 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@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 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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
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 rucola8968@gmail.com 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@smilecoms.comwrote:
Hi Andrea,
Are you using master?
Cheers Jason
On Mon, Apr 7, 2014 at 11:57 AM, Andrea Meroni rucola8968@gmail.comwrote:
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 rucola8968@gmail.comwrote:
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 rucola8968@gmail.comwrote:
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@smilecoms.com> 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@gmail.comwrote:
> 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.pentonjason.penton@smilecoms.comname.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@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.pentonjason.penton@smilecoms.comname.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@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 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@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 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@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 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@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
Ok, sorry but i will do it in a couple of hours because i'm running Kamailio on VMs and i have to retrieve them
Andrea
On Mon, Apr 7, 2014 at 11:09 AM, Jason Penton jason.penton@smilecoms.comwrote:
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 rucola8968@gmail.comwrote:
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@smilecoms.com
wrote:
Hi Andrea,
Are you using master?
Cheers Jason
On Mon, Apr 7, 2014 at 11:57 AM, Andrea Meroni rucola8968@gmail.comwrote:
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 rucola8968@gmail.comwrote:
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 rucola8968@gmail.comwrote:
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@smilecoms.com> 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@gmail.comwrote: > >> 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.pentonjason.penton@smilecoms.comname.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@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.pentonjason.penton@smilecoms.comname.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@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 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@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 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@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 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@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 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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
cool, no proble, I suspect that there is a mismatch somewhere when searching for the registered contact. I should be able to see from the logs.
On Mon, Apr 7, 2014 at 12:12 PM, Andrea Meroni rucola8968@gmail.com wrote:
Ok, sorry but i will do it in a couple of hours because i'm running Kamailio on VMs and i have to retrieve them
Andrea
On Mon, Apr 7, 2014 at 11:09 AM, Jason Penton jason.penton@smilecoms.comwrote:
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 rucola8968@gmail.comwrote:
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@smilecoms.com> wrote:
Hi Andrea,
Are you using master?
Cheers Jason
On Mon, Apr 7, 2014 at 11:57 AM, Andrea Meroni rucola8968@gmail.comwrote:
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 rucola8968@gmail.comwrote:
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 rucola8968@gmail.comwrote:
> 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@smilecoms.com> 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@gmail.com >> > 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@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.pentonjason.penton@smilecoms.comname.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@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.pentonjason.penton@smilecoms.comname.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@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 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@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 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@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 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@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 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@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
Actually, i'm checking the logs while copying and doing my stuff and i'm not able to find any message from ims_registrar_pcscf ... The debug level is 5. Should i rise it? Isn't it the maximum?
Andrea
On Mon, Apr 7, 2014 at 11:14 AM, Jason Penton jason.penton@smilecoms.comwrote:
cool, no proble, I suspect that there is a mismatch somewhere when searching for the registered contact. I should be able to see from the logs.
On Mon, Apr 7, 2014 at 12:12 PM, Andrea Meroni rucola8968@gmail.comwrote:
Ok, sorry but i will do it in a couple of hours because i'm running Kamailio on VMs and i have to retrieve them
Andrea
On Mon, Apr 7, 2014 at 11:09 AM, Jason Penton <jason.penton@smilecoms.com
wrote:
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 rucola8968@gmail.comwrote:
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@smilecoms.com> wrote:
Hi Andrea,
Are you using master?
Cheers Jason
On Mon, Apr 7, 2014 at 11:57 AM, Andrea Meroni rucola8968@gmail.comwrote:
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 rucola8968@gmail.comwrote:
> 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 rucola8968@gmail.comwrote: > >> 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@smilecoms.com> 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@gmail.com> 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@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.pentonjason.penton@smilecoms.comname.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@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.pentonjason.penton@smilecoms.comname.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@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.pentonjason.penton@smilecoms.comname.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@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 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@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 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@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 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@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 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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
There's not a lot of logging in the ims_registrar_pcscf, but there should be quite a lot in ims_usrloc_pcscf...
On Mon, Apr 7, 2014 at 12:18 PM, Andrea Meroni rucola8968@gmail.com wrote:
Actually, i'm checking the logs while copying and doing my stuff and i'm not able to find any message from ims_registrar_pcscf ... The debug level is 5. Should i rise it? Isn't it the maximum?
Andrea
On Mon, Apr 7, 2014 at 11:14 AM, Jason Penton jason.penton@smilecoms.comwrote:
cool, no proble, I suspect that there is a mismatch somewhere when searching for the registered contact. I should be able to see from the logs.
On Mon, Apr 7, 2014 at 12:12 PM, Andrea Meroni rucola8968@gmail.comwrote:
Ok, sorry but i will do it in a couple of hours because i'm running Kamailio on VMs and i have to retrieve them
Andrea
On Mon, Apr 7, 2014 at 11:09 AM, Jason Penton < jason.penton@smilecoms.com> wrote:
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 rucola8968@gmail.comwrote:
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@smilecoms.com> wrote:
Hi Andrea,
Are you using master?
Cheers Jason
On Mon, Apr 7, 2014 at 11:57 AM, Andrea Meroni rucola8968@gmail.comwrote:
> 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 <rucola8968@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 <rucola8968@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@smilecoms.com> 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@gmail.com> 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@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 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@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.pentonjason.penton@smilecoms.comname.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@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.pentonjason.penton@smilecoms.comname.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@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 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@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 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@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 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@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 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@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
Got it, however i already verified that with the S-CSCF the DB storage works without making any changes, so there shouldn't be others problem for now
Cheers
Andrea
On Mon, Apr 7, 2014 at 11:21 AM, Jason Penton jason.penton@smilecoms.comwrote:
There's not a lot of logging in the ims_registrar_pcscf, but there should be quite a lot in ims_usrloc_pcscf...
On Mon, Apr 7, 2014 at 12:18 PM, Andrea Meroni rucola8968@gmail.comwrote:
Actually, i'm checking the logs while copying and doing my stuff and i'm not able to find any message from ims_registrar_pcscf ... The debug level is 5. Should i rise it? Isn't it the maximum?
Andrea
On Mon, Apr 7, 2014 at 11:14 AM, Jason Penton <jason.penton@smilecoms.com
wrote:
cool, no proble, I suspect that there is a mismatch somewhere when searching for the registered contact. I should be able to see from the logs.
On Mon, Apr 7, 2014 at 12:12 PM, Andrea Meroni rucola8968@gmail.comwrote:
Ok, sorry but i will do it in a couple of hours because i'm running Kamailio on VMs and i have to retrieve them
Andrea
On Mon, Apr 7, 2014 at 11:09 AM, Jason Penton < jason.penton@smilecoms.com> wrote:
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 rucola8968@gmail.comwrote:
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@smilecoms.com> wrote:
> Hi Andrea, > > Are you using master? > > Cheers > Jason > > > On Mon, Apr 7, 2014 at 11:57 AM, Andrea Meroni <rucola8968@gmail.com > > 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 < >> rucola8968@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 < >>> rucola8968@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@smilecoms.com> 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@gmail.com> 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@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 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@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.pentonjason.penton@smilecoms.comname.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@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.pentonjason.penton@smilecoms.comname.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@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 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@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 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@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 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@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 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@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 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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
Here we are. In this file you can find the messages refered to alice and bob's registrations and the call from alice to bob. Please tell me if you need more infos about that ... Meanwhile, thank u very much
Andrea
On Mon, Apr 7, 2014 at 11:18 AM, Andrea Meroni rucola8968@gmail.com wrote:
Actually, i'm checking the logs while copying and doing my stuff and i'm not able to find any message from ims_registrar_pcscf ... The debug level is 5. Should i rise it? Isn't it the maximum?
Andrea
On Mon, Apr 7, 2014 at 11:14 AM, Jason Penton jason.penton@smilecoms.comwrote:
cool, no proble, I suspect that there is a mismatch somewhere when searching for the registered contact. I should be able to see from the logs.
On Mon, Apr 7, 2014 at 12:12 PM, Andrea Meroni rucola8968@gmail.comwrote:
Ok, sorry but i will do it in a couple of hours because i'm running Kamailio on VMs and i have to retrieve them
Andrea
On Mon, Apr 7, 2014 at 11:09 AM, Jason Penton < jason.penton@smilecoms.com> wrote:
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 rucola8968@gmail.comwrote:
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@smilecoms.com> wrote:
Hi Andrea,
Are you using master?
Cheers Jason
On Mon, Apr 7, 2014 at 11:57 AM, Andrea Meroni rucola8968@gmail.comwrote:
> 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 <rucola8968@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 <rucola8968@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@smilecoms.com> 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@gmail.com> 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@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 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@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.pentonjason.penton@smilecoms.comname.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@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.pentonjason.penton@smilecoms.comname.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@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 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@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 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@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 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@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 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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
Forgot to mention: the log is relative to the P-CSCF
Andrea
On Mon, Apr 7, 2014 at 1:26 PM, Andrea Meroni rucola8968@gmail.com wrote:
Here we are. In this file you can find the messages refered to alice and bob's registrations and the call from alice to bob. Please tell me if you need more infos about that ... Meanwhile, thank u very much
Andrea
On Mon, Apr 7, 2014 at 11:18 AM, Andrea Meroni rucola8968@gmail.comwrote:
Actually, i'm checking the logs while copying and doing my stuff and i'm not able to find any message from ims_registrar_pcscf ... The debug level is 5. Should i rise it? Isn't it the maximum?
Andrea
On Mon, Apr 7, 2014 at 11:14 AM, Jason Penton <jason.penton@smilecoms.com
wrote:
cool, no proble, I suspect that there is a mismatch somewhere when searching for the registered contact. I should be able to see from the logs.
On Mon, Apr 7, 2014 at 12:12 PM, Andrea Meroni rucola8968@gmail.comwrote:
Ok, sorry but i will do it in a couple of hours because i'm running Kamailio on VMs and i have to retrieve them
Andrea
On Mon, Apr 7, 2014 at 11:09 AM, Jason Penton < jason.penton@smilecoms.com> wrote:
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 rucola8968@gmail.comwrote:
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@smilecoms.com> wrote:
> Hi Andrea, > > Are you using master? > > Cheers > Jason > > > On Mon, Apr 7, 2014 at 11:57 AM, Andrea Meroni <rucola8968@gmail.com > > 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 < >> rucola8968@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 < >>> rucola8968@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@smilecoms.com> 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@gmail.com> 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@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 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@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.pentonjason.penton@smilecoms.comname.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@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.pentonjason.penton@smilecoms.comname.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@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 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@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 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@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 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@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 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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
---------- Forwarded message ---------- From: Andrea Meroni rucola8968@gmail.com Date: Mon, Apr 7, 2014 at 1:26 PM Subject: Re: [SR-Users] P-CSCF using MYSQL database To: "Kamailio (SER) - Users Mailing List" sr-users@lists.sip-router.org
Here we are. In this file you can find the messages refered to alice and bob's registrations and the call from alice to bob. Please tell me if you need more infos about that ... Meanwhile, thank u very much
Andrea
On Mon, Apr 7, 2014 at 11:18 AM, Andrea Meroni rucola8968@gmail.com wrote:
Actually, i'm checking the logs while copying and doing my stuff and i'm not able to find any message from ims_registrar_pcscf ... The debug level is 5. Should i rise it? Isn't it the maximum?
Andrea
On Mon, Apr 7, 2014 at 11:14 AM, Jason Penton jason.penton@smilecoms.comwrote:
cool, no proble, I suspect that there is a mismatch somewhere when searching for the registered contact. I should be able to see from the logs.
On Mon, Apr 7, 2014 at 12:12 PM, Andrea Meroni rucola8968@gmail.comwrote:
Ok, sorry but i will do it in a couple of hours because i'm running Kamailio on VMs and i have to retrieve them
Andrea
On Mon, Apr 7, 2014 at 11:09 AM, Jason Penton < jason.penton@smilecoms.com> wrote:
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 rucola8968@gmail.comwrote:
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@smilecoms.com> wrote:
Hi Andrea,
Are you using master?
Cheers Jason
On Mon, Apr 7, 2014 at 11:57 AM, Andrea Meroni rucola8968@gmail.comwrote:
> 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 <rucola8968@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 <rucola8968@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@smilecoms.com> 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@gmail.com> 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@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 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@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.pentonjason.penton@smilecoms.comname.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@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.pentonjason.penton@smilecoms.comname.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@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 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@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 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@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 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@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 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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
-
Andrea Meroni -
Jason Penton