I have postgresql installed in the same box of asterisk and I am trying to configure that call detail can be saved in the database. But the call details are not saved in the database. Here is the configuration:
1): from unixODBC, by using using select, it shows that unixODBC can access the database:
$ echo “select 1” | isql - asterisk-connector
2): after configure res_odbc.conf and make menuselect, etc, asterisk can see the odbc
*CLI> odbc show correct and Connected: Yes
3): I create a table in the database: call_detail and configured cdr_odbc, dsn=asterisk-connector, etc (basic info is the same as res_odbc). AND the table name is “call_detail” which is the same as the table name created.
4): *CLI>cdr status shows:
CDR logging: enabled
CDR registered backend: ODBC.
5): Test: a java code originates a call by connecting to manager, to a xten-xlite ip phone, the call is answered. Then no record is inserted into the table. At the same time, the call-detail information IS in csv file.
what is wrong?
Thanks a looooooot!