Thursday, August 19, 2010

Asterisk-CDR-ODBC Related Commands

The command list.
  1. CLI> cdr status
    sample out put:
    CDR logging: enabledCDR mode: simple
    CDR registered backend: cdr-custom
    CDR registered backend: csv
    CDR registered backend: cdr_manager

    Note:
  2. ; Database Call Detail Records
  3. load => cdr_odbc.so ; ODBC CDR Backend - Requires N/A

  4. #odbcinst -q -d
    sample out put:
    [PostgreSQL]

    note:
    if your /etc/odbcinst.ini file contain you get above sample output,
    [PostgreSQL]
    Description = ODBC for PostgreSQL
    Driver = /usr/lib/libodbcpsql.so
    setup = /usr/lib/libodbcpsqlS.so
    FileUsage = 1

  5. isql -v asterisk-connector
    note:
    isql application use perform connectivity test with database.

    The "asterisk-connector" has to specify in /etc/odbc.ini.
    [asterisk-connector]
    driver = MySQL
    Database = asterisk
    Server = localhost
    Socket = /var/lib/mysql/mysql.sock
    User = root
    Password = password

  6. CLI> odbc show
    sample out put:
    Name: asterisk
    DSN: asterisk-connector
  7. Pooled: no
    Connected: yes

  8. CLI> module reload

  9. CLI> cdr status
    sample out put:
    CDR logging: enabled
    CDR mode: simple
    CDR registered backend: cdr-custom
    CDR registered backend: cdr_manager
    CDR registered backend: ODBC

  10. CLI> console dial 100@default
    note:
    You have to have chan_oss. The above console dial command can make a call.