Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

Antsu

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

Antsu

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?

posted in User help

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

posted in User help

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

posted in User help

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=

posted in User help

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

posted in User help

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

posted in User help

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

posted in User help

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

posted in User help

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

Antsu

@Antsu

Latest posts made by Antsu