Topic: Testing eGroupWare 1.6.002 on SME 8.0Beta4

[cool34000]

Hi all,

Here's a quick howto to install eGW 1.6 on SME 8...

Code: [Select]

## INSTALL
wget http://download.opensuse.org/repositories/server:/eGroupWare/CentOS_5/noarch/eGroupware-1.6.002-9.1.noarch.rpm
wget http://download.opensuse.org/repositories/server:/eGroupWare/CentOS_5/noarch/eGroupware-egw-pear-1.6.002-9.1.noarch.rpm
yum localinstall eGroupware-1.6.002-9.1.noarch.rpm eGroupware-egw-pear-1.6.002-9.1.noarch.rpm -y

## CREATE MySQL DB & USER
mysqladmin -u root create egroupware
mysql -e " grant all privileges on egroupware.* to 'egroupware'@'localhost' "
mysql -u root -e " SET PASSWORD FOR egroupware@localhost = PASSWORD( 'egroupware_db_password' ) "
mysqladmin flush-privileges

## FIXING SECURITY
chmod 666 /var/lib/egroupware/header.inc.php
chmod 777 /var/lib/egroupware/default/backup/
chmod 777 /var/lib/egroupware/default/files/

## APACHE CONFIG
rm /etc/httpd/conf.d/egroupware.conf
cat > /etc/e-smith/templates/etc/httpd/conf/httpd.conf/98eGroupWare << EOF

####################################
#  eGroupWare
####################################
Alias /egroupware /usr/share/egroupware
<Directory /usr/share/egroupware/>
  AddType application/x-httpd-php .php .php3 .phtml
  AddType text/xml .xml
  Options FollowSymLinks ExecCGI
  AllowOverride None
  Order allow,deny
  Allow from all
  DirectoryIndex index.html index.php
  AddHandler cgi-script .cgi
  AddDefaultCharset Off
  php_flag file_uploads on
  php_flag log_errors on
  php_flag magic_quotes_gpc off
  php_flag magic_quotes_runtime off
  php_flag register_globals off
  php_flag short_open_tag on
  php_flag track_vars on
  php_flag display_errors off
  php_value error_reporting 'E_ALL & ~E_NOTICE'
  php_value max_execution_time 90
  php_admin_value mbstring.func_overload 7
  php_value memory_limit 48M
  php_value session.gc_maxlifetime 14400
  php_value include_path .:/usr/share/pear
  php_value open_basedir /usr/share/egroupware:/var/lib/egroupware:/tmp:/usr/share/pear
  php_value upload_max_filesize 8M
  <Files ~ "\.inc\.php$">
    Order allow,deny
    Deny from all
  </Files>
</Directory>

<Directory /usr/share/egroupware/phpsysinfo/>
  php_value open_basedir /
</Directory>

<Location /egroupware/icalsrv/icalsrv.php>
    Script PUT /usr/share/egroupware/icalsrv/icalsrv.php
    AddHandler ical/ics .ics
    Action ical/ics /usr/share/egroupware/icalsrv/icalsrv.php
    Order allow,deny
    Allow from all
</Location>

<Location /egroupware/rpc.php>
    php_admin_value mbstring.func_overload 0
    Order allow,deny
    Allow from all
</Location>

EOF

## APPLY CHANGES
expand-template /etc/httpd/conf/httpd.conf
/etc/rc7.d/S86httpd-e-smith sigusr1

## SETUP EGROUPWARE
http://yourdomain.com/egroupware/setup

## ONCE INSTALLED, PUT SECURITY BACK
chmod 644 /var/lib/egroupware/header.inc.php

Enjoy 

[Stefano]

excellent

what about writing in the wiki also?

[cool34000]

Hi,

SME 8 is still in beta stage... I don't think this howto should be in the wiki right now. Time will come!

[soprom]

I like your script! It's straight forward. On the other hand, there has been many times when I needed to update eGroupware to correct bugs.  So now I install with svn... Some parts of your script could be easily adapted for anyone wanting this method.

This way, I can have both versions on the same system using /opt/egw16 and /opt/egw17 instead of /opt/egroupware.

Installation with svn:

# 1.7 = svn checkout http://svn.egroupware.org/egroupware/trunk/aliases/default .
# 1.6 = svn checkout http://svn.egroupware.org/egroupware/branches/1.6/aliases/default .

Code: [Select]

cd /opt/egroupware
svn checkout http://svn.egroupware.org/egroupware/trunk/aliases/default .
And for permissions, I use this:

Code: [Select]

#!/bin/sh
cd /opt/egroupware

# setperms
echo "...Setting file access rules :"
echo "   - Changing owner recursivly..."
chown -R root:www /opt/egroupware/egroupware

echo "   - Recursive CHMOD 550 on folders..."
find egroupware -type d -exec chmod 550 {} \;

echo "   - Recursive CHMOD 440 on files..."
find egroupware -type f -exec chmod 440 {} \;

echo "   - Customization of CHMOD for a few folders..."
chmod 770 /opt/egroupware/egroupware/phpgwapi/images
chown www /opt/egroupware/egroupware/header.inc.php
chmod 600 /opt/egroupware/egroupware/header.inc.php

echo "...Permissions Ok."
Thanks for your script with rpms...

[SchulzStefan]

@cool34000

Mhmm, egw 1.6x is running under SME 7.4. You only have to install php5 (centosplus). The rpm's are nearly running out of the box. You don't have to wait for SME 8.0. On my server (7.4 up-to-date) egw 1.6x is running rockstable. Syncing with an HTC Touch is perfect. No problem at all...

stefan

[Stefano]

@cool34000

Mhmm, egw 1.6x is running under SME 7.4. You only have to install php5 (centosplus). The rpm's are nearly running out of the box. You don't have to wait for SME 8.0. On my server (7.4 up-to-date) egw 1.6x is running rockstable. Syncing with an HTC Touch is perfect. No problem at all...

stefan

I think that the real intent of cool34000 was to demonstrate that upgrading to SME8 will not break anything (if you have EGW installed)

ciao

[cool34000]

Hi all,

@SchulzStefan
I know that eGW 1.6 (and lots of other webapps) will work with the "php5 CGI update"...
In fact, php5 CGI was already needed under eGW 1.4 if you wanted some sync functions to work properly (not all of them)

Lately, I was asked howto install eGW 1.6 on SME 8.0 so this is just an answer to it, and also one solution among others. SVN is another lead if you want to be really up to date: look at soprom's post...


@Stefano
This is only a "one shot test", but for a fresh install only!
RPMs (taken from CentOS5) are installing eGW in /usr/share but it will with no doubt break your existing version of eGW if you use the same web alias (/egroupware) and the same database & user for MySQL!

By the way, upgrading SME 7 to SME 8 with eGW already installed on it will work with RPMs available on contribs' wiki.
This howto is not intended to upgrade these RPMs in any kind of way.

[soprom]

Syncing with an HTC Touch is perfect. No problem at all...

stefan

I'd like to have some details on setting this up!  What do you sync with?

[SchulzStefan]

@soprom

funambol. https://www.forge.funambol.org/download/#

for further details have a look at:
http://www.egroupware.org/index.php?page_name=sync&lang=&wikipage=SyncMLFunambol

stefan