• Recent
    • Tags
    • Popular
    • Register
    • Login

    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 5 Documentation Website

    Mango to MS Sql Server 2008

    User help
    2
    11
    4.6k
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • R
      r00t
      last edited by

      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 ?

      1 Reply Last reply Reply Quote 0
      • M
        mlohbihler
        last edited by

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

        Best regards,
        Matthew

        1 Reply Last reply Reply Quote 0
        • R
          r00t
          last edited by

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

          1 Reply Last reply Reply Quote 0
          • M
            mlohbihler
            last edited by

            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.

            Best regards,
            Matthew

            1 Reply Last reply Reply Quote 0
            • R
              r00t
              last edited by

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

              1 Reply Last reply Reply Quote 0
              • M
                mlohbihler
                last edited by

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

                Best regards,
                Matthew

                1 Reply Last reply Reply Quote 0
                • R
                  r00t
                  last edited by

                  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

                  1 Reply Last reply Reply Quote 0
                  • M
                    mlohbihler
                    last edited by

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

                    Best regards,
                    Matthew

                    1 Reply Last reply Reply Quote 0
                    • R
                      r00t
                      last edited by

                      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
                      1 Reply Last reply Reply Quote 0
                      • M
                        mlohbihler
                        last edited by

                        I can't really help you with that.

                        Best regards,
                        Matthew

                        1 Reply Last reply Reply Quote 0
                        • First post
                          Last post