[Asterisk-Users] Problem with cdr_odbc

[Ron Wellsted]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

onespell at yandex.ru wrote:
> 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!)
> 


> 
> cdr_odbc.conf
> -------------
> [global]
> dsn=asterisk

does this dsn match up with the entry in your odbc.ini file and does
that use a driver that is in the odbcinst.ini file?

- --
Ron Wellsted
ron at wellsted.org.uk http://www.wellsted.org.uk
N 52.567623, W 2.137621 Linux Counter No. 202120
FWD:519961
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.2 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iQEVAwUBRCsB90tP/KMNOfRbAQJbegf/SpYCgN7RllzXsVA9wJ7IfJG7CCQ974UZ
ZxGwecx+hkVw2iwbROjBht9IUBBs3w1IefRSSzqt+K4ojFKgdzOwLt43A6U8+b4n
moBWUd4gD5GmWf6w8a0Z9PjDPK3+kRP2ibd8TOa/5lygZa4P+OcW8/AuVO2thDQK
D2YfOQA035uvpyaDzd1D+TEI8kgQDGGLO4m8TX7t96OfM1U+CsleYmlxnBXefLsE
R3G8WivYXhxgnrRkj5MiV64nPjYYSjDpEtIoIs019pG7aY4pyrLEHapLr4zHDOhr
unia/S/0kB/V2wuEdIsheJT//7Vd76haYYZtqNI0lNXjcCVQyilSQw==
=VJ+z
-----END PGP SIGNATURE-----