<?php
// set zend license variables to be updated
$serial_number = 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX';
$user_name = 'user_name';
// connect to Zend Server database
$sqliteDebug = true;
try {
$sqlite = new SQLite3('/usr/local/zendsvr6/var/db/zsd.db');
//$sqlite = new SQLite3('/usr/local/zendphp7/var/db/zsd.db');
} catch (Exception $exception) {
echo '<p>There was an error connecting to the database!</p>';
if ($sqliteDebug) {
echo $exception->getMessage();
}
}
// perform updates
$query = "update ZSD_DIRECTIVES set DISK_VALUE = '" . $user_name . "' where NAME = 'zend.user_name'";
// for Zend Server 2019.0.x PHP 7.x
//$query = "update ZSD_ZEND_COMMON_DIRECTIVES set DISK_VALUE = '" . $user_name . "' where NAME = 'zend.user_name'";
$sqliteResult = $sqlite->query($query);
if (!$sqliteResult and $sqliteDebug) {
echo "<p>There was an error updating zend.user_name: $query</p>";
echo $sqlite->lastErrorMsg();
} else {
echo "<p>zend.user_name updated successfully: $user_name</p>";
}
$query = "update ZSD_DIRECTIVES set DISK_VALUE = '" . $serial_number . "' where NAME = 'zend.serial_number'";
// for Zend Server 2019.0.x PHP 7.x
// $query = "update ZSD_ZEND_COMMON_DIRECTIVES set DISK_VALUE = '" . $serial_number . "' where NAME = 'zend.serial_number'";
$sqliteResult = $sqlite->query($query);
if (!$sqliteResult and $sqliteDebug) {
echo "<p>There was an error updating zend.serial_number: $query</p>";
echo $sqlite->lastErrorMsg();
} else {
echo "<p>zend.serial_number updated successfully: $serial_number</p>";
}
|