aspose file tools*
The moose likes Tomcat and the fly likes Tomcat: how to admin users / group / roles into SQL database ?? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Products » Tomcat
Bookmark "Tomcat: how to admin users / group / roles into SQL database ??" Watch "Tomcat: how to admin users / group / roles into SQL database ??" New topic
Author

Tomcat: how to admin users / group / roles into SQL database ??

aders thomas
Greenhorn

Joined: Nov 19, 2001
Posts: 7
Hi - I am building a user-group-role database on SQL server, and using Tomcat JDBCRealm to authenticate user logins to my webapp against this database (easy to set up - works well).
I would now also like to use the Tomcat admin client (in V4.1 and V5) to create and edit the users / groups / roles stored in this SQL server database - ie. to replace the tomcat-users.xml file which is managed by the admin client using a MemoryUserDatabase.
Has anyone tried anything like this, if so ...
1. Are there any "JDBC" or "SQL" UserDatabase classes I can use to do this (rather than MemoryUserDatabase).
2. If not, and I wrote my own implementation, what else would I need to configure to plug it into Tomcat ?

Thanks for any feedback ...
Mike Curwen
Ranch Hand

Joined: Feb 20, 2001
Posts: 3695

I hardly ever look at the admin application, but wouldn't it just involve switching its web.xml file to use a JDBCRealm instead of a MemoryRealm ?

No coding required! Use JDBCRealm classes that Tomcat gives you, and that you've already used for your own application.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Tomcat: how to admin users / group / roles into SQL database ??
 
Similar Threads
Authenticating Users
What is resource-ref for?
Update of Tomcat-users.xml by Tomcat Administration Tool
Requesting help with Tomcat admin webapp
Tomcat 7.0 Manager's Username and Password