{
    "info": {
        "author": "Fr\u00e9d\u00e9ric MOHIER",
        "author_email": "frederic.mohier@alignak.net",
        "bugtrack_url": null,
        "classifiers": [
            "Development Status :: 5 - Production/Stable",
            "Environment :: Console",
            "Intended Audience :: Developers",
            "Intended Audience :: System Administrators",
            "License :: OSI Approved :: GNU Affero General Public License v3 or later (AGPLv3+)",
            "Natural Language :: English",
            "Programming Language :: Python",
            "Topic :: System :: Monitoring",
            "Topic :: System :: Systems Administration"
        ],
        "description": "Alignak checks package for Mysql\n================================\n\n*Checks pack for monitoring mysql database server*\n\n.. image:: https://badge.fury.io/py/alignak_checks_mysql.svg\n    :target: https://badge.fury.io/py/alignak-checks-mysql\n    :alt: Most recent PyPi version\n\n.. image:: https://img.shields.io/badge/IRC-%23alignak-1e72ff.svg?style=flat\n    :target: http://webchat.freenode.net/?channels=%23alignak\n    :alt: Join the chat #alignak on freenode.net\n\n.. image:: https://img.shields.io/badge/License-AGPL%20v3-blue.svg\n    :target: http://www.gnu.org/licenses/agpl-3.0\n    :alt: License AGPL v3\n\nInstallation\n------------\n\nThe installation of this checks pack will copy some configuration files in the Alignak default configuration directory (eg. */usr/local/share/alignak*). The copied files are located in the default sub-directory used for the packs (eg. *arbiter/packs*).\n\nFrom PyPI\n~~~~~~~~~\nTo install the package from PyPI::\n\n   sudo pip install alignak-checks-mysql\n\n\nFrom source files\n~~~~~~~~~~~~~~~~~\nTo install the package from the source files::\n\n   git clone https://github.com/Alignak-monitoring-contrib/alignak-checks-mysql\n   cd alignak-checks-linux-mysql\n   sudo pip install .\n\n**Note:** *using `sudo python setup.py install` will not correctly manage the package configuration files! The recommended way is really to use `pip`;)*\n\n\n\nDocumentation\n-------------\n\nThis checks pack is using the some PERL plugins that are shipped with the checks pack. As such, some more installation and preparation are necessary;)\n\n\nConfiguration\n~~~~~~~~~~~~~\n\n**Note**: this pack embeds the ``check_mysql_health`` script from http://labs.consol.de/lang/en/nagios/check_mysql_health/.\nThe embedded version is built from the 2.2.2 version but you may install this script by yourself ...\n\nWe recommand that you download and install your own available from the web site.\nAn abstract::\n\n    $ tar xvfz check_mysql_health-2.2.2\n    $ cd check_mysql_health-2.2.2\n    $ ./configure --prefix=/usr/local/var/libexec/alignak --with-nagios-user=alignak --with-nagios-group=alignak --with-mymodules-dir=/usr/local/var/libexec/alignak --with-mymodules-dyn-dir=/usr/local/var/libexec/alignak\n    $ make\n\n    $ make install\n\n**Note**: replace */usr/local/var/libexec/alignak* according to your platform ...\n\nAfter compilation and installation, the plugin is installed in the */usr/local/var/libexec/alignak* directory.\n\nEdit the */usr/local/etc/alignak/arbiter/packs/resource.d/mysql.cfg* file and configure the credentials to access to the mysql server.\n::\n\n    #-- MySQL default credentials\n    $MYSQLUSER$=root\n    $MYSQLPASSWORD$=root\n\n\nInstall PERL dependencies for check_mysql_health plugin\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\nYou must install some PERL dependencies for the *check_mysql_health* script.\n\nBefore installing PERL dependencies, you must install the mysql/mariadb client for your operating system.\n\nOn FreeBSD, you can::\n\n    pkg install mariadb102-client\n    cpan install DBI\n    cpan install DBD::mysql\n\nOn some Linux distros, you can::\n\n   su -\n   apt-get install mariadb-client\n   apt-get install dbi-perl\n   apt-get install dbd-mysql-perl\n\nOr you can use the PERL *cpan* utility::\n\n    cpan install DBI\n    cpan install DBD::mysql\n\n**Note**: you must have previously installed the mysql client for your operating system :)\n\n\nAlignak configuration\n~~~~~~~~~~~~~~~~~~~~~\n\nYou simply have to tag the concerned hosts with the template `mysql`.::\n\n    define host{\n        use                     mysql\n        host_name               my_server\n        address                 127.0.0.1\n    }\n\nSet the MySql connection credentials in the *resource.d/mysql.cfg* or declare the variables in each host.::\n\n   #-- MySQL default credentials\n   $MYSQLUSER$=alignak\n   $MYSQLPASSWORD$=alignak\n\nThe main `mysql` template declares macros used to configure the launched checks. The default values of these macros listed hereunder can be overriden in each host configuration.::\n\n    _MYSQLUSER                      $MYSQLUSER$\n    _MYSQLPASSWORD                  $MYSQLPASSWORD$\n\n    _UPTIME_WARN\t\t               10:\n    _UPTIME_CRIT\t\t               5:\n    _CONNECTIONTIME_WARN             1\n    _CONNECTIONTIME_CRIT             5\n    _QUERYCACHEHITRATE_WARN         90:\n    _QUERYCACHEHITRATE_CRIT         80:\n    _THREADSCONNECTED_WARN          10\n    _THREADSCONNECTED_CRIT          20\n    _QCACHEHITRATE_WARN             90:\n    _QCACHEHITRATE_CRIT             80:\n    _QCACHELOWMEMPRUNES_WARN         1\n    _QCACHELOWMEMPRUNES_CRIT        10\n    _KEYCACHEHITRATE_WARN           99:\n    _KEYCACHEHITRATE_CRIT           95:\n    _BUFFERPOOLHITRATE_WARN         99:\n    _BUFFERPOOLHITRATE_CRIT         95:\n    _BUFFERPOOLWAITFREE_WARN         1\n    _BUFFERPOOLWAITFREE_CRIT        10\n    _LOGWAITS_WARN                   1\n    _LOGWAITS_CRIT                  10\n    _TABLECACHEHITRATE_WARN         99:\n    _TABLECACHEHITRATE_CRIT         95:\n    _TABLELOCKCONTENTION_WARN        1\n    _TABLELOCKCONTENTION_CRIT        2\n    _INDEXUSAGE_WARN                90:\n    _INDEXUSAGE_CRIT                80:\n    _TMPDISKTABLES_WARN             25\n    _TMPDISKTABLES_CRIT             50\n    _SLOWQUERIES_WARN               0.1\n    _SLOWQUERIES_CRIT                1\n    _LONGRUNNINGPROCS_WARN          10\n    _LONGRUNNINGPROCS_CRIT          20\n    _OPENFILES_WARN                 80\n    _OPENFILES_CRIT                 95\n    _THREADCACHEHITRATE_WARN        99:\n    _THREADCACHEHITRATE_CRIT        95:\n\n\nTo set a specific value for an host, declare the same macro in the host definition file.::\n\n   define host{\n      use                     mysql\n      contact_groups          admins\n      host_name               my_host\n      address                 192.168.0.16\n\n      # Specific values for this host\n      _MYSQLUSER              root\n      _MYSQLPASSWORD          root_pwd\n   }\n\n\nBugs, issues and contributing\n-----------------------------\n\nContributions to this project are welcome and encouraged ... `issues in the project repository <https://github.com/alignak-monitoring-contrib/alignak-checks-mysql/issues>`_ are the common way to raise an information.\n\n\n",
        "description_content_type": "",
        "docs_url": null,
        "download_url": "",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "https://github.com/Alignak-monitoring-contrib/alignak-checks-mysql",
        "keywords": "a,l,i,g,n,a,k, ,m,o,n,i,t,o,r,i,n,g, ,p,a,c,k, ,c,h,e,c,k,s, ,m,y,s,q,l",
        "license": "GNU Affero General Public License, version 3",
        "maintainer": "",
        "maintainer_email": "",
        "name": "alignak_checks_mysql",
        "package_url": "https://pypi.org/project/alignak_checks_mysql/",
        "platform": "",
        "project_url": "https://pypi.org/project/alignak_checks_mysql/",
        "project_urls": {
            "Homepage": "https://github.com/Alignak-monitoring-contrib/alignak-checks-mysql"
        },
        "release_url": "https://pypi.org/project/alignak_checks_mysql/1.2.2/",
        "requires_dist": null,
        "requires_python": "",
        "summary": "Alignak checks pack for mysql/mariadb database server",
        "version": "1.2.2"
    },
    "last_serial": 4584149,
    "releases": {
        "0.2.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "9949602d15896a32e64a19309310324b",
                    "sha256": "a443739c511a13ddd114f1b54ffd35bfda10d1b8d25d4af3e7778957cf0af66b"
                },
                "downloads": -1,
                "filename": "alignak_checks_mysql-0.2.1.tar.gz",
                "has_sig": false,
                "md5_digest": "9949602d15896a32e64a19309310324b",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 4470,
                "upload_time": "2016-10-03T08:15:43",
                "url": "https://files.pythonhosted.org/packages/dc/b3/bc4e0323d201f8d7895f280afae83cddac4515480225f9fdfb6e5effb0e3/alignak_checks_mysql-0.2.1.tar.gz"
            }
        ],
        "0.2.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "cb196561b9d561f547101232999f98dd",
                    "sha256": "d7bfd3bd5a9d8589621c477b9289ed93049ed83fce0db2675f0b764f437d7d96"
                },
                "downloads": -1,
                "filename": "alignak_checks_mysql-0.2.2.tar.gz",
                "has_sig": false,
                "md5_digest": "cb196561b9d561f547101232999f98dd",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 42583,
                "upload_time": "2016-10-03T19:04:23",
                "url": "https://files.pythonhosted.org/packages/27/3b/b0b45cbba753ce50be653a9248e7df939f02ac70c6a3402cdc8f0df7330b/alignak_checks_mysql-0.2.2.tar.gz"
            }
        ],
        "0.3.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "f881a358ab7f490a6620d568914f9dcb",
                    "sha256": "59792d44ad7a3aaebde3bedd64c4231a7ad437d4c491145ae25eb1ad7a8ca2b5"
                },
                "downloads": -1,
                "filename": "alignak_checks_mysql-0.3.0.tar.gz",
                "has_sig": false,
                "md5_digest": "f881a358ab7f490a6620d568914f9dcb",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 43093,
                "upload_time": "2017-01-05T06:15:06",
                "url": "https://files.pythonhosted.org/packages/02/80/92c2f42c34481d4826d9f06db64fff9b877a3138065e5df73a0fdf9e3e69/alignak_checks_mysql-0.3.0.tar.gz"
            }
        ],
        "1.0.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "62bd90e53cd33dad9be2931a5e361ded",
                    "sha256": "4de0e6e06e74d74eb7036d041001b285f2d3d0a0bb7f70c0acd0472f321343fc"
                },
                "downloads": -1,
                "filename": "alignak_checks_mysql-1.0.0.tar.gz",
                "has_sig": false,
                "md5_digest": "62bd90e53cd33dad9be2931a5e361ded",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 43098,
                "upload_time": "2017-09-12T08:35:47",
                "url": "https://files.pythonhosted.org/packages/7d/cc/2eb8698ee8cc9e2685a47efd5b546437daa16c785ffb5ee613460fb25052/alignak_checks_mysql-1.0.0.tar.gz"
            }
        ],
        "1.1.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "f30b3655cd5390ce86e740f32cce8f1e",
                    "sha256": "8e92f5cd663ea0d587ec3efe638fb6612bab0955b988fbc2dc5dea41591f97a4"
                },
                "downloads": -1,
                "filename": "alignak_checks_mysql-1.1.0.tar.gz",
                "has_sig": false,
                "md5_digest": "f30b3655cd5390ce86e740f32cce8f1e",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 46208,
                "upload_time": "2018-04-16T04:22:07",
                "url": "https://files.pythonhosted.org/packages/74/6f/d058ecfe8a80f193ecc4c69d6375194f40f7d847535461e6375386886783/alignak_checks_mysql-1.1.0.tar.gz"
            }
        ],
        "1.2.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "b927362e2c483637f6f3f054e77b226c",
                    "sha256": "386d8d86f1d8fa62c35d7d885a524b21385d08750bb9636210a5168832576d63"
                },
                "downloads": -1,
                "filename": "alignak_checks_mysql-1.2.0.tar.gz",
                "has_sig": false,
                "md5_digest": "b927362e2c483637f6f3f054e77b226c",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 46412,
                "upload_time": "2018-04-30T12:37:08",
                "url": "https://files.pythonhosted.org/packages/02/a1/7b52a62db1279075bf8bc5bb4d7a9126743c057bdf1f837d1f2d9ef89c4e/alignak_checks_mysql-1.2.0.tar.gz"
            }
        ],
        "1.2.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "6b39e2852c186c7d58f6c1c8ce880eef",
                    "sha256": "a392ef790109e2c88e146722b71057721bd5864c37cb8622c573e56b0fd6f0af"
                },
                "downloads": -1,
                "filename": "alignak_checks_mysql-1.2.1-py2-none-any.whl",
                "has_sig": false,
                "md5_digest": "6b39e2852c186c7d58f6c1c8ce880eef",
                "packagetype": "bdist_wheel",
                "python_version": "py2",
                "requires_python": null,
                "size": 49277,
                "upload_time": "2018-12-09T17:07:57",
                "url": "https://files.pythonhosted.org/packages/65/07/24b03b23baa046e0f7ff2eaa35d58d2bb3b0a14cd3e9f5c604bb0e5a44b2/alignak_checks_mysql-1.2.1-py2-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "bd41ed303efd98e0b53a70e151d7b938",
                    "sha256": "eca7cbb34bbffd83a35ee282518107aab4df9fff6bac0a9e8e4ce02aaa24bf17"
                },
                "downloads": -1,
                "filename": "alignak_checks_mysql-1.2.1.tar.gz",
                "has_sig": false,
                "md5_digest": "bd41ed303efd98e0b53a70e151d7b938",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 48078,
                "upload_time": "2018-12-09T17:07:58",
                "url": "https://files.pythonhosted.org/packages/a8/67/e57bb4a8a61496b5bb60fdcaa3a6947d016d5d3c6036c878124c2f74b449/alignak_checks_mysql-1.2.1.tar.gz"
            }
        ],
        "1.2.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "8c1d621f4346751a6a0565994f9e8a25",
                    "sha256": "0bf4a0bd8af4dc9f977d9dc26573365221219f26916bd90573221f5cbe1bbe07"
                },
                "downloads": -1,
                "filename": "alignak_checks_mysql-1.2.2-py2-none-any.whl",
                "has_sig": false,
                "md5_digest": "8c1d621f4346751a6a0565994f9e8a25",
                "packagetype": "bdist_wheel",
                "python_version": "py2",
                "requires_python": null,
                "size": 49328,
                "upload_time": "2018-12-11T07:40:34",
                "url": "https://files.pythonhosted.org/packages/d9/8a/689bf3bb661267ac98593f867d653478fa49228d6affbdd6ec9fa524b152/alignak_checks_mysql-1.2.2-py2-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "3f0a3e22e4415899c7be21851a179d85",
                    "sha256": "199e474bf8bc60508ecf4f6e5001cb687db7c17724a14884ef8f99aae63e4c2c"
                },
                "downloads": -1,
                "filename": "alignak_checks_mysql-1.2.2.tar.gz",
                "has_sig": false,
                "md5_digest": "3f0a3e22e4415899c7be21851a179d85",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 48096,
                "upload_time": "2018-12-11T07:40:36",
                "url": "https://files.pythonhosted.org/packages/f0/db/60b1e9b760f26ae2e6dfe6f7bbf3c56ad70100b60818148cb42e3fa43eee/alignak_checks_mysql-1.2.2.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "8c1d621f4346751a6a0565994f9e8a25",
                "sha256": "0bf4a0bd8af4dc9f977d9dc26573365221219f26916bd90573221f5cbe1bbe07"
            },
            "downloads": -1,
            "filename": "alignak_checks_mysql-1.2.2-py2-none-any.whl",
            "has_sig": false,
            "md5_digest": "8c1d621f4346751a6a0565994f9e8a25",
            "packagetype": "bdist_wheel",
            "python_version": "py2",
            "requires_python": null,
            "size": 49328,
            "upload_time": "2018-12-11T07:40:34",
            "url": "https://files.pythonhosted.org/packages/d9/8a/689bf3bb661267ac98593f867d653478fa49228d6affbdd6ec9fa524b152/alignak_checks_mysql-1.2.2-py2-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "3f0a3e22e4415899c7be21851a179d85",
                "sha256": "199e474bf8bc60508ecf4f6e5001cb687db7c17724a14884ef8f99aae63e4c2c"
            },
            "downloads": -1,
            "filename": "alignak_checks_mysql-1.2.2.tar.gz",
            "has_sig": false,
            "md5_digest": "3f0a3e22e4415899c7be21851a179d85",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 48096,
            "upload_time": "2018-12-11T07:40:36",
            "url": "https://files.pythonhosted.org/packages/f0/db/60b1e9b760f26ae2e6dfe6f7bbf3c56ad70100b60818148cb42e3fa43eee/alignak_checks_mysql-1.2.2.tar.gz"
        }
    ]
}