Yeah, if you could zip up the madb and the logs and email them that could be interesting when I find a spare moment.

Derby has a MySQL like language, and you could just give the directive 'delete from userEvents' to whatever your tool is.

Another possibility is to port the database into MySQL so that the better toolset is available. Mango has the ability to perform that database port (can be found in the "convert database" type fields in your Mango/classes/env.properties (or Mango/overrides/properties/env.properties if you overrode it) which you just boot with the first time and it should port everything, then modify the environment to use the MySQL. I wouldn't expect an issue in the conversion since it seems the IDs have just [somehow] gotten jumbled and inserts are failing. Doesn't look like your database is wholly corrupted or cannot be read, and it'll convert the whole database before it goes about its other business.

Edit: I'm beginning to wonder if I'm mistaken, and if only the pointValues table is converted...

Alex,

Depending on your level of coding ability you could check out the ControlToolbox module I wrote here:

http://github.com/terrypacker/mango-modules

It hasn't been tested in any real world applications yet and the documentation for it is limited. But if you did use it I could give you some information on it and get it tuned up and working better with your feedback.

It currently only has support for PID loops but the plan was to add other algorithms to it over time.

I suggest you experiment with the 'Meta Data Source'

I've installed it using sudo apt-get install librxtx-java on Ubuntu 12.04. I am not familiar with Java unfortunately and it's infrastructure, so consider me a dumb user.

I have a modbus serial source setup and it seems to work fine (ie. I get he frequency from the inverter).

But it seems each time it will create the following error in the log:

Oct 23 23:59: 'Modbus': Exception from modbus master: No recipient was found waiting for response for key com.serotonin.modbus4j.serial.SerialWaitingRoomKeyFactory$TransportSyncWaitingRoomKey@1 UrgentOct 23 23:54: 'Modbus': Exception from modbus master: No recipient was found waiting for response for key com.serotonin.modbus4j.serial.SerialWaitingRoomKeyFactory$TransportSyncWaitingRoomKey@1 UrgentOct 23 23:49: 'Modbus': Exception from modbus master: No recipient was found waiting for response for key com.serotonin.modbus4j.serial.SerialWaitingRoomKeyFactory$TransportSyncWaitingRoomKey@1 UrgentOct 23 23:44: 'Modbus': Exception from modbus master: No recipient was found waiting for response for key com.serotonin.modbus4j.serial.SerialWaitingRoomKeyFactory$TransportSyncWaitingRoomKey@1 UrgentOct 23 23:39: 'Modbus': Exception from modbus master: No recipient was found waiting for response for key com.serotonin.modbus4j.serial.SerialWaitingRoomKeyFactory$TransportSyncWaitingRoomKey@1 UrgentOct 23 23:34: 'Modbus': Exception from modbus master: No recipient was found waiting for response for key com.serotonin.modbus4j.serial.SerialWaitingRoomKeyFactory$TransportSyncWaitingRoomKey@1 UrgentOct 23 23:29: 'Modbus': Exception from modbus master: No recipient was found waiting for response for key com.serotonin.modbus4j.serial.SerialWaitingRoomKeyFactory$TransportSyncWaitingRoomKey@1 UrgentOct 23 23:24: 'Modbus': Exception from modbus master: No recipient was found waiting for response for key com.serotonin.modbus4j.serial.SerialWaitingRoomKeyFactory$TransportSyncWaitingRoomKey@1

I am not sure if it's me who's doing it wrong or if there is an error.
When I hit HTTP Send Test / Send Static Data it shows "Sending..." and will stay like this until I hit cancel.
I also get the following error

WARN 2013-10-21 12:20:07,223 (com.serotonin.m2m2.web.dwr.MiscDwr.jsError:176) - Javascript error Description: TypeError: PublisherEditDwr.httpSenderTest is not a function Page: http://192.168.0.171:8080/publisher_edit.shtm?pid=1 Line: 567 Browser name: Firefox Browser version: 23 osName: Windows location: http://192.168.0.171:8080/publisher_edit.shtm?pid=1

Apart from this, what I am trying to do is to post some info via HTTP GET to a Cai WebControl board.

The URL would be

http://192.168.1.15/api/seturom.cgi?uromid=1&value=23456789

But I am using a password, so maybe

http://admin:password@192.168.1.15/api/seturom.cgi?uromid=1&value=23456789

Or using static HTTP headers. That's what I am trying to figure out.

Under Static Headers I entered

Authorization=Basic YWRtaW46cGFzc3dvcmQ=

(The string is base64 encode of "admin:password")

Is what I am doing about right?

Eventually what I am trying to do is update a value as above on a certain event (ie. HTTP Retriefer receives an alarm).

Alex

Joel posted a .conf file that adds that functionality some months ago: http://forum.infiniteautomation.com/forum/posts/list/1408.page

We definitely would appreciate seeing whatever you put together!

Click on the point details icon on the far left of the top menu. Then click on the "edit data point" icon and you will see the option to change the device name. In our next release we have combined all these setting into one place to make it much easier to find.

Joel.