topic 3.2 Labs on Debian Lenny + PostgreSQL - fail in Alfresco Archive

3.2 Labs on Debian Lenny + PostgreSQL - fail

rysiek — Sun, 12 Jul 2009 22:11:32 GMT

Hi guys,I am trying to set-up Alfresco 3.2 Labs on Debian Lenny with PostgreSQL as the backend. I have followed:http://wiki.alfresco.com/wiki/Installing_Labs_3_Stable_on_Debian_Etchhttp://wiki.alfresco.com/wiki/Database_ConfigurationWhen I start Alfresco, the CPU usage surges for a few minutes, and

Re: 3.2 Labs on Debian Lenny + PostgreSQL - fail

mikef — Mon, 13 Jul 2009 09:01:42 GMT

Currently the 3.2 Community release does not support PostgreSQL. However, an update will provided to add support for PostgreSQL. An announcement will be be made on the Forums as soon as it is available.

thanks

Re: 3.2 Labs on Debian Lenny + PostgreSQL - fail

rysiek — Mon, 13 Jul 2009 09:25:04 GMT

Ok, thanks for the info. Any idea when that might be?

One has to wonder why isn't it mentioned on the release info page:
http://wiki.alfresco.com/wiki/Alfresco_Community_Edition_3.2
…which would save some people a day or too…

Cheers
Mike aka rysiek

Re: 3.2 Labs on Debian Lenny + PostgreSQL - fail

mikef — Mon, 13 Jul 2009 09:59:09 GMT

Our apologies for that, it was an oversight on our behalf. Information has now been added to the release notes http://wiki.alfresco.com/wiki/Alfresco_Community_Edition_3.2_Release_Notes
I'd expect the update in the next week or so.

Re: 3.2 Labs on Debian Lenny + PostgreSQL - fail

rysiek — Mon, 13 Jul 2009 13:08:41 GMT

thanks, that's great news! waiting and monitoring, then!

Cheers
MIke aka rysiek

Re: 3.2 Labs on Debian Lenny + PostgreSQL - fail

nancyg — Wed, 15 Jul 2009 18:53:12 GMT

Hi,

I just posted an announcements about the 3.2 database support scripst for PostgreSQL, you can find them here http://wiki.alfresco.com/wiki/Community_Edition_file_list.

Trying downloading the amp, I'm hoping that will resolve your issues.

Nancy

Re: 3.2 Labs on Debian Lenny + PostgreSQL - fail

rysiek — Thu, 16 Jul 2009 10:05:28 GMT

Hi,

thanks, downloaded and installed:
1. stopped Alfresco;
2. placed the file in /opt/Alfresco/amps/ dir;
3. run /opt/Alfresco/apply_amps.sh
4. started Alfresco;
5. tried to access myserver:8080/alfresco.

and got (after about 5 minutes of waiting!):

Error 404 - The requested resource () is not available.

There also have not been any tables created in the pgsql database. Should I create those manually somehow?

Seems like it didn't help much.

./apply_amps log:

# ./apply_amps.sh
./apply_amps.sh: line 7: /usr/lib/jvm/java-6-sun/bin: is a directory
This script will apply all the AMPs in ./amps to the alfresco.war file in /opt/Alfresco/tomcat/webapps
Press control-c to stop this script . . .
Press any other key to continue . . .
Module managment tool available commands:
———————————————————–

install: Installs a AMP file(s) into an Alfresco WAR file, updates if an older version is already installed.
usage:   install <AMPFileLocation> <WARFileLocation> [options]
valid options:
   -verbose   : enable verbose output
   -directory : indicates that the amp file location specified is a directory.
                All amp files found in the directory and its sub directories are installed.
   -force     : forces installation of AMP regardless of currently installed module version
   -preview   : previews installation of AMP without modifying WAR file
   -nobackup  : indicates that no backup should be made of the WAR

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

list:  Lists all the modules currently installed in an Alfresco WAR file.
usage: list <WARFileLocation>

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

Module 'org.alfresco.module.vti' installed in '/opt/Alfresco/tomcat/webapps/alfresco.war'
   -    Title:        Vti
   -    Version:      1.2
   -    Install Date: Thu Jul 16 10:55:14 CEST 2009
   -    Desription:   Alfresco Vti Extension
Module 'PostgreSQL.for.Alfresco.3.2.Community' installed in '/opt/Alfresco/tomcat/webapps/alfresco.war'
   -    Title:        PostgreSQL for Alfresco 3.2 (Community)
   -    Version:      1.0
   -    Install Date: Thu Jul 16 10:54:16 CEST 2009
   -    Desription:   Install ibatis sql-maps and sql scripts.
About to clean out tomcat/webapps/alfresco directory and temporary files…
Press control-c to stop this script . . .
Press any other key to continue . . .
Cleaning temporary Alfresco files from Tomcat…‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

alfresco.log:

11:39:13,494 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/repository.properties]
11:39:13,498 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/domain/transaction.properties]
11:39:13,498 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from URL [file:/opt/Alfresco/tomcat/shared/classes/alfresco-global.properties]
11:39:13,693 INFO  [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
11:49:28,413 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.remoting.rmi.RmiServiceExporter' defined in class path resource [alfresco/emailserver/email-service-context.xml]: Invocation of init method failed; nested exception is java.rmi.server.ExportException: internal error: ObjID already in use
Caused by: java.rmi.server.ExportException: internal error: ObjID already in use
   at sun.rmi.transport.ObjectTable.putTarget(ObjectTable.java:169)
   at sun.rmi.transport.Transport.exportObject(Transport.java:74)
   at sun.rmi.transport.tcp.TCPTransport.exportObject(TCPTransport.java:229)
   at sun.rmi.transport.tcp.TCPEndpoint.exportObject(TCPEndpoint.java:393)
   at sun.rmi.transport.LiveRef.exportObject(LiveRef.java:129)
   at sun.rmi.server.UnicastServerRef.exportObject(UnicastServerRef.java:190)
   at sun.rmi.registry.RegistryImpl.setup(RegistryImpl.java:92)
   at sun.rmi.registry.RegistryImpl.<init>(RegistryImpl.java:78)
   at java.rmi.registry.LocateRegistry.createRegistry(LocateRegistry.java:186)
   at org.springframework.remoting.rmi.RmiServiceExporter.getRegistry(RmiServiceExporter.java:398)
   at org.springframework.remoting.rmi.RmiServiceExporter.getRegistry(RmiServiceExporter.java:370)
   at org.springframework.remoting.rmi.RmiServiceExporter.getRegistry(RmiServiceExporter.java:331)
   at org.springframework.remoting.rmi.RmiServiceExporter.prepare(RmiServiceExporter.java:263)
   at org.springframework.remoting.rmi.RmiServiceExporter.afterPropertiesSet(RmiServiceExporter.java:227)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1203)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1172)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:427)
   at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:249)
   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:155)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:246)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
   at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:291)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:189)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:69)
   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.deployDescriptor(HostConfig.java:627)
   at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488)
   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)
11:53:04,152 INFO  [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework
11:53:07,323 INFO  [org.alfresco.config.JBossEnabledWebApplicationContext] Refreshing org.alfresco.config.JBossEnabledWebApplicationContext@6155e3: display name [Root WebApplicationContext]; startup date [Thu Jul 16 11:53:07 CEST 2009]; root of context hierarchy
11:53:08,048 INFO  [org.alfresco.config.JBossEnabledWebApplicationContext] Bean factory for application context [org.alfresco.config.JBossEnabledWebApplicationContext@6155e3]: org.springframework.beans.factory.support.DefaultListableBeanFactory@163d118
11:53:12,949 INFO  [org.alfresco.web.scripts.DeclarativeRegistry] Registered 24 Web Scripts (+0 failed), 26 URLs
11:53:12,979 INFO  [org.alfresco.web.scripts.AbstractRuntimeContainer] Initialised Presentation Web Script Container (in 475.9176ms)
11:53:13,317 INFO  [org.alfresco.web.scripts.DeclarativeRegistry] Registered 42 Web Scripts (+0 failed), 44 URLs
11:53:13,326 INFO  [org.alfresco.web.scripts.AbstractRuntimeContainer] Initialised WebFramework Web Script Container (in 339.73517ms)
11:53:13,429 INFO  [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework
11:53:24,266 INFO  [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: 3.2 Labs on Debian Lenny + PostgreSQL - fail

steve — Fri, 17 Jul 2009 08:48:20 GMT

Hi,

Your error is:

ObjID already in use

This is normally due to a previous instance of Alfresco not shutting down cleanly, or another app using the rmi port that Alfresco is trying to use - and not anything to do with the PostgreSQL use.
Have a search in these forums for your error - the most common way of getting rid of it is to reboot your machine to free up any ports that have been stuck open.

Steve

Re: 3.2 Labs on Debian Lenny + PostgreSQL - fail

rysiek — Fri, 17 Jul 2009 10:13:12 GMT

thanks, did a search and got it going.

for the record, the problem was due to a hostname change (in /etc/hostname and /etc/hosts); after a reboot (so that the new machine name was being used by alfresco) all works AOK.

I can't get it, though, why alfresco triesto connect to <machine_name> instead of simply using "localhost".

cheers

Re: 3.2 Labs on Debian Lenny + PostgreSQL - fail

logicrider — Sat, 07 Nov 2009 23:23:19 GMT

I had the same issue with Debian Lenny + Alfresco 3. I concluded that…

Problem: Error Starting Alfresco - java.rmi.server.ExportException: internal error: ObjID already in use

Symptoms:

Accessing http://localhost:8080/alfresco returns "Error 404 - The requested resource () is not available."

alfresco.log:
- org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.remoting.rmi.RmiServiceExporter' defined in class path resource [alfresco/emailserver/email-service-context.xml]: Invocation of init method failed; nested exception is java.rmi.server.ExportException: internal error: ObjID already in use
netstat -lpn shows that port 50500 (RMI port) is not in use

Pinging the hostname shows replies from an IP not in /etc/hosts

Cause: Alfresco needs to be able to connect to the server using its hostname

Solution:

Solution A

The hostname returned by 'hostname -a' should be defined in /etc/hosts as an IP active in the host. Examples:

/etc/hostname: myhost
/etc/hosts: 127.0.0.1 myhost

/etc/hostname: myhost
/etc/hosts: 192.168.0.2 myhost

alfresco webapp should be accessed through the hostname: http://myhost:8080/alfresco

Solution B

Access the alfresco webapp by IP: