topic Re: Alfresco and Mysql [SOLVED] in Alfresco Archive

Alfresco and Mysql [SOLVED]

dteca — Mon, 04 Feb 2008 22:16:37 GMT

Hi,Forgive me but I am not very practical Alfresco, will be part of research on my thesis of the my studies.I have a problem, should I install alfresco and use some DBMS: mysql.I downloaded the following version Alfresco-Community-2.1R1-Setup but.My OS is windows vista home premium.Towards the end o

Re: Alfresco and Mysql [SOLVED]

mikeh — Mon, 04 Feb 2008 23:26:56 GMT

Hi
Vista Home isn't a supported platform, however you could try running the installer as Administrator (right-click Run As Administrator).

Mike

Re: Alfresco and Mysql [SOLVED]

dteca — Tue, 05 Feb 2008 09:56:05 GMT

HI,
i also tried with windows Xp, but the problem is the same.
However, i want to use Alfresco with Mysql.
I have already used versions Alfresco enterprise winth HSQL with success.
As i do to install Alfresco (also enterprise) with DB Mysql?
thanks you.

m.

Re: Alfresco and Mysql [SOLVED]

mikeh — Tue, 05 Feb 2008 10:51:01 GMT

Actually I've just noticed you're trying to install an old pre-Final version.

There's a newer version here: http://sourceforge.net/project/showfiles.php?group_id=143373

Thanks,
Mike

Re: Alfresco and Mysql [SOLVED]

dteca — Tue, 05 Feb 2008 14:37:43 GMT

but i can to install the new version winth the db Mysql?
thank you

Re: Alfresco and Mysql [SOLVED]

mikeh — Tue, 05 Feb 2008 15:06:53 GMT

Yes - MySQL is fully supported. Maybe you should do some reading in the wiki to help answer these basic questions.

Thanks,
Mike

Re: Alfresco and Mysql [SOLVED]

dteca — Tue, 05 Feb 2008 18:25:55 GMT

sorry Mikeh,
i have done the following steps:

1)installation to mysql6

2)installation the new version of Alfresco: http://sourceforge.net/project/showfiles.php?group_id=143373

3)Download the JDBC driver (mysql-connector-java-5.1.5) for Mysql and add it to alfresco's war file <alfresco-install-dir>\tomcat\common\lib

4)edit custom-repository.properties and changed root/password

5)Reconfigured alfresco server and chosen mysql

6)i have restarted Alfresco, after star alfresco server.

Is correct?
thank you

Re: Alfresco and Mysql [SOLVED]

mikeh — Tue, 05 Feb 2008 20:12:18 GMT

That sounds like the correct sequence.

If Alfresco has started ok and it looks like there are tables in the Alfresco MySQL database, then you're definitely there!

Thanks
Mike

Re: Alfresco and Mysql [SOLVED]

dteca — Wed, 06 Feb 2008 07:40:41 GMT

Sorry,
alfresco not started. I think that the problem is when i lanche tehe start server.
Can you indicate any link for the installation Alfresco with Mysql?
thank you

Re: Alfresco and Mysql [SOLVED]

mikeh — Wed, 06 Feb 2008 09:40:11 GMT

There are plenty of previous topics on these forums, but often it's easier if you post the error from the alfresco log file.

Thanks,
Mike

Re: Alfresco and Mysql [SOLVED]

dteca — Wed, 06 Feb 2008 10:17:11 GMT

Sorry,
this is the error of the Alfresco Web Client

HTTP Status 404 - /alfresco/

type Status report

message /alfresco/

description The requested resource (/alfresco/) is not available.
Apache Tomcat/5.5.23

below the log :

6-feb-2008 1.31.00 org.apache.coyote.http11.Http11BaseProtocol pause
INFO: Pausing Coyote HTTP/1.1 on http-8080
6-feb-2008 1.31.01 org.apache.catalina.core.StandardService stop
INFO: Stopping service Catalina
6-feb-2008 1.31.01 org.apache.coyote.http11.Http11BaseProtocol destroy
INFO: Stopping Coyote HTTP/1.1 on http-8080
6-feb-2008 11.04.59 org.apache.coyote.http11.Http11BaseProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
6-feb-2008 11.04.59 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1152 ms
6-feb-2008 11.04.59 org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
6-feb-2008 11.04.59 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.23
6-feb-2008 11.04.59 org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
6-feb-2008 11.05.00 org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive alfresco.war
6-feb-2008 11.06.35 org.apache.catalina.core.StandardContext start
GRAVE: Error listenerStart
6-feb-2008 11.06.35 org.apache.catalina.core.StandardContext start
GRAVE: Context [/alfresco] startup failed due to previous errors
6-feb-2008 11.06.39 org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
6-feb-2008 11.06.39 org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
6-feb-2008 11.06.39 org.apache.catalina.startup.Catalina start
INFO: Server startup in 100121 ms

Re: Alfresco and Mysql [SOLVED]

mikeh — Wed, 06 Feb 2008 11:54:02 GMT

Hi

Thanks, but unfortunately that log file doesn't contain the detail of the error. There should be a separate log file generated which will contain the details of the exception stack trace.

Thanks,
Mike

Re: Alfresco and Mysql [SOLVED]

dteca — Thu, 07 Feb 2008 16:31:18 GMT

I have a summary of what I did.

1)I uninstalled alfresco and delete the folder Alfresco;

2)Delete the database (in Mysql) alfresco;

3)I installed Alfresco Http://sourceforge.net/project/showfiles.php?group_id=143373;

4)i configured the alfresco server and i chose Mysql;

4)create a new database in Mysql: 'alfresco';

5)create a new user (user:alfresco; password:alfresco);

6)the folder alfresco/tomcat/common/lib contains the java connector:
mysql-connector-java-5.0.3-bin;

7)I edited the 'custom-repository.properties' . This is the new version:

###############################
## Common Alfresco Properties #
###############################

#
# Sample custom content and index data location
#
dir.root=@@ALF_DATA@@
dir.indexes=@@ALF_INDEXES@@

#
# Sample database connection properties
#
db.username=alfresco
db.password=alfresco
#db.pool.initial=10
#db.pool.max=100

#
# Property to control whether schema updates are performed automatically.
# Updates must be enabled during upgrades as, apart from the static upgrade scripts,
# there are also auto-generated update scripts that will need to be executed. After
# upgrading to a new version, this can be disabled.
#
#db.schema.update=true

#
# HSQL connection
#
#hsql#db.driver=org.hsqldb.jdbcDriver
#hsql#db.url=jdbc:hsqldb:file:alf_data/hsql_data/alfresco;ifexists=true;shutdown=true;

#
# MySQL connection (This is default and requires mysql-connector-java-5.0.3-bin.jar, which ships with the Alfresco server)

db.driver=com.mysql.jdbc.Driver
db.url=jdbc:mysql://localhost/alfresco

#
# Oracle connection (requires ojdbc14_g.jar or equivalent jar in shared libraries location)
#
#oracle#db.driver=oracle.jdbc.OracleDriver
#oracle#db.url=jdbcracle:thin:@localhost:1521:alfresco

#
# Sybase connection (requires jconn2d.jar or equivalent jar in shared libraries location)
#
#sybase#db.driver=com.sybase.jdbc2.jdbc.SybDriver
#sybase#db.url=jdbc:sybase:Tds:localhost:2638/alfresco

#
# SQLServer connection (requires jtds-1.2.jar or equivalent - http://jtds.sourceforge.net/)
#
#sqlserver#db.driver=net.sourceforge.jtds.jdbc.Driver
#sqlserver#db.url=jdbc:jtds:sqlserver://localhost/alfresco

#
# SQLServer connection using Microsoft JDBC driver
#
#db.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
#db.url=jdbc:sqlserver://localhost;DatabaseName=alfresco

#
# PostgreSQL connection (requires postgresql-8.2-504.jdbc3.jar or equivalent)
#
#postgresql#db.driver=org.postgresql.Driver
#postgresql#db.url=jdbcostgresql://localhost:5432/alfresco

this is the log file:

7-feb-2008 17.05.39 org.apache.coyote.http11.Http11BaseProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
7-feb-2008 17.05.39 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1094 ms
7-feb-2008 17.05.39 org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
7-feb-2008 17.05.39 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.23
7-feb-2008 17.05.39 org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
7-feb-2008 17.05.40 org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive alfresco.war
7-feb-2008 17.06.40 org.apache.catalina.core.StandardContext start
GRAVE: Error listenerStart
7-feb-2008 17.06.40 org.apache.catalina.core.StandardContext start
GRAVE: Context [/alfresco] startup failed due to previous errors
7-feb-2008 17.06.41 org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
7-feb-2008 17.06.42 org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
7-feb-2008 17.06.42 org.apache.catalina.startup.Catalina start
INFO: Server startup in 62832 ms
7-feb-2008 17.07.34 org.apache.coyote.http11.Http11BaseProtocol pause
INFO: Pausing Coyote HTTP/1.1 on http-8080
7-feb-2008 17.07.35 org.apache.catalina.core.StandardService stop
INFO: Stopping service Catalina
7-feb-2008 17.07.35 org.apache.coyote.http11.Http11BaseProtocol destroy
INFO: Stopping Coyote HTTP/1.1 on http-8080
7-feb-2008 17.25.09 org.apache.coyote.http11.Http11BaseProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
7-feb-2008 17.25.09 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1053 ms
7-feb-2008 17.25.09 org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
7-feb-2008 17.25.09 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.23
7-feb-2008 17.25.09 org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
7-feb-2008 17.25.10 org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive alfresco.war
7-feb-2008 17.26.37 org.apache.catalina.core.StandardContext start
GRAVE: Error listenerStart
7-feb-2008 17.26.37 org.apache.catalina.core.StandardContext start
GRAVE: Context [/alfresco] startup failed due to previous errors
7-feb-2008 17.26.39 org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
7-feb-2008 17.26.39 org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
7-feb-2008 17.26.39 org.apache.catalina.startup.Catalina start
INFO: Server startup in 90568 ms
7-feb-2008 17.29.24 org.apache.coyote.http11.Http11BaseProtocol pause
INFO: Pausing Coyote HTTP/1.1 on http-8080
7-feb-2008 17.29.25 org.apache.catalina.core.StandardService stop
INFO: Stopping service Catalina
7-feb-2008 17.29.25 org.apache.coyote.http11.Http11BaseProtocol destroy
INFO: Stopping Coyote HTTP/1.1 on http-8080

Re: Alfresco and Mysql [SOLVED]

mikeh — Thu, 07 Feb 2008 18:41:07 GMT

Hmmm… still not the correct log file but I think I can see one possible cause…

dir.root=@@ALF_DATA@@
dir.indexes=@@ALF_INDEXES@@‍‍

These tokens should have been replaced with their respective folder paths.

dir.root should point to alf_data
dir.indexes should point to alf_data/lucene-indexes

Thanks,
Mike

Re: Alfresco and Mysql [SOLVED]

dteca — Mon, 10 Mar 2008 19:09:57 GMT

Hi,
i solved the problem for installation alfresco and mysql on Windows Vista Premium.
These are the steps that I followed:
1) Installation Java (ver. 1.5.14). After the installation i created environment variables:
â€¢ JAVA_HOME=C:\Programmi\Java\jdk1.5.0_14
â€¢ JRE_HOME=C:\Programmi\Java\jre1.5.0_14
â€¢ PATH=â€¦;%JAVA_HOME%\bin

ATTENTION. If the O.S. is Windows Vista, the path of the Folder programs is c:\Program files.

2)Installation Tomcat. . I installed tomcat5.5, as a service, on the port 8080.

3)Installation Mysql. I installed Mysql 5.1 winth the standard configuration.

4)installation Alfresco. Download and unpack in c: \ alfresco version of the distribution war.

5)Copy the files unpacked in the installation of Tomcat as follows Scheme:

C:\alfresco\alfresco.war ——-> C:\Programmi\Apache Software Foundation\Tomcat 5.5\webapps\alfresco.war
C:\alfresco\endorsed\*.* ——-> C:\Programmi\Apache Software Foundation\Tomcat 5.5\common\endorsed
C:\alfresco\extensions\extension\*.* ——> C:\Programmi\Apache Software Foundation\Tomcat 5.5\shared\classes

6)copy the dirver jdbc - Mysql (mysql-connector-java-5.1.5-bin.jar) in the directory C:\Programmi\Apache Software Foundation\Tomcat 5.5\common\lib

7)configuration Mysql- databse Alfresco. Open a window "command" and move to the directory C:\Alfresco\extras\databases\mysql.
Run db_setup.bat
At the end of the script should show a Text looks like this:
C:\Alfresco\extras\databases\mysql>db_setup.bat
Creating Alfresco database and user…
Enter password: ****
Database prepared.
C:\Alfresco\extras\databases\mysql>

8 )move the direcotry C:\Programmi\Apache Software Foundation\Tomcat 5.5\shared\classes and edit two files:

a)fisrt file is: custom-repository.properties
Commenting on the row with the connection for HSQL to entering a "#";
Remove the commentary on the line with the connection to MySQL;
Remove the commentary on the follw line:
db.username=alfresco
db.password=alfresco
db.pool.initial=10
db.pool.max=100

b)second file is: custom-hibernate-dialect.properties

Commenting on the row on the dialect HSQL to entering a "#";
Remove the commentary on the line MySQL.

9)Start Tomcat service and connect to http://127.0.0.1:8080/alfresco

NOTES!!!Errors found in the log file[b/]
org.alfresco.error.AlfrescoRuntimeException: Bootstrap failed

Before starting Alfresco, we must remove the "alf_data" you will find C: \ Program Files \ Apache Software Foundation \ Tomcat 5.5 \ alf_data.
When you create a new alfresco DB is necessary to delete that folder.

The second problem concerns the memory available from Tomcat to The Java virtual machine[b/]
We need to increase the values:
- initial memory pool;
- maximum memory pool;Ã¹
- thread stack size.

I hope to be of help to someone and not have given wrong information.
Thanks,

marco.