Problems installin MySQL with Alfresco

[marãƒâ_a]

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 have installed it with the typical installation (next, next…).
I’ve installed it as a Windows service and I’ve included MySQL in path.
Then I’ve run mysql -u root –p and it’s worked with no errors.

The problem is the next:

“Navigate to the 'C:\alfresco' folder and run 'db_setup.bat'.  This creates a MySQL database named 'alfresco' with a user account and password of 'alfresco'.  If db_setup fails, this may be because the MySQL service is not running or that the mysql command cannot be found.  Either correct this or setup the Alfresco database and user manually by loading the 'db_setup.sql' file into MySQL, for example, 'mysql -u root -p <db_setup.sql'â€

[winston]

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

[marãƒâ_a]

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

[sanghamitra]

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

[marãƒâ_a]

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â€

[sanghamitra]

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

[marãƒâ_a]

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

[mikeh]

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

[marãƒâ_a]

Hi!
I can open in a Windows Explorer the folder “MyComputerNameâ€

[mikeh]

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