Adam Hi; I am still trying to use the Ethernet/IP data source. I can get mango to see the processor but Tells me "unable to start the session" . Thanks for your reply and I'll use the modbus like you said if I can't get this to work.
Thanks again.
Larry

Has anyone tried to connect to the AutomationDirect PLC P3-550 or P3-550E with the Allen Bradly Data Source? The PLC is tag name like the Allen Bradly’s. They use EtherNet/IP communication and much less cost.

Thanks so much Phil I'll give it a try.

Phil, Could you give an example?

Thanks

Thanks Joel

Excel Reports – Is there a way to run the reports on a trigger rather than time/date?

Phil, Thanks for the info. We found it with your help.

Larry

In The reports (not Excel) I have a report that works fine and is formatted the way we want when I click the charts button, but when the email comes the format is very different. I would like to know how to find the email format for the report.

All, Thanks for the help. After starting ma-bat in terminal we saw that the upgrade was not complete. We backed out and did the upgrade manually and all is well now. Thanks again for the help.
Larry

We upgraded yesterday to the newest core and mango would not restart. We restarted the server it's on and still won't start. Please find attache0_1477064443276_ma.log d the log file.

Thanks Larry

Phil, When we changed back to the h2 db mango came up fine, so it's something with the mysql and the server. will let you know more when we fine it.

Thanks

Phil, No I never came to mind, I'll have my IT admin check that.

Phil, That last entry time is about when Jon (our IT admin) tried to restart it for me.

Phil, I here is the file again when I select it to upload it puts the (.1) after the file??? 0_1475160117108_ma.log.1

Hi Joel, I can connect to the mysql db with the workbench from my laptop? Here is the ma.log file0_1475157802803_ma.log.1

Phil, here is what Jon, our IT Person sent me from the restart.

[Email Header]
Subject: RE: Hi Jon

Doesn’t seem to want to restart.

I shut it down, started it back up, web site is blank and here’s what the command window looks like

Jon

Phil, You were right, mango would not restart. When our IT person he got this "Java.sql.SQLException: Data source is closed at org.apache.commons.dbcp. BasicDataSource. createDataSource 1362". How should we go about recovery?

Phil, Thanks I'll restart mango tonight and check in the morning.

Phil, here is the log. I'll check the db login but Everything else is working fine. I was working on the report format in excel and had ran it maybe 6 times before lunch. ????

0_1475089401019_ma.log.1

I was working on a report and had stopped for lunch when i went to run it again I got this error "Mango XHR request failed, status=error, error=Server Error, message=org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Access denied for user 'Larry'@'localhost' (using password: YES), url=/rest/v1/excel-reports/run/XLT_760834"

I was working on the formatting of the main sheet, not the raw data sheet. Not sure what is happening?