Hello,
I am new to using the cdr-pusher and maybe this is just a configuration error on my part, however it looks like all is setup correctly. I have cdr-pusher setup on a freepbx system and it is to push to a cdr-stats server, and have configured supervisor as per the installation notes, however when I start the service I receive no cdrs on the stats server. For troubleshooting purposes I have tried to call the program directly and am seeing mysql query errors when calling it:
`[root@pbx conf.d]# /root/.gvm/pkgsets/go1.5.1/global/src/opt/app/cdr-pusher/bin/cdr-pusher
INFO[0000] StartTime: Mon Jul 24 2017 21:03:05
INFO[0000] RunFetcher waiting on chanSync before fetching
ERRO[0000] Failed to run query:Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(start_stamp), datetime(answer_stamp), datetime(end_stamp) FROM cdr WHERE flag_i' at line 1
ERRO[0000] Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(start_stamp), datetime(answer_stamp), datetime(end_stamp) FROM cdr WHERE flag_i' at line 1
INFO[0000] RunFetcher sleeps for 1 seconds!
INFO[0001] RunFetcher waiting on chanSync before fetching `
I have also altered the cdr table under asteriskcdrdb as noted in the instructions with
ALTER TABLE cdr ADD COLUMN id int(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT FIRST;
Any Idea on what could be wrong or is there any other info I may need to share?
Hello,
I am new to using the cdr-pusher and maybe this is just a configuration error on my part, however it looks like all is setup correctly. I have cdr-pusher setup on a freepbx system and it is to push to a cdr-stats server, and have configured supervisor as per the installation notes, however when I start the service I receive no cdrs on the stats server. For troubleshooting purposes I have tried to call the program directly and am seeing mysql query errors when calling it:
`[root@pbx conf.d]# /root/.gvm/pkgsets/go1.5.1/global/src/opt/app/cdr-pusher/bin/cdr-pusher
INFO[0000] StartTime: Mon Jul 24 2017 21:03:05
INFO[0000] RunFetcher waiting on chanSync before fetching
ERRO[0000] Failed to run query:Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(start_stamp), datetime(answer_stamp), datetime(end_stamp) FROM cdr WHERE flag_i' at line 1
ERRO[0000] Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(start_stamp), datetime(answer_stamp), datetime(end_stamp) FROM cdr WHERE flag_i' at line 1
INFO[0000] RunFetcher sleeps for 1 seconds!
INFO[0001] RunFetcher waiting on chanSync before fetching `
I have also altered the cdr table under asteriskcdrdb as noted in the instructions with
ALTER TABLE cdr ADD COLUMN id int(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT FIRST;Any Idea on what could be wrong or is there any other info I may need to share?