https://bugs.documentfoundation.org/show_bug.cgi?id=103077
Bug ID: 103077
Summary: Can't connect to an existing data base with ODBC
(unixODBC or iODBC), ..."Due to an unexpected error,
LibreOffice crashed. ..."
Product: LibreOffice
Version: 5.2.2.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Description:
I can't seem to get LibreOffice Base to open a database with ODBC without
crashing.
I have unixODBC and iODBC installed and working. I have 2 ODBC drivers (one for
MariaDB and one for MDBTools). I have 4 data sources (DSN's Data Source Names)
that I'm testing and they all work when tested with the isql command.
I'm using:
* Debian 8.6, Jessie-Stable
* MariaDB 10.1 (the latest version)
* unixODBC v. 2.3.1-3 (the latest version)
----------------------------------------------------------
My /etc/odbcinst.ini is as follows (and there is no ~/.odbcinst.ini):
[mariadb]
Description = Maria DB
Driver = /usr/lib/x86_64-linux-gnu/odbc/libmaodbc.so
Setup = /usr/lib/x86_64-linux-gnu/odbc/libodbcmyS.so
UsageCount = 1
[mdbtools]
Description = MDBTools Driver
Driver = /usr/lib/x86_64-linux-gnu/odbc/libmdbodbc.so
Setup = /usr/lib/x86_64-linux-gnu/odbc/libmdbodbc.so
UsageCount = 1
###############################################################
My /etc/odbc.ini is as follows (and there is no ~/.odbc.ini):
#=== For unixODBC =====================================
[mariadb-bigbase]
Description = Bigbase - tests ok with isql: show tables
Driver = mariadb
Server = localhost
Port = 3306
Socket = /var/run/mysqld/mysqld.sock
Option =
Stmt =
User = root
Password = test
Database = bigbase
[mdbtools-db]
Description = test ok with isql: select * from m -- fails on show tables
Driver = mdbtools
Database = /home/howard/Documents/db.mdb
#=== For iODBC =========================================
[ODBC Data Sources]
i-mariadb-bigbase = Mariadb
i-mdbtools-db = MDB Tools
[i-mariadb-bigbase]
Driver = /usr/lib/x86_64-linux-gnu/odbc/libmaodbc.so
Description = Bigbase - tests ok with isql: show tables
Server = localhost
Port = 3306
Socket = /var/run/mysqld/mysqld.sock
Option =
Stmt =
User = root
Password = test
Database = bigbase
[i-mdbtools-db]
Description = test ok with isql: select * from m
Driver = /usr/lib/x86_64-linux-gnu/odbc/libmdbodbc.so
Database = /home/howard/Documents/db.mdb
###############################################################
An example of confirming that the ODBC driver is working with isql is as
follows:
#> isql mariadb-bigbase
SQL> show tables
+--------------------------------------------------------------------------+
| Tables_in_bigbase |
+--------------------------------------------------------------------------+
| locations-all-old0 |
| us-zip-codes |
+--------------------------------------------------------------------------+
SQLRowCount returns 2
2 rows fetched
Steps to Reproduce:
Open LibreOffice and select: File | New | Database --> opens Database Wizard
>From here I have tried two methods of connecting as follows:
attempted method A:
Wizard step 1) * Connect to an existing database: MySQL
Wizard step 2) * Connect using ODBC (Open Database Connectivity)
Wizard step 3) Name of the ODBC data source on your system: mariadb-bigbase
Wizard step 4) Enter user name, click Test Connection and enter password gives:
The connection was established successfully.
Wizard step 5) Select:
* Yes, register the database for me.
X Open the database for editing.
Then click finish and save 'New Database' in ~/Documents.
Result: "Due to an unexpected error, LibreOffice crashed. ...
and
attempted method B:
Wizard step 1) Connect to an existing database: ODBC
Wizard step 2) Name of the ODBC data source on your system: mariadb-bigbase
Wizard step 3) Enter user name, click Test Connection and enter password gives:
The connection was established successfully.
Wizard step 4) Select:
* Yes, register the database for me.
X Open the database for editing.
Then click finish and save 'New Database1' in ~/Documents.
Result: "Due to an unexpected error, LibreOffice crashed. ...
Actual Results:
Due to an unexpected error, LibreOffice crashed. ...
Expected Results:
(I could open the connected data base).
Reproducible: Always
User Profile Reset: No
Additional Info:
Cinnamon GUI 2.2.16
Linux Kernel 3.16.0-4-amd64
Memory 7.8 GiB
Graphics Card AMD RV710/M92
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101
Firefox/45.0
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
