Convert Online

SQLines SQL Converter

Overview
Command Line
Configuration File
Release Notes

SQLines Data

Overview
Command Line
Configuration File
Connection Strings
Data Validation
Release Notes

Migration to MariaDB

IBM DB2 to MariaDB
Informix to MariaDB
MySQL to MariaDB
Oracle to MariaDB
PostgreSQL to MariaDB
SQL Server to MariaDB
Sybase ASE to MariaDB
Sybase ASA to MariaDB

Migration to MySQL

IBM DB2 to MySQL
Informix to MySQL
MariaDB to MySQL
Oracle to MySQL
SQL Server to MySQL
Sybase ASE to MySQL
Sybase ASA to MySQL
PostgreSQL to MySQL

Migration to PostgreSQL

IBM DB2 to PostgreSQL
Informix to PostgreSQL
MySQL to PostgreSQL
Oracle to PostgreSQL
SQL Server to PostgreSQL
Sybase ASE to PostgreSQL
Sybase ASA to PostgreSQL

Migration to SQL Server

IBM DB2 to SQL Server
Informix to SQL Server
MySQL to SQL Server
Oracle to SQL Server
PostgreSQL to SQL Server
Sybase ASE to SQL Server
Sybase ASA to SQL Server
Sybase ADS to SQL Server

Migration to Oracle

IBM DB2 to Oracle
Informix to Oracle
PostgreSQL to Oracle
Sybase ASE to Oracle
Sybase ASA to Oracle
SQL Server to Oracle
MySQL to Oracle
MariaDB to Oracle

SQL in Applications

Java


Differences

This shows you the differences between two versions of the page.

sqldata_mariadb_connection [December 04, 2017 12:43 pm]
sqlines 		sqldata_mariadb_connection [March 25, 2025 1:51 pm] (current)
sqlines
Line 11: Line 11:
    * //C:\Program Files\MariaDB\MariaDB Connector C 64-bit\lib\libmariadb.dll//     * //C:\Program Files\MariaDB\MariaDB Connector C 64-bit\lib\libmariadb.dll//
-If the MariaDB client is not available, go to MariaDB Download page http://www.mariadb.com and download //MariaDB Connector C//. +If the MariaDB client is not available, go to MariaDB Download page https://mariadb.com/downloads/connectors/ and download //MariaDB Connector C//.  
 + 
 +===== Setup SSL Connection ===== 
 + 
 +When connecting to a MariaDB database you can get the following error: //"SSL connection is required. Please specify SSL options and retry"// 
 + 
 +Use SSL connection options in //sqldata.cfg// or command line: 
 + 
 +  * -mysql_ssl_mode - SSL connection mode (--ssl-mode MySQL option), possible values are DISABLED, PREFERRED (default), REQUIRED, VERIFY_CA and VERIFY_IDENTITY 
 +  * -mysql_ssl_key - SSL private key file (--ssl-key MySQL option), the absolute path to the file 
 +  * -mysql_ssl_cert - SSL certificate file (--ssl-cert MySQL option), the absolute path to the file in PEM format 
 +  * -mysql_ssl_ca - SSL CA file (--ssl-ca option of MySQL CLI), the absolute path to the file in PEM format
===== Troubleshooting Connection on Windows ===== ===== Troubleshooting Connection on Windows =====
Line 30: Line 41:
Instead of the system PATH variable, you can also specify the path to MariaDB library using the  //-mariadb_lib// option of SQLines Data  configuration file //sqldata.cfg//. For example, you can set //-mariadb_lib=C:\Program Files\MariaDB\MariaDB Connector C 64-bit\lib\libmariadb.dll// Instead of the system PATH variable, you can also specify the path to MariaDB library using the  //-mariadb_lib// option of SQLines Data  configuration file //sqldata.cfg//. For example, you can set //-mariadb_lib=C:\Program Files\MariaDB\MariaDB Connector C 64-bit\lib\libmariadb.dll//
 +
 +===== Troubleshooting Connection =====
 +
 +  * **Error: TLS/SSL error: SSL is required, but the server does not support it**
 +
 +Set the MARIADB_TLS_DISABLE_PEER_VERIFICATION environment variable to disable SSL on the client.
 +
 +| export MARIADB_TLS_DISABLE_PEER_VERIFICATION=1 |
Contact us at [[support@sqlines.com]] if you still have any connection problems. Contact us at [[support@sqlines.com]] if you still have any connection problems.