Does RKM 7.5 run against a 7.1 ARS??
-----Original Message----- >From: strauss <stra...@unt.edu> >Sent: Jan 25, 2010 10:18 PM >To: arslist@ARSLIST.ORG >Subject: Re: RKM No Suitable Driver > >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" ________________________________________ 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"
