Koozali.org: home of the SME Server

Obsolete Releases => SME 7.x Contribs => Topic started by: SchulzStefan on October 31, 2006, 07:14:52 PM

Title: HOW-TO install open-Xchange 0.8.2 from vincent
Post by: SchulzStefan on October 31, 2006, 07:14:52 PM

Someone should remove my earlier post (20.06.06). It's obsolete.

For everybody some instructions for an installation without trouble: (This works for me - no guarantee that it works for you.)

1.) get all files from http://smeserver.free.fr/files/index.php?dir=open-xchange/ox7/ (thx to vincent who did and is still doing a great job!) You'll probably need only one icon-set.

2.) Change in /etc/e-smith/templates/etc/httpd/conf/httpd.conf the template 86WebShareAlias in:

- snip
    local %WebShare;
#   tie %WebShare, 'esmith::config', '/home/e-smith/WebShare';
    tie %WebShare, 'esmith::config', '/home/e-smith/db/WebShare';

        my $webshare;
- snip

expand-template /etc/httpd/conf/httpd.conf
/etc/init.d/httpd-e-smith restart

see the bug list for this. Thx to Ray.

3.) install from a local directory with yum localinstall *.rpm

4.) in the case that files are missing, get them from http://mirror.centos.org/centos/4/os/i386/CentOS/RPMS/

4.1.) run again yum localinstall *.rpm

5.) don't forget signal-event post-upgrade/reboot!

6.) now proceed with this (thx to Jay!):

### Clean up postgres
service postgresql stop
cd /var/lib/pgsql
rm -rf *
service postgresql start
service postgresql stop
expand-template /var/lib/pgsql/data/postgresql.conf
expand-template /var/lib/pgsql/data/pg_hba.conf
service tomcat restart
service postgresql restart
service open-xchange restart

#### Kick LDAP
service ldap stop
rm /home/e-smith/db/ldap/*ldif
rm /var/lib/ldap/*
signal-event ldap-update
service ldap restart

7.) Modify the /usr/local/open-xchange/share/rebuild_db.sh: missing user "postgres". Here's the correct script:

#!/bin/bash
# create de postgresql database for OX
# by filali.v@free.fr
# Vincent FILALI-ANSARY
#

[ ! -d /home/e-smith/db/pgsql ] && mkdir /home/e-smith/db/pgsql
su postgres -c'pg_dump -Fc -b openexchange -v' >/home/e-smith/db/pgsql/openexchange.sql.back

su - -c'dropdb openexchange' postgres
su - -c'dropuser openexchange' postgres

su - -c'createdb -e --template=template0 -E UNICODE -e openexchange' postgres
su - -c'psql -a -e -d openexchange -e -f /usr/local/open-xchange/share/createuser.sql' postgres
#su - -c'createuser -A -d -P -E -e openexchange' postgres
#su - -c'createdb -O openexchange -E UNICODE -e openexchange' postgres
su - -c'psql -a -e -d openexchange -f /usr/local/open-xchange/share/init_database.sql' postgres
su - -c'psql -a -e -d openexchange -f /usr/local/open-xchange/share/admin_last.sql' postgres

if [ -x /usr/local/open-xchange/share/add_syncml_db.sh ]; then
    . /usr/local/open-xchange/share/add_syncml_db.sh
fi

8.) Modify /usr/local/open-xchange/sbin/backup_ox: Here's the correct script:

#!/bin/bash
#
# by vincent Filali-ansary filali.v@free.fr
#

PATH=/usr/local/sbin:$PATH
export PATH


function OXbackup() {
    DOM=`/sbin/e-smith/db configuration get DomainName`

    service ldap restart 2>&1 >/dev/null
    cp -f /home/e-smith/db/ldap/${DOM}.ldif /home/e-smith/db/ldap/${DOM}.ldif.bak

    [ ! -d /home/e-smith/db/pgsql ] && mkdir /home/e-smith/db/pgsql
    su postgres -c'pg_dump -Fc -b openexchange -v' > /home/e-smith/db/pgsql/ox_${DOM}.sql
   
    [ ! -d /home/e-smith/open-xchange ] && mkdir /home/e-smith/open-xchange
    /usr/bin/rsync -aur --delete /usr/local/open-xchange/var /home/e-smith/open-xchange  
}

function OXbackupHa() {
    DOM=`/sbin/e-smith/db configuration get DomainName`

    service ldap restart 2>&1 >/dev/null
    cp -f /home/e-smith/db/ldap/${DOM}.ldif /home/e-smith/db/ldap/${DOM}.ldif.bak
    [ ! -d /home/e-smith/files/db/ldap ] && mkdir -p /home/e-smith/files/db/ldap
    cp -f /home/e-smith/db/ldap/${DOM}.ldif /home/e-smith/files/db/ldap/${DOM}.ldif
    cp -f /home/e-smith/db/ldap/${DOM}.ldif /home/e-smith/files/db/ldap/${DOM}.ldif.bak

    [ ! -d /home/e-smith/db/pgsql ] && mkdir /home/e-smith/db/pgsql
    su postgres -c'pg_dump -Fc -b openexchange -v' > /home/e-smith/db/pgsql/ox_${DOM}.sql
    [ ! -d /home/e-smith/files/db/pgsql ] && mkdir -p /home/e-smith/files/db/pgsql
    su postgres -c'pg_dump -Fc -b openexchange -v' > /home/e-smith/files/db/pgsql/ox_${DOM}.sql
 
    [ ! -d /home/e-smith/open-xchange ] && mkdir /home/e-smith/open-xchange
    /usr/bin/rsync -aur --delete /usr/local/open-xchange/var /home/e-smith/open-xchange  

    [ ! -d /home/e-smith/files/saves/open-xchange ] && mkdir -p /home/e-smith/files/saves/open-xchange
    /usr/bin/rsync -aur --delete /usr/local/open-xchange/var /home/e-smith/files/saves/open-xchange  
}

# check for heartbeat system
if [ -x /usr/local/sbin/getnode ]; then
    MYNODE=`getnode`
    HERIP=`getnode --mirror --ip`
    HERNAME=`getnode --mirror`
    # first thing verify if whe are the active node
    ACTIV=`/sbin/e-smith/db heartbeat getprop nodes Active`

    if [ $MYNODE == $ACTIV ]; then
   OXbackupHa
    fi
else
    OXbackup
fi

8.) Modify /usr/local/open-xchange/sbin/restore_ox: Here's the correct script:

#!/bin/bash

PATH=/usr/local/sbin:$PATH
export PATH

function StopServices() {
    #########################################################################
    [ -x /etc/rc.d/init.d/oxserve-scandir ] && /etc/init.d/oxserve-scandir stop 2>&1 >/dev/null
    [ -x /etc/rc.d/init.d/oxserve-index ] && /etc/init.d/oxserve-index stop 2>&1 >/dev/null
    service open-xchange stop 2>&1 >/dev/null
    service postgresql stop 2>&1 >/dev/null
    service ldap stop 2>&1 >/dev/null
}

function StartServices() {
    #########################################################################
    service service postgresql start 2>&1 >/dev/null
    service service ldap start 2>&1 >/dev/null
    service open-xchange start 2>&1 >/dev/null
    [ -x /etc/rc.d/init.d/oxserve-scandir ] && service oxserve-scandir start 2>&1 >/dev/null
    [ -x /etc/rc.d/init.d/oxserve-index ] && service oxserve-index start 2>&1 >/dev/null
}

function RestoreOX() {
    DOMAIN=`/sbin/e-smith/db configuration get DomainName`
    if [ -z $DOMAIN ]; then
   echo "error : the domain is unknow"
   exit 1
    fi
    if [ ! -f /home/e-smith/db/pgsql/ox_$DOMAIN.sql ]; then
   echo "error : "
   echo "file /home/e-smith/db/pgsql/ox_$DOMAIN.sql doesn't exists, unable to restore"
   exit 1
    fi
    if [ ! -f /home/e-smith/db/ldap/$DOMAIN.ldif.bak ]; then
   echo "error : "
   echo "file /home/e-smith/db/ldap/$DOMAIN.ldif.bak doesn't exists, unable to restore"
   exit 1
    fi
    if [ ! -d /home/e-smith/open-xchange ]; then
   echo "error : "
   echo "files /home/e-smith/open-xchange/ doesn't exists, unable to restore"
   exit 1
    fi

    StopServices

    ##########################################################################
    # LDAP
    rm -f /var/lib/ldap/*
    slapadd -l /home/e-smith/db/ldap/$DOMAIN.ldif.bak
    chown -R ldap:ldap /var/lib/ldap
    service ldap start 2>&1 >/dev/null

    ###########################################################################
    # Postgresql

    /sbin/e-smith/expand-template /var/lib/pgsql/data/postgresql.conf
    /sbin/e-smith/expand-template /var/lib/pgsql/data/pg_hba.conf
    chown -R postgres:postgres /var/lib/pgsql
    chmod 600 /var/lib/pgsql/data/postgresql.conf
    chmod 600 /var/lib/pgsql/data/pg_hba.conf

    service postgresql start 2>&1 >/dev/null
    su postgres -c'pg_dump -Fc -b openexchange -v' > /home/e-smith/db/pgsql/openexchange.sql.bak
    su - -c'dropdb openexchange' postgres
    su - -c'dropuser openexchange' postgres
    su - -c'createdb --template=template0 -E UNICODE -e openexchange' postgres
    su - -c'psql -a -e -d openexchange -e -f /usr/local/open-xchange/share/createuser.sql' postgres
   
    rm -f /tmp/temp_ox.sh
    cat <<-EOF >/tmp/temp_ox.sh
#!/bin/bash
su postgres -c'pg_restore -d openexchange -v /home/e-smith/db/pgsql/ox_${DOMAIN}.sql'

EOF
    chmod 755 /tmp/temp_ox.sh
    exec /tmp/temp_ox.sh
    rm -f /tmp/temp_ox.sh

    # check for an upgrade
    if [ -x /usr/local/open-xchange/share/upgrades/check4upgrade.sh ]; then
   /usr/local/open-xchange/share/upgrades/check4upgrade.sh
    fi

    ###############################################################################
    # FILES

    /usr/bin/rsync -aur --delete /home/e-smith/open-xchange/var /usr/local/open-xchange

    StartServices

}
##############################################################################################################################################

function RestoreOXHA() {
    DOMAIN=`/sbin/e-smith/db configuration get DomainName`
    if [ -z $DOMAIN ]; then
   echo "error : the domain is unknow"
   exit 1
    fi
    if [ ! -f /home/e-smith/files/db/pgsql/ox_$DOMAIN.sql ]; then
   echo "error : "
   echo "file /home/e-smith/files/db/pgsql/ox_$DOMAIN.sql doesn't exists, unable to restore"
   exit 1
    fi
    if [ ! -f /home/e-smith/files/db/ldap/$DOMAIN.ldif.bak ]; then
   echo "error : "
   echo "file /home/e-smith/files/db/ldap/$DOMAIN.ldif.bak doesn't exists, unable to restore"
   exit 1
    fi
    if [ ! -d /home/e-smith/files/saves/open-xchange ]; then
   echo "error : "
   echo "files /home/e-smith/files/saves/open-xchange/ doesn't exists, unable to restore"
   exit 1
    fi

    StopServices


    ##########################################################################
    # LDAP
    rm -f /var/lib/ldap/*
    slapadd -l /home/e-smith/files/db/ldap/$DOMAIN.ldif.bak
    chown -R ldap:ldap /var/lib/ldap
    service ldap start 2>&1 >/dev/null

    ###########################################################################
    # Postgresql

    /sbin/e-smith/expand-template /var/lib/pgsql/data/postgresql.conf
    /sbin/e-smith/expand-template /var/lib/pgsql/data/pg_hba.conf
    chown -R postgres:postgres /var/lib/pgsql
    chmod 600 /var/lib/pgsql/data/postgresql.conf
    chmod 600 /var/lib/pgsql/data/pg_hba.conf

    service postgresql start 2>&1 >/dev/null
    su postgres -c'pg_dump -Fc -b openexchange -v' > /home/e-smith/files/db/pgsql/openexchange.sql.bak
    su - -c'dropdb openexchange' postgres
    su - -c'dropuser openexchange' postgres
    su - -c'createdb --template=template0 -E UNICODE -e openexchange' postgres
    su - -c'psql -a -e -d openexchange -e -f /usr/local/open-xchange/share/createuser.sql' postgres

    rm -f /tmp/temp_ox.sh
    cat <<-EOF >/tmp/temp_ox.sh
#!/bin/bash
su postgres -c'pg_restore -d openexchange -v /home/e-smith/db/pgsql/ox_${DOMAIN}.sql'

EOF
    chmod 755 /tmp/temp_ox.sh
    exec /tmp/temp_ox.sh
    rm -f /tmp/temp_ox.sh

    # check for an upgrade
    if [ -x /usr/local/open-xchange/share/upgrades/check4upgrade.sh ]; then
   /usr/local/open-xchange/share/upgrades/check4upgrade.sh
    fi

    ###############################################################################
    # FILES

    /usr/bin/rsync -aur --delete /home/e-smith/files/saves/open-xchange/var /usr/local/open-xchange

    StartServices

}
###################################################################################################################
# check for heartbeat system
if [ -x /usr/local/sbin/getnode ]; then
    MYNODE=`getnode`
    HERIP=`getnode --mirror --ip`
    HERNAME=`getnode --mirror`
    # first thing verify if whe are the active node
    ACTIV=`/sbin/e-smith/db heartbeat getprop nodes Active`

    if [ $MYNODE == $ACTIV ]; then
   RestoreOXHA
    fi
else
    RestoreOX
fi


9.) Modify /usr/local/open-xchange/sbin/deluser_ox: Here's the correct script:

#!/bin/bash
#
# (c) 2004-2100 ;)
# Author: cutmasta AT netline-is D0T de
#
#
# This Script dels OX User from the LDAP!
# TODO : DELETE personal adressbook completely if he has entries in that!
#
#
# GLOBAL CONFIGFILE
prefix=/usr/local/open-xchange
exec_prefix=${prefix}

GLOBAL_CONF="${prefix}/etc/admintools.conf"

if [ -f $GLOBAL_CONF ]
    then
    . $GLOBAL_CONF
    else
    echo "Config File $GLOBAL_CONF not found."
    exit 0
fi

ac_prev=
for ac_option
do
  if test -n "$ac_prev"; then
    eval "$ac_prev=\$ac_option"
    ac_prev=
    continue
  fi
  case "$ac_option" in
      -*=*) ac_optarg=`echo "$ac_option" | $SED_BIN 's/[-_a-zA-Z0-9]*=//'` ;;
      *) ac_optarg= ;;
  esac
 
  case "$ac_option" in
     
      --username)
     ac_prev=username ;;
      --username=*)
     USERNAME=$ac_optarg ;;

     

      -help | --help | -? | --?)
     
     cat <<EOF

Usage: $0 [Options]

Options:
  --username=NAME              The Username - eg. john

EOF

     exit 0
     
     ;;
     
      *)    
     echo "Unknown command $ac_option"
     echo "Try $0 --help"
     exit 1
     ;;
  esac
 
done

ERROR=

if [ "$USERNAME" = "" ]
then
        ERROR="y"
        echo "Specify an Username!"
fi


if [ "$ERROR" = "y" ]
then
   echo "Please provide an Username!"
   echo "Try $0 --help"
   exit 0 ;
fi

#LDAP_DELETE_ADR=`$LDAPDELETE_BIN $LDAPCONN "ou=addr,uid=$USERNAME,$USER_BASEDN" 2>&1 | $GREP_BIN Delete | $AWK_BIN -F'(' {'print $2'} | $AWK_BIN -F')' {'print $1'}`

## DELETE RECURSIVE ALL USER STUFF FROM LDAP
LDAP_DELETE=`$LDAPDELETE_BIN $LDAPCONN -r "uid=$USERNAME,$USER_BASEDN" 2>&1 | $GREP_BIN Delete | $AWK_BIN -F'(' {'print $2'} | $AWK_BIN -F')' {'print $1'}`


# delete the user from the adressadmins
echo "dn: $GLOBAL_ADDRESSBOOK_ADMINSDN " > $TMPDIF
echo "changetype: modify" >> $TMPDIF
echo "delete: member" >> $TMPDIF
echo "member: uid=$USERNAME,$USER_BASEDN" >> $TMPDIF

LDAP_DELETE_ADDRESSADMIN=`$LDAPMODIFY_BIN $LDAPCONN -f $TMPDIF 2>&1 | $GREP_BIN ldap_modify | $AWK_BIN -F'(' {'print $2'} | $AWK_BIN -F')' {'print $1'}`
rm $TMPDIF

OX_OBJECTS_DELETE=`/usr/local/java/bin/java -Dopenexchange.propfile=/usr/local/open-xchange/etc/groupware/system.properties -classpath /usr/local/open-xchange/lib/intranet.jar:/usr/local/open-xchange/lib/comfiretools.jar:/usr/local/open-xchange/lib/nas.jar:/usr/local/share/java/pg74.216.jdbc3.jar com.openexchange.groupware.deleteUserGroups deleteUser $USERNAME`

esc=`echo -en "\033"`
warn="${esc}[1;31m"
done="${esc}[1;32m"
info="${esc}[1;33m"

case "$LDAP_DELETE" in
   
    "")
   echo "${done}LDAP Success!"

   if [ "$SQL_DB_TYPE" = "pgsql" ]
   then

      SQL_INSERT=`$SQL_BIN -h $DEFAULT_SQL_HOST -U $DEFAULT_SQL_USER -d $DEFAULT_SQL_DB -X -c "DELETE FROM $RIGHTS_TABLE WHERE login LIKE '$USERNAME'" | $AWK_BIN {'print $1'}`
      if [ $? -eq 0 ]; then
         SQL_INSERT="DELETE"
      fi
   else
   
      SQL_INSERT=`$MYSQL_BIN -h $DEFAULT_SQL_HOST -u $DEFAULT_SQL_USER --password=$DEFAULT_SQL_PASS $DEFAULT_SQL_DB -e "DELETE FROM $RIGHTS_TABLE WHERE login LIKE '$USERNAME'" `

   fi

   
   if [ "$SQL_INSERT" = "DELETE" ]
   then
       echo "${done}SQL Success"
   else
       echo "${warn}SQL Error"
       exit 0
   fi
   ;;
    32)
   echo "${info}No such User"
   ;;
    34)
   echo "${warn}invalid DN"
   ;;
    *)
   echo "${warn}Undefined ERROR - LDAP CODE $LDAP_INSERT"
   echo "${warn}See LDAP Log for Details!"
esac

echo -en "${esc}[m\017"
echo -n ""


10.) run initall_ox. Watch the output on the screen. There should no errors occur.

11.) run scan_users.sh. Watch the output on the screen. There should no errors occur.

12.) remember to change (re-confirm) the user-passwords in the server-manager. If you don't do this, the login is username=password. In this case you'll not be able to access webmail!

13.) Give the backup/restore command a chance. Login ox. Play around - create some dates, whatever. Logoff. Run manually backup_ox. Login again. Delete whatever you created before. Logoff. Run manually restore_ox.

14.) After restore_ox you have to do:

- service postgresql restart
- service ldap restart
- service open-xchange restart

15.) Login ox. Look if everything is restored.

16.) Check if you can use the deluser_ox. You might need this for removing machine accounts from ox.

I'm not working with the oxtender. Therefore I cannot give any help with this tool.

Work with ox. Be careful with up-dates. I strongly recommend a backup before updating. Check carefully WHAT exactly the update overwrites! You'll not be able to use restore_ox for a different database/scheme!

Someone should remove my earlier post (20.06.06). It's obsolete.

Title: Re: HOW-TO install open-Xchange 0.8.2 from vincent
Post by: dmay on October 31, 2006, 09:06:17 PM

Quote from: "SchulzStefan"

2.) Change in /etc/e-smith/templates/etc/httpd/conf/httpd.conf the template 86WebShareAlias in:

- snip
    local %WebShare;
#   tie %WebShare, 'esmith::config', '/home/e-smith/WebShare';
    tie %WebShare, 'esmith::config', '/home/e-smith/db/WebShare';

        my $webshare;
- snip

The above code comes from an old release of smeserver-webshare. This is not a core rpm so this may confuse readers. In any event if you implement the latest release smeserver-webshare-1.0.0-7dmay.noarch.rpm the above deprecated code no longer exists :D

Darrell

Title: HOW-TO install open-Xchange 0.8.2 from vincent
Post by: stephen noble on November 01, 2006, 01:40:40 PM

>Someone should remove my earlier post (20.06.06). It's obsolete.

just edit it with a url back to this post

Title: HOW-TO install open-Xchange 0.8.2 from vincent
Post by: spittingfire on November 02, 2006, 05:25:14 AM

Hi All,

I'm pretty much a newbie at this and followed the exact steps above to get open-xchange going.  I did not run into any errors but after I completed all steps and tried to log into webmail I get the error message below

The requested URL /servlet/webmail was not found on this server.

When I tried groupware I get the error message below

The requested URL /servlet/intranet was not found on this server.

Can one of you experts please let me know how to resolve this issue?  Thanks in advance and please keep in mind that I'm a newbie at this.

Title: HOW-TO install open-Xchange 0.8.2 from vincent
Post by: SchulzStefan on November 02, 2006, 08:16:34 AM

I assume you login like

https://yourserver-ip/cgi-bin/login.pl

Title: HOW-TO install open-Xchange 0.8.2 from vincent
Post by: spittingfire on November 02, 2006, 12:42:58 PM

yes it is

Title: HOW-TO install open-Xchange 0.8.2 from vincent
Post by: gantep on February 20, 2007, 06:22:06 PM

Hallo,

ich habe die backup und restore scripte angepasst und erhalte beim restore_ox script folgende Fehelrmeldung "syntax error: unexpected end of file"

Das Backup Script funktioniert einwandfrei.
Die Scripte wurden mittels Putty/SSH und vi editiert.

Kann mir jemand vielleicht die angepasste Datei schicken.

Grüße
Timur

Title: HOW-TO install open-Xchange 0.8.2 from vincent
Post by: gantep on February 20, 2007, 06:25:45 PM

Hi together,

I get the following error when executing the modified restore_ox script "syntax error: unexpected end of file".
The backup script works fine.

The scripts are copy pasted via PuttY/SSH and vi.

Can someone send me the modified restore_ox script or tell me how to fix this problem.

Bye,
Timur

Title: HOW-TO install open-Xchange 0.8.2 from vincent
Post by: yythoss on February 20, 2007, 08:00:39 PM

I have make new scripts, look at this:

http://forums.contribs.org/index.php?topic=35070.0

yythoss

Title: HOW-TO install open-Xchange 0.8.2 from vincent
Post by: BolO on March 07, 2007, 03:57:04 PM

Hey guys

I'm getting the following trying to install under 7.1.2

Quote

[root@mail ox]# yum localinstall *.rpm
==============================================================
WARNING: Additional commands may be required after running yum
==============================================================
Loading "smeserver" plugin
Loading "fastestmirror" plugin
Setting up Local Package Process
Examining apache-mod_jk-2.0-2.noarch.rpm: apache-mod_jk - 2.0-2.noarch
Examining atrpms-67-1.at.noarch.rpm: atrpms - 67-1.at.noarch
Examining e-smith-lib-1.16.0-10ox1.noarch.rpm: e-smith-lib - 1.16.0-10ox1.noarch
Examining e-smith-lib-1.16.0-10ox.noarch.rpm: e-smith-lib - 1.16.0-10ox.noarch
Examining openldap-clients-2.2.13-6.4E.i386.rpm: openldap-clients - 2.2.13-6.4E.i386
Examining perl-DBD-Pg-1.31-6.i386.rpm: perl-DBD-Pg - 1.31-6.i386
Examining perl-HTTP-DAV-0.31-1.2.el4.rf.noarch.rpm: perl-HTTP-DAV - 0.31-1.2.el4.rf.noarch
Examining perl-IO-Socket-SSL-0.96-4.noarch.rpm: perl-IO-Socket-SSL - 0.96-4.noarch
Examining perl-libxml-enno-1.02-31.noarch.rpm: perl-libxml-enno - 1.02-31.noarch
Examining perl-MIME-Lite-3.01-2.2.el4.rf.noarch.rpm: perl-MIME-Lite - 3.01-2.2.el4.rf.noarch
Examining perl-MIME-Types-1.16-1.2.el4.rf.noarch.rpm: perl-MIME-Types - 1.16-1.2.el4.rf.noarch
Examining perl-Net-SSLeay-1.26-2.i386.rpm: perl-Net-SSLeay - 1.26-2.i386
Examining perl-Parse-Yapp-1.05-32.noarch.rpm: perl-Parse-Yapp - 1.05-32.noarch
Examining perl-Unicode-UTF8simple-1.06-1.el4.at.noarch.rpm: perl-Unicode-UTF8simple - 1.06-1.el4.at.noarch
Examining perl-XML-Encoding-1.01-26.noarch.rpm: perl-XML-Encoding - 1.01-26.noarch
Examining perl-XML-Simple-2.14-7.el4.at.noarch.rpm: perl-XML-Simple - 2.14-7.el4.at.noarch
Examining postgresql-7.4.8-1.RHEL4.1.i386.rpm: postgresql - 7.4.8-1.RHEL4.1.i386
Examining postgresql-jdbc-7.4.8-1.RHEL4.1.i386.rpm: postgresql-jdbc - 7.4.8-1.RHEL4.1.i386
Examining postgresql-server-7.4.8-1.RHEL4.1.i386.rpm: postgresql-server - 7.4.8-1.RHEL4.1.i386
Examining sme7-open-xchange-0.8.2.1-72.noarch.rpm: sme7-open-xchange - 0.8.2.1-72.noarch
Examining sme7-open-xchange-conf-0.8.2-23.noarch.rpm: sme7-open-xchange-conf - 0.8.2-23.noarch
Examining sme7-open-xchange-conf-0.8.2-27.noarch.rpm: sme7-open-xchange-conf - 0.8.2-27.noarch
Examining sme7-open-xchange-oxtender-4.0.15-2.noarch.rpm: sme7-open-xchange-oxtender - 4.0.15-2.noarch
Examining sme7-open-xchange-syncml-0.8.2-305M.noarch.rpm: sme7-open-xchange-syncml - 0.8.2-305M.noarch
Examining sme7-OX-icons-base-1.0-1.noarch.rpm: sme7-OX-icons-base - 1.0-1.noarch
Examining sme7-OX-icons-crystal-1.0-3.noarch.rpm: sme7-OX-icons-crystal - 1.0-3.noarch
Examining sme7-OX-icons-crystalb-1.0-3.noarch.rpm: sme7-OX-icons-crystalb - 1.0-3.noarch
Examining sme7-OX-icons-zenith-1.0-3.noarch.rpm: sme7-OX-icons-zenith - 1.0-3.noarch
Examining sme7-postgresql-7.4.8-7.noarch.rpm: sme7-postgresql - 7.4.8-7.noarch
Examining sme7-tomcat-5.5.12-13.noarch.rpm: sme7-tomcat - 5.5.12-13.noarch
Examining sme-ant-1.6.5-2.noarch.rpm: sme-ant - 1.6.5-2.noarch
Examining sme-j2sdk-1.6.0-9.i386.rpm: sme-j2sdk - 1.6.0-9.i386
Examining xorg-x11-deprecated-libs-6.8.2-1.EL.13.25.i386.rpm: xorg-x11-deprecated-libs - 6.8.2-1.EL.13.25.i386
Marking apache-mod_jk-2.0-2.noarch.rpm to be installed
Marking openldap-clients-2.2.13-6.4E.i386.rpm to be installed
Marking perl-DBD-Pg-1.31-6.i386.rpm to be installed
Marking perl-HTTP-DAV-0.31-1.2.el4.rf.noarch.rpm to be installed
Marking perl-libxml-enno-1.02-31.noarch.rpm to be installed
Marking perl-MIME-Lite-3.01-2.2.el4.rf.noarch.rpm to be installed
Marking perl-MIME-Types-1.16-1.2.el4.rf.noarch.rpm to be installed
Marking perl-Net-SSLeay-1.26-2.i386.rpm to be installed
Marking perl-Parse-Yapp-1.05-32.noarch.rpm to be installed
Marking perl-Unicode-UTF8simple-1.06-1.el4.at.noarch.rpm to be installed
Marking perl-XML-Encoding-1.01-26.noarch.rpm to be installed
Marking perl-XML-Simple-2.14-7.el4.at.noarch.rpm to be installed
Marking postgresql-7.4.8-1.RHEL4.1.i386.rpm to be installed
Marking postgresql-jdbc-7.4.8-1.RHEL4.1.i386.rpm to be installed
Marking postgresql-server-7.4.8-1.RHEL4.1.i386.rpm to be installed
Marking sme7-open-xchange-0.8.2.1-72.noarch.rpm to be installed
Marking sme7-open-xchange-conf-0.8.2-23.noarch.rpm to be installed
Marking sme7-open-xchange-conf-0.8.2-27.noarch.rpm to be installed
Marking sme7-open-xchange-oxtender-4.0.15-2.noarch.rpm to be installed
Marking sme7-open-xchange-syncml-0.8.2-305M.noarch.rpm to be installed
Marking sme7-OX-icons-base-1.0-1.noarch.rpm to be installed
Marking sme7-OX-icons-crystal-1.0-3.noarch.rpm to be installed
Marking sme7-OX-icons-crystalb-1.0-3.noarch.rpm to be installed
Marking sme7-OX-icons-zenith-1.0-3.noarch.rpm to be installed
Marking sme7-postgresql-7.4.8-7.noarch.rpm to be installed
Marking sme7-tomcat-5.5.12-13.noarch.rpm to be installed
Marking sme-ant-1.6.5-2.noarch.rpm to be installed
Marking sme-j2sdk-1.6.0-9.i386.rpm to be installed
Marking xorg-x11-deprecated-libs-6.8.2-1.EL.13.25.i386.rpm to be installed
atrpms-67-1.at.noarch.rpm: does not update installed package.
e-smith-lib-1.16.0-10ox1.noarch.rpm: does not update installed package.
e-smith-lib-1.16.0-10ox.noarch.rpm: does not update installed package.
perl-IO-Socket-SSL-0.96-4.noarch.rpm: does not update installed package.
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Package perl-MIME-Types.noarch 0:1.16-1.2.el4.rf set to be updated
---> Package perl-Parse-Yapp.noarch 0:1.05-32 set to be updated
---> Package perl-libxml-enno.noarch 0:1.02-31 set to be updated
---> Package sme7-open-xchange.noarch 0:0.8.2.1-72 set to be updated
---> Package sme-ant.noarch 0:1.6.5-2 set to be updated
---> Package sme7-OX-icons-crystal.noarch 0:1.0-3 set to be updated
---> Package postgresql.i386 0:7.4.8-1.RHEL4.1 set to be updated
---> Package sme7-open-xchange-syncml.noarch 0:0.8.2-305M set to be updated
---> Package postgresql-server.i386 0:7.4.8-1.RHEL4.1 set to be updated
---> Package perl-DBD-Pg.i386 0:1.31-6 set to be updated
---> Package perl-XML-Simple.noarch 0:2.14-7.el4.at set to be updated
---> Package perl-MIME-Lite.noarch 0:3.01-2.2.el4.rf set to be updated
---> Package openldap-clients.i386 0:2.2.13-6.4E set to be updated
---> Package sme7-open-xchange-oxtender.noarch 0:4.0.15-2 set to be updated
---> Package perl-Unicode-UTF8simple.noarch 0:1.06-1.el4.at set to be updated
---> Package sme7-postgresql.noarch 0:7.4.8-7 set to be updated
---> Package perl-XML-Encoding.noarch 0:1.01-26 set to be updated
---> Package postgresql-jdbc.i386 0:7.4.8-1.RHEL4.1 set to be updated
---> Package perl-HTTP-DAV.noarch 0:0.31-1.2.el4.rf set to be updated
---> Package sme7-OX-icons-base.noarch 0:1.0-1 set to be updated
---> Package apache-mod_jk.noarch 0:2.0-2 set to be updated
---> Package perl-Net-SSLeay.i386 0:1.26-2 set to be updated
---> Package xorg-x11-deprecated-libs.i386 0:6.8.2-1.EL.13.25 set to be updated
---> Package sme7-open-xchange-conf.noarch 0:0.8.2-27 set to be updated
---> Package sme7-OX-icons-zenith.noarch 0:1.0-3 set to be updated
---> Package sme7-open-xchange-conf.noarch 0:0.8.2-23 set to be updated
---> Package sme7-tomcat.noarch 0:5.5.12-13 set to be updated
---> Package sme-j2sdk.i386 0:1.6.0-9 set to be updated
---> Package sme7-OX-icons-crystalb.noarch 0:1.0-3 set to be updated
--> Running transaction check
Setting up repositories
Loading mirror speeds from cached hostfile
Reading repository metadata in from local files
--> Processing Dependency: sme7-jotm for package: sme7-open-xchange
--> Processing Dependency: e-smith-lib = 1.16.0-10ox1 for package: sme7-open-xchange-conf
--> Processing Dependency: sme7-common-transaction for package: sme7-open-xchange
--> Processing Dependency: e-smith-lib = 1.16.0-10ox for package: sme7-open-xchange-conf
--> Finished Dependency Resolution
Error: Missing Dependency: sme7-jotm is needed by package sme7-open-xchange
Error: Missing Dependency: e-smith-lib = 1.16.0-10ox1 is needed by package sme7-open-xchange-conf
Error: Missing Dependency: sme7-common-transaction is needed by package sme7-open-xchange
Error: Missing Dependency: e-smith-lib = 1.16.0-10ox is needed by package sme7-open-xchange-conf
================================================================
No new rpms were installed. No additional commands are required.
================================================================

Anyone know what's going on?

Title: Howto install OpenXchange in SME 7.0 (Henry Gómez howto)
Post by: hgomez on June 18, 2007, 08:54:55 PM

Hello my friends, I did some time ago a howto OpenLdap+Samba+PDC+OpenXchange, well it work fine in SME 5.6 - SME 6.5, I did not test in 7.0, but the OpenXchange work fine...here it goes:


The rpms you need are in:
http://smeserver.free.fr/Files/open-xchange/ox7/
http://mirror.centos.org/centos/4/os/i386/CentOS/RPMS/

What you will need :

    * Read all this paper and understand what are you going to do.
    * Don’t use production environment.
    * Parameters when you are installing e-smith:
          LDAP : idealx.org
          Name of server : PDC-SRV
          "Secure shell access" Change to Private
          "Allow administrative command line access over secure shell" set to Yes

          "Allow secure shell access using standard passwords" set to Yes
          Change "Windows workgroup" from "mitel-networks" to IDEALX-NT
          "Workgroup and Domain Controller" set to Yes
          "Roaming profiles" set to Yes
          Create root SAMBA User.
    * Change LDAP directory settings
          Default department : TaS
          Default company : IDL
          Default Street address : Avenida principal de los ilustres
          Default City : CCS
          Default Phone Number : 58-416-8047867

1.-Creating root Samba user:
login as: root
#smbpasswd -a root
#pico /etc/samba/smb.conf

add this lines to the eof (it´s for share everything, at the end of the procedure you will not use it)

[everything]
comment = Root File System
path = /
read only = No
guest ok = Yes

2.-Save file and restart samba service
service smb restart

3.-rpms that you will need for OpenXchange:
apache-mod_jk-2.0-2.noarch.rpm
e-smith-lib-1.16.0-10ox1.noarch.rpm
openldap-2.2.13-6.4E.i386.rpm
openldap-clients-2.2.13-4.i386.rpm
openldap-devel-2.2.13-6.4E.i386.rpm
openldap-servers-2.2.13-6.4E.i386.rpm
perl-DBD-Pg-1.31-6.i386.rpm
perl-HTTP-DAV-0.31-1.2.el4.rf.noarch.rpm
perl-IO-Socket-SSL-1.01-1.c4.noarch.rpm
perl-libxml-enno-1.02-31.noarch.rpm
perl-MIME-Lite-3.01-2.2.el4.rf.noarch.rpm
perl-MIME-Types-1.16-1.2.el4.rf.noarch.rpm
perl-Net_SSLeay.pm-1.25-4.el4.at.i386.rpm
perl-Parse-Yapp-1.05-32.noarch.rpm
perl-Unicode-UTF8simple-1.06-1.el4.at.noarch.rpm
perl-XML-Encoding-1.01-26.noarch.rpm
perl-XML-Simple-2.14-7.el4.at.noarch.rpm
postgresql-7.4.8-1.RHEL4.1.i386.rpm
postgresql-jdbc-7.4.8-1.RHEL4.1.i386.rpm
postgresql-server-7.4.8-1.RHEL4.1.i386.rpm
sme7-ant-1.7.0-4.noarch.rpm
sme7-open-xchange-0.8.2.1-82.noarch.rpm
sme7-open-xchange-conf-0.8.2-27.noarch.rpm
sme7-open-xchange-oxtender-4.2.3-1.noarch.rpm
sme7-open-xchange-syncml-0.8.2-311M.noarch.rpm
sme7-OX-icons-base-1.0-1.noarch.rpm
sme7-postgresql-7.4.8-7.noarch.rpm
sme7-tomcat-6.0.13-2.noarch.rpm
sme-j2sdk-1.6.0-9.i386.rpm
xorg-x11-deprecated-libs-6.8.2-1.EL.13.25.i386.rpm

4.- Install OpenXchange
rpm -ivh apache-mod_jk-2.0-2.noarch.rpm
rpm -Uvh --nodeps --force perl*.rpm
rpm -ivh sme-j2sdk-1.6.0-9.i386.rpm
rpm -ivh sme7-ant-1.7.0-4.noarch.rpm
rpm -ivh sme7-tomcat-6.0.13-2.noarch.rpm
rpm -ivh postgresql-7.4.8-1.RHEL4.1.i386.rpm
rpm -ivh postgresql-jdbc-7.4.8-1.RHEL4.1.i386.rpm
rpm -ivh postgresql-server-7.4.8-1.RHEL4.1.i386.rpm

5.- Creating database enviroment for OpenExchange
rpm -ivh sme7-postgresql-7.4.8-7.noarch.rpm
rpm -ivh openldap-clients-2.2.13-4.i386.rpm
rpm -Uvh e-smith-lib-1.16.0-10ox1.noarch.rpm
rpm -ivh sme7-open-xchange-0.8.2.1-82.noarch.rpm
rpm -ivh sme7-open-xchange-oxtender-4.2.3-1.noarch.rpm

6.- Init OpenLDAP Schema within OpenExchange
/usr/local/open-xchange/sbin/initall_ox
 
7.- Install Panel
rpm -ivh sme7-open-xchange-conf-0.8.2-27.noarch.rpm
rpm -ivh sme7-open-xchange-syncml-0.8.2-311M.noarch.rpm

8.- Install Icons
service open-xchange stop
rpm -ivh sme7-OX-icons-base-1.0-1.noarch.rpm
service open-xchange start

9.- Add user to OpenXchange
Goto Server Manager Panel
in "Open-Xchange (ox)"->"Users configuration" change Language from Deutsch to English and save language.

Now using the user panel create a user and try to access with him to https://pdc-srv/cgi-bin/login.pl

NOTA:
Solo para mis compañeros habla hispana, cuando configuren un usuario en español o al menos uno deberán hacer lo siguiente:

#cd /home/e-smith/files/ibays/Primary/html/cfintranet/images/top
#cp -r EN ES

Y por ultimo para que el idioma quede definido para todo el mundo por defecto haga lo siguiente:

pico /usr/lib/perl5/site_perl/esmith/loginsme.pm

Busquen la línea con my $default_lang       = 'FR'; pónganla en comentario y pongan ES, como se ve a continuación

#my $default_lang       = 'FR';
my $default_lang       = 'ES';
 
pico /usr/local/open-xchange/etc/admintools.conf
 

 Busquen la línea con DEFAULT_PREF_LANG="FR" pónganla en comentario y pongan ES, como se ve a continuación

#DEFAULT_PREF_LANG="FR"
DEFAULT_PREF_LANG="ES"
 

That is all...Enjoy...
FINAL: Very Important:
If you left the LDAP Setting by default everything work fine, but if you change it, take care about the number of letter that you will use...I don't know why but more than I used fuck the OpenLDAP!!!!