Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: DarkMirage on May 06, 2005, 08:11:33 PM

Title: Open-Xchange (SME7): progress, requests, testing
Post by: DarkMirage on May 06, 2005, 08:11:33 PM
The following describes the procedure to install Open-Xchange 0.8 RC1 on SME7 (started this thread with alpha9)

I've posted this here for testing, and requests for features to be included in this script.
I plan to change a lot on the interface (adding a server-manager panel for openexchange options and integrating user administration), however, at this point I'm just trying to keep the script working, with the progress made in sme 7 development.

You need 2 boxes, or network storage while reinstalling the same box.
Testing has been done on clean installations only, and included logging in with the mailadmin account, a useraccount with webmail access (existing sme user) and a user without webmail access (user doesn't exist in sme).

Get the following Java files (links are to Java License Agreement):
The jta files are in the same place.
jdk-1_5_0_03-linux-i586.bin (http://javashoplm.sun.com/ECom/docs/Welcome.jsp?StoreId=22&PartDetailId=jdk-1.5.0_03-oth-JPR&SiteId=JSC&TransactionId=noreg)
javamail-1_3_2.zip (http://javashoplm.sun.com/ECom/docs/Welcome.jsp?StoreId=22&PartDetailId=javamail-1_3_2-oth-JPR&SiteId=JSC&TransactionId=noreg)
jaf-1_0_2-upd.zip (http://javashoplm.sun.com/ECom/docs/Welcome.jsp?StoreId=22&PartDetailId=7017-jaf-1.0.2-oth-JPR&SiteId=JSC&TransactionId=optreg)
jta-1_0_1B-classes.zip (http://javashoplm.sun.com/ECom/docs/Welcome.jsp?StoreId=22&PartDetailId=7083-jta-1.0.1B-mr-spec-oth-JSpec&SiteId=JSC&TransactionId=noreg)
jta-1_0_1B-doc.zip] (http://javashoplm.sun.com/ECom/docs/Welcome.jsp?StoreId=22&PartDetailId=7083-jta-1.0.1B-mr-spec-oth-JSpec&SiteId=JSC&TransactionId=noreg)
jmx-1_2_1-ri.zip (http://javashoplm.sun.com/ECom/docs/Welcome.jsp?StoreId=22&PartDetailId=7657-jmx-1.2.1-oth-JPR&SiteId=JSC&TransactionId=noreg)

From the directory containing the above, enter the following commands:
Code: [Select]
wget http://ainigma32.lir.dk/ainigma32/Open-Xchange-devel
chmod +x Open-Xchange-devel; ./Open-Xchange-devel

This should take some time depending on your download and computer speed...

The script may halt on missing files. Here's what to do:
Check file OX-missing.list
Code: [Select]
pico OX-missing.list

Get any missing packages
You should re-run the wget file, it will not download existing packages.
It will place found packages in the right directory.
That goes for packages previously downloaded, packages in the current directory and packages downloaded just now, in that order.

When it's done you can save /SME7Open-Xchange-devel.tgz so you can skip the download if you're going to start over. It does not include the initial script, so include that with the backup.

Copy /SME7Open-Xchange.tgz to a clean installation (or a network path while you reinstall the same box). You should move into it's dir or specify a path with the tarball. Then execute the install script.
Code: [Select]
tar -zxPf SME7-Open-Xchange.tgz
./Open-Xchange-install


Enter a new mailadmin password and wait untill it finishes. (This took ca 30 min. during tests)

You should be able to login at http://<yourdomain>/cgi-bin/login.pl with the mailadmin account.

You can add users as follows:
Code: [Select]
/usr/local/ox/sbin/adduser_ox \
 --username='doej' \
 --passwd='<yourpass>' \
 --name='John' \
 --sname='Doe' \
 --maildomain='<yourdomain>' \
 --ox_timezone='Europe/Amsterdam'


Notes:

mailadmin is the ox admin account, it doesn't have a mailaccount by default (webmail will fail)
Quickfix: Add the mailadmin account to sme
Planning: Find out deps on mailadmin account, and alter to uid admin
users not added to sme do not have imap access.
Quickfix: add users to sme after adding to ox
Planning: Full sme-ox collaboration integration
Setup on groupware is dead link
Quickfix: none (don't follow link)
Explanation: Links to umin, which isn't installed
Planning: Find out where link is created, and either remove or link to server-manager
   
I've used a lot of sources for this, including the phpwiki page right here on contribs.org, and would like to thank everyone posting helpfull info on this. I'll try to work out a list of sources to put into a later (hopefully completely working) version of this howto.
(edit) Typo
Title: Re: Open-Xchange (SME7): progress, requests, testing
Post by: CharlieBrady on May 06, 2005, 09:14:07 PM
Quote from: "DarkMirage"

Get the following Java files (links are to Java License Agreement):


Java licensing is sooooo tedious ...

Quote

From the directory containing the above, enter the following commands:
Code: [Select]
wget http://ainigma32.lir.dk/ainigma32/Open-Xchange-devel
chmod +x Open-Xchange-devel; ./Open-Xchange-devel



You could do that in one step via:

Code: [Select]

lynx -dump http://ainigma32.lir.dk/ainigma32/Open-Xchange-devel | sh
Title: Open-Xchange (SME7): progress, requests, testing
Post by: ergozd on May 07, 2005, 08:34:38 AM
Hi DarkMirage!

Package axis was updated to axis-1.2-1jpp.noarch.rpm, after modification script runs without any problem (so far, Building Java... right now).

Will post results l8r.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: ergozd on May 07, 2005, 08:55:51 AM
Hi again!

openexchange RPMS didn't built,

Code: [Select]
[root@smedev7 SPECS]# rpmbuild -ba openexchange.spec
Executing(%prep): /bin/sh -e /usr/src/redhat/TMP/rpm-tmp.83135
+ umask 022
+ cd /usr/src/redhat/BUILD
+ exit 0
Executing(%build): /bin/sh -e /usr/src/redhat/TMP/rpm-tmp.35782
+ umask 022
+ cd /usr/src/redhat/BUILD
error: Bad exit status from /usr/src/redhat/TMP/rpm-tmp.35782 (%build)


RPM build errors:
    Bad exit status from /usr/src/redhat/TMP/rpm-tmp.35782 (%build)


Code: [Select]
#!/bin/sh

  RPM_SOURCE_DIR="/usr/src/redhat/SOURCES"
  RPM_BUILD_DIR="/usr/src/redhat/BUILD"
  RPM_OPT_FLAGS="-O2 -g -march=i386 -mcpu=i686"
  RPM_ARCH="i386"
  RPM_OS="linux"
  export RPM_SOURCE_DIR RPM_BUILD_DIR RPM_OPT_FLAGS RPM_ARCH RPM_OS
  RPM_DOC_DIR="/usr/share/doc"
  export RPM_DOC_DIR
  RPM_PACKAGE_NAME="open-xchange"
  RPM_PACKAGE_VERSION="0.8.0"
  RPM_PACKAGE_RELEASE="sme7"
  export RPM_PACKAGE_NAME RPM_PACKAGE_VERSION RPM_PACKAGE_RELEASE



  set -x
  umask 022
  cd /usr/src/redhat/BUILD
{
cd 'open-xchange-0.8.0-RC1'
make
} > /dev/null 2> /dev/null
exit 0
Title: Open-Xchange (SME7): progress, requests, testing
Post by: DarkMirage on May 07, 2005, 11:35:24 AM
Updated the axis package (in the list)

ergozd, maybe you could tell me some more about your setup?
(edit) Nevermind, the new axis package was missing an extra dependency, which has been added.

I'm currently running some more tests on alpha9 and alpha10, and I'll try to include some different server configurations.

Charlie, your 1-command option doesn't work. It breaks lines, which breaks the script...
Title: Open-Xchange (SME7): progress, requests, testing
Post by: tbcomputing on May 07, 2005, 12:17:52 PM
Could not retrieve Open-Xchange-install.
Known source was http://ainigma32.lir.dk/ainigma32/Open-Xchange-install.

Could not retrieve openexchange.spec.
Known source was http://ainigma32.lir.dk/ainigma32/openexchange.spec.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: DarkMirage on May 07, 2005, 12:43:19 PM
Sorry, had some trouble with webserver.
Seems alpha10 has some strange dns habits (resolved our gateway on external ip, and did get the specified file  :-? ).
Should all be good now.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: tbcomputing on May 07, 2005, 01:57:01 PM
tar -zxPf SME7Open-Xchange.tgz

Should be

tar -zxPf SME7-Open-Xchange.tgz
Title: Open-Xchange (SME7): progress, requests, testing
Post by: tbcomputing on May 07, 2005, 02:55:50 PM
Ok

Installed on SME7 alpha 10.

Twin pentium 333 256 MB ram, adaptec 2940 and IBM eepro 100 NIC in server only mode.

Install went fine, mailadmin logged in but message is:

Permision denied
You don't have the permission to access this page.

in calendar, contacts, tasks.

Others OK

Must be a pemission error somewhere.

Will try to sort later

Tony
Title: Open-Xchange (SME7): progress, requests, testing
Post by: ergozd on May 07, 2005, 03:09:04 PM
I think I found what the problem was. Java (jdk-1_5_0_03-linux-i586.bin) was NOT installed. I've run and installed it manually.

May be another minor issue, I saw in Open-Xchange-intall.err file that axis was not installed, it requires jakarta-commons-httpclient3 RPM which was not fetched by Open-Xchange-devel script.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: CharlieBrady on May 07, 2005, 03:50:17 PM
Quote from: "DarkMirage"

Seems alpha10 has some strange dns habits (resolved our gateway on external ip, and did get the specified file  :-? ).


Nobody (including you) has reported any strange dns habits. Bug tracker is at smeserver.sourceforge.net.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: Denbert on May 08, 2005, 04:36:49 PM
Hi DarkMirage,

Just installed OX on Alpha10 this morning – Worked perfect.

I’ll definitely follow this promising project, and are looking forward to se full integration in SME.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: tbcomputing on May 08, 2005, 05:16:57 PM
Interesting - mine did not install properly - mailadmin partly works, new user did not work at all.

Going to try again now.

Have taken a processor out of the box so its a single CPU now.

Are there any twin CPU issues?

If successful this time will post question on OX forum.

Tony.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: jester on May 08, 2005, 06:49:03 PM
DarkMirage,
A new "Secure Upgrade" of OpenXchange (0.8.0-1) has been released.

Jester.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: tbcomputing on May 08, 2005, 09:12:22 PM
Update

Re-installed.

New user created first in OX then in SME works fine.

mailadmin user can log in but cannot access calendar, contacts and tasks.

Denbert

Are you quite sure it is all working, can you access the calendar, contacts and tasks with the user mailadmin?

If so, I dont know what the issue is - it cant be me since all I've done is exactly as per the instruction.

But, DarkMirage, you've succeeded where no one else has before and got OX to work on SME.

Well done!

Tony
Title: Open-Xchange (SME7): progress, requests, testing
Post by: Denbert on May 08, 2005, 09:25:27 PM
Sorry, my mistake.

I made a user account on OX and afterwards on SME – This user works fine.

The mailadmin user can’t use calendar as DarkMirage already wrote.

Any suggestions regarding client if I don’t want to use a browser? I don’t se any point in installing Outlook  :hammer:
Title: Open-Xchange (SME7): progress, requests, testing
Post by: Denbert on May 08, 2005, 09:45:09 PM
Hi again,

User Setup doesn’t work?

Please see http://hegnstoften.net/ox/user_setup_error.jpg

Is it an issue due to setup on SME or an OX issue?
Title: Open-Xchange (SME7): progress, requests, testing
Post by: tbcomputing on May 08, 2005, 09:47:01 PM
DarkMirage said in the instructions that it does not work.

I think you have to upload some .war files

Tony
Title: Open-Xchange (SME7): progress, requests, testing
Post by: tbcomputing on May 08, 2005, 10:40:10 PM
There is a problem with Tomcat5/apache/jk

in httpd log

mod jk log

worker=ajp13 failed

Also cannot access Tomcat via

http://yourdomain:8080/manager/html

If this can be resolved I think the .war files for user admin can be loaded.

This may also be the reason why a request to add a calendar item creates a load of disk activity on the server before it can be created.

Hope this helps

Tony
Title: OX-Look => outlook connector
Post by: jester on May 09, 2005, 08:58:06 AM
Denbert,

You can dowload a connector for outlook (OX-Look) from the open-xchange.org site afaik.

Jester.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: DarkMirage on May 09, 2005, 10:42:00 AM
Well, the rights for the mailadmin are easily fixed with this:
Code: [Select]
/usr/local/ox/sbin/addusersql_ox --username=mailadmin --lang=EN
I will include this in the script later.

I'm working on the integration of user collaboration at the moment, which seems to be going alright. I will probably use ldap-like actions to insert the proper entries, but I still need to figure out what the addusersql script does, as I don't like the Open-Xchange scripts, imho they are to widely compatible (meaning inefficient if the environment is known anyway).

@tbcomputing: I've minimised the mod_jk and tomcat entries, so that's probably why the manager isn't working (where does it say you should be able to access http://yourdomain:8080/manager/html in my posts?  :-D ) Opening several ports and sites and servlets looks unsecure to me. Don't know where your error is coming from though.

@jester: I can't keep up with both the ox updates and the sme7 upgrades, but I'll do my best to start using new versions as soon as possible.

@charlie: I don't know if it's a bug; I used a kind-of weird setup, and it worked anyway... What I did find, which I'll look into further before posting a bug, is squid failing on a dns lookup (no internet access), which causes the local webserver to remain silent on requests, although it's running
Title: Open-Xchange (SME7): progress, requests, testing
Post by: tbcomputing on May 09, 2005, 12:46:04 PM
DarkMirage

I take your point about the tomcat/jk and your script.

I will try and find out some more about my error.

I think I may need a better test platform

Tony
Title: Open-Xchange (SME7): progress, requests, testing
Post by: DarkMirage on May 10, 2005, 08:52:53 PM
Updated the script/installation with the following:

User integration: No more commandline
Just add users and groups as you always do,
reset the password (also for existing users),
and login at Open-Xchange :-D

Removed a wrong template fragment
Since I excluded php pgsql, the php.ini entry was invalid

Corrected permissions for mailadmin
Mailadmin shouldn't have any 'permission denied' anymore.
Also resolved a duplicate sql entry for mailadmin.

Set mailadmin to use the system password
The password needs to be reset once before use.
Notice:
If you add the mailadmin user for webmail access, it's password will be either the system password or the mailadmin password, whichever was reset last. This will be fixed shortly.
Fixed

Commented out script correctfilespool
Really, what does this do, except for extend the installation time?
So, installation went down to ca 10 min. here. I will analyze/rewrite the script later.

Planning (next up is):

Configuration panel
A server manager panel to configure/modify the ConfigDB entry.
Still waiting for requests, and still wondering which settings are most likely to be changed during usage.
So far I've only included the default user settings, plus a enable/disable option.

Update/upgrade to Open-Xchange 0.8.0-1 and alpha 11
No actual changes expected (I'll find out when I get there)
Title: Open-Xchange (SME7): progress, requests, testing
Post by: rcasado on May 10, 2005, 11:20:46 PM
Really taking shape nicely! :hammer:

There is a missing file: Could not retrieve perl-Authen-PAM-0.15-1.1.el3.rf.i386.rpm.
Known source was http://dag.wieers.com/packages/perl-Authen-PAM/perl-Authen-PAM-0.15-1.1.el3.rf.i386.rpm.

Changed the source in the script to: http://apt.sw.be/dries/packages/ and it resolved the problem here.

Cheers,
Richard
Title: Open-Xchange (SME7): progress, requests, testing
Post by: jester on May 13, 2005, 02:11:02 PM
DarkMirage,

you was waiting for some requests, so.... I'm just pooring out my mind:
- WebDAV support
- SyncML support (http://www.open-xchange.org/oxwiki/SyncML)
- support for user authentication on remote Win or SME(samba)domain (http://no.longer.valid/phpwiki/index.php/SME%20Domain%20Client%20Howto)
- start/stop/restart of ox in configuration panel
- option to deny users use of ox, ox-webinterface or shutdown of ox-webinterface in configuration panel
- installation of language-packs trough configuration panel

Just some thoughts, i only would need WebDav myself for now but i could imagine the others beeing usefull for somebody. I hope to finally find time to give your work a go next week.
So far you've done a hell of a job!!!

Jester.
Title: ERROR: Authentification failed on w/alpha12
Post by: jfarschman on May 16, 2005, 07:37:58 PM
Hi,

  I just did an install with 7.0alpha12 and it all pretty much work... except that I cannot login to the login.pl screen.  I get an Authentification [sic] error.

My Open-Xchange-install.err file is pretty clean.  I had the following issues:

  A. Several rpm warnings:

     warning: ant-1.6.2-3jpp.noarch.rpm:
     V3 DSA signature: NOKEY, key ID c431416d

     This doesn't look serious because when I do an
     rpm -qa | grep ant I can see that they are all
     installed.

  B. Tomcat shutdown specified twice:
     
     60shutdownwait' specified more than once

  C. Two psql entries:

     psql:/usr/local/ox/share/init_database.sql:1103:
     NOTICE:  CREATE TABLE / PRIMARY KEY will create
     implicit index 'attachments_pkey' for table
     'attachments'

  D. Can't Connect to LDAP Server:

     ldap_bind: Can't contact LDAP server

The last one seems like it would cause an authentication failure.  I did a little checking.  I have 5 slapd daemons running, but I try to authenticate in the login.pl window I det an "err=49" (password... I don't think so  I tried that)  I have to say Alpha12 is the first release I've tried this on.


Code: [Select]

May 16 11:34:51 hook slapd[1581]: daemon: conn=16 fd=9 connection from IP=127.0.0.1:32805 (IP=0.0.0.0:389) accepted.
May 16 11:34:51 hook slapd[2527]: conn=16 op=0 BIND dn="" method=128
May 16 11:34:51 hook slapd[2527]: conn=16 op=0 RESULT tag=97 err=0 text=
May 16 11:34:51 hook slapd[2527]: conn=16 op=1 BIND dn="UID=MAILADMIN,OU=USERS,OU=OXOBJECTS,DC=HITECHSAVVY,DC=COM" method=128
May 16 11:34:51 hook slapd[2527]: conn=16 op=1 RESULT tag=97 err=49 text=
[/code]
Title: Open-Xchange (SME7): progress, requests, testing
Post by: jfarschman on May 17, 2005, 01:44:50 AM
Okay...

  I have a few files with bad ownership.  Did I run the script wrong?

Code: [Select]

ls -l /var/lib/ldap
total 128
-rw-------    1 ldap     ldap        16384 May 16 12:46 cn.dbb
-rw-------    1 ldap     ldap        24576 May 16 12:46 dn2id.dbb
-rw-------    1 root     root         8192 May 15 18:08 gidNumber.dbb
-rw-------    1 root     root         8192 May 15 18:08 givenName.dbb
-rw-------    1 ldap     ldap        24576 May 16 12:46 id2entry.dbb
-rw-------    1 ldap     ldap         8192 May 16 12:46 mail.dbb
-rw-------    1 ldap     ldap         8192 May 16 12:46 nextid.dbb
-rw-------    1 ldap     ldap         8192 May 16 12:46 objectClass.dbb
-rw-------    1 root     root         8192 May 15 18:08 sn.dbb
-rw-------    1 ldap     ldap         8192 May 16 12:46 uid.dbb
-rw-------    1 root     root         8192 May 15 18:08 uidNumber.dbb


After that I still have to add users to the command line first... then the SME GUI.  Otherwise it will not work.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: whistleruk on May 17, 2005, 03:15:37 PM
Anyone got this working through the MS Outlook connector?
Title: Open-Xchange (SME7): progress, requests, testing
Post by: jester on May 17, 2005, 03:57:06 PM
I've got the same messages as jfarschman on SME7.0alpha13 (although it says alpha12 ?!). Re-read the message from DarkMirage on installing OX and realised that i did not get any question on a mailadmin passwd, should this be?!

Jay, what should the proper ownership of the files in: /var/lib/ldap be?! (sorry.... i'm a newbie) I'm want to give that ox-look connector a go.

jester.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: DarkMirage on May 19, 2005, 03:33:31 AM
Sorry I haven't been around...

The complete data dir of ldap should be owned by ldap.
(chown -R ldap:ldap /var/lib/ldap)

I should tell you, since I'm creating a whole new install, I haven't been able to test with anything later then alpha 10. Not sure if anything changed..

It shouldn't be long now before I update the scripts and files.

The new version will include most of the options mentioned by Jester above, but I'll get in to that once I have it all working.
Thanks for the suggestions, Jester, I was just wondering about one thing, how are you testing for webdav? I don't know why it's not working, if it isn't...

Error 49 stands for invalid credentials. If you haven't changed /etc/openldap/ldap.conf, the root dn to be specific, it's probably your user, not Open-Xchange failing. Do you get a 'Authentication failed' message?
You might just try resetting the password for the user (in SME that is, it then should sync itself with OX).

Not getting the 'Enter password' prompt is correct, I removed it from the installation.
(edit)
Just checked my test installation for the ldap problem, seems since I've deprecated the use of slapadd in favor of ldapadd, all file ownerships remain correct.
Title: Had real trouble installing...
Post by: goodevans on May 20, 2005, 04:14:31 PM
Couldn't for the life of me work out where I was going wrong. It wasn't even building the open-exchange rpm. So I decided to to start installing a few things manually.

Yep. Bad download on probably two of the smallest files of all. Both the jta classes and docs were corrupt.

Moral of the story, if this doesn't work for you, check your downloaded files...

Works now tho. Thanks!
Title: WebDAV testing
Post by: jester on May 24, 2005, 05:35:06 PM
I've been fooling around with WebDAV (SME7 Alpha12) and after some adjustments i found on the OX forums got it working.

Because of Tomcat running as a different user than who owns the filespool you will get a: 'Can't access the filespool: Permission denied' error.
Found the solution on: http://www.open-xchange.org/cgi-bin/simpleforum.cgi?fid=02&topic_id=1112090510&highlight=webdav%20access%20filespool
To correct this:
Code: [Select]
chown -R tomcat4:tomcat4 /usr/local/ox/var/filespool
Also to access trough WebDAV the user must be part of a group:
Code: [Select]
/usr/local/ox/sbin/addusertogroup_ox --user='<username>' --group='<groupname>'i used the standard 'users' group

I don't know if the above adjustments pose a possible security risk, I'm to much of a newbie, so use at own risk!
@DarkMirage: do you know if this can do any harm?!

How to access OX trough WebDav can be found here:
http://www.open-xchange.org/oxwiki/Integrations
and
http://www.open-xchange.org/oxwiki/OXInterfaces

Jester.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: DarkMirage on May 25, 2005, 08:59:50 AM
Well, I'm no security expert either, but it seems harmless enough to me. I have already integrated the requirements for WebDav in the new version, since I found the wiki you specified  :-D

I was able to up/download documents, so it seems alright to me.

Once I have a first version of the server-manager panel, I'll update the version. This shouldn't take too long.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: guest22 on May 25, 2005, 11:40:04 AM
DarkMirage, would it be possible for you to create a new page on the wiki so you/we can have a consistent how-to where changes can be easily made ?

Thanks in advance, nice work!

ps. (Mathias, would you be so kind to setup the initial page for DarkMirage please?)
Title: Open-Xchange (SME7): progress, requests, testing
Post by: DarkMirage on May 25, 2005, 01:14:23 PM
Sounds like a good idea, I'll start setting up a quick install/ some basic documentation
(That is, for my part of the installation, I'll leave the documentation for Open-Xchange to http://www.open-xchange.org/cgi-bin/simpleforum.cgi and http://www.open-xchange.org/oxwiki/Open Xchange Wiki (http://www.open-xchange.org/oxwiki/Open_2dXchange_20Wiki))
Title: Open-Xchange (SME7): progress, requests, testing
Post by: guest22 on May 25, 2005, 01:19:11 PM
@DarkMirage,

Thanks, usually every how-to will be accompanied by a feedbackpage so all users/testers can enter the SME Server specific info/findings/results.

Another great addition!

Thanks,

guest
Title: Open-Xchange (SME7): progress, requests, testing
Post by: rcasado on May 27, 2005, 02:02:10 AM
Everything appears to be working smoothly on Alpha15 except in Documents / File Uploads. Getting an error: "An error ocurred saving the documents to the database". Anyone else run into this?

Really great addition to SME7 DarkMirage  :-)
Title: Open-Xchange (SME7): progress, requests, testing
Post by: guest22 on May 27, 2005, 07:52:27 AM
Quote from: "rcasado"
Everything appears to be working smoothly on Alpha15 except in Documents / File Uploads. Getting an error: "An error ocurred saving the documents to the database". Anyone else run into this?


Sounds like a wrong permissions on those directories. Please check the Open-Xchange default install docs either ontheir site or within the package.

guest
Title: Open-Xchange (SME7): progress, requests, testing
Post by: jester on May 27, 2005, 09:32:54 AM
I've been trying the OX-look connector on Outlook2000 and DirkMirage's OX installation on SME7 Alpha12 and it works. Just download here:
http://www.openexchange.com/EN/download/

and follow the instructions found here:
http://www.open-xchange.org/oxwiki/OXLook

Must say that i thought this was a GPL-ed connector allso, but found out it costs: 20,-USD/20,-EUR per seat (reasonable price though). The beta of this connector is free for download, but has a restriction though... you have to switch between the functions Tasks, Appointments and Contacts (found in the menu: Extra > OXlook > 'Restriction'-tab). Maybe the opensource connector (http://www.openconnector.org/) might do the trick in the future as well.

Jester.
Title: Dissapeared!
Post by: dswillia on June 02, 2005, 12:25:37 AM
Does anyone have a active link for DarkMirage's script.  I just installed alpha 16 and would like to give it a shot, however it seems that the host is down.

Regards
Title: Open-Xchange (SME7): progress, requests, testing
Post by: guest22 on June 02, 2005, 03:33:03 PM
There you go:

http://no.longer.valid/phpwiki/index.php/Open-Xchange%20scripts

That's the beauty of the wiki ;-)
Title: Open-Xchange (SME7): progress, requests, testing
Post by: gregswallow on June 02, 2005, 04:27:39 PM
Ans here is another link for one file downloaded by the script:
http://mirror.contribs.org/smeserver/contribs/gswallow/open-xchange/Open-Xchange-files.tgz

...I downloaded that May 17th (files inside are from May 10th), not sure if it had changed since then.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: gregswallow on June 02, 2005, 04:32:01 PM
I was planning to work on this soon, but in the meantime why doesn't someone save us all a little time and upload the rpms created by all the 'rpmbuild -bb' commands in the script somewhere.   (But change all to -ba so it builds the source rpm as well and upload both).
Title: Open-Xchange (SME7): progress, requests, testing
Post by: guest22 on June 02, 2005, 04:41:51 PM
I agree, a contrib area is free of charge.. Simply apply for one at staff AT contribs.org...
Title: Open-Xchange (SME7): progress, requests, testing
Post by: guest22 on June 03, 2005, 10:57:09 AM
Quote from: "guest22"
There you go:

http://no.longer.valid/phpwiki/index.php/Open-Xchange%20scripts


Sorry, that was not the correct and original script. Does anybody have the original script? If so, please add it to the wiki.

TIA
Title: Open-Xchange (SME7): progress, requests, testing
Post by: duncan on June 03, 2005, 10:59:33 AM
Quote from: "guest22"
I agree, a contrib area is free of charge.. Simply apply for one at staff AT contribs.org...


Do we have access to our contrib areas again?
Title: Open-Xchange (SME7): progress, requests, testing
Post by: DarkMirage on June 03, 2005, 12:30:34 PM
Wow, thats one really old script you're looking for  :-D .

I am at the point of (again) upgrading my newest development to the latest versions, and creating an updated install script. If nothing comes up, I should have it for you in 1 or 2 days.

It includes a better rpm-based installation, split from dependencies (meaning you may install and configure those yourself by ignoring the script).

I would be willing to place the rpm for OpenXchange, Java I'm not so sure about. Does anyone know where/how I can do that?

(edits)
Wait, it's right there..

Well, I have applied for a contrib area, and I am currently downloading the latest alpha. I noticed I was already up to date with Open-Xchange (v0.8.0-2) so that should save me some time.

Something which keeps on bugging me in the manager panel... Does anyone know what to trigger to have SME update the /home/e-smith/db/navigation/navigation.*?

Maybe I can find some db function at last moment..
If not, OpenXchange will remain below "Unknown"
Found it
Title: Open-Xchange (SME7): progress, requests, testing
Post by: gregswallow on June 03, 2005, 04:48:22 PM
Quote from: "duncan"
Do we have access to our contrib areas again?

Mine works, but I have read that others are not working too, so you're not alone.  I'll put open-exchange/java rpms into my directory if anyone has them made.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: gregswallow on June 03, 2005, 04:54:09 PM
Quote from: "DarkMirage"
Does anyone know what to trigger to have SME update the /home/e-smith/db/navigation/navigation.*?

Code: [Select]
signal-event post-upgrade and
Code: [Select]
reboot (when done) will always work when you are unsure.  In the yum panel for SME7 those will be the actions that will be available to be run after installing an addon.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: guest22 on June 03, 2005, 08:54:20 PM
I maintain 'mirror.contribs.org/smeserver/contribs/misc' which is the place for 'not yet have our own home or can not access our area'. So if you need a temp area, please let me know or even better send me your work, and I will put it up in 'mirror.contribs.org/smeserver/contribs/misc'. Ruffdogs is working on the FTP issue, Please let them know your _exact_ problem, it will help a great deal.

guest
Title: Open-Xchange (SME7): progress, requests, testing
Post by: DarkMirage on June 03, 2005, 11:00:01 PM
@greg, when I said I need the navigation db to be updated, I meant it needs to be rebuild by reading the headers in /etc/e-smith/web/functions...
The post-upgrade did not when I tested it.

I'm adding it using DB::db now, seems to work, although I need to get deeper into the rpm spec file scripting... At this point you need to initialise at least ones before the panel shows up right, and it will not be removed (well, a lot won't, as I haven't worked out the uninstall procedure just yet).

@HF, that would be great, maybe you could pm me with an address to send the tarball containing all rpms and scripts? I expect to have the last bugs worked out in one or two days.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: CharlieBrady on June 03, 2005, 11:20:05 PM
Quote from: "DarkMirage"
@greg, when I said I need the navigation db to be updated, I meant it needs to be rebuild by reading the headers in /etc/e-smith/web/functions...
The post-upgrade did not when I tested it.

I'm adding it using DB::db now, seems to work, although I need to get deeper into the rpm spec file scripting...


Please join one of the developer mailing lists (devinfo, or the developer list at sourceforge) and ask your questions there. A good number of the people there who could help you don't hang out in the Forums. I'm sure they'd be interested to know what you are up to, and be happy to help.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: gregswallow on June 03, 2005, 11:51:18 PM
Quote from: "DarkMirage"
@greg, when I said I need the navigation db to be updated, I meant it needs to be rebuild by reading the headers in /etc/e-smith/web/functions...
The post-upgrade did not when I tested it.

Charlie's right - better to join the sourceforge mailing list at this point.  You've done an awesome job so far figuring things out - I think we have a good basis for making a smeserver-openxchange rpm now for the configuration.

I said post-upgrade AND reboot ;-)  Check again after the reboot.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: DarkMirage on June 04, 2005, 12:16:23 AM
Actually, the version I am currently working on has an array of new functions, and is rpm-based (I have managed to include all Open-Xchange specific configuring into the rpm and the events the service uses.)

All that is needed besides installing the e-smith-open-xchange##.rpm, as I have named it, is installing the dependencies and doing some very minimal configuring to get them to work with Open-Xchange.

I would like to say all is going well with the new install, however...I started using alpha 17, which really doesn't do much for the new server-manager panel (see the alpha dev thread).

I have subscribed to the mailing list, and will be watching it for a bit before asking. Still plenty I want to try myself ( I am trying to learn a bit from this.. ).
Title: Open-Xchange (SME7): progress, requests, testing
Post by: guest22 on June 04, 2005, 09:19:34 AM
@DarkMirage: Mail me at RequestedDeletion .a t. star-support.com
Title: Open-Xchange (SME7): progress, requests, testing
Post by: kmccarn on June 04, 2005, 03:14:43 PM
The command you are probably looking for is:

/etc/e-smith/events/actions/navigation-conf

and ignore all the error messages.

 :-D
Title: Open-Xchange (SME7): progress, requests, testing
Post by: DarkMirage on June 04, 2005, 04:23:25 PM
Thanks for the posts but I actually figured out how to do this in the rpm (spec file):
Code: [Select]
%post
/sbin/e-smith/db \
/home/e-smith/db/navigation/navigation.en-us \
set OpenXchange service status uninitialised
%postun
/sbin/e-smith/db \
/home/e-smith/db/navigation/navigation.en-us \
delete OpenXchange


This is exactly what I wanted, so it's al good now (untill I start adding languages offcourse  :hammer: )
Title: Open-Xchange (SME7): progress, requests, testing
Post by: DarkMirage on June 04, 2005, 08:59:36 PM
The Wiki (http://no.longer.valid/phpwiki/index.php/Open-Xchange%20scripts) has been updated, and includes a link to the complete installation package, no longer requiring any builds

I'll be writing some usefull documentation to add to the wiki, and following up on some changes i've been thinking of
(although it should be a while before I post any changes).

Please post/comment any problems you find during testing so I can have a look at those.
Title: errors..
Post by: jazbokes on June 05, 2005, 09:36:24 AM
[root@dallas openxchange]# tar -zxPf SME7-Open-Xchange.tgz
[root@dallas openxchange]# ls
e-smith-open-xchange  SME7-Open-Xchange.tgz
[root@dallas openxchange]# ./e-smith-open-xchange
useradd: user ox exists
useradd: user tomcat4 exists
warning: /OX-tmp/ant-1.6.2-3jpp.noarch.rpm: V3 DSA signature: NOKEY, key ID c431416d
warning: /OX-tmp/fontconfig-2.2.1-13.i386.rpm: V3 DSA signature: NOKEY, key ID 025e513b
warning: /OX-tmp/perl-IO-Socket-SSL-0.94-0.dag.rhel3.noarch.rpm: V3 DSA signature: NOKEY, key ID 6b8d79e6
########################################### [100%]
        package XFree86-libs-data-4.3.0-81.EL is already installed
        package fontconfig-2.2.1-13 is already installed
        package XFree86-libs-4.3.0-81.EL is already installed
        package XFree86-Mesa-libGL-4.3.0-81.EL is already installed
./e-smith-open-xchange: line 6: /etc/init.d/rhdb: No such file or directory
su: user postgres does not exist
ERROR: Cannot create output file //var/lib/pgsql/data/pg_hba.conf.5302 No such file or directory
 at /sbin/e-smith/expand-template line 45
ERROR: Cannot create output file //etc/tomcat5/tomcat5.conf.5303 No such file or directory
 at /sbin/e-smith/expand-template line 45
./e-smith-open-xchange: line 32: /etc/init.d/rhdb: No such file or directory
./e-smith-open-xchange: line 33: /etc/init.d/tomcat5: No such file or directory
Title: Open-Xchange (SME7): progress, requests, testing
Post by: guest22 on June 05, 2005, 10:55:53 AM
@jazbokes: Did you start that on a clean and fresh install, or did you already tried the 'old' script?
Title: Open-Xchange (SME7): progress, requests, testing
Post by: DarkMirage on June 05, 2005, 11:21:47 AM
Clearly not a clean install..
You might try forcing the rpms to install (--force), just have a look inside the script.
It's really short, so that should be easy to find.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: jazbokes on June 05, 2005, 05:56:38 PM
clean install on sme 7a15..  wl try again on fresh sme 7a15..install..
Title: Open-Xchange (SME7): progress, requests, testing
Post by: jazbokes on June 05, 2005, 07:17:44 PM
installed  fine.. & able to login as admin.. now when attempt to open email get  the following error:

WebMail - OPEN-XCHANGE 0.8.0-2
!!! SYSTEM - ERROR !!!

webmail is enabled..
Title: Open-Xchange (SME7): progress, requests, testing
Post by: gregswallow on June 05, 2005, 07:37:48 PM
Could you upload e-smith-open-xchange-0.5-0.noarch.*s*rpm as well please.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: tbcomputing on June 05, 2005, 09:19:56 PM
Thanks for your work Dark Mirage.

Installed fine on Alpha17.

Users alrady existing when OX is installed have access to the logon.

Users added post OX install get

ERROR: Authentification failed

when trying to login.

Created a group called oxusers annd added existing and new users to it, but new users still cannot login.

Will look into log files to see if I can find any more info

Tony
Title: Open-Xchange (SME7): progress, requests, testing
Post by: rcasado on June 05, 2005, 10:47:39 PM
Worked perfectly over here using alpha15  :-)

- Able to create, modify and delete users and rights from the Server Manager
- Able to set to upload files after changing ownership of the filespool directory
- System was set up as a stand alone server

The only 'hiccup' I've found is in the OX webmail servlet. User admin shows up correctly as admin@correct-domain-name.net while oxuser(s) created after OX was installed show up as oxuser(s)@localhost. Horde shows both type users correctly.

Exceptional work, especially considering the short amount of time you've had.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: DarkMirage on June 06, 2005, 03:19:59 PM
@jazbokes: I'm not sure why it stopped but I think your webmail might not be running, could you try "/etc/init.d/OpenXchange status"?

@greg: I'll have to build it first, but sure, why not.

@tbcomputing: Where did you reset your password? I fear the user-password page uses a different approach, resulting in an unset password (not empty though)
A group called oxusers... well, the oxgroup "users" already exists, and contains everybody. Not sure what you expected from that.

@rcasado: Thanks. The 'hiccup' is actually Open-Xchange built-in... :-? .
You might double check in ldap:
First lookup your ldap domain dn in /etc/openldap/ldap.conf (Something like dc=example,dc=org)
Then do a search for users' mail addresses:
Code: [Select]
ldapsearch -x -W \
-D uid=admin,ou=Users,ou=OxObjects,<domain dn> \
-b ou=Users,ou=OxObjects,<domain dn> \
-s one \
mail

Don't use any extra spaces (like after comma's)!
You should get prompted for the admin password.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: guest22 on June 07, 2005, 04:31:40 PM
Does anybody have a good procedure to connect outlook 2003 to Open-Xchange. Can't seem to get it goin'.

I have outlook 2003 with a connection to an MS-exachnge server. Installed OX-look.

Kinda lost here...
Title: Open-Xchange (SME7): progress, requests, testing
Post by: jester on June 07, 2005, 04:43:42 PM
@RequestedDeletion: This might help:  http://www.open-xchange.org/oxwiki/OXLook

Jester.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: guest22 on June 07, 2005, 05:10:35 PM
@jester: thanks, I've been there, but no luck

Does anybody know if the current OX-look plugin will expire and thus will not work anylonger. I noticed the OX-look plugin under the 'tool' menu bar, but it has disappeared.. :-( Reinstalling OX-look will not help.

Any help is appreciated.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: gregswallow on June 10, 2005, 08:32:30 PM
DarkMirage,
Is the sun jdk needed to *run* open-xchange, or just to compile the open-xchange rpm?  I don't think it can be distributed.  

Also Centos 3.5 include jaf, javamail, jakarta-regexp (same as regexp from jpackage), mx4j and bcel packages - can those be used instead of the ones from jpackage.org (which again, some are in the non-free section).  

I think a goal would be to see if we can make it work with whats included with Centos 3.5.  I posted a couple messages about open-xchange on the smeserver-developer list and that was the gist of the response I got.

Greg
Title: Open-Xchange (SME7): progress, requests, testing
Post by: guest22 on June 10, 2005, 08:41:19 PM
I installed DM's script on alpha19 with no problem. The problem is understanding how OX really works, and there is no 'TRFM' possible ;-)

For example, I have the 'feeling' that LDAP integration is not 100% there yet. But then again, it could just be my incompetence.

Interesting questions Greg, DM, you around?

guest

(edit: additional remark/question)
Title: Open-Xchange (SME7): progress, requests, testing
Post by: DarkMirage on June 10, 2005, 10:55:10 PM
I'm around...quietly mostly  :hammer:

Well, the best thing I can think of is testing and checking (and some more testing etc...)
Downloading alpha19 as we speak.. I wonder what will happen once I start pulling packages from the install.

About those packages, well, it not so much Open-Xchange which needs a lot, it's (what I found to be) Tomcat's dependencies (listed below).

Open-Xchange itself does need javamail monolithic (..for some mail.jar which would normally be split in smtp and ..err.. imap or something) and jdom (again some jar file)
Or maybe those just need to be included in the build and that's it  :-? Ah yes, more testing

Offcourse their are some dependencies which are simply needed by both, I just don't know which ones.

Tomcat (claims to) requires:
ant-1.6.2-3jpp.noarch.rpm
axis-1.2-1jpp.noarch.rpm
bcel-5.1-5jpp.noarch.rpm
fontconfig-2.2.1-13.i386.rpm
jaf-1.0.2-4jpp.noarch.rpm
jakarta-commons-beanutils-1.7.0-2jpp.noarch.rpm
jakarta-commons-collections-3.1-1jpp.noarch.rpm
jakarta-commons-daemon-1.0-2jpp.noarch.rpm
jakarta-commons-dbcp-1.2.1-3jpp.noarch.rpm
jakarta-commons-digester-1.6-2jpp.noarch.rpm
jakarta-commons-discovery-0.2-2jpp.noarch.rpm
jakarta-commons-el-1.0-3jpp.noarch.rpm
jakarta-commons-fileupload-1.0-3jpp.noarch.rpm
jakarta-commons-httpclient3-3.0-0.rc2.1jpp.noarch.rpm
jakarta-commons-launcher-0.9-3jpp.noarch.rpm
jakarta-commons-logging-1.0.4-2jpp.noarch.rpm
jakarta-commons-modeler-1.1-4jpp.noarch.rpm
jakarta-commons-pool-1.2-2jpp.noarch.rpm
java-1.5.0-sun-1.5.0.03-1jpp.i586.rpm
java-1.5.0-sun-devel-1.5.0.03-1jpp.i586.rpm
javamail-1.3.2-1jpp.noarch.rpm
jpackage-utils-1.6.3-1jpp.noarch.rpm
jta-1.0.1-0.b.4jpp.noarch.rpm
log4j-1.2.9-1jpp.noarch.rpm
mx4j-3.0.1-1jpp.noarch.rpm
regexp-1.3-2jpp.noarch.rpm
tomcat5-5.0.30-6jpp.noarch.rpm
tomcat5-jasper-5.0.30-6jpp.noarch.rpm
tomcat5-servlet-2.4-api-5.0.30-6jpp.noarch.rpm
tyrex-1.0.1-3jpp.noarch.rpm
wsdl4j-1.5-1jpp.noarch.rpm
xalan-j2-2.6.0-2jpp.noarch.rpm
xerces-j2-2.6.2-4jpp.noarch.rpm
XFree86-libs-4.3.0-81.EL.i386.rpm
XFree86-libs-data-4.3.0-81.EL.i386.rpm
XFree86-Mesa-libGL-4.3.0-81.EL.i386.rpm
xml-commons-1.0-0.b2.7jpp.noarch.rpm
xml-commons-apis-1.0-0.b2.7jpp.noarch.rpm
xml-commons-resolver-1.1-3jpp.noarch.rpm

I'll have a go at some of the options you came up with, and let you know...

About the ldap integration, well, I kinda noticed I broke resource management in the panel.. perhaps I'll create a quickfix later on.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: gregswallow on June 11, 2005, 02:08:50 AM
Quote from: "gregswallow"
I think a goal would be to see if we can make it work with whats included with Centos 3.5.

I've been doing a bit of reading on thew subject today - here are a few interesting websites to browse:

http://www.gnu.org/philosophy/java-trap.html
http://www.gnu.org/software/classpath/
http://www.gnu.org/software/classpathx/javamail/javamail.html
http://www.gnu.org/software/classpathx/jaf/jaf.html

Perhaps there are enough gpl'd java components to get open-xchange working.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: guest22 on June 11, 2005, 05:06:09 AM
Quote from: "DarkMirage"
I'm around...quietly mostly  :hammer:

Thx.

Quote from: "DarkMirage"
About the ldap integration, well, I kinda noticed I broke resource management in the panel.. perhaps I'll create a quickfix later on.

Ok, then my 'feeling' didn't fool me ;-) a quickfix would be very much appreciated!

guest
Title: Open-Xchange (SME7): progress, requests, testing
Post by: gregswallow on June 11, 2005, 06:00:38 AM
Also of interest, ClarkConnect has a beta OX 0.8 - I assume they have "legal" java rpms - they seem to have renamed them, but worth investigating what they use:

ftp://beta.clarkconnect.com/3.0/beta/
http://www.clarkconnect.org/projects/groupware.php

I don't see source rpms anywhere though :-(
Title: Open-Xchange (SME7): progress, requests, testing
Post by: guest22 on June 11, 2005, 06:46:36 AM
Quote from: "gregswallow"
I don't see source rpms anywhere though :-(


ftp://beta.clarkconnect.com/3.0/beta/

(edit: SOURCE, I should read better... :-( )
(edit2: I shouldn't reply at all if I do not read the post correctly!)
Title: Open-Xchange (SME7): progress, requests, testing
Post by: gregswallow on June 11, 2005, 09:23:50 AM
An alternative to ibm or sun's jdk would be java-1.4.2-gcj-compat from jpackage.org - Looks like that package is on its way into Fedora Core 4:
http://mirrors.kernel.org/fedora/core/development/SRPMS/java-1.4.2-gcj-compat-1.4.2.0-40jpp_30rh.src.rpm

Googled a bit of info here:
http://www.redhat.com/archives/fedora-devel-list/2004-September/msg00261.html
Title: Open-Xchange (SME7): progress, requests, testing
Post by: DarkMirage on June 11, 2005, 12:18:09 PM
Quote
An alternative to ibm or sun's jdk would be java-1.4.2-gcj-compat

Well, if you can get it installed ok, kudos  :roll: . I've just been resolving dependencies for half an hour, and I think this is really just for CentOS 4, not 3.x.

Java doesn't say you can't use anything, you just need to contact them for redistributing (haven't taken a closer look though).
I wouldn't be surprised if this is what clarkconnect did.

I have had little luck with classpath either, but I won't give up just yet.

I found 22 of the used packages in 3.5 repositories, so that's a good start.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: gregswallow on June 11, 2005, 05:41:42 PM
Quote from: "DarkMirage"
I wouldn't be surprised if this is what clarkconnect did.

Looks to me like they used the ibm java - which according to http://www-128.ibm.com/developerworks/java/jdk/linux140/jre-info.html ibm java 1.4.2 can be included with your product if:
Quote
You want the Runtime Environment for Linux to be installed in your product's directory and used only by the product.
You want to limit testing to a single Runtime Environment for Linux. This allows you to ship your product with a controlled environment.


And sorry, I shouldn't have put a link to that FC4 rpm, try the 'generic' one on jpackage:
http://mirrors.dotsrc.org/jpackage/1.6/generic/free/RPMS/java-1.4.2-gcj-compat-1.4.2.0-6jpp.noarch.rpm - it should require libgcj rpms from Centos.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: DarkMirage on June 11, 2005, 06:49:27 PM
It doesn't matter, I tried the src rpm, and even that failed miserably.

error: Failed dependencies:
        gcc-java >= 3.4 is needed by java-1.4.2-gcj-compat-1.4.2.0-6jpp
        libgcj >= 3.4 is needed by java-1.4.2-gcj-compat-1.4.2.0-6jpp

Ow yes, there it is again, we need everything upgraded to 3.4 (which is really, CentOS 4)

Same for classpath, anyway, requires gcj 3.4 (gcc-java 3.4)

I get the idea looking at the clarkconnect approach is our best bet...
<edits> I should focus when typing
Title: Open-Xchange (SME7): progress, requests, testing
Post by: DarkMirage on June 11, 2005, 07:23:03 PM
Just did some reading in the sme7 docs, and noticed it is supposed to end up as centos4 based.

I'll see how it works out for me to try and fork my search for a better java base in 3.5 aswell as 4.0 (using the upgrade howto)...
Title: Open-Xchange (SME7): progress, requests, testing
Post by: guest22 on June 11, 2005, 07:27:36 PM
DM, please do not forget about the quick fix, I sure could need it. Thx!

guest
Title: Open-Xchange (SME7): progress, requests, testing
Post by: DarkMirage on June 11, 2005, 07:54:53 PM
It's in the mail..
Title: Open-Xchange (SME7): progress, requests, testing
Post by: soprom on June 13, 2005, 01:43:02 AM
First, thank you all for such an effort.
Groupware is an important part of a local network and having such a package is a major option for the SME.

I installed on a SME7A19 without any error messages.

1. Resources
when I click on <Add Resource> I get this:
Code: [Select]
The requested URL /server-manager//cgi-bin/Resources was not found on this server.

2. Localization
Where do I add a language? Or is it too early in the dev stages...

3. Save settings
ERROR!Settings could not be stored in directory!

4. Public Folders
I cannot find how to add/access public folders. Can someone give me a hint?
Title: Open-Xchange (SME7): progress, requests, testing
Post by: dmac on June 13, 2005, 04:55:42 AM
Ok, having a bit of a problem today,

Did an clean install of 7.0 alpha 19, and used the rpm package created by Dark Mirage.  Used the Server-Manager panel to enable Open Exchange.  Used the Server-Manager panel to add a new user.  Reset the user password and everytime I try to login, I get Authentication Failed.  Checked the OX logs in the /ox/var/log folder and there error only states Authentication Failed, no code or anything.  

What am I doing wrong?
Title: Open-Xchange (SME7): progress, requests, testing
Post by: DarkMirage on June 13, 2005, 01:58:31 PM
Quote from: "soprom"
1. Resources

You're right, it should be pointing to OpenXchange instead of Resources.. (link is in /etc/e-smith/locale/en-us/etc/e-smith/web/functions/OpenXchange)
Will fix it soon..

Quote from: "soprom"
2. Localization
Where do I add a language? Or is it too early in the dev stages...

That's exactly what it is, it's in the roadmap...

Quote from: "soprom"
3. Save settings

Users will be allowed to change their pref's in the next update...(This should be optional later on)

Quote from: "soprom"
4. Public Folders

Try right clicking as admin? Haven't tested yet...

Quote from: "dmac"
Authentication Failed

I guess you checked sessiond and groupware logs?
Maybe any ldap messages in /var/log/messages?

Btw, I do hope you meant /usr/local/ox/var/log folder
Title: Open-Xchange (SME7): progress, requests, testing
Post by: jester on June 13, 2005, 02:32:38 PM
@DarkMirage: maybe something for the future in the manager panel -> activating and setting mailbox quota's?!

Jester.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: DarkMirage on June 13, 2005, 02:42:05 PM
OpenXchange plugs into the imap server,
so that should be handled by sme..?
Title: Open-Xchange (SME7): progress, requests, testing
Post by: gregswallow on June 13, 2005, 06:42:37 PM
Quote from: "DarkMirage"
Just did some reading in the sme7 docs, and noticed it is supposed to end up as centos4 based.

I'll see how it works out for me to try and fork my search for a better java base in 3.5 aswell as 4.0 (using the upgrade howto)...


SME7 will be Centos 3, not 4.  AFAIK, SME8 will be Centos 4, but I don't think work will begin on that until the bugs are all squashed for SME7.

Other bad news, according to Markus Klein (@open-xchange.org)...this is from a response to a message I posted on the ox-devel mailing list:
Quote

> Has anyone tried to get open-xchange to work without the non-free java
> packages?  I want it to be completely redistributable.  

This doesn't work because WebMail uses directly some classes of
com.sun.mail
for direct imap commands. This has to be rewritten if you want to use classpathx
javamail API instead of Sun's javamail API.


I think our best bet is to check out further what ClarkConnect is doing.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: guest22 on June 13, 2005, 07:04:48 PM
Quote from: "gregswallow"
I think our best bet is to check out further what ClarkConnect is doing.


I've tried that but got a reply: this mailbox doesn't exists'

guest
Title: Open-Xchange (SME7): progress, requests, testing
Post by: DarkMirage on June 13, 2005, 08:31:41 PM
Quote from: "gregswallow"
This has to be rewritten if you want to use classpathx
javamail API instead of Sun's javamail API.


I will look into that then..

Just finishing up on a first version of e-smith-tomcat5, next is e-smith-rh-postgresql
(you know, some basic templating and all) and perl-DBD-pg,
then I'll get into manipulation of the open-xchange source for use in e-smith-open-xchange..
I noticed many java rpms from the centos 3.5 mirrors are classpath(x) based, so I assume there is a way to get it up and running...

Offcourse this will all take a while, I'll see about correcting some bugs mentioned earlier in between..
Title: Open-Xchange (SME7): progress, requests, testing
Post by: gregswallow on June 13, 2005, 08:53:14 PM
Quote from: "DarkMirage"
Just finishing up on a first version of e-smith-tomcat5, next is e-smith-rh-postgresql
(you know, some basic templating and all) and perl-DBD-pg,
then I'll get into manipulation of the open-xchange source for use in e-smith-open-xchange..


You might want to rename them smeserver-xxx, that has been the suggestion on the devel list for other community contributed packages (eg, smeserver-yum).

If you need some help/have questions post to the smeserver-devel mailing list.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: DarkMirage on June 13, 2005, 09:37:05 PM
Right, so I subscribed, started looking at the archive...and noticed the ldap in alpha19 is already aci-enabled...
I was still installing them every time... :hammer:
I'll be quiet and do some more reading now...
Title: Open-Xchange (SME7): progress, requests, testing
Post by: pcbaldwin on June 15, 2005, 04:49:59 AM
Quote from: "guest22"

I've tried that but got a reply: this mailbox doesn't exists'
guest


What e-mail address did you use?  Regardless, I uploaded the spec files and all the related scripts & configs that we used to build the OpenXchange beta.        Grab the ox-specs.tar.gz file in http://download1.clarkconnect.com/3.0/other/

Warning: the tarzip unpacks into a bunch of openxchange-xyz directories... not ox-specs.  The following directories are probably of most interest:

- openxchange-openldap: the sandboxed LDAP build
- openxchange-postgresql: the sandboxed Postgres build
- openxchange: OpenXhange and our setup scripts

Just in case someone reads this post a few weeks from now... when the final version is released, the source RPMs will be found in the usual spot: http://download1.clarkconnect.com/3.1/sources/

Peter Baldwin
CTO Point Clark Networks
Title: Open-Xchange (SME7): progress, requests, testing
Post by: guest22 on June 15, 2005, 06:56:13 AM
Quote from: "pcbaldwin"
Quote from: "guest22"

I've tried that but got a reply: this mailbox doesn't exists'
guest


What e-mail address did you use?

Arrival-Date: Sat, 11 Jun 2005 01:21:24 -0400 (EDT)

Final-Recipient: rfc822; contact_nospam@clarkconnect.com
Action: failed
Status: 5.0.0
Diagnostic-Code: X-Postfix; unknown user: "contact_nospam"

Thanks for the info and pointers.

guest
Title: Open-Xchange (SME7): progress, requests, testing
Post by: gregswallow on June 15, 2005, 09:31:00 AM
Quote from: "pcbaldwin"
Grab the ox-specs.tar.gz file in http://download1.clarkconnect.com/3.0/other/

Peter, thanks for sharing your work in progress!  You guys must have done a bit of research on what is distributable and what isn't as far as Sun/IBM Java is concerned - it is confusing to say the least.  Looks like you've got it all legal though.  I wasn't sure about the jaf and javamail packages but after re-reading the 'Sun Binary Code Licence' for those, it seems ok.

Greg
Title: Open-Xchange (SME7): progress, requests, testing
Post by: gregswallow on June 15, 2005, 09:36:56 AM
Quote from: "DarkMirage"
...and noticed the ldap in alpha19 is already aci-enabled...


Yes, it seems Charlie is taking notice of your project - Did you post your src rpm's somewhere yet?
Title: Open-Xchange (SME7): progress, requests, testing
Post by: gregswallow on June 15, 2005, 09:42:16 AM
Quote from: "DarkMirage"
...and noticed the ldap in alpha19 is already aci-enabled...


Yes, it seems Charlie is taking notice of your project - Did you post your src rpm's somewhere yet?
Title: Open-Xchange (SME7): progress, requests, testing
Post by: DarkMirage on June 15, 2005, 10:05:55 AM
contribs/misc/open-xchange/SRPMS (http://"http://mirror.contribs.org/smeserver/contribs/misc/open-xchange/SRPMS/")

They have been there for a while, just forgot to mention it...
Title: Open-Xchange (SME7): progress, requests, testing
Post by: DarkMirage on June 15, 2005, 11:05:55 AM
I'm afraid I'm getting a bit lost on what is and isn't allowed with java.

Greg, maybe you can explain what you've found out so far?

I have been working on the gnu JVM, and have made some progress, but it's not getting anywhere fast..

Better news, I have a first version of both smesmerver-tomcat5 and smeserver-rh-postgresql working, and I have been able to use perl-DBD-pg to connect with postgres.

This means I can deprecate the extra userrights property in the accounts db, eliminating redudant data,
and perhaps provide more functionality in the panel, since I am now able to retrieve data from postgres.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: gregswallow on June 15, 2005, 05:06:19 PM
Quote from: "DarkMirage"
I'm afraid I'm getting a bit lost on what is and isn't allowed with java.


I think we should follow ClarkConnects example by using the IBM JRE.  Sun's Javamail and Jaf packages are OK to distribute, I had thought they weren't.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: pcbaldwin on June 15, 2005, 05:19:26 PM
Quote from: "gregswallow"
You guys must have done a bit of research on what is distributable and what isn't as far as Sun/IBM Java is concerned - it is confusing to say the least.  Looks like you've got it all legal though.  

Greg


The licensing issues were confusing.  Basically, you can distribute many of the Java libraries from Sun and IBM as long as you do not modify anything.  This was to protect against Microsoft-like shenanigans with "enhancing and extending" Java ... thereby introducing incompatibilities.  

Sun also requires that other JVMs (IBM, Kaffe) cannot be provided alongside its own JVM -- that's a bit rude but within their rights.  The licensing bothers the open source purists (Debian, and Red Hat to a certain extent), and that's within their rights too!
Title: Open-Xchange (SME7): progress, requests, testing
Post by: DarkMirage on June 15, 2005, 11:09:32 PM
Well, the IBM JRE (JVM) is the way go then.

I'll try to create a modified tomcat package, including the smeserver config I had created as a separate package,
and try to maintain as much functionality as possible.

The available tomcat rpms need packages which have been integrated with the Java JVM, so that's just not going to work as is.

edit) No, nevermind, it's working just fine with original packages.. I was doing it all wrong

I guess the licensing makes sense, and I wouldn't be bothered by it, if they would just say it as it is. I guess that would be (nearly) impossible when covering most legal loopholes? Anyway, so be it.

Thanks for the info, pcbaldwin, greg
Title: Ox updates
Post by: arnocazin on July 01, 2005, 10:59:18 PM
Is there an easy way to apply updates to ox
actually the ox version is 8.0.4
with the e-smith templates system can we simply apply  updates
Please help needed
thanks
Title: Open-Xchange (SME7): progress, requests, testing
Post by: DarkMirage on July 02, 2005, 12:04:21 AM
arnocazin, it really depends on what you're using. From what I've know, the current package doesn't even work on the latest alpha, which doesn't come as a surprise, looking at the differences since the (my) latest ox release.

If you're simply installing ox as described in the various howto's on open-xchange.org, it depends on the changes. If any files requiring compilation (for example .java) have been changed, you need to recompile those. You may offcourse replace any files which need to be updated instead of removing and replacing all.

A bigger problem is when they've updated the ldap schema, since all ldap entries need to be updated, for which I'm not sure how to explain an easy way. It really gets specific there (meaning I would need to know what changed to help you out).
The same sort of goes for postgresql.

All in all, best you look up the changes (as in file-based, not as in change-log) and go from there, either asking help here or using a method above.

Keep in mind that any alpha's and ox packages released up to now have been and still are for testing purposes only.

I can't tell you if something will break after updating, and you shouldn't be using a setup on which that matters.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: stefan24 on August 22, 2005, 12:53:21 PM
The script from DarkMirage is also not working on SME 7 beta1.

I get some dependency errors, which prevent the installation:

package perl-XML-NamespaceSupport-1.08-6 (which is newer than perl-XML-NamespaceSupport-1.08-1.dag.rhel3) is already installed

After installing several RPMs from the packages manually, there is a Open-Xchange panel, but it seems to be stuck at "Status    Initialising...".
Title: Open-Xchange (SME7): progress, requests, testing
Post by: guest22 on August 22, 2005, 01:02:19 PM
Quote from: "stefan24"
The script from DarkMirage is also not working on SME 7 beta1.


Thanks for the info. I actually do not know if DarkMirage is still working on this. I lost track of the status during the thoughts of the Sun licenses regarding Java related stuff.

guest
Title: Open-Xchange (SME7): progress, requests, testing
Post by: stefan24 on August 22, 2005, 01:12:21 PM
Quote from: "guest22"
I lost track of the status during the thoughts of the Sun licenses regarding Java related stuff.


Personally I do not mind downloading several packages manually, before starting a script, which does the rest automatically.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: gregswallow on August 23, 2005, 01:19:25 AM
The rpms needed have changed for Centos 4.1.  I haven't seen a howto for RHEL4, but there are howto's for OX on Fedora Core 3 (and jpackage.org has the RHEL4 rpms) which should be enough info to get you up and running if you want to work at it.  All the howtos I've seen use Sun Java.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: DarkMirage on August 25, 2005, 11:33:01 PM
I haven't looked at OX for some time, as sme7 development was going too fast for me.

I'll see about updating the script/packages/rpms where necessary when I find some time (which shouldn't be all that long from now).
Title: Open-Xchange (SME7): progress, requests, testing
Post by: guest22 on August 28, 2005, 08:19:49 AM
@DarkMirgae, YFYI the Open Source Jive Messenger uses the SUN java packages and are bundled with their Jive downloads. Maybe they have found a way to distribute Java legally??? ( http://www.jivesoftware.org/messenger/ )
Title: Open-Xchange (SME7): progress, requests, testing
Post by: sonoracomm on September 06, 2005, 09:15:25 PM
Hi DarkMIrage,

I just wanted to thank you, and everyone participating, for all your efforts towards OX and SME 7 integration.  Thank you.

I know how momentum plays a large part in everything we do...and I know we are all busy people trying to earn a living.  But I just want to say that I, for one, am extremely interested in this project, and the SME 7 project as a whole.

I believe that virtually everybody, and I do mean everybody, is looking forward to an updated SME Server with a great groupware package.  Not to belittle any previous and well appreciated contributions to the SME project, but I personally think this groupware contrib is second in importance only to the main SME Server itself.

Thanks again,

G
Title: Open-Xchange (SME7): progress, requests, testing
Post by: gregswallow on September 06, 2005, 11:09:09 PM
There are some groupware addons for Horde webmail though that I'm hoping to have included maybe in 7.1 (or as addons).  Check out www.horde.org.  Kronolith is a calendar app, Mnemo is for notes and memos, Gollem is a web-based file manager, and Nag is a task list app.   There are others as well.  

The rpms I made are not quite done yet, but there are some fairly simple instructions for getting Kronolith working here:
http://forums.contribs.org/index.php?topic=28690.msg119387#msg119387

I have rpms to install the files for Mnemo, nag and gollem, but not the configuration yet - If you have used horde 3 via John Bennett's howto for SME6, and know how to set up administration for Horde 3 have a go, otherwise wait for finished rpms:
http://mirror.contribs.org/smeserver/contribs/gswallow/wip/
Title: Open-Xchange (SME7): progress, requests, testing
Post by: sonoracomm on September 08, 2005, 06:49:21 PM
Hi Greg,

Thanks for your response. I appreciate it.

Kronolith looks pretty interesting...don't know about the other pieces.

Since I primarily support small businesses for a living, and since M$ has about a 95% market share in the Office Suite category, any groupware solution I recommend/support MUST be tightly integrated with MS Outlook.  I stress MUST, or it will not be accepted.

No matter how good/solid the groupware solution, solid, reliable Outlook integration is perhaps the toughest part.  Over the last two years we've implemented a couple of different commercial groupware solutions other than MS Exchange (which is good, but complicated and expensive).  Upgrading SME to Cyrus IMAP was the best so far, but I really fear the next SME upgrade.  Learning Cyrus is like learning Sendmail used to be...

We used the Bynari Outlook Connector because it seemed the best one we could find.  I think Bynari is _about_to_ finally ship a version that's got most bugs fixed (3.06).  Building an Outlook connector must be tough.  I'm still open to a new connector, if anyone knows a good one.

These are a couple of the reasons I'm really looking forward to this project...

Thanks again,

G
Title: Open-Xchange (SME7): progress, requests, testing
Post by: gregswallow on September 08, 2005, 08:23:22 PM
Quote from: "sonoracomm"

Since I primarily support small businesses for a living, and since M$ has about a 95% market share in the Office Suite category, any groupware solution I recommend/support MUST be tightly integrated with MS Outlook.  I stress MUST, or it will not be accepted.


Horde is working towards that - It is definitly in the development stage, but some things are possible now:
http://janschneider.de/cweb/home/index,channel,25,story,226.html
http://sync4j.org/
Title: Open-Xchange (SME7): progress, requests, testing
Post by: gregswallow on September 09, 2005, 10:25:14 PM
This is brand new.  You guys will like this...take a look at the hosted demo:
http://www.zimbra.com/

Some info on installing on Redhat:
http://www.zimbra.com/blog/archives/2005/08/developing_with.html

Looks pretty good to me.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: jester on September 12, 2005, 04:49:17 PM
Just for the record... you've probably allready seen this,but hey:

http://www.openconnector.org/

Regards,
   jester.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: fixit on October 05, 2005, 02:23:42 PM
Having a lot of trouble with ox with failed dependencies coming up with some of the rpms "jaxp_parser_impl" what file is this associated with. I am using sme 7b4

error: Failed dependencies:
        jaxp_parser_impl is needed by xml-commons-resolver-1.1-3jpp.noarch

Thanks, Russell
Title: Open-Xchange (SME7): progress, requests, testing
Post by: DarkMirage on October 05, 2005, 02:50:46 PM
jaxp_parser_impl is provided by xerces-j2 (http://"http://rpm.pbone.net/index.php3/stat/4/idpl/2062541/com/xerces-j2-2.6.2-7jpp.noarch.rpm.html"), which can be found at jpackage.org (http://"http://www.jpackage.org/rpm.php?id=2773"), which may be downloaded here (http://"http://mirrors.dotsrc.org/jpackage/1.6/generic/free/RPMS/xerces-j2-2.6.2-7jpp.noarch.rpm").

IMHO, rpm.pbone.net (http://"http://rpm.pbone.net"), although slow at times, is always a good place to figure out "provides".

You probably already know this, but the current ox release isn't ready for any beta's.

Hth
Title: Open-Xchange (SME7): progress, requests, testing
Post by: gregswallow on October 05, 2005, 06:14:05 PM
If you set up the jpackage mirror in yum you can do 'yum install jaxp_parser_impl' and yum will automagically figure out what rpm that file is from and prompt to install it.  If you just want to see what rpm provides something 'yum provides jaxp_parser_impl' will show you all the available rpms that provide that file.
Title: Open-Xchange (SME7): progress, requests, testing
Post by: fixit on October 05, 2005, 11:44:51 PM
that still didn't work, could it be when getting the files java-1.5.0-sun-1.5.0.03-1jpp.nosrc.rpm i got
java-1.5.0-sun-1.5.0.05-1jpp.nosrc.rpm and i actually renamed it .03 instead of .05 to get the script to work


error: Failed dependencies:
        jaxp_parser_impl is needed by jakarta-commons-modeler-1.1-4jpp.noarch
        jaxp_transform_impl is needed by jakarta-commons-modeler-1.1-4jpp.noarch
        jmxri is needed by jakarta-commons-modeler-1.1-4jpp.noarch

 Thanks, Russell
Title: Open-Xchange (SME7): progress, requests, testing
Post by: Franco on October 06, 2005, 03:50:15 AM
Life before and after open-exchange:
(http://www.carpena.com.br/images/cpu.gif)
Just FYI, if your CPU isn't that powerful...
Title: Open-Xchange (SME7): progress, requests, testing
Post by: jester on October 17, 2005, 08:45:59 AM
Just for anyone who wants to know...

Next to the OpenConnector project (http://www.openconnector.org/) there is an other project that is developing a connector especially for Outlook with Open-Xchange, and it is going to be GPL'ed: http://www.syn-3.nl/index.php?option=com_content&task=view&id=98&Itemid=84

Regards,
  Jester.