search for: dispositionstring

...14567]: cdr_odbc.c:133 odbc_log: Unable to retrieve database handle. CDR failed. I can successfully connect with iSQL so ODBCINST and ODBC ini files must be okay. I have modified /etc/asterisk/cdr_odbc.conf to include :- [global] dsn=asterisk username=asterisk password=******* ;loguniqueid=yes ;dispositionstring=yes table=cdr ;"cdr" is default table name usegmtime=yes ; set to "yes" to log in GMT What am I doing wrong please ? Best Regards, -- SplatNIX IT Services :: Innovation through collaboration

...r/log/odbc-asterisk /etc/asterisk/res_odbc.conf: [asterisk] enabled => yes dsn => asterisk username => asterisk password => exodus_2009 pre-connect => yes /etc/asterisk/cdr_odbc.conf: ; cdr_odbc.conf ; [global] dsn=asterisk username=asterisk password=exodus_2009 loguniqueid=yes dispositionstring=yes table=cdr ;"cdr" is default table name usegmtime=no ; set to "yes" to log in GMT ---------------------------------------------------------------------------------------------------------- Any ideas?

Hi, I have configured the cdr throught ODBC with this files: /etc/cdr_odbc.conf [global] dsn=asterisk2 ;loguniqueid=yes dispositionstring=yes table=cdr ;"cdr" is default table name usegmtime=no ; set to "yes" to log in GMT hrtime=yes ;Enables microsecond accuracy with the billsec and duration fields /etc/cdr.conf [general] enable=yes unanswered = yes /etc/res_odbc.conf [asterisk] enable...

...et up the same odbc database for func_odbc, and registered my custom SQL functions and can access these (the db manager shows that this session is connected) cdr.conf ========== [general] enable=yes cdr_odbc.conf ========== [general] dsn=mydsn username=myuser password=mypassword loguniqueid=yes dispositionstring=yes table=PUB.cdr ;"cdr" is default table name usegmtime=no ; set to "yes" to log in GMT I must be missing something really really obvious here and would appreciate any help Julian

...for asterisk. /etc/asterisk/res_odbc.conf ----------------------------- [mysql] enabled => yes dsn => MySQL-asterisk username => asterisk password => qpalym pre-connect => yes and /etc/asterisk/cdr_odbc.conf ---------------------------- [global] dsn=MySQL-asterisk loguniqueid=yes dispositionstring=yes table=cdr But after a call hangup I get the following error: cdr_odbc.c: Unable to retrieve database handle. CDR failed. What is going wrong here, please? -Thorsten-

...if my config is off. mySQL 5 Asterisk branch/1.4 current rev cdr.conf [general] enabled=yes batch=no size=100 time=300 scheduleronly=no endbeforehexten=no safeshutdown=yes cdr_manager.conf [general] enabled=yes cdr_odbc.conf [global] dsn=asterisk username=user password=password loguniqueid=yes dispositionstring=yes table=cdr ;"cdr" is default table name ;usegmtime=no ; set to "yes" to log in GMT loaded files cdr_manager.so cdr_odbc.so cdr_csv.so --------------------------------------------------------------...

; ; cdr_odbc.conf ; ;[global] ;dsn=MySQL-test ;username=username ;password=password ;loguniqueid=yes ;dispositionstring=yes ;table=cdr ;"cdr" is default table name ;usegmtime=no ; set to "yes" to log in GMT Though, reading from https://issues.asterisk.org/view.php?id=15021, it seems that lines username= and password= in cdr_odbc.conf are not used anymore (the fields in...

Hello,

...] usegmtime=yes ; log date/time in GMT. Default is "no" loguniqueid=yes ; log uniqueid. Default is "no" loguserfield=yes ; log user field. Default is "no" ; ; cdr_odbc.conf ; [global] username => sa password => password dsn => DSN_NAME loguniqueid=yes dispositionstring=yes table=cdr usegmtime=yes a16-q1:/etc/asterisk# 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...

Hi, Has anyone made a successfull instalation of cdr_odbc?? I've install unixODBC-2.2.8 (made my own RPM) and then built the module. I'm trying to send the cdrs to a M$ SQL server. The sql connection works because I can do any query via isql. When I do the calls I get the following output on the asterisk console: -- Executing Hangup("SIP/test1-a5e1", "") in new

...DB2 Database name voiceml Tables created on server AST_CDR AST_CONFIG VOICEMESSAGES I've checked the unix ODBC side of things and I can connect to the DB2 database o.k. I've set up cdr_odbc.conf [global] dsn=voiceml username=<usernme> password=<password> loguniqueid=yes dispositionstring=yes table=ast_cdr ;"cdr" is default table name usegmtime=yes ; set to "yes" to log in GMT res_odbc.conf odbcstorage => voiceml [voiceml] enabled => yes dsn => voiceml username => <userid> password => <password> pre-connect =&gt...