You need to change the context.xml syntax to use something like the following:
<Context path="/roller" docBase="roller" debug="99" reloadable="false"
antiJARLocking="true" antiResourceLocking="false">
<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
driverName="org.postgresql.Driver"
connectionURL="jdbc:postgresql://localhost/roller"
connectionName="postgres" connectionPassword="postgres"
userTable="rolleruser" userNameCol="username"
userCredCol="passphrase"
userRoleTable="userrole" roleNameCol="rolename" />
<Resource name="jdbc/rollerdb" auth="Container" type="javax.sql.DataSource"
maxActive="20" maxIdle="10" maxWait="100"
driverClassName="org.postgresql.Driver"
username="postgres" password="postgres"
url="jdbc:postgresql://localhost/roller"/>
<Resource name="mail/Session" auth="Container" type="javax.mail.Session"
mail.smtp.host="localhost" />
</Context>
On 10/17/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> Installed Roller 1.2 with Tomcat 5.5 and MySQL 4.1.
>
> Following the Installation Guide
> (http://www.rollerweblogger.org/wiki/Wiki.jsp?page=InstallationGuide), got
> to the part about editing Tomcat's server.xml
>
> Step 5 says (for Tomcat 5.5) to add this (below) to the server.xml and
> replace scott / tiger with my own username password. Did this.
>
> Problem is, with this section, Tomcat service won't start; Windows
> complains "The Apache Tomcat service on Local Computer started and then
> stopped. Some services stop automatically if they have no work to do, for
> example, the Performance Logs and Alerts service."
>
> Remove everything between <context> and </context> and Tomcat starts fine.
>
> Any help is *greatly* appreciated!
>
> Stephen
>
> >>>
>
> <Context path="/roller" docBase="roller" debug="0">
>
> <Realm className="org.apache.catalina.realm.JDBCRealm"
> driverName="com.mysql.jdbc.Driver"
> connectionURL=
> "jdbc:mysql://localhost:3306/roller?autoReconnect=true&
> useUnicode=true&characterEncoding=utf-8&mysqlEncoding=utf8"
> connectionName="scott"
> connectionPassword="tiger"
> userTable="rolleruser"
> userNameCol="username"
> userCredCol="passphrase"
> userRoleTable="userrole"
> roleNameCol="rolename" debug="0" />
>
> <Resource name="jdbc/rollerdb" auth="Container" type="javax.sql.DataSource"
> driverClassName="com.mysql.jdbc.Driver"
>
> url="jdbc:mysql://localhost:3306/roller?autoReconnect=true&useUnicode=true&characterEncoding=utf-8&mysqlEncoding=utf8"
> username="scott"
> password="tiger"
> maxActive="20"
> maxIdle="3"
> removeAbandoned="true"
> maxWait="3000" />
>
> <!--
> To enable email notification of comments: uncomment the resouce below,
> set your mailhost, and make sure you have mail.jar and activation.jar
> in <tomcat>/common/lib.
> -->
> <!--
> <Resource name="mail/Session" auth="Container" type="javax.mail.Session"
> mail.smtp.host="mailhost.example.com" />
> -->
>
> </Context>
>
