Re: [Zabbix-users] mysql template and credentials?

[Marc S. <ma...@25...>]

Hello Kristian,

probably our mysql monitoring mechanism might be a good solution for you:

https://share.zabbix.com/databases/mysql/mysql-extend
https://github.com/breuninger-ecom/mysql_extend

Regards
Marc

Am 18.05.2016 um 07:57 schrieb Kristian Rink:
> Folks;
>
> I'm trying to set up mysql server monitoring following the tutorial
> outlined in [1]. While most of the setup is pretty straightforward, I
> fail to make zabbix-agent and the local checks use the right
> credentials for accessing the database. 
>
> I do have a .my.cnf in place (actually, in various places by now, all
> containing the same information), and the credentials stored in there
> provide access to the databases using mysql -u -p from the command
> line, however zabbix server still complains that
>
>
>   1336:20160518:075417.199 item "archiv:mysql.status[Bytes_received]"
> became not supported: Received value [ERROR 1045 (28000): Access denied
> for user 'zabbix'@'localhost' (using password: NO)] is not suitable f
> or value type [Numeric (float)] 
>
>
> Changing permissions of .my.cnf obviously also didn't change anything.
> Can anyone out there enlighten me what it takes to get mysql checks to
> work?
>
> TIA and all the best,
> Kristian
>
>
> [1] http://blog.themilkyway.org/2013/11/how-to-monitor-mysql-using-the-
> new-zabbix-template-app-mysql/
>
> ------------------------------------------------------------------------------
> Mobile security can be enabling, not merely restricting. Employees who
> bring their own devices (BYOD) to work are irked by the imposition of MDM
> restrictions. Mobile Device Manager Plus allows you to control only the
> apps on BYO-devices by containerizing them, leaving personal data untouched!
> https://ad.doubleclick.net/ddm/clk/304595813;131938128;j
> _______________________________________________
> Zabbix-users mailing list
> Zab...@li...
> https://lists.sourceforge.net/lists/listinfo/zabbix-users