I'm running Version 6.0.4 of the Dataiku DSS on a MacOS, but I'm having difficulties in setting-up MySQL connection in my localhost. I basically followed the instruction found here :
Each time I tried to connect to my local MySQL instance it threw me the following error:
This error is typically caused by an installation issue.
More information on this error in DSS documentation
Additional technical details
Thanks Alex, this would solve my current problem. Though now, it threw me another error, but couldn't figure out how to fix this:
The server time zone value 'WIB' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the 'serverTimezone' configuration property) to use a more specifc time zone value if you want to utilize time zone support., caused by: InvalidConnectionAttributeException: The server time zone value 'WIB' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the 'serverTimezone' configuration property) to use a more specifc time zone value if you want to utilize time zone support.
Where's the timezone configuration panel located? I know this must have been outside of the DSS areas but more on to the mysql insted.
Tried a combination of both with or without the quotes, but still no luck.
Btw, by any chance, you're "the" (tagged) Alex on the DSS sample tutorial files?
The error message here is passed from MySQL to the Dataiku interface. This indicates that MySQL does not like this format. The allowed values for this parameter may depend on the version of MySQL you have installed. This page should help: https://dev.mysql.com/doc/refman/8.0/en/time-zone-support.html
Can you try with the value 'UTC' and confirm that it accepts it?
Hope it helps,
PS: We are 19 Alex's at Dataiku right now. I know... Hence the tagged Alex on the tutorial files is one of my colleagues 🙂
The keyword "DATA_DIR" in https://doc.dataiku.com/dss/latest/installation/jdbc.html depends on where you installed Dataiku DSS.
In the case of the macOS .dmg installer, that DATA_DIR is
Alternatively, you can find the DATA_DIR from our user interface, in Administration > Maintenance > System info.
If you want to understand more about what is the Dataiku DSS data directory (a.k.a. the DATA_DIR) I invite you to give this a read: https://doc.dataiku.com/dss/latest/operations/datadir.html
Hope it helps,