Setting a ODBC connection to MySQL

[SCraveiro]

Hello,

I'm trying to set up an ODBC connection to a MySQL database but i'm always getting the same error.

I've already tried with the connection string below
DRIVER=MySQL;SERVER=127.0.0.1;PORT=3306;DATABASE=FuxaDb;SSLMODE=DISABLED

and with
DRIVER=MySQL;SERVER=127.0.0.1;PORT=3306;DATABASE=FuxaDb;SSLMODE=ENABLED

I've already try with ODBC connection and have tested the ODBC connection with
isql -v FuxaDatabase dbaps ***
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| echo [string] |
| quit |
| |
+---------------------------------------+
I'm running this on a Raspberry PI 5 8GB with FUXA V1.2.7 and NodeJS V18. I can't run with docker.

I search for this kind of problem on discution but didn't menage to make it work.

Thank you!

[MatthewReed303]

@SCraveiro I have done a PR that improves the ODBC a lot and also adds a proper browser and query builder etc you can give it ago #2063

[SCraveiro]

@MatthewReed303 thank you for your reply.
I'm new to GitHub. For using your PR I've need to download the latest version of FUXA and reinstall it again? Or have to do anything else?

[MatthewReed303]

@SCraveiro I have just done an electron build here with the PR Electron Build give it a go.

Please make sure you have the ODBC drivers installed correctly. You can just run this script on your RPI https://github.com/frangoteam/FUXA/blob/master/odbc/install_odbc_drivers.sh

Installing ODBC Drivers

The available drivers that can be used and there defined name can be found here: ODBC Driver ini

If you install via NPM on a Debian based Linux system you can try manually install ODBC drivers for your system with the following steps:

1: sudo apt-get update && sudo apt-get install -y unixodbc unixodbc-dev

2: copy both files from here onto your system ODBC Driver Files

3: Go to the directory of the downloaded files and make script executable and install and most ini file

sudo chmod +x install_odbc_drivers.sh
sudo ./install_odbc_drivers.sh
sudo cp odbcinst.ini /etc/odbcinst.ini

4: Test the installed drivers and you can connect using unixODBC change the connection string to suit your DB

sudo myodbc-installer -s -a -c2 -n "test" -t "DRIVER=MySQL;SERVER=YourIP;PORT=3306;DATABASE=testDB;UID=User;PWD=MyPass"
sudo isql test

[RobertMiller-KR2]

I am having the same issue with mySQL. The device gives me a green indicator but It cannot get the tables. I am running the docker container version FuxaPRO1.2.9 on a windows machine, I have updated the ODBC drivers. I can monitor in mysql workbench that it is connecting to the DB In fact its showing the mysql-connector-odbc has about 11 connections and the myodbc-installer test passes

[MatthewReed303]

@RobertMiller-KR2 that error is misleading, try to do a query in a script and see if it works

I will follow up the PR and see if we can get the fixes in the main branch

[RobertMiller-KR2]

@MatthewReed303 Ok The insert seems to work regardless of the "Error".