Page 1 of 1
Trying to install OpenKM with SQL Server
PostPosted:Tue Nov 12, 2013 4:51 pm
by Shakes
Hi all,
Trying to install OpenKM with SQL Server 2008 r2, I've been through all the necessary steps to achieve this provided by the following link:
http://wiki.openkm.com/index.php/SQL_Se ... OpenKM_6.2. Please check the screenshot of the error message when trying to run OpenKM.
I have modified server.xml to point to my Database
Code: Select all<Resource name="jdbc/OpenKMDS" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000" validationQuery="select 1"
username="okm" password="<my pswd here" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://<MyServerHere>;databaseName=okm_repo"/>
Thanks
Dan
Re: Trying to install OpenKM with SQL Server
PostPosted:Tue Nov 12, 2013 6:22 pm
by michaeled
Did you try to login to the sql server from the OpenKM server in command line with the same information?
Look at the catalina log and the access log of the sql server
Michael
Re: Trying to install OpenKM with SQL Server
PostPosted:Wed Nov 13, 2013 9:15 am
by Shakes
michaeled wrote:Did you try to login to the sql server from the OpenKM server in command line with the same information?
Look at the catalina log and the access log of the sql server
Michael
I haven't no, how would login to sql server via the openKM server?
Many thanks
Re: Trying to install OpenKM with SQL Server
PostPosted:Wed Nov 13, 2013 9:28 am
by michaeled
I use mysql client to connect to mysql server in command line. For sql server there is an ODBC driver for linux, look at here:
http://stackoverflow.com/questions/1493 ... from-linux
Re: Trying to install OpenKM with SQL Server
PostPosted:Wed Nov 13, 2013 9:47 am
by Shakes
michaeled wrote:I use mysql client to connect to mysql server in command line. For sql server there is an ODBC driver for linux, look at here: http://stackoverflow.com/questions/1493 ... from-linux
I have downloaded SQLCMD, do I test the following:
Code: Select all url="jdbc:sqlserver://<myserver>:1433;databaseName=okm_repo"/>
Michael, thanks for your help.
Dan
Re: Trying to install OpenKM with SQL Server
PostPosted:Wed Nov 13, 2013 10:48 am
by Shakes
Code: Select all2013-11-13 10:44:40,280 [pool-2-thread-1] ERROR org.hibernate.util.JDBCExceptionReporter - Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
2013-11-13 10:44:40,285 [pool-2-thread-1] ERROR com.openkm.core.Config - ** Error reading configuration table **
2013-11-13 10:44:40,288 [pool-2-thread-1] INFO com.openkm.servlet.RepositoryStartupServlet - *** Repository initializing... ***
2013-11-13 10:44:40,340 [pool-2-thread-1] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: null
2013-11-13 10:44:40,341 [pool-2-thread-1] ERROR org.hibernate.util.JDBCExceptionReporter - Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
2013-11-13 10:44:40,342 [pool-2-thread-1] ERROR org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/OpenKM] - Servlet /OpenKM threw load() exception
Manage to find the logs, Cannot load JDBC driver class, I've placed the sqljdbc_4.0.2206.100_enu.exe within the tomcat\lib folder. Is this the correct way?
Re: Trying to install OpenKM with SQL Server
PostPosted:Wed Nov 13, 2013 12:03 pm
by Shakes
Managed to find out the issue, I required to manually copy the .jar file to the Tomcat lib folder. All working dandy :0
Re: Trying to install OpenKM with SQL Server
PostPosted:Fri Nov 15, 2013 4:50 pm
by jllort
Seems you've solved. I will change okm_repo database name from wiki, now we're using okmdb name.