Alfresco and Mysql [SOLVED]

[dteca]

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 of the installation I report the following error:


n error has occurred during installation
An error has occurred during installation
couldn't open "C:/Alfresco/.installinfo": permission denied
while executing
"open $file $mode"
(procedure "::InstallJammer:toreInfo" line 7)
invoked from within
"::InstallJammer:toreInfo $info(InstallDir)"
(procedure "::InstallJammer::actions::InstallSelectedFiles" line 99)
invoked from within
"::InstallJammer::actions::$type $obj"
while executing
"::InstallJammer::ExecuteActions $action -parent $id -conditions $eval"
(procedure "::InstallJammer::actions::ExecuteAction" line 6)
invoked from within
"::InstallJammer::actions::$type $obj"
An error has occurred during installation
An error has occurred during installation
couldn't open "C:/Alfresco/.installinfo": permission denied
while executing
"open $file $mode"
(procedure "::InstallJammer:toreInfo" line 7)
invoked from within
"::InstallJammer:toreInfo $info(InstallDir)"
(procedure "::InstallJammer::actions::InstallSelectedFiles" line 99)
invoked from within
"::InstallJammer::actions::$type $obj"
while executing
"::InstallJammer::ExecuteActions $action -parent $id -conditions $eval"
(procedure "::InstallJammer::actions::ExecuteAction" line 6)
invoked from within
"::InstallJammer::actions::$type $obj"
while executing
"::InstallJammer::ExecuteActions $id -when $when"
(procedure "::InstallJammer::RaiseEventHandler" line 80)
invoked from within
"::InstallJammer::RaiseEventHandler .wizard"
(command bound to event)

[dteca]

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

[mikeh]

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

[dteca]

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

[mikeh]

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

[dteca]

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.