📃 PHP-client Plugins Checks sqliteconnect

Edit on GitHub

Table of Contents

SqliteConnect

Description

Make a database connection to a sqlite database. The function fails if the filename does not exist or the PDO cannot open it

$o = new PDO("sqlite:".$aParams["db"],(...));

Syntax

$oMonitor->addCheck(
    array(
        "name" => "Slite test",
        "description" => "Connect sqlite database file",
        "check" => array(
            "function" => "SqliteConnect",
            "params" => array(
                "db"       => [database file],
                "user"     => [username],
                "password" => [password],
                "timeout"  => [time],
            ),
        ),
    )
);

Parameters

key type description
db🔸 (string) full path of the sqlite database file
user (string) optional: username; default: empty
password (string) optional: password; default: empty
timeout (integer) optional timeout in sec; default: 5

🔸 required

Examples

$sSqlitefile=$aConfig['dataDir'].'/database/logs.db';
$oMonitor->addCheck(
    array(
        "name" => "Sqlite DB for action logs",
        "description" => "Connect sqlite db ". basename($sSqlitefile),
        "check" => array(
            "function" => "SqliteConnect",
            "params" => array(
                "db"=>$sSqlitefile
            ),
        ),
    )
);