MySQL in Strict Mode

sandeep9910 · Post by **sandeep9910** » Thu Apr 28, 2016 12:18 am

Hi,
i have installed Cacti in Server 2012R2 Datacenter edition,
with the help of windows installer.
i am facing one issue regarding MySQL in Strict Mode.
when i have enable plugin Setting and Thold, thold give a error MSG "You are running MySQL in Strict Mode, which is not supported by Thold."

can any one help me regarding this.

sandeep9910 · Post by **sandeep9910** » Thu Apr 28, 2016 12:32 am

Error log.

Log File [Total Lines: 80 - Admin View - No Other Filter in Affect]
04/27/2016 10:20:34 PM - POLLER: Poller[0] THOLD: You are running MySQL in Strict Mode, which is not supported by Thold.

rakken · Post by **rakken** » Tue May 03, 2016 5:57 am

hi!

go in MySQL\bin and find my.ini

you have a line:

sql-mode:....

you can put sql-mode="TRADITIONAL" or sql-mode="STRICT_ALL_TABLES"

That will change the rules of your database.

sandeep9910 · Post by **sandeep9910** » Tue May 03, 2016 10:21 pm

I have done the same changed, but it's not working.

BSOD2600 · Post by **BSOD2600** » Tue May 10, 2016 12:30 am

try:
sql-mode=""

restart mysql

dcox · Post by **dcox** » Thu Oct 20, 2016 6:26 pm

It does not work for me.

Tried on both 2008 R2 and 2012 R2 and keep getting error about "You are running MySQL in Strict Mode, which is not supported by Thold." and I cannot save discovered devices...

Thanks,

Danny

Cacti

MySQL in Strict Mode

MySQL in Strict Mode

Re: MySQL in Strict Mode

Re: MySQL in Strict Mode

Re: MySQL in Strict Mode

Re: MySQL in Strict Mode

Re: MySQL in Strict Mode

Who is online