Hi, I own a OwnCloud Server with a MariaDB as Database: My db_connection_types.conf based on the Post here from 2017, which has a few errors inside (missing Tokens, wrong supported Versions, serviceClass with MySQL...) [mariadb]
displayName = MariaDB
serviceClass = com.splunk.dbx2.DefaultDBX2JDBC
jdbcUrlFormat = jdbc:mariadb://<host>:<port>/<database>
jdbcUrlSSLFormat = jdbc:mariadb://<host>:<port>/<database>?useSSL=true&requireSSL=true&verifyServerCertificate=false
jdbcDriverClass = org.mariadb.jdbc.Driver
supportedMajorVersion = 2
supportedMinorVersion = 7
port = 3306
testQuery = SELECT 1
ui_default_catalog = $database$ anyway. I chose the driver mariadb-java-client-2.7.1.jar because DBeaver downloaded this Version automatically and there I can select my data. With the db_connection_types.conf I can create a connection and receive the catalog. But in the SQL Explorer I receive every-time a "Error in 'dbxquery' command: External search command exited unexpectedly with non-zero error code 1." also for very basic querys (like "select * form `d040ddbe`.`5zdza_share`). Tested with same result on jre1.8.0_291 and jdk-11.0.11. Has someone a similar system running and could give me a few hints where I'm wrong? Kind Regards SierraX
... View more