docs/examples/roller.conf

<web-app id='/roller'>

    <app-dir>C:/sourceforge/roller/build/roller</app-dir>
 
	<resource-ref>
	  <res-ref-name>jdbc/rollerdb</res-ref-name>
	  <res-type>javax.sql.DataSource</res-type>
	  <init-param driver-name="org.gjt.mm.mysql.Driver"/>
	  <init-param url="jdbc:mysql://localhost/roller?autoReconnect=true"/>
	  <init-param user="roller" />
	  <init-param password="tiger" />
	</resource-ref>
<!--
	<resource-ref>
		<res-ref-name>mail/Session</res-ref-name>
		<res-type>javax.mail.Session</res-type>
		<init-param mail.transport.protocol='smtp' />
		<init-param mail.host='localhost' />
		<init-param mail.user='FranklyIdontGiveaDamn' />
	</resource-ref>
-->
	<login-config>
		<!-- Resin-specific JdbcAuthenticator -->
		<authenticator id='com.caucho.http.security.JdbcAuthenticator'>
		  <pool-name>rollerdb</pool-name>
		  <password-query>
			SELECT passphrase FROM rolleruser u, website w WHERE username=? and u.id = w.userid and w.isenabled = 1
		  </password-query>
		  <cookie-auth-query>
			SELECT username FROM rolleruser WHERE cookie=?
		  </cookie-auth-query>
		  <cookie-auth-update>
			UPDATE rolleruser u, website w SET cookie=? WHERE username=? and u.id = w.userid and w.isenabled = 1
		  </cookie-auth-update>
		  <role-query>
			SELECT rolename FROM userrole r, rolleruser u, website w 
			WHERE r.username=? and r.userid = u.id and u.id = w.userid and w.isenabled = 1
		  </role-query>
		</authenticator>

		<auth-method>FORM</auth-method>
		<form-login-config>
			<form-login-page>/login.jsp</form-login-page>
			<form-error-page>/loginerror.jsp</form-error-page>
		</form-login-config>
	</login-config>
</web-app>