Bug 54456 - Open of a existing ODBC connection I got a strange screen
Summary: Open of a existing ODBC connection I got a strange screen
Status: CLOSED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: Other macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-09-03 19:09 UTC by Fred Bakker
Modified: 2014-09-17 17:56 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
Screen dump (128.90 KB, image/jpeg)
2012-09-03 19:09 UTC, Fred Bakker
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Fred Bakker 2012-09-03 19:09:08 UTC
Created attachment 66570 [details]
Screen dump

The connection is pooled by ODBC and exists
Comment 1 Alex Thurgood 2012-09-03 19:44:19 UTC
Fred : DUP of bug 54457 ?

Alex
Comment 2 Alex Thurgood 2012-09-03 19:44:48 UTC
Does it crash ?

Alex
Comment 3 Julien Nabet 2012-09-15 05:31:46 UTC
On which env are you?
Could you rename your LO directory profile and try again? (see http://wiki.documentfoundation.org/UserProfile)
Comment 4 Cor Nouws 2012-12-15 15:25:25 UTC
Hi Fred,
Any change that you help with the quesions, or is the problem resolved in the mean time?
Thanks - Cor
Comment 5 Fred Bakker 2012-12-15 17:27:45 UTC
Hello Cor,

No and I have those problems not on my Windows version.
I have also 3 rows instead of all the rows in the table and also that 
problem doesn't occur on the Windows machine.
I think LibreOffice Base is not ment to run on a Apple.

But I am open for suggestions.....

Thanks Cor and have a Nice Christmas and a Happy New Year.

Fred Bakker

On 15-12-12 16:25, bugzilla-daemon@freedesktop.org wrote:
> Cor Nouws <mailto:cno@nouenoff.nl> changed bug 54456 
> <https://bugs.freedesktop.org/show_bug.cgi?id=54456>
> What 	Removed 	Added
> CC 		cno@nouenoff.nl
>
> *Comment # 4 <https://bugs.freedesktop.org/show_bug.cgi?id=54456#c4> 
> on bug 54456 <https://bugs.freedesktop.org/show_bug.cgi?id=54456> from 
> Cor Nouws <mailto:cno@nouenoff.nl> *
> Hi Fred,
> Any change that you help with the quesions, or is the problem resolved in the
> mean time?
> Thanks - Cor
> ------------------------------------------------------------------------
> You are receiving this mail because:
>
>   * You reported the bug.
>
Comment 6 Julien Nabet 2012-12-15 17:33:52 UTC
(In reply to comment #5)
...
> But I am open for suggestions.....
Could you give a try to a newer version like 3.6.4? (3.6.1 is getting old)
If you still reproduce this, could you rename your LO directory profile (see my previous comment https://bugs.freedesktop.org/show_bug.cgi?id=54456#c3) ?

Finally, could you also give your Java version? (Base is very dependent on Java)
Comment 7 Fred Bakker 2012-12-16 11:08:58 UTC
Hello,

On the Apple I have Version 3.6.4.3 (Build ID: 2ef5aff), so that is the 
last version.
How can I see which version of Java (run-time I supose) I have ?

ODBC doesn't give that problem on the Apple, but with ODBC, I still get 
strange behavior. like:


While I have:

267 records in the database table and I think it is also a Java problem.
I don't have this problem on the Windows machine.
I did use the normal installation of a downloaded .dmg
Also it could be strange to have different versions of Java.
I have also NetBeans 7.3 Beta on this machine.

Julien I work also on a Dutch version of OS X version 10.8, so it is 
hard to find
the directory's and I didn't find a user profile on the place you mentioned.

Hopefully it gives you some ideas about this problem.
I give computerlessons to 55 Plus (elderly) people and I would like
to give them an alternative for Windows Office, also with Base in
place of Access.

By the way I have installed Version 3.6.4.3 (Build ID: 2ef5aff) on Windows
and the problem is solved I think, so you can close the bug 54456, 
because the
problems with the strange screen are gone on both machines.

You all are very helpfull to try to solve this problem and I would like
help you all to make LibreOffice a good alternative.

Thanks in advance

Fred Bakker

On 15-12-12 18:33, bugzilla-daemon@freedesktop.org wrote:
>
> *Comment # 6 <https://bugs.freedesktop.org/show_bug.cgi?id=54456#c6> 
> on bug 54456 <https://bugs.freedesktop.org/show_bug.cgi?id=54456> from 
> Julien Nabet <mailto:serval2412@yahoo.fr> *
> (In reply tocomment #5  <show_bug.cgi?id=54456#c5>)
> ...
> > But I am open for suggestions.....
> Could you give a try to a newer version like 3.6.4? (3.6.1 is getting old)
> If you still reproduce this, could you rename your LO directory profile (see my
> previous commenthttps://bugs.freedesktop.org/show_bug.cgi?id=54456#c3  <show_bug.cgi?id=54456#c3>) ?
>
> Finally, could you also give your Java version? (Base is very dependent on
> Java)
> ------------------------------------------------------------------------
> You are receiving this mail because:
>
>   * You reported the bug.
>
Comment 8 Julien Nabet 2012-12-16 11:41:44 UTC
Fred Bakker:
So trying to understand your feedback.
- You had some problem with Windows but with last version they're gone.
- You still have problems with MacOs but don't know where to find LO directory profile
- Moreover, you don't know how to see Java version.

So first, I update platform to Macos All.
About profile, the important thing is this one:
"For Mac users:

    /Users/<user name>/Library/Application Support/libreoffice/3/user

Important: These folders are hidden, you need to enable the option from your operative system to see hidden folders in order to see them."

About Java, just launch LO then go to Menu Options, then LibreOffice/Java and take a look to the version used.

Don't hesitate to come on IRC #libreoffice on freenode.net and talk about this behaviour.
Comment 9 Fred Bakker 2012-12-16 18:50:45 UTC
Hello,

Yes, that is correct; I don't have the ODBC problem anymore, also the 
connection
with a MySQL database did work.

I did try the command below "/User......"
I got this:


First I treid to do cd
Second I did ls of Library which was found and you can see what's inside
The last one was a ls of a part of the mentioned path, but there is no 
LibreOffice inside.

At the Java subject I found this and I suppose that this is what you are 
looking for.

Which I found under "Preferences" and not under Options, but the heading 
is Options, so it's ok.

I did connect and found 
http://download.documentfoundation.org/libreoffice/stable/3.5.2/win/x86/LibO_3.5.2_Win_x86_install_multi.msi
which is not the correct one (I was downloading 3.6.4), but I got this 
message there


  Object not found!

The requested URL was not found on this server. The link on the 
referring page <http://libreoffice.nl.portalux.com/download:p:mac> seems 
to be wrong or outdated. Please inform the author of that page 
<http://libreoffice.nl.portalux.com/download:p:mac> about the error.

If you think this is a server error, please contact the webmaster 
<mailto:ftp@documentfoundation.org>.


    Error 404

download.documentfoundation.org <http://download.documentfoundation.org/>
Sun Dec 16 19:44:22 2012
Apache



And I did already give the webmaster a message about that.

What is the purpose of freenode.net, because there is already a 
LibreOffice.org ?

Greetings and thanks in advance

Fred Bakker

On 16-12-12 12:41, bugzilla-daemon@freedesktop.org wrote:
> Julien Nabet <mailto:serval2412@yahoo.fr> changed bug 54456 
> <https://bugs.freedesktop.org/show_bug.cgi?id=54456>
> What 	Removed 	Added
> OS 	All 	Mac OS X (All)
>
> *Comment # 8 <https://bugs.freedesktop.org/show_bug.cgi?id=54456#c8> 
> on bug 54456 <https://bugs.freedesktop.org/show_bug.cgi?id=54456> from 
> Julien Nabet <mailto:serval2412@yahoo.fr> *
> Fred Bakker:
> So trying to understand your feedback.
> - You had some problem with Windows but with last version they're gone.
> - You still have problems with MacOs but don't know where to find LO directory
> profile
> - Moreover, you don't know how to see Java version.
>
> So first, I update platform to Macos All.
> About profile, the important thing is this one:
> "For Mac users:
>
>      /Users/<user name>/Library/Application Support/libreoffice/3/user
>
> Important: These folders are hidden, you need to enable the option from your
> operative system to see hidden folders in order to see them."
>
> About Java, just launch LO then go to Menu Options, then LibreOffice/Java and
> take a look to the version used.
>
> Don't hesitate to come on IRC #libreoffice on freenode.net and talk about this
> behaviour.
> ------------------------------------------------------------------------
> You are receiving this mail because:
>
>   * You reported the bug.
>
Comment 10 Julien Nabet 2012-12-16 20:04:24 UTC
Fred: you're mixing Win and MacOs elements.
You must seperate both subjects to make it clear.

1) On Windows
If you have still some remaining problems. Try a clean install, ie:
- uninstall LO
- clean your Windows registry with free tool (like ccleaner)
- rename or delete (if you didn't customize anything) your LO directory profile
Before Vista: \Documents and Setting\<user name>\Application Data\libreoffice\3\user
From Vista: %appdata%\libreoffice\3\user
- install last 3.6.4 version

On Windows, what's your Java version (you can go to "add/uninstall softs" to know it)

2) On Mac
It seems you have several versions.
So idem:
- uninstall every LO versions
- rename or delete your LO directory profile
/Users/<user name>/Library/Application Support/libreoffice/3/user
- install last 3.6.4 version

On Windows, what's your Java version


Last thing: please, answer by adding a comment to the bugtracker here https://bugs.freedesktop.org/show_bug.cgi?id=54456
and not by answering the email automatically sent by bugzilla
And again: distinguish the problems and actions you did on 2 platforms.
Comment 11 Fred Bakker 2012-12-17 13:48:37 UTC
I don't have the problems in the Windows version anymore.
I still have the silly problem of just 3 records instead of 187 record and just alone on the Apple iMac.
Even with the 4.0.0 version !!
At LODev-Advanced-Java I have 1.6_0_37 as Java Runtime version fro Apple Inc.
Again: I don't have problems anymore with the Windows version.
Comment 12 Julien Nabet 2012-12-17 13:54:48 UTC
Fred: thank you for your feedback and your patience.

Alex/Roman: it seems it's a Mac Only bug, would you have some time to give it a try?
Comment 13 Fred Bakker 2012-12-17 14:11:39 UTC
In what way Julien ? I am not in a hurry and I have other tools to go around.
Comment 14 Roman Eisele 2012-12-18 08:12:22 UTC
(In reply to comment #12)
> Alex/Roman: it seems it's a Mac Only bug, would you have some time to give
> it a try?

@ Alex:
Can you please take this one? You are much more into Base than me ... ;-)
Thank you!
Comment 15 Alex Thurgood 2012-12-20 07:32:16 UTC
@All : On the Mac, ODBC problems are not new, they have been around since the release of OOo 3.3.x, and consequently, since the creation of the LO project.

https://bugs.freedesktop.org/show_bug.cgi?id=46237


It is not a Java problem.

As LO is 32bit only on Mac, the user requires a 32bit driver. However, if you are using a recent version of OSX, which Fred doesn't mention, then you are stuck. OSX 10.7 and 10.8 come with mysql server 64bit pre-installed, which can only be talked to via a 64bit ODBC connector. The ODBC 64bit connector will not talk to LO and vice-versa.

A simple test for this is to use isql from the command line.

Now, on 32bit OSX systems, so Tiger (10.4), Leopard (10.5) and SnowLeopard (10.6) in 32bit kernel mode, the mysql ODBC driver and LO will talk to each other, but there is a bug somewhere in one of the pieces that means that means that either you will get a connection and no data, or else, dependent on mysql ODBC driver and iODBCAdmin  version, you  will get a connection that only shows the first 3 results of the resultset.

Fred is lucky in so far as he can at least see the first 3 results. When I was testing this throughout LO 3.3.x development, I could only get a successful connection, but no data.

Note that the ODBC driver supplied by MySQL in versions 5.x is buggy as hell, and is missing bits that are required for proper operation, such as the driver setup libraries...


What Fred has failed to give us so far, at least for the Mac, is :

Operating system info : OSX version
MySQL ODBC Driver version :
iODBCAdmin version (this is supplied by Apple) :
MySQL server version and whether the server instance is local or remote :
The location of his odbc.ini and odbcinst.ini files. Beware, there can often be 2 or more sets of these files on an OSX system, and Apple's "protective" configuration regime prevents the normal user from seeing these locations.

I can not do testing because I'm on a 64bit kernel, with a 64bit local version of mysql, which requires the 64bit driver. This driver refuses to talk to LO, or LO refuse to talk to the driver - either way, it doesn't work for me at all.

Ideally, if someone wanted to try and reproduce this, they would need an older version of the MySQL ODBC 32bit driver, running on a 32bit Mac OSX system, so Tiger or Leopard, or at a pinch and with some juggling, OSX 10.6.

Alex
Comment 16 Alex Thurgood 2012-12-20 07:48:24 UTC
Yet another nail in the coffin for ODBC on OSX...

@Fred : switch to the JDBC connector, at least it works...

Alternatively, try the native mysql connector from the Apache OO project, which I think still continues to work with LO 3.6. I haven't been able to build the mysql native connector for Mac for about 6 months now, and there is no solution to that, other than to hope that the AOO project will keep supplying a working connector. This however, is potentially unlikely, with regard to version 4 of LibreOffice, since it was decided to allow incompatible changes in the LO code which might cause extensions to break, including the native mysql connector extension.


Alex
Comment 17 Alex Thurgood 2012-12-20 08:06:29 UTC
Setting version to earliest release where problem first noted, i.e. 3.3.0


Alex
Comment 18 Roman Eisele 2012-12-20 08:46:07 UTC
@ Alex Thurgood:
Thank you very very much for your careful research and detailed explanation of this issue! Now at least we understand what’s going on here ...
Comment 19 Alex Thurgood 2013-01-10 16:52:50 UTC
Adding Lionel to CC
Comment 20 Alex Thurgood 2014-09-17 17:53:59 UTC
This works fine for me with mysql 5.1 odbc connector 64bit and LO 4.3.1.2 64bit TDF release
Comment 21 Alex Thurgood 2014-09-17 17:55:05 UTC
There is a newer version (5.3) of the odbc connector available from mysql - I haven't tested that yet.
Comment 22 Alex Thurgood 2014-09-17 17:56:37 UTC
@Fred : update to the latest 64bit versions as indicated and reconfigure your odbc.ini system dsn accordingly