[opencms-dev] OpenCms creating DB failed

[David Gonzalez Fuentes]

I've replaced "localhost" with "127.0.0.1" pool.mysql.url=jdbc:mysql://localhost:3306/opencms
and same problem.

I've done "mysql -u<user> -p<password> and I have access. "telnet localhost 3306" works, etc

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.

I'm not an Java and MuSQL expert.

Thanks anyway

-----Mensaje original-----
De: opencms-dev-bounces at opencms.org en nombre de Claus Priisholm
Enviado el: jue 30/06/2005 11:43
Para: The OpenCms mailing list
Asunto: Re: [opencms-dev] OpenCms creating DB failed
 
I haven't followed this thread from the start, but have you tried to 
replace 'localhost' with '127.0.0.1' in the JDBC url?

David Gonzalez Fuentes wrote:
> Hi team,
>  
> My enviroment is :
>  
> Fedora FC4
> Java 1.4.2_08 (SDK)
> Tomcat 4.1.31
> MySQL 4.0.24
> MySQL jdbc 3.1.10
>  
> 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". 
>  
> Should I have "db.pool.default.jdbcDriver"?
> 
>  
> Brgds, David
> 
> ________________________________
> 
> De: opencms-dev-bounces at opencms.org en nombre de Alexander Wallace
> Enviado el: mié 29/06/2005 21:13
> Para: The OpenCms mailing list
> Asunto: Re: [opencms-dev] OpenCms creating DB failed
> 
> 
> 
> Also, depending on your enviroment, you could be using other driver even if
> you have the most current in your lib folder...
> 
> But i would definitely try changing the class name in
> WEB-INF/conf/opencms.properties
> 
> On Wednesday 29 June 2005 12:39 pm, Borja Marcos Suarez wrote:
> 
>>What is your environment? I mean, jvm, tomcat version, ...
>>
>>Another idea is... check the opencms.properties file in WEB-INF/config
> 
> directory.
> 
>>You can try to change the driver by default 'org.gjt.myqsl.Driver' to the
> 
> new one as they say in the MySQL site.
> 
>>db.pool.default.jdbcDriver=org.gjt.mm.mysql.Driver
>>
>>Regards,
>>
>>Borja Marcos
>>
>>  _____ 
>>
>>De: opencms-dev-bounces at opencms.org en nombre de David Gonzalez Fuentes
>>Enviado el: mié 29/06/2005 19:19
>>Para: The OpenCms mailing list
>>Asunto: RE: [opencms-dev] OpenCms creating DB failed
>>
>>
>>I've updated jdbc connector as follows, but same pblm
>>webapps/opencms/WEB-INF/lib/mysql-connector-java-3.1.10-bin.jar
>>
>>Brgds, David
>>
>>
>>
>>
>>  _____ 
>>
>>De: opencms-dev-bounces at opencms.org en nombre de David Gonzalez Fuentes
>>Enviado el: mié 29/06/2005 18:55
>>Para: The OpenCms mailing list
>>Asunto: RE: [opencms-dev] OpenCms creating DB failed
>>
>>
>>
>>I've installed mysql connector
> 
> at /webapps/opencms/WEB-INF/lib/mysql-connector-java-3.0.7-stable-bin.jar. I
> think is the las stable one, however I'll check again in Mysql web.
> 
>>Thanks for coops.
>>
>>Brgds, David
>>
>>  _____ 
>>
>>De: opencms-dev-bounces at opencms.org en nombre de Alexander Wallace
>>Enviado el: mié 29/06/2005 18:00
>>Para: The OpenCms mailing list
>>Asunto: Re: [opencms-dev] OpenCms creating DB failed
>>
>>
>>
>>Sounds to me like a jdbc driver problem, i think i've seen it in this
>>scenarion and fixed it getting the newest version...
>>
>>On Wednesday 29 June 2005 10:33 am, David Gonzalez Fuentes wrote:
>>
>>>Hello Team,
>>>
>>>I've installed all previous OpenCms components successfully however when
>>
>>installing OpenCms setup-wizard, I get a "Creating Database....Failed" msg.
>>The following msg is displayed:
>>
>>>"Could no connect to database via: jdbc:mysql://localhost:3306/
>>>java.sql. SQL Exception: communication link failure: Bad handshake"
>>>
>>>MySQL is up&running however I've installed it as default. Root permission
>>
>>are ok as MySQL instalation procedure.
>>
>>>Should I modify other parameters?
>>>
>>>Thanks for coops.
>>>
>>>Brgds, David
>>>
>>
>>
>>_______________________________________________
>>This mail is send to you from the opencms-dev mailing list
>>To change your list options, or to unsubscribe from the list, please visit
>>http://mail.opencms.org/mailman/listinfo/opencms-dev
>>
>>
>>
> 
> 
> 
> _______________________________________________
> This mail is send to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://mail.opencms.org/mailman/listinfo/opencms-dev
> 
> 
> 
> 
> ------------------------------------------------------------------------
> 
> 
> 
> _______________________________________________
> This mail is send to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://mail.opencms.org/mailman/listinfo/opencms-dev

-- 
Claus Priisholm, CodeDroids ApS
cpr (you know what) codedroids.com - http://www.codedroids.com

Javadocs and other OpenCms stuff: 
http://www.codedroids.com/community/opencms



_______________________________________________
This mail is send to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://mail.opencms.org/mailman/listinfo/opencms-dev

-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 4681 bytes
Desc: not available
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20050630/f1c8a076/attachment.bin>