Master.csv is not generated


(Evgenii Beletskii) #1

Dear all,
I was about to enable simple call logging with using cdr_csv.so Asterisk module and did the following:

  1. Created /etc/asterisk/cdr.conf since it was missing and added the following:
[csv]
usegmtime=yes
loguniqueid=yes
loguserfield=yes
  1. Created /etc/asterisk/cdr_manager.conf (it was missing too) with the following text:
[general]
enabled = yes
  1. enabled CDR modules in module.conf:
load = cdr_manager.so
load = cdr_odbc.so
load = cdr_adaptive_odbc.so
load = cdr_csv.so
  1. restarted my server

However, no Master.csv file is generated to /var/log/asterisk/cdr-csv when I place a call…

cat /var/log/asterisk/full | grep cdr
[2017-05-09 07:21:34] WARNING[1954] func_cdr.c: CDR requires a value (CDR(variable)=value)
[2017-05-09 08:53:48] WARNING[1954] func_cdr.c: CDR requires a value (CDR(variable)=value)
[2017-05-09 08:54:56] WARNING[1954] func_cdr.c: CDR requires a value (CDR(variable)=value)
[2017-05-09 08:55:53] WARNING[1954] func_cdr.c: CDR requires a value (CDR(variable)=value)
)[2017-05-09 08:56:16] WARNING[1954] func_cdr.c: CDR requires a value (CDR(variable)=value)
[2017-05-09 09:11:57] NOTICE[1047] res_odbc.c: Registered ODBC class ‘asteriskcdrdb’ dsn->[MySQL-asteriskcdrdb]
[2017-05-09 09:11:57] WARNING[1047] cdr_adaptive_odbc.c: No such connection ‘asteriskcdrdb’ in the ‘asteriskcdrdb’ section of cdr_adaptive_odbc.conf. Check res_odbc.conf.
[2017-05-09 09:12:17] NOTICE[1047] cdr.c: CDR simple logging enabled.
[2017-05-09 09:13:28] WARNING[1047] cdr_manager.c: Failed to load configuration file. Module not activated.
[2017-05-09 09:13:28] WARNING[1047] cdr_pgsql.c: Unable to load config for PostgreSQL CDR’s: cdr_pgsql.conf
[2017-05-09 09:13:28] WARNING[1047] cdr_sqlite3_custom.c: Failed to load configuration file. Module not activated.
[2017-05-09 09:13:28] WARNING[1047] cdr_odbc.c: cdr_odbc: Unable to load config for ODBC CDR’s: cdr_odbc.conf
[2017-05-09 09:13:28] ERROR[1047] cdr_syslog.c: Unable to load cdr_syslog.conf. Not logging custom CSV CDRs to syslog.
[2017-05-09 09:13:29] WARNING[1047] cel_odbc.c: No such connection ‘asteriskcdrdb’ in the ‘cel’ section of cel_odbc.conf. Check res_odbc.conf.
[2017-05-09 09:13:29] NOTICE[1047] cdr_tds.c: Unable to load TDS config for CDRs: cdr_tds.conf
[2017-05-09 09:51:46] NOTICE[6453] res_odbc.c: Registered ODBC class ‘asteriskcdrdb’ dsn->[MySQL-asteriskcdrdb]
[2017-05-09 09:55:41] ERROR[6913] config_options.c: In cdr.conf: Processing options for general failed
[2017-05-09 09:55:42] NOTICE[6913] res_odbc.c: Registered ODBC class ‘asteriskcdrdb’ dsn->[MySQL-asteriskcdrdb]
[2017-05-09 09:55:47] NOTICE[6913] res_odbc.c: Registered ODBC class ‘asteriskcdrdb’ dsn->[MySQL-asteriskcdrdb]
[2017-05-09 09:57:16] WARNING[6913] loader.c: Unload failed, ‘cdr_csv.so’ is not loaded.
[2017-05-09 10:03:50] NOTICE[1045] res_odbc.c: Registered ODBC class ‘asteriskcdrdb’ dsn->[MySQL-asteriskcdrdb]
[2017-05-09 10:03:50] WARNING[1045] cdr_adaptive_odbc.c: No such connection ‘asteriskcdrdb’ in the ‘asteriskcdrdb’ section of cdr_adaptive_odbc.conf. Check res_odbc.conf.
[2017-05-09 10:04:08] ERROR[1045] config_options.c: In cdr.conf: Processing options for general failed
[2017-05-09 10:04:08] NOTICE[1045] cdr.c: Failed to process CDR configuration; using defaults
[2017-05-09 10:04:08] NOTICE[1045] cdr.c: CDR simple logging enabled.
[2017-05-09 10:05:11] WARNING[1045] cdr_manager.c: Failed to load configuration file. Module not activated.
[2017-05-09 10:05:11] WARNING[1045] cdr_pgsql.c: Unable to load config for PostgreSQL CDR’s: cdr_pgsql.conf
[2017-05-09 10:05:11] WARNING[1045] cdr_sqlite3_custom.c: Failed to load configuration file. Module not activated.
[2017-05-09 10:05:11] WARNING[1045] cdr_odbc.c: cdr_odbc: Unable to load config for ODBC CDR’s: cdr_odbc.conf
[2017-05-09 10:05:11] ERROR[1045] cdr_syslog.c: Unable to load cdr_syslog.conf. Not logging custom CSV CDRs to syslog.
[2017-05-09 10:05:11] WARNING[1045] cel_odbc.c: No such connection ‘asteriskcdrdb’ in the ‘cel’ section of cel_odbc.conf. Check res_odbc.conf.
[2017-05-09 10:05:11] NOTICE[1045] cdr_tds.c: Unable to load TDS config for CDRs: cdr_tds.conf
[2017-05-09 12:12:18] NOTICE[1035] res_odbc.c: Registered ODBC class ‘asteriskcdrdb’ dsn->[MySQL-asteriskcdrdb]
[2017-05-09 12:12:18] WARNING[1035] cdr_adaptive_odbc.c: No such connection ‘asteriskcdrdb’ in the ‘asteriskcdrdb’ section of cdr_adaptive_odbc.conf. Check res_odbc.conf.
[2017-05-09 12:12:31] ERROR[1035] config_options.c: In cdr.conf: Processing options for general failed
[2017-05-09 12:12:31] NOTICE[1035] cdr.c: Failed to process CDR configuration; using defaults
[2017-05-09 12:12:31] NOTICE[1035] cdr.c: CDR simple logging enabled.
[2017-05-09 12:13:30] WARNING[1035] cdr_manager.c: Failed to load configuration file. Module not activated.
[2017-05-09 12:13:30] WARNING[1035] cdr_pgsql.c: Unable to load config for PostgreSQL CDR’s: cdr_pgsql.conf
[2017-05-09 12:13:30] WARNING[1035] cdr_sqlite3_custom.c: Failed to load configuration file. Module not activated.
[2017-05-09 12:13:30] WARNING[1035] cdr_odbc.c: cdr_odbc: Unable to load config for ODBC CDR’s: cdr_odbc.conf
[2017-05-09 12:13:30] ERROR[1035] cdr_syslog.c: Unable to load cdr_syslog.conf. Not logging custom CSV CDRs to syslog.
[2017-05-09 12:13:30] WARNING[1035] cel_odbc.c: No such connection ‘asteriskcdrdb’ in the ‘cel’ section of cel_odbc.conf. Check res_odbc.conf.
[2017-05-09 12:13:30] NOTICE[1035] cdr_tds.c: Unable to load TDS config for CDRs: cdr_tds.conf
[2017-05-09 12:25:31] WARNING[1956] func_cdr.c: CDR requires a value (CDR(variable)=value)
[2017-05-09 12:56:05] WARNING[1956] func_cdr.c: CDR requires a value (CDR(variable)=value)
[2017-05-09 12:57:12] WARNING[1956] func_cdr.c: CDR requires a value (CDR(variable)=value)
[2017-05-09 13:14:43] WARNING[1956] func_cdr.c: CDR requires a value (CDR(variable)=value)
[2017-05-09 13:19:29] ERROR[7260] config_options.c: In cdr.conf: Processing options for general failed
[2017-05-09 13:19:31] NOTICE[7260] res_odbc.c: Registered ODBC class ‘asteriskcdrdb’ dsn->[MySQL-asteriskcdrdb]
[2017-05-09 13:19:32] WARNING[7260] cdr_csv.c: No [csv] section in cdr.conf. Unregistering backend.
[2017-05-09 13:19:51] WARNING[1956] func_cdr.c: CDR requires a value (CDR(variable)=value)
[2017-05-09 13:24:43] NOTICE[7628] cdr.c: CDR simple logging enabled.
[2017-05-09 13:24:44] NOTICE[7628] res_odbc.c: Registered ODBC class ‘asteriskcdrdb’ dsn->[MySQL-asteriskcdrdb]
[2017-05-09 13:33:56] NOTICE[8477] res_odbc.c: Registered ODBC class ‘asteriskcdrdb’ dsn->[MySQL-asteriskcdrdb]
[2017-05-09 13:37:16] NOTICE[8477] cdr.c: CDR simple logging enabled.
[2017-05-09 13:37:17] NOTICE[8477] res_odbc.c: Registered ODBC class ‘asteriskcdrdb’ dsn->[MySQL-asteriskcdrdb]
[2017-05-09 13:37:41] NOTICE[8477] res_odbc.c: Registered ODBC class ‘asteriskcdrdb’ dsn->[MySQL-asteriskcdrdb]
[2017-05-09 13:38:11] WARNING[1956] func_cdr.c: CDR requires a value (CDR(variable)=value)
[2017-05-09 13:39:27] WARNING[8477] loader.c: Module ‘cdr_csv.so’ already exists.
[2017-05-09 13:45:00] WARNING[1956] func_cdr.c: CDR requires a value (CDR(variable)=value)
[2017-05-09 14:11:47] ERROR[12913] config_options.c: In cdr.conf: Processing options for general failed
[2017-05-09 14:12:02] NOTICE[12913] res_odbc.c: Registered ODBC class ‘asteriskcdrdb’ dsn->[MySQL-asteriskcdrdb]
[2017-05-09 14:17:08] NOTICE[13193] cdr.c: CDR simple logging enabled.
[2017-05-09 14:17:09] NOTICE[13193] res_odbc.c: Registered ODBC class ‘asteriskcdrdb’ dsn->[MySQL-asteriskcdrdb]

root@raspbx:~# cat /var/log/asterisk/full | grep -i error | grep -i cdr

[2017-05-09 09:13:28] ERROR[1047] cdr_syslog.c: Unable to load cdr_syslog.conf. Not logging custom CSV CDRs to syslog.
[2017-05-09 09:55:41] ERROR[6913] config_options.c: In cdr.conf: Processing options for general failed
[2017-05-09 10:04:08] ERROR[1045] config_options.c: In cdr.conf: Processing options for general failed
[2017-05-09 10:05:11] ERROR[1045] cdr_syslog.c: Unable to load cdr_syslog.conf. Not logging custom CSV CDRs to syslog.
[2017-05-09 12:12:31] ERROR[1035] config_options.c: In cdr.conf: Processing options for general failed
[2017-05-09 12:13:30] ERROR[1035] cdr_syslog.c: Unable to load cdr_syslog.conf. Not logging custom CSV CDRs to syslog.
[2017-05-09 13:19:29] ERROR[7260] config_options.c: In cdr.conf: Processing options for general failed
[2017-05-09 14:11:47] ERROR[12913] config_options.c: In cdr.conf: Processing options for general failed

Please advise.


(Jonathan) #2

Evgenii Beletskii did you ever resolve this?