help asked/offered for bug 36555

classic Classic list List threaded Threaded
28 messages Options
Next » 12
Winfried Donkers Winfried Donkers
Reply | Threaded
Open this post in threaded view
|

help asked/offered for bug 36555

Hello all,

 

This bug (MS Access databases cannot be opened since LibO 3.4) is a serious problem for several cpmpanies that migrated from MS Office to LibO (including the company I work for).

Comment 11 from Alex Thurgood gives a possible cause, but:

-I am not familiar with the make system of LibO;

-I am not sure is this can be tested on a Linux machine (I can't build a Windows version of LibO, I use openSUSE Linux);

-I am still a newbie with hacking in LibO.

 

However, I want to help wherever I can with this problem. Is there anyting I can do to (help) solve the bug, preferably with guidance from an expert?

 

 

Winfried

 


_______________________________________________
LibreOffice mailing list
[hidden email]
http://lists.freedesktop.org/mailman/listinfo/libreoffice
Noel Grandin Noel Grandin
Reply | Threaded
Open this post in threaded view
|

Re: help asked/offered for bug 36555

Hi

If you want to help, you need to get your hands on a Windows machine to test builds on.
Preferably something with lots of cores and a reasonable amount of memory (4G or more) because the windows build is quite slow.

Here are some links to help you get started with setting up a Windows machine:
http://wiki.documentfoundation.org/Development/Windows_Build_Dependencies
http://wiki.documentfoundation.org/Development/Native_Build
http://wiki.documentfoundation.org/Development/BuildingOnWindowsWithCygwinAndMSVCExpress

Regards, Noel Grandin

Winfried Donkers wrote:

Hello all,

 

This bug (MS Access databases cannot be opened since LibO 3.4) is a serious problem for several cpmpanies that migrated from MS Office to LibO (including the company I work for).

Comment 11 from Alex Thurgood gives a possible cause, but:

-I am not familiar with the make system of LibO;

-I am not sure is this can be tested on a Linux machine (I can't build a Windows version of LibO, I use openSUSE Linux);

-I am still a newbie with hacking in LibO.

 

However, I want to help wherever I can with this problem. Is there anyting I can do to (help) solve the bug, preferably with guidance from an expert?

 

 

Winfried

 



_______________________________________________
LibreOffice mailing list
[hidden email]
http://lists.freedesktop.org/mailman/listinfo/libreoffice




Disclaimer: http://www.peralex.com/disclaimer.html


_______________________________________________
LibreOffice mailing list
[hidden email]
http://lists.freedesktop.org/mailman/listinfo/libreoffice
Winfried Donkers Winfried Donkers
Reply | Threaded
Open this post in threaded view
|

Re: help asked/offered for bug 36555


>>This bug (MS Access databases cannot be opened since LibO 3.4) is a serious problem for several cpmpanies that migrated from >>MS Office to LibO (including the company I work for).
>>Comment 11 from Alex Thurgood gives a possible cause, but:
>>-I am not familiar with the make system of LibO;
>>-I am not sure is this can be tested on a Linux machine (I can't build a Windows version of LibO, I use openSUSE Linux);
>>-I am still a newbie with hacking in LibO.
 
>>However, I want to help wherever I can with this problem. Is there anyting I can do to (help) solve the bug, preferably with >>guidance from an expert?

>If you want to help, you need to get your hands on a Windows machine to test builds on.
>Preferably something with lots of cores and a reasonable amount of memory (4G or more) because the windows build is quite >slow.

Sorry, I don't have a Windows machine available with lots of cores and memory. Neither do we have MSVC++.
I'll have to wait till someone who does have such a machine (and time) picks up the bug...

 
 
Winfried
_______________________________________________
LibreOffice mailing list
[hidden email]
http://lists.freedesktop.org/mailman/listinfo/libreoffice
Noel Grandin Noel Grandin
Reply | Threaded
Open this post in threaded view
|

Re: help asked/offered for bug 36555

Hi

You don't need to pay for MSVC - there is a free Express version available (I'm using it).
And if your machine is slower, it just means it'll take a little longer to give feedback.
Even an older Windows-XP machine will do fine for this purpose.

Really, there are not that many LibreOffice developers around.
Your bug won't get priority unless either
(a) you step in and at least help with running test,
or (b) your company pays SUSE/Redhat to allocate one of their developers to it.

-- Noel Grandin

Winfried Donkers wrote:
Sorry, I don't have a Windows machine available with lots of cores and memory. Neither do we have MSVC++. I'll have to wait till someone who does have such a machine (and time) picks up the bug.




Disclaimer: http://www.peralex.com/disclaimer.html


_______________________________________________
LibreOffice mailing list
[hidden email]
http://lists.freedesktop.org/mailman/listinfo/libreoffice
Alex Thurgood Alex Thurgood
Reply | Threaded
Open this post in threaded view
|

Re: help asked/offered for bug 36555

In reply to this post by Winfried Donkers
Le 17/11/11 09:11, Winfried Donkers a écrit :

Hi Winfried,


> Comment 11 from Alex Thurgood gives a possible cause, but:
>

What we need is for someone to test it with a recent daily build on
Windows from master, because it might already be fixed. Only then is it
worthwhile investigating further.

I don't recall that you could ever read MDB files from within OOo/LO on
Linux (or Mac for that matter). There was a vague attempt to integrate
MDB read capabilities into OOo, but I thought that faded out and
certainly never got integrated into the main branch (unless some Linux
distros did it ?).

Alex


_______________________________________________
LibreOffice mailing list
[hidden email]
http://lists.freedesktop.org/mailman/listinfo/libreoffice
Winfried Donkers Winfried Donkers
Reply | Threaded
Open this post in threaded view
|

Re: help asked/offered for bug 36555

In reply to this post by Noel Grandin
>You don't need to pay for MSVC - there is a free Express version available (I'm using it).
>And if your machine is slower, it just means it'll take a little longer to give feedback.
>Even an older Windows-XP machine will do fine for this purpose.

I will try to set up a Windows machine for building LibreOffice. It'll take some time, but when I succeed I will get back to you with feedback (or questions).

Winfried Donkers


_______________________________________________
LibreOffice mailing list
[hidden email]
http://lists.freedesktop.org/mailman/listinfo/libreoffice
Noel Grandin Noel Grandin
Reply | Threaded
Open this post in threaded view
|

Re: help asked/offered for bug 36555

In reply to this post by Alex Thurgood
Hi

Excellent. Feel free to ask for help if you get stuck setting it up.

-- Noel Grandin

Alexander Thurgood wrote:
Le 17/11/11 09:11, Winfried Donkers a écrit :

Hi Winfried,


Comment 11 from Alex Thurgood gives a possible cause, but:

What we need is for someone to test it with a recent daily build on
Windows from master, because it might already be fixed. Only then is it
worthwhile investigating further.

I don't recall that you could ever read MDB files from within OOo/LO on
Linux (or Mac for that matter). There was a vague attempt to integrate
MDB read capabilities into OOo, but I thought that faded out and
certainly never got integrated into the main branch (unless some Linux
distros did it ?).

Alex


_______________________________________________
LibreOffice mailing list
[hidden email]
http://lists.freedesktop.org/mailman/listinfo/libreoffice





Disclaimer: http://www.peralex.com/disclaimer.html


_______________________________________________
LibreOffice mailing list
[hidden email]
http://lists.freedesktop.org/mailman/listinfo/libreoffice
julien2412 julien2412
Reply | Threaded
Open this post in threaded view
|

Re: help asked/offered for bug 36555

In reply to this post by Alex Thurgood
Just to remind what said Jan, there's the url http://dev-builds.libreoffice.org/daily/ where daily builds can be found.
About Windows, Voreppe and Windows_2008R2/ have something to test.

Now if there's a backtrace, we won't have symbols to help (will we ?).
Michael Meeks-2 Michael Meeks-2
Reply | Threaded
Open this post in threaded view
|

Re: help asked/offered for bug 36555

In reply to this post by Noel Grandin

On Thu, 2011-11-17 at 12:00 +0200, Noel Grandin wrote:
> or (b) your company pays SUSE/Redhat to allocate one of their
> developers to it.

        Heh ;-) Of course, there is also Canonical, Lanedo, and any number of
other S/W consulting firms that could help out.

        But - of course you're right; the basic way to get things fixed is to
fix them yourself, and we're eager to help self-motivated problem fixers
with code pointers, tips, build help etc. etc.

        So - indeed, the first step is to get a build. After you have that,
resurrecting the old mdbtools CWS / patch set would be a good idea.

        The -real- reason we havn't shipped mdbtools in anger is that it is not
reliable / good at write support. If we are not writing into the
database - we need to migrate it to something else on load. If we are
migrating it to something else, we want to run hundreds of miles up-hill
rather than migrate tens of thousands of users to using hsqldb in anger.
So we're blocked on getting a nice sqlite backend in-tree that we're
confident enough in to replace hsqldb, such that we can resurrect the
mdbtool stuff so that ... ;-) so it is rather a linked problem.

        OTOH - it'd be great to have help with any part of that you like.

        All the best,

                Michael.

--
[hidden email]  <><, Pseudo Engineer, itinerant idiot

_______________________________________________
LibreOffice mailing list
[hidden email]
http://lists.freedesktop.org/mailman/listinfo/libreoffice
Alex Thurgood Alex Thurgood
Reply | Threaded
Open this post in threaded view
|

Re: help asked/offered for bug 36555

In reply to this post by Alex Thurgood
Le 17/11/2011 10:43, Alexander Thurgood a écrit :

I tested this on the master daily build from 26/11/2011 built by 2008R2
and can confirm that the bug is still there. I added my comments to the
bug report.

This bug was introduced somewhere just after the branching off of the
3.4 tree, the 3.3.x versions still work with Access files.

Alex

_______________________________________________
LibreOffice mailing list
[hidden email]
http://lists.freedesktop.org/mailman/listinfo/libreoffice
Winfried Donkers Winfried Donkers
Reply | Threaded
Open this post in threaded view
|

Re: help asked/offered for bug 36555

In reply to this post by Noel Grandin
>Excellent. Feel free to ask for help if you get stuck setting it up.

>-- Noel Grandin

I have installed all dependancies (I hope) and am now trying to get ./autogen.sh to succeed (so far, a lot of paths to be set as option). I keep having trouble with moz/zipped. Should this be (as seen from within cygwin)  /moz/zipped, /git/libo/moz/zipped or something else (master is cloned to /git/libo)?
It'll be monday before I can continue my struggle to get a Windows build, so that I can -with your help- try to include the mdbtools. Even a limited ability (reading and simple writing of ms access files) would be fine.


Winfried


_______________________________________________
LibreOffice mailing list
[hidden email]
http://lists.freedesktop.org/mailman/listinfo/libreoffice
Noel Grandin Noel Grandin
Reply | Threaded
Open this post in threaded view
|

Re: help asked/offered for bug 36555

Hi

It should be, from your perspective, /git/lib/moz/zipped

For reference, my autogen looks like:

--with-max-jobs=6
--with-num-cpus=6
--without-junit
--without-java
--with-ant-home=/cygdrive/c/libreoffice/apache-ant-1.8.2
--disable-build-mozilla
--disable-atl
--disable-activex
--with-windows-sdk-home=/cygdrive/c/Program Files/Microsoft
SDKs/Windows/v7.1
--with-mozilla-build=/cygdrive/c/mozilla-build

-- Noel Grandin

On 18 November 2011 14:52:51, Winfried Donkers wrote:

>> Excellent. Feel free to ask for help if you get stuck setting it up.
>
>> -- Noel Grandin
>
> I have installed all dependancies (I hope) and am now trying to get ./autogen.sh to succeed (so far, a lot of paths to be set as option). I keep having trouble with moz/zipped. Should this be (as seen from within cygwin)  /moz/zipped, /git/libo/moz/zipped or something else (master is cloned to /git/libo)?
> It'll be monday before I can continue my struggle to get a Windows build, so that I can -with your help- try to include the mdbtools. Even a limited ability (reading and simple writing of ms access files) would be fine.
>
>
> Winfried
>
>
>

Disclaimer: http://www.peralex.com/disclaimer.html


_______________________________________________
LibreOffice mailing list
[hidden email]
http://lists.freedesktop.org/mailman/listinfo/libreoffice
Michael Meeks-2 Michael Meeks-2
Reply | Threaded
Open this post in threaded view
|

Re: help asked/offered for bug 36555

In reply to this post by Winfried Donkers

On Fri, 2011-11-18 at 13:52 +0100, Winfried Donkers wrote:
> I have installed all dependancies (I hope) and am now trying to
> get ./autogen.sh to succeed (so far, a lot of paths to be set as
> option). I keep having trouble with moz/zipped. Should this be (as
> seen from within cygwin)  /moz/zipped, /git/libo/moz/zipped or
> something else (master is cloned to /git/libo)?

        The mozilla stuff is a nightmare, I'd recommend turning it off as much
as possible (personally) - it only slows the build down for your needs.

> It'll be monday before I can continue my struggle to get a Windows
> build, so that I can -with your help- try to include the mdbtools.
> Even a limited ability (reading and simple writing of ms access files)
> would be fine.

        Sure - well, it should be easy enough to resurrect the code to do that,
the CWS as a patch is here:

http://cgit.freedesktop.org/libreoffice/build/tree/patches/dev300/cws-mdbdriver01.diff

        And there are some patches for mdb related bits in the same directory,
look at the 'apply' file there and for the mdb related section.

        HTH,

                Michael.

--
[hidden email]  <><, Pseudo Engineer, itinerant idiot

_______________________________________________
LibreOffice mailing list
[hidden email]
http://lists.freedesktop.org/mailman/listinfo/libreoffice
Lionel Élie Mamane Lionel Élie Mamane
Reply | Threaded
Open this post in threaded view
|

Re: help asked/offered for bug 36555

In reply to this post by Michael Meeks-2
On Thu, Nov 17, 2011 at 01:54:56PM +0000, Michael Meeks wrote:

> So - indeed, the first step is to get a build. After you have that,
> resurrecting the old mdbtools CWS / patch set would be a good idea.

That's not the best way to fix this bug. As I read it, bug#36555 is
about accessing Access files through the ADO driver, not through
mdbtools! So what needs to be done is to fix/reenable/whatever the ADO
SDBC driver.

Think of ADO as another API to access datastores, including databases;
it is actually an object wrapper around the OLE DB API. It is rather
higher-level than ODBC (but still allows escape to direct SQL, if the
datastore supports SQL), and actually there is an OLE DB provider
(~driver) for ODBC, so that ODBC is just one of the datastores that
ADO/OLE DB can access. It is deprecated, though, and won't be made
available for 64 bit OS/App.

There is also a "direct" OLE DB provider for MS Access mdb files
(technically, for the underlying "Jet" database engine) and that is
what the people reporting the bug are trying to use.

So fixing this should be easier than addressing the SQLite/mdbtools
situation cleanly!

--
Lionel
_______________________________________________
LibreOffice mailing list
[hidden email]
http://lists.freedesktop.org/mailman/listinfo/libreoffice
Alex Thurgood Alex Thurgood
Reply | Threaded
Open this post in threaded view
|

Re: help asked/offered for bug 36555

Le 20/11/2011 10:49, Lionel Elie Mamane a écrit :

Hi all,

> So fixing this should be easier than addressing the SQLite/mdbtools
> situation cleanly!
>

I would tend to agree. It worked before in 3.3.x, and then it stopped
working when 3.4 was branched, so if my addled brain is not too rotten,
that would indicate that the problem was introduced by a commit that
prevented the code which worked either from being compiled or from
completing compilation.

Alex

_______________________________________________
LibreOffice mailing list
[hidden email]
http://lists.freedesktop.org/mailman/listinfo/libreoffice
Winfried Donkers Winfried Donkers
Reply | Threaded
Open this post in threaded view
|

Re: help asked/offered for bug 36555

In reply to this post by Noel Grandin
> Excellent. Feel free to ask for help if you get stuck setting it up.

> -- Noel Grandin

.autogen.sh succeeded, now make give a strange error:
...
configure: creating ./config.status
./configure: line 8411: test: too many arguments
./configure: line 8411: test: too many arguments
./configure: line 8411: test: too many arguments
./configure: line 8411: test: too many arguments
./configure: line 8411: test: too many arguments
./configure: line 8411: test: too many arguments
configure: error: could not make ./config.status
...
line 8411 of configure is 'if test -z "$CPP"; then', whicj looks perfectly ok to me
config.status has not been altered (size is 0bytes, timestamp is before starting time of make)

Also, considering the vast amount of messages added to bug 36555 by Lionel Elie Mamane and Alex Thurgood, it may be wiser to abandon my attempts to build LibreOffice and continue with easy hacks on my Linus machine? Or do you still wish me to have a running windows machine for testing this (and possible other) bugs/patches?

Winfried
_______________________________________________
LibreOffice mailing list
[hidden email]
http://lists.freedesktop.org/mailman/listinfo/libreoffice
Lionel Élie Mamane Lionel Élie Mamane
Reply | Threaded
Open this post in threaded view
|

Re: help asked/offered for bug 36555

On Mon, Nov 21, 2011 at 12:07:03PM +0100, Winfried Donkers wrote:

> Also, considering the vast amount of messages added to bug 36555 by
> Lionel Elie Mamane and Alex Thurgood, it may be wiser to abandon my
> attempts to build LibreOffice and continue with easy hacks on my
> Linus machine?

Well, the situation is that I think I've fixed the bug (in 3.5 on 20
November 2011 with 0e9473eca6f559bc83eb061384b0db936e4ed8e1), but
haven't tested it, because:

1) I don't have a Windows build

2) Not eager to invest the time in making one

3) My plan was to wait for a Windows tinderbox to build, and test the
   result.

The untested nature of the fix keeps it off the libreoffice-3-4
branch.

If you were to test my patch (e.g. by taking the last git revision
that a tinderbox built correctly and adding my patch), that patch
could be in the libreoffice-3-4 branch "sooner" and that would make me
a bit happier (one thing less on my "TODO stack"). It would also give
your company a version of LibreOffice with that bug fixed *right*
*now* (assuming my patch indeed fixes the bug), if you compile 3.4.4 +
my patch. It would also allow your company to have _any_ fix / change
you/they want in future :)

Looking at the LibreOffice project's interest, in the short term we
would probably benefit more from your going through other
EasyHacks. Except if it makes the difference between having the fix
for 3.4.5 or not, but I dare hope the Windows build will be fixed
"soon enough" for that not to be a factor.

On the long term, my general impression is that people with a Windows
build environment and/or an interest in the Windows build and/or the
time to take care if Windows issues are rather more scarce than we'd
like, so your being one of these people could be useful in future :)


I realise I haven't given you a straight simple answer, but <shrug>,
that's the situation.

--
Lionel
_______________________________________________
LibreOffice mailing list
[hidden email]
http://lists.freedesktop.org/mailman/listinfo/libreoffice
Winfried Donkers Winfried Donkers
Reply | Threaded
Open this post in threaded view
|

Re: help asked/offered for bug 36555


>Looking at the LibreOffice project's interest, in the short term we
>would probably benefit more from your going through other
>EasyHacks. Except if it makes the difference between having the fix
>for 3.4.5 or not, but I dare hope the Windows build will be fixed
>"soon enough" for that not to be a factor.
>On the long term, my general impression is that people with a Windows
>build environment and/or an interest in the Windows build and/or the
>time to take care if Windows issues are rather more scarce than we'd
>like, so your being one of these people could be useful in future :)
>I realise I haven't given you a straight simple answer, but <shrug>,
>that's the situation.

I will opt for the long term (and hope that others are able to test the patch soon) but I will keep the windows-machine ready to try again (for when someone (including myself) knows a solution for the error messages).

Winfried
_______________________________________________
LibreOffice mailing list
[hidden email]
http://lists.freedesktop.org/mailman/listinfo/libreoffice
Noel Grandin-2 Noel Grandin-2
Reply | Threaded
Open this post in threaded view
|

Re: help asked/offered for bug 36555

In reply to this post by Winfried Donkers
Hmmm, that looks like a quoting problem with the $CPP variable.

What does your $CPP variable look like?

On Mon, Nov 21, 2011 at 13:07, Winfried Donkers
<[hidden email]> wrote:

>> Excellent. Feel free to ask for help if you get stuck setting it up.
>
>> -- Noel Grandin
>
> .autogen.sh succeeded, now make give a strange error:
> ...
> configure: creating ./config.status
> ./configure: line 8411: test: too many arguments
> ./configure: line 8411: test: too many arguments
> ./configure: line 8411: test: too many arguments
> ./configure: line 8411: test: too many arguments
> ./configure: line 8411: test: too many arguments
> ./configure: line 8411: test: too many arguments
> configure: error: could not make ./config.status
> ...
> line 8411 of configure is 'if test -z "$CPP"; then', whicj looks perfectly ok to me
> config.status has not been altered (size is 0bytes, timestamp is before starting time of make)
>
> Also, considering the vast amount of messages added to bug 36555 by Lionel Elie Mamane and Alex Thurgood, it may be wiser to abandon my attempts to build LibreOffice and continue with easy hacks on my Linus machine? Or do you still wish me to have a running windows machine for testing this (and possible other) bugs/patches?
>
> Winfried
> _______________________________________________
> LibreOffice mailing list
> [hidden email]
> http://lists.freedesktop.org/mailman/listinfo/libreoffice
>
_______________________________________________
LibreOffice mailing list
[hidden email]
http://lists.freedesktop.org/mailman/listinfo/libreoffice
Winfried Donkers Winfried Donkers
Reply | Threaded
Open this post in threaded view
|

Re: help asked/offered for bug 36555

>> .autogen.sh succeeded, now make give a strange error:
>> ...
>> configure: creating ./config.status
>> ./configure: line 8411: test: too many arguments
>> ...
>> configure: error: could not make ./config.status
>> ...
>Hmmm, that looks like a quoting problem with the $CPP variable.
>What does your $CPP variable look like?

Sorry for the delay in answering:
I found out that not ./configure caused the problem, but ./dmake/configure
line 8411 of this configure says
  if test `sed -n "s/.*$ac_delim\$/X/p" conf$$subs.sed | grep -c X` = 97; then
As I'm not well versed with sed, I daren't tell you what which(?) variable looks like.

Winfried
_______________________________________________
LibreOffice mailing list
[hidden email]
http://lists.freedesktop.org/mailman/listinfo/libreoffice
Next » 12