Did you set up your auth.config and users and roles using the JMC or did you manually
edit the files? I found it worked best using the JMC. Also my first attempt caused
problems when I tried using database reserved words such as user as one of my column
names. One thing I noticed is that the order of parameters in defaultUser are
different in yours than mine. Not sure if that should matter. Here is my auth.config
using a SQLServer datasource:
defaultUser
{
jrun.security.JDBCLoginModule requisite userNameColumn="username" tableName="jdbcuser"
dataSourceJNDIName="SQLLOCAL" mode="USER" passwordColumn="password";
};
defaultRole
{
jrun.security.JDBCLoginModule requisite roleColumn="role" userNameColumn="username"
tableName="jdbcrole" dataSourceJNDIName="SQLLOCAL" mode="ROLE";
};
HTH.
Ted Zimmerman
-----Original Message-----
From: Zhang, Yuying [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 20, 2002 2:55 PM
To: JRun-Talk
Subject: Using JRun JDBC login module
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
