Alfresco with mysql DB

siquser — Wed, 19 Nov 2008 22:27:35 GMT

Has anybody tried to install MySQL? I need some help. Here is what I did1. Installed MySQL latest version on Windows. Ensured MySQL service is up-and-running, connected to a Test database & everything looks good here2. Installed TOMCAT Server. Ensured TOMCAT service is up-and-running3. Started I

Re: Alfresco with mysql DB

beren — Sat, 22 Nov 2008 13:34:30 GMT

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

Re: Alfresco with mysql DB

siquser — Mon, 24 Nov 2008 19:05:47 GMT

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 Userystem INFO [repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: C:\Alfresco\alf_data
10:57:13,403 Userystem INFO [admin.patch.PatchExecuter] Checking for patchesto apply …
10:57:13,693 Userystem INFO [admin.patch.PatchExecuter] No patches were required.
10:57:13,713 Userystem INFO [repo.module.ModuleServiceImpl] Found 0 module(s).
10:57:15,001 Userystem WARN [alfresco.util.OpenOfficeConnectionTester] An initial OpenOffice connection could not be established.
10:57:15,021 Userystem INFO [service.descriptor.DescriptorService] Alfresco JVM - v1.6.0_10-rc2-b32; maximum heap size 506.313MB
10:57:15,221 Userystem 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 Userystem 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 Userystem WARN [alfresco.linkvalidation.LinkValidationServiceImpl] LinkValidationService Update is not running (virtualization server not registered or started)
—————————————————————————–

topic Alfresco with mysql DB in Alfresco Archive

Alfresco with mysql DB

Re: Alfresco with mysql DB

Re: Alfresco with mysql DB