Bug 280862 - net/libnss-mysql: WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version
Summary: net/libnss-mysql: WARNING: MYSQL_OPT_RECONNECT is deprecated and will be remo...
Status: Closed FIXED
Alias: None
Product: Ports & Packages
Classification: Unclassified
Component: Individual Port(s) (show other bugs)
Version: Latest
Hardware: Any Any
: --- Affects Some People
Assignee: Dima Panov
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-08-16 12:37 UTC by Max Khon
Modified: 2024-11-05 18:08 UTC (History)
3 users (show)

See Also:
fluffy: maintainer-feedback+

Attachments
FIx the use of deprecated option (1.35 KB, patch)
2024-08-16 12:37 UTC, Max Khon 		no flags Details | Diff
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Max Khon freebsd_committer freebsd_triage 2024-08-16 12:37:44 UTC 
Created attachment 252821 [details]
FIx the use of deprecated option

When libnss_mysql is built against mysql80-client-8.0.39 every libnss_mysql initialization emits a warning to stderr:

WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version

Patch proposal is attached
Comment 1 spork 2024-09-27 20:00:56 UTC 
This is kind of a big deal - this warning output is everywhere on a system with libnss-mysql and it does fun things like turning every cron job that's successfully completed into one that sends you mail each time the job is run. And if you're not paying a whole lot of attention or just don't frequently work with libnss hosts, the error really doesn't give you a clue as to the cause.

I got this on upgrade last night. I just found this patch and applied it on a FreeBSD 13.4-p1 host and have not had any issues. Is there anything I can do to move this bug along? It's more than a month old now.
Comment 2 Vladimir Druzenko freebsd_committer freebsd_triage 2024-09-27 21:03:38 UTC 
I can commit this patch soon (in 1-2 days) with "maintainer timeout > 1 month".

Also I suggest to switch upstream to https://github.com/saknopper/libnss-mysql.
Comment 3 Dima Panov freebsd_committer freebsd_triage 2024-09-27 21:07:10 UTC 
(In reply to Vladimir Druzenko from comment #2)
This option needed also for mariadb, time to recheck it agains all available in ports versions.

Please be patient
Comment 4 Vladimir Druzenko freebsd_committer freebsd_triage 2024-09-27 21:25:20 UTC 
(In reply to Dima Panov from comment #3)
Hello!
Comment 5 Mark Linimon freebsd_committer freebsd_triage 2024-10-01 00:58:39 UTC 
^Triage: over to maintainer.
Comment 6 Vladimir Druzenko freebsd_committer freebsd_triage 2024-10-13 08:42:33 UTC 
(In reply to Dima Panov from comment #3)
ping
Comment 7 Vladimir Druzenko freebsd_committer freebsd_triage 2024-11-03 18:36:22 UTC 
ping
Comment 8 commit-hook freebsd_committer freebsd_triage 2024-11-05 18:07:27 UTC 
A commit in branch main references this bug:

URL: https://cgit.FreeBSD.org/ports/commit/?id=fe377bbb78a53fd6b22450d580ce67b1cfee3696

commit fe377bbb78a53fd6b22450d580ce67b1cfee3696
Author:     Max Khon <fjoe@FreeBSD.org>
AuthorDate: 2024-11-05 18:05:23 +0000
Commit:     Dima Panov <fluffy@FreeBSD.org>
CommitDate: 2024-11-05 18:06:15 +0000

    net/libnss-mysql: WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version (+)

    PR:     280862

 net/libnss-mysql/Makefile                       |  2 +-
 net/libnss-mysql/files/patch-src_mysql.c (gone) | 22 ----------------------
 2 files changed, 1 insertion(+), 23 deletions(-)
Comment 9 Dima Panov freebsd_committer freebsd_triage 2024-11-05 18:08:23 UTC 
Committed, thanks!