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.

posted in User help

Hi,

i need to edit [add/rename/remove] the Data Sources list:

for example, how to remove the DNP3 Serial datasource ?

posted in User help

Hi,

i need to edit [add/rename/remove] the Data Sources list:

for example, how to remove the DNP3 Serial datasource ?

posted in User help

i believe it is the sqljbc.jar's issue, could u please upload the latest one u're using ?
thanks

posted in User help

hi mlohbihler,

could you please help me fix this error : http://pastebin.com/nt8C4fbC

thanks!

posted in User help

hi mlohbihler,

could you please help me fix this error : http://pastebin.com/nt8C4fbC

thanks!

r00t

we hope that these "business-side changes " things don't affect the licence (GPL) !! and we're tuned for details as well :)
thanks for the quick feed back mate;)

r00t

so why the latest version of mango is kept private ? where can i find the source code of the version 1.13.0 since it's GPL ?

r00t

the next private version of mango u mean :wink:

posted in User help

here's the log file from tomcat directory: "mango.log"

FATAL 2012-01-09 15:44:01,613 (com.serotonin.mango.db.DatabaseAccess.initialize:153) - Unable to connect to database of type MSSQL 
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication.)
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:381)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:428)
	at com.serotonin.mango.db.MSSQLAccess.newDatabaseCheck(MSSQLAccess.java:47)
	at com.serotonin.mango.db.DatabaseAccess.initialize(DatabaseAccess.java:99)
	at com.serotonin.mango.MangoContextListener.databaseInitialize(MangoContextListener.java:255)
	at com.serotonin.mango.MangoContextListener.contextInitialized(MangoContextListener.java:94)
	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.deployDirectory(HostConfig.java:1079)
	at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1002)
	at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:506)
	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(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
	at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication.)
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1232)
	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:881)
	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)
	... 30 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication.
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1352)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2329)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:1905)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:1893)
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1045)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:817)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:700)
	at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:842)
	at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
	at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
	at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1254)
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1228)
	... 33 more
Caused by: java.lang.UnsatisfiedLinkError: no sqljdbc_auth in java.library.path
	at java.lang.ClassLoader.loadLibrary(Unknown Source)
	at java.lang.Runtime.loadLibrary0(Unknown Source)
	at java.lang.System.loadLibrary(Unknown Source)
	at com.microsoft.sqlserver.jdbc.AuthenticationJNI.<clinit>(AuthenticationJNI.java:32)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:1902)
	... 45 more

posted in User help

the app couldn't start; but, if i convert to mysql or derby, it works , so i think i've a mistake only in the connection string

posted in User help

the database is Ms Sql server not mysql, and i've only created the 'empty' schema ; i let mango creat the tables itself as u said in the mango<->mysql thread somewhere...

posted in User help

i've edited "WEB-INF/classes/env.properties" file but still doesn't work

posted in User help

hi,
i'm trying to connect mango to ms sql server 2008 R2, this is my build.propreties file:

tomcat.home=C:/Program Files/Apache Software Foundation/Tomcat 6.0
tomcat.manager.url=http://localhost:8080/manager/html
tomcat.manager.username=manager
tomcat.manager.password=manager
tomcat.hostname=webapps

# App name and app path are separated to accomodate root deployments. (i.e. 'ROOT' vs. '/') 
tomcat.appdir=mango
tomcat.apppath=/mango

log4j.xml.logThreshold=warn

db.type=mssql
db.url=jdbc:sqlserver://localhost:1433;databaseName=DbMango;integratedSecurity=true;
db.username=sa
db.password=
db.pool.maxActive=10
db.pool.maxIdle=10

convert.db.type=derby
convert.db.url=~/../../bin/DbMango
convert.db.username=
convert.db.password=

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

# This property is only used for building a distribution.
version=1.0.0

the BUILD is Succussful but the convert doesn't happen, any suggestion ?

posted in User help

hi,
i'm trying to connect mango to ms sql server 2008 R2, this is my build.propreties file:

tomcat.home=C:/Program Files/Apache Software Foundation/Tomcat 6.0
tomcat.manager.url=http://localhost:8080/manager/html
tomcat.manager.username=manager
tomcat.manager.password=manager
tomcat.hostname=webapps

# App name and app path are separated to accomodate root deployments. (i.e. 'ROOT' vs. '/') 
tomcat.appdir=mango
tomcat.apppath=/mango

log4j.xml.logThreshold=warn

db.type=mssql
db.url=jdbc:sqlserver://localhost:1433;databaseName=DbMango;integratedSecurity=true;
db.username=sa
db.password=
db.pool.maxActive=10
db.pool.maxIdle=10

convert.db.type=derby
convert.db.url=~/../../bin/DbMango
convert.db.username=
convert.db.password=

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

# This property is only used for building a distribution.
version=1.0.0

the BUILD is Succussful but the convert doesn't happen, any suggestion ?

Posts made by r00t