[upstream] Address data sources missing

[NoOp]

Binary package hint: openoffice.org

Over on the Ubuntu user's mailing list someone asked a question about
Thunderbird address data sources. So in the process of replying I check
on my systems & found:

OOo 2.1 installed from Openoffice.org files directly (installed on
Dapper) has:

File|Templates|Address Book Source| Administrate button
- Evolution
- Groupwise
- Evolution LDAP
- Mozilla / Netscape
- Thunderbird
- KDE address book
- LDAP address book
- Other external data source

OOo 2.2(rc3) (Ubuntu'ized Feisty version) only shows:

File|Templates|Address Book Source| Administrate button
- Evolution
- Groupwise
- Evolution LDAP
- Other external data source

Note: Thunderbird is installed & working on both machines.

I then installed OOo 2.2(rc3) (non-Ubuntu'ized version) on Ubuntu Dapper using the files from OOo and the results are exactly the same as my OOo 2.1 (non-Ubuntuized) version:

File|Templates|Address Book Source| Administrate button
- Evolution
- Groupwise
- Evolution LDAP
- Mozilla / Netscape
- Thunderbird
- KDE address book
- LDAP address book
- Other external data source

The Ubuntu version is missing:
- Mozilla / Netscape
- Thunderbird
- KDE address book
- LDAP address book

Note: related bug from earlier versions appears to be https://launchpad.net/ubuntu/+source/openoffice.org/+bug/35671

[Braden (braden)]

Some comments after reading
<http://www.mozilla.org/projects/embedding/shared_profiles.html>...

Different cache directories for each application would not be much of a step
forward. Apps can already get this by setting up their own profile directory
(indeed, that's what they do). Having apps be able to share a single cache (per
user) is a major usability win. Further discussion of this probably belongs in
bug 135061.

Prefs... IMO, the most desirable situation from a usability standpoint would be
to have Gecko prefs shared. Apps that don't want that can set up their own
profile directories and share nothing with other apps.

[Jud-me (jud-me)]

-> ccarlen

[Ccarlen (ccarlen)]

Taking.

[Bzbarsky (bzbarsky)]

*** Bug 148102 has been marked as a duplicate of this bug. ***

[Ccarlen (ccarlen)]

*** Bug 148509 has been marked as a duplicate of this bug. ***

[Bugzilla-rtimwest (bugzilla-rtimwest)]

This means that the browser and mail now conflict with each other.

This means that separate menu selections, scripts, or icons for "mozilla" and
"mozilla mail" no longer work independently, or consistently, depdending on what
else is running.

This means that naive users have to be told, "mostly, you can just click on this
to check mail, but if the browser is running, you have to do something
completely different" and "mostly, you just click on this to get to the web, but
if you've got e-mail open...".

This means that users that are NOT used to having tabs can no longer just fire
off multiple sessions and cut-and-paste or compare, as they routinely do with
IE, for example.

This means that, now running mail and the browser as one session but in
different desktops, clicking on a link in an e-mail message will open the link
on another desktop, out of view rather than in front of the user.

If multiple windows are open in one session, and Edit-Preferences is selected in
each, it branches to one and only one copy of the preferences dialog. Is this
impossible across sessions?

[Matti-mversen (matti-mversen)]

*** Bug 148839 has been marked as a duplicate of this bug. ***

[Jonabbey (jonabbey)]

This issue is especially bad for the common user on Linux/X, as programs like
KMail, etc., are used to ordering the platform browser to run with a given url,
in the expectation that either the running application will just open a new
window on the new url, or that the application won't mind multiple copies of
itself running.

It would be nice that if one ran 'mozilla', or 'mozilla-mail', that mozilla
would look to see if a browser instance was running in the same user account
with the same DISPLAY environment set, and if so, a signal would be sent to the
running instance so that it could open up the appopriate window.

I believe this is how it works on Windows now. It would make this issue much
less objectionable on X Windows if we could get the same kind of behavior.

[Ccarlen (ccarlen)]

> It would be nice that if one ran 'mozilla', or 'mozilla-mail', that mozilla
> would look to see if a browser instance was running

Very true, but a separate issue (XPApps) If what you're talking about was done,
there would be less need for mozilla to be able to share a profile amongst
multiple instances. This bug is not about the behavior of mozilla, but being
able to share profiles for applications which really need to do this (not
nescesarily mozilla).

[Bugzilla-rtimwest (bugzilla-rtimwest)]

>>This bug is not about the behavior of mozilla<<

People reporting this issue as a bug in Mozilla's behavior have had their bug
reports rolled up (DUPME) into this one- or discarded (RESOLVED). Either action
apparently discards/disregards votes for the previous bugs that were so handled.
The brings up questions as to how accurately it's impact can now be judged.

If this bug is not about the behavior of Mozilla, perhaps this action was
inappropriate. Those people are now tracking this bug to see what the resolution
will be, if any.

[Bzbarsky (bzbarsky)]

*** Bug 154074 has been marked as a duplicate of this bug. ***

[Matti-mversen (matti-mversen)]

*** Bug 154875 has been marked as a duplicate of this bug. ***

[Ham-mozilla-org (ham-mozilla-org)]

Marking http://bugzilla.mozilla.org/show_bug.cgi?id=154875 as a duplicate of
this bug is, IMHO, misleading.

154875 is an issue that's been driving myself and several others I know up the
wall - we were all happily using RC2, without this behaviour, (although AFAIAW
all of us were fortunate never to have profile corruption problems), and
suddenly things have gone pear-shaped.

The reporter of bug 154875 sounds quite upset by it all, and I can see where
s/he is coming from - all my window-manager shortcuts for opening browsers are
now broken without any apparent workaround (since they point to /..../mozilla),
and I have to keep paging through all my virtual desktops to find wherever the
heck the last remaining instance of EITHER a browser window OR EVEN a mail
window is hiding, and then Ctrl-N / Ctrl-1 off that window.

I wouldn't mind at all if someone (anyone?) had proposed a workable workaround,
but for now it seems my only option is to downgrade to RC2, or stop using
Mozilla altogether (if you think this is OTT, then think how much time is wasted
paging through 9 virtual desktops almost every time you want to open a new
browser window!)

HOWEVER, marking 154875 as a duplicate hides this entire problem. I read this
bug report first (135137) and decided it was a different problem. It was only by
noting Robert West's comment (#10), and reading all the dupes that I realised it
was now officially the same bug. (!).

[Jruderman (jruderman)]

See also bug 122698, "Detect [and use] currently running instance of Mozilla
when app is launched a second time". Several of the dups of this bug are really
dups of 122698. It's probably easier to fix bug 122698 than it is to fix all
profile-corruption and other dataloss bugs that crop up when two instances try
to share a profile.

[John-marmion (john-marmion)]

OpenOffice.org(OOo) integrates with mozilla. Please see:

http://www.openoffice.org/issues/show_bug.cgi?id=6391

What interests me here is the Mozilla Address Book integration with OOo. This is
a readonly access by OOo. But following the fix for bug #76431, it is no longer
possible to simultaineously run the Browser and access Mozilla Address Book data
from within OOo.

The reason for adding this comment is two fold, one to draw attention to the
effect of this on 3rdparty products such as OOo and secondly to support the
requests for the ability to support a readonly access to a second instance in
the spirit of 4.x.

[Teilo+bugzilla (teilo+bugzilla)]

*** Bug 160026 has been marked as a duplicate of this bug. ***

[Ajschult (ajschult)]

*** Bug 160402 has been marked as a duplicate of this bug. ***

[Mozilla-jgaunt (mozilla-jgaunt)]

changing component, since this deals specifically with the work needed to make
profiles accessible by multiple processes. adding the nspr
semaphore/memorysharing bug as a blocker

[Nyet (nyet)]

Please don't forget to take into account multiple instances running on SEPARATE
machines using a common NFS mounted home... I'm not sure if that is a separate
issue or not. If it is, I could not find it.

[Moz-poelzi (moz-poelzi)]

gconf uses a technique that the first instance is opening a port on which the
other instances from the same user can connect to. only the first instance use
the files directly (better: write them).
i think this technique is not bad, because the normal way is that the profile is
located in a networkwide lan where ports can opened and connected in them.

if the first instance of the application dies, another becomes the writer instance.

[Lummox418 (lummox418)]

I would like to help this work on Mac OS 9. To do this, I need a description of
the proposed shared profile architecture. I have not yet found such a
description in this or related bugs, or at
http://www.mozilla.org/projects/embedding/shared_profiles.html , which describes
the problem but not the solution.

Mac OS 9 has an IPC mechanism and with this information I will be able to
provide assistance in using it for this job. Thank you.

[Mozilla-jgaunt (mozilla-jgaunt)]

I'm working on a tech spec right now, and when it is coherent enough to post for
comments I'll post it, uh, somewhere ( probably newsgroups and m.o ). It will
only outline the preferences work, but the architecture is one we hope to be
able to leverage to share the other profile data.

[Rembert (rembert)]

Can anyone tell me the difference between bug 122698 and this one. I was very
disappointed to find Mozilla falling back to bug 122698 when upgrading from 1.1b
to 1.2a. Why wasn't the patch mentioned in 122698 included in the new
run-mozilla.sh?

[Mozilla-jgaunt (mozilla-jgaunt)]

bug 122698 deals only with start up behavior. This bug deals with the ability to
run multiple programs that all use mozilla, more specifically gecko, as a
rendering engine.

bug 122698 doesn't want to "share" the profile data between apps, it just wants
to check for a currently running version of mozilla and open a window from that
process. The bug aims at allowing two or more processes, like chimera and
phoenix and netscape, to run at the same time on the same profile without
profile corruption, deadlocks, or any other Bad Stuff(tm).

Docs have been posted(or rather links to m.o) to the n.p.m prefs,xpcom,&
embedding as well as posted at
http://www.mozilla/org/projects/embedding/profileSharing/index.html that talk
about the design we are working on for sharing the profile data.

[Cyp (cyp)]

Might it be possible to have an interim 'solution' that would keep both sides
happy?

For sites where Mozilla is used by technically unsavvy users, the prompt to
setup a new profile leads to headaches for support staff, and everyone I've
asked would settle for a message that says "Close the other Mozilla first"
instead of the new profile setup prompt.

Another solution would be a simple prefs.js setting to disable the locking.
Those of us following this and related bug reports that have a problem with
the new locking behaviour are fully aware of the risk of profile corruption
and yet are willing to take that risk (primarily because the alternative
really isn't an alternative), and a means to disable it would make us happy
campers again.

[Matti-mversen (matti-mversen)]

*** Bug 184913 has been marked as a duplicate of this bug. ***

[Ed-sender-192668 (ed-sender-192668)]

Cyrus,

rm -f ~/.mozilla/profilename/wierd-dirname/lock

I'm keeping that command in my mozilla script until they figure out how to fix
the problem correctly.

[Kdavis (kdavis)]

Here is the workaround I came up with:

#!/bin/sh

#URL TO OPEN
URL=$1

#MOZILLA REMOTE COMMAND
COMMAND="openurl("$1",new-tab)"
#COMMAND="openurl("$1",new-window)"

#CHANGE DIRECTORY TO MOZILLA
cd /usr/local/mozilla

#SEARCH FOR MOZILLA WINDOW
xwininfo -root -tree | grep -q -s phoenix
RETVAL=$?

if [ $RETVAL = 0 ] ; then
  ./mozilla -remote $COMMAND
else
  ./mozilla $URL
fi

[Felix Miata (mrmazda)]

*** Bug 185367 has been marked as a duplicate of this bug. ***

[Matti-mversen (matti-mversen)]

*** Bug 185586 has been marked as a duplicate of this bug. ***

[Matti-mversen (matti-mversen)]

*** Bug 186498 has been marked as a duplicate of this bug. ***

[Bzbarsky (bzbarsky)]

*** Bug 190718 has been marked as a duplicate of this bug. ***

[Matti-mversen (matti-mversen)]

*** Bug 191179 has been marked as a duplicate of this bug. ***

[Matti-mversen (matti-mversen)]

*** Bug 192572 has been marked as a duplicate of this bug. ***

[Rhkramer (rhkramer)]

The bug I reported, Bug 190718, is *not* a duplicate of this bug -- far from it
-- in most respects it seems almost the opposite.

My problem is this: In Mozilla 1.1 (Mandrake 9.0) when any portion of Mozilla
crashes, all my open Mozilla tabs and windows close. (Since it is not untypical
to have 150 tabs open spread across 15 or so Mozilla windows, and some of those
windows may have open "text boxes" for editing TWiki pages, I lose a significant
amount of work and context.)

It seems no matter how I open Mozilla, only one instance is created.

In one of the comments above it is stated that this is how applications in
Windows behave. It is not, at least as of Win95, and if it has changed it is a
change for the worse. The truth is that in Windows there are ways to open new
copies of an application so they are new windows/tabs of the same instance and
there is a way(s) to open an application so a new instance is created.

In Windows (95), if you open a new application window by entering the
application name on the command line, clicking the icon, or clicking on the
start menu entry, you get a new instance of the application that shares nothing
with the previous instance. (Well, that statement may be a little too strong --
it presumably shares the preferences and things like that.) The point is, a new
instance of the program is created, and if some other instance of the program
crashes, this new instance does not crash (unless the crash kills all of Windows).

On the other hand, if you go into an open window or tab of a running instance of
a program and click New (or Open??), you create a new Window or Tab that is part
of the existing instance. If something happens to cause a crash of this new
window, all open windows and tabs that are part of this instance close, but
those that are part of some other instance remain open and functional.

IIUC some other people are pushing for improvements or changes to the single
instance behavior. My bug (RFE) is requesting that there be a means to create
multiple instances.

Is it clear?

If so, I think somebody needs to rewrite some bugs or create some "meta bugs" to
properly collect the votes. (Note that the two behaviors I describe above are
not mutually exclusive -- there should be a means to do both, and at least
knowledgable users should be aware of how to do both.)

I will now basically paste these same comments into bug 190178 and attempt to
reopen it. Please don't close it as a duplicate of this bug again -- perhaps
there is some other bug that it is truly a duplicate of, but it's not this one.

Or, another way of saying what I'm trying to say -- the writeup on this bug
135137 is so confusing, it's hard to tell what it is about. If my bug truly is
a duplicate of this bug, this bug needs to be rewritten (a new "meta bug") very
clearly, and all the comments to this bug (135137) that confuse the issue need
to be discarded.

Randy Kramer

[Matti-mversen (matti-mversen)]

*** Bug 190718 has been marked as a duplicate of this bug. ***

[R-contact2009-awhlink-com (r-contact2009-awhlink-com)]

*** Bug 105181 has been marked as a duplicate of this bug. ***

[R-contact2009-awhlink-com (r-contact2009-awhlink-com)]

*** Bug 111070 has been marked as a duplicate of this bug. ***

[Ccarlen (ccarlen)]

Setting to milestone that's not passed.

[Malcolm-ferguson (malcolm-ferguson)]

Randy,

There's no guarantees under Windows whether you get a new process or same the
process. It's up to the application developer. If they don't do anything
special, you will get multiple processes. What changed with Win95 (well, Win32)
was that the HANDLE to the previous instance was no longer passed to WinMain, so
application developers had to start using named mutexes, or named pipes or
FindWindow if they wanted to have one process only. Try launching Word multiple
times, you will not succeed (Office XP at least).

Explorer/Internet Explorer is an interesting case. It has an option in its
preferences dialog to run multiple processes. This is the first thing that I
enable when I sit down at fresh installation/new user environment. The stupid
default of having it disabled will mean the shell dies whenever a crash occurs
in another window. Anyway, IE allows multiple processes, which is vital IMHO
considering how often I make it crash. Some of the shared data is accessed
through separate singleton processes, like the Protected Storage service that
originally came with IE4.

I would really like to see the ability to launch Mozilla in multiple processes.
 This will make it more reliable and more useful. Concurrency of the shared
data is going to be a problem though. Do we have something in the toolkit that
allows interprocess communication on all the Mozilla platforms? E.g. a CORBA
based profile/configuration service/daemon would be very useful.

[promeneur (epistemepromeneur)]

Mandriva 2010.2 32 bit
libreoffice 3.4.2 OOO340m1 build 302

i confirm the bug

in lo base
i created a db file for my kab (kde addressbook)
the kab.odb seems filled (1,6 ko)

in lo writer
in file > model > address book source
in "data source" field it appears in the list
i can select it
but
when i select it have the error message about no sdbc driver

i can't access to the address book

[Iplaw67 (iplaw67)]

(In reply to comment #34)
> Mandriva 2010.2 32 bit
> libreoffice 3.4.2 OOO340m1 build 302
>
> i confirm the bug
>

Well thank you, but it has been reported as fixed on master, and so therefore may or may not be backported for 3.4.4 (not my decision).

I will try this again on one of my own recent Linux 32bit master builds and see if I confirm Julien's findings.

Alex

[Iplaw67 (iplaw67)]

(In reply to comment #35)

>
> Well thank you, but it has been reported as fixed on master, and so therefore
> may or may not be backported for 3.4.4 (not my decision).
>
> I will try this again on one of my own recent Linux 32bit master builds and see
> if I confirm Julien's findings.
>
>

Replying to myself :
On my own week-old 32bit linux Ubuntu build from master, I can see various choices for existing database connections, among which Thunderbird and Seamonkey address books. The ODB file can be created just fine, however, the wizard does not pick up the user's TB/SM profile, and thus can not actually make the connection to the mozab underlying database file.

Even if I save the ODB file, re-open and then try and reset the properties of the ODB connection to point to the mab file, this still fails to work. So as far as I'm concerned, my tests were inconclusive. I can't tell whether it is a problem in the connectivity code or somewhere else, because there is not much point in listing the available types of database if LibO can not actually connect to them.

Alex

[borutj (borut-jereb)]

Created attachment 52636
Address Data Source choices

[borutj (borut-jereb)]

Ubuntu 11.10
libreoffice 3.4.3

When I want to use
File --> Wizards --> Address Data Source
I have no possibilities to choose an usual database except the choice to open External Data Source. After choosing the only possibilities (External Data Source) I get the error:

The error report is:

SQL Status: HY000

The connection to the external data source could not be established. No SDBC driver was found for the given URL.

On the other hand I have some databases in my libreoffice repository.

[Iplaw67 (iplaw67)]

(In reply to comment #38)

Hi,

> Ubuntu 11.10
> libreoffice 3.4.3
>
> When I want to use
> File --> Wizards --> Address Data Source
> I have no possibilities to choose an usual database except the choice to open
> External Data Source. After choosing the only possibilities (External Data
> Source) I get the error:
>
> The error report is:
>
> SQL Status: HY000
>
> The connection to the external data source could not be established. No SDBC
> driver was found for the given URL.
>
> On the other hand I have some databases in my libreoffice repository.

I can confirm this too on 32bit Ubuntu Oneiric 11.10 with distrib supplied LO 3.4.3, so the fix is still not in for that version.

Alex

[Cno (cno)]

No problem in 3.4.3 and 3.4.4 and a masterbuild for 3.5

So probably a bug for the "32bit Ubuntu Oneiric 11.10 with distrib supplied LO
3.4.3" ??

[Iplaw67 (iplaw67)]

Confirming bug also in distrib supplied :

LibreOffice 3.4.4
OOO340m1 (Build:402)

Ubuntu 11.10 32bit

So would this be one for Bjoern ?

Alex

[David Sterratt (david-c-sterratt)]

(In reply to comment #40)
> No problem in 3.4.3 and 3.4.4 and a masterbuild for 3.5

This is still definitely a problem for me on Ubuntu 11.10 i686 with the latest official libreoffice binaries. Steps to reproduce:

1. Purge ubuntu libreoffice packages with dpkg --purge --force-all "libreoffice*"
2. Install 3.5.0beta0 binaries from libreoffice.org.
3. rm -Rf ~/.libreoffice
4. Open /opt/libreoffice3.5/program/soffice
5. Open "File->Wizards->Address Data Sources..."
6. There are four sources presented (Mozilla/Netscape, Thunderbird, LDAP and Other external data source)
7. Select any of these. A dialogue appears saying "The connection to the external data source could not be established. No SBDC driver was found for the given URL"
8. Click on "More" in this box. The error shown is "SQL Status: HY000. The connection to the external data source could not be established. No SDBC driver was found for the given URL."
9. Click on "Information". The description is "A connection for the following URL was requested "sdbc:address:evolution:local".

From the comments above it looks as though I'm going to have to use OpenOffice to use my evolution address book to print out year's Christmas card labels...

[David Sterratt (david-c-sterratt)]

I've tried OpenOffice.org and it doesn't work either. When running from the command line I got an error "Can find no compliant libebook client libraries". Googling this lead me to the following file (in OOo):

https://svn.apache.org/repos/asf/incubator/ooo/trunk/main/connectivity/source/drivers/evoab2/EApi.cxx

and its equivalent in LibreOffice:

http://cgit.freedesktop.org/libreoffice/core/tree/connectivity/source/drivers/evoab2/EApi.cxx

The error occurs in EApiInit(). The reason for this is that it can't find a version of libebook on my system that matches one of the following, defined at the top of the file:

static const char *eBookLibNames[] = {
    "libebook-1.2.so.10", // bumped again
    "libebook-1.2.so.9", // evolution-2.8
    "libebook-1.2.so.5", // evolution-2.4 and 2.6+
    "libebook-1.2.so.3", // evolution-2.2
    "libebook.so.8" // evolution-2.0
};

I have libebook-1.2.so.12 installed in my system, which doesn't match any of the above. I suppose we could just try adding libebook-1.2.so.12 to the list to see what happens.

When (if) I've a moment, I'll try recompiling libreoffice, but I don't know how long it will take on my laptop...

[NoOp (glgxg)]

I have:
$ locate libebook
/usr/lib/libebook-1.2.so.9
/usr/lib/libebook-1.2.so.9.3.1

$ ls -al /usr/lib/libebook-1.2.so.9
lrwxrwxrwx 1 root root 21 2011-01-20 19:49 /usr/lib/libebook-1.2.so.9 -> libebook-1.2.so.9.3.1

and have the issue in 3.4.3. Address selections are available, but clicking on any of them results in:
SQL Status: HY000

The connection to the external data source could not be established. No SDBC driver was found for the given URL.

A connection for the following URL was requested "sdbc:address:evolution:local

[NoOp (glgxg)]

Correction:

and have the issue in 3.4.3.

should read:

and have the issue in 3.4.4

[NoOp (glgxg)]

Created attachment 54439
LO3.5 screenshot

Same issue with:
LibreOffice 3.5.0
Build ID: ef91e38-b1d4df6-090bcba-45cf606-05891e7

Screenshot attached.

[David Sterratt (david-c-sterratt)]

@NoOp: that's what I saw on 3.5.0beta0 too. Interesting that it's not just a problem with the library version being wrong.

I've compiled libreoffice with
"libebook-1.2.so.12"
added to eBookLibNames. Now I only get the option of the "External data sources" and when I click on that I get the same error as you, with the Information that "A connection for the following URL was requested "sdbc:address:evolution:local"."

I think the problem may the recent changes in the libebook library. See the list of deprecated symbols at:
http://developer.gnome.org/libebook/3.2/

The file
http://cgit.freedesktop.org/libreoffice/core/tree/connectivity/source/drivers/evoab2/EApi.h
seems to use a lot of these deprecated symbols.

I've love to have the time-expertise to hack around, but I don't. I'm going to have to move to good old-fashioned handwriting for my Christmas card envelopes.

[David Sterratt (david-c-sterratt)]

The OpenOffice version of this bug:
https://issues.apache.org/ooo/show_bug.cgi?id=116901

[Iplaw67 (iplaw67)]

Confirming on my 3.5 build from master Linux Ubuntu 32bit, that only 1 entry is present when the wizard is started "Other external data source".

If I click Next after having chosen this possibility, I get an error messsage of the type : "The connection could not be established. No SDBC driver could be found."

So confirming other peoples findings too.

Build ID:
87ca88c-d46295c-6e20485-4c1bcb5-libreoffice-3-5-branch point

This really needs sorting out.

Alex

[NoOp (glgxg)]

@David re comment #47:

"I've love to have the time-expertise to hack around, but I don't. I'm going to
have to move to good old-fashioned handwriting for my Christmas card envelopes."

Try this workaround: In Writer select the data sources (F4). Right-click in the data source (where Bibliography is) and select 'Registered databases'. Click 'New' and browse to where your existing .odb is located. Select the .odb & click OK. Verfify that it works by selecting the database and viewing Tables. If so, from there you should be able to File|New|Label|Labels|Database and select the database that you just added. Note: I can't get File|New|Label to work from Writer, I have to go back to the main menu and select it from there. But I reckon that's another bug report...

[Jbf-faure-9 (jbf-faure-9)]

*** Bug 45157 has been marked as a duplicate of this bug. ***

[Iplaw67 (iplaw67)]

In my latest build from master, on Ubuntu Oneiric, I have several entries, including Evolution, Evolution (LDAP), other DB, but NO Thunderbird (which is most annoying, but not really surprising since I disabled building mozab within my build because it doesn't build within the LO code on Ubuntu (sigh).

However, the basic functionality of the Address Database Source Wizard does work. For example, I could set up and define a mysql database as an Address Datasource, just as I could with the Evolution address book.

So, FWIW, this works for me (apart from TB Address book integration) on Linux 32bit Ubuntu Oneiric with my build from master.

Alex

[tellapu (tellapu)]

I hoped that LibreOffice 3.5.1 would solve the problem, but after an upgrade from 3.4 in Ubuntu Oneric 11.10 (64-Bit) the same problem persists.
No entries available, I would need to have access to the evolution addressbook. I get the following error and information:
SQL Status: HY000
The connection to the external data source could not be established. No SDBC driver was found for the given URL.

A connection for the following URL was requested "sdbc:address:evolution:local".

It is encouraging that the importance has been raised to critical and I hope that somebody will be assigned for LO (ubuntu) soon. Thanks for working on this. I need the feature desperately.

[Libreoffice-z (libreoffice-z)]

Reduced severity.

As it seems NoOp reproduced with LibO vanilla build 3.4.0beta3, so together with other confirming comments I believe we can this one take as NEW, also due to other builds.

3.4 lifecycle is terminated, so shift to “Bug 37361 LibreOffice 3.5 most annoying bugs”

@All:
Is my addition to summary line correct?

@Alex:
Can you please keep at it and check whether the "fix" is enduring?

@Lionel:
Any ideas? This one seems to be really tricky, I see several conflicting observations.

[Mike-stewart (mike-stewart)]

For goodness sake. TEN YEARS and an issue is still "new". In a commercial environment someone would be sacked.

You cant run Firefox in a remote desktop session or under Citrix if another session already has Firefox open. This is a pretty big defect.

Frankly, this is the achilles heel of "community" software. Lots of voluntary work on building a Ferrari ... but because it is not managed as a consumer product ... you cant drive it on Sundays between 2 and 3pm.

The thing that really ticks me off after 20 years in the industry is techs nodding their heads and saying "yep, that's to be expected". Sorry, just because you can come up with an explanation doesn't mean "its OK".

Any workaround is better than closing umpteen "duplicates" and leaving an issue open for 10 years. Come back in 2050 and this will probably still be open.

Am I really the only one who is ashamed to say I'm a software developer? This is exactly the sort of thing that sees software guys get mocked by business people (well actually anyone for that matter)... and fair enough too.

Firefox as a browser is in my opinion the best (except for this particular problem) ... all the man hours that some extremely talented and selfless people have put into the tool is amazing .. only to be let down by a failure to look at the whole... as a tool used by people ... to address real usability issues ... which after all is the point.

Do you know that in real engineering disciplines people construct whole buildings? that stay standing? that can be used all year round? That take technology and engineering and apply it to _people_? that can be constructed in days? to budget?!! ... such a revolutionary concept.

While "db" has been very generous with his time to provide his script I don't think this will help my grandmother.

Yep, Im an angry old man .. the thing that makes me a sad old man is that this sort of failure is why open source and community software hasn't quite conquered the world how many predicted. Instead a commercial layer appears in between .. a layer that "tweaks" all the effort of selfless individuals to get to an actual product that delivers... and that commercial layer then chuckles it all the way back to the bank.

[RamonS (ramons)]

Mike S - Not disagreeing a bit. There are also other significant flaws in FF4 and up (dysfunctional default UI, rapid release cycle, the 'fix' for bug 586234, inability to clone a tab).
I don't think it is necessarily a reflection on all software developers, not even on all who work on FF. My guess is - and that is true for commercial software as well - some folks with a far too big ego make the decisions and they want things to be their way. The UI change that nobody wanted - still there. The rapid releases that still break add-ons and that caused hundred thousands of complaints - still there. All the stuff that works fine in FF3.x and was broken for no reason in FF4 - still there. I think that up until FF3 Mozilla was close to the community of users and made a browser that users loved. Then something changed, a decision was made to copy Chrome and entirely ignore the wishes of the user community. What Mozilla needs to do is replace the decision makers with folks that care about the users more than themselves. FF turned into the materialized ego trip of a select few and the result is unhappy users and continuously dropping market share. I really wonder how the decisions are made which bugs to fix first after covering security issues. My guess is that new (and buggy) features trumps fixing bugs filed a decade ago. And the memory leaks are still there, but that is a common occurrence in FF since version 1.

As far as sharing a profile is concerned, I think that it is even more a need for Thunderbird. You wrote that you are a developer. I know it is a common response that gets used too often, but maybe you can take on this issue and fix it? I wish I could, but I am just a QA buff and a regular user aka someone who the FF folks give a damn about.

[NoOp (glgxg)]

Who's idea was it to feed upstream bug comments into this launchpad bug report?
Firefox (Bug 135137 - Profile data cannot be shared by multiple running instances. ) has absolutely *nothing* to do with this bug report.
And BTW: address data sources are working in the non-Ubuntu version of LibreOffice:
LibreOffice 3.5.3.2
Build ID: 235ab8a-3802056-4a8fed3-2d66ea8-e241b8

[Lionel Elie Mamane (lionel-mamane)]

Summary:

 - May be related to 32 bits / 64 bits; works on 64 bits, fails on 32 bits.
 - May be related to version of libebook installed and deprecated / removed symbols; see comment 47.

Any future testers, please *always* say whether you use 32 bits or 64 bits, and what libebook-*.so* you have on your system. Thanks for that.

[Nv4y-robert (nv4y-robert)]

Tried to connect KDE-Adressbook.
OpenSuSE 11.4, 32bit, LO 3.3.4 and LO 3.5.4.2 → connection works, no content is shown (may be another problem).
OpenSuSE 12.1, 64bit, LO 3.5.4.2 → no SDBC-Driver for URL. When I search for more Information the URL "sdbc:address:kab" was not found. I think it could not be found, because the right URL has to be "sdbc:kab". Thats the URL I see, when I open Extras → Options →LibreOffice Base → Connections.

Robert

[tellapu (tellapu)]

Hi NoOp (glgxg)! Your comment regarding address data sources is very interesting. How did you uninstall the official Libre office (12.04) and install the non-Ubuntu version of LibreOffice? (I run Ubuntu 12.04 (AMD64) with LibreOffice 3.5.3.2).
Thanks.

[Lionel Elie Mamane (lionel-mamane)]

(In reply to comment #56)

> When I search for more Information the URL "sdbc:address:kab" was not found.
> I think it could not be found, because the right URL has to be "sdbc:kab".
> Thats the URL I see, when I open
> Extras → Options →LibreOffice Base → Connections.

I think "sdbc:address:kab" is the right one.

I don't see either in my (the default) "Extras → Options →LibreOffice Base → Connections".

[Lionel Elie Mamane (lionel-mamane)]

(In reply to comment #56)
> Tried to connect KDE-Adressbook.
> OpenSuSE 11.4, 32bit, LO 3.3.4 and LO 3.5.4.2 → connection works

OK, as we have reports that:

 - it works on 32 bits
 - does not work on 32 bits

I'm going to assume this is *not* related to 32/64 bits.

More fundamentally, I have the impression we are mixing several different bugs here:

1) Do the right options appear in the "Address Book Data Source" wizard?

2) Do these options work as expected?

Each missing, and each not-working option could be a *different* bug. One of these multiple bugs could be linked to 32/64 bits.

Especially, the libebook discussion should be relevant *only* to "does Evolution appear in the list / work", and not to any other entry.

Wrt to 1):

1.1) evolution missing: duh... Not enabled in our builds :-|

In my testing (my libreoffice-3-6 development tree and LibreOffice 3.6.1.1 official amd64 .debs on Debian amd64 with package libebook-1.2-12 version 3.2.2-3, file /usr/lib/libebook-1.2.so.12), I have:

Mozilla / Netscape
Thunderbird/Icedove
LDAP
Other

The first two don't work, saying that no address book directory is available. As this is very well possible (I don't use any of these programs), this does not necessarily indicate a bug.

LDAP: seems to work, don't have an actual LDAP server to completely test.

Other: seems to work, did not go all the way to a connection

I don't have KDE address book listed: duh, I don't have KDE installed.

I don't have evolution address book listed: I don't use Evolution, so maybe not a bug. Maybe still a bug.

So I'm sending this back to QA:

1) Please open a new bug for each separate issue, and include me in CC

2) Make it a blocker of this bug

3) include exact reproduction instructions on what is needed
   on a fresh system to create said Address Book
   before LibreOffice is supposed to be able to use it:

   a) install what program
      (please not "all of KDE" or something like that)
   b) do what in that program to create a new address book and
      a few entries in it, ...

   Also include exact settings (if any) needed in LibreOffice
   (e.g. LDAP connection string, BaseDN, ...)

   If needs connection to a server, try to find
   a publicly available server.
   E.g. for LDAP, the Debian LDAP directory may do (I don't know).

If the issue is "all entries missing" (or "all except Other"), that's probably a single issue. Don't open a bug per missing entry. But if *some* are missing, probably multiple issues (exception: Evolution, Groupwise and Evolution LDAP are served by the same driver, so if all three are missing,l it is a single issue).

Same for "some/all not working".

[Iplaw67 (iplaw67)]

(In reply to comment #58)

> In my testing (my libreoffice-3-6 development tree and LibreOffice 3.6.1.1
> official amd64 .debs on Debian amd64 with package libebook-1.2-12 version
> 3.2.2-3, file /usr/lib/libebook-1.2.so.12), I have:
>
> Mozilla / Netscape
> Thunderbird/Icedove
> LDAP
> Other

> The first two don't work, saying that no address book directory is available.
> As this is very well possible (I don't use any of these programs), this does
> not necessarily indicate a bug.
>

For me, I can set up and connect to a TB addressbook via the method you describe, ie. via the wizard, on master build from 30/08 64bit, so Thunderbird as an address datasource WFM.

Alex

[David Ostrovsky (d-ostrovsky)]

FYI i am working on Thunderbird Address Book (mork) driver implementation that doesn't depend on any mozilla code.

It based on the open source mork driver implementation. For the details check the https://bugs.freedesktop.org/show_bug.cgi?id=51004. You can check the code (and contribuite ;-) on the LO feature branch: http://cgit.freedesktop.org/libreoffice/core/tree/connectivity/source/drivers/mork?h=feature/mork

Currently it can already import the deafult AddressBook. And almoust the whole range of SQL query constructs is supported (compared to mozilla based implementation).

The plans are: merge that feature branch to master and ship that implementation with LO 3.7 on all not windows platforms
(windows would still depend on mozilla because it is uses it also for outlook and outlook express)

[David Ostrovsky (d-ostrovsky)]

the fix is commited on master

[Michael Meeks (michael-meeks)]

Any more joy in finding / splitting out the component parts of this multi-issue bug ? if not perhaps closing it would provoke filing separate bugs for any remaining issues ?

[NoOp (glgxg)]

Ubuntu 12.04 (no distro versions of LO - all are direct LO .deb's)

LibreOffice 3.5.7.1
Build ID: 3fa2330-e49ffd2-90d118b-705e248-051e21c
Works for me, for the most part[1]
o Mozilla/Netscape
o Thunderbird/Icedove
o LDAP address data
o Other external data source
 - JDBC
 - Oracle JDBC
 - KDE Address Book
 - LDAP Address Book
 - SeaMonkey Address Book
 - Thunderbird/Icedove Address Book
 - Spreadsheet
 - dBASE
 - Text
 - MySQL (JDBC)
 - My SQL (Native)
 - My SQL (ODBC)
 - ODBC
 - PostgreSQL

Version 3.6.2.2 (Build ID: da8c1e6)
Works for me, for the most part[1]
o Evolution
o Groupwise
o Evolution LDAP
o Mozilla/Netscape
o Thunderbird/Icedove
o LDAP address data
o Other external data source
 - dBASE
 - JDBC
 - Groupwise
 - Evolution LDAP
 - KDE Address Book
 - LDAP Address Book
 - SeaMonkey Address Book
 - Thunderbird/Icedove Address Book
 - Spreadsheet
 - dBASE (again - don't know why it's listed twice)
 - Text
 - MySQL (JDBC)
 - My SQL (Native)
 - My SQL (ODBC)
 - ODBC
 - PostgreSQL
@Lionel: Evolution does indeed work just fine for me.

I no longer get "No SDBC driver was found".

[1] There is an issue with the Mozilla/Netscape/SeaMonkey/Thunderbird connections. I have both SeaMonkey (my primary) and Thunderbird. Both are direct Mozilla installs (non-distro) & the profiles reside in normal:
~/.mozilla/seamonkey
~/.thunderbird
However, LO defaults to the SeaMonkey address book when Thunderbird/Icedove is selected. But of course that is for bug report other than this one.

Regarding mixes of LO distro issues: It would simplify things greatly if those issues remain in the distro's reporting system (e.g., launchpad etc). The Ubuntu launchpad issue is:
<https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/93546>
[Address data sources missing] Note this bug report was originally reported by me a few years ago on Ubuntu's OOo. Unfortunatly, that bug report has been intermixed with this one so much that I gave up on it some time ago.

[Lionel Elie Mamane (lionel-mamane)]

(In reply to comment #60)
> Any more joy in finding / splitting out the component parts of this
> multi-issue bug ?

You are right, there was enough time for that to happen, now closing.

[Björn Michaelsen (bjoern-michaelsen)]

as per #215 fixed in upstream 3.5 and later (so precise and later).

[Mozaic (mozaic)]

Ist's on LibreOffice 4.0 note:

https://wiki.documentfoundation.org/ReleaseNotes/4.0#Base
" On all non-Windows platforms a new mork driver implementation is used to access Thunderbird address book. This means that Debian/Ubuntu users can finally integrate LO with their Thunderbird address book. (Debian/Ubuntu distros are not shipping a Mozilla-based mork driver, therefore their native Base package can not access the address book.) This also fixes some really old bugs for different distros. (David Ostrovsky)

For more information please see: https://bugs.freedesktop.org/show_bug.cgi?id=51004 "

[NoOp (glgxg)]

@Björn re: 249:

You've obviously not tried nor tested with
LibreOffice 3.5.7.2
Build ID: 350m1(Build:2)
This product was supplied by The Document Foundation, Debian and Ubuntu.

have you?

[NoOp (glgxg)]

LO(U)3.5.7.2 screenshot