Hi,
Trying to use JRun JDBC login module to integrate JRun security with DB2 tables.
We have web.xml configured, using form login and there are two kinds of users -
basicuser and admin. This works fine with JRun default XMLLogin Module. We also have a
Data Source - RXDS set up in JMC. However, the user I created through database table
wouldn't be able to login to our application.
- auth.config:
defaultUser
{
jrun.security.JDBCLoginModule requisite userNameColumn="login"
dataSourceJNDIName="RXDS" tableName="users" mode="USER" passwordColumn="password";
};
defaultRole
{
jrun.security.JDBCLoginModule requisite roleColumn="rolename" userNameColumn="login"
tableName="roles" dataSourceJNDIName="RXDS" mode="ROLE";
};
- uses.sql
CREATE TABLE users(
-- login: Login id of the gui user
login char(8) not null CONSTRAINT usersC_UCNT UNIQUE,
-- name: Full name of the user
name char(128) not null,
-- password:
password char(8) not null,
) ;
-roles.sql
CREATE TABLE roles(
-- login: Login id of the gui user
login char(8) not null,
-- rolename:
rolename char(12) not null
) ;
I have a user called 'admin' in users table, and it's role is 'basicuser' and 'admin'.
However when I log in as 'admin', the browser will bring me to 403 error page.
Thanks,
YZ
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
