topic Re: regarding Ingres-Alfresco bundle in Alfresco Archive

regarding Ingres-Alfresco bundle

ceci123 — Fri, 28 Aug 2009 16:05:13 GMT

Has anyone installed the Ingres-Alfresco bundle from http://esd.ingres.com/product/Community_Projects/Ingres_Alfresco_Bundle/Appliances? Ingres-Alfresco-3.0.0stable-8-linux-installer.tgzI've trying to install Alfresco using this instructions (http://wiki.alfresco.com/wiki/Installing_Labs_3_on_Linux_

Re: regarding Ingres-Alfresco bundle

ceci123 — Sun, 30 Aug 2009 17:30:18 GMT

OK.

I finally managed to install this bundle. Now I have a different problem. I can't view the files on 'share'… I get a Web Script Status 500 - Internal Error

FULL ERROR posted here: http://forums.alfresco.com/en/viewtopic.php?f=36&t=21404

any idead?

thank you.

Re: regarding Ingres-Alfresco bundle

dranakan — Tue, 01 Sep 2009 15:22:45 GMT

Hello,

I am also using Ingres with Alfresco. I have get the same error… I just give you a link for the installation of Alfresco/Ingres (if you want/need more details, or want to use last version of product (Ingres 9.3))…

http://wiki.alfresco.com/wiki/Installing_Alfresco_Labs_3b_and_Ingres

For Alfresco 3.2 and Ingres 10 : http://wiki.alfresco.com/wiki/Installing_Alfresco_Community_32_and_Ingres_10

Good luck

Re: regarding Ingres-Alfresco bundle

ceci123 — Tue, 01 Sep 2009 18:28:59 GMT

Like I said, I installed Ingres-Alfresco-3.0.0stable-8-linux-installer.tgz and it seems to be working now.

I need to integrate it with Outlook 2007 but don't know where to begin.

Do you know how I can achieve this?

Thanks

Ceci

Re: regarding Ingres-Alfresco bundle

ceci123 — Mon, 07 Sep 2009 17:47:58 GMT

HI dranakan (or anyone who has done it)

have you been able to install Sharepoint Protocol for this bundle install?

if so, can you share your knowledge.

thank you

Re: regarding Ingres-Alfresco bundle

dranakan — Tue, 08 Sep 2009 06:41:49 GMT

Hello ceci123,

I have installed the office plugin to use word, Excel and Powerpoint (for 2003 and also 2007, they work). You can find this addons here : http://wiki.alfresco.com/wiki/Community_Edition_file_list

I have installed also the connector functionality for Microsoft SharePoint Protocol support (vti-module), but not on this bundle, but I think that there is no problem to use it. (to try to use the collaboration on a document)

You can do the same than other installation under Windows/MySql or Linux/otherDb with your bundle.

I have nothing done with Outlook 2007… but if your question is specific about it, your could better create another post with this subject…

Good luck 🙂

Re: regarding Ingres-Alfresco bundle

ceci123 — Tue, 08 Sep 2009 12:54:39 GMT

Hello dranakan.

thank you for the reply and the link to the plugins.

Did you use 'Module Management Tool' to install vti-module.amp (Microsoft SharePoint Protocol support )?
How well does it work?

I am assuming that you installed the following plugins

File   Description
alfresco-community-excel2003-addin-3.2.zip   Add-in for Microsoft Excel 2003
alfresco-community-office2003-addins-3.2.zip   Add-in for Microsoft Office 2003
alfresco-community-powerpoint2003-addin-3.2.zip   Add-in for Microsoft Powerpoint 2003
alfresco-community-word2003-addin-3.2.zip   Add-in for Microsoft Word 2003

With the above plugins, when you upload a word doc and open it from the Document Library, does it open in Word?

Right now(without the plugins) I can view it in word by going to:

Alfresco Share >> Document Library >> Documents >> Download >> and view with native application.

Thanks a lot for sharing your experience with Alfresco. As you can tell, I am very new in the Alfresco world.

Ceci

Re: regarding Ingres-Alfresco bundle

dranakan — Tue, 08 Sep 2009 14:04:13 GMT

Yes I have used the mmt to install vti-module.amp. Just go to the base folder of Alfresco, and use : apply_amps.sh (If you don't have with the Bundle, you can get it download a linux alfresco. Copy it. this script need also the bin/alfresco-mmt.jar). Sometimes it doesn't works for updating modules, but you can use the command (look in the script) and don't forget to remove the tomcat/webapps/alfresco.

You can just install alfresco-community-office2003-addins-3.2.zip Add-in for Microsoft Office 2003 if you want to use the three (Excel, Powerpoint and Word).
Becare that the link if for 3.2

I can't yet in my installation use the online edit for office document… but the are some help about it : http://wiki.alfresco.com/wiki/Main_Page (look at the right for help) it is about 3.2. Perhaps searching on the wiki will help you to find about 3.0.

Good luck

Re: regarding Ingres-Alfresco bundle

ceci123 — Thu, 10 Sep 2009 14:07:20 GMT

Hi dranakan.

I can't find the apply_amps.sh file anywhere…I don't think its included in the bundle.

I guess had I installed the non-bundle alfresco I wouldn't be so confused. Every time I google something about Alfresco…i see references to 'tomcat' or 'alfresco.
The bundle does not have 'tomcat' but 'apache-tomcat'.

When I looked at the bundle directories I find these directories:
apache-tomcat/ apps/ common/ img/ ingres/ java/ openoffice/ scripts/ Xvfb/

And under those directories these files are shown:
apache-tomcat/:
bin common conf LICENSE logs NOTICE RELEASE-NOTES RUNNING.txt scripts server shared temp webapps work

apps/:
alfresco

common/:
bin include lib man share

img/:
alfresco.ico bitnami.ico

ingres/:
bin ckp data demo dmp files install jnl lib log scripts setalfrescoingresvars.sh setenv.sh setingresvars.sh sig utility vdba version.rel work

java/:
bin db include lib man README_ja.html register.html register_zh_CN.html THIRDPARTYLICENSEREADME.txt
COPYRIGHT demo jre LICENSE README.html README_zh_CN.html register_ja.html sample

openoffice/:
help LICENSE LICENSE.html licenses presets program README README.html readmes scripts settings share soffice.bin.pid THIRDPARTYLICENSEREADME.html

scripts/:
ingres setenv.sh

Xvfb/:
bin misc var

So when you say "Copy it. this script need also the bin/alfresco-mmt.jar" I am assuming you are referring to the apache-tomcat/bin in my case. Correct?
Sorry I have not worked with .jar files that much.

Any addition knowledge you can share in installing other Alfresco components would be greatly appreciated. I am sure once I manage to install one, everything will start to make sense.

Thanks

Ceci

Re: regarding Ingres-Alfresco bundle

dranakan — Thu, 10 Sep 2009 14:46:46 GMT

Hello Ceci,

I will help you to add a module inside alfresco. I don't know if it's necessary to add vti for what you want (I let you check it).

You could find the apply.sh with a no bundle alfreco. This script will put the modules in the directories "amps" inside your "alfresco.war". This script is like this :


#!/bin/sh
# ——-
# Script for apply AMPs to installed WAR
# ——-
ALF_HOME=/opt/Alfresco3
export JAVA_HOME="/usr"
export PATH=$PATH;$JAVA_HOME/bin
cd "$ALF_HOME"
APPSERVER="$ALF_HOME"/tomcat
echo "This script will apply all the AMPs in ./amps to the alfresco.war file in $APPSERVER/webapps"
echo "Press control-c to stop this script . . ."
read -p "Press any other key to continue . . ."
java -jar bin/alfresco-mmt.jar install ./amps $APPSERVER/webapps/alfresco.war -directory
java -jar bin/alfresco-mmt.jar list $APPSERVER/webapps/alfresco.war
echo "About to clean out tomcat/webapps/alfresco directory and temporary files…"
echo "Press control-c to stop this script . . ."
read -p "Press any other key to continue . . ."
rm -rf $APPSERVER/webapps/alfresco
sh $ALF_HOME/bin/clean_tomcat.sh
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

If you want to add some modules inside your alfresco.war, you need to use the command which executes the alfresco-mmt-jar. Alfresco is in the directory (adapt if it is not like this in your install)

1) Take inside a non-bundle the alfresco-mmt.jar and copy it in /. Copy also the module that you want to add
2) Stop Alfresco and use this command to add your module


cd /
java -jar alfresco-mmt.jar install THE_MODULE_YOU_WANT /apache-tomcat/webapps/alfresco.war -verbose
‍‍‍‍

3) Remove the directory apache-tomcat/webapps/alfresco. It will be recreate at the startup of alfresco (from the alfresco.war).
4) Start Alfresco

All is good ?

Re: regarding Ingres-Alfresco bundle

ceci123 — Thu, 10 Sep 2009 17:26:18 GMT

Thank you for the detailed explanation. That helps a lot.

Unfortunately, my boss has decided to use Sharepoint instead.

I will try implementing it for my own curiosity.

Thank you

Ceci