PdoConnect

Description

Verify a database connection with PDO connect.

PDO supports a wide range of database types - see http://php.net/manual/en/pdo.drivers.php. BUT: I just started with Mysql. To implement more types go to classes/appmonitor-checks.class.php - method checkPdoConnect().

Syntax

$oMonitor->addCheck(
    [
        "name" => "Mysql Master",
        "description" => "Connect mysql db X on server Y",
        "check" => [
            "function" => "PdoConnect",
            "params" => [
                "connect"  => [pdo connect string],
                "user"     => [database user],
                "password" => [password],
            ],
        ],
    ]
);

Parameters

key type description
connect🔸 (string) connect string, i.e. ‘mysql:host=localhost;port=3306;dbname=mydatabase;’
user🔸 (string) mysql username
password🔸 (string) password
timeout (integer) optional timeout in sec; default: 5

🔸 required

Remark:
The idea is not to enter credentials in the parameters. You should parse the config of your application and insert its variables.

Examples

None yet.