Realm e datasource
Stefano T
Praticamente se uso una connessione diretta al db mi funziona tutto
ok. se invece uso la datasource mi da questo errore:
27-lug-2007 18.37.51 org.apache.catalina.realm.DataSourceRealm open
GRAVE: Exception performing authentication
javax.naming.NameNotFoundException: Name jdbc is not bound in this
Context
at org.apache.naming.NamingContext.lookup(NamingContext.java:
769)
at org.apache.naming.NamingContext.lookup(NamingContext.java:
152)
at
org.apache.catalina.realm.DataSourceRealm.open(DataSourceRealm.java:
401)
at
org.apache.catalina.realm.DataSourceRealm.authenticate(DataSourceRealm.java:
282)
at
org.apache.catalina.authenticator.FormAuthenticator.authenticate(FormAuthenticator.java:
257)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:
416)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:
126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:
105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:
107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:
148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:
869)
at org.apache.coyote.http11.Http11BaseProtocol
$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:
664)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:
527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:
80)
at org.apache.tomcat.util.threads.ThreadPool
$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
questo è il context.xml che da il problema
<?xml version="1.0" encoding="UTF-8"?>
<Context path="/realm">
<Resource auth="Container"
driverClassName="org.postgresql.Driver"
maxActive="20"
maxIdle="10"
maxWait="-1"
name="jdbc/postgres"
password="postgres"
type="javax.sql.DataSource"
url="jdbc:postgresql://localhost:5432/qo_db"
username="postgres"/>
<Realm className="org.apache.catalina.realm.DataSourceRealm"
dataSourceName="jdbc/postgres"
debug="99"
roleNameCol="role_name"
userCredCol="user_pass"
userNameCol="user_name"
userRoleTable="user_roles"
userTable="users"/>
</Context>
questo che invece funziona.
<?xml version="1.0" encoding="UTF-8"?>
<Context path="/realm">
<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
driverName="org.postgresql.Driver"
connectionURL="jdbc:postgresql://localhost:5432/qo_db"
connectionName="postgres"
connectionPassword="postgres"
userTable="users"
userNameCol="user_name"
userCredCol="user_pass"
userRoleTable="user_roles"
roleNameCol="role_name"/>
</Context>
il web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee
http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
<session-config>
<session-timeout>
30
</session-timeout>
</session-config>
<welcome-file-list>
<welcome-file>user.jsp</welcome-file>
</welcome-file-list>
<security-constraint>
<web-resource-collection>
<web-resource-name>Public Area</web-resource-name>
<!-- Define the context-relative URL(s) to be protected --
>
<url-pattern>/index.jsp</url-pattern>
<url-pattern>/login.jsp</url-pattern>
</web-resource-collection>
</security-constraint>
<security-constraint>
<web-resource-collection>
<web-resource-name>Protected Area</web-resource-name>
<!-- Define the context-relative URL(s) to be protected --
>
<url-pattern>/user.jsp</url-pattern>
</web-resource-collection>
<auth-constraint>
<!-- Anyone with one of the listed roles may access this
area -->
<role-name>User</role-name>
<role-name>Admin</role-name>
</auth-constraint>
</security-constraint>
<!-- uses form-based authentication -->
<login-config>
<auth-method>FORM</auth-method>
<form-login-config>
<form-login-page>/login.jsp</form-login-page>
<form-error-page>/fail_login.html</form-error-page>
</form-login-config>
</login-config>
<!-- Security roles referenced by this web application -->
<security-role>
<role-name>User</role-name>
</security-role>
<security-role>
<role-name>Admin</role-name>
</security-role>
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/postgres</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>
il db e la jsp sono ok sennò non funzionerebbe anche nell'altro caso..
Stefano T
megadix
> nessuno?
Vabbuo', visto che insisti...
Sulla documentazione ufficiale:
http://tomcat.apache.org/tomcat-5.5-doc/config/realm.html
dove parla di DataSourceRealm, appunto, c'è una sezione dedicata agli
attributi; quello che ti serve dovrebbe essere "localDataSource".
Facci sapere com'è andata, eh :)