Mac OS - MySQL Connection in Dataiku

Solved!
gerryleonugroho
Level 3
Mac OS - MySQL Connection in Dataiku

Hi everyone,

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 :

https://doc.dataiku.com/dss/latest/installation/jdbc.html

https://doc.dataiku.com/dss/latest/connecting/sql/mysql.html

 

Each time I tried to connect to my local MySQL instance it threw me the following error:

 

 

0 Kudos
5 Solutions
Alex_Combessie
Dataiker Alumni

Hi,

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

/Users/<your_user_name>/Library/DataScienceStudio/dss_home

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,

Alex

View solution in original post

0 Kudos
Alex_Combessie
Dataiker Alumni

Hi,

You can set that parameter from the Dataiku connection UI, as shown below:

Screenshot 2020-03-12 at 11.16.23.pngHope it helps,

Alex

View solution in original post

0 Kudos
Alex_Combessie
Dataiker Alumni

Hi,

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,

Alex

 

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 ๐Ÿ™‚

View solution in original post

0 Kudos
gerryleonugroho
Level 3
Author

Hi Alex,

They worked like magic ๐Ÿ˜Š

gerryleonugroho_0-1584019958287.png

 

Thanks for all the help @Alex_Combessie, really appreciate all the walkthrough. And please stays safe during the pandemic situation. ๐Ÿ™‚

 

Cheers,

 

View solution in original post

Clรฉment_Stenac

Hi,

WIB is indeed not a "time zone" but an "offset to UTC", which may not be valid always. That's a fairly tricky distinction that is mostly due to daylight savings.

For example, Paris is UTC+1 in winter, UTC+2 in summer. The "time zone" called "Europe/Paris" will always be at the correct time of Paris. However the timezone "CET" will only be at the correct time during winter while "CEST" will only be correct during summer. Hence, only "Europe/Paris" is a valid timezone.

In your case, you want to set it to, I guess, "Asia/Jakarta" . While this should ideally be done in MySQL, you should be able to, in the MySQL Connection settings of DSS, add a "Custom JDBC property" with key "serverTimezone" and value "Asia/Jakarta"

View solution in original post

12 Replies
Alex_Combessie
Dataiker Alumni

Hi,

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

/Users/<your_user_name>/Library/DataScienceStudio/dss_home

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,

Alex

0 Kudos
gerryleonugroho
Level 3
Author

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.

 

Thanks,

0 Kudos
Alex_Combessie
Dataiker Alumni

Hi,

You can set that parameter from the Dataiku connection UI, as shown below:

Screenshot 2020-03-12 at 11.16.23.pngHope it helps,

Alex

0 Kudos
gerryleonugroho
Level 3
Author

Hi @Alex_Combessie,

 

Thanks for the quick response, but still getting an error, as attached.

 

gerryleonugroho_0-1584008603436.png

 

0 Kudos
Alex_Combessie
Dataiker Alumni

Instead of using "WIB" timezone, could you try with "+07:00"? (see https://24timezones.com/time-zone/wib#:~:text=WIB%20(Western%20Indonesia%20Time)%20is,used%20as%20th...

0 Kudos
gerryleonugroho
Level 3
Author

Hi Alex,

Tried a combination of both with or without the quotes, but still no luck.

 

gerryleonugroho_0-1584011016105.png

Btw, by any chance, you're "the" (tagged) Alex on the DSS sample tutorial files?

 

Cheers,

GLN

0 Kudos
Alex_Combessie
Dataiker Alumni

Hi,

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,

Alex

 

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 ๐Ÿ™‚

0 Kudos
gerryleonugroho
Level 3
Author

Hi Alex,

They worked like magic ๐Ÿ˜Š

gerryleonugroho_0-1584019958287.png

 

Thanks for all the help @Alex_Combessie, really appreciate all the walkthrough. And please stays safe during the pandemic situation. ๐Ÿ™‚

 

Cheers,

 

CoreyS
Dataiker Alumni

Thanks @gerryleonugroho !

Looking for more resources to help you use Dataiku effectively and upskill your knowledge? Check out these great resources: Dataiku Academy | Documentation | Knowledge Base

A reply answered your question? Mark as โ€˜Accepted Solutionโ€™ to help others like you!
0 Kudos
gerryleonugroho
Level 3
Author

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 instead.

 

Thanks,

0 Kudos
Clรฉment_Stenac

Hi,

WIB is indeed not a "time zone" but an "offset to UTC", which may not be valid always. That's a fairly tricky distinction that is mostly due to daylight savings.

For example, Paris is UTC+1 in winter, UTC+2 in summer. The "time zone" called "Europe/Paris" will always be at the correct time of Paris. However the timezone "CET" will only be at the correct time during winter while "CEST" will only be correct during summer. Hence, only "Europe/Paris" is a valid timezone.

In your case, you want to set it to, I guess, "Asia/Jakarta" . While this should ideally be done in MySQL, you should be able to, in the MySQL Connection settings of DSS, add a "Custom JDBC property" with key "serverTimezone" and value "Asia/Jakarta"

gerryleonugroho
Level 3
Author

Hi @Clรฉment_Stenac would try this later on. Again, I love your products. ๐Ÿ™‚

Labels

?
Labels (1)
A banner prompting to get Dataiku