sr-dev June 2013

sr-dev@lists.kamailio.org

33 participants
235 discussions

Asterisk 11.4.0+Kamailio 4.0.1 Integration

by Ravindra Gowda

Dear All, I am trying to integrate kamailio 4.0.1 server with Asterisk 11.4.0 in Ubuntu 12.04 LTS version. I tried it by using the following link : http://kb.asipto.com/asterisk:realtime:kamailio-4.0.x-asterisk-11.3.0-astdb. But after all, when i tried to start Kmailio server with /etc/init.d/kamailio start command , i am getting the following errors: asterisk-kamailio@asterisk- kamailio:/$ sudo /etc/init.d/kamailio start [sudo] password for asterisk-kamailio: /etc/init.d/kamailio: 1: /etc/init.d/kamailio: sed: not found /etc/init.d/kamailio: 118: /etc/init.d/kamailio: arithmetic expression: expecting primary: "" what could be the wrong, and how can i solve it? Please share your valuable suggestions on this. Any help will greatly appreciate. *Thank you and Best regards,* *R Ravindra **Gowda* *Engineer - Systems and Products*. *Thrikasa Technologies* *| Office: +91 40 23260434 | Mob: +918885284050 * *| Fax:+91 40 23221045* *| email: ravindra(a)thrikasa.in* *| Web: www.thrikasa.in* 'If you don't give up,you cannot fail'. The information contained in this communication is proprietary to Thrikasa Technologies., and/or third parties, may contain classified or privileged information, and is intended only for the use of the intended addressee thereof. If you are not the intended addressee, please be aware that any use, disclosure, distribution and/or copying of this communication is strictly prohibited.If you receive this communication in error, please notify the sender immediately and delete it from your computer.

10 years, 10 months

Asterisk 11.4.0 + Kamailio 4.0.1 integration

by Ravindra Gowda

Dear All, I am trying to integrate kamailio 4.0.1 server with Asterisk 11.4.0 in Ubuntu 12.04 LTS version. I tried it by using the following link : http://kb.asipto.com/asterisk:realtime:kamailio-4.0.x-asterisk-11.3.0-astdb. But after all, when i tried to start Kmailio server with /etc/init.d/kamailio start command , i am getting the following errors: asterisk-kamailio@asterisk-kamailio:/$ sudo /etc/init.d/kamailio start [sudo] password for asterisk-kamailio: /etc/init.d/kamailio: 1: /etc/init.d/kamailio: sed: not found /etc/init.d/kamailio: 118: /etc/init.d/kamailio: arithmetic expression: expecting primary: "" what could be the wrong, and how can i solve it? Please share your valuable suggestions on this. Any help will greatly appreciate. *Thank you and Best regards,* *R Ravindra **Gowda* *Engineer - Systems and Products*. *Thrikasa Technologies* *| Office: +91 40 23260434 | Mob: +918885284050 * *| Fax:+91 40 23221045* *| email: ravindra(a)thrikasa.in* *| Web: www.thrikasa.in* 'If you don't give up,you cannot fail'. The information contained in this communication is proprietary to Thrikasa Technologies., and/or third parties, may contain classified or privileged information, and is intended only for the use of the intended addressee thereof. If you are not the intended addressee, please be aware that any use, disclosure, distribution and/or copying of this communication is strictly prohibited.If you receive this communication in error, please notify the sender immediately and delete it from your computer.

10 years, 10 months

[tracker] Task opened: modules/lcr: use pv_cache_get on mod_init (Attachment added)

by sip-router

THIS IS AN AUTOMATED MESSAGE, DO NOT REPLY. A new Flyspray task has been opened. Details are below. User who did this - Víctor Seva (linuxmaniac) Attached to Project - sip-router Summary - modules/lcr: use pv_cache_get on mod_init Task Type - Improvement Category - Module Status - Unconfirmed Assigned To - Operating System - All Severity - Low Priority - Normal Reported Version - Development Due in Version - Undecided Due Date - Undecided Details - Use pv_cache_get instead of pv_parse_spec on mod_init. One or more files have been attached. More information can be found at the following URL: http://sip-router.org/tracker/index.php?do=details&task_id=306 You are receiving this message because you have requested it from the Flyspray bugtracking system. If you did not expect this message or don't want to receive mails in future, you can change your notification settings at the URL shown above.

10 years, 10 months

git:master: modules/usrloc: rpc statistics command update

by Juha Heinanen

Module: sip-router Branch: master Commit: 7cb062ce8eb9935b69298b61aa6a59450b97dbaf URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=7cb062c… Author: Juha Heinanen <jh(a)tutpro.com> Committer: Juha Heinanen <jh(a)tutpro.com> Date: Sat Jun 1 17:47:58 2013 +0300 modules/usrloc: rpc statistics command update - ul.db_users and ul.db_contacts now deal with unexpired records only - new command ul.db_expired_contacts tells number of expired contacts --- modules/usrloc/README | 16 ++++++++- modules/usrloc/doc/usrloc_admin.xml | 19 ++++++++++- modules/usrloc/ul_rpc.c | 61 ++++++++++++++++++++++++++++++++-- 3 files changed, 88 insertions(+), 8 deletions(-) diff --git a/modules/usrloc/README b/modules/usrloc/README index 79448c3..6b48425 100644 --- a/modules/usrloc/README +++ b/modules/usrloc/README @@ -89,6 +89,7 @@ Bogdan-Andrei Iancu 6.6. ul.add 6.7. ul.db_users 6.8. ul.db_contacts + 6.9. ul.db_expired_contacts 7. Statistics @@ -225,6 +226,7 @@ Chapter 1. Admin Guide 6.6. ul.add 6.7. ul.db_users 6.8. ul.db_contacts + 6.9. ul.db_expired_contacts 7. Statistics @@ -842,6 +844,7 @@ modparam("usrloc", "db_ops_ruid", 1) 6.6. ul.add 6.7. ul.db_users 6.8. ul.db_contacts + 6.9. ul.db_expired_contacts 6.1. ul.dump @@ -900,7 +903,8 @@ modparam("usrloc", "db_ops_ruid", 1) 6.7. ul.db_users - Tell number of different users (AoRs) in a location table. + Tell number of different users (AoRs) in a location table that have + unexpired contacts. Parameters: * table name - location table where the users are looked for, for @@ -908,7 +912,15 @@ modparam("usrloc", "db_ops_ruid", 1) 6.8. ul.db_contacts - Tell number of contacts in a location table. + Tell number of unexpired contacts in a location table. + + Parameters: + * table name - location table where the contacts are looked for, for + example, location. + +6.9. ul.db_expired_contacts + + Tell number of expired contacts in a location table. Parameters: * table name - location table where the contacts are looked for, for diff --git a/modules/usrloc/doc/usrloc_admin.xml b/modules/usrloc/doc/usrloc_admin.xml index 8720471..21e0c87 100644 --- a/modules/usrloc/doc/usrloc_admin.xml +++ b/modules/usrloc/doc/usrloc_admin.xml @@ -1163,7 +1163,7 @@ modparam("usrloc", "db_ops_ruid", 1) <function moreinfo="none">ul.db_users</function> </title> <para> - Tell number of different users (AoRs) in a location table. + Tell number of different users (AoRs) in a location table that have unexpired contacts. </para> <para>Parameters: </para> <itemizedlist> @@ -1178,7 +1178,22 @@ modparam("usrloc", "db_ops_ruid", 1) <function moreinfo="none">ul.db_contacts</function> </title> <para> - Tell number of contacts in a location table. + Tell number of unexpired contacts in a location table. + </para> + <para>Parameters: </para> + <itemizedlist> + <listitem><para> + <emphasis>table name</emphasis> - location table where the contacts are looked for, for example, location. + </para></listitem> + </itemizedlist> + </section> + + <section> + <title> + <function moreinfo="none">ul.db_expired_contacts</function> + </title> + <para> + Tell number of expired contacts in a location table. </para> <para>Parameters: </para> <itemizedlist> diff --git a/modules/usrloc/ul_rpc.c b/modules/usrloc/ul_rpc.c index 216d326..077b035 100644 --- a/modules/usrloc/ul_rpc.c +++ b/modules/usrloc/ul_rpc.c @@ -673,7 +673,7 @@ static void ul_rpc_db_users(rpc_t* rpc, void* ctx) memset(query, 0, QUERY_LEN); query_str.len = snprintf(query, QUERY_LEN, - "SELECT COUNT(DISTINCT %.*s, %.*s) FROM %.*s", + "SELECT COUNT(DISTINCT %.*s, %.*s) FROM %.*s WHERE (UNIX_TIMESTAMP(expires) = 0) OR (expires > NOW())", user_col.len, user_col.s, domain_col.len, domain_col.s, table.len, table.s); @@ -690,7 +690,7 @@ static void ul_rpc_db_users(rpc_t* rpc, void* ctx) } static const char* ul_rpc_db_users_doc[2] = { - "Tell number of different users (AoRs) in database table (db_mode!=0 only)", + "Tell number of different unexpired users (AoRs) in database table (db_mode!=0 only)", 0 }; @@ -727,7 +727,7 @@ static void ul_rpc_db_contacts(rpc_t* rpc, void* ctx) } memset(query, 0, QUERY_LEN); - query_str.len = snprintf(query, QUERY_LEN, "SELECT COUNT(*) FROM %.*s", + query_str.len = snprintf(query, QUERY_LEN, "SELECT COUNT(*) FROM %.*s WHERE (UNIX_TIMESTAMP(expires) = 0) OR (expires > NOW())", table.len, table.s); query_str.s = query; if (ul_dbf.raw_query(ul_dbh, &query_str, &res) < 0) { @@ -742,7 +742,59 @@ static void ul_rpc_db_contacts(rpc_t* rpc, void* ctx) } static const char* ul_rpc_db_contacts_doc[2] = { - "Tell number of contacts in database table (db_mode=3 only)", + "Tell number of unexpired contacts in database table (db_mode=3 only)", + 0 +}; + +static void ul_rpc_db_expired_contacts(rpc_t* rpc, void* ctx) +{ + str table = {0, 0}; + char query[QUERY_LEN]; + str query_str; + db1_res_t* res; + int count; + + if (db_mode == NO_DB) { + rpc->fault(ctx, 500, "Command is not supported in db_mode=0"); + return; + } + + if (rpc->scan(ctx, "S", &table) != 1) { + rpc->fault(ctx, 500, "Not enough parameters (table to lookup)"); + return; + } + + if (table.len + 22 > QUERY_LEN) { + rpc->fault(ctx, 500, "Too long database query"); + return; + } + + if (!DB_CAPABILITY(ul_dbf, DB_CAP_RAW_QUERY)) { + rpc->fault(ctx, 500, "Database does not support raw queries"); + return; + } + if (ul_dbf.use_table(ul_dbh, &table) < 0) { + rpc->fault(ctx, 500, "Failed to use table"); + return; + } + + memset(query, 0, QUERY_LEN); + query_str.len = snprintf(query, QUERY_LEN, "SELECT COUNT(*) FROM %.*s WHERE (UNIX_TIMESTAMP(expires) > 0) AND (expires <= NOW())", + table.len, table.s); + query_str.s = query; + if (ul_dbf.raw_query(ul_dbh, &query_str, &res) < 0) { + rpc->fault(ctx, 500, "Failed to query contact count"); + return; + } + + count = (int)VAL_INT(ROW_VALUES(RES_ROWS(res))); + ul_dbf.free_result(ul_dbh, res); + + rpc->add(ctx, "d", count); +} + +static const char* ul_rpc_db_expired_contacts_doc[2] = { + "Tell number of expired contacts in database table (db_mode=3 only)", 0 }; @@ -755,6 +807,7 @@ rpc_export_t ul_rpc[] = { {"ul.add", ul_rpc_add, ul_rpc_add_doc, 0}, {"ul.db_users", ul_rpc_db_users, ul_rpc_db_users_doc, 0}, {"ul.db_contacts", ul_rpc_db_contacts, ul_rpc_db_contacts_doc, 0}, + {"ul.db_expired_contacts", ul_rpc_db_expired_contacts, ul_rpc_db_expired_contacts_doc, 0}, {0, 0, 0, 0} };

10 years, 10 months

Kamailio 4.0.1 +Asterisk 11.4.0 Integration

by Ravindra Gowda

Dear All, I am trying to integrate kamailio 4.0.1 server with Asterisk 11.4.0 in Ubuntu 12.04 LTS version. I tried it by using the following link : http://kb.asipto.com/asterisk:realtime:kamailio-4.0.x-asterisk-11.3.0-astdb. But i am unable to accomplish it, i just ended with some mysql errors. I am very new to this aspect. So can anyone suggest me any other standard reference procedure or any tutorials to do this. PS: my host Architecture: i686 Any help will greatly appreciate. *Thank you and Best regards,* *R Ravindra **Gowda* *Thrikasa Technologies* *| Office: +91 40 23260434 | Mob: +918885284050 * *| Fax:+91 40 23221045* *| email: ravindra(a)thrikasa.in* *| Web: www.thrikasa.in* 'If you don't give up,you cannot fail'. The information contained in this communication is proprietary to Thrikasa Technologies., and/or third parties, may contain classified or privileged information, and is intended only for the use of the intended addressee thereof. If you are not the intended addressee, please be aware that any use, disclosure, distribution and/or copying of this communication is strictly prohibited.If you receive this communication in error, please notify the sender immediately and delete it from your computer.

10 years, 10 months

Jump to page:

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

sr-dev June 2013