I was using 1.6.0.1 without any problems then my server died and i had to start everything from scratch. I retrieved my database and all config files from the backups without any problems. At the same time asterisk 1.6.0.5 was available for download and I installed this new version. Though when you run it; it actually says 1.6.0.3 ???
After that my cdr odbc stopped working. Again DB and my configuration files are all kept the same during this setup.
In my logs I have…
[Jan 29 23:03:23] NOTICE[9952]: res_odbc.c:251 load_odbc_config: Adding ENV var: INFORMIXSERVER=my_special_database
[Jan 29 23:03:23] NOTICE[9952]: res_odbc.c:251 load_odbc_config: Adding ENV var: INFORMIXDIR=/opt/informix
[Jan 29 23:03:23] NOTICE[9952]: res_odbc.c:606 odbc_obj_connect: Connecting ast-conf
[Jan 29 23:03:23] NOTICE[9952]: res_odbc.c:620 odbc_obj_connect: res_odbc: Connected to ast-conf [asterisk-odbc]
[Jan 29 23:03:23] NOTICE[9952]: res_odbc.c:340 load_odbc_config: Registered ODBC class 'ast-conf' dsn->[asterisk-odbc]
[Jan 29 23:03:23] NOTICE[9952]: res_odbc.c:823 load_module: res_odbc loaded.
res_odbc.so => (ODBC resource)
[Jan 29 23:03:23] NOTICE[9952]: config.c:1910 ast_config_engine_register: Registered Config Engine odbc
res_config_odbc loaded.
res_config_odbc.so => (Realtime ODBC configuration)
When i issue “odbc show all” I get the following
Name: ast-conf
DSN: asterisk-odbc
Pooled: No
Connected: Yes
issuing cdr show status prints
CDR logging: enabled
CDR mode: simple
CDR output unanswered calls: no
CDR registered backend: cdr-custom
CDR registered backend: ODBC
CDR registered backend: Adaptive ODBC
But after a call is completed I get the infamous "odbc_log: Unable to retrieve database handle. CDR failed. "
any ideas?
Thanks,
Vito