On 7.1 and 7.2 I have had much better luck installing RKM with the JDBC Driver
for SQL Server 2000 installed, even though I was normally using it against a
local install of SQL Server 2005 Standard; the KMS_config.xml file is coded for
that, and is better able to complete the installation. THEN I usually edit the
xml file to change the driver.
OOTB:
<!-- Shipping default is SQLServer2000 on localhost:1433(default install) -->
<database driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
password="!!gdfadfcdfddhglda" schema_name="rkm" type="sqlserver"
url="jdbc:microsoft:sqlserver://localhost:1433" user="RKMAdmin"/>
</RKM_boot>
...and then comment out the old line and add the new line with the correct
syntax for the 2005 driver (.jdbc.sqlserver. get inverted to sqlserver.jdbc):
<!--database driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
password="!!gdfadfcdfddhglda" schema_name="rkm" type="sqlserver"
url="jdbc:microsoft:sqlserver://localhost:1433" user="RKMAdmin"/-->
<database driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
password="!!gdfadfcdfddhglda" schema_name="rkm" type="sqlserver"
url="jdbc:sqlserver://localhost:1433" user="RKMAdmin"/>
</RKM_boot>
I checked several of my RKM 7.2 servers, and all have the 2000 syntax commented
out and the 2005 syntax added. Trying to do this _during_ the install doesn't
work - do it afterwards.
======================================================
BTW, in 7.5 they include more possibilities for the db:
"Out-of-the-box JDBC driver
A JDBC driver is provided with the BMC Remedy Knowledge Management
installation, for Sybase, Oracle®, and MS SQL databases. MySQL databases
requires you to acquire the relevant JDBC driver."
<!-- Shipping default is SQLServer2000 on localhost:1433(default install)
-->
<database_mysqldisabled driver="com.mysql.jdbc.Driver"
initial="0" max-active="75" max-idle="25" min-idle="0" password="password"
url="jdbc:mysql://localhost/rkm" user="root"/>
<database driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
initial="0" max-active="75" max-idle="25" min-idle="0"
password="!!gdfadfcdfddhglda" schema_name="rkm" type="sqlserver"
url="jdbc:sqlserver://localhost:1433" user="RKMAdmin"/>
<database_sybasedisabled
driver="com.sybase.jdbc2.jdbc.SybDriver" initial="0" max-active="75"
max-idle="25" min-idle="0" password="" url="jdbc:sybase:Tds:localhost:5000/rkm"
user="sa"/>
<database_oracledisabled
driver="oracle.jdbc.driver.OracleDriver" initial="0" max-active="75"
max-idle="25" min-idle="0" password="password"
url="jdbc:oracle:thin:@localhost:1521:orcl" user="system"/>
...and the installer must have set the syntax to 2005 or later; my db on that
server is SQL Server 2008. It was built in early November, days before WWRUG
2009 as a new install with RKM 7.5.00.001, and I have forgotten whether the
installer even supports SQL Server 2000, or what choices it gave me (and none
of the documentation is helpful in this regard).
Christopher Strauss, Ph.D.
Call Tracking Administration Manager
University of North Texas Computing & IT Center
http://itsm.unt.edu/
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of bruce sisk
Sent: Monday, January 25, 2010 8:09 PM
To: arslist@ARSLIST.ORG
Subject: Re: RKM No Suitable Driver
So...I spent the weekend wiping this server and reinstalling:
Java 1.6 P18
MS SQL 2005 JDBC drivers 1.2
Mid-tier 7.1 P8 including Tomcat
RKM 7.2
Mid-tier is working and fully able to communicate with the DB.
RKM installed with no issues.
I am unable to complete the Configuration wizard. I get to the screen where it
asks for the info to create the DB objects and I get the error in the log shown
below...Failed to create database objects. No suitable driver.
I have the JDBC on the same server as the RKM install. I have read and followed
ALL of the KB articles that apply or may apply to this. I added a classpath to
the environment varibales...is that correct?? Should it be in a Tomcat config
somewhere?? Is the 1.2 version the correct one to use??
I am sure there are many installations of this out there. I would appreciate
any help.
Thanks,
Bruce Sisk
>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:arsl...@arslist.org]on Behalf Of bruce sisk
>Sent: Thursday, January 21, 2010 10:16 PM
>To: arslist@ARSLIST.ORG
>Subject: RKM No Suitable Driver
>
>
>I am installing RKM 7.2 on a Windows 2003 server, MS SQL 2005 DB with Tomcat
>and IIS and Remedy Mid-tier 7.1 Patch 8 (although there appears to be
>remnants of a 7.0.x install). Mid-tier works. the .jar files are in the
>tomcat common lib folder.
>
>I keep getting an error when trying to create the rkm database using the RKM
>Config Wizard:
>
>ERROR: Diagnostics: Failed to create database connection: Cannot create JDBC
>driver of class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' for connect
>URL 'jdbc:microsoft:sqlserver://<remote server>:1433'
>ERROR: kms.sql.SQLServer: Failed to create database objects: No suitable
>driver
>
>I have a classpath that points to the sqljdbc.jar. It is the 1.2 version of
>the JDBC driver.
>
>I am not getting a login failure so I don't think that is the reason.
>
>I am stumped. I am about ready to wipe the whole server and start over, but
>I am not sure if that is the solution. Would hate to do all that and still
>get the same problem.
>
>Below is the details of the log file.
>
>Bruce Sisk
>
>21-Jan-10 22:03:25 * ERROR: Diagnostics: Failed to create database
>connection: Cannot create JDBC driver of class
>'com.microsoft.sqlserver.jdbc.SQLServerDriver' for connect URL
>'jdbc:microsoft:sqlserver://xxx:1433'
>21-Jan-10 22:03:25 INFO: Diagnostics: Code version: 7.2.00.1521
>21-Jan-10 22:03:25 INFO: Diagnostics: Config version: 7.2.00.1521
>21-Jan-10 22:03:25 DEBUG: HomeFinder: Creating SearchServer connection
>pool...
>21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer driver:
>jdbc.searchserver.SSDriver
>21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer URL:
>jdbc:searchserver:SearchServer_5.4
>21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer active: 1
>21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer max idle: 1
>21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer min idle: 0
>21-Jan-10 22:03:25 INFO: HomeFinder: SearchServer properties file not
>specified, using defaults
>21-Jan-10 22:03:25 INFO: AppConfig: Configuration settings successfully
>loaded.
>21-Jan-10 22:03:25 DEBUG: HomeFinder: Creating raw database connection...
>21-Jan-10 22:03:25 DEBUG: HomeFinder: Database driver:
>com.microsoft.sqlserver.jdbc.SQLServerDriver
>21-Jan-10 22:03:25 DEBUG: HomeFinder: Database URL:
>jdbc:microsoft:sqlserver://xxx:1433
>21-Jan-10 22:03:25 DEBUG: HomeFinder: Database user: xxx
>21-Jan-10 22:03:25 DEBUG: HomeFinder: Database password: ********
>21-Jan-10 22:03:25 * ERROR: kms.sql.SQLServer: Failed to create database
>objects: No suitable driver
>21-Jan-10 22:03:31 DEBUG: AppConfig:
>kms.authentication.SystemConfigurationAuthenticator created.
>
>________________________________________
>PeoplePC Online
>A better way to Internet
>http://www.peoplepc.com
>
>_______________________________________________________________________________
>UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
________________________________________
PeoplePC Online
A better way to Internet
http://www.peoplepc.com
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
