Topic: Open-Exchange 0.8.2 from Vincent

[SchulzStefan]

Jay,

this is the result:

[root@warp ~]# psql -U openexchange
psql: FATAL:  IDENT authentication échouée pour l'utilisateur "openexchange"

Where should the database be located? /var/db? There's nothing. In home/e-smith/db also nothing and in /home/e-smith/db/pgsql there are two files: openexchange.sql.back and pre_upgrade.sql.back, both with zero length.

So, I think meanwhile I have a corrupt ldap and no openexchange database.

[jfarschman]

Stefan,

  You got it right... no openexchange db.  I don't know where it should be. I have the following:

[root@perihelion ~]# ls /home/e-smith/db/pgsql
openexchange.sql.back  pre_upgrade.sql.back

I know you already tried this... but try again.  You really ned to postgres db.

#### Build the postgres DB.  This deletes your data #initall_ox
#### Don't use realinitall_ox all the time use scan_users.sh
realinitall_ox
dbinit_ox

#### Check on the validity of everything
scan_users.sh

#### One more time just to be safe
service tomcat restart
service postgresql start
service open-xchange restart

[SchulzStefan]

Jay,

in home/e-smith/db/pgsql/openexchange.sql.back there is a file - but lenght is zero bytes.

What do you think about a complete re-install? Can you tell me what EXACTLY has to be removed, that there are no files or templates or any other fragments or stuff from ox remain on the server?

[jfarschman]

Stefan,

  A complete reinstall is a good idea.

PACKAGES="apache-mod_jk atrpms e-smith-lib openldap-clients
          perl-DBD-Pg perl-HTTP-DAV perl-IO-Socket-SSL perl-MIME-Lite
          perl-MIME-Types perl-Net-SSLeay perl-Parse-Yapp perl-Unicode-UTF8simple
          perl-XML-Encoding perl-XML-Simple perl-libxml-enno
          postgresql postgresql-jdbc postgresql-server sme-ant sme-j2sdk
          sme7-open-xchange sme7-open-xchange-conf sme7-open-xchange-oxtender
          sme7-open-xchange-syncml sme7-postgresql sme7-tomcat xorg-x11-deprecated-libs
          sme7-OX-icons-base sme7-OX-icons-zenith sme7-OX-icons-crystal
          sme7-OX-icons-crystalb"

[SchulzStefan]

Jay,

I found an error in /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
pg_dump -U openexchange openexchange >/home/e-smith/db/pgsql/openexchange.sql.back

su - -c'dropdb openexchange' postgres
su - -c'dropuser openexchange' postgres
su - -c'createdb --template=template0 -E UNICODE -e openexchange' postgres
su - -c'psql -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'export PGPASSWORD="openexchange"; psql -d openexchange -U postgres openexchange -q -f /usr/local/open-xchange/share/init_database.sql' postgres
su - -c'export PGPASSWORD="openexchange"; psql -d openexchange -U postgres openexchange -q -f /usr/local/open-xchange/share/admin_last.sql' postgres

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

I let you know, if ox works now.

[SchulzStefan]

Open-Xchange works!

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

1.) get following files from http://smeserver.free.fr/files/index.php?dir=open-xchange/ox7/ (thx to vincent who did a great job!) You'll probably need only one icon-set.
2.) install from a local directory with yum localinstall *.rpm
3.) in the case that files are missing, get them from http://mirror.centos.org/centos/4/os/i386/CentOS/RPMS/
4.) run again yum localinstall *.rpm
5.) don't forget signal-event post-install/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
/etc/rc.d/init.d/ldap stop
rm /home/e-smith/db/ldap/*ldif
rm /var/lib/ldap/*
signal-event ldap-update
/etc/rc.d/init.d/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
pg_dump -U openexchange openexchange >/home/e-smith/db/pgsql/openexchange.sql.back

su - -c'dropdb openexchange' postgres
su - -c'dropuser openexchange' postgres
su - -c'createdb --template=template0 -E UNICODE -e openexchange' postgres
su - -c'psql -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'export PGPASSWORD="openexchange"; psql -d openexchange -U postgres openexchange -q -f /usr/local/open-xchange/share/init_database.sql' postgres
su - -c'export PGPASSWORD="openexchange"; psql -d openexchange -U postgres openexchange -q -f /usr/local/open-xchange/share/admin_last.sql' postgres

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

8.) run initall_ox
9.) run scan_users.sh
10.) 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!

There are still some SQL-bug's adding/deleting users to/from groups with the ox-scripts. I'm not going to fix this.

Now for me there is only the question how to import the outlook.pst (all local) from different clients into ox. I DON'T WANT TO USE THE OXTENDER. In fact I want the users work with OPEN-XCHANGE. Any body with any suggestions or hints?

Thx in advance
Stefan

[SchulzStefan]

Vincent,

there's still one point: If I create a user via server-manager AFTER installing open-xchange, this user has a broken ox-gui. Only the portal icon appears.

All users are correctly transferred if their accounts already exist before the installation. Adding the user manually to the oxdatabase results in SQL errors.

The only way is to initall_ox. That's not really practicable - all data is gone afterwards. In my understanding this causes of not correct adapted scrips in /usr/local/open-xchange/sbin.

Do you have an idea to fix this?

Stefan

[wallyrp]

Good Morning,

Just a curious point, have you tried the scan_users.sh script to fix your issue instead of the initall?

[SchulzStefan]

Wally,

I tried this. Didn't help at all. The new user has only the portal icon - nothing else. I think someone has to look for the /sbin scripts.

Stefan