PostgreSQL

If you want to go directly to postgresql database, and have the cdr_pgsql.so compiled you can use the following sample setup. On Debian, before compiling asterisk, just install libpqxx-dev. Other distros will likely have a similiar package.

Once you have the compile done, copy the sample cdr_pgsql.conf file or create your own.

Here is a sample:

•         /etc/asterisk/cdr_pgsql.conf
            ; Sample Asterisk config file for CDR logging to PostgresSQL
            [global]
            hostname=localhost
            port=5432
            dbname=asterisk
            password=password
            user=postgres
            table=cdr
  

Now create a table in postgresql for your cdrs

•         CREATE TABLE cdr (
                  calldate      time               NOT NULL ,
                  clid          varchar (80)          NOT NULL ,
                  src           varchar (80)          NOT NULL ,
                  dst           varchar (80)          NOT NULL ,
                  dcontext      varchar (80)          NOT NULL ,
                  channel       varchar (80)          NOT NULL ,
                  dstchannel    varchar (80)          NOT NULL ,
                  lastapp       varchar (80)          NOT NULL ,
                  lastdata      varchar (80)          NOT NULL ,
                  duration      int                   NOT NULL ,
                  billsec       int                   NOT NULL ,
                  disposition   varchar (45)          NOT NULL ,
                  amaflags      int                   NOT NULL ,
                  accountcode   varchar (20)          NOT NULL ,
                  uniqueid      varchar (150)         NOT NULL ,
                  userfield     varchar (255)         NOT NULL
          );