You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Richard Sayre <ri...@gmail.com> on 2007/06/13 19:42:03 UTC
Tomcat 6, SQL Server 2005 JDBC Realm not working
I have a web app that connects to my SQL Server 2005 Database with no
trouble using this code:
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
con =
DriverManager.getConnection("jdbc:sqlserver://server-2006;databaseName=v362;user=user;password=dbase");
My application runs fine and I can see data from the database.
Now when I try to set up a Realm to do Database authentication I get an error:
<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
connectionURL="jdbc:sqlserver://server-2006;databaseName=v362;userName=user;password=dbase"
connectionName="user"
connectionPassword="dbase"
digest="SHA"
userTable="PPMUser" userNameCol="UserName"
userCredCol="UserPassword"
userRoleTable="PPMUser" roleNameCol="RoleTomcat" />
Exception:
13-Jun-2007 3:56:00 PM org.apache.catalina.realm.JDBCRealm authenticate
SEVERE: Exception performing authentication
java.sql.SQLException: com.microsoft.sqlserver.jdbc.SQLServerDriver
at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:691)
at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:346)
at org.apache.catalina.authenticator.BasicAuthenticator.authenticate(BasicAuthenticator.java:181)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:491)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Unknown Source)
The strange thing is, if I set up a DSN under Windows and use the Sun
ODBC driver the authentication realm works:
<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
driverName="sun.jdbc.odbc.JdbcOdbcDriver"
connectionURL="jdbc:odbc:v362"
connectionName="user"
connectionPassword="dbase"
digest="SHA"
userTable="User" userNameCol="UserName" userCredCol="UserPassword"
userRoleTable="User" roleNameCol="RoleTomcat" />
Does any one have this type of authentication working with MS SQL
Server 2005 JDBC driver under Tomcat 6?
Thank you,
Rich
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Tomcat 6, SQL Server 2005 JDBC Realm not working
Posted by Richard Sayre <ri...@gmail.com>.
It turns out I had to RTFM.
"Quick Start:
3. Place a copy of the JDBC driver you will be using inside the
$CATALINA_HOME/lib directory. Note that only JAR files are
recognized!"
I only had it in my Web App lib folder
On 6/14/07, Richard Sayre <ri...@gmail.com> wrote:
> I just tried the exact same thing with the jTDS driver and I got the same error:
>
> <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
> driverName="net.sourceforge.jtds.jdbc.Driver"
> connectionURL="jdbc:jtds:sqlserver://server-2006/v362;user=user;password=dbase"
> connectionName="user"
> connectionPassword="dbase"
> digest="SHA"
> userTable="PPMUser" userNameCol="UserName"
> userCredCol="UserPassword"
> userRoleTable="PPMUser" roleNameCol="RoleTomcat" />
>
> 14-Jun-2007 10:49:02 AM org.apache.catalina.realm.JDBCRealm authenticate
> SEVERE: Exception performing authentication
> java.sql.SQLException: net.sourceforge.jtds.jdbc.Driver
> at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:691)
> at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:346)
> at org.apache.catalina.authenticator.BasicAuthenticator.authenticate(BasicAuthenticator.java:181)
> at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:491)
> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)
> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581)
> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
> at java.lang.Thread.run(Unknown Source)
>
>
> Did anything change in Tomcat 6 for setting up JDBC Realms? I am
> putting this in the server xml.
>
> On 6/13/07, Richard Sayre <ri...@gmail.com> wrote:
> > I have a web app that connects to my SQL Server 2005 Database with no
> > trouble using this code:
> >
> > Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
> > con =
> > DriverManager.getConnection("jdbc:sqlserver://server-2006;databaseName=v362;user=user;password=dbase");
> >
> > My application runs fine and I can see data from the database.
> >
> > Now when I try to set up a Realm to do Database authentication I get an error:
> >
> > <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
> > driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
> > connectionURL="jdbc:sqlserver://server-2006;databaseName=v362;userName=user;password=dbase"
> > connectionName="user"
> > connectionPassword="dbase"
> > digest="SHA"
> > userTable="PPMUser" userNameCol="UserName"
> > userCredCol="UserPassword"
> > userRoleTable="PPMUser" roleNameCol="RoleTomcat" />
> >
> > Exception:
> >
> > 13-Jun-2007 3:56:00 PM org.apache.catalina.realm.JDBCRealm authenticate
> > SEVERE: Exception performing authentication
> > java.sql.SQLException: com.microsoft.sqlserver.jdbc.SQLServerDriver
> > at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:691)
> > at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:346)
> > at org.apache.catalina.authenticator.BasicAuthenticator.authenticate(BasicAuthenticator.java:181)
> > at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:491)
> > at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
> > at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
> > at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> > at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)
> > at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
> > at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581)
> > at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
> > at java.lang.Thread.run(Unknown Source)
> >
> > The strange thing is, if I set up a DSN under Windows and use the Sun
> > ODBC driver the authentication realm works:
> >
> > <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
> > driverName="sun.jdbc.odbc.JdbcOdbcDriver"
> > connectionURL="jdbc:odbc:v362"
> > connectionName="user"
> > connectionPassword="dbase"
> > digest="SHA"
> > userTable="User" userNameCol="UserName" userCredCol="UserPassword"
> > userRoleTable="User" roleNameCol="RoleTomcat" />
> >
> >
> > Does any one have this type of authentication working with MS SQL
> > Server 2005 JDBC driver under Tomcat 6?
> >
> > Thank you,
> >
> > Rich
> >
>
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Tomcat 6, SQL Server 2005 JDBC Realm not working
Posted by Richard Sayre <ri...@gmail.com>.
I just tried the exact same thing with the jTDS driver and I got the same error:
<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
driverName="net.sourceforge.jtds.jdbc.Driver"
connectionURL="jdbc:jtds:sqlserver://server-2006/v362;user=user;password=dbase"
connectionName="user"
connectionPassword="dbase"
digest="SHA"
userTable="PPMUser" userNameCol="UserName"
userCredCol="UserPassword"
userRoleTable="PPMUser" roleNameCol="RoleTomcat" />
14-Jun-2007 10:49:02 AM org.apache.catalina.realm.JDBCRealm authenticate
SEVERE: Exception performing authentication
java.sql.SQLException: net.sourceforge.jtds.jdbc.Driver
at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:691)
at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:346)
at org.apache.catalina.authenticator.BasicAuthenticator.authenticate(BasicAuthenticator.java:181)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:491)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Unknown Source)
Did anything change in Tomcat 6 for setting up JDBC Realms? I am
putting this in the server xml.
On 6/13/07, Richard Sayre <ri...@gmail.com> wrote:
> I have a web app that connects to my SQL Server 2005 Database with no
> trouble using this code:
>
> Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
> con =
> DriverManager.getConnection("jdbc:sqlserver://server-2006;databaseName=v362;user=user;password=dbase");
>
> My application runs fine and I can see data from the database.
>
> Now when I try to set up a Realm to do Database authentication I get an error:
>
> <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
> driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
> connectionURL="jdbc:sqlserver://server-2006;databaseName=v362;userName=user;password=dbase"
> connectionName="user"
> connectionPassword="dbase"
> digest="SHA"
> userTable="PPMUser" userNameCol="UserName"
> userCredCol="UserPassword"
> userRoleTable="PPMUser" roleNameCol="RoleTomcat" />
>
> Exception:
>
> 13-Jun-2007 3:56:00 PM org.apache.catalina.realm.JDBCRealm authenticate
> SEVERE: Exception performing authentication
> java.sql.SQLException: com.microsoft.sqlserver.jdbc.SQLServerDriver
> at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:691)
> at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:346)
> at org.apache.catalina.authenticator.BasicAuthenticator.authenticate(BasicAuthenticator.java:181)
> at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:491)
> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)
> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581)
> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
> at java.lang.Thread.run(Unknown Source)
>
> The strange thing is, if I set up a DSN under Windows and use the Sun
> ODBC driver the authentication realm works:
>
> <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
> driverName="sun.jdbc.odbc.JdbcOdbcDriver"
> connectionURL="jdbc:odbc:v362"
> connectionName="user"
> connectionPassword="dbase"
> digest="SHA"
> userTable="User" userNameCol="UserName" userCredCol="UserPassword"
> userRoleTable="User" roleNameCol="RoleTomcat" />
>
>
> Does any one have this type of authentication working with MS SQL
> Server 2005 JDBC driver under Tomcat 6?
>
> Thank you,
>
> Rich
>
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org