Apache-AJP-Tomcat-JDBC realm

[baden]

I am testing this out on my local system, not on a .com.

Configured on Windows2K, Apache-AJP-Tomcat

Doing:

http://profitma-tuobr3:8080/manager/list

pops up the authentication - userid/pw window, and works fine - connects with db.

When doing

http://profitma-tuobr3/manager/list,

the auth. window pops up, but I can't authenticate! Looks like it's not talking to the db.

I got this working with WARP - that uses an <engine> in servlet.xml. Can't do this with AJP.



<!-- Because this Realm is here, an instance will be shared globally -->
<!--

=============== COMMENTED OUT TO MAKE USE JDBC/POSTGRESQL REALM ===================

<Realm className=&quot;org.apache.catalina.realm.MemoryRealm&quot; />
-->

<!-- =============================================================== -->
<!-- === JDBC realm using postgresql === -->
<!-- =============================================================== -->

<Realm

className=&quot;org.apache.catalina.realm.JDBCRealm&quot;
debug=&quot;99&quot;
driverName=&quot;org.postgresql.Driver&quot;

connectionName=&quot;postgres&quot;
connectionPassword=&quot;&quot;

connectionURL=&quot;jdbcostgresql://localhost:5432/tomcatusers&quot;
userTable=&quot;users&quot;
userNameCol=&quot;username&quot;
userCredCol=&quot;password&quot;
userRoleTable=&quot;userroles&quot;
roleNameCol=&quot;rolename&quot;/>