The reason I jump on mySQL 8 is because someone said it worked. I'll try an older version.

https://forum.mango-os.com/topic/4686/mysql-version/6?_=1614639710932

I thought this should be a straightforward process. I installed Mango 3.77 on a headless ubuntu server 20.04 and mysql 8+. Moved the mango files and config to new env and worked fine under H2. Then configured env.properties to include mySQL and convert.

I get this error. Duplicate column? Any ideas?

INFO 2021-03-01T09:21:02,784 (com.serotonin.m2m2.Lifecycle.loadLic:670) - License file not found
INFO 2021-03-01T09:21:02,870 (com.serotonin.m2m2.db.BasePooledProxy.initializeImpl:36) - Initializing pooled connection
manager
WARN 2021-03-01T09:21:05,381 (com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade:98) - Upgrading 'core' from 1 to 2
INFO 2021-03-01T09:21:05,383 (com.serotonin.m2m2.db.upgrade.DBUpgrade.createUpdateLogOutputStream:169) - Writing upgrad
e log to /opt/mango/logs/com.serotonin.m2m2.db.upgrade.Upgrade1.log
FATAL 2021-03-01T09:21:05,578 (com.serotonin.m2m2.db.AbstractDatabaseProxy.initialize:185) - Exception initializing data
base proxy: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table publishers
add column rtdata longblob; ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate
column name 'rtdata'
com.serotonin.ShouldNeverHappenException: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL gr
ammar [alter table publishers add column rtdata longblob; ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSy
ntaxErrorException: Duplicate column name 'rtdata'
at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:104) ~[mango-3.7.7.jar:?]
at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:36) ~[mango-3.7.7.jar:?]
at com.serotonin.m2m2.db.AbstractDatabaseProxy.initialize(AbstractDatabaseProxy.java:171) ~[mango-3.7.7.jar:?]
at com.serotonin.m2m2.Lifecycle.databaseInitialize(Lifecycle.java:732) ~[ma-priv-3.7.7.jar:?]
at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:285) ~[ma-priv-3.7.7.jar:?]
at com.serotonin.m2m2.Main.main(Main.java:159) ~[ma-priv-3.7.7.jar:?]
Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table publishers a
dd column rtdata longblob; ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate c
olumn name 'rtdata'
at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.ja
va:93) ~[spring-jdbc-5.1.7.RELEASE.jar:5.1.7.RELEASE]

Hello,
I can test publish/subscribe via python but can't make the subscribe work on Mango. Attached is the data source config. What am I missing?

))

ERROR 2021-02-01T21:09:38,258 (com.infiniteautomation.m2m2.mqtt.client.MqttClientDataSourceRT.connect:712) - ERROR initializing MQTT Client
com.serotonin.ShouldNeverHappenException: @ "DISCONNECTING" don't know how to handle event: "CONNECT_ASYNC"
        at com.infiniteautomation.m2m2.mqtt.client.MqttClientDataSourceRT.handleBokerConnectionevent(MqttClientDataSourceRT.java:264) ~[?:?]
        at com.infiniteautomation.m2m2.mqtt.client.MqttClientDataSourceRT.connect(MqttClientDataSourceRT.java:710) ~[?:?]
        at com.infiniteautomation.m2m2.mqtt.client.MqttClientDataSourceRT.access$1200(MqttClientDataSourceRT.java:44) ~[?:?]
        at com.infiniteautomation.m2m2.mqtt.client.MqttClientDataSourceRT$4.run(MqttClientDataSourceRT.java:756) ~[?:?]
        at java.util.TimerThread.mainLoop(Timer.java:556) ~[?:?]
        at java.util.TimerThread.run(Timer.java:506) ~[?:?]
Exception in thread "Timer-2" com.serotonin.ShouldNeverHappenException: @ "DISCONNECTING" don't know how to handle event: "INITIALIZATION_FAILED"
        at com.infiniteautomation.m2m2.mqtt.client.MqttClientDataSourceRT.handleBokerConnectionevent(MqttClientDataSourceRT.java:264)
        at com.infiniteautomation.m2m2.mqtt.client.MqttClientDataSourceRT.connect(MqttClientDataSourceRT.java:715)
        at com.infiniteautomation.m2m2.mqtt.client.MqttClientDataSourceRT.access$1200(MqttClientDataSourceRT.java:44)
        at com.infiniteautomation.m2m2.mqtt.client.MqttClientDataSourceRT$4.run(MqttClientDataSourceRT.java:756)
        at java.base/java.util.TimerThread.mainLoop(Timer.java:556)
        at java.base/java.util.TimerThread.run(Timer.java:506)
ERROR 2021-02-01T21:09:39,080 (com.infiniteautomation.m2m2.mqtt.client.MqttClientDataSourceRT$2.onFailure:703) - MQTT Connection not established
ERROR 2021-02-01T21:10:30,899 (com.infiniteautomation.m2m2.mqtt.client.MqttClientDataSourceRT$2.onFailure:703) - MQTT Connection not established

@robmalone Mango did not even what to start up with JDK 1.14. I did recover the old jdk I was using on the crashed system and will revert to that.

thx

I'm getting this as well.

I restored from a windows crash and using the recommended AdoptOpenJDK JDK. I was using the old JDK from Oracle prior. I now get this error and I know the port works fine as I can communicate using a modbus master tool.

I am using the rest API in my user module, components, etc. and works fine. However, I recently read on a post an example using a call on the pointvalues object. e.g.

PointValues.getPointValuesForXid(...)

I tried it and works fine and was wondering this officially documented?

pjc

Thanks. It will probably end up a user component.

pjc

I would like to retrieve the historical values stored via cron/meta-data point that are run once an hr and per month for a chart. When I perform a mysql query, I get what I expect. e.g. if there are 5 entries I get 5 entries.
MySql query returns what I expect.
e.g.

select pointValue, from_unixtime(ts/1000) from pointvalues where datapointid=474

via ma-point-values I get the 5 + a current value which is the same as the last log value. I am using these to seed a chart and always get an extra point that mirrors that of what was saved via cron.

<ma-point-values point="point1" values="point1Values" from="dateBar.from" to="dateBar.to" rollup="{{dateBar.rollupType}}" rollup-interval="{{dateBar.rollupIntervals}} {{dateBar.rollupIntervalPeriod}}">
</ma-point-values>

<p>There are {{point1Values.length}} rows to display.</p>


<md-table-container>
    <table md-table>
        <thead md-head>
        <tr>
            <th md-column>TimeStamp</th>
            <th md-column>Point Value</th>
        </tr>
        </thead>
        <tbody md-body>
        <tr ng-repeat="value in point1Values">
            <td md-cell>{{value.timestamp | maMoment:'format':'ll LTS'}}</td>
            <td md-cell>{{value.value}}</td>
        </tr>
        </tbody>
    </table>
</md-table-container>

This is an output on the per month points. I don't want the Dec 3 to return. mySql only has the 1 entry.

Thanks. It worked.

How does the parent item drop down list get populated in the create menu item from the dashboard designer? via the register a menu item in a user module? I am trying to create a menu bar at the top using the suggestions in forum and nothing but the canned entries appear.

I;m obviously missing something.

pjc