Topic: sme 7.2 and open-xchange 0.8.6-5 *works*

[SchulzStefan]

Question to open-xchange users:

Is there anybody out there, who can confirm a stable running open-xchange after updating from 7.1 to sme 7.2?

Meanwhile, I confirm for my installation:

Coming up from a clean sme 7.1. Only installed contrib was dar. Performed a yum update to sme 7.2. Installed the pdf distiller. With the latest rpm's of vincent, http://smeserver.free.fr/Files/open-xchange/ox7 open-xchange works without any problems. no errors in any log til now.

thx to vincent and all other people, working on this great contrib!

stefan

[allforone]

I am going to try it this weekend. I am a newbie trying to learn all the various things I can do with sme. I know I can use yum to point to http://smeserver.free.fr/Files/open-xchange/ox7/ but I do not know how to do it. Can U help!

[SchulzStefan]

@allforone

1.) get all files from http://smeserver.free.fr/Files/open-xchange/ox7

2.) read the blog from vincent http://smeserver.free.fr/wordpress/

3.) run the install script

4.) for more questions, query the forum for the keyword "open-xchange"

stefan

[tariqf]

Have been running stable and production ox installs on SME since 7.0 and up to and including 7.2. No problems at all currently on 0.8.6-5. Have this on many servers around the UK.

[allforone]

This is what has taken place!

login as: root
root@192.168.2.5's password:
Last login: Mon Jul 30 16:57:09 2007 from pc-00100.altitude.selfip.com
[root@hserver ~]# cd OX
[root@hserver OX]# ls
install-ox.sh
[root@hserver OX]# scan_users.sh
---------> recreate the ldap database.
config file testing succeeded
---------> scan all the users.

Create User : harlan password: nonofyourbusiness
LDAP Success
org.postgresql.util.PSQLException: Backend start-up failed: org.postgresql.util.                                              PSQLException: FATAL: La base de données «openexchange» n'existe pas

        at org.postgresql.jdbc1.AbstractJdbc1Connection.openConnectionV3(Abstrac                                              tJdbc1Connection.java:460)
        at org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection(AbstractJ                                              dbc1Connection.java:214)
        at org.postgresql.Driver.connect(Driver.java:139)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:185)
        at com.openexchange.server.DBPool.createConnection(DBPool.java:290)
        at com.openexchange.server.DBPool.init(DBPool.java:115)
        at com.openexchange.server.DBPool.<init>(DBPool.java:95)
        at com.openexchange.groupware.DeleteObjects.<init>(DeleteObjects.java:12                                              3)
        at com.openexchange.groupware.deleteUserGroups.main(deleteUserGroups.jav                                              a:86)
org.postgresql.util.PSQLException: Backend start-up failed: org.postgresql.util.                                              PSQLException: FATAL: La base de données «openexchange» n'existe pas

        at org.postgresql.jdbc1.AbstractJdbc1Connection.openConnectionV3(Abstrac                                              tJdbc1Connection.java:460)
        at org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection(AbstractJ                                              dbc1Connection.java:214)
        at org.postgresql.Driver.connect(Driver.java:139)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:185)
        at com.openexchange.server.DBPool.createConnection(DBPool.java:290)
        at com.openexchange.server.DBPool.pickup(DBPool.java:181)
        at com.openexchange.server.DBPool.pickupWriteable(DBPool.java:190)
        at com.openexchange.groupware.DeleteObjects.<init>(DeleteObjects.java:12                                              6)
        at com.openexchange.groupware.deleteUserGroups.main(deleteUserGroups.jav                                              a:86)
LDAP Success!
Added Group users to LDAP

add user : harlan to group: users
OK
DBI connect('dbname=openexchange;host=localhost','openexchange',...) failed: FAT                                              AL:  La base de données «openexchange» n'existe pas at /usr/local/open-xchange/s                                              bin/adjustfolders.pl line 50
Can't call method "prepare" on an undefined value at /usr/local/open-xchange/sbi                                              n/adjustfolders.pl line 56, <DATA> line 283.
Setting right user and group. This can take a long time depending on the
used filesystem. Please be patient.
Setting user and group ...
[root@hserver OX]#

When I login I get nothing but this in the address bar with a blank screen.

https://hserver/servlet/webmail?

SITE=mauth&sessionID=e81458906b7ccd3b8780cad66ef5e935

It is the same for the groupware too.

This is a fresh install with all updates.

Other than getting it working It was a snap. Hats off to you Sir.

[tariqf]

* check postgres is working
* run initall_ox

[allforone]

Something was diffrent during the installation, However it is still not working. When I log in I get just a white screen.  I don't know alot about the log files, but this seems like it might have something to do with it.

Boot log
Jul 31 04:44:32 hserver httpd-e-smith: Starting httpd-e-smith succeeded
Jul 31 04:44:35 hserver startup.sh: Using CATALINA_BASE:   /usr/local/tomcat
Jul 31 04:44:35 hserver startup.sh: Using CATALINA_HOME:   /usr/local/tomcat
Jul 31 04:44:35 hserver startup.sh: Using CATALINA_TMPDIR: /usr/local/tomcat/temp
Jul 31 04:44:35 hserver startup.sh: Using JRE_HOME:       /usr/local/java
Jul 31 04:44:35 hserver tomcat: startup.sh startup succeeded
Jul 31 04:44:35 hserver radiusd: Starting radiusd succeeded
Jul 31 04:44:36 hserver smolt:  succeeded
Jul 31 04:44:37 hserver spamd: Starting spamd succeeded
Jul 31 04:44:37 hserver squid: Starting squid succeeded
Jul 31 04:44:38 hserver nmbd: Starting nmbd succeeded
Jul 31 04:44:38 hserver smbd: Starting smbd succeeded
Jul 31 04:44:43 hserver messagebus: messagebus startup succeeded
Jul 31 04:44:46 hserver haldaemon: haldaemon startup succeeded
Jul 31 04:44:50 hserver 10fix_privilege_tables: ERROR 1060 (42S21) at line 22: Duplicate column name 'File_priv'
Jul 31 04:44:50 hserver 10fix_privilege_tables: ERROR 1060 (42S21) at line 28: Duplicate column name 'Grant_priv'
Jul 31 04:44:50 hserver 10fix_privilege_tables: ERROR 1060 (42S21) at line 29: Duplicate column name 'Grant_priv'
Jul 31 04:44:50 hserver 10fix_privilege_tables: ERROR 1060 (42S21) at line 30: Duplicate column name 'Grant_priv'
Jul 31 04:44:50 hserver 10fix_privilege_tables: ERROR 1060 (42S21) at line 41: Duplicate column name 'ssl_type'
Jul 31 04:44:51 hserver 10fix_privilege_tables: ERROR 1054 (42S22) at line 87: Unknown column 'Type' in 'columns_priv'
Jul 31 04:44:51 hserver 10fix_privilege_tables: ERROR 1060 (42S21) at line 93: Duplicate column name 'type'
Jul 31 04:44:51 hserver 10fix_privilege_tables: ERROR 1060 (42S21) at line 103: Duplicate column name 'Show_db_priv'
Jul 31 04:44:51 hserver 10fix_privilege_tables: ERROR 1060 (42S21) at line 120: Duplicate column name 'max_questions'
Jul 31 04:44:51 hserver 10fix_privilege_tables: ERROR 1060 (42S21) at line 130: Duplicate column name 'Create_tmp_table_priv'
Jul 31 04:44:51 hserver 10fix_privilege_tables: ERROR 1060 (42S21) at line 133: Duplicate column name 'Create_tmp_table_priv'
Jul 31 04:44:52 hserver 10fix_privilege_tables: ERROR 1061 (42000) at line 141: Duplicate key name 'Grantor'
Jul 31 04:44:54 hserver 10fix_privilege_tables: @hadGrantPriv:=1
Jul 31 04:44:54 hserver 10fix_privilege_tables: 1
Jul 31 04:44:54 hserver last message repeated 2 times
Jul 31 04:44:54 hserver 10fix_privilege_tables: @hadShowDbPriv:=1
Jul 31 04:44:54 hserver 10fix_privilege_tables: 1
Jul 31 04:44:54 hserver last message repeated 2 times
Jul 31 04:44:54 hserver 10fix_privilege_tables: waiting for mysqld to restart
Jul 31 04:44:55 hserver mysql.init: Loading 10fix_privilege_tables into mysql succeeded
Jul 31 04:44:56 hserver mysql.init: Loading 20mysql_migrate_horde into mysql succeeded

Thats not all of it only the error parts pasted. I am not sure of what to look for. I am dead in the mud!