Apache OpenOffice (AOO) Bugzilla – Issue 4607
Can not connect to ldap server
Last modified: 2006-05-31 14:29:06 UTC
Trying to connect to an ldap server. No matter what I try it gives error message sql status: S1000. Tested with Openoffice 1.0 running on rh6.2 and rh7.2. LDAP server is openldap on rh7.2 system. url ldap.advocap.org dc=advocap,dc=org It works just fine under the StarOffice 6.0 beta. If you any more details let me know.
Marc, can you reproduce this?
Hi, Can you please test if the addressbook in the mozilla browser can connect to yout ldap server. If not, the OpenOffice addressbook can't connect, too. Bye Marc
Open Office is the only programs that does not work. The following work: Netscape 4.7 Netscape 6.2 Star office 6 beta! Pine Evolution gq can search but not browse as anonomous user because of access control
I have problems with connecting to our company's internal LDAP server too. Mozilla (latest 1.0 branch) has no problems (even though I have to supply my username/password if I'm trying to download an offline copy of the whole database). When I'm trying e.g. to switch to "Tables" tab in the datasource management window, I get an error: SQL Status: S1000 Regardless of whether I'm supplying the username/password or not. I ran a sniffer to see how does the communication between my workstation and LDAP server look like, and discovered that my machine doesn't even try to TCP connect to the server! OpenOffice doesn't go even as far as initiating a TCP connection. So it looks like maybe some driver problem.
I've checked that I have 2 version of LDAP library for different versions of Open/StarOffice (I need both of them): [root@tuxia ~]$ll $(locate libmozabdrv2.so) -rwxr-xr-x 1 root root 363552 mar 14 20:12 /usr/lib/office60_en/program/libmozabdrv2.so* -rwxr-xr-x 1 root root 3732302 kwi 29 07:00 /usr/local/openffice1.0/program/libmozabdrv2.so*
Might this be a conflict between those two libraries?
I have the same problems. I have tried the International OpenOffice.org 1.0 (at home) and the Danish OpenOffice.org 1.0 (at work). Both give this error. In both cases, Evolution, command-line tools, etc. connect just fine to the LDAP servers in question... I tried snooping a bit with tcpdump, but I never saw an attempt to connect in the captured data...? Like the original poster, I also used the LDAP address book just fine in the StarOffice 6.0 Beta.. What could this be?
I have just retried the LDAP connectivity in StarOffice 6.0 Beta, and it still works there. To post a bit like Aleksander below here are the mozab's on my system: locate mozab /opt/OpenOffice.org1.0/program/libmozab2.so /opt/OpenOffice.org1.0/program/libmozabdrv2.so /opt/staroffice6.0/program/libmozab638li.so Sizes: -rwxr-xr-x 1 root root 39894 apr 29 07:00 libmozab2.so -rwxr-xr-x 1 root root 3732302 apr 29 07:00 libmozabdrv2.so -rwxr-xr-x 1 root root 611936 aug 30 2001 libmozab638li.so If libmozab2.so is the one used, it is rather a lot smaller than the StarOffice one. If it's the other one it sure has grown. Is it the 'missing' one in stead? mozabdrv2.so LDAP references: moz-abldapdirectory:// ldap LDAP Directory Unable to connect to LDAP Server @mozilla.org/network/ldap-operation;1 moz-abldapdirectory: ldap: @mozilla.org/network/ldap-url;1 @mozilla.org/network/ldap-connection;1 LDAP references in mozab2.so: ldap LDAP references in mozab638li.so: isLDAP__CQ312connectivity14mozaddressbook16OMozabConnection ldap moz-abldapdirectory:// LDAP Directory Not sure how helpfull that is, but it may reveal a bit about the differences involved? Let me know if there's something I can test in both SO6 and OOo to help isolate this...
Martin, Aleksander, OOo (and, for that matter, SO) ship with some mozilla components which enable access to the various address book types. In the StarOffice6.0 beta (and in OOo's 638 builds), this was a version prior to Mozilla 0.9.4, in OOo 1.0 and SO 6.0 this is Mozilla 0.9.5. The difference in the libraries (libmoz*) is because in 638, we simply had another structure, namely only one big lib. In later versions, we separated this into libmoz and libmozdrv for performance and robustness reasons. The most interesting thing I see in the descriptions is the anonymous connection John talked about. Though the user interface of OOo suggests otherwise, OOo always connects anonymously. So I wonder what are the access restrictions on your LDAP servers ...? Another point would be the mozilla profile. Though OOo uses own components from mozilla, it accesses the existent profiles (by default the first one) on your machine. Perhaps you work with another one, and the default one has invalid e.g. proxy settings? Could you try http://dba.openoffice.org/howto/mozillaprofile.html to ensure that you access the correct profile? Perhaps with creating a completely new one in Mozilla, and setting it up so that it can definately access your LDAP server, and then using this new profile? Does this change anything? Frank
2nd attempt. Logged in this time. :) I tried the profile tip but it didn't help for me. I created a 'Mail' addressbook vith the information needed to contact the mail server at work. Although I didn't see any records in the addressbook, it worked just fine when creating new messages, autocompleting what I typed. I have no entries in the personal addressbook and only two entries in the collected addressbook. None of those matches anything in the LDAP database. Therefore, I must conclude that Mozilla does in fact connect to the LDAP server. Why it will not list the records, I am not sure.... This didn't change anything in OOo, though. I even tried importing the Mozilla target in stead, and it listed both personal, collected and Mail. It didn't seem to return too many results with either collected or Mail. Mail did give the field-names, though. Connecting to an LDAP database via the Addressbook target is still giving the S1000 error.. Frank, can you actually connect to an LDAP server with OOo version 1.0? I'd be really glad if this is some strange form of local configuration error (if resolvable, that is :))
Martin wrote: > Therefore, I must conclude that Mozilla does in fact connect to the > LDAP server. Why it will not list the records, I am not sure.... Mozilla doesn't show the whole database when you enter LDAP addressbook - you woulnd't like to start a download of a few million records if you configured e.g. Bigfoot, right :)? Instead, you have to execute a search (query), either by typing something in the search bar (you can turn it on via View->Show/Hide->Search Bar), or by doing an advanced search (e.g. Tools->Search Addresses...). Without search terms, the LDAP addressbook will appear empty, that' normal in Mozilla.
Martin, > 2nd attempt. Logged in this time. :) From this I assume that you may be interested in issue 2148 :) > I tried the profile tip but it didn't help for me. hmm. > Frank, can you actually connect to an LDAP server with OOo version > 1.0? actually, I can connect to our company's internal address server(s) without any problems with OOo 1.0. No idea at the moment .....
The plot thickens. We recently set up a new machine at work which we haven't customized yet. I NFS mounted the share with OpenOffice.org on and ran soffice as a user unique to that machine and lo and behold: It worked with LDAP (but I can only get that one LDAP entry because the Addressbook target no longer features in the Data Source list?! I then removed and reinstalled my OpenOffice.org installation on the /home NFS mount. This worked too. I went to my own machine and used the OOo installation I had created on the other machine, and it still worked with LDAP. So far so good. I got home (SuSE Linux 7.3 upgraded to 8.0) and tried to get the same result, but alas, it wouldn't work. Even though I removed the installation completely (the local part, that is) it just won't connect to an LDAP server. I tried creating an entirely new user for just this test but it gave the same result. No LDAP. In both of these cases, however the Addressbook target still exists, mentioning Mozilla and LDAP targets. The machine at work where this worked have mozilla 0.9.8 installed (standard SuSE version). My workstation at home have currently Mozilla 1.0rc1 from ftp.suse.com/pub/projects/mozilla. Not sure if it has any relevance, but it is one of very few obvious things that differs here. Any ideas?
A little more information: I just compared the installation at work with my installation af home and found that the installation at work is approximately 3 MB, whereas the one at home is only 1 MB?! This is the list of files at work: ./user ./user/temp ./user/temp/soffice.tmp ./user/temp/soffice.tmp/sv3eh.tmp ./user/temp/soffice.tmp/sv3eh.tmp/sv3f4.tmp ./user/temp/soffice.tmp/svi6j.tmp ./user/temp/soffice.tmp/svi6j.tmp/svi6m.tmp ./user/database ./user/database/biblio ./user/database/biblio/biblio.dbf ./user/basic ./user/basic/Standard ./user/basic/Standard/Module1.xba ./user/basic/Standard/dialog.xlb ./user/basic/Standard/script.xlb ./user/basic/dialog.xlc ./user/basic/script.xlc ./user/store ./user/store/.templdir.cache ./user/autocorr ./user/autotext ./user/autotext/mytexts.bau ./user/template ./user/backup ./user/gallery ./user/gallery/sg30.sdv ./user/gallery/sg30.thm ./user/gallery/sg100.sdv ./user/gallery/sg100.thm ./user/config ./user/config/streger.sod ./user/config/gallery.soc ./user/config/autotbl.fmt ./user/config/html.soc ./user/config/cmyk.soc ./user/config/pile.soe ./user/config/aktuel.sog ./user/config/javarc.bak ./user/config/standard.sob ./user/config/standard.soc ./user/config/standard.sod ./user/config/standard.soe ./user/config/standard.sog ./user/config/standard.soh ./user/config/javarc ./user/config/klassisk.sog ./user/config/inethist.dat ./user/config/skraveringer.soh ./user/config/web.soc ./user/config/farver.soc ./user/config/registry ./user/config/registry/instance ./user/config/registry/instance/org ./user/config/registry/instance/org/openoffice ./user/config/registry/instance/org/openoffice/ucb ./user/config/registry/instance/org/openoffice/ucb/Hierarchy.xml ./user/config/registry/instance/org/openoffice/ucb/Store.xml ./user/config/registry/instance/org/openoffice/UserProfile.xml ./user/config/registry/instance/org/openoffice/Setup.xml ./user/config/registry/instance/org/openoffice/Office ./user/config/registry/instance/org/openoffice/Office/Linguistic.xml ./user/config/registry/instance/org/openoffice/Office/Views.xml ./user/config/registry/instance/org/openoffice/Office/Writer.xml ./user/config/registry/instance/org/openoffice/Office/Jobs.xml ./user/config/registry/instance/org/openoffice/Office/DataAccess.xml ./user/config/registry/instance/org/openoffice/Office/Common.xml ./user/config/registry/instance/org/openoffice/Inet.xml ./user/config/sun-color.soc ./user/wordbook ./user/wordbook/hyph_ru.dic ./user/wordbook/dictionary.lst ./user/wordbook/en_US.aff ./user/wordbook/en_US.dic ./user/wordbook/hyph_da.dic ./user/wordbook/hyph_de.dic ./user/wordbook/hyph_en.dic ./user/plugin ./user/psprint ./user/psprint/pspfontcache ./user/psprint/fontmetric ./user/psprint/driver ./LICENSE ./setup ./README ./LICENSE.html ./soffice ./spadmin ./instdb.ins ./setup.log ./README.html ./program ./program/setup.log ... And at home: ./user ./user/psprint ./user/psprint/pspfontcache ./user/psprint/psprint.conf ./user/wordbook ./user/wordbook/da_DK.aff ./user/wordbook/README_da_DK.txt ./user/autocorr ./user/autocorr/acor1030.dat ./user/config ./user/config/registry ./user/config/registry/instance ./user/config/registry/instance/org ./user/config/registry/instance/org/openoffice ./user/config/registry/instance/org/openoffice/Office ./user/config/registry/instance/org/openoffice/Office/Common.xml ./user/config/registry/instance/org/openoffice/Office/DataAccess.xml ./user/config/registry/instance/org/openoffice/Office/Jobs.xml ./user/config/registry/instance/org/openoffice/Office/Linguistic.xml ./user/config/registry/instance/org/openoffice/Office/Views.xml ./user/config/registry/instance/org/openoffice/UserProfile.xml ./user/config/registry/instance/org/openoffice/Setup.xml ./user/config/registry/instance/org/openoffice/Inet.xml ./user/fonts ./user/fonts/fonts.dir ./setup.log ./instdb.ins Any hints there? However, by 'tester2' user at home also have approximately 3 MB data..: ./user ./user/store ./user/psprint ./user/psprint/pspfontcache ./user/psprint/fontmetric ./user/psprint/driver ./user/wordbook ./user/wordbook/hyph_da.dic ./user/wordbook/en_US.aff ./user/wordbook/hyph_ru.dic ./user/wordbook/hyph_de.dic ./user/wordbook/en_US.dic ./user/wordbook/dictionary.lst ./user/wordbook/hyph_en.dic ./user/autotext ./user/autotext/mytexts.bau ./user/autocorr ./user/backup ./user/config ./user/config/html.soc ./user/config/standard.sod ./user/config/classic.sog ./user/config/inethist.dat ./user/config/sun-color.soc ./user/config/gallery.soc ./user/config/standard.soe ./user/config/web.soc ./user/config/standard.sog ./user/config/styles.sod ./user/config/modern.sog ./user/config/hatching.soh ./user/config/registry ./user/config/registry/instance ./user/config/registry/instance/org ./user/config/registry/instance/org/openoffice ./user/config/registry/instance/org/openoffice/ucb ./user/config/registry/instance/org/openoffice/Office ./user/config/registry/instance/org/openoffice/Office/Common.xml ./user/config/registry/instance/org/openoffice/Office/DataAccess.xml ./user/config/registry/instance/org/openoffice/Office/Jobs.xml ./user/config/registry/instance/org/openoffice/Office/Views.xml ./user/config/registry/instance/org/openoffice/UserProfile.xml ./user/config/registry/instance/org/openoffice/Setup.xml ./user/config/registry/instance/org/openoffice/Inet.xml ./user/config/standard.sob ./user/config/javarc.bak ./user/config/autotbl.fmt ./user/config/javarc ./user/config/standard.soc ./user/config/standard.soh ./user/config/arrowhd.soe ./user/config/palette.soc ./user/config/cmyk.soc ./user/gallery ./user/gallery/sg100.thm ./user/gallery/sg30.thm ./user/gallery/sg100.sdv ./user/gallery/sg30.sdv ./user/plugin ./user/database ./user/database/biblio ./user/database/biblio/biblio.dbf ./user/template ./user/basic ./user/basic/Standard ./user/basic/Standard/Module1.xba ./user/basic/Standard/script.xlb ./user/basic/Standard/dialog.xlb ./user/basic/script.xlc ./user/basic/dialog.xlc ./user/temp ./soffice ./spadmin ./LICENSE ./setup ./setup.log ./LICENSE.html ./README.html ./instdb.ins ./README Still, LDAP doesn't work there... What can it *be*? Oh well, it isn't that important for my home machine, but I would really like to know the deciding factor here :)
I discovered the same problem with the de version. Installed en and it worked. I then thought it's a language problem but it isn't. LDAP works when installing 'single' while it doesn't work when doing a 'net' install. Now if I just knew how to fix it...
Simon, do I understand you correctly that LDAP does work when doing a full install, but not with a /net install? If so, which platform are we talking about in your case? Frank
I confirm that my setup, where LDAP doesn't work, is where OpenOffice is run from a -net install. At the moment, unfortunately, I can't check with a full install for unprivileged user (due to HDD space limitations).
Frank Sorry for the delay... I'm in the process of creating RPM packages for RedHat Linux. I'm currently testing with RedHat 6.2 and 7.2. I install the RPM (or do a /net install by hand), then launch openoffice (I've removed any OO configs before). The setup program starts up. When I do 'workstation install', LDAP doesn't work but when doing 'full install', LDAP works. Simon
Simon, (no problem with the delay, I find time for this here sporadically only, too) This is interesting. Would be good to know if John as the original submitter can confirm this, too - LDAP working in a full, but not in a net install. Frank
I have only used a net install. I'll try to test a singe user install. On thing that may be relevant is when accessing from Mozzila must set Scope one level option.
OK, I've freed some disk space and did a full install of OO 1.0 in my home directory (after removing the previous OpenOffice.org1.0 profile of course). Suddenlt LDAP started working, exactly as all others reported here. So yes, LDAP works in a full install, doesn't work in a net install.
I just got a copy of Staroffice 6.0 Did network install. Root can use ldap, other users can not. Have a simular problem with odbc access athough in this case it works for users on some operations. I see a trend here :-) Could be a few things but it sure narrows it down. John
I was having problems using LDAP as a non-root user after a net install. I tried running as root and I was able to use LDAP, just like John. I then tried running as the non-root user again, and LDAP magically worked. After some investigation (and several large recursive diffs), I discovered that when I set up the LDAP connection as root, the file OpenOffice.org1.0.changed/program/components/xpti.dat was created (along with xptitemp.dat, which is identical). Adding this file to a clean install allowed the non-root user to use LDAP. This is either something that should be done by the installer, or something that should be done in the users local directory.
I can confirm the problem on Debian GNU/Linux unstable. I have used the OpenOffice (german) tar archive. I did a network install as root. Could not connect to ldap server as normal users. After reading this thread i did a client installation as root and could connect to the ldap server as well as running a query. After that step i was able to connect to the ldap server as a noraml user. I would suggest a immediate update to the release notes in order to explain the problem and the solution.
i had a quick look at this. I can verify what Rick Greenwood stated. It appears that these two files are missing from the german version of OOo 1.0. They appear in the english version. I will check to see that this is fixed in OOo 1.0.1. I have also created : http://www.openoffice.org/issues/show_bug.cgi?id=6485 which would ensure that this would not happen in future.
I have checked that this is fixed in OOo 1.0.1. I will mark this bug as fixed. Thanks to everyone who contributed on this.
Marking as verified.
closing
change subcomponent to 'none'