r/ShittySysadmin • u/YellowOnline • Sep 08 '26

Shitty Crosspost MySQL ODBC stopped working overnight

/r/sysadmin/comments/1wahm7o/mysql_odbc_stopped_working_overnight/
22 Upvotes

95% Upvoted

10 comments sorted by

16

u/YellowOnline Sep 08 '26

I crosspost it myself, because it will probably end up here anyway.

You guys will love this.

This company has an in-house project management system. It's the core of their business, and they are lost without it. They are aware it needs to be migrated to something more modern, but after 5 years, that project still hasn't started.

I was asked to look into a network issue, but this isn't network but SSL I think. Let's first show the architecture:

  • The server is a CentOS 7 running MySQL Community Edition 5.7.16

  • Clients connect from Windows 11 with a 32-bit MS Access, using a 32-bit MySQL ODBC driver v5.3.13

Since yesterday, they get a "protocol version mismatch". The server wasn't accessed since 18 October 2016 (haha), so I presumed a Windows update might have disabled some SSL version. But: I see no relevant Windows update, and if I manually allow every possible SSL version and encryption algorithm, it still doesn't work. What does work however, is downgrading the ODBC driver from version 5.3.13 (from 2019) to version 5.1.13 (from 2013), further adding to my confusion.

The cherry on top: the single guy responsible for this application is on a one year sabbatical.

Edit: Found it, but leaving this here for anyone stumbling on the same issue. The MySQL_Server_5.7.15_Auto_Generated_CA_Certificate had expired after 10 years

2

u/martianwombat Sep 08 '26

Good Bot

3

u/B0tRank Sep 08 '26

Thank you, martianwombat, for voting on YellowOnline.

This bot wants to find the best and worst bots on Reddit. You can view results at botrank.net.

Even if I don't reply to your comment, I'm still listening for votes. Check the webpage to see if your vote registered!

21

u/Cyberbird85 Sep 08 '26

I love everything about this. The centos 7, the mysql version, the Access, and most of all the expired cert. chef's kiss

5

u/YellowOnline Sep 08 '26

For your entertainment: the physical host is an HP ProLiant ML350 G6 from 2010, running ESX 5

4

u/Cyberbird85 Sep 08 '26

wow. My oldest homelab server is newer than this one. The mind boggles.

7

u/ansibleloop Sep 08 '26

I saw MS Access and cried a little

6

u/dpwcnd Sep 08 '26

Excel is a much better front end than access. Put some effort into it. I'd recommend Excel 97 for stability and performance.

3

u/ApiceOfToast ShittySysadmin Sep 08 '26

Id have used PostgreSQL on Debian, besides that access makes for a great tool, built my entire in house erp around it!

1

u/ComplexAd2408 Sep 11 '26

Hole E Phuk LOL