• G
    gquiroz

    Is it possible to modify the times that trend samples are taken so that the 15-minute samples are taken at the top of each hour, at 15 minutes after each hour, at 30 minutes after each hour and at 45 minutes after each hour (i.e. 9:00am, 9:15am, 9:30am, 9:45am, 10:00am, etc)?

    posted in User help read more
  • G
    gquiroz

    Hey Joel! Yup, that was it. I was trying to read the wrong register. Thank you!

    posted in User help read more
  • G
    gquiroz

    Hello,

    I am using Mango v 2.8.8
    I am trying to use the Modbus IP Module on Mango. With another a modbus scanning tool, I can confirm I have the correct IP, Port #, Slave ID and Register #.
    0_1549290521646_Screen Shot 2019-02-04 at 6.39.06 AM.png
    However on Mango, when I try to scan for nodes I am getting no results, it seems to be stuck scanning. I also get the error Illegal data address when trying to read the modbus directly.
    0_1549290615495_Screen Shot 2019-02-04 at 6.41.27 AM.png
    0_1549290651380_Screen Shot 2019-02-04 at 9.30.33 AM.png

    posted in User help read more
  • G
    gquiroz

    Hi phildunlap, apparently MYSQL v8 came with a security update that prevents many third party applications from accessing the server.
    Authentication plugin 'caching_sha2_password' cannot be loaded
    I could not find a fix for this, other than just downgrading to an older version.
    I will create a new post regarding the BACnet question: https://forum.infiniteautomation.com/topic/4042/adding-a-bacnet-router-as-a-foreign-device

    posted in User help read more
  • G
    gquiroz

    Hey there,
    we are using Mango 2.8.8 to read a BACnet device. We noticed we are having issues reading the devices from Mango when we do a BACnet who is look up. When we spoke to the manufacturer of the BACnet device they told us to add the BACnet device as a foreign device on Mango--Mango has to send the who is request directly to the router on a specific IP address. How can this be done on the system settings for a bacnet data source?
    0_1548956076686_Screen Shot 2019-01-31 at 12.34.06 PM.png

    posted in User help read more
  • G
    gquiroz

    I am a using windows 10 system

    I found what the issue was. MySQL v 8 was not working due to a security setting. i downgraded to MySQL v 5 and it worked.
    I am having trouble with the BACnet discovery. Not sure what is meant by Property: characterSetNotSupporte '29'
    com.serotonin.bacnet4j.type.constructed.BACnetError cannot be cast to com.serotonin.bac4j.type.constructed.ServicesSupported

    0_1548940638025_Screen Shot 2019-01-30 at 6.59.51 PM.png

    posted in User help read more
  • G
    gquiroz

    Hi phildunlap,

    my mah2.h2.db file size is 443,876 KB

    I've configured my env.properties file as shown in this thread: https://forum.infiniteautomation.com/topic/3559/convert-from-h2-to-mysql-database-guidelines/7

    I see I am getting a couple of errors/exceptions:

    • Unable to connect to database of type MYSQl
    • Could not get JDBC connection
    • Exception n thread "high-pool-1-thread-1"
      0_1548880695002_Screen Shot 2019-01-30 at 3.36.07 PM.png
      0_1548880686795_Screen Shot 2019-01-30 at 3.37.13 PM.png

    is there some sort of overide I should place or remove any existing data sources along with datapoints?

    posted in User help read more
  • G
    gquiroz

    I am using Mango v. 2.8.8
    It was running on an H2 database which appears to be out of memory
    0_1548872266396_Screen Shot 2019-01-30 at 10.37.20 AM.png
    Looking at other Forum Posts, I saw one proposed solution was to switch to a MySQl DB. I stopped the mango service, installed the MySQL server, went ahead and created a DB for Mango and updated my env.properties and commented out the H2 db settings. When I start the Mango service it seems to initialize the service, runs for 5 seconds, then stops. I noticed if I revert back to H2 it works again, however to prevent any more memory issues I've disabled my datasource.

    In summary:

    • What is meant by h2.jdbc Out of Memory? Are there any steps I can do to fix this first?
    • Is there anything else other than updating the env.properties in order to use MySQL?
    • Once running with MySQl how could I transfer my historical data from the H2 database to MySQL?

    posted in User help read more
  • G
    gquiroz

    @phildunlap Thanks for the help. Now the data points have started coming up itself.

    posted in Mango Automation read more
  • G
    gquiroz

    @phildunlap It has 441 data points. do you think that can be an issue?

    posted in Mango Automation read more