From a5e941b56ea72044c4dadd9bdb8221cb919bea85 Mon Sep 17 00:00:00 2001 From: markster Date: Fri, 11 Jun 2004 00:12:35 +0000 Subject: Merge res_odbc and res_config git-svn-id: http://svn.digium.com/svn/asterisk/trunk@3186 f38db490-d61c-443f-a65b-d21fe96a405b --- configs/res_odbc.conf.sample | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) create mode 100755 configs/res_odbc.conf.sample (limited to 'configs/res_odbc.conf.sample') diff --git a/configs/res_odbc.conf.sample b/configs/res_odbc.conf.sample new file mode 100755 index 000000000..144eb6a95 --- /dev/null +++ b/configs/res_odbc.conf.sample @@ -0,0 +1,20 @@ +;;; odbc setup file + +[mysql1] +dsn => MySQL-asterisk +username => myuser +password => mypass +pre-connect => yes + + +[mysql2] +dsn => MySQL-asterisk +username => myuser +password => mypass +pre-connect => yes + + + + + + -- cgit v1.2.3 From 5b49f62b7cfc30451990f0e5b62f74e102144c87 Mon Sep 17 00:00:00 2001 From: markster Date: Sun, 28 Nov 2004 21:28:30 +0000 Subject: Add ability to store voicemail in ODBC database git-svn-id: http://svn.digium.com/svn/asterisk/trunk@4349 f38db490-d61c-443f-a65b-d21fe96a405b --- configs/res_odbc.conf.sample | 18 +++++++++--------- 1 file changed, 9 insertions(+), 9 deletions(-) (limited to 'configs/res_odbc.conf.sample') diff --git a/configs/res_odbc.conf.sample b/configs/res_odbc.conf.sample index 144eb6a95..6b162a644 100755 --- a/configs/res_odbc.conf.sample +++ b/configs/res_odbc.conf.sample @@ -1,17 +1,17 @@ ;;; odbc setup file -[mysql1] -dsn => MySQL-asterisk -username => myuser -password => mypass +[asterisk] +dsn => asterisk +;username => myuser +;password => mypass pre-connect => yes -[mysql2] -dsn => MySQL-asterisk -username => myuser -password => mypass -pre-connect => yes +;[mysql2] +;dsn => MySQL-asterisk +;username => myuser +;password => mypass +;pre-connect => yes -- cgit v1.2.3 From 24c1e3c22259fee9f8a08911d5e5c6e2604ead18 Mon Sep 17 00:00:00 2001 From: kpfleming Date: Tue, 29 Nov 2005 18:24:39 +0000 Subject: git-svn-id: http://svn.digium.com/svn/asterisk/trunk@7221 f38db490-d61c-443f-a65b-d21fe96a405b --- configs/res_odbc.conf.sample | 0 1 file changed, 0 insertions(+), 0 deletions(-) mode change 100755 => 100644 configs/res_odbc.conf.sample (limited to 'configs/res_odbc.conf.sample') diff --git a/configs/res_odbc.conf.sample b/configs/res_odbc.conf.sample old mode 100755 new mode 100644 -- cgit v1.2.3 From 603200e1acd29560d468013e5b94b04c5802c3e1 Mon Sep 17 00:00:00 2001 From: tilghman Date: Thu, 8 Dec 2005 23:33:08 +0000 Subject: Document two keywords that were previously missing git-svn-id: http://svn.digium.com/svn/asterisk/trunk@7405 f38db490-d61c-443f-a65b-d21fe96a405b --- configs/res_odbc.conf.sample | 21 ++++++++++++++++----- 1 file changed, 16 insertions(+), 5 deletions(-) (limited to 'configs/res_odbc.conf.sample') diff --git a/configs/res_odbc.conf.sample b/configs/res_odbc.conf.sample index 6b162a644..59d5c68c3 100644 --- a/configs/res_odbc.conf.sample +++ b/configs/res_odbc.conf.sample @@ -1,17 +1,28 @@ ;;; odbc setup file +; ENV is a global set of environmental variables that will get set. +; Note that all environmental variables can be seen by all connections, +; so you can't have different values for different connections. +[ENV] +INFORMIXSERVER => my_special_database +INFORMIXDIR => /opt/informix + +; All other sections are arbitrary names for database connections. + [asterisk] +enabled => yes dsn => asterisk ;username => myuser ;password => mypass pre-connect => yes -;[mysql2] -;dsn => MySQL-asterisk -;username => myuser -;password => mypass -;pre-connect => yes +[mysql2] +enabled => no +dsn => MySQL-asterisk +username => myuser +password => mypass +pre-connect => yes -- cgit v1.2.3 From 6e09cb5e8914384748b0f087e46643f08342c6d4 Mon Sep 17 00:00:00 2001 From: tilghman Date: Thu, 21 Sep 2006 23:24:41 +0000 Subject: Twould help if we actually documented how the new features in res_odbc actually work. (Oops) git-svn-id: http://svn.digium.com/svn/asterisk/branches/1.4@43464 f38db490-d61c-443f-a65b-d21fe96a405b --- configs/res_odbc.conf.sample | 12 +++++++++++- 1 file changed, 11 insertions(+), 1 deletion(-) (limited to 'configs/res_odbc.conf.sample') diff --git a/configs/res_odbc.conf.sample b/configs/res_odbc.conf.sample index 59d5c68c3..2642676bf 100644 --- a/configs/res_odbc.conf.sample +++ b/configs/res_odbc.conf.sample @@ -24,7 +24,17 @@ username => myuser password => mypass pre-connect => yes - +; Certain servers, such as MS SQL Server and Sybase use the TDS protocol, which +; limits the number of active queries per connection to 1. By setting up pools +; of connections, Asterisk can be made to work with these servers. +[sqlserver] +enabled => no +dsn => mickeysoft +pooling => yes +limit => 5 +username => oscar +password => thegrouch +pre-connect => yes -- cgit v1.2.3 From 534a372d1a51be83ac151273cbca155b2fd17ae3 Mon Sep 17 00:00:00 2001 From: qwell Date: Thu, 8 Nov 2007 18:45:15 +0000 Subject: Avoid warnings on load when using sample configuration files. Issue 11195, patch by eliel. git-svn-id: http://svn.digium.com/svn/asterisk/branches/1.4@89115 f38db490-d61c-443f-a65b-d21fe96a405b --- configs/res_odbc.conf.sample | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'configs/res_odbc.conf.sample') diff --git a/configs/res_odbc.conf.sample b/configs/res_odbc.conf.sample index 2642676bf..16a1e6b05 100644 --- a/configs/res_odbc.conf.sample +++ b/configs/res_odbc.conf.sample @@ -10,7 +10,7 @@ INFORMIXDIR => /opt/informix ; All other sections are arbitrary names for database connections. [asterisk] -enabled => yes +enabled => no dsn => asterisk ;username => myuser ;password => mypass -- cgit v1.2.3 From e2576b4a0635ab0499ff83205f8c13540076e11e Mon Sep 17 00:00:00 2001 From: tilghman Date: Sun, 25 Nov 2007 17:17:10 +0000 Subject: We previously attempted to use the ESCAPE clause to set the escape delimiter to a backslash. Unfortunately, this does not universally work on all databases, since on databases which natively use the backslash as a delimiter, the backslash itself needs to be delimited, but on other databases that have no delimiter, backslashing the backslash causes an error. So the only solution that I can come up with is to create an option in res_odbc that explicitly specifies whether or not backslash is a native delimiter. If it is, we use it natively; if not, we use the ESCAPE clause to make it one. Reported by: elguero Patch by: tilghman (Closes issue #11364) git-svn-id: http://svn.digium.com/svn/asterisk/branches/1.4@89559 f38db490-d61c-443f-a65b-d21fe96a405b --- configs/res_odbc.conf.sample | 3 +++ 1 file changed, 3 insertions(+) (limited to 'configs/res_odbc.conf.sample') diff --git a/configs/res_odbc.conf.sample b/configs/res_odbc.conf.sample index 16a1e6b05..1cca8b0e7 100644 --- a/configs/res_odbc.conf.sample +++ b/configs/res_odbc.conf.sample @@ -35,6 +35,9 @@ limit => 5 username => oscar password => thegrouch pre-connect => yes +; Many databases have a default of '\' to escape special characters. MS SQL +; Server does not. +backslash_is_escape => no -- cgit v1.2.3 From 19cfd3cfc36ff3084365b21f43cd6ac0c1528083 Mon Sep 17 00:00:00 2001 From: tilghman Date: Mon, 21 Jan 2008 18:11:07 +0000 Subject: Permit the user to specify number of seconds that a connection may remain idle, which fixes a crash on reconnect with the MyODBC driver. (closes issue #11798) Reported by: Corydon76 Patches: 20080119__res_odbc__idlecheck.diff.txt uploaded by Corydon76 (license 14) Tested by: mvanbaak git-svn-id: http://svn.digium.com/svn/asterisk/branches/1.4@99341 f38db490-d61c-443f-a65b-d21fe96a405b --- configs/res_odbc.conf.sample | 5 +++++ 1 file changed, 5 insertions(+) (limited to 'configs/res_odbc.conf.sample') diff --git a/configs/res_odbc.conf.sample b/configs/res_odbc.conf.sample index 1cca8b0e7..4b5fe428f 100644 --- a/configs/res_odbc.conf.sample +++ b/configs/res_odbc.conf.sample @@ -23,6 +23,11 @@ dsn => MySQL-asterisk username => myuser password => mypass pre-connect => yes +; +; On some databases, the connection times out and a reconnection will be +; necessary. This setting configures the amount of time a connection +; may sit idle (in seconds) before a reconnection will be attempted. +;idlecheck => 3600 ; Certain servers, such as MS SQL Server and Sybase use the TDS protocol, which ; limits the number of active queries per connection to 1. By setting up pools -- cgit v1.2.3