Cannot set Timezone on connection using SYSTEM timezone

[mariadb-corporation]

Cannot set Timezone on connection using SYSTEM timezone

[grgrssll-dev]

It seems to work if I use 'US/Pacific' instead of 'America/Los_Angeles' in the options.timezone

[rusher]

ok, found the issue. Using timezone exactly corresponding to client current timezone might cause automatic retrieval of server timezone.
This is corrected with 9fc5d23 that will be in next release

[knoxcard]

I know this might sound stupid, but have you tried...

yarn add https://github.com/MariaDB/mariadb-connector-nodejs.git
or
npm install https://github.com/MariaDB/mariadb-connector-nodejs.git

[rusher]

Can you indicate sequelize and moment-timezone versions in package-lock.json ?
I fail to understand how 'US/Pacific' instead of 'America/Los_Angeles' would change anything with the latest version.

[grgrssll-dev]

Sorry for the delay.
The mariadb-connector-nodejs did not help...

sequelize: 5.8.6
moment-timezone: 0.5.25

The sequelize constructor options for dialectOptions are

// Doesn't work
dialectOptions: {
    timezone: 'America/Los_Angeles',
    // also doesn't work if no timezone option presented
},
// throws: ER_WRONG_AUTO_TIMEZONE

// Does work
dialectOptions: {
    timezone: 'US/Pacific',
},

[knoxcard]

Everything good? Close issue?

[grgrssll-dev]

Fix verified working for me. Thanks