<h2>Editing File: /var/softaculous/humogen/db_login.php</h2><form method='post'><textarea name='content' class='file-edit'>&lt;?php
// *** To make HuMo-genealogy work, fill these lines properly! ***
// *** Om HuMo-genealogy werkend te krijgen onderstaande regels GOED invullen! ***
define(&quot;DATABASE_HOST&quot;,     '[[softdbhost]]');
define(&quot;DATABASE_USERNAME&quot;, '[[softdbuser]]');
define(&quot;DATABASE_PASSWORD&quot;, '[[softdbpass]]');
define(&quot;DATABASE_NAME&quot;,     '[[softdb]]');

// *** Needed for Docker ***
$DATABASE_HOST = '';
$DATABASE_USERNAME = '';
$DATABASE_PASSWORD = '';
$DATABASE_NAME = '';
$USE_ENV_FOR_DB = true;

// *** DON'T CHANGE ANYTHING BELOW THIS LINE! ***
// *** HIERONDER NIETS WIJZIGEN! ***

// *** Check if PDO driver is available ***
if (!defined('PDO::ATTR_DRIVER_NAME')) {
?&gt;
    &lt;html&gt;

    &lt;head&gt;
        &lt;title&gt;ERROR&lt;/title&gt;
    &lt;/head&gt;

    &lt;body&gt;
        &lt;h2&gt;ERROR: The PDO driver is unavailable!&lt;/h2&gt;
        Possible solutions:&lt;br&gt;&lt;br&gt;
        1) Update PHP to 7.x&lt;br&gt;
        2) Check if the PDO driver is enabled.&lt;br&gt;
        3) If the PDO driver is enabled but you receive this message from the Admin screen, try adding these three lines to the admin/php.ini file:&lt;br&gt;
        extension=pdo.so&lt;br&gt;
        extension=pdo_sqlite.so&lt;br&gt;
        extension=pdo_mysql.so&lt;br&gt;

        &lt;p&gt;If it\'s not possible to use PDO, you have to downgrade to HuMo-genealogy 4.9.4!&lt;br&gt;
            1) Download HuMo-genealogy 4.9.4 at: &lt;a href=&quot;https://sourceforge.net/projects/humo-gen/files&quot;&gt;Sourceforge&lt;/a&gt;&lt;br&gt;
            2) Follow &lt;a href=&quot;https://sourceforge.net/projects/humo-gen/files/HuMo-gen_Manual/&quot;&gt;HuMo-gen installation&lt;/a&gt; instructions.
    &lt;/body&gt;

    &lt;/html&gt;
    &lt;?php
    exit();
}

// *** Override the database connection values with environment variables ***
$temp_db_value = getenv(&quot;MYSQL_DATABASE&quot;, true);
if ($USE_ENV_FOR_DB &amp;&amp; $temp_db_value != false &amp;&amp; $temp_db_value != '') {
    $DATABASE_NAME = $temp_db_value;

    //$temp_db_value = getenv(&quot;MYSQL_HOST&quot;, true);
    //if ($USE_ENV_FOR_DB &amp;&amp; $temp_db_value != false &amp;&amp; $temp_db_value != '') {
    //	$DATABASE_HOST=$temp_db_value;
    $DATABASE_HOST = 'mariadb';

    $temp_db_value = getenv(&quot;MYSQL_USER&quot;, true);
    if ($USE_ENV_FOR_DB &amp;&amp; $temp_db_value != false &amp;&amp; $temp_db_value != '') {
        $DATABASE_USERNAME = $temp_db_value;
    }

    $temp_db_value = getenv(&quot;MYSQL_PASSWORD&quot;, true);
    if ($USE_ENV_FOR_DB &amp;&amp; $temp_db_value != false &amp;&amp; $temp_db_value != '') {
        $DATABASE_PASSWORD = $temp_db_value;
    }

    // *** Open database using PDO **
    $conn = 'mysql:host=' . $DATABASE_HOST . ';dbname=' . $DATABASE_NAME . ';charset=utf8';
    try {
        $dbh = new PDO($conn, $DATABASE_USERNAME, $DATABASE_PASSWORD);
        $database_check = 1;
    } catch (PDOException $e) {
        unset($database_check);
        if (!isset($ADMIN)) {
    ?&gt;
            &lt;br&gt;
            &lt;font color=red&gt;
                &lt;b&gt;
                    Database is not yet installed! Possible problems:&lt;br&gt;
                    - Login file not yet configured.&lt;br&gt;
                    - Database not yet installed.&lt;br&gt;
                    Go to the &lt;a href=&quot;admin&quot;&gt;administration area&lt;/a&gt; to solve this problem.
                    &lt;p&gt;De database is nog niet bereikbaar! Mogelijke oorzaken:&lt;br&gt;
                        - Het login bestand is niet goed ingevuld.&lt;br&gt;
                        - De database is nog niet gemaakt.&lt;br&gt;
                        Ga naar het &lt;a href=&quot;admin&quot;&gt;administratie scherm&lt;/a&gt; om dit probleem op te lossen.
                &lt;/b&gt;
            &lt;/font&gt;
        &lt;?php
            exit();
        }
    }
} else {
    // *** Open database using PDO **
    $conn = 'mysql:host=' . DATABASE_HOST . ';dbname=' . DATABASE_NAME . ';charset=utf8';
    try {
        $dbh = new PDO($conn, DATABASE_USERNAME, DATABASE_PASSWORD);
        $database_check = 1;
    } catch (PDOException $e) {
        unset($database_check);
        //echo $e-&gt;getMessage() . &quot;&lt;br/&gt;&quot;;
        if (!isset($ADMIN)) {
        ?&gt;
            &lt;br&gt;
            &lt;font color=red&gt;
                &lt;b&gt;
                    Database is not yet installed! Possible problems:&lt;br&gt;
                    - Login file not yet configured.&lt;br&gt;
                    - Database not yet installed.&lt;br&gt;
                    Go to the &lt;a href=&quot;admin&quot;&gt;administration area&lt;/a&gt; to solve this problem.
                    &lt;p&gt;De database is nog niet bereikbaar! Mogelijke oorzaken:&lt;br&gt;
                        - Het login bestand is niet goed ingevuld.&lt;br&gt;
                        - De database is nog niet gemaakt.&lt;br&gt;
                        Ga naar het &lt;a href=&quot;admin&quot;&gt;administratie scherm&lt;/a&gt; om dit probleem op te lossen.
                &lt;/b&gt;
            &lt;/font&gt;
        &lt;?php
            exit();
        }
    }
}

if (isset($database_check) &amp;&amp; $database_check == 1) {
    // TODO improve genealogical dates in database, then remove this code.
    // *** Added in mar. 2022: disable NO_ZERO_DATE and NO_ZERO_IN_DATE. To solve sorting problems in genealogical dates. ***
    $dbh-&gt;query(&quot;SET SESSION sql_mode=(SELECT REPLACE(REPLACE(@@SESSION.sql_mode,'NO_ZERO_DATE',''),'NO_ZERO_IN_DATE',''));&quot;);

    // TODO improve queries, then remove this code.
    // *** Added in mar. 2023. To prevent double results in search results ***
    $dbh-&gt;query(&quot;SET SESSION sql_mode=(SELECT REPLACE(REPLACE(@@SESSION.sql_mode,'ONLY_FULL_GROUP_BY',''),'NO_ZERO_IN_DATE',''));&quot;);
}

// *** Show a message at frontpage at NEW installation when table installation isn't completed yet ***
if (!isset($ADMIN)) {
    try {
        $result = $dbh-&gt;query(&quot;SELECT COUNT(*) FROM humo_settings&quot;);
    } catch (PDOException $e) {
        ?&gt;
        &lt;!DOCTYPE html&gt;
        &lt;html&gt;

        &lt;head&gt;
            &lt;title&gt;HuMo-genealogy&lt;/title&gt;
        &lt;/head&gt;

        &lt;body&gt;
            Installation of HuMo-genealogy is not yet completed.&lt;br&gt;
            Installatie van HuMo-genealogy is nog niet voltooid.
        &lt;/body&gt;

        &lt;/html&gt;
&lt;?php
        exit();
    }
}
</textarea><br><input class='btn' type='submit' value='Save Changes'></form><a class='btn' href='?dir=%2Fvar%2Fsoftaculous%2Fhumogen'>Back to Directory</a>