• M
    mlohbihler

    Can you try putting in a pause after initializing the local device, using "Thread.sleep(###)"? There may be a delay while the device waits to join the network, during which your requests might be timing out. Start with something like 10 seconds to see if this works, and then reduce the time as much as you can.

    posted in BACnet4J general discussion read more
  • M
    mlohbihler

    Version 1.13.2 of Mango has not yet been released, but some users have already expressed concern with regard to how long the database update may take. The update this time is particularly onerous, making some significant changes to the pointValues and pointValueAnnotations tables. If your instance uses MySQL and contains upwards of millions of records (a configuration that was specifically tested), you might expect a conversion time of hours.

    If this downtime is unacceptable, below is an alternative conversion method. This procedure is intended for MySQL, but can be adapted for other databases. Note that it includes two restarts of Mango. During the uptime between restarts, the accumulated history will not be available.

    1. Shut down Mango, and apply the 1.13.2 upgrade.

    2. Access your MySQL database using the mysql console, or a tool like the MySQL Workbench, and execute the following statements.

    rename table pointValues to pointValuesSave;
    rename table pointValueAnnotations to pointValueAnnotationsSave;
    
    create table pointValues (
      id bigint not null auto_increment,
      dataPointId int not null,
      dataType int not null,
      pointValue double,
      ts bigint not null,
      primary key (id)
    ) engine=MyISAM;
    create index pointValuesTempIdx1 on pointValues (dataPointId, ts);
    
    create table pointValueAnnotations (
      pointValueId bigint not null,
      textPointValueShort varchar(128),
      textPointValueLong longtext,
      sourceType smallint,
      sourceId int,
      primary key (pointValueId)
    ) engine=MyISAM;
    
    update systemSettings set settingValue='1.13.1' where settingName='databaseSchemaVersion';
    
    

    This will copy your pointValues tables to new names, and create proxies in their place. These statements should execute quickly.

    1. Restart Mango. All history will appear to be gone, but new samples will be stored.

    2. Run the following statements:

    alter table pointValueAnnotationsSave drop foreign key pointValueAnnotationsFk1;
    alter table pointValueAnnotationsSave ENGINE = MyISAM;
    alter table pointValueAnnotationsSave add primary key (pointValueId);
    alter table pointValuesSave drop foreign key pointValuesFk1;
    
    drop index pointValuesIdx1 on pointValuesSave;
    drop index pointValuesIdx2 on pointValuesSave;
    alter table pointValuesSave ENGINE = MyISAM;
    create index pointValuesIdx1 on pointValuesSave (dataPointId, ts);
    
    

    These statements will convert the pointValues tables to MyISAM, remove FKs, and keep only necessary indices. They may take a very long time to run.

    1. Shut down Mango, and execute the following statements:
    insert into pointValuesSave (id,dataPointId,dataType,pointValue,ts) select id,dataPointId,dataType,pointValue,ts from pointValues;
    insert into pointValueAnnotationsSave (pointValueId,textPointValueShort,textPointValueLong,sourceType,sourceId) select pointValueId,textPointValueShort,textPointValueLong,sourceType,sourceId from pointValueAnnotations;
    drop table pointValues;
    drop table pointValueAnnotations;
    
    rename table pointValuesSave to pointValues;
    rename table pointValueAnnotationsSave to pointValueAnnotations;
    
    

    These statements will copy all of the newly collected data into the old tables, and then rename the tables back to their original names. These should run quickly, depending on how much new data has been collected into the proxy tables.

    1. Restart Mango. The database upgrade is now complete. All history should again be available.

    Note that application features that depend upon history data should be disabled, such as the PTCP publisher data sync.

    posted in User help read more
  • M
    mlohbihler

    We can only take it as an annoying type of flattery, but the amount of spam that this forum is getting has passed our tolerance. We don't want to go as far as moderating messages, so for now we've only made recaptcha a registration requirement. This is of course no guarantee that the spam will stop, so we'll cross our fingers and apologize in advance for the nuisance, should it continue.

    posted in Announcements read more
  • M
    mlohbihler

    The official production release of Mango M2M2 is now available. Download version 1.0.1 of the core now. Make sure you get the associated module versions as well. Look for module versions marked as "1.x - #.#.#".

    posted in Announcements read more
  • M
    mlohbihler

    All forum users,

    We have been having some trouble with one of our servers, in particular the one that hosts this forum. There may be downtime in addition to what we've already experienced over the next little while until we get problems worked out. Updates will be posted here.

    posted in Announcements read more
  • M
    mlohbihler

    Test drive the new M2M2 software by visiting http://m2m2.serotoninsoftware.com. Now in beta.

    posted in Announcements read more
  • M
    mlohbihler

    Mango Scripting is a scripting environment for automation software. Please see http://automation.serotoninsoftware.com/ for more information.

    posted in Scripting general Discussion read more
  • M
    mlohbihler

    This is an open request for opinions on how a "serial data" data source might work. Many different approaches to how such a think could work can be conceived, so we are looking for specific examples of how you would want to derive data from a stream. In your description you should include examples of data (not too long please), and a description of how it is received and formatted.

    posted in Wishlist read more
  • M
    mlohbihler

    To all real life Mango users. Our apologies for the spam that is occasionally sent via these forums. We are currently considering replacing this forum software in our long overdue but hopefully soon full site redesign. In the meantime we are mopping up spam messages as quickly as we can. Please bear with us.

    posted in Announcements read more
  • M
    mlohbihler

    A new version of Mango has been released: 1.10.0. Great new functionality is available. See the release notes page for more information.

    Special note: for all users who have been patiently waiting, an OPC DA data source will be available in the next release.

    posted in Announcements read more