Jump to content

How to integrate Drupal and Alfresco


Recommended Posts

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


  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

  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/"







      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

  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

  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

        Require ip ::1

      • # Require ip

        # Require ip ::1

        Require all granted

    2. systemctl restart  httpd.service

    3. Open a Browser

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

Link to comment
Share on other sites

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;


    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

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

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

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 ( 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

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


Now off to installing alfresco


  1. yum -y install fontconfig libSM libICE libXrender libXext

  2. hostname alfresco.hosangit.com

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

  4. vi /etc/hosts

    1.   localhost localhost.localdomain alfresco.hosangit.com

  5. vi /etc/sysconfig/network

    1. HOSTNAME=alfresco.hosangit.com


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



admin and password you entered during setup




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

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

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.

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.

  • Create New...