Hi,
i am using an RT 5.03 installation on a Ubuntu Linux 22.04.3 LTS box with MariaDB Ver 10.6.12-MariaDB-0ubuntu0.22.04.1).
Starting this morning i get the following warning via rt cron daemon:
Subject of mail: Cron root@rt /opt/rt5/sbin/rt-fulltext-indexer --quiet ANDroot@rt /opt/rt5/sbin/rt-email-dashboards
WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
It is just a warning but i guess that some changes have to be made. Any suggestions?
Thx in advance and have fun,
Maurice
1 Like
I have the same setup as you, had to turn off notification in cron cause it sends every other minute.
I upgraded to 5.0.4 and the problem persists. I have the same setup as the previous posters.
An easy way to replicate from the command line is:
(or whatever your path is to RT’s sbin/ )
1 Like
I had some software updates that I ran now and after that I ran /opt/rt5/sbin/rt-fulltext-indexer with no warning about deprecated MySQL.
Was it easy to upgrade to RT 5.0.4, did you follow any guide? Did you also upgrade the Ubuntu server?
The others in this thread are using MariaDB, not MySQL. But the error is a MySQL error, since MariaDB is interoperable.
You can run a command like “dpkg --list | grep mariadb” to see if that’s what you have.
For the upgrade: I went from 5.0.3 to 5.0.4 which was painless. Just follow the instructions in the README file.
After some system updates i got rid of the warning message. So the problem is solved.
But for my understanding: As i posted i use a MariaDB installation but i got a MySQL warning. So i guess that some client software /rt Perl stuff) uses a lib with this depricated feature. Because of the compatibility betwenn MySQl and MariaDB they are both affected or is it just a warning from the library and as MariaDB user i can ignore it?
Th@nx a lot to all posters,
Maurice
Some additional background on what happened here and the current update that removed the message:
opened 04:25PM - 18 Jul 23 UTC
```
The MySQL client library currently supports performing an automatic reconne… ction to the server if it finds that the connection is down and an application attempts to send a statement to the server to be executed. Now, this feature is deprecated and subject to removal in a future release of MySQL.
The related MYSQL_OPT_RECONNECT option is still available but it is also deprecated. C API functions [mysql_get_option()](https://dev.mysql.com/doc/c-api/8.1/en/mysql-get-option.html) and [mysql_options()](https://dev.mysql.com/doc/c-api/8.1/en/mysql-options.html) now write a deprecation warning to the standard error output when an application specifies MYSQL_OPT_RECONNECT. (WL #15766)
```
https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-34.html#mysqld-8-0-34-deprecation-removal
https://dev.mysql.com/doc/relnotes/mysql/8.1/en/news-8-1-0.html#mysqld-8-1-0-deprecation-removal
I seem DBD::mysql is using only one place in
https://github.com/perl5-dbi/DBD-mysql/blob/7117e4c53fdd4d1ddd6672e339723bd5b3bd73ec/dbdimp.c#L2118-L2121
Current status is `deprecated` and it would work several minor updates.
But the after the deadline, this method raises would be errored.
(This depends libmysqlclient.so 's version, not Server's version)
The errors went away when I restarted my system. I had restarted my web server and various components after some system upgrades, but not the whole system. I’m not sure what specific package was causing the error pre-reboot, and then not causing error post-reboot, but the solution was to reboot.