cdr-pusher setup issues

[scott Fertig]

Hello all!

First of all I apologize if this has been gone over, I have attempted to search around and have not found a solution. The issue I seem to be having is that when setting up cdr-pusher on a freepbx system it looks like the cdr-pusher queries are failing. I have currently setup cdr-stats on a debian server, and have the cdr-pusher setup on the freepbx server, I had to deviate from the instructions somewhat during the go setup as the instructions on the wiki did not seem to work at  all. Everything appears to be in place however I get no data when running the app using supervisor. I am able to start it from the cli and I can see mysql errors:

[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 20:53:16          

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 

I also did alter the cdr table as instructed in the documentation, this however did not seem to help:

ALTER TABLE cdr ADD COLUMN id int(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT FIRST;

Does anyone have any suggestions as to what could be the issue?

--Scott

[scott Fertig]

I figured this out, it looks like I used the wrong sql statements in the config file which I took from the install instructions. I only have one issue currently, when going to analytics then overview I get a 500 error, I'm still trying to debug this one.

--
You received this message because you are subscribed to a topic in the Google Groups "CDR-Stats" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/cdr-stats/8i5ATOXSUms/unsubscribe.
To unsubscribe from this group and all its topics, send an email to cdr-stats+unsubscribe@googlegroups.com.
To post to this group, send email to cdr-...@googlegroups.com.
Visit this group at https://groups.google.com/group/cdr-stats.
For more options, visit https://groups.google.com/d/optout.