Problem with MySQL driver on Ubuntu server

vordan

Hi, I am having problem installing the MySQL driver. I get the following error:
The MySQL Connector JAR is missing from your deployment and if you would like to use MySQL, you must manually install the MySQL Connector JAR.

The OS is Ubuntu 20.04.5 LTS.
MySQL server is version 8.0.32-0ubuntu0.20.04.2
I've downloaded the driver from the Oracle site - mysql-connector-j-8.0.32.deb and installed it with dpkg.
I've even copied the driver .jar file to the /fusionauth/fusionauth-app/lib folder.
Always the same error.

I am this close to giving up. Please, help

dan

@vordan Sorry to hear this! We have other folks running with MySQL, so I'm not sure what your particular issue is.

Can you echo $CLASSPATH in start.sh to ensure the mysql library is being picked up?

Here's an excerpt of start.sh:

# Start it up
echo "Starting fusionauth-app..."
echo "  --> Logging to ${LOG_DIR}/fusionauth-app.log"
cd "${APP_DIR}"

CLASSPATH=""
for file in lib/*; do
  CLASSPATH=${CLASSPATH}:${file}
done
CLASSPATH=${CLASSPATH:1}

if [[ ${1} == "--debug" ]]; then

Add echo $CLASSPATH on a new line after CLASSPATH=${CLASSPATH:1}. Do you see your mysql lib file?

truearrowsoftware

@dan I know this is old thread and OP didn't reply. But I have same issue and I did see mysql Connector when I echo $CLASSPATH in script .. I am getting that It cannot access database. I am using Connector 8.0.33 but my mysql is 5.7 is that a problem? Because I check authentication setting to mysql and using PHP Script I can connect fine but not from fusionAuth 1.48