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');