How to use DataSourceRealm?

[Bojan Tomic]

I'm trying to build an access control mechanism for a JSF web application on Tomcat 6. Since I already have a database with users, I was going for a DataSourceRealm.
First, I've created another table called user_roles that has only two columns: useraname and role.
Then, I've added the following rows:

Table: [B]users[/B]
 
id   | username   | password
----------------------------
1    | usertest   | usertest
2    | admintest  | admintest
 
Table: [B]user_roles[/B]
 
id   | username  | role
----------------------------
1    | usertest  | user
2    | admintest | admin
 

Next, I edited conf/server.xml to contain this:

<Context path="/Test" reloadable="true" crossContext="true">
            <Resource name="jdbc/mysql" auth="Container" type="javax.sql.DataSource" username="root" password=""
                       driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/test" maxActive="8" maxIdle="4"/>
      <Realm className="org.apache.catalina.realm.DataSourceRealm" dataSourceName="jdbc/mysql"
    roleNameCol="role" userCredCol="password" userNameCol="username" userRoleTable="user_roles" userTable="users"/>
</Context>

and I edited my web.xml to contain this:

 
        <security-constraint>
<web-resource-collection>
<web-resource-name>Users Only</web-resource-name>
<url-pattern>/*</url-pattern>
</web-resource-collection>
<auth-constraint>
<role-name>user</role-name>
</auth-constraint>
</security-constraint>
<login-config>
<auth-method>BASIC</auth-method>
</login-config>
<resource-ref>
<res-ref-name>jdbc/mysql</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>

No exceptions are raised during Tomcat startup. Now, when I try to access the app through http://localhost:8080/Test/, the login dialog pops up but no matter what I type in - nothing happens. usertest/usertest doesn't work.
I tried shuting down MySQL to see if an exception would be raised when I attempt to login, but everything seems the same. So, it must something in my server.xml is wrongly configured but I don't know what.
Please guys, give it a shot. I'd be very, very grateful.
[ November 19, 2008: Message edited by: Veggen Skrikk ]

[Paul Clapham]

"Veggen Skrikk", please check your private messages for an important administrative matter.

[Bojan Tomic]

I tried this exact same configuration with JDBCRealm, and it works fine, so the error must be in the DataSource configurations, but I still can't discover it.

I hope this helps...

[Sudharsan Govindarajan]

I face the same problem now. JDBCRealm works, but DataSourceRealm not.
@Bojan, did you happen to fix it?

Thanks!

[Sudharsan Govindarajan]

Figured it out. I had to set

localDataSource="true"

in the Realm definition

[Bojan Tomic]

I haven't fixed it. I'll try your solution.
Thanks for posting it.