cancel
Showing results for 
Search instead for 
Did you mean: 

Not getting started

rogerp
Champ in-the-making
Champ in-the-making
Hi,

Q1: (Sorry, I had to edit my earlier post)
Using the main (i.e. full) Linux installer, I got (after a bit of persuasion) Alfresco Labs 3 running on top of Derby. Having followed the instructions about wiring in MySQL database support, I see that Alf has created the requisite tables in MySQL. When Alf starts up, I get no errors in the alfersco.log file..

When I load the page in a browser, the alfresco.log file gets an error that begins with:
11:34:49,411 ERROR [org.alfresco.repo.content.transform.magick.AbstractImageMagickContentTransformer] ImageMagickContentTransformer not available: Failed to perform ImageMagick transformation: 
Execution result:
   os:         Linux
   command:    [/usr/local/bin/convert, /home/sedlaptop1/Alfresco/tomcat/temp/Alfresco/ImageMagickContentTransformer_init_source_7124.gif, /home/sedlaptop1/Alfresco/tomcat/temp/Alfresco/ImageMagickContentTransformer_init_target_7125.png]
   succeeded:  false
   exit code:  1
   out:       
   err:        Cannot run program "/usr/local/bin/convert": java.io.IOException: error=2, No such file or directory
11:34:51,500 INFO  [org.alfresco.config.xml.XMLConfigService$PropertyConfigurer] Loading properties file from class path resource [alfresco/file-servers.properties]
11:34:55,648 ERROR [org.alfresco.repo.content.transform.RuntimeExecutableContentTransformer] Failed to start a runtime executable content transformer:
Execution result:
   os:         Linux
   command:    [/home/sedlaptop1/Alfresco/bin/pdf2swf, -V]
   succeeded:  false
   exit code:  1
   out:       
   err:        Cannot run program "/home/sedlaptop1/Alfresco/bin/pdf2swf": java.io.IOException: error=2, No such file or directory
11:35:01,288 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
11:35:01,688 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] No changes were made to the schema.
11:35:07,606 INFO  [org.alfresco.repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: /home/sedlaptop1/Alfresco/alf_data
11:35:07,651 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: The store 'avm://sitestore' has a duplicate root node entry.
   at org.alfresco.repo.admin.ConfigurationChecker.check(ConfigurationChecker.java:268)
The main culprit being
The store 'avm://sitestore' has a duplicate root node entry.
Under Derby, I had no such problem. I notice in the A/fresco/alf_data/lucene-indexes/avm/sitestore folder there are TWO folders, with long HEX names containing three files. – can someone tell me what this means and how I correct it? (localhost:8080/alfresco gives a 404 error.)

Q2:
If I go to localhost:8080/share/page/site-index I get the login but I haven't a clue what the username and password is. (I have tried admin/admin).  When Alf was running on top of Derby I changed the admin password (from Alfresco) but this new password doesn't work in Share either. Please tell me what to do.

Comments:
I don't know why the installation manual says you get a choice of database when you install. I certainly didn't. I am not convinced that the Open Office step during install worked either but I haven't got as far as testing it.

I tried installing under Glassfish v2 but gave up. GF is supposed to be a JEE reference implementation, I don't have the time to sort out the overrides to get Alf to work. Perhaps there's a definitive "Installing under Glassfish" somewhere, because the instructions in the manual didn't do it for me. The only point I can see of using GF over Tomcat is the control of database connections (e.g. pooling), so I'm not too bothered about using Tomcat.

Many thanks,

Roger
8 REPLIES 8

tvaughan77
Champ in-the-making
Champ in-the-making
Note: I'm not an alfresco guru or anything, but I have done about 8 installs in the last 2 months…

Q1

The error about ImageMagick is completely unrelated to the error about the avm:sitestore.  The former you can ignore, the latter you cannot.

Q2

You setup Alfresco, ran it under Derby, then changed the DB to MySQL?  That sounds like a recipe for disaster because Alfresco depends on a certain amount of consistency between the underlying database and the contents of ./alf_data.

If I were you, I'd:

1) Shut down alf

2) Delete alf_data/*

3) Drop the alfresco database from MySQL; then re-create it "create database alfresco;"

4) Restart

rogerp
Champ in-the-making
Champ in-the-making
Many thanks for your reply.
You setup Alfresco, ran it under Derby, then changed the DB to MySQL?  That sounds like a recipe for disaster because Alfresco depends on a certain amount of consistency between the underlying database and the contents of ./alf_data.
Since the install does not allow the choice of database, it starts off using Derby. There is a strong temptation to run alf when it's installed but I realise that generates Derby-specific artifacts. I would have thought that wiring in a different database would not require anything as drastic as you suggest. It's not mentioned in the manual as far as I can see.
If I were you, I'd:

1) Shut down alf

2) Delete alf_data/*

3) Drop the alfresco table from MySQL

4) Restart
Anyone else reading the above: After step 3) you probably also need to rerun the SQL script
mysql> source <alf-install>/extras/databases/mysql/db_setup.sql
Just for belt-and-braces, I carried out the above, checked that alf had reinstigated the database schema, I rebooted the machine (to ensure no traces of Tomcat were running), deleted alfresco.log and did ./alf_start.sh Here is the resulting alfresco.log file:
16:37:38,427 INFO  [org.alfresco.web.scripts.DeclarativeRegistry] Registered 67 Web Scripts (+0 failed), 71 URLs
16:37:38,428 INFO  [org.alfresco.web.scripts.AbstractRuntimeContainer] Initialised Presentation Web Script Container (in 662.08966ms)
16:38:39,368 INFO  [org.alfresco.web.scripts.DeclarativeRegistry] Registered 101 Web Scripts (+0 failed), 105 URLs
16:38:39,370 INFO  [org.alfresco.web.scripts.AbstractRuntimeContainer] Initialised WebFramework Web Script Container (in 60925.69ms)
16:38:39,601 INFO  [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework
16:38:43,841 INFO  [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework
16:39:03,931 ERROR [org.alfresco.repo.content.transform.magick.AbstractImageMagickContentTransformer] ImageMagickContentTransformer not available: Failed to perform ImageMagick transformation:
Execution result:
   os:         Linux
   command:    [/usr/local/bin/convert, /home/sedlaptop1/Alfresco/tomcat/temp/Alfresco/ImageMagickContentTransformer_init_source_33618.gif, /home/sedlaptop1/Alfresco/tomcat/temp/Alfresco/ImageMagickContentTransformer_init_target_33619.png]
   succeeded:  false
   exit code:  1
   out:       
   err:        Cannot run program "/usr/local/bin/convert": java.io.IOException: error=2, No such file or directory
16:39:06,307 INFO  [org.alfresco.config.xml.XMLConfigService$PropertyConfigurer] Loading properties file from class path resource [alfresco/file-servers.properties]
16:39:10,330 ERROR [org.alfresco.repo.content.transform.RuntimeExecutableContentTransformer] Failed to start a runtime executable content transformer:
Execution result:
   os:         Linux
   command:    [/home/sedlaptop1/Alfresco/bin/pdf2swf, -V]
   succeeded:  false
   exit code:  1
   out:       
   err:        Cannot run program "/home/sedlaptop1/Alfresco/bin/pdf2swf": java.io.IOException: error=2, No such file or directory
16:39:16,204 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
16:39:16,586 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] No changes were made to the schema.
16:39:22,663 INFO  [org.alfresco.repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: /home/sedlaptop1/Alfresco/alf_data
16:39:22,704 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: The store 'avm://sitestore' has a duplicate root node entry.
   at org.alfresco.repo.admin.ConfigurationChecker.check(ConfigurationChecker.java:268)
   at org.alfresco.repo.admin.ConfigurationChecker.access$000(ConfigurationChecker.java:72)
   at org.alfresco.repo.admin.ConfigurationChecker$1.execute(ConfigurationChecker.java:178)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:320)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:246)
   at org.alfresco.repo.admin.ConfigurationChecker.onBootstrap(ConfigurationChecker.java:182)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
   at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
   at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
   at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:830)
   at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:719)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
   at org.apache.catalina.core.StandardService.start(StandardService.java:516)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
So far, so bad.
Note: I'm not an alfresco guru or anything, but I have done about 8 installs in the last 2 months…
What's your favoured way of doing an install (full?, .war?)  and which version are you installing?

Thanks for your help.

tvaughan77
Champ in-the-making
Champ in-the-making
16:39:22,704 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: The store 'avm://sitestore' has a duplicate root node entry.
   at org.alfresco.repo.admin.ConfigurationChecker.check(ConfigurationChecker.java:268)

Ughh….I hate that error.

Try adding this to your tomcat/shared/classes/alfresco/extension/custom-repository.properties then restarting.

dir.root=/opt/alfresco/alf_data
dir.indexes=/opt/alfresco/alf_data/lucene-indexes
index.recovery.mode=AUTO

Anyone else reading the above: After step 3) you probably also need to rerun the SQL script
Actually, if you've already run the scripts in the past, you don't need to re-run the grant commands…just "create database alfresco".

Also, FYI - it's better/safer if you leave off the " with grant option;" section of the commands in that script…they're unnecessary (as far as I know…I've been running without them for 2 months) and dangerous.

What's your favoured way of doing an install (full?, .war?) and which version are you installing?

I'm running Labs3D/Stable on CentOs 5 (qa/production) and on Ubunutu 8.10 (locally).  I grab the Alfresco-Labs-3Stable-Linux-x86-Install and execute that, then I have a whole check list of "post install cleanup steps" I run through.  I can share those with you, if you like, but it'll be a separate post (there's lots of post-install steps 😉

rogerp
Champ in-the-making
Champ in-the-making
I'm surprised the database doesn't need a grant in order for alfresco to create its tables but if not (and it does strike me as odd that an unknown process/user is allowed to create arbitrary tables) then fine, you just need to create an empty database for alfresco to help itself to.

I would like to see your check lists (and I'm sure they would be useful to others like me); if you do not care to post them here, I would be very grateful if you could email them to me: roger.powell AT brunel.ac.uk

Actually, I have just about given up with the full Linux install and am partway through a bundled Tomcat install instead.

Many thanks!

tvaughan77
Champ in-the-making
Champ in-the-making
The thing with the grant option isn't so weird…if you've already run the script once, you've created a user named "alfresco" with permissions on a database named "alfresco."  If you blow away the database, the permissions don't get cascade deleted…

Anyway, here's my checklist for installing Alfresco labs3d stable on CentOS5

== Alfresco Installation ==

Notes taken during the March 12, 2009 installation of Alfresco Labs 3-Stable on myserver

0) Log in as root

1) Create user "alfresco" with home /opt/alfresco
useradd –home /opt/alfresco alfresco

2) Download Alfresco-Labs-3Stable-Linux-x86-Install (should exist in myserver//home/root/downloads among other places)

3) Make directory for alfresco, Run Alfresco-Labs-3Stable-Linux-x86-Install, set install location as /opt/alfresco

mkdir /opt/alfresco
chown alfresco.alfresco /opt/alfresco
su alfresco
[alfresco@myserver downloads]$ ./Alfresco-Labs-3Stable-Linux-x86-Install

This will install Alfresco Labs on your computer.  Continue? [n/Y] y


Where do you want to install Alfresco Labs? [/home/alfresco/Alfresco] /opt/alfresco

Installing Alfresco Labs…
Installing Program Files…
Installing Program Files Linux…
Installing JDBC Drivers…
Installing Samples…
Installing WCM…
Installing WCM Linux…
Installation complete.

4) The install script is a little ghetto and doesn't automatically change *.sh's @@ALFRESCO_DIR@@ to '''/opt/alfresco''' and all @@JAVA_HOME@@ to '''/usr/java/default'''.  Do that manually by editing all the /opt/alfresco/*.sh files and find and replace the tokens.

5) Installation Checkpoint:

/opt/alfresco/alf_start.sh &
tail -f /opt/alfresco/tomcat/logs/catalina.out

You'll see some errors about ImageMagick or pdf2swf or OpenOffice, but ignore those.  It takes about 2-3 minutes to fully boot.  The last line in the catalina.out file should say "INFO: Server startup in 116540 ms"

You should be able to hit [links|lynx] http://localhost:8080/alfresco and get a non-404 page

6) Shut down alfresco
/opt/alfresco/alf_stop.sh


== Alresco Cleanup (Optional) ==

Alfresco would like to have a variety of supporting applications installed along with it:

1) Install jpeg tools:
login as root
cd ~/downloads
wget http://www.ijg.org/files/jpegsrc.v6b.tar.gz
cd /usr/share
tar xzf ~/downloads/jpegsrc.v6b.tar.gz
cd jpeg6b
./configure
make
make install
chown -R root.root /usr/share/jpeg6b


2) Install swf2pdf
login as root
cd ~/downloads
wget http://www.swftools.org/swftools-0.8.1.tar.gz
cd /usr/share
tar xzf ~/downloads/swftools-0.8.1.tar.gz
cd swftools-0.8.1
./configure
make
make install
chown -R root.root /usr/share/swftools-0.8.1


3) Install ImageMagick:
sudo yum install ImageMagick

4) Organize some .sample files (trust me, these get annoying)
–as user alfresco
$ cd /opt/alfresco/tomcat/shared/classes/alfresco/extension
$ mkdir samples
$ mv *.sample samples

== Configuring Alfresco ==

1) Create a MySQL database and user for alfresco:

 
create database alfresco;

grant all on alfresco.* to 'alfresco'@'localhost' identified by 'secret';

grant all on alfresco.* to 'alfresco'@'localhost.localdomain' identified by 'secret';

2) Edit the custom-hibernate-dialect.properties file to "comment out" the DerbyDialect and comment in the MySQL dialect
#hibernate.dialect=org.hibernate.dialect.DerbyDialect
hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect

3) Edit the custom-repository.properties (not shown is the changes to the paths for ImageMagick, pdf2swf, etc…point to the right paths if you did the optional installation shown above)

# Change the dir.root to point to a full path
dir.root=/opt/alfresco/alf_data

# Add these two lines after dir.root
dir.indexes=/opt/alfresco/alf_data/lucene-indexes
index.recovery.mode=AUTO

# Comment in the db username and password
db.username=alfresco
db.password=alfresco

# Comment out the derby connection
#db.driver=org.apache.derby.jdbc.EmbeddedDriver
#db.url=jdbc:derby:alf_data/derby_data/alfresco;create=true

# Comment in the MySQL connection
db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql://localhost/alfresco

4) Edit the alfresco.sh start script

# Change the Java -Xmx to be 1024
export JAVA_OPTS='-Xms256m -Xmx1024m -XX:MaxPermSize=256m -server'

# Add this comment and line
#
#  Custom param that serves only as a 'marker' for kill process…see:
http://forums.alfresco.com/en/viewtopic.php?f=9&t=13763&p=49967
#
export JAVA_OPTS="${JAVA_OPTS} -DshutdownIdentifier=alfresco"

5) Edit the virtual properties to be accurate for the environment

# Change the virtserver domain property to be whatever the externally facing IP of this machine is (/sbin/ifconfig | grep inet)
# IMPORTANT — use dashes, not periods in separating the IP address bytes (for example 1-2-3-4 not 1.2.3.4)
alfresco.virtserver.domain=xx-xx-xx-xx.ip.alfrescodemo.net

# We'll be behind apache, so instead of 8180, run on 80
alfresco.virtserver.http.port=80

# You'll want to change the admin user's password, so pick one now and update the properties file in preparation for that
alfresco.server.password=secret

6) Delete the old crap in the alf_data directory left over from the first couple of "checkpoints" (above) when you started up alfresco:

$ cd /opt/alfresco
$ ./alf_stop.sh
$ rm -rf /opt/Alfresco/alf_data [do not do this during an upgrade or in the case where's there's actually valuable data in there]

== Running Alfresco Behind Apache ==

We won't use the mod_jk connector because all content will be served by Alfresco, so we'll just use the generic mod_proxy configuration:

1) Create a conf.d/alfresco.conf that's included by the httpd.conf file
{{{
<VirtualHost *:80>
  Include conf.d/alfresco.vhost
</VirtualHost>

<VirtualHost *:443>
  Include conf.d/alfresco.vhost
  SSLEngine on
</VirtualHost>
}}}

2) Create a conf.d/alfresco.vhost :
{{{
ServerName alfresco.mycompany.com

ProxyPass /  http://localhost:8080/
ProxyPreserveHost on
}}}

3) Edit the /opt/Alfresco/tomcat/conf/server.xml's Connector setting:
{{{
    <Connector port="8080" protocol="HTTP/1.1" URIEncoding="UTF-8"
               connectionTimeout="20000"
               redirectPort="8443"
               proxyPort="80" proxyName="alfresco.mycompany.com"
               />
}}}

== Post-Install Hammering ==



1) Change tomcat's repository.properties file to de-conflict with the virtualization server's need to have an RMI port at 50501:

tomcat/webapps/alfresco/WEB-INF/classes/alfresco/repository.properties


#
#  Changed the avm.rmi.service.port value from 50501 to 50509 because I was
# experiencing the same problem as described in this thread:
# http://forums.alfresco.com/en/viewtopic.php?f=9&t=15525
#
avm.rmi.service.port=50509

2) If you change the admin password from its default (and that's highly recommended), update the virtual-tomcat's /conf/alfresco-virtserver.properties with the new password

rogerp
Champ in-the-making
Champ in-the-making
Many thanks! I keep getting distracted to do other jobs so I still haven't got back to installing and configuring alfresco but this detail is really helpful. Should be a sticky! Very helpful indeed!  Smiley Very Happy

amatesi
Champ in-the-making
Champ in-the-making
5) Installation Checkpoint:

/opt/alfresco/alf_start.sh &
tail -f /opt/alfresco/tomcat/logs/catalina.out

You'll see some errors about ImageMagick or pdf2swf or OpenOffice, but ignore those.  It takes about 2-3 minutes to fully boot.  The last line in the catalina.out file should say "INFO: Server startup in 116540 ms"

You should be able to hit [links|lynx] http://localhost:8080/alfresco and get a non-404 page

Hi, I am stuck here…
I have Ubuntu 8.04 and Alfresco labs 3, after "giving it a start", once I go to localhost:8080/alfresco I get a 404 error page.

Ignoring OO, imagemagick and swf2pdf errors, my catalina.out log says the following:

GRAVE: Error listenerStart
24-mar-2009 18.24.58 org.apache.catalina.core.StandardContext start
GRAVE: Context [/alfresco] startup failed due to previous errors
log4j:ERROR LogMananger.repositorySelector was null likely due to error in class reloading, using NOPLoggerRepository.
log4j:WARN No appenders could be found for logger (org.quartz.core.JobRunShell).
log4j:WARN Please initialize the log4j system properly.
24-mar-2009 18.25.01 org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive studio.war
18:25:05,246  INFO  [web.scripts.DeclarativeRegistry] Registered 67 Web Scripts (+0 failed), 71 URLs
18:25:05,247  INFO  [web.scripts.AbstractRuntimeContainer] Initialised Presentation Web Script Container (in 401.16ms)
18:26:06,094  INFO  [web.scripts.DeclarativeRegistry] Registered 101 Web Scripts (+0 failed), 105 URLs
18:26:06,094  INFO  [web.scripts.AbstractRuntimeContainer] Initialised WebFramework Web Script Container (in 60827.492ms)
18:26:06,191  INFO  [web.site.FrameworkHelper] Successfully Initialized Web Framework
24-mar-2009 18.26.06 org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
24-mar-2009 18.26.06 org.apache.catalina.startup.Catalina start
INFO: Server startup in 143867 ms
"GRAVE" stands for "SEVERE" FYI

Here's my config:
ALF_HOME=/opt/alfresco
export JAVA_HOME="/usr/lib/jvm/java-6-sun-1.6.0.07"
* Permissions 775 Recursive for alfresco user/group inside /opt/alfresco & /media/alfresco/
* mysql DB alfresco up

custom-repository.properties:

dir.root=/media/alfresco/alf_data
# Add these two lines after dir.root
dir.indexes=/media/alfresco/alf_data/lucene-indexes
index.recovery.mode=AUTO
db.username=alfresco
db.password=alfresco
db.pool.initial=10
db.pool.max=100
#
# MySQL connection (This is default and requires mysql-connector-java-5.0.3-bin.jar, which ships with the Alfresco server)
#
db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql://localhost/alfresco

custom-hibernate-dialect.properties:

#^M
# MySQL dialect (default)^M
#^M
hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect
^M

EDIT:

just figured I had some problems with those ports so I changed them all in such way:

avm.rmi.service.port=50509
avmsync.rmi.service.port=50510
attribute.rmi.service.port=50511
authentication.rmi.service.port=50512
repo.rmi.service.port=50513
action.rmi.service.port=50514

any ideas?!

amatesi
Champ in-the-making
Champ in-the-making
In the mean time, I was able to figure out what my problem was related to: OpenOffice.
I had OO 2.4 from ubuntu 8.04 server official repos not working, next I tried OO 3.0.1 from launchpad repos and still the same exception (I swear I purged to death all oo-related packages…even non-related  :mrgreenSmiley Happy.

To make it short, I cleansed all and restarted from the beginning, this time with official OO.org 3.0.1 X86_64 DEBs.
I installed them like normal debs and still the exception Smiley Happy

here's my exceptional exception…

00:19:08,892 INFO  [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework
00:19:29,819 INFO  [org.alfresco.config.xml.XMLConfigService$PropertyConfigurer] Loading properties file from class path resource [alfresco/file-servers.properties]
00:19:43,926 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
00:19:44,495 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] No changes were made to the schema.
00:19:47,203 INFO  [org.alfresco.repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: /media/alfresco/alf_data
00:19:47,260 INFO  [org.alfresco.repo.admin.patch.PatchExecuter] Checking for patches to apply …
00:19:47,773 INFO  [org.alfresco.repo.admin.patch.PatchExecuter] No patches were required.
00:19:47,778 INFO  [org.alfresco.repo.module.ModuleServiceImpl] Found 0 module(s).
00:19:48,623 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
net.sf.jooreports.openoffice.connection.OpenOfficeException: connection failed: socket,host=localhost,port=8100,tcpNoDelay=1; com.sun.star.lang.DisposedException: java.io.IOException: com.sun.star.io.IOException: EOF reached - socket,host=localhost,port=8100,tcpNoDelay=1,localHost=localhost,localPort=34467,peerHost=localhost,peerPort=8100
        at net.sf.jooreports.openoffice.connection.AbstractOpenOfficeConnection.connect(AbstractOpenOfficeConnection.java:77)
        at org.alfresco.util.OpenOfficeConnectionTester.testAndConnect(OpenOfficeConnectionTester.java:157)
        at org.alfresco.util.OpenOfficeConnectionTester.checkConnection(OpenOfficeConnectionTester.java:128)
        at org.alfresco.util.OpenOfficeConnectionTester.onBootstrap(OpenOfficeConnectionTester.java:101)
        at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
        at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
        at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:830)
        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:719)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
        at org.apache.catalina.core.StandardService.start(StandardService.java:516)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
00:19:55,314 INFO  [org.alfresco.web.scripts.DeclarativeRegistry] Registered 67 Web Scripts (+0 failed), 71 URLs
00:19:55,316 INFO  [org.alfresco.web.scripts.AbstractRuntimeContainer] Initialised Presentation Web Script Container (in 638.5923ms)
00:20:56,440 INFO  [org.alfresco.web.scripts.DeclarativeRegistry] Registered 101 Web Scripts (+0 failed), 105 URLs
00:20:56,440 INFO  [org.alfresco.web.scripts.AbstractRuntimeContainer] Initialised WebFramework Web Script Container (in 61093.133ms)
00:20:56,541 INFO  [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework

here's my tomcat/shared/classes/alfresco/extension/bootstrap/openoffice-startup-context.xml


  <list>
                      <value>${ooo.exe}</value>
                      <value>-accept=socket,host=localhost,port=8100;urp;StarOffice.ServiceManager</value>
                      <value>-env:UserInstallation=file:///${ooo.user}</value>
                      <value>-nologo</value>
                      <value>-headless</value>
                      <value>-nofirststartwizard</value>
                      <value>-nocrashrep</value>
                      <value>-norestore</value>
                  </list>


I am sure I can write with the alfresco user inside /usr/lib/openoffice, inside the "oouser" and inside "dir.root" because I tried touch and vi with test files.