Casper Suite 9.93: Driver org.mariadb.jdbc.Driver claims to not accept JDBC URL jdbc:://:/

in ,

With the release of Casper Suite 9.93, JAMF Software changed the MySQL connector from MySQL to MariaDB. This leads to the following error:

Driver org.mariadb.jdbc.Driver claims to not accept JDBC URL jdbc:://:/

This will happen if you push ROOT.war and DataBase.xml as usual. Hopefully you deploy on a test instance first!

DB Configuration resides in /usr/local/jss/tomcat/webapps/ROOT/WEB-INF/xml/DataBase.xml

Old DataBase.xml is:

<?xml version="1.0" encoding="UTF-8"?>
<DataBase>
    <DataBaseType>mysql</DataBaseType>
    <DataBaseDriver>com.mysql.jdbc.Driver</DataBaseDriver>
    <ServerName>jamf-mysql1.sdfsfsaa111.eu-west-1.rds.amazonaws.com</ServerName>
    <ServerPort>3306</ServerPort>
    <DataBaseName>jamfsoftware</DataBaseName>
    <DataBaseUser>jamfsoftware</DataBaseUser>
    <DataBasePassword>Pa$$w0rd</DataBasePassword>
    <MinPoolSize>5</MinPoolSize>
    <MaxPoolSize>90</MaxPoolSize>
    <MaxIdleTimeExcessConnectionsInMinutes>1</MaxIdleTimeExcessConnectionsInMinutes>
    <MaxConnectionAgeInMinutes>5</MaxConnectionAgeInMinutes>
    <NumHelperThreads>3</NumHelperThreads>
    <InStatementBatchSize>1000</InStatementBatchSize>
    <jdbcParameters>?characterEncoding=utf8&amp;useUnicode=true&amp;jdbcCompliantTruncation=false</jdbcParameter
s>
</DataBase>

Make sure you use the following instead:

<?xml version="1.0" encoding="ISO-8859-1"?>
<DataBase>
    <DataBaseType>mysql</DataBaseType>
    <DataBaseDriver>org.mariadb.jdbc.Driver</DataBaseDriver>
    <ServerName>jamf-mysql1.sdfsfsaa111.eu-west-1.rds.amazonaws.com</ServerName>
    <ServerPort>3306</ServerPort>
    <DataBaseName>jamfsoftware</DataBaseName>
    <DataBaseUser>jamfsoftware</DataBaseUser>
    <DataBasePassword>Pa$$w0rd</DataBasePassword>
    <MinPoolSize>5</MinPoolSize>
    <MaxPoolSize>90</MaxPoolSize>
    <MaxIdleTimeExcessConnectionsInMinutes>1</MaxIdleTimeExcessConnectionsInMinutes>
    <MaxConnectionAgeInMinutes>5</MaxConnectionAgeInMinutes>
    <NumHelperThreads>3</NumHelperThreads>
    <InStatementBatchSize>1000</InStatementBatchSize>
    <jdbcParameters>?characterEncoding=utf8&amp;useUnicode=true&amp;jdbcCompliantTruncation=false</jdbcParameter
s>
</DataBase>