<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7226.0">
<TITLE>OpenCms creating DB failed. Solved</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>Hi team,<BR>
<BR>
Problem solved!. Here you have de solution to DB connection.<BR>
<BR>
1.- Platform s/w:<BR>
<BR>
Fedora FC4<BR>
Java 1.4.2_08 (SDK)<BR>
Tomcat 4.1.31<BR>
MySQL 4.0.24<BR>
MySQL jdbc 3.1.1<BR>
<BR>
2.- Copy MySQL conector jdbc<BR>
Copy "mysql-conector-java-3.1.10.bin.jar" (not "..bin-g.jar") to /opencms/WEB-INF/lib<BR>
3.- Modify OpenCms Java driver<BR>
Change 'org.gjt.myqsl.Driver' to 'org.gjt.mm.mysql.Driver'<BR>
4.-Solve Fedora FC4 and java conflict<BR>
As shown in <A HREF="http://www.linuxforums.org/forum/topic-47483.html">http://www.linuxforums.org/forum/topic-47483.html</A><BR>
add 'alias net-pf-10 off' to your /etc/modprobe.conf and reboot<BR>
5.- Start again opencms-wizard<BR>
leave all default values:<BR>
a.- Database Server Connection "root" no password;<BR>
b.- OpenCms Connection "root"<BR>
c.- jdbc:mysql://localhost:3306/<BR>
d.- Database: opencms<BR>
<BR>
Hope it helps others!<BR>
<BR>
Brgds, David<BR>
<BR>
<BR>
<BR>
-----Mensaje original-----<BR>
De: David Gonzalez Fuentes<BR>
Enviado el: jue 30/06/2005 13:23<BR>
Para: David Gonzalez Fuentes; The OpenCms mailing list<BR>
Asunto: RE: [opencms-dev] OpenCms creating DB failed<BR>
<BR>
I've desactivate IPV6 in FC4, as I've found some network connection problem reported between java and FC4. I've added "alias net-pf-10 off" to /etc/modprobe.conf and OpenCms wizard-startup error has been changed.<BR>
<BR>
Perhaps the pbm is in FC4. Has anyone had the same problem or this may be the clue?.<BR>
<BR>
Brgds, David<BR>
<BR>
<BR>
-----Mensaje original-----<BR>
De: David Gonzalez Fuentes<BR>
Enviado el: jue 30/06/2005 12:21<BR>
Para: The OpenCms mailing list<BR>
Asunto: RE: [opencms-dev] OpenCms creating DB failed<BR>
<BR>
<BR>
I've replaced "localhost" with "127.0.0.1" pool.mysql.url=jdbc:mysql://localhost:3306/opencms<BR>
and same problem.<BR>
<BR>
I've done "mysql -u<user> -p<password> and I have access. "telnet localhost 3306" works, etc<BR>
<BR>
I'm not sure if I've to shutdown tomcat and restart again, or insert full path to pool.mysql.url=jdbc:mysql://localhost:3306/opencms.<BR>
<BR>
I'm not an Java and MuSQL expert.<BR>
<BR>
Thanks anyway<BR>
<BR>
-----Mensaje original-----<BR>
De: opencms-dev-bounces@opencms.org en nombre de Claus Priisholm<BR>
Enviado el: jue 30/06/2005 11:43<BR>
Para: The OpenCms mailing list<BR>
Asunto: Re: [opencms-dev] OpenCms creating DB failed<BR>
<BR>
I haven't followed this thread from the start, but have you tried to<BR>
replace 'localhost' with '127.0.0.1' in the JDBC url?<BR>
<BR>
David Gonzalez Fuentes wrote:<BR>
> Hi team,<BR>
> <BR>
> My enviroment is :<BR>
> <BR>
> Fedora FC4<BR>
> Java 1.4.2_08 (SDK)<BR>
> Tomcat 4.1.31<BR>
> MySQL 4.0.24<BR>
> MySQL jdbc 3.1.10<BR>
> <BR>
> I've updated 'org.gjt.myqsl.Driver' to 'org.gjt.mm.mysql.Driver' however I do not find " db.pool.default.jdbcDriver". I only have in opencms.properties "pool.mysqlonline.driver=org.gjt.mm.mysql.Driver".<BR>
> <BR>
> Should I have "db.pool.default.jdbcDriver"?<BR>
><BR>
> <BR>
> Brgds, David<BR>
><BR>
> ________________________________<BR>
><BR>
> De: opencms-dev-bounces@opencms.org en nombre de Alexander Wallace<BR>
> Enviado el: mié 29/06/2005 21:13<BR>
> Para: The OpenCms mailing list<BR>
> Asunto: Re: [opencms-dev] OpenCms creating DB failed<BR>
><BR>
><BR>
><BR>
> Also, depending on your enviroment, you could be using other driver even if<BR>
> you have the most current in your lib folder...<BR>
><BR>
> But i would definitely try changing the class name in<BR>
> WEB-INF/conf/opencms.properties<BR>
><BR>
> On Wednesday 29 June 2005 12:39 pm, Borja Marcos Suarez wrote:<BR>
><BR>
>>What is your environment? I mean, jvm, tomcat version, ...<BR>
>><BR>
>>Another idea is... check the opencms.properties file in WEB-INF/config<BR>
><BR>
> directory.<BR>
><BR>
>>You can try to change the driver by default 'org.gjt.myqsl.Driver' to the<BR>
><BR>
> new one as they say in the MySQL site.<BR>
><BR>
>>db.pool.default.jdbcDriver=org.gjt.mm.mysql.Driver<BR>
>><BR>
>>Regards,<BR>
>><BR>
>>Borja Marcos<BR>
>><BR>
>> _____<BR>
>><BR>
>>De: opencms-dev-bounces@opencms.org en nombre de David Gonzalez Fuentes<BR>
>>Enviado el: mié 29/06/2005 19:19<BR>
>>Para: The OpenCms mailing list<BR>
>>Asunto: RE: [opencms-dev] OpenCms creating DB failed<BR>
>><BR>
>><BR>
>>I've updated jdbc connector as follows, but same pblm<BR>
>>webapps/opencms/WEB-INF/lib/mysql-connector-java-3.1.10-bin.jar<BR>
>><BR>
>>Brgds, David<BR>
>><BR>
>><BR>
>><BR>
>><BR>
>> _____<BR>
>><BR>
>>De: opencms-dev-bounces@opencms.org en nombre de David Gonzalez Fuentes<BR>
>>Enviado el: mié 29/06/2005 18:55<BR>
>>Para: The OpenCms mailing list<BR>
>>Asunto: RE: [opencms-dev] OpenCms creating DB failed<BR>
>><BR>
>><BR>
>><BR>
>>I've installed mysql connector<BR>
><BR>
> at /webapps/opencms/WEB-INF/lib/mysql-connector-java-3.0.7-stable-bin.jar. I<BR>
> think is the las stable one, however I'll check again in Mysql web.<BR>
><BR>
>>Thanks for coops.<BR>
>><BR>
>>Brgds, David<BR>
>><BR>
>> _____<BR>
>><BR>
>>De: opencms-dev-bounces@opencms.org en nombre de Alexander Wallace<BR>
>>Enviado el: mié 29/06/2005 18:00<BR>
>>Para: The OpenCms mailing list<BR>
>>Asunto: Re: [opencms-dev] OpenCms creating DB failed<BR>
>><BR>
>><BR>
>><BR>
>>Sounds to me like a jdbc driver problem, i think i've seen it in this<BR>
>>scenarion and fixed it getting the newest version...<BR>
>><BR>
>>On Wednesday 29 June 2005 10:33 am, David Gonzalez Fuentes wrote:<BR>
>><BR>
>>>Hello Team,<BR>
>>><BR>
>>>I've installed all previous OpenCms components successfully however when<BR>
>><BR>
>>installing OpenCms setup-wizard, I get a "Creating Database....Failed" msg.<BR>
>>The following msg is displayed:<BR>
>><BR>
>>>"Could no connect to database via: jdbc:mysql://localhost:3306/<BR>
>>>java.sql. SQL Exception: communication link failure: Bad handshake"<BR>
>>><BR>
>>>MySQL is up&running however I've installed it as default. Root permission<BR>
>><BR>
>>are ok as MySQL instalation procedure.<BR>
>><BR>
>>>Should I modify other parameters?<BR>
>>><BR>
>>>Thanks for coops.<BR>
>>><BR>
>>>Brgds, David<BR>
>>><BR>
>><BR>
>><BR>
>>_______________________________________________<BR>
>>This mail is send to you from the opencms-dev mailing list<BR>
>>To change your list options, or to unsubscribe from the list, please visit<BR>
>><A HREF="http://mail.opencms.org/mailman/listinfo/opencms-dev">http://mail.opencms.org/mailman/listinfo/opencms-dev</A><BR>
>><BR>
>><BR>
>><BR>
><BR>
><BR>
><BR>
> _______________________________________________<BR>
> This mail is send to you from the opencms-dev mailing list<BR>
> To change your list options, or to unsubscribe from the list, please visit<BR>
> <A HREF="http://mail.opencms.org/mailman/listinfo/opencms-dev">http://mail.opencms.org/mailman/listinfo/opencms-dev</A><BR>
><BR>
><BR>
><BR>
><BR>
> ------------------------------------------------------------------------<BR>
><BR>
><BR>
><BR>
> _______________________________________________<BR>
> This mail is send to you from the opencms-dev mailing list<BR>
> To change your list options, or to unsubscribe from the list, please visit<BR>
> <A HREF="http://mail.opencms.org/mailman/listinfo/opencms-dev">http://mail.opencms.org/mailman/listinfo/opencms-dev</A><BR>
<BR>
--<BR>
Claus Priisholm, CodeDroids ApS<BR>
cpr (you know what) codedroids.com - <A HREF="http://www.codedroids.com">http://www.codedroids.com</A><BR>
<BR>
Javadocs and other OpenCms stuff:<BR>
<A HREF="http://www.codedroids.com/community/opencms">http://www.codedroids.com/community/opencms</A><BR>
<BR>
<BR>
<BR>
_______________________________________________<BR>
This mail is send to you from the opencms-dev mailing list<BR>
To change your list options, or to unsubscribe from the list, please visit<BR>
<A HREF="http://mail.opencms.org/mailman/listinfo/opencms-dev">http://mail.opencms.org/mailman/listinfo/opencms-dev</A><BR>
<BR>
<BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>