I have tried all I can to setup Netbeans/Tomcat to use
postgre for my user auth via J_security_check by
talking with my Postgre DB....can anyone review the
following files and let me know if I have done
anything wrong. I verified I can connect via a JSP
and return a result. But I cant get the Auth to work.
Here is what I used that works to talk to the DB:
<%
Class.forName("org.postgresql.Driver");
String url = "jdbc:postgresql://localhost:5432/landt";
Connection con = DriverManager.getConnection(url,
"postgres", "postgres");
Statement stmt =
con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);
ResultSet srs = stmt.executeQuery("SELECT username
FROM users");
while (srs.next()) {
String name = srs.getString("username");
out.println(name);
}
%>
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>
index.jsp
</welcome-file>
</welcome-file-list>
<security-constraint>
<display-name>TenantConstraint</display-name>
<web-resource-collection>
<web-resource-name>tenant</web-resource-name>
<description>Tenant</description>
<url-pattern>/secureTenant/*</url-pattern>
<http-method>GET</http-method>
<http-method>POST</http-method>
<http-method>HEAD</http-method>
<http-method>PUT</http-method>
<http-method>OPTIONS</http-method>
<http-method>TRACE</http-method>
<http-method>DELETE</http-method>
</web-resource-collection>
<auth-constraint>
<description/>
<role-name>tenant</role-name>
</auth-constraint>
</security-constraint>
<security-constraint>
<display-name>LandlordConstraint</display-name>
<web-resource-collection>
<web-resource-name>landlord</web-resource-name>
<description>Landlord</description>
<url-pattern>/secureLandlord/*</url-pattern>
<http-method>GET</http-method>
<http-method>POST</http-method>
<http-method>HEAD</http-method>
<http-method>PUT</http-method>
<http-method>OPTIONS</http-method>
<http-method>TRACE</http-method>
<http-method>DELETE</http-method>
</web-resource-collection>
<auth-constraint>
<description/>
<role-name>landlord</role-name>
</auth-constraint>
</security-constraint>
<login-config>
<auth-method>FORM</auth-method>
<Realm
className="org.apache.catalina.realm.JDBCRealm"
connectionName="postgres"
connectionPassword="postgres"
connectionURL="jdbc:postgresql://localhost:5432/landt"
debug="99" driverName="org.postgresql.Driver"
roleNameCol="rolename" userCredCol="password"
userNameCol="username" userRoleTable="user_roles"
userTable="users"/>
<form-login-config>
<form-login-page>/login.jsp</form-login-page>
<form-error-page>/error.html</form-error-page>
</form-login-config>
</login-config>
<security-role>
<description>For Tenants</description>
<role-name>tenant</role-name>
</security-role>
<security-role>
<description>For Landlords</description>
<role-name>landlord</role-name>
</security-role>
</web-app>
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
