@nikorun
where this master.setValue
(...) line should be added ?

I am have issue with reading current BACnet PLC date and time. I use following code.

		PropertyIdentifier pidTime = new PropertyIdentifier(57);
		log.warn( "Time "+ localDevice.getConfiguration().getProperty(pidTime));
		log.warn("Sys time " + tmptime.toString());		

		tmptime = new DateTime();
		
		// Reading local device time/date value
		Encodable deviceTime = localDevice.getConfiguration().getProperty(pidTime);

I get system time instead of real PLC time. What am I doing wrong? Should it be conduct on RemoteDevice? If yes, how. Please help.

@joolz said in How to get current device time?:

For a device object, you can read the Local_Date and Local_Time properties.

Is there some kind of LocalDevice/ RemoteDevice method do this ? It is no easy to find.

I can't wait Joel :D !

@JoelHaggar said:

Something to know is that in a very near release of the Mango Automation Enterprise license we will offer a NoSQL database option that gives impressive performance for very large systems.

Thank you very much for so prompt response! You have no idea how I appreciate it!

mango.log doesn't show anything special - without error/warnings but still freezed on startup level... ( maybe it is just me being impatient.... :oops: )
I decreased size of my database to the 1.2GB and problem is solved but question is how to avoid this kind of behavior - becouse in the future I will have - for sure huge database.

Thank you for advice with disabling all of the sources - I guess it could possibly help. I I will find solution I will share with you :-).

@phildunlap said:

A good thing to know is that you can put a file in your Mango root directory called "SAFE" and boot Mango with your datasources disabled. I suspect something in your configuration is causing an unnecessary delay, or your network is significantly slower than you're querying it. You could do some trial and error datasource/datapoint enabling.... or, have you investigated your mango/logs/ma.log? If so, swap debug-log4j.xml with log4j.xml in mango/classes for a boot, and let's have a look

**phildunlap ** I have additional question :) .
I was able to run Mango on MySQL but time from hitting Apache *startup * till the moment Mango starts, increased from couple of seconds to the 4 hours (database has 4.5GB)....
Is it possible to fix it? I use Apache 7.0.

@phildunlap said:

I suspect the database conversion will help a lot, and thanks for answering, hussam.

In regards to the second part of the first post, you could investigate tuning the -X arguments passed to the JVM in your .bat or .sh start up script, such as your -Xms (Initial heap). I don't know that you're going to need to go into situations where Mango will require more than 4Gb with 8000pnts/2minutes, although this of course depends upon the configuration and use case.

Thank you for your answer - phildunlap. According your advice - I also improved Java parameters -> following this tutorial: http://www.wikihow.com/Increase-Java-Memory-in-Windows-7. There is also option to set JAVA heap space in TomCat service, but despite all this actions, I still had JAVA cheap space after some time (even If I set 4GB).

But I guess that should be set inside Mango to make it work, because It will be overwrite by constans inside Mango? Am I wrong?

@phildunlap said:

I suspect the database conversion will help a lot, and thanks for answering, hussam.

In regards to the second part of the first post, you could investigate tuning the -X arguments passed to the JVM in your .bat or .sh start up script, such as your -Xms (Initial heap). I don't know that you're going to need to go into situations where Mango will require more than 4Gb with 8000pnts/2minutes, although this of course depends upon the configuration and use case.

@hussam said:

your env.properities configuration is wrong,if you want to convert derby to mysql,configuration is like:

first creat one empty database in mysql,

then.
(new datase)
db.type=mysql
db.url=jdbc:mysql://localhost/samedb
db.username=
db.password=
db.pool.maxActive=10
db.pool.maxIdle=10
db.update.log.dir=${catalina.base}/logs/

(old database)
convert.db.type=derby
convert.db.url=~/../../bin/mangoDB2
convert.db.username=
convert.db.password=

grove.url=http://mango.serotoninsoftware.com/servlet

Thank you very much for your response!

And did you tried to increase values of parametres:
db.pool.maxActive=10
db.pool.maxIdle=10
without loosing stability?
If yes, did it cause improvement of Mango performance ?

Hey,

I want to run Mango on Kubuntu 13.10.

I installed/moved to described points following files/applications:

1. librxtxSerial.so: save in <jdk1.6-home>/jre/lib/i386
2. RXTXcomm.jar: save in <jdk1.6-home>\jre\lib\ext
3. apache-tomcat-6.0.20.tar.gz
4. mango-1.12.5.tar.gz

Hey,

I want to run Mango on Kubuntu 13.10.

I installed/moved to described points following files/applications:

1. librxtxSerial.so: save in <jdk1.6-home>/jre/lib/i386
2. RXTXcomm.jar: save in <jdk1.6-home>\jre\lib\ext
3. apache-tomcat-6.0.20.tar.gz
4. mango-1.12.5.tar.gz