[Freeswitch-trunk] [commit] r6135 - in freeswitch/trunk: build conf src/mod/applications/mod_limit

Freeswitch SVN anthm at freeswitch.org
Thu Nov 1 15:05:48 EDT 2007


Author: anthm
Date: Thu Nov  1 15:05:48 2007
New Revision: 6135

Added:
   freeswitch/trunk/src/mod/applications/mod_limit/
   freeswitch/trunk/src/mod/applications/mod_limit/Makefile
   freeswitch/trunk/src/mod/applications/mod_limit/mod_limit.c
Modified:
   freeswitch/trunk/build/modules.conf.in
   freeswitch/trunk/conf/freeswitch.xml
   freeswitch/trunk/conf/modules.conf.xml

Log:
add mod_limit

Modified: freeswitch/trunk/build/modules.conf.in
==============================================================================
--- freeswitch/trunk/build/modules.conf.in	(original)
+++ freeswitch/trunk/build/modules.conf.in	Thu Nov  1 15:05:48 2007
@@ -6,6 +6,7 @@
 applications/mod_enum
 applications/mod_fifo
 applications/mod_voicemail
+applications/mod_limit
 #applications/mod_ivrtest
 #applications/mod_soundtouch
 #applications/mod_rss

Modified: freeswitch/trunk/conf/freeswitch.xml
==============================================================================
--- freeswitch/trunk/conf/freeswitch.xml	(original)
+++ freeswitch/trunk/conf/freeswitch.xml	Thu Nov  1 15:05:48 2007
@@ -62,6 +62,7 @@
     <!-- ivr.conf is used by mod_dptools -->
     <!--#include "ivr.conf.xml"-->
     <!--#include "voicemail.conf.xml"-->
+    <!--#include "limit.conf.xml"-->
 
     <!-- Dialplan Interfaces -->
     <!--#include "dialplan_directory.conf.xml"-->

Modified: freeswitch/trunk/conf/modules.conf.xml
==============================================================================
--- freeswitch/trunk/conf/modules.conf.xml	(original)
+++ freeswitch/trunk/conf/modules.conf.xml	Thu Nov  1 15:05:48 2007
@@ -38,6 +38,7 @@
     <load module="mod_dptools"/>
     <load module="mod_fifo"/>
     <load module="mod_voicemail"/>
+    <load module="mod_limit"/>
 
     <!-- Dialplan Interfaces -->
     <!-- <load module="mod_dialplan_directory"/> -->

Added: freeswitch/trunk/src/mod/applications/mod_limit/Makefile
==============================================================================
--- (empty file)
+++ freeswitch/trunk/src/mod/applications/mod_limit/Makefile	Thu Nov  1 15:05:48 2007
@@ -0,0 +1,3 @@
+BASE=../../../..
+include $(BASE)/build/modmake.rules
+LOCAL_CFLAGS += `if test -f $(BASE)/.libs/libfreeswitch_la-switch_odbc.o ; then echo -DSWITCH_HAVE_ODBC; fi ;`

Added: freeswitch/trunk/src/mod/applications/mod_limit/mod_limit.c
==============================================================================
--- (empty file)
+++ freeswitch/trunk/src/mod/applications/mod_limit/mod_limit.c	Thu Nov  1 15:05:48 2007
@@ -0,0 +1,391 @@
+/* 
+ * FreeSWITCH Modular Media Switching Software Library / Soft-Switch Application
+ * Copyright (C) 2005/2006, Anthony Minessale II <anthmct at yahoo.com>
+ *
+ * Version: MPL 1.1
+ *
+ * The contents of this file are subject to the Mozilla Public License Version
+ * 1.1 (the "License"); you may not use this file except in compliance with
+ * the License. You may obtain a copy of the License at
+ * http://www.mozilla.org/MPL/
+ *
+ * Software distributed under the License is distributed on an "AS IS" basis,
+ * WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License
+ * for the specific language governing rights and limitations under the
+ * License.
+ *
+ * The Original Code is FreeSWITCH Modular Media Switching Software Library / Soft-Switch Application
+ *
+ * The Initial Developer of the Original Code is
+ * Anthony Minessale II <anthmct at yahoo.com>
+ * Portions created by the Initial Developer are Copyright (C)
+ * the Initial Developer. All Rights Reserved.
+ *
+ * Contributor(s):
+ * 
+ * Anthony Minessale II <anthmct at yahoo.com>
+ * Neal Horman <neal at wanlink dot com>
+ *
+ *
+ * mod_limit.c -- Framework Demo Module
+ *
+ */
+#include <switch.h>
+#ifdef SWITCH_HAVE_ODBC
+#include <switch_odbc.h>
+#endif
+
+SWITCH_MODULE_LOAD_FUNCTION(mod_limit_load);
+SWITCH_MODULE_DEFINITION(mod_limit, mod_limit_load, NULL, NULL);
+
+static struct {
+    switch_memory_pool_t *pool;
+    char hostname[256];
+    char *dbname;
+    char *odbc_dsn;
+    switch_mutex_t *mutex;
+#ifdef SWITCH_HAVE_ODBC
+	switch_odbc_handle_t *master_odbc;
+#else
+	void *filler1;
+#endif
+} globals;
+
+static char limit_sql[] =
+	"CREATE TABLE limit_data (\n"
+	"   hostname   VARCHAR(255),\n"
+	"   realm      VARCHAR(255),\n"
+	"   id         VARCHAR(255),\n" 
+	"   uuid       VARCHAR(255)\n"
+	");\n";
+
+
+
+static switch_status_t limit_execute_sql(char *sql, switch_mutex_t *mutex)
+{
+	switch_core_db_t *db;
+    switch_status_t status = SWITCH_STATUS_SUCCESS;
+
+	if (mutex) {
+		switch_mutex_lock(mutex);
+	}
+
+#ifdef SWITCH_HAVE_ODBC
+    if (globals.odbc_dsn) {
+		SQLHSTMT stmt;
+		if (switch_odbc_handle_exec(globals.master_odbc, sql, &stmt) != SWITCH_ODBC_SUCCESS) {
+			char *err_str;
+			err_str = switch_odbc_handle_get_error(globals.master_odbc, stmt);
+			switch_log_printf(SWITCH_CHANNEL_LOG, SWITCH_LOG_ERROR, "ERR: [%s]\n[%s]\n", sql, switch_str_nil(err_str));
+			switch_safe_free(err_str);
+            status = SWITCH_STATUS_FALSE;
+		}
+		SQLFreeHandle(SQL_HANDLE_STMT, stmt);
+	} else {
+#endif
+		if (!(db = switch_core_db_open_file(globals.dbname))) {
+			switch_log_printf(SWITCH_CHANNEL_LOG, SWITCH_LOG_ERROR, "Error Opening DB %s\n", globals.dbname);
+            status = SWITCH_STATUS_FALSE;
+			goto end;
+		}
+
+		status = switch_core_db_persistant_execute(db, sql, 25);
+		switch_core_db_close(db);
+
+#ifdef SWITCH_HAVE_ODBC
+    }
+#endif
+
+
+ end:
+	if (mutex) {
+		switch_mutex_unlock(mutex);
+	}
+
+    return status;
+}
+
+
+static switch_bool_t limit_execute_sql_callback(switch_mutex_t *mutex,
+                                                char *sql,
+                                                switch_core_db_callback_func_t callback,
+                                                void *pdata)
+{
+	switch_bool_t ret = SWITCH_FALSE;
+	switch_core_db_t *db;
+	char *errmsg = NULL;
+	
+	if (mutex) {
+        switch_mutex_lock(mutex);
+    }
+
+
+#ifdef SWITCH_HAVE_ODBC
+    if (globals.odbc_dsn) {
+		switch_odbc_handle_callback_exec(globals.master_odbc, sql, callback, pdata);
+	} else {
+#endif
+
+
+
+		if (!(db = switch_core_db_open_file(globals.dbname))) {
+			switch_log_printf(SWITCH_CHANNEL_LOG, SWITCH_LOG_ERROR, "Error Opening DB %s\n", globals.dbname);
+			goto end;
+		}
+
+	
+		switch_core_db_exec(db, sql, callback, pdata, &errmsg);
+
+		if (errmsg) {
+			switch_log_printf(SWITCH_CHANNEL_LOG, SWITCH_LOG_ERROR, "SQL ERR: [%s] %s\n", sql, errmsg);
+			free(errmsg);
+		}
+
+		if (db) {
+			switch_core_db_close(db);
+		}
+
+#ifdef SWITCH_HAVE_ODBC
+    }
+#endif
+
+
+ end:
+
+	if (mutex) {
+        switch_mutex_unlock(mutex);
+    }
+	
+
+
+	return ret;
+
+}
+
+
+static switch_status_t do_config()
+{
+	char *cf = "limit.conf";
+	switch_xml_t cfg, xml, settings, param;
+    switch_core_db_t *db;
+    switch_status_t status = SWITCH_STATUS_SUCCESS;
+    char *odbc_user = NULL;
+    char *odbc_pass = NULL;
+
+	if (!(xml = switch_xml_open_cfg(cf, &cfg, NULL))) {
+		switch_log_printf(SWITCH_CHANNEL_LOG, SWITCH_LOG_ERROR, "open of %s failed\n", cf);
+		return SWITCH_STATUS_TERM;
+	}
+    
+	if ((settings = switch_xml_child(cfg, "settings"))) {
+		for (param = switch_xml_child(settings, "param"); param; param = param->next) {
+			char *var = (char *) switch_xml_attr_soft(param, "name");
+			char *val = (char *) switch_xml_attr_soft(param, "value");
+            
+			if (!strcasecmp(var, "debug")) {
+                
+            } else if (!strcasecmp(var, "odbc-dsn")) {
+#ifdef SWITCH_HAVE_ODBC
+                globals.odbc_dsn = switch_core_strdup(globals.pool, val);
+                if ((odbc_user = strchr(globals.odbc_dsn, ':'))) {
+                    *odbc_user++ = '\0';
+                }
+                if ((odbc_pass = strchr(odbc_user, ':'))) {
+                    *odbc_pass++ = '\0';
+                }
+#else
+                switch_log_printf(SWITCH_CHANNEL_LOG, SWITCH_LOG_ERROR, "ODBC IS NOT AVAILABLE!\n");
+#endif
+
+            }
+        }
+    }
+
+    if (switch_strlen_zero(globals.odbc_dsn) || switch_strlen_zero(odbc_user) || switch_strlen_zero(odbc_pass)) {
+        globals.dbname = "call_limit";
+    }
+    
+
+#ifdef SWITCH_HAVE_ODBC
+    if (globals.odbc_dsn) {
+        if (!(globals.master_odbc = switch_odbc_handle_new(globals.odbc_dsn, odbc_user, odbc_pass))) {
+            switch_log_printf(SWITCH_CHANNEL_LOG, SWITCH_LOG_CRIT, "Cannot Open ODBC Database!\n");
+            status = SWITCH_STATUS_FALSE;
+            goto done;
+        }
+        if (switch_odbc_handle_connect(globals.master_odbc) != SWITCH_ODBC_SUCCESS) {
+            switch_log_printf(SWITCH_CHANNEL_LOG, SWITCH_LOG_CRIT, "Cannot Open ODBC Database!\n");
+            status = SWITCH_STATUS_FALSE;
+            goto done;
+        }
+        
+        switch_log_printf(SWITCH_CHANNEL_LOG, SWITCH_LOG_INFO, "Connected ODBC DSN: %s\n", globals.odbc_dsn);
+        switch_odbc_handle_exec(globals.master_odbc, limit_sql, NULL);
+    } else {
+#endif
+        if ((db = switch_core_db_open_file(globals.dbname))) {
+            switch_core_db_test_reactive(db, "select * from limit_data", NULL, limit_sql);
+        } else {
+            switch_log_printf(SWITCH_CHANNEL_LOG, SWITCH_LOG_CRIT, "Cannot Open SQL Database!\n");
+            status = SWITCH_STATUS_FALSE;
+            goto done;
+        }
+        switch_core_db_close(db);
+#ifdef SWITCH_HAVE_ODBC
+    }           
+#endif
+
+ done:
+
+    return status;
+
+}
+
+static switch_status_t hanguphook(switch_core_session_t *session)
+{
+    switch_channel_t *channel;
+	switch_channel_state_t state;
+    const char *realm = NULL;
+    const char *id = NULL;
+    char *sql = NULL;
+
+	channel = switch_core_session_get_channel(session);
+	assert(channel != NULL);
+
+	state = switch_channel_get_state(channel);
+
+    if (state == CS_HANGUP || state == CS_RING) {
+        id = switch_channel_get_variable(channel, "limit_id");
+        realm = switch_channel_get_variable(channel, "limit_realm");
+        sql = switch_mprintf("delete from limit_data where uuid='%q' and hostname='%q' and realm='%q'and id='%q';", 
+                             switch_core_session_get_uuid(session), globals.hostname, realm, id);
+        printf("wtf [%s]\n", sql);
+        limit_execute_sql(sql, globals.mutex);
+        switch_safe_free(sql);
+        switch_core_event_hook_remove_state_change(session, hanguphook);
+    }
+    return SWITCH_STATUS_SUCCESS;
+}
+
+struct callback {
+    char *buf;
+    size_t len;
+    int matches;
+};
+typedef struct callback callback_t;
+static int sql2str_callback(void *pArg, int argc, char **argv, char **columnNames)
+{
+	callback_t *cbt = (callback_t *) pArg;
+
+	switch_copy_string(cbt->buf, argv[0], cbt->len);
+	cbt->matches++;
+	return 0;
+}
+
+
+#define LIMIT_USAGE "<realm> <id> <max>"
+#define LIMIT_DESC "limit access to an extension"
+
+SWITCH_STANDARD_APP(limit_function)
+{
+    int argc = 0;
+    char *argv[6] = { 0 };
+    char *mydata = NULL;
+    char *sql = NULL;
+    char *realm = NULL;
+    char *id = NULL;
+    int max = 0, got = 0;
+    char buf[80] = "";
+    callback_t cbt = { 0 };
+    switch_channel_t *channel;
+
+	channel = switch_core_session_get_channel(session);
+	assert(channel != NULL);
+
+    if (!switch_strlen_zero(data)) {
+        mydata = switch_core_session_strdup(session, data);
+        argc = switch_separate_string(mydata, ' ', argv, (sizeof(argv) / sizeof(argv[0])));
+    }
+
+    if (argc < 3) {
+        switch_log_printf(SWITCH_CHANNEL_LOG, SWITCH_LOG_WARNING, "USAGE: limit %s\n", LIMIT_USAGE);
+        return;
+    }
+
+
+    switch_mutex_lock(globals.mutex);
+
+    
+    
+    realm = argv[0];
+    id = argv[1];
+    max = atoi(argv[2]);
+
+    if (max < 0) {
+        max = 0;
+    }
+    
+    switch_channel_set_variable(channel, "limit_realm", realm);
+    switch_channel_set_variable(channel, "limit_id", id);
+    switch_channel_set_variable(channel, "limit_max", argv[2]);
+
+    cbt.buf = buf;
+    cbt.len = sizeof(buf);
+    sql = switch_mprintf("select count(hostname) from limit_data where realm='%q' and id='%q'", realm, id);
+    limit_execute_sql_callback(NULL, sql, sql2str_callback, &cbt);
+    got = atoi(buf);
+
+    if (got + 1 > max) {
+        switch_ivr_session_transfer(session, "limit_exceeded", NULL, NULL);
+        goto done;
+    }
+
+    switch_core_event_hook_add_state_change(session, hanguphook);
+    sql = switch_mprintf("insert into limit_data values('%q','%q','%q','%q');", globals.hostname, realm, id, switch_core_session_get_uuid(session));
+    limit_execute_sql(sql, NULL);
+    switch_safe_free(sql);
+
+
+ done:
+
+    switch_mutex_unlock(globals.mutex);
+
+}
+
+
+SWITCH_MODULE_LOAD_FUNCTION(mod_limit_load)
+{
+    switch_status_t status;
+	switch_application_interface_t *app_interface;
+
+    memset(&globals, 0, sizeof(&globals));
+    gethostname(globals.hostname, sizeof(globals.hostname));
+    globals.pool = pool;
+
+    if ((status = do_config() != SWITCH_STATUS_SUCCESS)) {
+        return status;
+    }
+
+    switch_mutex_init(&globals.mutex, SWITCH_MUTEX_NESTED, globals.pool);
+    
+    /* connect my internal structure to the blank pointer passed to me */
+    *module_interface = switch_loadable_module_create_module_interface(pool, modname);
+
+	SWITCH_ADD_APP(app_interface, "limit", "Limit", LIMIT_DESC, limit_function, LIMIT_USAGE, SAF_NONE);
+
+    /* indicate that the module should continue to be loaded */
+    return SWITCH_STATUS_SUCCESS;
+}
+
+
+
+/* For Emacs:
+ * Local Variables:
+ * mode:c
+ * indent-tabs-mode:nil
+ * tab-width:4
+ * c-basic-offset:4
+ * End:
+ * For VIM:
+ * vim:set softtabstop=4 shiftwidth=4 tabstop=4 expandtab:
+ */



More information about the Freeswitch-trunk mailing list