topic Invalid port error when trying to read from PlanetScale MySQL databse in Data Engineering

Invalid port error when trying to read from PlanetScale MySQL databse

190809 — Fri, 18 Nov 2022 12:51:47 GMT

Using the code below I am attempting to connect to a PlanetScale MySQL database. I get the following error: java.sql.SQLException: error parsing url : Incorrect port value. However the port is the default 3306, and I have used the correct url based on the PlanetScale documentation, and other members of my team can connect to it with this url using other platforms. Is Databricks doing something else here that I can't see?

remote_table = (spark.read

.format("jdbc")\

.option("driver", driver)\

.option("url", url)\

.option("dbtable", table)\

.option("user", username)\

.option("password", passwd)\

.option("ssl", True) \

.option("sslmode", "require" ) \

.option("sslcert", "dbfs:/mnt/folder/admin/client-cert.pem")\

.option("sslkey", "dbfs:/mnt/folder/admin/client-key.pem" )\

.load()

)

Re: Invalid port error when trying to read from PlanetScale MySQL databse

Pat — Fri, 18 Nov 2022 13:15:26 GMT

HI @Rachel Cunningham ,

maybe you can share your `driver` and `url` value (masked)?

Re: Invalid port error when trying to read from PlanetScale MySQL databse

190809 — Fri, 18 Nov 2022 13:18:56 GMT

driver = "org.mariadb.jdbc.Driver"

url = f"jdbc:mysql://{user}:{password}@{database_host}/{database_name}?sslaccept=strict"

The PlanetScale url does not require the host value in the url string and is set to 3306 as default. I have tried adding it and am met with an invalid url error.