http://coldfusion.com logo
Join Slack
Powered by
Having some trouble getting a Lucee commandbox app...
# box-products
p
Having some trouble getting a Lucee commandbox application to work with MySQL 8.0.28, hosted on the same server. Web pages and Datasource validation in the administrator are showing me "Public Key Retrieval is not allowed" 
box migrate up
is throwing the following:
Copy code
ERROR (5.4.2+00453)

The OSGi Bundle with name [com.mysql.cj] is not available in version [8.0.28] locally (/home/user/.CommandBox/engine/cfml/cli/lucee-server/bundles) or from the update provider (<http://release.lucee.org>), the following versions are available locally [8.0.15, 8.0.19, 8.0.15].
  caused by: org.osgi.framework.BundleException
I've put the 
mysql-connector-java-8.0.28.jar
in 
~/.CommandBox/lib
I'll put my box.json and .cfonfig.json in a thread Can anyone help with either of these errors? (or hopefully, both in one go)
cfconfig datasource object:
Copy code
"allowAlter":true,
            "allowCreate":true,
            "allowDelete":true,
            "allowDrop":true,
            "allowGrant":true,
            "allowInsert":true,
            "allowRevoke":true,
            "allowSelect":true,
            "allowUpdate":true,
            "alwaysSetTimeout":"true",
            "blob":"true",
            "class":"com.mysql.cj.jdbc.Driver",
            "clob":"true",
            "connectionLimit":"100",
            "connectionTimeout":"-1",
            "custom":"useUnicode=true&characterEncoding=UTF8&verifyServerCertificate=false&serverTimezone=Etc%2FUTC&useSSL=false&maxReconnects=3&useLegacyDatetimeCode=true",
            "database":"cf",
            "dbdriver":"MySQL",
            "dsn":"jdbc:mysql://${MYSQL_HOST}:${MYSQL_PORT}/cf",
            "host":"${MYSQL_HOST}",
            "metaCacheTimeout":"60000",
            "password":"${MYSQL_PASSWORD}",
            "port":"${MYSQL_PORT:3306}",
            "storage":"false",
            "username":"${MYSQL_USER}",
            "validate":"false"
cfmigrations from box.json
Copy code
"cfmigrations":{
        "connectionInfo":{
            "bundleName": "com.mysql.cj",
            "bundleVersion": "8.0.28",
            "class":"com.mysql.cj.jdbc.Driver",
            "connectionString":"jdbc:mysql://${MYSQL_HOST}:${MYSQL_PORT}/cf?useUnicode=true&characterEncoding=UTF-8&useLegacyDatetimeCode=true&useSSL=false",
            "password":"${MYSQL_PASSWORD}",
            "username":"${MYSQL_USER}"
        },
        "defaultGrammar":"AutoDiscover@qb",
        "migrationsDirectory":"resources/database/migrations",
        "schema":"cf"
    },
I needed to drop the mysql-connector-java-8.0.28.jar into the CommandBox/engine/cfml/lucee-server/bundles folder as well as Commandbox/lib, that fixed the OSGI bundle error
👍🏼 1
3 Views
Open in Slack
PreviousNext
Powered by