Topic: Open-Exchange 0.8.2 from Vincent

[SchulzStefan]

I installed the ox-contrib form vincent. To the provided files of Vincent, there are a few more necessary:

- xorg-x11-Mesa-libGL-6.8.2-1.EL.13.25.i386.rpm
- xorg-x11-Mesa-libGLU-6.8.2-1.EL.13.25.i386.rpm
- xorg-x11-libs-6.8.2-1.EL.13.25.i386.rpm

Installed with yum localinstall *.rpm. Went smooth.

Now here's the problem: after "realinitall_ox" there's
1.) no login possible in ox
2.) the ldap is gone (even not accesable in ms-outlook clients.)

Here are the messages from the screen:

realinitall_ox
Stoping all

Shutting down SESSIOND                                                                                             [ done ]

Shutting down OX                                                                                                   [ done ]

Shutting down OXWebmail                                                                                            [ done ]
Stopping : tomcatUsing CATALINA_BASE:   /usr/local/tomcat
Using CATALINA_HOME:   /usr/local/tomcat
Using CATALINA_TMPDIR: /usr/local/tomcat/temp
Using JRE_HOME:       /usr/local/java

Stopping ldap:                                             [  OK  ]
Starting ldap:                                             [  OK  ]
pg_dump: [Archivierer (DB)] Verbindung zur Datenbank »openexchange« fehlgeschlagen: FATAL:  IDENT authentication échouée pour l'utilisateur "openexchange"
DROP DATABASE
DROP USER
CREATE DATABASE openexchange ENCODING 'UNICODE' TEMPLATE template0;
CREATE DATABASE
Sie sind jetzt mit der Datenbank »openexchange« als Benutzer »postgres« verbunden.
CREATE USER openexchange WITH ENCRYPTED PASSWORD 'openexchange' CREATEDB CREATEUSER;
CREATE USER
psql: FATAL:  IDENT authentication échouée pour l'utilisateur "openexchange"
psql: FATAL:  IDENT authentication échouée pour l'utilisateur "openexchange"
Starting : tomcat                                          [  OK  ]
Starting all

Starting SESSIOND                                                                                                  [ done ]

Starting OX                                                                                                        [ done ]

Starting OXWebmail                                                                                                 [ done ]
---------> recreate the ldap database.
Stopping ldap:                                             [  OK  ]
Starting ldap:                                             [  OK  ]
---------> scan all the users.
Added Group assist to LDAP
Added Group guest to LDAP
Added Group machines to LDAP
Added Group mgm to LDAP
Added Group staff to LDAP

Create User : backuppc password: backuppc
LDAP Success
ERREUR:  La relation «usr_general_rights» n'existe pas
SQL Error
Deleting User from LDAP

- snip

Batch-Anweisung Nummer 0 (delete from prg_documents_read where group_right like 'users') wurde abgebrochen.
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:107)
        at com.openexchange.groupware.DeleteObjects.delGroupObjects(DeleteObjects.java:655)
        at com.openexchange.groupware.deleteUserGroups.main(deleteUserGroups.java:86)
LDAP Success!
Added Group users to LDAP
Groupname already exists in LDAP
Exiting now!

add user : admin to group: assist
OK

- snip

Groupname already exists in LDAP
Exiting now!

- snip

Setting right user and group. This can take a long time depending on the
used filesystem. Please be patient.
Setting user and group ...


With the server-panel I created a new user with a new passwort - a login in ox is still not possible.

Would be nice to get this running on the machine.

Anyway - the other question I have is, how can I rebuild the LDAP???

Thx in advance for any reply!
Stefan

[jfarschman]

Stefan,

  Not sure what instructions you are following... but here is now to fix the problem (I think):

### 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 start
service open-xchange restart

#### Kick LDAP
/etc/rc.d/init.d/ldap stop
rm /home/e-smith/db/ldap/*ldif
rm /var/lib/ldap/*
/etc/e-smith/events/actions/ldap-update
/etc/rc.d/init.d/ldap start


Also... you may want to do a dbinit_ox to make sure you get the correct settings in the psql db.

[SchulzStefan]

Jay,

thank you for your reply. I tried this. See the result below:

[root@warp sbin]# service postgresql stop
postgresql-Dienst stoppen:                                 [  OK  ]
[root@warp sbin]# cd /var/lib/pgsql
[root@warp pgsql]# rm -rf *
[root@warp pgsql]# service postgresql start
Datenbank initialisieren:                                  [  OK  ]
postgresql-Dienst starten:                                 [  OK  ]
[root@warp pgsql]# service postgresql stop
postgresql-Dienst stoppen:                                 [  OK  ]
[root@warp pgsql]# expand-template /var/lib/pgsql/data/postgresql.conf
[root@warp pgsql]# expand-template /var/lib/pgsql/data/pg_hba.conf
[root@warp pgsql]# service tomcat restart
Stopping : tomcatUsing CATALINA_BASE:   /usr/local/tomcat
Using CATALINA_HOME:   /usr/local/tomcat
Using CATALINA_TMPDIR: /usr/local/tomcat/temp
Using JRE_HOME:       /usr/local/java

Starting : tomcat                                          [  OK  ]
[root@warp pgsql]# service postgresql start
postgresql-Dienst starten:                                 [  OK  ]
[root@warp pgsql]# service open-xchange restart
Restarting all

Shutting down SESSIOND                                                                                             [ done ]
Starting SESSIOND                                                                                                  [ done ]

Shutting down OX                                                                                                   [ done ]
Starting OX                                                                                                        [ done ]

Shutting down OXWebmail                                                                                            [ done ]
Starting OXWebmail                                                                                                 [ done ]
[root@warp pgsql]# /etc/rc.d/init.d/ldap stop
slapd beenden:                                             [  OK  ]
[root@warp pgsql]# rm /home/e-smith/db/ldap/*ldif
rm: reguläre Datei ,,/home/e-smith/db/ldap/wunds.org.ldif" entfernen? y
[root@warp pgsql]# rm /var/lib/ldap/*
rm: reguläre Datei ,,/var/lib/ldap/alias.dbb" entfernen? y
rm: reguläre Datei ,,/var/lib/ldap/cn.dbb" entfernen? y
rm: reguläre Datei ,,/var/lib/ldap/dn2id.dbb" entfernen? y
rm: reguläre Datei ,,/var/lib/ldap/givenName.dbb" entfernen? y
rm: reguläre Datei ,,/var/lib/ldap/id2entry.dbb" entfernen? y
rm: reguläre Datei ,,/var/lib/ldap/lnetMailAccess.dbb" entfernen? y
rm: reguläre Datei ,,/var/lib/ldap/mailEnabled.dbb" entfernen? y
rm: reguläre Datei ,,/var/lib/ldap/memberUid.dbb" entfernen? y
rm: reguläre Datei ,,/var/lib/ldap/nextid.dbb" entfernen? y
rm: reguläre Datei ,,/var/lib/ldap/objectClass.dbb" entfernen? y
rm: reguläre Datei ,,/var/lib/ldap/sn.dbb" entfernen? y
rm: reguläre Datei ,,/var/lib/ldap/uid.dbb" entfernen? y
[root@warp pgsql]# /etc/e-smith/events/actions/ldap-update
Event name must be specified at /etc/e-smith/events/actions/ldap-update line 51.

Any suggestions?

Stefan

[jfarschman]

Stefan,
 
  Sorry about that.  ldap-update should be invoked like this:

  signal-event ldap-update

  That should work better.

[SchulzStefan]

Jay,

there's still something wrong. See the result below:

[root@warp pgsql]# /etc/rc.d/init.d/ldap start
Konfigurationsdateien nach  untersuchen:config file testing succeeded
slapd starten:                                             [FEHLGESCHLAGEN](error)

and here's the other one:

[root@warp sbin]# dbinit_ox
psql: FATAL:  La base de données «openexchange» n'existe pas (database does not exist)

Hmm...?

[SchulzStefan]

Jay,

meanwhile I thought the errors may occur because auf yum localinstall. So I uninstalled and re-installed the whole stuff with rpm --nodeps --force.

There are still the same problems.

- initall_ox not properly working
- scan_users.sh not properly working. After running scan_users I'm able to access the webinterface. Username=password.
- I can only change the personal data in the tab
- only one icon (portal) is displayed
- only the calender appears at the right side
- no way to do anything because of restricted rights.

To execute dbinit_ox is also not possible:

[root@warp o_xchange]# dbinit_ox
ERREUR:  La relation «sys_gen_rights_template» n'existe pas

In fact, I'm not able to run ox with 7.0 final. I would really like to know, what's wrong.

[jfarschman]

Stefan,

Code: [Select]

La base de données «openexchange» n'existe pas (database does not exist)

It's looks like you don't have a database.  So... this command will fail:

psql -U openexchange

You can build a database with the following:
realinitall_ox
dbinit_ox

service tomcat restart
service postgresql start
service open-xchange restart

Then I would do a scan_users.sh again to see everything working properly.

[SchulzStefan]

O.K. Jay, here we go:

[root@warp sbin]# realinitall_ox
Stoping all

Shutting down SESSIOND                                                                                             [ done ]

Shutting down OX                                                                                                   [ done ]

Shutting down OXWebmail                                                                                            [ done ]
Stopping : tomcatUsing CATALINA_BASE:   /usr/local/tomcat
Using CATALINA_HOME:   /usr/local/tomcat
Using CATALINA_TMPDIR: /usr/local/tomcat/temp
Using JRE_HOME:       /usr/local/java

Stopping ldap:                                             [  OK  ]
sed: Datei /usr/local/open-xchange/share/sed.in Zeile 5: unknown option to s'
Starting ldap:                                             [  OK  ]
pg_dump: [Archivierer (DB)] Verbindung zur Datenbank »openexchange« fehlgeschlagen: FATAL:  IDENT authentication échouée pour l'utilisateur "openexchange"
DROP DATABASE
DROP USER
CREATE DATABASE openexchange ENCODING 'UNICODE' TEMPLATE template0;
CREATE DATABASE
Sie sind jetzt mit der Datenbank »openexchange« als Benutzer »postgres« verbunden.
CREATE USER openexchange WITH ENCRYPTED PASSWORD 'openexchange' CREATEDB CREATEUSER;
CREATE USER
psql: FATAL:  IDENT authentication échouée pour l'utilisateur "openexchange"
psql: FATAL:  IDENT authentication échouée pour l'utilisateur "openexchange"
Starting : tomcat                                          [  OK  ]
Starting all

Starting SESSIOND                                                                                                  [ done ]

Starting OX                                                                                                        [ done ]

Starting OXWebmail                                                                                                 [ done ]
---------> recreate the ldap database.
Stopping ldap:                                             [  OK  ]
sed: Datei /usr/local/open-xchange/share/sed.in Zeile 5: unknown option to s'
Starting ldap:                                             [  OK  ]
---------> scan all the users.
Added Group assist to LDAP
Added Group guest to LDAP
Added Group machines to LDAP
Added Group mgm to LDAP
Added Group staff to LDAP

Create User : boenisch password: boenisch
Undefined ERROR - LDAP CODE 32
See LDAP Log for Details!

- snip

Batch-Anweisung Nummer 0 (delete from prg_documents_read where group_right like 'users') wurde abgebrochen.
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:107)
        at com.openexchange.groupware.DeleteObjects.delGroupObjects(DeleteObjects.java:655)
        at com.openexchange.groupware.deleteUserGroups.main(deleteUserGroups.java:86)
No such Group
Added Group users to LDAP
Added Group assist to LDAP

add user : admin to group: assist
Undefined ERROR - LDAP CODE
See Server Log for Details!
ERROR

-snip

Setting right user and group. This can take a long time depending on the
used filesystem. Please be patient.
Setting user and group ...

[root@warp sbin]# dbinit_ox
ERREUR:  La relation «sys_gen_rights_template» n'existe pas

[root@warp sbin]# scan_users.sh
---------> recreate the ldap database.
Stopping ldap:                                             [  OK  ]
Starting ldap:                                             [  OK  ]
---------> scan all the users.
Added Group assist to LDAP
Added Group guest to LDAP
Added Group machines to LDAP
Added Group mgm to LDAP
Added Group staff to LDAP

Create User : boenisch password: boenisch
LDAP Success

- snip

Batch-Anweisung Nummer 0 (delete from prg_documents_read where group_right like 'users') wurde abgebrochen.
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:107)
        at com.openexchange.groupware.DeleteObjects.delGroupObjects(DeleteObjects.java:655)
        at com.openexchange.groupware.deleteUserGroups.main(deleteUserGroups.java:86)
LDAP Success!
Added Group users to LDAP
Groupname already exists in LDAP
Exiting now!

add user : admin to group: assist
OK

- snip

Setting right user and group. This can take a long time depending on the
used filesystem. Please be patient.
Setting user and group ...


I had this before...

[jfarschman]

Yep...

  Looks like the LDAP is corrupt.

[SchulzStefan]

Any suggestions to get this fixed?

[jfarschman]

#### Kick LDAP
/etc/rc.d/init.d/ldap stop
rm /home/e-smith/db/ldap/*ldif
rm /var/lib/ldap/*
/etc/e-smith/events/actions/ldap-update
/etc/rc.d/init.d/ldap start

[SchulzStefan]

jay,

[root@warp ~]# /etc/rc.d/init.d/ldap start
Konfigurationsdateien nach  untersuchen:config file testing succeeded
slapd starten:                                             [FEHLGESCHLAGEN] (FAILED)

???

[jfarschman]

Stefan,

  I do not know what to do.  slapd will not start.

  Sometimes the install works well... sometimes it does not.  The code changes often.

[SchulzStefan]

Jay, I think, this is the main problem:

Create User : user password: <user>
LDAP Success
ERREUR:  La relation «usr_general_rights» n'existe pas
SQL Error
Deleting User from LDAP
Batch-Anweisung Nummer 0 (delete from prg_documents_read where group_right like 'users') wurde abgebrochen.
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:107)
        at com.openexchange.groupware.DeleteObjects.delGroupObjects(DeleteObjects.java:655)
        at com.openexchange.groupware.deleteUserGroups.main(deleteUserGroups.java:86)

LDAP is not correctly build during the installation. Any ideas?

[jfarschman]

Stefan,

  Do you have an openexchange db?  Check the rights,

psql -U openexchange
select * from usr_general_rights where login like 'jay';
\q;

psql -U openexchange
INSERT INTO usr_general_rights values
('now','admin','now','','jay','y','y','y','y',
'y','y','y','y','y','y','y','y','y','y','y','y','y','y','y',
'y','y','y','y','y','y','y','y','y','y','y','y','y','y','y',
'y','y','y','y','y','y','y','y','y','y','y','y','y');
\q;

You may also want to put in the rights for default:

INSERT INTO sys_gen_rights_template values
('now','admin','now','','default_template','y','y','y','y',
'y','y','y','y','y','y','y','y','y','y','y','y','y','y','y',
'y','y','y','y','y','y','y','y','y','y','y','y','y','y','y',
'y','y','y','y','y','y','y','y','y','y','y','y','y');

[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