<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1400" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=878573911-18102005><FONT face=Arial color=#0000ff size=2>Hi
Jakob,</FONT></SPAN></DIV>
<DIV><SPAN class=878573911-18102005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=878573911-18102005><FONT face=Arial color=#0000ff size=2>thanks
for the feedback. I've tested the module on Windows with a fresh OpenCms 6.0.2
Installation, without any major issue.</FONT></SPAN></DIV>
<DIV><SPAN class=878573911-18102005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=878573911-18102005><FONT face=Arial color=#0000ff size=2>The
preconditios are:</FONT></SPAN></DIV>
<DIV><SPAN class=878573911-18102005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=878573911-18102005><FONT face=Arial color=#0000ff size=2>1.
Install OpenCms a opencms.war (and not ROOT.war) under
webapps.</FONT></SPAN></DIV>
<DIV><SPAN class=878573911-18102005><FONT face=Arial color=#0000ff size=2>2.
Select opencms as DB-Name during the installation of
opencms.</FONT></SPAN></DIV>
<DIV><SPAN class=878573911-18102005><FONT face=Arial color=#0000ff size=2>3.
control mvncore.xml for the following entries</FONT></SPAN></DIV>
<DIV><SPAN class=878573911-18102005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=878573911-18102005><FONT face=Arial color=#0000ff
size=2><driver_class_name>com.mysql.jdbc.Driver</driver_class_name><BR>
<database_url>jdbc:mysql://localhost/<FONT
color=#ff0000>opencms</FONT>?useUnicode=true&characterEncoding=utf-8</database_url><BR>
<database_user><FONT
color=#ff0000>opencmsuser</FONT></database_user><BR>
<database_password><FONT
color=#ff0000>admin</FONT></database_password></FONT></SPAN></DIV>
<DIV><SPAN class=878573911-18102005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=878573911-18102005><FONT face=Arial color=#0000ff size=2>use
first <FONT color=#ff0000>root</FONT> as opencmsuser with appropriate password,
also:</FONT></SPAN></DIV>
<DIV><SPAN class=878573911-18102005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=878573911-18102005><FONT size=2><FONT face=Arial><FONT
color=#0000ff><database_user></FONT><FONT
color=#ff0000>root</FONT></FONT></FONT><FONT size=2><FONT face=Arial><FONT
color=#0000ff></database_user><BR><database_password></FONT><FONT
color=#ff0000>whatever-secret-password</FONT><FONT
color=#0000ff></database_password></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=878573911-18102005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=878573911-18102005><FONT face=Arial color=#0000ff size=2>(I
guess your problem is here!)</FONT></SPAN></DIV>
<DIV><SPAN class=878573911-18102005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=878573911-18102005><FONT face=Arial color=#0000ff size=2>4. the
<FONT color=#ff0000>mysql-connector-java-3.0.15-ga-bin.jar</FONT> must be under
<FONT color=#ff0000>webapps\opencms\WEB-INF\lib</FONT></FONT></SPAN></DIV>
<DIV><SPAN class=878573911-18102005><FONT face=Arial color=#0000ff size=2>at
least it works for me, if you are using MySQL 4.1 on windows, download the
latest mysql jdbc driver (I think
mysql-connector-java-3.0.16-ga-bin.jar)</FONT></SPAN></DIV>
<DIV><SPAN class=878573911-18102005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=878573911-18102005><FONT face=Arial color=#0000ff size=2>5.
Touch your module and publish all files.</FONT></SPAN></DIV>
<DIV><SPAN class=878573911-18102005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=878573911-18102005><FONT face=Arial color=#0000ff size=2>6.
restart tomcat</FONT></SPAN></DIV>
<DIV><SPAN class=878573911-18102005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=878573911-18102005><FONT face=Arial color=#0000ff size=2>If
this doesn't help, please provide the follwing infos:</FONT></SPAN></DIV>
<DIV><SPAN class=878573911-18102005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=878573911-18102005><FONT face=Arial color=#0000ff size=2>Tomcat
version</FONT></SPAN></DIV>
<DIV><SPAN class=878573911-18102005><FONT face=Arial color=#0000ff size=2>your
jdbc driver</FONT></SPAN></DIV>
<DIV><SPAN class=878573911-18102005><FONT face=Arial color=#0000ff size=2>trace
log (opencms.log and catalina.out)</FONT></SPAN></DIV>
<DIV><SPAN class=878573911-18102005><FONT face=Arial color=#0000ff size=2>does
your opencms installation work properly?</FONT></SPAN></DIV>
<DIV><SPAN class=878573911-18102005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=878573911-18102005><FONT face=Arial color=#0000ff
size=2>Looking to hear from you.</FONT></SPAN></DIV>
<DIV><SPAN class=878573911-18102005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=878573911-18102005><FONT face=Arial color=#0000ff size=2>Kind
Regards,</FONT></SPAN></DIV>
<DIV><SPAN class=878573911-18102005><FONT face=Arial color=#0000ff
size=2>Arash</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
opencms-dev-bounces@opencms.org [mailto:opencms-dev-bounces@opencms.org] <B>On
Behalf Of </B>Jakob Lemler<BR><B>Sent:</B> Dienstag, 18. Oktober 2005
13:34<BR><B>To:</B> 'The OpenCms mailing list'<BR><B>Subject:</B> AW:
[opencms-dev] Forum Module (mvnForum) for OpenCms 6.x
availablefordownload<BR><BR></FONT></DIV>
<DIV><SPAN class=137540710-18102005><FONT face=Arial color=#0000ff size=2>hi
Arash,</FONT></SPAN></DIV>
<DIV><SPAN class=137540710-18102005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=137540710-18102005><FONT face=Arial color=#0000ff
size=2>first of all thanks for the module, althought it does not work here
until yet. </FONT></SPAN></DIV>
<DIV><SPAN class=137540710-18102005><FONT face=Arial color=#0000ff size=2>But
the reason why is just peanuts (almost for sure ...
;-))</FONT></SPAN></DIV>
<DIV><SPAN class=137540710-18102005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=137540710-18102005><FONT face=Arial color=#0000ff
size=2>Tried to install it with ocms 6.02 according to your description.
But it does not work because the mysql jdbc driver could not be found ...
(as far as I understand the error message further down).</FONT></SPAN></DIV>
<DIV><SPAN class=137540710-18102005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=137540710-18102005><FONT face=Arial color=#0000ff size=2>In
my installation, there is an actual jdbc-driver under
"%catalina_home%\common\lib" (3.1.11) additionally to the version which comes
with opencms in the WEB-INF\lib directory (3.0.15-ga-bin). As far as I
understand the one under the common directory should be found (and should be
usable) by all deployed webapps. Additionally the one in the opencms tree
should be used first... So I do not get what's the reason why...
;-(</FONT></SPAN></DIV>
<DIV><SPAN class=137540710-18102005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=137540710-18102005><FONT face=Arial color=#0000ff size=2>How
the modul is "looking up" the driver? Is it possible (or perhaps a must) to
use the tomcat connection pool ??? </FONT></SPAN></DIV>
<DIV><SPAN class=137540710-18102005><FONT face=Arial color=#0000ff size=2>If
so, what exactly do I have to include in the mvncore.xml
file?</FONT></SPAN></DIV>
<DIV><SPAN class=137540710-18102005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=137540710-18102005><FONT face=Arial color=#0000ff size=2>As
you can see, these are the questions of a non programmer ... Hopefully
interesting to otherones too... ;-)</FONT></SPAN></DIV>
<DIV><SPAN class=137540710-18102005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN><SPAN class=137540710-18102005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=137540710-18102005><FONT face=Arial color=#0000ff
size=2>regards and tia for your answer!</FONT></SPAN></DIV>
<DIV><SPAN class=137540710-18102005><FONT face=Arial color=#0000ff
size=2>jakob</FONT></SPAN></DIV>
<DIV></DIV>
<DIV><FONT face=Tahoma size=2><FONT face=Arial
color=#0000ff></FONT></FONT> </DIV>
<DIV><SPAN class=137540710-18102005><FONT face=Arial color=#0000ff
size=2>environment:</FONT></SPAN></DIV>
<DIV><SPAN class=137540710-18102005><FONT face=Arial color=#0000ff size=2>-
win xp sp1</FONT></SPAN></DIV>
<DIV><SPAN class=137540710-18102005><FONT face=Arial color=#0000ff size=2>-
mysql 4.1.13</FONT></SPAN></DIV>
<DIV><SPAN class=137540710-18102005><FONT face=Arial color=#0000ff size=2>-
jdbc driver 3.1.11</FONT></SPAN></DIV>
<DIV><SPAN class=137540710-18102005><FONT face=Arial color=#0000ff size=2>-
tomcat 5.5.12</FONT></SPAN></DIV>
<DIV><SPAN class=137540710-18102005><FONT face=Arial color=#0000ff size=2>-
opencms 6.0.2</FONT></SPAN></DIV>
<DIV><SPAN class=137540710-18102005><FONT face=Arial color=#0000ff size=2>-
jdk 1.5.0</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><SPAN class=137540710-18102005><FONT face=Arial color=#0000ff
size=2>Screen-Message:</FONT></SPAN></DIV>
<DIV><SPAN class=137540710-18102005>
<H2 align=center>mvnForum Fatal Error Message : Cannot init system. Reason :
Check your database configuration. Detail : DBUtils: Cannot get connection
from Connection Pool.</H2></SPAN></DIV>
<DIV><SPAN class=137540710-18102005><FONT face=Arial color=#0000ff
size=2>stdout.log:</FONT></SPAN></DIV>
<DIV><SPAN class=137540710-18102005><FONT face=Arial color=#0000ff
size=2>"2005-10-18 12:04:49,278 ERROR [ajp-8019-1] db.DBConnectionManager
(DBConnectionManager.java:356) - Cannot create a new
connection in DBConnectionPool. URL = <A
href="http://capella.chako.de:8080/opencms/mvnforum/?useServerPrepStmts=false">http://capella.chako.de:8080/opencms/mvnforum/?useServerPrepStmts=false</A><BR>java.sql.SQLException:
No suitable driver<BR> at java.sql.DriverManager.getConnection(Unknown
Source)<BR> at java.sql.DriverManager.getConnection(Unknown
Source)"<BR></FONT></SPAN></DIV>
<DIV><FONT face=Tahoma><FONT size=2><SPAN class=137540710-18102005><FONT
face=Arial color=#0000ff></FONT></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=137540710-18102005>The
data in mvncore.xml:</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=137540710-18102005><dboptions><BR>
<!--<BR> if USE_DATASOURCE
= false, use the default built-in connection
pool<BR> if USE_DATASOURCE =
true, use the connection pool that Servlet Container
provides<BR>
--><BR>
<use_datasource>false</use_datasource><BR>
<!--<BR> You should NOT
change the DATABASE_TYPE
below<BR> By default,
DATABASE_TYPE = 0<BR> NOTE: If
your database/driver doesnt support scrollable
resultset<BR>
(such as some version of Interbase/Firebird), set DATABASE_TYPE =
2<BR>
--><BR>
<database_type>0</database_type><BR>
<!--<BR> Set the below
options if you want to use default connection
pool<BR> This is applied if
you set USE_DATASOURCE =
false<BR>
MINUTES_BETWEEN_REFRESH is the minutes between built-in Connection Pool
refreshment<BR>
Some time your database server is set connection timeout too low, such
as<BR>
5 minutes, that cause the connection auto disconnected. In this case you
should<BR>
set MINUTES_BETWEEN_REFRESH lower than the server connection timeout
value<BR> NOTE: These values
can be obtained from the header of
the<BR>
sql script for your
database<BR> NOTE: For
compatible with future release of mvnForum, we
highly<BR>
recommend that use config your database/driver to use unicode utf8
encoding<BR>
--><BR>
<driver_class_name>com.mysql.jdbc.Driver</driver_class_name><BR>
<!--
<database_url>jdbc:mysql://localhost/opencms?useUnicode=true&characterEncoding=utf-8</database_url>
--><BR>
<database_url>http://capella.chako.de:8080/opencms/mvnforum/?useServerPrepStmts=false</database_url><BR>
<database_user>XXXX</database_user><BR>
<database_password>XXXXXXXXX</database_password><BR>
<max_connection>30</max_connection><BR>
<max_time_to_wait>2000</max_time_to_wait><BR>
<minutes_between_refresh>15</minutes_between_refresh><BR>
<!--<BR> Set the Data
source name if you want to use Servlet Container connection
pool<BR> This is applied if
you set USE_DATASOURCE = true<BR>
--><BR>
<datasource_name/><BR>
</dboptions><BR></SPAN></FONT></DIV>
<DIV><FONT face=Tahoma><FONT face=Arial color=#0000ff size=2><SPAN
class=137540710-18102005></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Tahoma><FONT size=2><SPAN
class=137540710-18102005> </SPAN>-----Ursprüngliche
Nachricht-----<BR><B>Von:</B> opencms-dev-bounces@opencms.org
[mailto:opencms-dev-bounces@opencms.org] <B>Im Auftrag von </B>Arash
Kaffamanesh<BR><B>Gesendet:</B> Dienstag, 18. Oktober 2005 03:52<BR><B>An:</B>
opencms-dev@opencms.org<BR><B>Betreff:</B> [opencms-dev] Forum Module
(mvnForum) for OpenCms 6.x available fordownload<BR><BR></DIV></FONT></FONT>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><FONT face=Verdana><SPAN
class=518595400-18102005>Hi,</SPAN></FONT></DIV>
<DIV><FONT face=Verdana><SPAN
class=518595400-18102005></SPAN></FONT> </DIV>
<DIV><FONT face=Verdana><SPAN class=518595400-18102005>as promised last week
(and last year ;-)) an easy to use: </SPAN></FONT></DIV>
<DIV><FONT face=Verdana><SPAN
class=518595400-18102005></SPAN></FONT> </DIV>
<DIV><FONT face=Verdana><SPAN
class=518595400-18102005><STRONG>OpenCms-mvnForum-Plugin
Module</STRONG></SPAN></FONT></DIV>
<DIV><FONT face=Verdana><SPAN
class=518595400-18102005></SPAN></FONT> </DIV>
<DIV><FONT face=Verdana><SPAN class=518595400-18102005>is now available for
download.</SPAN></FONT></DIV>
<DIV><FONT face=Verdana><SPAN
class=518595400-18102005></SPAN></FONT> </DIV>
<DIV><FONT face=Verdana><SPAN class=518595400-18102005>Module Name: <FONT
color=#0000ff>org.opencms.mvnforum.plugin</FONT><BR>Date released:
2005/10/17<BR>Integrator: Arash Kaffamanesh<BR>Version:
0.18</SPAN></FONT></DIV>
<DIV><FONT face=Verdana><SPAN class=518595400-18102005>Download Size: 5.7
MB</SPAN></FONT></DIV>
<DIV><FONT face=Verdana><SPAN
class=518595400-18102005></SPAN></FONT> </DIV>
<DIV><FONT face=Verdana><SPAN
class=518595400-18102005>Description:</SPAN></FONT></DIV>
<DIV><FONT face=Verdana></FONT> </DIV>
<DIV><FONT face=Verdana><SPAN class=518595400-18102005>This module has been
tested with the latest OpenCms 6.0.2, MySQL 4.x on Windows 2000 and includes
the latest mvnForum RC4,<BR>it comes as it is without any garanty and with
respect to terms and conditions of mvnForum and OpenCms licensing rules
(LGPL GNU License).</SPAN></FONT></DIV>
<DIV><FONT face=Verdana></FONT> </DIV>
<DIV><FONT face=Verdana><SPAN
class=518595400-18102005>Preconditions:</SPAN></FONT></DIV>
<DIV><FONT face=Verdana></FONT> </DIV>
<DIV><FONT face=Verdana><SPAN class=518595400-18102005>You shall have
installed OpenCms 6.x with MySQL 4.x on Tomcat 5.x (Java 1.5 recommended)
under webapps/opencms.</SPAN></FONT></DIV>
<DIV><FONT face=Verdana><SPAN
class=518595400-18102005></SPAN></FONT> </DIV>
<DIV><FONT face=Verdana><SPAN class=518595400-18102005>Further information
and download available from:</SPAN></FONT></DIV>
<DIV><FONT face=Verdana></FONT> </DIV>
<DIV><FONT face=Verdana><A
href="http://www.pomegranate.de/en/OpenSource/OpenCMS/downloads/index.html">http://www.pomegranate.de/en/OpenSource/OpenCMS/downloads/index.html</A></FONT></DIV>
<DIV><SPAN class=518595400-18102005><FONT
face=Verdana></FONT></SPAN> </DIV>
<DIV><SPAN class=518595400-18102005><FONT face=Verdana>Please provide
feedback. </FONT></SPAN></DIV>
<DIV><SPAN class=518595400-18102005><FONT
face=Verdana></FONT></SPAN> </DIV>
<DIV><SPAN class=518595400-18102005><FONT face=Verdana>After sufficient
testing it could be uploaded to OpenCms 6 Sandbox, in the case
that any of You could find it useful and OpenCms Experts at
Alkacon would like to do so :-)</FONT></SPAN></DIV>
<DIV><SPAN class=518595400-18102005><FONT
face=Verdana></FONT></SPAN> </DIV>
<DIV><SPAN class=518595400-18102005><FONT face=Verdana>Kind
Regards,</FONT></SPAN></DIV>
<DIV><SPAN class=518595400-18102005><FONT
face=Verdana>Arash</FONT></SPAN></DIV>
<DIV dir=ltr align=left>
<DIV><FONT face=Verdana><SPAN class=736484818-11102005><SPAN
class=736484818-11102005> ______________________________________</SPAN></SPAN></FONT></DIV><FONT
face=Verdana><SPAN class=736484818-11102005>|arash kaf<SPAN
class=518595400-18102005>f</SPAN>amanesh </SPAN> <SPAN
class=736484818-11102005> </SPAN></FONT>
<DIV><FONT face=Verdana><SPAN
class=736484818-11102005>| </SPAN></FONT></DIV>
<DIV><FONT face=Verdana><SPAN class=736484818-11102005></SPAN></FONT></DIV>
<DIV><FONT face=Verdana><SPAN
class=736484818-11102005>|http://www.pomegranate.de</SPAN></FONT></DIV>
<DIV><FONT face=Verdana><SPAN class=736484818-11102005>|<FONT
color=#ff0000>global portal & content management
solutions</FONT></SPAN></FONT></DIV>
<DIV><SPAN class=736484818-11102005><SPAN class=736484818-11102005><FONT
face=Verdana>|<SPAN class=736484818-11102005><SPAN
class=736484818-11102005>______________________________________</SPAN></SPAN></FONT></SPAN></SPAN></DIV></DIV>
<DIV><FONT face=Arial
size=2></FONT> </DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>