Hi,
I'm migrating from sip-router/Kamailio 3.1, SER flavour to the latest dev version, with MySQL support.
I need to add attributes to domains, and therefore use the domain_attrs table. A handy command I used for that was ser_attr : ser_attr add domain=anydomain.voip attr=value
Is there something similar I can use under the Kamailio flavour? kamctl does not seem to help here, unless I missed an option.
Regards,
Philippe
Not all tables are supported by kamctl. If you are looking for a simple way to provision your tables, you can try the new provisioning module xhttp_pi: http://kamailio.org/docs/modules/devel/modules/xhttp_pi
To enable the module in your config simply add the lines provided in the example to your config: http://kamailio.org/docs/modules/devel/modules/xhttp_pi#id2531339
When you compile and install the module, a sample framework will be constructed with all the existing tables under: /usr/local/share/kamailio/xhttp_pi/pi_framework.xml Then you can edit the file by removing all the tables that are not used and add new db commands/actions as you need. A full example with all the possible commands and features can be found here: http://git.sip-router.org/cgi-bin/gitweb.cgi?p=sip-router;a=blob;f=examples/... Or in the source tree: ./examples/pi_framework.xml
In the future, a new script will be available to generate the the framework for tables defined in kamctlrc (same behavior as kamdbctl).
Regards, Ovidiu Sas
Thanks Ovidiu,
I installed the xhttp_pi module. Some information in the modules/xhttp_pi/README, probably mixed with xhttp_rpc, should be updated.
The 'loadmodule "xhttp_rpc.so"' instruction is missing, and should replace the 'loadmodule "xhttp_rpc.so"' line.
This line : modparam("xhttp_rpc", "xhttp_pi_root", "pi")
Should be changed with : modparam("xhttp_pi", "xhttp_pi_root", "pi")
And a default value should probably be set to the 'framework' parameter, otherwise, Kamailio will fail to start with this error : Jan 16 10:10:42 ks3095254 /usr/local/sbin/kamailio[19278]: ERROR: xhttp_pi [xhttp_pi.c:274]: missing framework
Thanks again,
Philippe
2013/1/9 Ovidiu Sas osas@voipembedded.com
Not all tables are supported by kamctl. If you are looking for a simple way to provision your tables, you can try the new provisioning module xhttp_pi: http://kamailio.org/docs/modules/devel/modules/xhttp_pi
To enable the module in your config simply add the lines provided in the example to your config: http://kamailio.org/docs/modules/devel/modules/xhttp_pi#id2531339
When you compile and install the module, a sample framework will be constructed with all the existing tables under: /usr/local/share/kamailio/xhttp_pi/pi_framework.xml Then you can edit the file by removing all the tables that are not used and add new db commands/actions as you need. A full example with all the possible commands and features can be found here:
http://git.sip-router.org/cgi-bin/gitweb.cgi?p=sip-router;a=blob;f=examples/... Or in the source tree: ./examples/pi_framework.xml
In the future, a new script will be available to generate the the framework for tables defined in kamctlrc (same behavior as kamdbctl).
Regards, Ovidiu Sas
-- VoIP Embedded, Inc. http://www.voipembedded.com
On Wed, Jan 9, 2013 at 9:54 AM, Philippe Sultan philippe.sultan@gmail.com wrote:
Hi,
I'm migrating from sip-router/Kamailio 3.1, SER flavour to the latest dev version, with MySQL support.
I need to add attributes to domains, and therefore use the domain_attrs table. A handy command I used for that was ser_attr : ser_attr add domain=anydomain.voip attr=value
Is there something similar I can use under the Kamailio flavour? kamctl
does
not seem to help here, unless I missed an option.
Regards,
Philippe
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
Hello Philippe,
Thank you for the report, I updated the documentation. The framework parameter was left intentionally blank to force the kamailio admin to set the proper location for framework file. Also, I updated the documentation with the new command: kamdbctl pframework create This will create a sample framework file that will have exactly the same tables as the ones configured in the db by the kamdbctl create command.
Regards, Ovidiu Sas
On Wed, Jan 16, 2013 at 4:49 AM, Philippe Sultan philippe.sultan@gmail.com wrote:
Thanks Ovidiu,
I installed the xhttp_pi module. Some information in the modules/xhttp_pi/README, probably mixed with xhttp_rpc, should be updated.
The 'loadmodule "xhttp_rpc.so"' instruction is missing, and should replace the 'loadmodule "xhttp_rpc.so"' line.
This line : modparam("xhttp_rpc", "xhttp_pi_root", "pi")
Should be changed with : modparam("xhttp_pi", "xhttp_pi_root", "pi")
And a default value should probably be set to the 'framework' parameter, otherwise, Kamailio will fail to start with this error : Jan 16 10:10:42 ks3095254 /usr/local/sbin/kamailio[19278]: ERROR: xhttp_pi [xhttp_pi.c:274]: missing framework
Thanks again,
Philippe
2013/1/9 Ovidiu Sas osas@voipembedded.com
Not all tables are supported by kamctl. If you are looking for a simple way to provision your tables, you can try the new provisioning module xhttp_pi: http://kamailio.org/docs/modules/devel/modules/xhttp_pi
To enable the module in your config simply add the lines provided in the example to your config: http://kamailio.org/docs/modules/devel/modules/xhttp_pi#id2531339
When you compile and install the module, a sample framework will be constructed with all the existing tables under: /usr/local/share/kamailio/xhttp_pi/pi_framework.xml Then you can edit the file by removing all the tables that are not used and add new db commands/actions as you need. A full example with all the possible commands and features can be found here:
http://git.sip-router.org/cgi-bin/gitweb.cgi?p=sip-router;a=blob;f=examples/... Or in the source tree: ./examples/pi_framework.xml
In the future, a new script will be available to generate the the framework for tables defined in kamctlrc (same behavior as kamdbctl).
Regards, Ovidiu Sas
-- VoIP Embedded, Inc. http://www.voipembedded.com
On Wed, Jan 9, 2013 at 9:54 AM, Philippe Sultan philippe.sultan@gmail.com wrote:
Hi,
I'm migrating from sip-router/Kamailio 3.1, SER flavour to the latest dev version, with MySQL support.
I need to add attributes to domains, and therefore use the domain_attrs table. A handy command I used for that was ser_attr : ser_attr add domain=anydomain.voip attr=value
Is there something similar I can use under the Kamailio flavour? kamctl does not seem to help here, unless I missed an option.
Regards,
Philippe
Hello,
On 1/9/13 3:54 PM, Philippe Sultan wrote:
Hi,
I'm migrating from sip-router/Kamailio 3.1, SER flavour to the latest dev version, with MySQL support.
I need to add attributes to domains, and therefore use the domain_attrs table. A handy command I used for that was ser_attr : ser_attr add domain=anydomain.voip attr=value
that module is now uid_domain and the tables names are prefixed with 'uid_'. I guess the tool can be configured to work with different table names.
Cheers, Daniel
Is there something similar I can use under the Kamailio flavour? kamctl does not seem to help here, unless I missed an option.
Regards,
Philippe
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
Thanks for the hint, Daniel.
Can you confirm I should use the modules/uid_domain module rather than modules_k/domain?
Philippe
2013/1/17 Daniel-Constantin Mierla miconda@gmail.com
Hello,
On 1/9/13 3:54 PM, Philippe Sultan wrote:
Hi,
I'm migrating from sip-router/Kamailio 3.1, SER flavour to the latest dev version, with MySQL support.
I need to add attributes to domains, and therefore use the domain_attrs table. A handy command I used for that was ser_attr : ser_attr add domain=anydomain.voip attr=value
that module is now uid_domain and the tables names are prefixed with 'uid_'. I guess the tool can be configured to work with different table names.
Cheers, Daniel
Is there something similar I can use under the Kamailio flavour? kamctl does not seem to help here, unless I missed an option.
Regards,
Philippe
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing listsr-users@lists.sip-router.orghttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
-- Daniel-Constantin Mierla - http://www.asipto.comhttp://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda Kamailio World Conference, April 16-17, 2013, Berlin