regarding Ingres-Alfresco bundle

[ceci123]

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.tgz

I've trying to install Alfresco using this instructions (http://wiki.alfresco.com/wiki/Installing_Labs_3_on_Linux_with_command_line_interface#Change_HSQL_Dat... ) but I am not having any luck. I was wondering if anyone has successfully installed the above package and give me some advise. 

I posted my problem in installing here if you are interested but no one has responded yet. 
http://forums.alfresco.com/en/viewtopic.php?f=8&t=21373

Thank you for reading and hope you can give me some ideas on how to go about it.

Sincerely

Ceci

[ceci123]

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.

[dranakan]

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

[ceci123]

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

[ceci123]

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

[dranakan]

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 🙂

[ceci123]

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

[dranakan]

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

[ceci123]

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

[dranakan]

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 ?