asterisk + postgre
Добавлено: 23 апр 2014, 14:57
Собрал asterisk с модулем cdr_pgsql, прописал cdr_pgsql.conf, res_pgsql.conf, делаю звонок в никуда, в базе пусто.
Я что-то забыл?
Вот фрагмент лога, где asterisk поднимает cdr_pgsql(ругается на CEL, но он и не нужен)
== Parsing '/etc/asterisk/cdr_custom.conf': Found
cdr_custom.so => (Customizable Comma Separated Values CDR Backend)
== Parsing '/etc/asterisk/cel_sqlite3_custom.conf': Found
== Parsing '/etc/asterisk/cdr_syslog.conf': Found
== Parsing '/etc/asterisk/cdr_manager.conf': Found
cdr_manager.so => (Asterisk Manager Interface CDR Backend)
== Parsing '/etc/asterisk/cel_custom.conf': Found
cel_custom.so => (Customizable Comma Separated Values CEL Backend)
== Parsing '/etc/asterisk/cdr_pgsql.conf': Found
> Found column 'acctid' of type 'int8'
> Found column 'calldate' of type 'timestamptz'
> Found column 'clid' of type 'text'
> Found column 'src' of type 'text'
> Found column 'dst' of type 'text'
> Found column 'dcontext' of type 'text'
> Found column 'channel' of type 'text'
> Found column 'dstchannel' of type 'text'
> Found column 'lastapp' of type 'text'
> Found column 'lastdata' of type 'text'
> Found column 'duration' of type 'int8'
> Found column 'billsec' of type 'int8'
> Found column 'disposition' of type 'text'
> Found column 'amaflags' of type 'int8'
> Found column 'accountcode' of type 'text'
> Found column 'uniqueid' of type 'text'
> Found column 'userfield' of type 'text'
cdr_pgsql.so => (PostgreSQL CDR Backend)
== Parsing '/etc/asterisk/cdr.conf': Found
cdr_csv.so => (Comma Separated Values CDR Backend)
== Parsing '/etc/asterisk/cdr_sqlite3_custom.conf': Found
== Parsing '/etc/asterisk/cel.conf': Found
cel_manager.so => (Asterisk Manager Interface CEL Backend)
== Parsing '/etc/asterisk/cel_pgsql.conf': Found
[Apr 23 14:33:10] WARNING[6132]: cel_pgsql.c:402 process_my_load_module: CEL pgsql config file missing global secti on.
cel_pgsql.so => (PostgreSQL CEL Backend)
Я что-то забыл?
Вот фрагмент лога, где asterisk поднимает cdr_pgsql(ругается на CEL, но он и не нужен)
== Parsing '/etc/asterisk/cdr_custom.conf': Found
cdr_custom.so => (Customizable Comma Separated Values CDR Backend)
== Parsing '/etc/asterisk/cel_sqlite3_custom.conf': Found
== Parsing '/etc/asterisk/cdr_syslog.conf': Found
== Parsing '/etc/asterisk/cdr_manager.conf': Found
cdr_manager.so => (Asterisk Manager Interface CDR Backend)
== Parsing '/etc/asterisk/cel_custom.conf': Found
cel_custom.so => (Customizable Comma Separated Values CEL Backend)
== Parsing '/etc/asterisk/cdr_pgsql.conf': Found
> Found column 'acctid' of type 'int8'
> Found column 'calldate' of type 'timestamptz'
> Found column 'clid' of type 'text'
> Found column 'src' of type 'text'
> Found column 'dst' of type 'text'
> Found column 'dcontext' of type 'text'
> Found column 'channel' of type 'text'
> Found column 'dstchannel' of type 'text'
> Found column 'lastapp' of type 'text'
> Found column 'lastdata' of type 'text'
> Found column 'duration' of type 'int8'
> Found column 'billsec' of type 'int8'
> Found column 'disposition' of type 'text'
> Found column 'amaflags' of type 'int8'
> Found column 'accountcode' of type 'text'
> Found column 'uniqueid' of type 'text'
> Found column 'userfield' of type 'text'
cdr_pgsql.so => (PostgreSQL CDR Backend)
== Parsing '/etc/asterisk/cdr.conf': Found
cdr_csv.so => (Comma Separated Values CDR Backend)
== Parsing '/etc/asterisk/cdr_sqlite3_custom.conf': Found
== Parsing '/etc/asterisk/cel.conf': Found
cel_manager.so => (Asterisk Manager Interface CEL Backend)
== Parsing '/etc/asterisk/cel_pgsql.conf': Found
[Apr 23 14:33:10] WARNING[6132]: cel_pgsql.c:402 process_my_load_module: CEL pgsql config file missing global secti on.
cel_pgsql.so => (PostgreSQL CEL Backend)