topic Re: Problems installin MySQL with Alfresco in Alfresco Archive

Problems installin MySQL with Alfresco

marãƒâ_a — Fri, 24 Aug 2007 09:42:56 GMT

Hi! This is the first time IÃ¢â‚¬â„¢m using Alfresco. I have a lot of questions and my English is not very good. IÃ¢â‚¬â„¢ve been working with an Alfresco version that works with HSQL. Now IÃ¢â‚¬â„¢m trying to change HSQL with MySQL. What I have done is the next:I have downloaded MySQL Server 5.0.I

Re: Problems installin MySQL with Alfresco

winston — Fri, 24 Aug 2007 09:49:48 GMT

hi,

did you run this command

mysql -u root -p db_setup.sql

or this one

mysql -u root -p <db_setup.sql

You need that little arrow

Re: Problems installin MySQL with Alfresco

marãƒâ_a — Fri, 24 Aug 2007 10:31:25 GMT

Hi!, thanks a lot. Now I'm executing the comand with that little arrow and I have another error:

classpath:alfresco/dbscripts/create/1.4/${db.script.dialect}/post-create-indexes.sql
10:50:18,937 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: Bootstrap failed

Thanks a lot for the answer

Re: Problems installin MySQL with Alfresco

sanghamitra — Wed, 29 Aug 2007 08:43:25 GMT

Hi I would just you follow the following steps :-

Stop all running instances of tomcat before you try any of these steps.

1. first after installing alfresco2.1 go to alfresco\extras\databases\mysql from the command prompt.
then run the command db_remove.bat (this will remove all running instances as you said that you have already created the database).

then run the command db_start.bat and when prompted enter your password. Your alfresco database will be created.

(If you face any problem here this means your mysql is not installed properly. so try removing it and reinstalling it. removing it includes manually deleting the mysql folder if it doesnt get deleted automatically).

2.modify 2 files from the tomcat/shared/classes/alfresco/extension directory that are set to use HSQL. Those files are:
- custom-repository.properties
     - comment out the HSQL connection lines (using #)
     - uncomment the MySQL connection lines and adjust as appropriate
- custom-hibernate-dialect.properties
     - comment out the HSQL line using #
     - uncomment the MySQL line

3. Download the MySQL Java Database Connector from http://dev.mysql.com/downloads/connector/j/   and Copy the JAR file into alfresco\tomcat\server\lib.
The jar file is "mysql-connector-java-5.0.6-bin".

4. Then restart your tomcat and it should work fyn.

Let me know if you still face any problems.
Best of Luck

Re: Problems installin MySQL with Alfresco

marãƒâ_a — Wed, 29 Aug 2007 12:01:08 GMT

Thanks a lot, now it seems to me that is works. But now I have another problem. IÃ¢â‚¬â„¢m in a local network using a proxy. IÃ¢â‚¬â„¢m trying to Ã¢â‚¬Å“mapping network driveÃ¢â‚¬

Re: Problems installin MySQL with Alfresco

sanghamitra — Wed, 29 Aug 2007 12:21:55 GMT

Hi
From what I understand you are facing problem in your CIFS configuration

Just try out the steps below and let me know if it works.
1. open my computers –> go to tools —> Map network drive
there specify any drive say y: and put the folder name as \\<your computer name>_a\alfresco and click on finish.
then you should be able to see the alfresco folder.

This should work fine.
In case i didn't understand your problem properly let me know.

Best of luck

Re: Problems installin MySQL with Alfresco

marãƒâ_a — Wed, 29 Aug 2007 12:48:42 GMT

Hi,
Mi problem is that when I try that steps it doesnÃ¢â‚¬â„¢t work, but I donÃ¢â‚¬â„¢t know why. Could it be because of the domain?
Thanks a lot

Re: Problems installin MySQL with Alfresco

mikeh — Wed, 29 Aug 2007 13:34:28 GMT

Hi,

It looks like you're trying to map a drive to a folder that doesn't exist.

Try choosing Start, then Run and typing the path you're trying to map, e.g.

\\myserver_a\alfresco‍

That should bring up an Explorer window. By default this folder will be mapped to the Company Home space.

If you want to create extra mappings, for example to the User Homes space, then you would use the path

\\myserver_a\alfresco\User Homes‍

The point being, you have to map the path as it appears in Windows Explorer.

Hope that helps,
Mike

Re: Problems installin MySQL with Alfresco

marãƒâ_a — Wed, 29 Aug 2007 13:54:54 GMT

Hi!
I can open in a Windows Explorer the folder Ã¢â‚¬Å“MyComputerNameÃ¢â‚¬

Re: Problems installin MySQL with Alfresco

mikeh — Wed, 29 Aug 2007 14:44:59 GMT

Hi,

I hadn't noticed your earlier comment:

IÃ¢â‚¬â„¢m in a local network using a proxy.

You need to make sure the proxy is letting CIFS traffic through.

I would highly recommend you try to connect without a proxy in place to check the server configuration is correct, then try to add the proxy in - otherwise it's much harder to figure out where the problem lies.

Thanks,
Mike

Re: Problems installin MySQL with Alfresco

marãƒâ_a — Thu, 30 Aug 2007 07:25:09 GMT

Hi!
IÃ¢â‚¬â„¢ve solved my problem. It was because my PC Name was too long and then, Alfresco couldÃ¢â‚¬â„¢t add Ã¢â‚¬Å“_aÃ¢â‚¬

Re: Problems installin MySQL with Alfresco

mikeh — Thu, 30 Aug 2007 08:51:08 GMT

Hi,

Glad you got the problem fixed - thanks for posting your solution.

Mike