Topic: [Announce] Howto install Open-Xchange for SME

[vinc28]

in the rpm sme-openexchange-conf you have the latest version of oxlook in the
../../Primary/files/openexchange/windows


vincent

[ReetP]

Installed with the greatest of ease on a 6.01 server. Brilliant !

Apparently I had aspell already installed and I forgot to run /usr/local/open-xchange/bin/initall_ox to start with but after that it all seems OK.

One question - I cannot seem to get Thunderbird address book to view LDAP contacts ? I really like the global contacts and would like to be able to access them.

I have the following settings :

Name : test
host : 192.168.0.48
Base DN : dc=mynet,dc=com
Port 389
Bind DN - empty

If I go to the advanced tab and run 'Download now' I get a login box but nothing comes down.

I have read around but am lost.

Any ideas ?

[Tib]

Hi ReetP

I have Thunderbird Installed and the way I do it is:

Name: (What ever you want to call it)

HostName: myweb.net.au

Base DN: dc=global,dc=myweb,dc=(com or net),dc=au(if required)

Port: 389

Bind DN: (Blank)

If you wnat local addreses then just change global to local.

Hope this helps,

Tib

[Franco]

I followed step by step the tutorial, everything went fine. Created the user (already on SME) by:

Code: [Select]


[root@sme root]# /usr/local/open-xchange/sbin/adduser_sme_ox --username=test --passwd=test --name=test --sname=User --maildomain=smebr.homeunix.net --shell=/bin/bash/ --lang=EN --organisation=Informatica --street=Test --city=Poa --phone=99999999 --department=Informatica --mail_enabled=OK --inetmail=TRUE --ox_appointment_days=5 --ox_task_days=5 --ox_timez
one=America --write_global_address=TRUE --uid=5000 --gid=5000

which returns:

Code: [Select]


LDAP Success
SQL Success


But when I tried to access, I get an error:
ERROR: Authentification failed
and:

Code: [Select]

Sep 30 00:19:48 sme slapd[4657]: conn=5 op=1 BIND dn="UID=TEST,OU=USERS,OU=OXOBJECTS,DC=SMEBR,DC=HOMEUNIX,DC=NET" method=128
Sep 30 00:19:48 brio slapd[4657]: conn=5 op=1 RESULT tag=97 err=49 text=

What am I doing wrong?

[dmac]

Try and run /usr/local/open-xchange/bin/initall_ox.

I had the same problem, ran the script above and it just works!  There has been an addition that is mentioned in Step 4.  If you have downloaded the files in the last week, it should be part of the download.

Darin

[Franco]

It works!!!
Thanks much!
But for every user I add to the system I need to rerun this command?
This seems to be the part where I was failing. I built a machine with 6.5 just for testing this contrib and there was no users before install, then I created new users.
I also noticed that this app uses a lot of CPU resources, I'm testing on a celeron with 600MHz and it tops 100% when I use OX.

Great Work!

[dmac]

But for every user I add to the system I need to rerun this command?

I don't think so.  If you have the OX panel in the server-manager, then when you add a new user using the user panel, i think it will create the OX user as well.  If not, then the OX panel will allow you to create the user without having to drop out to the command line.

Killer App, now we can take Micro$oft for a run!!

Darin

[ReetP]

Hi Tib,

Thanks for the help, but unfortunately it doesn't cure it !

If I use

dc=mynetwork,dc=com

I have discovered that I can access both local and global contacts.

If I use

dc=global[or local],dc=mynetwork,dc=com

or

dc=global[or local],dc=testmachine,dc=mynetwork,dc=com

I get zip !

Any bright ideas ? I have tried various things to no avail.

I am using T-Bird 1.06 on Debian if that makes any difference. I will try it on a windoze box later.

It's not vital, but would be handy too differentiate.

B. Rgds
John

PS - I assume from what I can see that this is read only and you cannot add contacts from Thunderbird ?  Or have I missed something as this would be extremely useful.

[duncan]

if you want to try follow this link
http://e-smith.dyndns.org/ox/ox7
save all the files in a dir and : rpm -iUvh *

good luck


vincent
 

Hi - Has this been tested as working on 7beta4. During the rpm installation on a pristine installation - I get the following error when rpm creates existing SME users.

Code: [Select]

Undefined ERROR - LDAP CODE
See Server Log for Details!
ERROR


I just get authentication errors when trying to log in.

[Franco]

I'm getting hammered with these messages since install:

Oct  2 23:48:22 sme slapd[5679]: conn=281 op=1 BIND dn="" method=128
Oct  2 23:48:22 sme slapd[5679]: conn=281 op=1 RESULT tag=97 err=0 text=
Oct  2 23:49:22 sme slapd[1557]: conn=281 op=2 BIND dn="" method=128
Oct  2 23:49:22 sme slapd[1557]: conn=281 op=2 RESULT tag=97 err=0 text=
Oct  2 23:50:24 sme slapd[5679]: conn=281 op=3 BIND dn="" method=128
Oct  2 23:50:25 sme slapd[5679]: conn=281 op=3 RESULT tag=97 err=0 text=
Oct  2 23:50:26 sme slapd[1557]: conn=281 op=4 UNBIND
Oct  2 23:50:27 sme slapd[1557]: conn=-1 fd=9 closed
Oct  2 23:47:23 sme slapd[1348]: daemon: conn=281 fd=9 connection from IP=127.0.0.1:3369 (IP=0.0.0.0:389) accepted.

Are they normal? Please advise!

[ReetP]

Stuntshell,

I think that they are LDAP query messages - address lookup results. I guess they are from Open-Xchange itself, but I am not 100% sure on that.

I don't think that they are a problem - unless like me you are trying to find out how to query the addressbook from a mail program...........

It would be better if they were dumped to slapd.log or similar as they sure as hell fill up /var/log/messages.
Or is there a --quiet option ?

[dmajwool]

If I use
dc=mynetwork,dc=com

I have discovered that I can access both local and global contacts.

If I use
dc=global[or local],dc=mynetwork,dc=com
or
dc=global[or local],dc=testmachine,dc=mynetwork,dc=com

I get zip !

Any bright ideas ?
I am using T-Bird 1.06

PS - I assume from what I can see that this is read only and you cannot add contacts from Thunderbird ?  Or have I missed something as this would be extremely useful.

I was having a similar problem but I stumbled across

http://no.longer.valid/mantis/bug_view_page.php?bug_id=131

Which led me to look at server manager Directory page which states

The LDAP server provides a network-available listing of the user accounts and groups on your server, and can be accessed using an LDAP client such as the Address Book feature in Netscape Communicator. Configure your LDAP client with the local IP address of your server, port number 389, and the server root parameter shown below.
Server root    dc=mydomain,dc=com

Instead of local ip of my server, I used www.mydomain.com, which also worked.

The missing link, written in the bug tracker is that in the address book client you need to search for the addresses on the LDAP - they are not listed by default.  On Thunderbird, put a space bar in the search box & press return.

Like you, I would like to discover how to make the LDAP address book world writeable at the client end.  Anyone?

[ReetP]

The space bar tip is a nice one.

Still can't get it to differentiate between local and global address books though. The following syntax should be correct but doesn't work for me :

dc=global[or local],dc=mynetwork,dc=com
or
dc=global[or local],dc=testmachine,dc=mynetwork,dc=com

I need to try my Windoze version to see if that works differently from the linux one that I use.

Tib, you said that you could differentiate global from local addresses. What version of Thunderbird do you use ?


I would love to know how to write addresses from Thunderbird. That would be the final clincher for me. Personally (and from conversations with clients) I think that the centralised contacts is THE most important thing.

I stil think that this is one of the best contribs so far. Well done all you people.

B. Rgds
John

[dmajwool]

I came across this link in the OX wiki.  Its for a GUI to administer OX user accounts

http://atfrogs.berlios.de./

Has anyone tried it in SME?

[Tib]

ReetP

I'm running Thunderbird ver 1.0 on Suse 9.3 and Ver 1.5 Beta on windows.

Also I'm running SME 6.0.1-01 with a heap of mods as well as the phpldapadmin mod ... maybe it's this mod the enables the global and local settings ... ot sure.

I also have the smeserver-ldap-contacts-0.3.1-01hm.install.sh loaded from hmuhammad in the contribs section.

Maybe one of these did the trick ... not sure as I didn't test ldap with a clean install of SME.

my setup for ldap is ... dc=local,dc=mydomain,dc=net or dc=global,dc=mydomain,dc=net

Ragards,

Tib.