Re: Cannot install jahia 5.0 on mysql 5.0

Looks like there was some issue with mysql 5.0.15 and utf8.
I had set the log4j level to debug and I am getting the following error:

2006-10-04 12:03:58,890: [http-8080-Processor23] DatabaseConnection, DEBUG,
org.jahia.admin.database.DatabaseConnection: Trying to open a database
connection...
2006-10-04 12:03:59,578: [http-8080-Processor23] DatabaseConnection, DEBUG,
org.jahia.admin.database.DatabaseConnection: Try to talk with the database
using table [jahia_db_test]...
2006-10-04 12:03:59,765: [http-8080-Processor23] DatabaseConnection, DEBUG,
org.jahia.admin.database.DatabaseConnection: Error executing query [SELECT
testfield FROM jahia_db_test]
java.sql.SQLException: Data too long for column 'testfield' at row 1

I found out some related links on web for the same
http://forums.mysql.com/read.php?103,51906,86883#msg-86883
http://bugs.mysql.com/bug.php?id=18908

Finally,
alter database jahia default character set utf8;
worked.

Thanks
Sanjay
http://sanjaygoel.blogspot.com

On 10/3/06, Dan O'Hare <[email protected]> wrote:
>
> Sanjay Goel wrote:
>
> > Hi,
> > I have been trying to use mysql as a backend db for jahia. In Jahia
> > Configuration wizard, I go to advance settings for database, select
> > mysql and put these values
> > driver com.mysql.jdbc.Driver
> > url jdbc:mysql://localhost/jahia?useUnicode=true&characterEncoding=UTF-8
> > username jahia
> > passwd jahia
> >
> > I have already created a user jahia with passwd jahia and also created
> > the database jahia on my local mysql server. I also have UTF-8 charset
> > enabled in my mysql server instance. I am able to connect to this DB
> > using mysql client.
> > However, when I use these settings, jahia gives an error - Can't talk
> > with the database. Check your settings.
> >
> > I also tried url
> >
> jdbc:mysql://localhost:3306/jahia?useUnicode=true&characterEncoding=UTF-8
> >
> > What can be possibly wrong in this setup?
> > Sanjay Goel
> > http://sanjaygoel.blogspot.com
>
> Have you given all privileges to your database for the given username
> and password like this:
>
> Grant all privileges on jahia to 'jahia'@'localhost';
> Flush privileges;
>
> I had a similar problem and eventually it solved itself with the above
> MySQL commands and the code you mentioned.
> Oh and thanks for putting your improved readme file up as it helped me a
> lot to get Jahia 5 built and deployed.
>
> Hope this helps,
>
> Dan
>
> --
> Dan O'Hare
> Developer
>
> SOUK Digital
> A SOUK Group Company.
>
> http://www.soukdigital.com/
>
> Nottingham Office
> High Pavement Business Centre,
> 3-5 High Pavement,
> The Lace Market,
> Nottingham.
> NG1 1HF
> Tel: +44 (0) 115 959 6455
> Fax: +44 (0) 115 959 6456
> Direct: +44 (0) 115 959 6472
>
> London Office
> 1st Floor,
> Shaftesbury House,
> 151 Shaftesbury Avenue,
> London WC2H 8AL
> Tel: +44 (0) 20 7420 7880
>
> Confidentiality: This e-mail and its attachments are intended for
> the above named only and may be confidential. If they have come
> to you in error you must take no action based on them, nor must
> you copy or show them to anyone; please reply to this e-mail and
> highlight the error.
>
> Security Warning: Please note that this e-mail has been created
> in the knowledge that Internet e-mail is not a 100% secure
> communications medium. We advise that you understand and observe
> this lack of security when e-mailing us.
>
> Viruses: Although we have taken steps to ensure that this e-mail
> and attachments are free from any virus, we advise that in keeping
> with good computing practice the recipient should ensure they are
> actually virus free.
>
>
>