Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Thu Jul 20, 2017 7:50 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 6 posts ] 
Author Message
 Post subject: MySQL in Strict Mode
PostPosted: Thu Apr 28, 2016 12:18 am 
Offline

Joined: Thu Apr 28, 2016 12:05 am
Posts: 4
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.


Top
 Profile  
 
 Post subject: Re: MySQL in Strict Mode
PostPosted: Thu Apr 28, 2016 12:32 am 
Offline

Joined: Thu Apr 28, 2016 12:05 am
Posts: 4
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.


Top
 Profile  
 
 Post subject: Re: MySQL in Strict Mode
PostPosted: Tue May 03, 2016 5:57 am 
Offline

Joined: Tue Apr 26, 2016 6:57 am
Posts: 14
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.


Top
 Profile  
 
 Post subject: Re: MySQL in Strict Mode
PostPosted: Tue May 03, 2016 10:21 pm 
Offline

Joined: Thu Apr 28, 2016 12:05 am
Posts: 4
I have done the same changed, but it's not working.


Top
 Profile  
 
 Post subject: Re: MySQL in Strict Mode
PostPosted: Tue May 10, 2016 12:30 am 
Offline
Cacti Moderator
User avatar

Joined: Sat May 08, 2004 12:44 pm
Posts: 12125
Location: USA
try:
sql-mode=""

restart mysql

_________________

| Scripts: Monitor processes | RFC1213 MIB | DOCSIS Stats | Dell PowerEdge | Speedfan | APC UPS | DOCSIS CMTS | 3ware | Motorola Canopy |
| Guides: Windows Install | [HOWTO] Debug Windows NTFS permission problems |
| Tools: Windows All-in-one Installer |


Top
 Profile  
 
 Post subject: Re: MySQL in Strict Mode
PostPosted: Thu Oct 20, 2016 6:26 pm 
Offline

Joined: Thu Jun 14, 2012 5:31 pm
Posts: 13
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


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group