search for: sanitysql

I tested this issue with version 13 and version 18. In res_odbc.conf, if I add a second, new data source like [asterisk] enabled=yes dsn=asterisk sanitysql => select 1 isolation => read_committed username=root ;password= pre-connect => yes forcecommit => yes connect_timeout => 10 negative_connection_cache => 0 max_connections =>500 my odbc.ini [cdr] Description = MySQL ODBC Driver Testing Driver = maria Socket = /v...

...for segfault, get backtrace, and all threads backtrace On 8/16/23 18:48, Federico wrote: > > I tested this issue with version 13 and version 18. > > In res_odbc.conf, if I add a second, new data source like > > [asterisk] > > enabled=yes > > dsn=asterisk > > sanitysql => select 1 > > isolation => read_committed > > username=root > > ;password= > > pre-connect => yes > > forcecommit => yes > > connect_timeout => 10 > > negative_connection_cache => 0 > > max_connections =>500 > > my odbc.in...

...hen starting up Run Asterisk straight from gdb Wait for segfault, get backtrace, and all threads backtrace On 8/16/23 18:48, Federico wrote: I tested this issue with version 13 and version 18. In res_odbc.conf, if I add a second, new data source like [asterisk] enabled=yes dsn=asterisk sanitysql => select 1 isolation => read_committed username=root ;password= pre-connect => yes forcecommit => yes connect_timeout => 10 negative_connection_cache => 0 max_connections =>500 my odbc.ini [cdr] Description = MySQL ODBC Driver Testing Driver = maria Socket = /v...

...= root Password = mypassword Port = 3306 Socket = /var/run/mysqld/mysqld.sock -------------- /etc/asterisk/res_odbc.conf lists below: [ENV] [asterisk] enabled => yes dsn => asterisk-connector password => mypassword pre-connect => yes sanitysql => select 1 pooling => yes idlecheck => 30 share_connections => yes limit => 1000 connect_timeout => 60 negative_connection_cache => 600 -------------- /etc/asterisk/cdr_adaptive_odbc.conf lists below: [cdr] connection=asterisk table=cdr alias start => calldate alias phone...

...On Thu, Aug 17, 2023 at 11:04 AM Federico <federico at digitalipvoice.com> wrote: > I tested this issue with version 13 and version 18. > > In res_odbc.conf, if I add a second, new data source like > > > > [asterisk] > > enabled=yes > > dsn=asterisk > > sanitysql => select 1 > > isolation => read_committed > > username=root > > ;password= > > pre-connect => yes > > forcecommit => yes > > connect_timeout => 10 > > negative_connection_cache => 0 > > max_connections =>500 > > > >...

...sr/lib64/libmaodbc.so FileUsage=1 Threading=0 /etc/odbc.ini or /etc/unixODBC/odbc.ini [strshk] Description = MySQL ODBC Driver Testing Driver = maria Server = 208.73.232.47 #free testing service User = anonymous Password = Database = strshk Option = 3 res_odbc.conf [strshk] enabled=yes dsn=strshk sanitysql => select 1 isolation => read_uncommitted username=anonymous password= pre-connect => yes forcecommit => yes connect_timeout => 10 negative_connection_cache => 300 max_connections=100 database=strshk func_odbc.conf [STRSHK] escapecommas=yes prefix=MYSQL dsn=strshk readsql=call st...

Hi list, yesterday I converted my voicemail.conf to realtime voicemail and also configured to store the voicemessages in a database using odbc as described here <http://www.voip-info.org/wiki/view/Asterisk+RealTime+Voicemail> and here <http://www.voip-info.org/wiki/view/Asterisk+Voicemail+ODBC+storage>. I am using asterisk 1.4.2 with mysql. I also installed the proper odbc driver for

...isk# cat cdr_adaptive_odbc.conf [first] connection=sqlserver table=cdr alias calldate => start a16-q1:/etc/asterisk# cat res_odbc.conf [ENV] [sqlserver] enabled => yes dsn => DSN_NAME share_connections => no limit => 5 username => sa password => password pre-connect => yes sanitysql => select count(*) from systables backslash_is_escape => no a16-q1:/etc/asterisk# ls asterisk.conf cdr.conf chan_dahdi.conf extensions.conf iax.conf modules.conf queuerules.conf res_odbc.conf cdr_adaptive_odbc.conf cdr_odbc.conf dialplan func_odbc.conf...

...= root Password = mypassword Port = 3306 Socket = /var/run/mysqld/mysqld.sock -------------- /etc/asterisk/res_odbc.conf lists below: [ENV] [asterisk] enabled => yes dsn => asterisk-connector password => mypassword pre-connect => yes sanitysql => select 1 idlecheck => 30 connect_timeout => 20 -------------- /etc/asterisk/cdr_adaptive_odbc.conf lists below: [cdr] connection=asterisk table=cdr alias start => calldate alias phoneno => phoneno alias userid => userid alias callerid => callerid -------------- asterisk&...

...= root Password = mypassword Port = 3306 Socket = /var/run/mysqld/mysqld.sock -------------- /etc/asterisk/res_odbc.conf lists below: [ENV] [asterisk] enabled => yes dsn => asterisk-connector password => mypassword pre-connect => yes sanitysql => select 1 idlecheck => 30 connect_timeout => 20 -------------- /etc/asterisk/cdr_adaptive_odbc.conf lists below: [cdr] connection=asterisk table=cdr alias start => calldate alias phoneno => phoneno alias userid => userid alias callerid => callerid -------------- asterisk&...

...= root Password = mypassword Port = 3306 Socket = /var/run/mysqld/mysqld.sock -------------- /etc/asterisk/res_odbc.conf lists below: [ENV] [asterisk] enabled => yes dsn => asterisk-connector password => mypassword pre-connect => yes sanitysql => select 1 idlecheck => 30 connect_timeout => 20 -------------- /etc/asterisk/cdr_adaptive_odbc.conf lists below: [cdr] connection=asterisk table=cdr alias start => calldate alias phoneno => phoneno alias userid => userid alias callerid => callerid -------------- asterisk&...

Hello Everyone, I have an installation where the client has a Microsoft SQL database that holds all of their case information. They would like the asterisk system to require users to enter a valid case number when making an outgoing call. I?m seeing some documentation regarding people using Microsoft SQL for CDR storage, however nothing regarding validating authentication using a Microsoft SQL