Alfresco with mysql DB
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-19-2008 05:27 PM
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?
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?
Labels:
- Labels:
-
Archive
2 REPLIES 2

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-22-2008 08:34 AM
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
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-24-2008 02:05 PM
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 User
ystem INFO [repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: C:\Alfresco\alf_data
10:57:13,403 User
ystem INFO [admin.patch.PatchExecuter] Checking for patchesto apply …
10:57:13,693 User
ystem INFO [admin.patch.PatchExecuter] No patches were required.
10:57:13,713 User
ystem INFO [repo.module.ModuleServiceImpl] Found 0 module(s).
10:57:15,001 User
ystem WARN [alfresco.util.OpenOfficeConnectionTester] An initial OpenOffice connection could not be established.
10:57:15,021 User
ystem INFO [service.descriptor.DescriptorService] Alfresco JVM - v1.6.0_10-rc2-b32; maximum heap size 506.313MB
10:57:15,221 User
ystem 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 User
ystem 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 User
ystem WARN [alfresco.linkvalidation.LinkValidationServiceImpl] LinkValidationService Update is not running (virtualization server not registered or started)
—————————————————————————–
—————————————————————————–
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 User

10:57:13,403 User

10:57:13,693 User

10:57:13,713 User

10:57:15,001 User

10:57:15,021 User

10:57:15,221 User

10:57:15,221 User

10:57:15,501 User

—————————————————————————–
