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.

Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website

Mango to MS Sql Server 2008


  • 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 ?


  • Check your WEB-INF/classes/env.properties file. Make sure it looks ok.


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


  • Ensure that the tables in the mysql schema - but not the schema itself - have been dropped and try again. A conversion will only be run if Mango creates the tables anew.


  • 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...


  • Right, I meant mssql. Ok, are there any startup errors?


  • 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


  • Knowing the actual error message that you are getting would be very helpful.


  • 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
    

  • I can't really help you with that.