you must be sure that interserver is started and responding (try telnet localhost 3060 to test it). interserver is the server-side part of interclient. i'm afraid i've never used interbase with JDBCRealm so i cannot give you advice for that
michael -----Original Message----- From: Diego Novati [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 11:47 PM To: Tomcat Users List Subject: Re: JNDIRealm and Interbase - step 3 Hi falks ! I solved the problem of step 2 copying "interclient.jar" in $CATALINA\common\lib and now I'm able to start Tomcat again. Now ther's the last problem: calling http://localhost:8080/manager/list I'm getting a "HTTP 500 - Internal server error" and in the "catalina_log" I have the following exception error: 2001-12-18 23:34:55 HttpProcessor[8080][4] process.invoke java.lang.NullPointerException at interbase.interclient.PreparedStatement.setString(PreparedStatement.java:979 ) at org.apache.catalina.realm.JDBCRealm.credentials(JDBCRealm.java:484) at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:376) at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:326) .... Anyting to suggest ? Is tehre someone who was able to use Interbase with Tomcat for JDNRRealm ? Thanks Diego ----- Original Message ----- From: "Diego Novati" <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]> Sent: Tuesday, December 18, 2001 11:19 PM Subject: Re: JNDIRealm and Interbase - step 2 > Hi, > thanks for your tips. > I downloded and installed Firebird InterClient 2.01 and corrected '\' with > '/'. > The problem is that nothing has changed !!!! > > <Realm className="org.apache.catalina.realm.JDBCRealm" > driverName="interbase.interclient.Driver" > connectionName="SYSDBA" > connectionPassword="masterkey" > connectionURL="jdbc:interbase://localhost/C:/Program > Files/Apache Group/Tomcat 4.0/DBUsers/DBUSERS.GDB" > userTable="USERS" userNameCol="USER_NAME" > userCredCol="USER_PASS" > userRoleTable="USER_ROLES" roleNameCol="ROLE_NAME"/> > > and here's the exception: > > Starting service Tomcat-Standalone > Apache Tomcat/4.0 > Catalina.start: LifecycleException: Exception opening database connection: > java.sql.SQLException: interbase.interclient.Driver > LifecycleException: Exception opening database connection: > java.sql.SQLException: interbase.interclient.Driver > at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:615) > at > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108) > at > org.apache.catalina.core.StandardEngine.start(StandardEngine.java:307) > at > org.apache.catalina.core.StandardService.start(StandardService.java:388) > at > org.apache.catalina.core.StandardServer.start(StandardServer.java:505) > at org.apache.catalina.startup.Catalina.start(Catalina.java:776) > at org.apache.catalina.startup.Catalina.execute(Catalina.java:681) > at org.apache.catalina.startup.Catalina.process(Catalina.java:179) > at java.lang.reflect.Method.invoke(Native Method) > at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:218) > > Any ideas ? > > Thanks > > Diego > > ----- Original Message ----- > From: "Michael Weissenbacher" <[EMAIL PROTECTED]> > To: "'Tomcat Users List'" <[EMAIL PROTECTED]> > Sent: Tuesday, December 18, 2001 10:30 PM > Subject: RE: JNDIRealm and Interbase > > > > beware of interclient 2.0, it has some serious memory leak. i advice you > to > > you firebird 1.0.0 rc1 instead of interbase6 open source, it has fixed > many > > bugs of the original borland open source version. look at > > http://firebird.sourceforge.net/ where you can also get interclient 2.01 > > without the memory leak. > > and it's possible to simply use / instead of \\ for the connection url in > > winnt. > > > > michael > > > > -----Original Message----- > > From: Guido Medina [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, December 18, 2001 10:13 PM > > To: 'Tomcat Users List' > > Subject: RE: JNDIRealm and Interbase > > > > > > Yes, it is a Java String problem, remember (again) that tomcat is made in > > java and a JVM is running, so instead of put "\" you MUST put "\\", that's > > it. > > > > Guido > > > > -----Original Message----- > > From: Diego Novati [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, December 18, 2001 5:13 PM > > To: Tomcat Users List > > Subject: JNDIRealm and Interbase > > > > > > Hi, > > I need to use Interbase 6.0 OpenEdition with JNDIRealm. > > Using InterClient 1.6 Tomcat start but throws an Exception during the > > Authentication; using InterClient 2.0 I'm not able to start Tomcat. Is > there > > anyone who is able to use Interbase ? > > > > Tomcat 4.0.1 > > Interbase 6.0 > > InterClient 1.6/InterClient 2.0 > > > > server.xml: > > .... > > <Realm className="org.apache.catalina.realm.JDBCRealm" > > driverName="interbase.interclient.Driver" > > connectionName="SYSDBA" > > connectionPassword="masterkey" > > connectionURL="jdbc:interbase://localhost/C:\Program > > Files\Apache Group\Tomcat 4.0\DBUsers\DBUSERS.GDB" > > userTable="USERS" userNameCol="USER_NAME" > > userCredCol="USER_PASS" > > userRoleTable="USER_ROLES" roleNameCol="ROLE_NAME"/> > > .... > > > > Interbase: > > > > CREATE TABLE "USERS" > > ( > > "USER_NAME" VARCHAR(15) NOT NULL, > > "USER_PASS" VARCHAR(15) NOT NULL, > > CONSTRAINT "USERSPRIMARYKEY" PRIMARY KEY ("USER_NAME") > > ); > > > > CREATE TABLE "USER_ROLES" > > ( > > "USER_NAME" VARCHAR(15) NOT NULL, > > "ROLE_NAME" VARCHAR(15) NOT NULL, > > CONSTRAINT "USER_ROLESPRIMARYKEY" PRIMARY KEY ("USER_NAME", "ROLE_NAME") > > ); > > > > Can you help me ? > > > > Thanks > > > > Diego Novati > > > > > > -- > > To unsubscribe: <mailto:[EMAIL PROTECTED]> > > For additional commands: <mailto:[EMAIL PROTECTED]> > > Troubles with the list: <mailto:[EMAIL PROTECTED]> > > > > -- > > To unsubscribe: <mailto:[EMAIL PROTECTED]> > > For additional commands: <mailto:[EMAIL PROTECTED]> > > Troubles with the list: <mailto:[EMAIL PROTECTED]> > > > > > -- > To unsubscribe: <mailto:[EMAIL PROTECTED]> > For additional commands: <mailto:[EMAIL PROTECTED]> > Troubles with the list: <mailto:[EMAIL PROTECTED]> > -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]> -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
