10  Setup

The first time, need to install all this and REBOOT the computer.

Maybe install this first? sudo apt install mysql-connector-odbc unixodbc

10.0.1 Download drivers and plugins

VERSION 8.4

1. From https://dev.mysql.com/downloads/mysql/

• Select Version: 8.4.X (needs to be the same of DB_credentials$value$Driver)
• Select Operating System: Ubuntu Linux
• Select OS Version: Ubuntu Linux 24.04 (x86, 64-bit)
• Download 1 file:
  • mysql-community-client-plugins_… # e.g. mysql-community-client-plugins_8.1.0-1ubuntu22.04_amd64.deb

2. From: https://dev.mysql.com/downloads/connector/odbc/

• Select Version: 8.4.X (needs to be the same of DB_credentials$value$Driver)
• Select Operating System: Ubuntu Linux
• Select OS Version: Ubuntu Linux 24.04 (x86, 64-bit)
• Download 4 files:
  • mysql-connector-odbc_…
  • mysql-connector-odbc-dbgsym_…
  • mysql-connector-odbc-setup_…
  • mysql-connector-odbc-setup-dbgsym_…

10.0.2 Copy the 5 files to a folder

For example to ~/Downloads/drivers/: - mysql-community-client-plugins_8.0.33-1ubuntu22.04_amd64.deb - mysql-connector-odbc_8.0.33-1ubuntu22.04_amd64.deb - mysql-connector-odbc-dbgsym_8.0.33-1ubuntu22.04_amd64.deb - mysql-connector-odbc-setup_8.0.33-1ubuntu22.04_amd64.deb - mysql-connector-odbc-setup-dbgsym_8.0.33-1ubuntu22.04_amd64.deb

10.0.3 Install drivers:

Para Ubuntu 24.04:

sudo dpkg -i mysql-community-client-plugins_8.4.10-1ubuntu24.04_amd64.deb sudo dpkg -i mysql-connector-odbc_8.4.0-1ubuntu24.04_amd64.deb sudo dpkg -i ~/Downloads/drivers/mysql-*

Remove: sudo apt remove mysql-community-client-plugins mysql-connector-odbc mysql-connector-odbc-dbgsym mysql-connector-odbc-setup mysql-connector-odbc-setup-dbgsym

10.0.4 Test

List available drivers

odbc::odbcListDrivers()$name |> unique()
DRIVER_temp = odbc::odbcListDrivers()$name |> unique() # Store to use latter
DRIVER = DRIVER_temp[3]

# Server credentials
rstudioapi::navigateToFile(".vault/.credentials")
jsPsychAdmin::clean_up_dev_protocol(protocol_id = 999) # Will ask for server password