Jump to content

How to integrate Drupal and Alfresco

rev.dennis

By rev.dennis
in Drupal

 Share

Recommended Posts

rev.dennis Experienced

rev.dennis

Posted
Posted

Drupal is an excellent CMS used on millions of websites but it has always lacked a decent Document Management module.  This is where Alfresco comes in which is an excellent Document Management Repository but lacks any luster of a website.  These two together would prove to be a great pair / team.


 


Here are some sites that talk about methods to integrate the two of these together.



Link to comment
Share on other sites
Guest dennis

Guest dennis

Posted
Posted

Instructions



  1. Download CMIS from Drupal

  2. On your Drupal site, click Admin - Modules  and Click on Install New Module

  3. Click on Browse and locate the CMIS file you downloaded in step 1

  4. Once installed, click on enable newly installed module and place a checkmark in every option and then click Save Configuration

You have to configure the module "CMIS Browser" with: Set Root location for CMIS Browser (Root Directory / Root folder for CMIS nodes)



 





Link to comment
Share on other sites
Guest dennis

Guest dennis

Posted
Posted
  1. First I installed CentOS 7 minimal (static set ip during installation)

  2. logged in as root

  3. configured proxy in /etc/profile by adding the following at the bottom then running source /etc/profile

    1. MY_PROXY_URL="http://proxy.hosangit.com:8080/"



      HTTP_PROXY=$MY_PROXY_URL



      HTTPS_PROXY=$MY_PROXY_URL



      FTP_PROXY=$MY_PROXY_URL



      http_proxy=$MY_PROXY_URL



      https_proxy=$MY_PROXY_URL



      ftp_proxy=$MY_PROXY_URL



      export HTTP_PROXY HTTPS_PROXY FTP_PROXY http_proxy https_proxy ftp_proxy



       



  4. tested yum by updating the new installation with yum update (yum -y update)

  5. Two methods of a minimal Desktop installation

    1. OPTION1

      • yum -y groupinstall "X Window System"

      • yum -y install gnome-classic-session gnome-terminal nautilus-open-terminal control-center liberation-mono-fonts

      • unlink /etc/systemd/system/default.target

      • ln -sf /lib/systemd/system/graphical.target /etc/systemd/system/default.target

      • reboot

    2. OPTION2

      • yum groupinstall "GNOME Desktop" "Graphical Administration Tools"

      • yum groupinstall "Server with GUI"

      • ln -sf /lib/systemd/system/runlevel5.target /etc/systemd/system/default.target

      • reboot



  6. Since I'm running on a VMWare instance, I need a few things as prereq yum -y install gcc kernel-devel perl tcpdump net-tools

  7. Now mount the VMWare tools image and at your console while logged into root run:

    1. mkdir /mnt/cdrom   

    2. mount /dev/cdrom /mnt/cdrom  

    3. cd /tmp  

    4. tar -xvf /mnt/cdrom/VMWare...tar.gz  

    5. cd vmware-tools-distrib  

    6. chmod +x vmware-install.pl  

    7. ./vmware-install.pl



  8. Accept all the default settings (since the minimal installation doesn't have X windows installed, I suggest leaving the setting as no for drag and drop, shared folders, etc. that are only available for x-window systems like Gnome or KDE)

    1. Note: start VMware Tools by invoking: /usr/bin/vmware-toolbox-cmd

  9. upload alfresco....bin file to /tmp

  10. yum -y install mariadb-server mariadb

  11. Create the startup links

    1. systemctl start mariadb.service

    2. systemctl enable mariadb.service

  12. Set password for mysqldb root (i just accept all the defaults by pressing enter except I do enter a password when prompted)

    1. mysql_secure_installation

  13. Install Apache

    1. yum -y install httpd

  14. Create the startup links for Apache so it will start when the server does

    1. systemctl start httpd.service

    2. systemctl enable httpd.service

  15. Edit your built-in firewall to allow traffic

    1. firewall-cmd --permanent --zone=public --add-service=http

    2. firewall-cmd --permanent --zone=public --add-service=https

    3. firewall-cmd --reload

  16. Test by opening a browser and going to your ip address http://192.168.1.10

  17. Install PHP

    1. yum -y install php

    2. vi /etc/php.ini

      • memory_limit = 256M

      • post_max_size = 128M

      • upload_max_filesize = 256M

      • max_execution_time = 60

      • upload_tmp_dir = /var/www/html/tmp

    3. systemctl restart httpd.service



  18. Test PHP by creating info.php (vi /var/www/html/info.php)



    1. <?php phpinfo(); ?>





    2. Open a Browser http://192.168.1.10/info.php







  19. Get MySQL support in php (yum search php <-- shows you all the supported modules)

    1. yum -y install php-mysql php-gd php-ldap php-odbc php-pear php-xml php-xmlrpc php-mbstring php-snmp php-soap libssh2 libssh2-devel make php-devel curl curl-devel

    2. systemctl restart httpd.service

  20. Let's install phpMyAdmin

    1. yum -y install epel-release

    2. yum -y install phpMyAdmin

  21. Configure phpMyAdmin (vi /etc/httpd/conf.d/phpMyAdmin.conf)

    1. Replace:



      • Require ip 127.0.0.1



        Require ip ::1







      • # Require ip 127.0.0.1



        # Require ip ::1



        Require all granted





    2. systemctl restart  httpd.service

    3. Open a Browser http://192.168.1.10/phpmyadmin



  22. Done with the building the backend... now to load the CMS and then Alfresco



Link to comment
Share on other sites
Guest dennis

Guest dennis

Posted
Posted

Install Drupal Instructions (on CentOS 7 minimal install after doing the above install)



  1. Create drupal database

    1. mysql -u root -p

    2. MariaDB > CREATE DATABASE drupaldb;

    3. MariaDB > CREATE USER drupaluser@localhost IDENTIFIED BY 'drupalpassword';

    4. MariaDB > GRANT ALL PRIVILEGES ON drupaldb.* TO drupaluser@localhost;

    5. MariaDB > FLUSH PRIVILEGES;

    6. MariaDB > EXIT

    7. vi my.cnf

    8. max_allowed_packet=32M

    9. systemctl restart httpd.service

    10. systemctl restart mariadb.service

Installation of Open Atrium 2



  1. cd /tmp

  2. yum -y install wget unzip

  3. wget http://ftp.drupal.org/files/projects/openatrium-7.x-2.26-core.tar.gz

  4. cd /var/www/html

  5. tar -zxvf /tmp/openatrium-7.x-2.26-core.tar.gz

  6. mv openatrium-7.x-2.26/ oa2/

  7. cd /var/www/html/oa2/sites/default/

  8. cp -p default.settings.php settings.php

  9. cd /var/www/html/oa2

  10. chmod a+w sites/default/settings.php

  11. chmod a+w sites/default

  12. chcon -R -t httpd_sys_content_rw_t /var/www/html/oa2/sites/

  13. chown -R apache:apache /var/www/html/oa2

  14. vi /etc/selinux/config (changed to disabled which fixed Forbidden You don't have permission error when accessing site)

  15. open browser http://192.168.1.10/oa2

Note: I always pick Standard Installation



 



After installation



chmod 644 sites/default/settings.php


chmod 755 sites/default



Link to comment
Share on other sites
Guest dennis

Guest dennis

Posted
Posted

Install Alfresco



 



First I figured out you need to have a local browser to configure Alfresco so I install a minimal desktop on my server (not a fan of this but its needed). You could first try the text based browser Lynx but not sure this will work.  yum -y install lynx (configure lynx proxy here /etc/lynx.cfg)



  1. yum -y groupinstall "X Window System"

  2. yum -y install gnome-classic-session gnome-terminal nautilus-open-terminal control-center liberation-mono-fonts

  3. unlink /etc/systemd/system/default.target

  4. ln -sf /lib/systemd/system/graphical.target /etc/systemd/system/default.target

  5. reboot



Link to comment
Share on other sites
Guest dennis

Guest dennis

Posted
Posted

If you mess up the install, its not the end of the world.  What I do is delete and start fresh until I have a clean installation with no errors



 



When I had to reinstall open atrium I simply $ rm -rf /var/www/html/oa2



Then I went into phpmyadmin (http://192.168.1.10/phpmyadmin) and selected all tables in drupaldb and dropped them until I had an empty database again.



 



Started over with uploading the .tar.gz of oa2



Link to comment
Share on other sites
  • 3 weeks later...
Guest dennis

Guest dennis

Posted
Posted

Had to install firefox so I had a browser in the GUI (yum -y install firefox)



 



Now off to installing alfresco



PreReq's



  1. yum -y install fontconfig libSM libICE libXrender libXext

  2. hostname alfresco.hosangit.com

  3. ping alfresco.hosangit.com (verify it comes back with 127.0.0.1)

  4. vi /etc/hosts

    1. 127.0.0.1   localhost localhost.localdomain alfresco.hosangit.com

  5. vi /etc/sysconfig/network

    1. HOSTNAME=alfresco.hosangit.com

Install



cd /tmp



wget https://process.alfresco.com/ccdl/?file=release/community/5.0.c-build-00145/alfresco-community-5.0.c-installer-linux-x64.bin



chmod +x alfresco-community-5.0.c-installer-linux-x64.bin



./alfresco-community-5.0.c-installer-linux-x64.bin --mode text



firewall-cmd --zone=public --add-port=8080/tcp --permanent


firewall-cmd --zone=public --add-port=8005/tcp --permanent


firewall-cmd --zone=public --add-port=8443/tcp --permanent


firewall-cmd --zone=public --add-port=8009/tcp --permanent


firewall-cmd --reload



 



yoursite.com:8080/share



admin and password you entered during setup



 



Troubleshoot



Services



service alfresco stop # To stop Alfresco


service alfresco start # To start Alfresco


service alfresco restart # To restart Alfresco



Cleaner URL (instead of using 8080) if you have Apache (httpd) loaded just edit httpd.conf (vi /etc/httpd/conf/httpd.conf) and add the following lines to the end



ProxyPass /share http://localhost:8080/share


ProxyPassReverse /share http://localhost:8080/share


ProxyPass /alfresco http://localhost:8080/alfresco


ProxyPassReverse /alfresco http://localhost:8080/alfresco



 



Add the following to /var/www/html/oa2/sites/default/settings.php





$conf['cmis_repositories'] = array(

  'default' => array(

    'user' => 'admin',

    'password' => 'testlab',

    'url' => 'http://yoursite.com:8080/alfresco/cmisatom'

  )

);


Module CMIS VIews (leave "Set Root location for CMIS Broswer" blank)



 



http://yoursite.com/cmis/browser(tests that the cmis browser is working)



http://yoursite.com/cmis/query(another test)



Link to comment
Share on other sites
Guest dennis

Guest dennis

Posted
Posted

Rough steps:



  1. Install Atrium

  2. Install the CMIS and Alfresco CMIS modules like you would a normal Drupal module

  3. Expand the attached tar ball in sites/all/modules/features

  4. Replace theme.css with the attached in sites/all/themes/ginkgo

  5. Replace sprite_icons.png with the attached in sites/all/themes/ginkgo/images

  6. Set the CMIS settings. In your browser go to: atrium.localhost/admin/settings/cmis and specify Alfresco

  7. In your browser go to: atrium.localhost/admin/settings/cmis/alfresco and set your repository URL and credentials


     



Link to comment
Share on other sites
Guest dennis

Guest dennis

Posted
Posted

Error sharing folders in VMware Workstation 10 with CentOS 7



 



during install of vmware tools I get the following error





In file included from /tmp/modconfig-pM2CXU/vmhgfs-only/inode.c:36:0:

/tmp/modconfig-pM2CXU/vmhgfs-only/inode.c: In function ‘HgfsPermission’:

/tmp/modconfig-pM2CXU/vmhgfs-only/./shared/compat_dcache.h:57:38: error: ‘struct dentry’ has no member named ‘d_count’

 #define compat_d_count(dentry) dentry->d_count

                                      ^

/tmp/modconfig-pM2CXU/vmhgfs-only/inode.c:1904:23: note: in expansion of macro ‘compat_d_count’

          int dcount = compat_d_count(dentry);

                       ^

make: ***  Error 1

make: *** Waiting for unfinished jobs....

make: ***  Error 2

make: Leaving directory `/usr/src/kernels/3.10.0-123.13.2.el7.x86_64'

make: ***  Error 2

make: Leaving directory `/tmp/modconfig-pM2CXU/vmhgfs-only'



The filesystem driver (vmhgfs module) is used only for the shared folder

feature. The rest of the software provided by VMware Tools is designed to work

independently of this feature.



If you wish to have the shared folders feature, you can install the driver by

running vmware-config-tools.pl again after making sure that gcc, binutils, make

and the kernel sources for your running kernel are installed on your machine.

These packages are available on your distribution's installation CD.


Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...