Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

JDBC Connector error with MySQL

I've finally tracked down an error and now need help-

I'm moving my WHD instance from Mac OS to Centos

Everything is set up and working but WHD won't start because of a time zone error

'The server time zone 'AEST' is unrecognised or represents more than one time zone'

With a bit of extra work I found this was because I'm using a new version of the JDBC connector- v8 on the new server, v5 on the old server.

Putting the old version on the new server does not work.

I've tried

- manually setting the time zone in mysql my.cnf

- using the time zone files for mysql (may have not done this properly )

- using mysql workbench to set the time zone

- using mysql commands '@global.time_zone'

- apparently I could set something in the JDBC connection profile but I can't find that

and all sorts of other things. I'm really not having much luck, and would appreciate any help......

Screen Shot 2018-06-17 at 3.21.05 pm.png

Find more posts tagged with

Accepted answers

All comments

fluffy_midnight

Hi adamc,

I'd recommend trying a JDBC driver that is between v8 and v5, here's a link to a list of archived versions where some of the version 6 J connector's are available for download: J Connector (Archived Versions)

Try this first and if none of them are working and you're getting no where we can work from there.

-Midnight

adamc

thanks- the end result I'm looking for is to drop mySQL altogether in favour of Postgres, so I'll go back to the other thread and concentrate on that.

Thanks fluffy midnight

fluffy_midnight

Hi adamc,

If you're migrating from MySQL to PostgreSQL then I'd recommend checking out their wiki: Converting Databases to PostgreSQL

Additionally, try to raise this with a DBA or get a database conversion tool.

I wish you the best of luck!

-Midnight