SET GLOBAL log_warnings = 1 "error" on intro page

Post support questions that relate to the Windows 2003/2000/XP operating systems.

Moderators: Developers, Moderators

Post Reply
mrossTTX
Cacti User
Posts: 114
Joined: Wed Dec 07, 2022 12:49 pm

SET GLOBAL log_warnings = 1 "error" on intro page

Post by mrossTTX »

on my intro page i see this "error" logged in "database checks"
Aborted clients/connects: 160. Run 'SET GLOBAL log_warnings = 1;' from the mysql CLI and set in server.cnf to silence.


it appears SET GLOBAL log_warnings = 1 has been deprecated and you should be using log_error_verbosity instead
the exact error mysql gives me when running this command is
0 row(s) affected, 1 warning(s): 1287 '@@log_warnings' is deprecated and will be removed in a future release. Please use log_error_verbosity instead

i looked up the warning, and in mysql 5.7 here is what i found
In MySQL 5.7.2 and higher, use of log_warnings is still permitted but maps onto use of log_error_verbosity as follows:

In MySQL 5.7.2 and higher, use of log_warnings is still permitted but maps onto use of log_error_verbosity as follows:

Setting log_warnings=0 is equivalent to log_error_verbosity=1 (errors only).
Setting log_warnings=1 is equivalent to log_error_verbosity=2 (errors, warnings).

i ran that in mysql workbench
"SET GLOBAL log_error_verbosity=2;" which gave me a green checkbox, but the response came back as
0 row(s) affected
if i put SET GLOBAL log_error_verbosity=2 in my my.ini for mysql, the service will not start. i remove it and it starts fine.
anyone else see this and have a solution
User avatar
TheWitness
Developer
Posts: 16897
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Re: SET GLOBAL log_warnings = 1 "error" on intro page

Post by TheWitness »

What Cacti version?
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
mrossTTX
Cacti User
Posts: 114
Joined: Wed Dec 07, 2022 12:49 pm

Re: SET GLOBAL log_warnings = 1 "error" on intro page

Post by mrossTTX »

1.2.22
User avatar
TheWitness
Developer
Posts: 16897
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Re: SET GLOBAL log_warnings = 1 "error" on intro page

Post by TheWitness »

This would appears to be Intropage related. Log this in the respective GitHub issue list for Intropage.
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest