Re: AW: Question configurung JBDCRealm (Tomcat 5.5.9)

2005-12-21 Thread andy gordon
Peter, Have you tried the following? I placed arrows pointing to my suggestions. debug="99" driverName="org.postgresql.Driver" connectionURL="jdbc:postgresql://localhost:5432/ testwebapp?user=login&password=pwd" userTable="users" userNameCol="login" userCredCol="password" userR

AW: Question configurung JBDCRealm (Tomcat 5.5.9)

2005-12-21 Thread Peter . Zoche
Hi andy! As in the HOW-TO described you need two tables, one table 'users' that holds the username and the password, and one table that holds the username and the roles the user is given (it is a mapping from users to roles). My database has also two tables, but the first table holds username, pas