[Asterisk-Users] Problem with cdr_odbc
onespell at yandex.ru
onespell at yandex.ru
Tue Mar 28 06:40:55 MST 2006
My Asterisk doesn't write CDR's to database via ODBC. Plz, anybody help
me to understand, what I am doing wrong.
Asterisk succesfully writes CDR's into the text log.
Database exists, unixODBC installed and configured properly (I can use
database from isql, Asterisk reads sipusers from it...).
"cdr_odbc" occurances in my "full" log:
Mar 28 15:11:44 VERBOSE[8753] logger.c: [cdr_odbc.so]Mar 28 15:11:44 VERBOSE[8753] logger.c: [cdr_odbc.so] => (ODBC CDR Backend)
Mar 28 15:11:44 DEBUG[8753] config.c: Parsing /usr/local/asterisk/etc/asterisk/cdr_odbc.conf
Mar 28 15:11:44 DEBUG[8753] cdr_odbc.c: cdr_odbc: Logging uniqueid
Mar 28 15:11:44 DEBUG[8753] cdr_odbc.c: cdr_odbc: Not logging in GMT
Mar 28 15:11:44 VERBOSE[8753] logger.c: -- cdr_odbc: dsn is asterisk
Mar 28 15:11:44 VERBOSE[8753] logger.c: -- cdr_odbc: username is astserver
Mar 28 15:11:44 VERBOSE[8753] logger.c: -- cdr_odbc: password is [secret]
Mar 28 15:11:44 VERBOSE[8753] logger.c: -- cdr_odbc: table is cdr
(and that's all!)
Asterisk's configs:
cdr.conf
--------
[general]
enable=yes
batch=no
safeshutdown=yes
cdr_manager.conf
----------------
[general]
enabled = no
cdr_odbc.conf
-------------
[global]
dsn=asterisk
username=astserver
password=12345
loguniqueid=yes
dispositionstring=yes
table=cdr ;"cdr" is default table name
;usegmtime=no ; set to "yes" to log in GMT
res_odbc.conf
-------------
[asterisk]
enabled => yes
dsn => asterisk
username => astserver
password => 12345
pre-connect => yes
extconfig.conf
--------------
[settings]
sipusers => odbc,asterisk,sip_buddies
sippeers => odbc,asterisk,sip_buddies
modules.conf
------------
[modules]
autoload=yes
preload => res_odbc.so
preload => res_config_odbc.so
load => cdr_odbc.so
noload => chan_iax2.so
noload => pbx_gtkconsole.so
noload => pbx_kdeconsole.so
noload => app_intercom.so
noload => chan_modem.so
noload => chan_modem_aopen.so
noload => chan_modem_bestdata.so
noload => chan_modem_i4l.so
load => res_musiconhold.so
noload => chan_alsa.so
[global]
More information about the asterisk-users
mailing list