cancel
Showing results for 
Search instead for 
Did you mean: 

Alfresco with mysql DB

siquser
Champ in-the-making
Champ in-the-making
Has anybody tried to install MySQL? I need some help. Here is what I did

1. Installed MySQL latest version on Windows. Ensured MySQL service is up-and-running, connected to a Test database & everything looks good here

2. Installed TOMCAT Server. Ensured TOMCAT service is up-and-running

3. Started Installing Alfresco, during installation I selected MySQL instead of Derby (I believe "Derby" was the 2nd option)
    Installation went thry w/o any issues

Problem
=======
Tried starting Alfresco Service, it opens up DOS windows displays some text & then closes saying "Failed".

Any idea?
2 REPLIES 2

beren
Champ in-the-making
Champ in-the-making
Can you start your server from a command line and paste the output here?

Why do you think this is a database issue?

Do you see the alfresco schema created in your database?

I have MySQL and it works fine with no issues so far. I'm running on Win32 (XP) with Tomcat.

beren

siquser
Champ in-the-making
Champ in-the-making
The following is the output that spit into command window before it closes itslef
—————————————————————————–
Nov 24, 2008 10:56:20 AM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Nov 24, 2008 10:56:20 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1063 ms
Nov 24, 2008 10:56:20 AM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Nov 24, 2008 10:56:20 AM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.18
Nov 24, 2008 10:56:20 AM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive alfresco.war
Nov 24, 2008 10:56:23 AM org.apache.catalina.core.StandardContext addApplicationListener
INFO: The listener "org.apache.myfaces.webapp.StartupServletContextListener" is already configured for this context. The duplicate definition has been ignored.
10:56:51,576  INFO  [config.xml.XMLConfigService$PropertyConfigurer] Loading properties file from class path resource [alfresco/file-servers.properties]
10:57:07,999  INFO  [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
10:57:09,028  INFO  [domain.schema.SchemaBootstrap] No changes were made to the schema.
10:57:10,756  ERROR [util.exec.RuntimeExecBootstrapBean] Bootstrap command failed:
Execution result:
   os:         Windows 2003
   command:    [C:/Alfresco/openoffice/OpenOffice.org 3/program/soffice, "-accep
t=socket,host=localhost,port=8100;urp;StarOffice.ServiceManager", "-env:UserInst
allation=file:///C:/Alfresco/alf_data/oouser", -nologo, -headless, -nofirststart
wizard, -nocrashrep, -norestore]
   succeeded:  false
   exit code:  2
   out:
   err:        Cannot run program "C:/Alfresco/openoffice/OpenOffice.org 3/program/soffice": CreateProcess error=3, The system cannot find the path specified
10:57:12,983 UserSmiley Frustratedystem INFO  [repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: C:\Alfresco\alf_data
10:57:13,403 UserSmiley Frustratedystem INFO  [admin.patch.PatchExecuter] Checking for patchesto apply …
10:57:13,693 UserSmiley Frustratedystem INFO  [admin.patch.PatchExecuter] No patches were required.
10:57:13,713 UserSmiley Frustratedystem INFO  [repo.module.ModuleServiceImpl] Found 0 module(s).
10:57:15,001 UserSmiley Frustratedystem WARN  [alfresco.util.OpenOfficeConnectionTester] An initial OpenOffice connection could not be established.
10:57:15,021 UserSmiley Frustratedystem INFO  [service.descriptor.DescriptorService] Alfresco JVM - v1.6.0_10-rc2-b32; maximum heap size 506.313MB
10:57:15,221 UserSmiley Frustratedystem INFO  [service.descriptor.DescriptorService] Alfresco license: Enterprise - v3.0 granted to Trial User limited to 30 days expiring Sat Dec 13 00:00:00 PST 2008 (19 days remaining)
10:57:15,221 UserSmiley Frustratedystem INFO  [service.descriptor.DescriptorService] Alfresco started (Enterprise): Current version 3.0.0 (r11498) schema 501 - Installed version 3.0.0 (r11498) schema 501
10:57:15,501 UserSmiley Frustratedystem WARN  [alfresco.linkvalidation.LinkValidationServiceImpl] LinkValidationService Update is not running (virtualization server not registered or started)
—————————————————————————–