jdbc/rollerdb
com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource
jdbc:mysql://localhost:3306/roller?autoReconnect=true
roller
tiger
8
100
30s
smtp
localhost
mail-user
*******
%h %l %u %t "%r" %>s %b "%{Referer}i" "%{User-Agent}i"
1D
jdbc/rollerdb
SELECT passphrase FROM rolleruser WHERE username=? and userenabled=1
SELECT username FROM usercookie WHERE cookie=?
UPDATE usercookie SET cookieid=? WHERE username=?
SELECT rolename FROM userrole r, rolleruser u
WHERE r.username=? and r.userid = u.id and u.userenabled=1
none
FORM
/login.jsp
/loginerror.jsp