This is version . It is not the current version, and thus it cannot be edited.
[Back to current version]   [Restore this version]

I created a JDBC front end for the 2.1 authentication system which simply retrieves all neccesary information from a configurable JDBC database. Most of the SQL statements are configurable as well. This requires a future version of 2.1 where two methods in WikiDatabase are changed to protected instead of private. The jar file contains both source code and compiled classes.

That would be 2.1.89. Can you please check it's okay? --JanneJalkanen
Silly me, it needs also m_principals to be protected. --Killer

Setup instructions#

Place the jar file into WEB-INF/lib. Add the following lines to your (modified to your configuration, of course).
jspwiki.authenticator = net.killeri.jspwiki.JDBCWikiAuthenticator
jspwiki.authenticator.jdbcclass = org.postgresql.Driver
jspwiki.authenticator.jdbcurl = jdbc:postgresql:jspwiki?user=fuubar
jspwiki.authenticator.selectsql = select user_id from person where user_id=? and password=?
jspwiki.userdatabase = net.killeri.jspwiki.JDBCUserDatabase
jspwiki.userdatabase.jdbcclass = org.postgresql.Driver
jspwiki.userdatabase.jdbcurl = jdbc:postgresql:jspwiki?user=fuubar
jspwiki.authorizer = PageAuthorizer

For authorization you need to have a table "role" with fields "role_name" and "user_id" in your database. This too will be configurable in later versions.

Database administration#

The jar file includes a couple of plugins to help with the database administration, namely ChangePasswordPlugin, GroupAddPlugin, GroupConnectPlugin, GroupDisconnectPlugin, and UserAddPlugin. All of these require the WikiFormsPlugin fom Ebu.

Hello, nice site look this: <a href=>crossing great in lake mall michigan</a> <a href=>keystone at the crossing mall</a> <a href=>texas hall of fame</a> <a href=>crossing line zero</a> <a href=>business consulting enterprise montreal object</a> <a href=>falling make myspace object</a> <a href=>trains railroad crossing</a>

End ^) See you

--Hillary, 10-Sep-2006

Add new attachment

Only authorized users are allowed to upload new attachments.

List of attachments

Kind Attachment Name Size Version Date Modified Author Change note
jdbcauthenticator.jar 34.2 kB 2 02-Dec-2003 10:47 Killer
« This particular version was published on 10-Sep-2006 20:01 by Hillary.