• mircsicz

    That's why I'm proxying it, it's my lazy men's way to get it on HTTPS ;-)

    posted in Mango Automation Installation read more
  • mircsicz

    Seems it was an issue with my NginX Proxy. This is the setup that works now:

    server {
            listen          80;
            server_name  XXX.mydomain.de;
            return 301 https://$host$request_uri;
    }
    
    server {
            listen          443 ssl;
            server_name  XXX.mydomain.de;
            client_max_body_size 16M;
    
            ssl                     on;
            ssl_protocols           TLSv1.2;
            ssl_certificate         /etc/nginx/ssl/mydomain.de-bundle.crt;
            ssl_certificate_key     /etc/nginx/ssl/mydomain.de.key;
    
            proxy_cache off;
            proxy_store off;
    
            location / {
                    proxy_set_header Referer "";
                    proxy_pass http://10.xx.x.70:8080;
    #               proxy_redirect          off;
                    proxy_redirect          http://10.xx.x.70:8080 https://XXX.mydomain.de;
                    proxy_set_header        Host                    $host;
                    proxy_set_header        X-Real-IP               $remote_addr;
                    proxy_set_header        X-Forwarded-Host        $host;
                    proxy_set_header        X-Forwarded-Server      $host;
                    proxy_set_header        X-Forwarded-For         $proxy_add_x_forwarded_for;
            }
    }
    

    posted in Mango Automation Installation read more
  • mircsicz

    Hi hi,

    I've just installed the enterprise eval version 3.3.2. First thing I did was upgrading to 3.3.3, after the upgrade I see the following error in the console:

    ERROR 2018-03-08T13:31:10,706 (org.springframework.web.socket.server.support.AbstractHandshakeHandler.handleInvalidUpgradeHeader:285) - Handshake failed due to invalid Upgrade header: null
    

    What happend, do I need to take any actions beside a "ma.sh restart"?

    EDIT: A "ma.sh restart" doesn't solve the problem

    posted in Mango Automation Installation read more
  • mircsicz

    @Jared-Wiltshire I want to create dashboard's for several energy-site's. Each with an overview chart in 15Min Delta Rollup, a pie to show the diversification between the different meters and some stat's. But I can't find an example that describe's this with fixed data point's...

    I don't want a picker or a list for that. I want the dashboard available to the client. So they shouldn't have an option to change the data-source or data-point used on the dashboard.

    Can you please give me an specific example for this demand?

    And is the code off that "Energy Campus Example" available somewhere public? I read about it in two postings and saw the video but can't find anything specific...

    EDIT: played with the chart examples and found a way to fix it to delta and 15 Minutes:

    rollup="DELTA" rollup-interval="15 MINUTES"
    

    But I still need figure out how to pre define data-point's for a chart

    EDIT2: in the <ma-point-values> Doc point-xid is mentioned but looking in the legacy UI / data-point's I can't find that string. All I see is "Export Id (XID):", is that the same and just not consistently named?... And even if I found it how would I define that to let's say "point1"?

    EDIT3: <ma-get-point-value> is my solution:

    <div id="87c617bf-e3be-4e9c-9e66-b5ea619899e8" style="position: absolute; left: 1px; top: 2px; width: 769px; height: 34px; text-align: center;">WSE KA-DB</div>
    <ma-get-point-value point="point1" point-xid="GHV1 3P6 5OG EE kWh"></ma-get-point-value>
    <ma-get-point-value point="point2" point-xid="GHV1 3P7 4OG EE kWh"></ma-get-point-value>
    
    <ma-point-values point="point1" values="point1Values" from="dateBar.from" to="dateBar.to" rollup="DELTA" rollup-interval="15 MINUTES">
    </ma-point-values>
    <ma-point-values point="point2" values="point2Values" from="dateBar.from" to="dateBar.to" rollup="DELTA" rollup-interval="15 MINUTES">
    </ma-point-values>
    
    <ma-serial-chart style="height: 300px; width: 100%" series-1-values="point1Values" series-1-point="point1" series-2-values="point2Values" series-2-point="point2" series-2-axis="right" legend="true" balloon="true" options="{valueAxes:[{minimum:0, axisColor:point1Color, color:point1Color}, {axisColor:point2Color, color:point2Color}]}">
    </ma-serial-chart>
    

    Still looking for an example for the pie... ;-)

    posted in User help read more
  • mircsicz

    I Installed the update and can approve that changing the passwd now works for me ;-)

    posted in User help read more
  • mircsicz

    @jared-wiltshire said in Graph with 15Min consumption from electricity meter with absolute value:

    Use the date bar controls on the toolbar to select a 15 minute delta rollup.

    If you have various points you need displayed differently then you can set the type of rollup per point on the data point edit page (legacy UI data sources page) then select point default from the date bar.

    Hi Jared,

    sorry but I don't get it right... I've just started using Mango so I'm not yet that fluent in the GUI Acronyms...

    I got that the date bar is always on top and this is what I did set:
    15Min Delta Rollup

    But the Chart is not update'd and still show's the daily rollup:
    Daily Delta Rollup

    I also tried to find your setting on the legacy UI, but I didn't come closer then opening the data sources page...

    EDIT: just realized that it's showing the daily because it's set to do so, but the Rollup Interval is "greyed out" so I can't change that! I even tried with an hourly rollup, but it's not changing with that setting...

    Argghh: Got it just removing the check enables it :-(
    15Min Delta Rollup w. 15Min Rollup Interval

    posted in User help read more
  • mircsicz

    As I'm now importing my XML's I'm now creating dashboard's for the various Location's I'm AMR'ing. Nearly all those Energy-Meter's are read by MBus and deliver their meter reading as an absolut value continouesly growing...

    I've created a watch list following this

    But my graph looks like this by default:
    default chart

    What I need instead is a chart like this
    Power chart

    To achieve this every value needs to subtracted from the prior timestamp's value. But I didn't find any example where this was mentioned. I know it was mentioned in one of the demo video's but can't remember which...

    posted in User help read more
  • mircsicz

    I did another test:

    • created another superadmin user
    • changed "admin" passwd
    • tried to relogin with both user's

    both failed and the error in the log is:

       org.springframework.web.context.request.async.WebAsyncManager.WEB_ASYNC_MANAGER=org.springframework.web.context.request.async.WebAsyncManager@4ef58d08
       javax.servlet.error.status_code=500
       javax.servlet.error.exception_type=class org.springframework.dao.CannotAcquireLockException
       javax.servlet.http.HttpServletResponse=org.springframework.security.web.context.HttpSessionSecurityContextRepository$SaveToSessionResponseWrapper@28c26f74
       _csrf=org.springframework.security.web.csrf.DefaultCsrfToken@12b6570
       javax.servlet.error.message=org.springframework.dao.CannotAcquireLockException: PreparedStatementCallback; SQL [SELECT id,username,password,email,phone,disabled,homeUrl,lastLogin,receiveAlarmEmails,receiveOwnAuditEvents,timezone,muted,permissions,name,locale,tokenVersion,passwordVersion FROM users WHERE LOWER(username)=LOWER(?)]; Zeitüberschreitung beim Versuch die Tabelle "USERS" zu sperren
    Timeout trying to lock table "USERS"; SQL statement:
    SELECT id,username,password,email,phone,disabled,homeUrl,lastLogin,receiveAlarmEmails,receiveOwnAuditEvents,timezone,muted,permissions,name,locale,tokenVersion,passwordVersion FROM users WHERE LOWER(username)=LOWER(?) [50200-196]; nested exception is org.h2.jdbc.JdbcSQLException: Zeitüberschreitung beim Versuch die Tabelle "USERS" zu sperren
    Timeout trying to lock table "USERS"; SQL statement:
    SELECT id,username,password,email,phone,disabled,homeUrl,lastLogin,receiveAlarmEmails,receiveOwnAuditEvents,timezone,muted,permissions,name,locale,tokenVersion,passwordVersion FROM users WHERE LOWER(username)=LOWER(?) [50200-196]
    

    Resetting the admin passwd in H2-web-console and all is fine again:

    UPDATE USERS SET PASSWORD = '{NONE}admin' WHERE USERNAME = 'admin'
    

    posted in User help read more
  • mircsicz

    Yeap Phil, I'm aware of that. But with a working basic example like this one I can abstract the rest...

    THX a ton Philip I reran the import on al 50k XML files and I now have the expected data point's.... I'll now start to adopt for other value type's!!!

    posted in Development general discussion read more
  • mircsicz

    Hi Philip,

    yeap that's exactly what I want! But I can't realize the change, I guess I've to change "This EE point xid" in

    if(value.getEE() != null)    
                  result.add(new NumericImportPoint("This EE point xid", value.getEE().doubleValue(), sdf.parse(value.getDATETIME()).getTime(), extraParams));    
    

    But as I don't have any java experience I simply don't know how, So if you could phrase it for me once I'ld hopefully be done and gone... ;-)

    EDIT: I just saw that the Data Point is literally named: "This EE point xid" so if you'ld be so kind to tell me how to parse the string behind the "tp" var into that place that would probably be it. It expect the DataPoint name to be something like:

    • GHV1 3P6 5OG_EE
    • Case-Temp_TMP
    • or in other cases:
    • GHV1 3P6 5OG_PO
    • etc

    posted in Development general discussion read more
  • mircsicz

    THX to phil's support it's now importing and creating data point's

    But it's so far not the correct data point seperation!

    It needs to be seperated by TPID's

    EDIT: Sorry was in a rush as my son woke up while I was typing...

    The structur of the XML is as follow's:

    RMCU
       TP ID=NAME-OF-METERING-POINT
          VALUES
            DATETIME
             EE (Electric Energy)
             TMP (Temperatur)
             PO (Power)
             HQ (Heat Quantity)
          VALUES
       TP
    ID
     NAME-OF-DATALOGGER
    ID
    SERIAL
      SERIAL-OF-DATALOGGER
    SERIAL
    IP
       IP-OF-DATALOGGER
    IP
    RMCU
    

    Each TP-ID's VALUE tagged combined with DATETIME needs to become it's own Data Point

    posted in Development general discussion read more
  • mircsicz

    Argghhh, I've removed the additional "import" line's from TP and VALUES.java but I still get no positive feedback:

    {"resourceId":"DF_a963f6b1-51fe-445e-9d3e-d255342e2f58","progress":0,"finished":true,"cancelled":false,"errors":["Loading file ka-db failed: 1 counts of IllegalAnnotationExceptions"],"unfoundIdentifiers":[],"createdPoints":[],"failedPoints":[],"totalImported":0,"priority":2,"queueSize":0,"taskId":"TR_DF_a963f6b1-51fe-445e-9d3e-d255342e2f58","threadName":"Temporary Resource Timeout for : DF_a963f6b1-51fe-445e-9d3e-d255342e2f58","expires":1520371072215}```

    posted in Development general discussion read more
  • mircsicz

    Yes I saw your note and all I added to the other two *.java files was the import part's you mentioned...

    And yes copy/pasted the provided class ;-)

    posted in Development general discussion read more
  • mircsicz

    @phildunlap said in Import EnergyData from XML:

    Refresh that page, you should get some status information

    That's all I get... :-(

    posted in Development general discussion read more
  • mircsicz

    Hi Philip,

    I've uploaded using the API and clicked "Submit, get monitor":

    {"resourceId":"DF_672777d1-dc31-4ec8-bb0f-091d52697197","progress":0,"finished":true,"cancelled":false,"errors":["Loading file ka-db failed: 1 counts of IllegalAnnotationExceptions"],"unfoundIdentifiers":[],"createdPoints":[],"failedPoints":[],"totalImported":0,"priority":2,"queueSize":0,"taskId":"TR_DF_672777d1-dc31-4ec8-bb0f-091d52697197","threadName":"Temporary Resource Timeout for : DF_672777d1-dc31-4ec8-bb0f-091d52697197","expires":1520368586474}
    

    posted in Development general discussion read more
  • mircsicz

    @phildunlap There's no user other than admin... And as this is only a side effect and a testing setup I prefer to focus on the XML import... But I'll look into it as soon as the import work's

    @Jared-Wiltshire No, I've a tmux session on the server where I start and stop the H2-web-console.sh script... And while changing that passwd it was definetly off!

    posted in User help read more
  • mircsicz

    I've moved this issue to it's own topic

    And BTW: I've pasted the log output in that new topic...

    posted in User help read more
  • mircsicz

    I've just changed the admin passwd on a new installation.

    When trying to relogin I see this in the log's

    SELECT id,username,password,email,phone,disabled,homeUrl,lastLogin,receiveAlarmEmails,receiveOwnAuditEvents,timezone,muted,permissions,name,locale,tokenVersion,passwordVersion FROM users WHERE LOWER(username)=LOWER(?) [50200-196]
    
    org.springframework.dao.CannotAcquireLockException: PreparedStatementCallback; SQL [SELECT id,username,password,email,phone,disabled,homeUrl,lastLogin,receiveAlarmEmails,receiveOwnAuditEvents,timezone,muted,permissions,name,locale,tokenVersion,passwordVersion FROM users WHERE LOWER(username)=LOWER(?)]; Zeitüberschreitung beim Versuch die Tabelle "USERS" zu sperren
    Timeout trying to lock table "USERS"; SQL statement:
    SELECT id,username,password,email,phone,disabled,homeUrl,lastLogin,receiveAlarmEmails,receiveOwnAuditEvents,timezone,muted,permissions,name,locale,tokenVersion,passwordVersion FROM users WHERE LOWER(username)=LOWER(?) [50200-196]; nested exception is org.h2.jdbc.JdbcSQLException: Zeitüberschreitung beim Versuch die Tabelle "USERS" zu sperren
    Timeout trying to lock table "USERS"; SQL statement:
    SELECT id,username,password,email,phone,disabled,homeUrl,lastLogin,receiveAlarmEmails,receiveOwnAuditEvents,timezone,muted,permissions,name,locale,tokenVersion,passwordVersion FROM users WHERE LOWER(username)=LOWER(?) [50200-196]
    

    And the UI shows:

    An error occurred while logging in - Internal Server Error
    

    posted in User help read more
  • mircsicz

    Hi Philip,

    don't know what caused the error, but logging in without credential's did the trick.

    So I've reset the admin passwd, but when I set it again I get this

    An error occurred while logging in - Internal Server Error
    

    Why is it giving me such a hard time :-(

    posted in User help read more