[Libreoffice-bugs] [Bug 103077] Can't connect to an existing data base with ODBC ( unixODBC or iODBC), ..."Due to an unexpected error, LibreOffice crashed. ..."

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103077

Julien Nabet  changed:

   What|Removed |Added

   Keywords|wantBacktrace   |haveBacktrace
   Priority|medium  |high
 Status|UNCONFIRMED |NEW
 Ever confirmed|0   |1
   Severity|normal  |major

--- Comment #11 from Julien Nabet  ---
bt is ok, thank you for your feedback.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103077] Can't connect to an existing data base with ODBC ( unixODBC or iODBC), ..."Due to an unexpected error, LibreOffice crashed. ..."

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103077

--- Comment #10 from Howard Johnson  ---
Created attachment 127958
  --> https://bugs.documentfoundation.org/attachment.cgi?id=127958=edit
gdbtrace.log  of trying to register and open a new LO ODBC database

Hope this is the right thing for you.  I've never done this before.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103077] Can't connect to an existing data base with ODBC ( unixODBC or iODBC), ..."Due to an unexpected error, LibreOffice crashed. ..."

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103077

Julien Nabet  changed:

   What|Removed |Added

   Keywords||wantBacktrace
 CC||serval2...@yahoo.fr

--- Comment #9 from Julien Nabet  ---
To retrieve a backtrace on Linux, you can use this link:
https://wiki.documentfoundation.org/QA/BugReport/Debug_Information#GNU.2FLinux:_How_to_get_a_backtrace

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103077] Can't connect to an existing data base with ODBC ( unixODBC or iODBC), ..."Due to an unexpected error, LibreOffice crashed. ..."

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103077

--- Comment #8 from rob...@familiegrosskopf.de ---
Have tried it a little bit more.

libmaodbc.so: 
I couldn't get it work with the binaries. 
One version (2.0.12, libmadoc.so 1.6 MB) gives the error: file not found
Other version (2.0.12, libmadoc.so 2.0 MB) gives the error: memory allocation
error.
I won't install it through the source-code.

Tested all the special differences in our odbcinst.ini and odbc.ini. Worked
with all the parameters you have given - but always the same way as without
these parameters.

Couldn't reproduce any error here with OpenSUSE 42.1 64bit rpm Linux.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103077] Can't connect to an existing data base with ODBC ( unixODBC or iODBC), ..."Due to an unexpected error, LibreOffice crashed. ..."

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103077

--- Comment #7 from Howard Johnson  ---
I just upgraded to unixODBC 2.3.4.  But the results are the same: crash.

Also I'm using Maria 10.1 which could have changed something I suppose.

  your Maria version: 10.0.27-12.1
  mine, via this command:
mysql --version 
   Ver 15.1 Distrib 10.1.18-MariaDB, for debian-linux-gnu (x86_64) using
readline 5.2

Previously, our unixODBC versions were very close:

  yours  2.3.1-3.2
  mine   2.3.1-3

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103077] Can't connect to an existing data base with ODBC ( unixODBC or iODBC), ..."Due to an unexpected error, LibreOffice crashed. ..."

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103077

--- Comment #6 from Howard Johnson  ---
(In reply to robert from comment #5)
> (In reply to Howard Johnson from comment #3)
> > "Have connected to MariaDB ... In odbcinst.ini ... Driver =
> > /usr/lib64/libmyodbc5.so"
> > 
> > Thanks, but I think this is the MySQL driver you're pointing to above, not
> > the MariaDB driver (i.e. "lib my odbc..").
> > 
> > The MariaDB driver is named: libmaodbc.so  (lib ma odbc..).
> 
> There is no special libmaodbc available for my system (OepnSUSE 42.1 64bit
> rpm Linux). I use MyODBC-unixODBC instead. Compiled nothing here by myself.
> > 
> > ---
> > 
> > FYI, I tried to use the MySQL driver here but it crashed when I tried to
> > Test the connection.
> > 
> > Which database engine are you using, MariaDB or MySQL?
> 
> MariaDB 10.0.27-12.1
> UnixODBC 2.3.1-3.2
> 
> So there must be something special with your installed ODBC-configuration.

Thanks.  

I have tried to use the MySQL ODBC driver, but with it I could not get ODBC to
work at all, i.e. isql would not connect.  

To solve this I got the libmaodbc MariaDB ODBC connector here:

  https://mariadb.com/products/connectors-plugins
 click 

  https://mariadb.com/my_portal/download/connector-odbc
 Then I selected for Debian/Ubuntu, and:
   mariadb-connector-odbc-2.0.12-ga-linux-x86_64.tar.gz
 Inside is:
/lib
  libmaodbc.so

So I copied the libmaodbc.so file into
/usr/lib/x86_64-linux-gnu/odbc/libmaodbc.so, and set
Driver=/usr/lib/x86_64-linux-gnu/odbc/libmaodbc.so in odbcinst.ini.  Then isql
began to work.

Perhaps there is something special about this connector driver, but it is the
one from MariaDB, and I could not get ODBC to work with MariaDB until I
installed it.

I'm also working on trying to get some sort of debug log, but am stalled
because at the moment I don't know how to do this.  Will keep working on it. 
Thanks for your help.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103077] Can't connect to an existing data base with ODBC ( unixODBC or iODBC), ..."Due to an unexpected error, LibreOffice crashed. ..."

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103077

--- Comment #5 from rob...@familiegrosskopf.de ---
(In reply to Howard Johnson from comment #3)
> "Have connected to MariaDB ... In odbcinst.ini ... Driver =
> /usr/lib64/libmyodbc5.so"
> 
> Thanks, but I think this is the MySQL driver you're pointing to above, not
> the MariaDB driver (i.e. "lib my odbc..").
> 
> The MariaDB driver is named: libmaodbc.so  (lib ma odbc..).

There is no special libmaodbc available for my system (OepnSUSE 42.1 64bit rpm
Linux). I use MyODBC-unixODBC instead. Compiled nothing here by myself.
> 
> ---
> 
> FYI, I tried to use the MySQL driver here but it crashed when I tried to
> Test the connection.
> 
> Which database engine are you using, MariaDB or MySQL?

MariaDB 10.0.27-12.1
UnixODBC 2.3.1-3.2

So there must be something special with your installed ODBC-configuration.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103077] Can't connect to an existing data base with ODBC ( unixODBC or iODBC), ..."Due to an unexpected error, LibreOffice crashed. ..."

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103077

--- Comment #4 from Howard Johnson  ---
(In reply to Joel Madero from comment #1)
> debug log would be nice:
> https://wiki.documentfoundation.org/Development/How_to_debug

Ok, I read thru this a bit.  I might need some help getting this.  I tried to
start these but all of them just printed usage:

libreoffice5.2 --base --enable-debug 
libreoffice5.2 --base --enable-debug --enable-selective-debuginfo="sw/ xmloff/"
libreoffice5.2 --base --enable-dbgutil

And I tried this but got "No such file or directory"

./autogen.sh --enable-debug


Do I need to try and build LibreOffice from source?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103077] Can't connect to an existing data base with ODBC ( unixODBC or iODBC), ..."Due to an unexpected error, LibreOffice crashed. ..."

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103077

--- Comment #3 from Howard Johnson  ---
You wrote,

"Have connected to MariaDB ... In odbcinst.ini ... Driver =
/usr/lib64/libmyodbc5.so"

Thanks, but I think this is the MySQL driver you're pointing to above, not the
MariaDB driver (i.e. "lib my odbc..").

The MariaDB driver is named: libmaodbc.so  (lib ma odbc..).

---

FYI, I tried to use the MySQL driver here but it crashed when I tried to Test
the connection.

Which database engine are you using, MariaDB or MySQL?

(In reply to robert from comment #2)
> Have connected to MariaDB on OpenSUSE Leap 42.1 64bit rpm Linux.
> Installed the packages
> MyODBC
> unixODBC
> 
> In odbcinst.ini I set this:
> [MySQL]
> Description = ODBC Driver for MySQL
> Driver = /usr/lib64/libmyodbc5.so
> 
> In odbc.ini I set this
> [MySQL-test]
> Description = MySQL database test
> Driver = MySQL
> Server = localhost
> Database = libotest
> Port = 3306
> Socket =
> Option = 3
> Charset = UTF8
> 
> Only error: LO is looking for libodbc.so.1, but there is only a libodbc.so.2
> on my system. So I put a link from usr/lib64/libodbc.so.1 to
> usr/lib64/libodbc.so.2.
> 
> Have tried this, could input data - so I couldn't confirm this bug.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103077] Can't connect to an existing data base with ODBC ( unixODBC or iODBC), ..."Due to an unexpected error, LibreOffice crashed. ..."

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103077

rob...@familiegrosskopf.de changed:

   What|Removed |Added

 CC||rob...@familiegrosskopf.de

--- Comment #2 from rob...@familiegrosskopf.de ---
Have connected to MariaDB on OpenSUSE Leap 42.1 64bit rpm Linux.
Installed the packages
MyODBC
unixODBC

In odbcinst.ini I set this:
[MySQL]
Description = ODBC Driver for MySQL
Driver = /usr/lib64/libmyodbc5.so

In odbc.ini I set this
[MySQL-test]
Description = MySQL database test
Driver = MySQL
Server = localhost
Database = libotest
Port = 3306
Socket =
Option = 3
Charset = UTF8

Only error: LO is looking for libodbc.so.1, but there is only a libodbc.so.2 on
my system. So I put a link from usr/lib64/libodbc.so.1 to
usr/lib64/libodbc.so.2.

Have tried this, could input data - so I couldn't confirm this bug.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103077] Can't connect to an existing data base with ODBC ( unixODBC or iODBC), ..."Due to an unexpected error, LibreOffice crashed. ..."

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103077

Joel Madero  changed:

   What|Removed |Added

 CC||jmadero@gmail.com

--- Comment #1 from Joel Madero  ---
debug log would be nice:
https://wiki.documentfoundation.org/Development/How_to_debug

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs