Details

    • Similar Issues:

      Description

      Currently MySql is supported, but not the MariaDB fork.

      Problem Description

      For using Jenkins in comercial enviroment it would be creat to support MariaDB too.

      It is fully compatible with MySql 5.7. Using MariaDB-Server results in the following Warning (but works):

      Non validated MySQL version 5.5.5-10.2.20-MariaDB. MySQL Server version 5.7+ or Amazon Aurora MySQL 5.6+ is required
      

      Discovering introspecting the JDBC driver metadata that it's MariaDB

      docker run  -e MYSQL_ROOT_PASSWORD=mypass -e MYSQL_DATABASE=jenkins -e MYSQL_USER=jenkins -e MYSQL_PASSWORD=jenkins -p 3307:3306 -d mariadb/server:latest
      
      Property Name Value
      JDBC Driver CLASSNAME com.mysql.jdbc.Driver
      JDBC Driver CLASSPATH No files specified in 'Extra ClassPath' tab for driver
      getURL jdbc:mysql://localhost:3307/jenkins
      isReadOnly false
      getRowIdLifetime ROWID_UNSUPPORTED
      supportsStoredFunctionsUsingCallSyntax true
      autoCommitFailureClosesAllResultSets false
      getClientInfoProperties  
      generatedKeyAlwaysReturned true
      getMaxLogicalLobSize 0
      supportsRefCursors false
      getResultSetHoldability 1
      getUserName jenkins@172.17.0.1
      supportsCatalogsInTableDefinitions true
      supportsSchemasInTableDefinitions false
      getDriverName MySQL Connector/J
      getCatalogSeparator .
      storesMixedCaseIdentifiers true
      storesUpperCaseIdentifiers false
      getDatabaseProductName MySQL
      getDatabaseProductVersion 5.5.5-10.3.11-MariaDB-1:10.3.11+maria~bionic
      getDatabaseMajorVersion 5
      getIdentifierQuoteString `
      supportsSchemasInDataManipulation false
      supportsStoredProcedures true
      supportsSavepoints true
      getCatalogTerm database
      getSchemaTerm  
      getProcedureTerm PROCEDURE
      supportsCatalogsInDataManipulation true
      supportsCatalogsInProcedureCalls true
      supportsMultipleResultSets true
      getJDBCMajorVersion 4
      getJDBCMinorVersion 2
      supportsNamedParameters false
      supportsMultipleOpenResults true
      supportsGetGeneratedKeys true
      getDatabaseMinorVersion 5
      getSQLStateType 2
      locatorsUpdateCopy true
      supportsStatementPooling false
      allProceduresAreCallable false
      allTablesAreSelectable false
      nullsAreSortedHigh false
      nullsAreSortedLow true
      nullsAreSortedAtStart false
      nullsAreSortedAtEnd false
      getDriverVersion mysql-connector-java-8.0.13 (Revision: 66459e9d39c8fd09767992bc592acd2053279be6)
      getDriverMajorVersion 8
      getDriverMinorVersion 0
      usesLocalFiles false
      usesLocalFilePerTable false
      supportsMixedCaseIdentifiers true
      storesLowerCaseIdentifiers false
      supportsMixedCaseQuotedIdentifiers true
      storesUpperCaseQuotedIdentifiers true
      storesLowerCaseQuotedIdentifiers false
      storesMixedCaseQuotedIdentifiers true
      getSearchStringEscape \
      getExtraNameCharacters #@
      supportsAlterTableWithAddColumn true
      supportsAlterTableWithDropColumn true
      supportsColumnAliasing true
      nullPlusNonNullIsNull true
      supportsConvert false
      supportsTableCorrelationNames true
      supportsDifferentTableCorrelationNames true
      supportsExpressionsInOrderBy true
      supportsOrderByUnrelated false
      supportsGroupBy true
      supportsGroupByUnrelated true
      supportsGroupByBeyondSelect true
      supportsLikeEscapeClause true
      supportsMultipleTransactions true
      supportsNonNullableColumns true
      supportsMinimumSQLGrammar true
      supportsCoreSQLGrammar true
      supportsExtendedSQLGrammar false
      supportsANSI92EntryLevelSQL true
      supportsANSI92IntermediateSQL false
      supportsANSI92FullSQL false
      supportsIntegrityEnhancementFacility false
      supportsOuterJoins true
      supportsFullOuterJoins false
      supportsLimitedOuterJoins true
      isCatalogAtStart true
      supportsSchemasInProcedureCalls false
      supportsSchemasInIndexDefinitions false
      supportsSchemasInPrivilegeDefinitions false
      supportsCatalogsInIndexDefinitions true
      supportsCatalogsInPrivilegeDefinitions true
      supportsPositionedDelete false
      supportsPositionedUpdate false
      supportsSelectForUpdate true
      supportsSubqueriesInComparisons true
      supportsSubqueriesInExists true
      supportsSubqueriesInIns true
      supportsSubqueriesInQuantifieds true
      supportsCorrelatedSubqueries true
      supportsUnion true
      supportsUnionAll true
      supportsOpenCursorsAcrossCommit false
      supportsOpenCursorsAcrossRollback false
      supportsOpenStatementsAcrossCommit false
      supportsOpenStatementsAcrossRollback false
      getMaxBinaryLiteralLength 16777208
      getMaxCharLiteralLength 16777208
      getMaxColumnNameLength 64
      getMaxColumnsInGroupBy 64
      getMaxColumnsInIndex 16
      getMaxColumnsInOrderBy 64
      getMaxColumnsInSelect 256
      getMaxColumnsInTable 512
      getMaxConnections 0
      getMaxCursorNameLength 64
      getMaxIndexLength 256
      getMaxSchemaNameLength 0
      getMaxProcedureNameLength 0
      getMaxCatalogNameLength 32
      getMaxRowSize 2147483639
      doesMaxRowSizeIncludeBlobs true
      getMaxStatementLength 65531
      getMaxStatements 0
      getMaxTableNameLength 64
      getMaxTablesInSelect 256
      getMaxUserNameLength 16
      getDefaultTransactionIsolation TRANSACTION_READ_COMMITTED
      supportsTransactions true
      supportsDataDefinitionAndDataManipulationTransactions false
      supportsDataManipulationTransactionsOnly false
      dataDefinitionCausesTransactionCommit true
      dataDefinitionIgnoredInTransactions false
      supportsBatchUpdates true

      Discovering running SQL queries that it's MariaDB

      MariaDB Docker image

      docker run -e MYSQL_ROOT_PASSWORD=mypass -e MYSQL_DATABASE=jenkins -e MYSQL_USER=jenkins -e MYSQL_PASSWORD=jenkins -p 3307:3306 -d mariadb/server:latest

      SELECT VERSION();
      
      10.3.11-MariaDB-1:10.3.11+maria~bionic
      
      

      MariaDB Centos

      official MariaDB (Centos-Repo from https://downloads.mariadb.org/mariadb/repositories/):

      SELECT VERSION();
      
      10.3.11-MariaDB
       

        Attachments

          Activity

          Hide
          rpaasche Robert Paasche added a comment -

          Select Version from a official MariaDB (Centos-Repo from https://downloads.mariadb.org/mariadb/repositories/):

          SELECT VERSION();
          
          10.3.11-MariaDB
          
          Show
          rpaasche Robert Paasche added a comment - Select Version from a official MariaDB (Centos-Repo from https://downloads.mariadb.org/mariadb/repositories/): SELECT VERSION(); 10.3.11-MariaDB
          Hide
          cleclerc Cyrille Le Clerc added a comment -

          https://github.com/jenkinsci/pipeline-maven-plugin/pull/198

          If MariaDB is detected, an info message "MariaDB version x.y.z detected. Please ensure that your MariaDB version is at least version 10.2+" is displayed

          Show
          cleclerc Cyrille Le Clerc added a comment - https://github.com/jenkinsci/pipeline-maven-plugin/pull/198 If MariaDB is detected, an info message "MariaDB version x.y.z detected. Please ensure that your MariaDB version is at least version 10.2+" is displayed
          Hide
          cleclerc Cyrille Le Clerc added a comment -

          3.6.6-beta-4 in progress with the fix

          Show
          cleclerc Cyrille Le Clerc added a comment - 3.6.6-beta-4 in progress with the fix
          Hide
          cleclerc Cyrille Le Clerc added a comment -

          Robert Paasche can you please test pipeline-maven-3.6.6-beta-4 ? The "Validate JDBC Connection" button will return

          MariaDB version x.y.z detected. Please ensure that your MariaDB version is at least version 10.2+
          

          https://github.com/jenkinsci/pipeline-maven-plugin/releases/tag/pipeline-maven-3.6.6-beta-4

          Show
          cleclerc Cyrille Le Clerc added a comment - Robert Paasche can you please test pipeline-maven-3.6.6-beta-4 ? The "Validate JDBC Connection" button will return MariaDB version x.y.z detected. Please ensure that your MariaDB version is at least version 10.2+ https://github.com/jenkinsci/pipeline-maven-plugin/releases/tag/pipeline-maven-3.6.6-beta-4
          Hide
          rpaasche Robert Paasche added a comment -

          Uhh It's already released .

          It works for me:

          MariaDB version 10.3.11 detected. Please ensure that your MariaDB version is at least version 10.2+
          
          Show
          rpaasche Robert Paasche added a comment - Uhh It's already released . It works for me: MariaDB version 10.3.11 detected. Please ensure that your MariaDB version is at least version 10.2+
          Hide
          cleclerc Cyrille Le Clerc added a comment -

          Shipped in 3.6.6

          Show
          cleclerc Cyrille Le Clerc added a comment - Shipped in 3.6.6

            People

            • Assignee:
              cleclerc Cyrille Le Clerc
              Reporter:
              rpaasche Robert Paasche
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: