topic Error on Configuration of New Alfresco CM 2.1 I with MySQL in Alfresco Archive

Error on Configuration of New Alfresco CM 2.1 I with MySQL

jrpolan — Fri, 14 Sep 2007 15:30:48 GMT

Hello,I have recently installed the 2.1 community edition on Mac OSX. Once I configure the database for MySQL according to wiki instructions, I get the errors pasted below. NOTE: If I swap back to HSQL, it works just fine. Anyone have ideas?5:54:34,173 ERROR [org.alfresco.repo.content.transform.magi

Re: Error on Configuration of New Alfresco CM 2.1 I with MySQL

mikeh — Fri, 14 Sep 2007 15:56:41 GMT

Hi Jason,

Did you run the db_setup.sql script?


create database alfresco;
grant all on alfresco.* to 'alfresco'@'localhost' identified by 'alfresco' with grant option;
grant all on alfresco.* to 'alfresco'@'localhost.localdomain' identified by 'alfresco' with grant option;‍‍‍‍

Thanks,
Mike

Re: Error on Configuration of New Alfresco CM 2.1 I with MySQL

jrpolan — Fri, 14 Sep 2007 16:05:23 GMT

Mike,
Yes i did and they completed successfully. I can connect as alfresco to mysql following the script executing.

Jason

Re: Error on Configuration of New Alfresco CM 2.1 I with MySQL

mikeh — Fri, 14 Sep 2007 16:28:47 GMT

Could you also check the MySQL connector is on the classpath?

http://dev.mysql.com/downloads/connector/j/5.0.html

Thanks,
Mike

Re: Error on Configuration of New Alfresco CM 2.1 I with MySQL

jrpolan — Fri, 14 Sep 2007 17:40:46 GMT

Hi Mike,
yes, it is on the classpath. ive echoed it at start and it shows up.

Jason

Re: Error on Configuration of New Alfresco CM 2.1 I with MySQL

mikeh — Fri, 14 Sep 2007 19:32:19 GMT

I'll speak to one of the devs here on Monday who has set up correctly on a Mac - there's might be a step missing from the wiki.

Thanks,
Mike

Re: Error on Configuration of New Alfresco CM 2.1 I with MySQL

orion — Sat, 15 Sep 2007 22:41:25 GMT

Hello MikeH,

Maybe this can help you. Copy the Mysql Java Connector to /webapps/alfresco/WEB-INF/lib and try again.

Orion

Re: Error on Configuration of New Alfresco CM 2.1 I with MySQL

jrpolan — Tue, 18 Sep 2007 12:10:04 GMT

Orion,
Yep, tried that as well, no luck. the mysql connector is definitely in the classpath.

Jason

Re: Error on Configuration of New Alfresco CM 2.1 I with MySQL

ebariaux — Wed, 19 Sep 2007 21:42:21 GMT

I have the same issue on Gentoo.

I solve this part

 command: convert /Applications/alfresco/tomcat/temp/Alfresco/ImageMagickContentTransformer_init_source_46095.gif /Applications/alfresco/tomcat/temp/Alfresco/ImageMagickContentTransformer_init_target_46096.png
succeeded: false
exit code: 1
out:
err: convert: not found ‍‍‍‍‍

by installing image magick. But the rest still fails.

Re: Error on Configuration of New Alfresco CM 2.1 I with MySQL

jmintha — Thu, 11 Oct 2007 07:49:33 GMT

I had the same problem. It turned out that tcp wrappers were blocking the connection to the database. From /var/log/auth.log:
mysqld[19684]: refused connect from 127.0.0.1

adding:
mysqld: localhost 127.0.0.1

to /etc/hosts.allow seems to have solved it.