1.8 cdr to postgres

Hi folks…I’m an asterisk newbie :frowning:
I have asterisk up and running and I can make calls from phone to phone - no worries there.
I can get asterisk to write cdr to the master log no problem - however I need it to write the cdr to postgres (on a separate machine) I have followed the instructions in Asterisk “The definitive guide”, postrges config ends on pg 352. And cdr is not writing to postgres :cry: -
this are the message from cli:

== Parsing ‘/etc/asterisk/asterisk.conf’: == Found
== Parsing ‘/etc/asterisk/extconfig.conf’: == Found
== Binding extensions to pgsql/asterisk/extensions_conf
== Binding sipuser to pgsql/asterisk/sip_conf
== Binding sippeers to pgsql/asterisk/sip_conf
== Binding sipregs to pgsql/asterisk/sip_conf
== Binding voicemail to pgsql/asterisk/voicemail_users
== Binding queues to pgsql/asterisk/queue_table
== Binding queue_members to pgsql/asterisk/queue_member_table
== Binding cdr to pgsql/asterisk/cdr_table

and ----------------------
DEV_ASTRSK1*CLI> odbc show

ODBC DSN Settings

Name: asterisk
DSN: asterisk-connector
Last connection attempt: 1970-01-01 02:00:00
Pooled: No
Connected: Yes

CLI> module show like odbc
Module Description Use Count
res_odbc.so ODBC resource 0
cel_odbc.so ODBC CEL backend 0
cdr_odbc.so ODBC CDR Backend 0
cdr_adaptive_odbc.so Adaptive ODBC CDR backend 0
func_odbc.so ODBC lookups 0
res_config_odbc.so Realtime ODBC configuration 0
6 modules loaded



unanswered = no




;usegmtime=yes ; log date/time in GMT. Default is “no”
;loguniqueid=yes ; log uniqueid. Default is “no”
;loguserfield=yes ; log user field. Default is “no”
;accountlogs=yes ; create separate log file for each account code. Default is “yes”

usegmtime=yes ; log date/time in GMT
loguniqueid=yes ; log uniqueid
loguserfield=yes ; log user field
odbc => /etc/asterisk/cdr_odbc.conf

enabled => yes
dsn => asterisk-connector
username => asterisk
password => Aneasy1
pre-connect => yes


enabled = no

rate => Rate
carrier => Carrier

please…Help me obiwan your my last chance

Just in case you are wondering - the passwords are not real

wooo hooo - solved it
first install postgresql-devel
then ./configure --wtih-postgres=/path to pg_config

then make menuconfig - select cdr_pgsql

then follow config file samples

dude out