chris2511 / xca

X Certificate and Key management
http://xca.hohnstaedt.de
Other
1.43k stars 197 forks source link

XCA 2.6 on macOS - mySQL ODBC issue #537

Open Henri0404 opened 3 months ago

Henri0404 commented 3 months ago

Hi,

receive this message, even the driver is installed, macOS 14.4.

Der folgende Fehler ist aufgetreten: [iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded, IM002 QODBC: Unable to connect

ls -l /usr/local/opt/libiodbc/lib/libiodbc.2.dylib

lrwxr-xr-x 1 root wheel 58 Mar 12 17:57 /usr/local/opt/libiodbc/lib/libiodbc.2.dylib -> /opt/homebrew/Cellar/libiodbc/3.52.16/lib/libiodbc.2.dylib

Thanks

Henri

chris2511 commented 3 months ago

See: https://mariadb.com/kb/en/creating-a-data-source-with-mariadb-connectorodbc/

You need at least mariadb-connector-odbc and a .odbc.ini like this in your home directory:

[Default]
Description = MariaDB Driver
Driver      = /opt/homebrew/lib/mariadb/libmaodbc.dylib
Database    = xca
Server      = mariadbsql.local

Afterwards a

isql -v Default <sqluser> <sqlpass>

worked. But: xca did not:

Error: The following error occurred:
?????????????????

and I have no clue why. Maybe it works for you.

jonathanmarsaud commented 5 days ago

Hi,

Also affected by this on macOS Sonoma and XCA 2.6, even with libodbc installed and properly linked according to the README.md.

anddyL commented 5 days ago

Hello, Same problem. I installed the version with brew install and "xca-2.6.0-Darwin.dmg" and could not connect with mariadb.