RE: JDBC Realm not working with NT service

2002-01-02 Thread Guido Medina

copy the jsse 1.0.2 jar files inside C:\Program Files\JavaSoft\JRE\lib\Ext

that's it...

-Original Message-
From: gman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 02, 2002 1:16 PM
To: [EMAIL PROTECTED]
Subject: JDBC Realm not working with NT service


hello,

my tomcat 3.3 application works fine as a stand-alone
application using JDBC Realm authentication. When i
run it as an NT service using the supplied
jk_nt_service tool.. the authentication fails with the
message below. For some reason it is not sending the
user to the database, although it does correctly get
the user name in the error message (not last line
below). Anyone else have this problem?

thanks

Gareth

=
2002-01-02 11:28:56 - JDBCRealm: There was an
SQLException while in checkConnection: {0} -
java.sql.SQLException: [Microsoft][ODBC SQL Server
Driver][SQL Server]Login failed for user '\'.
at
sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6031)
at
sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6188)
at
sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:2458)
at
sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:320)
at
sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:163)
at
java.sql.DriverManager.getConnection(DriverManager.java:517)
at
java.sql.DriverManager.getConnection(DriverManager.java:199)
at
org.apache.tomcat.modules.aaa.JDBCRealm.checkConnection(Unknown
Source)
at
org.apache.tomcat.modules.aaa.JDBCRealm.getCredentials(Unknown
Source)
at
org.apache.tomcat.modules.aaa.RealmBase.checkPassword(Unknown
Source)
at
org.apache.tomcat.modules.aaa.RealmBase.authenticate(Unknown
Source)
at
org.apache.tomcat.core.Request.getRemoteUser(Unknown
Source)
at
org.apache.tomcat.modules.aaa.AccessInterceptor.authorize(Unknown
Source)
at
org.apache.tomcat.core.ContextManager.internalService(Unknown
Source)
at
org.apache.tomcat.core.ContextManager.service(Unknown
Source)
at
org.apache.tomcat.modules.server.Http10Interceptor.processConnection(Unknown
Source)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(Unknown
Source)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(Unknown
Source)
at java.lang.Thread.run(Thread.java:484)

2002-01-02 11:28:56 - JDBCRealm: Authentication
unsuccessful for user lloydg

__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com

--
To unsubscribe:   mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]



RE: JDBC Realm not working with NT service

2002-01-02 Thread gman

i tried this, also put them in the jdk/lib that is my
JAVA_HOME, but i get the same problem. Did you run
into the same problem and solve it with that jar?

thanks

G

--- Guido Medina [EMAIL PROTECTED] wrote:
 copy the jsse 1.0.2 jar files inside C:\Program
 Files\JavaSoft\JRE\lib\Ext
 
 that's it...
 
 -Original Message-
 From: gman [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, January 02, 2002 1:16 PM
 To: [EMAIL PROTECTED]
 Subject: JDBC Realm not working with NT service
 
 
 hello,
 
 my tomcat 3.3 application works fine as a
 stand-alone
 application using JDBC Realm authentication. When i
 run it as an NT service using the supplied
 jk_nt_service tool.. the authentication fails with
 the
 message below. For some reason it is not sending the
 user to the database, although it does correctly get
 the user name in the error message (not last line
 below). Anyone else have this problem?
 
 thanks
 
 Gareth
 
 =
 2002-01-02 11:28:56 - JDBCRealm: There was an
 SQLException while in checkConnection: {0} -
 java.sql.SQLException: [Microsoft][ODBC SQL Server
 Driver][SQL Server]Login failed for user '\'.
   at

sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6031)
   at

sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6188)
   at

sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:2458)
   at

sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:320)
   at

sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:163)
   at

java.sql.DriverManager.getConnection(DriverManager.java:517)
   at

java.sql.DriverManager.getConnection(DriverManager.java:199)
   at

org.apache.tomcat.modules.aaa.JDBCRealm.checkConnection(Unknown
 Source)
   at

org.apache.tomcat.modules.aaa.JDBCRealm.getCredentials(Unknown
 Source)
   at

org.apache.tomcat.modules.aaa.RealmBase.checkPassword(Unknown
 Source)
   at

org.apache.tomcat.modules.aaa.RealmBase.authenticate(Unknown
 Source)
   at
 org.apache.tomcat.core.Request.getRemoteUser(Unknown
 Source)
   at

org.apache.tomcat.modules.aaa.AccessInterceptor.authorize(Unknown
 Source)
   at

org.apache.tomcat.core.ContextManager.internalService(Unknown
 Source)
   at

org.apache.tomcat.core.ContextManager.service(Unknown
 Source)
   at

org.apache.tomcat.modules.server.Http10Interceptor.processConnection(Unknown
 Source)
   at

org.apache.tomcat.util.net.TcpWorkerThread.runIt(Unknown
 Source)
   at

org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(Unknown
 Source)
   at java.lang.Thread.run(Thread.java:484)
 
 2002-01-02 11:28:56 - JDBCRealm: Authentication
 unsuccessful for user lloydg
 
 __
 Do You Yahoo!?
 Send your FREE holiday greetings online!
 http://greetings.yahoo.com
 
 --
 To unsubscribe:  
 mailto:[EMAIL PROTECTED]
 For additional commands:
 mailto:[EMAIL PROTECTED]
 Troubles with the list:
 mailto:[EMAIL PROTECTED]
 


__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com

--
To unsubscribe:   mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]




RE: JDBC Realm not working with NT service

2002-01-02 Thread Ignacio J. Ortega

 De: gman [mailto:[EMAIL PROTECTED]]
 Enviado el: miƩrcoles 2 de enero de 2002 18:16

 my tomcat 3.3 application works fine as a stand-alone
 application using JDBC Realm authentication. When i
 run it as an NT service using the supplied
 jk_nt_service tool.. the authentication fails with the
 message below. For some reason it is not sending the

When tomcat runs from command line ( or by double clicking startup.bat
), it uses the logged in user ( it seems your are using same kind of nt
or 2000) as the user for every other access from that program and thus
being able to use all the facilities of the deskop, and particularly the
registry..

Normally a service runs owned by user system that by default is not a
desktop user ( whatever name MS has for this i dont recall), that is
does not have access to every resource in the machine that needs
autentication , such as the registry, or network access..

So the solution is to change the user of the service to anyone with
desktop access, you can try first with Administrator, and later when
you see it working create a dedicated user, with lower rights, for the
task of owning and running tomcat..


Saludos ,
Ignacio J. Ortega



--
To unsubscribe:   mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]




RE: JDBC Realm not working with NT service

2002-01-02 Thread Ignacio J. Ortega

 De: gman [mailto:[EMAIL PROTECTED]]
 Enviado el: miƩrcoles 2 de enero de 2002 18:16

 java.sql.SQLException: [Microsoft][ODBC SQL Server
 Driver][SQL Server]Login failed for user '\'.


Uhh, and you are using the JDBC-ODBC Bridge from microsoft, this not the
best for your hair ;).., try to use a REAL jdbc driver (MS has one
class4 JDBC driver for SQLServer), JDBC-ODBC bridge is not intended to
be used in production apps, it's not thread safe..

Saludos ,
Ignacio J. Ortega


--
To unsubscribe:   mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]