The console informs that IP limit, see attachment. Limit really disappears when restart the MA again. Unfortunately I cannot restart the computer if I’m for example at the trip and not home. If I want to check the situation there will be contacts from several address more than three.
How I can avoid this three limit system, so that I can take the remote control from anywhere?

Attachment: download link

I use Core version 2.0.3 at home. But I cannot take remote connection, because there is that 3 ip limit. I take connection to address like xxx.xxxxxxxx.dy.fi:8082. (dy.fi is a dynamic dns service) At home I can take connection from different computers, because it take that address always 192.168.100.1 but from other sources (not home network) connection it seems to be the real address. I didn’t found any Mango license file on Mango folder. What should I do that I can use remote connection for other networks?

Hello,

I’m planning to update Mango version 12.4 for new Mango automation system.
Is it possible to copy Mango's Mysql database with for example Mysql Workbench tool to new system’s Mysql database? I can transfer other settings with import/export function but is that database case possible? If I need to use Mango automation Data import modul what is to practical way to change database to csv -format? I have got 230 data point in my system from two years period, database is quite big. Should I start it from the beginning or can I upload the old data easily?

BR,
Antsu

Hello,

I’m planning to update Mango version 12.4 for new Mango automation system.
Is it possible to copy Mango's Mysql database with for example Mysql Workbench tool to new system’s Mysql database? I can transfer other settings with import/export function but is that database case possible? If I need to use Mango automation Data import modul what is to practical way to change database to csv -format? I have got 230 data point in my system from two years period, database is quite big. Should I start it from the beginning or can I upload the old data easily?

BR,
Antsu

Did you mean that env.properties?

db.type=mysql
db.url=jdbc:mysql://localhost/mango
db.username=mangoUser
db.password=mangoPass
db.pool.maxActive=10
db.pool.maxIdle=10
db.update.log.dir=${catalina.base}/logs/

convert.db.type=derby
convert.db.url=~/../..mangoDB
convert.db.username=
convert.db.password=

Hi,

I'm tried to setup Mango on my new computer. OS is Ubuntu 12.04 LTS and then Mysql version is 5.5.24-0ubuntu0.12.04.1 and Mango 1.13.0.

When I try to start Mango, browser says:

            *  HTTP Status 404 -*

Localhost.log says:

*Jun 19, 2012 7:03:10 PM org.apache.catalina.core.ApplicationContext log

INFO: Initializing Spring root WebApplicationContext

Jun 19, 2012 7:03:13 PM org.apache.catalina.core.StandardContext listenerStart

SEVERE: Exception sending context initialized event to listener instance of class com.serotonin.mango.MangoContextListener

org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [ create table systemSettings ( settingName varchar(32) not null, settingValue longtext, primary key (settingName) ) engine=InnoDB; ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'mango.systemSettings' already exists

at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:94)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:427)

at com.serotonin.mango.db.BasePooledAccess.runScript(BasePooledAccess.java:89)

at com.serotonin.mango.db.BasePooledAccess.createSchema(BasePooledAccess.java:106)

at com.serotonin.mango.db.MySQLAccess.newDatabaseCheck(MySQLAccess.java:79)

at com.serotonin.mango.db.DatabaseAccess.initialize(DatabaseAccess.java:102)

at com.serotonin.mango.MangoContextListener.databaseInitialize(MangoContextListener.java:259)

at com.serotonin.mango.MangoContextListener.contextInitialized(MangoContextListener.java:98)

at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)

at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)

at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675)

at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601)

at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)

at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)

at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)

at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)

at org.apache.catalina.core.StandardService.start(StandardService.java:525)

at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)

at org.apache.catalina.startup.Catalina.start(Catalina.java:595)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:616)

at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'mango.systemSettings' already exists

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:532)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)

at com.mysql.jdbc.Util.getInstance(Util.java:381)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477)

at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:741)

at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:587)

at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:266)

at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:420)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395)

... 31 more

Jun 19, 2012 7:03:13 PM org.apache.catalina.core.ApplicationContext log

INFO: Closing Spring root WebApplicationContext
*
What went wrong?

BR

Antsu

My system is fall down. Maybe hard disk is gone. :cry: But if I can recovery that, where is all data points, and graphical views? Is any else files what I should recovery?

BR Antsu

My system is fall down. Maybe hard disk is gone. :cry: But if I can recovery that, where is all data points, and graphical views? Is any else files what I should recovery?

BR Antsu

Hi,
I need to use eventhandler process to run script. I put that script on that path: /usr/share/tomcat6/bin but when I run that by clicking green arrow in Mango, appears that message (see attachment). Nothing else happened.I try also path /var/lib/tomcat6/webapps/ROOT but that works similarity.
When I run that script on that folder, that works. What I should change ?

BR
Antsu

Attachment: download link

Hi,
I need to use eventhandler process to run script. I put that script on that path: /usr/share/tomcat6/bin but when I run that by clicking green arrow in Mango, appears that message (see attachment). Nothing else happened.I try also path /var/lib/tomcat6/webapps/ROOT but that works similarity.
When I run that script on that folder, that works. What I should change ?

BR
Antsu

Hi,
that is nice to hear. Could you give some info when the new release is available, please

Hi,

I use meta data scripts and they will update with cron pattern. When I use Mango 1.9.0 update was ok, but now I use Mango ver. 1.12.0 (1.12.2). Every time when Mango startup, Mango runs scripts. Example I calculate electricity consumption per month. That script’s update is Cron pattern 30 59 23 L * ? but every time when Mango starts that calculation updates.
Is that be caused by Quartz Scheduler was replace with Java Timer ?
Is any other way to do same function?

BR
Antsu

Hi,

I use meta data scripts and they will update with cron pattern. When I use Mango 1.9.0 update was ok, but now I use Mango ver. 1.12.0 (1.12.2). Every time when Mango startup, Mango runs scripts. Example I calculate electricity consumption per month. That script’s update is Cron pattern 30 59 23 L * ? but every time when Mango starts that calculation updates.
Is that be caused by Quartz Scheduler was replace with Java Timer ?
Is any other way to do same function?

BR
Antsu

Thank’s for your advice, Joel. That way it is VERY easy. I think that so complicated. :oops:
Simply is beautifully….

BR
Antsu

Hello,

How I can send Mango’s measurements to outside via Modbus? My purpose is to send to Mango’s 1-Wire measurement’s to PLC holding registers via Modbus. I can send them to plc on Points details-tab, but how I can do that automatically?

BR
Antsu

Hello,

How I can send Mango’s measurements to outside via Modbus? My purpose is to send to Mango’s 1-Wire measurement’s to PLC holding registers via Modbus. I can send them to plc on Points details-tab, but how I can do that automatically?

BR
Antsu

I connect PLC to Mango via MODBUS. Connection is ok and data flows. But then appears one problem. When I go back to Modbus serial properties menu, port is gone. If I click arrow, opening box is empty. Connection is still working. If I made Modbus data source again, then port will be visible, but when I open properties again that disappears. Because that port is missing, I can’t do any changes to settings, update period for example. Mango version is 1.9.0 and I use Ubuntu 10.04.

Second problem is updating Mango version 1.10.0. When I log in first time after updating, browser says:
”waiting answer from address....” .I lost my nerves after half an hour and put old installation back. Did that 1.10.0 update do something to Derby database? In my opinion, that database is grow about 1,5 times. Is that reason to slow down?

BR
Antsu

I connect PLC to Mango via MODBUS. Connection is ok and data flows. But then appears one problem. When I go back to Modbus serial properties menu, port is gone. If I click arrow, opening box is empty. Connection is still working. If I made Modbus data source again, then port will be visible, but when I open properties again that disappears. Because that port is missing, I can’t do any changes to settings, update period for example. Mango version is 1.9.0 and I use Ubuntu 10.04.

Second problem is updating Mango version 1.10.0. When I log in first time after updating, browser says:
”waiting answer from address....” .I lost my nerves after half an hour and put old installation back. Did that 1.10.0 update do something to Derby database? In my opinion, that database is grow about 1,5 times. Is that reason to slow down?

BR
Antsu

Hi!
Indeed Java was updated its latest version. All the files into right palace and now all works fine.

Both RXTXcomm.jar and librxtxSerial.so were there in the right place. I copied those again, but not any help. 1-wire view is still same. What should I do next? Ubuntu made automatic updating (n.35mb). I haven’t look that any better what that include.