REDROOM

Navigation

Breadcrumbs

/ / var / softaculous / humogen

Create

Create File | Create Folder | Upload Files | Run Command

Edit File Size: 5.72 KB

//var/softaculous/humogen/db_login.php

Text Base64

<?php
// *** To make HuMo-genealogy work, fill these lines properly! ***
// *** Om HuMo-genealogy werkend te krijgen onderstaande regels GOED invullen! ***
define("DATABASE_HOST", '[[softdbhost]]');
define("DATABASE_USERNAME", '[[softdbuser]]');
define("DATABASE_PASSWORD", '[[softdbpass]]');
define("DATABASE_NAME", '[[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')) {
?>
 <html>

<head>
 <title>ERROR</title>
 </head>

<body>
 <h2>ERROR: The PDO driver is unavailable!</h2>
 Possible solutions: 
 1) Update PHP to 7.x 
 2) Check if the PDO driver is enabled. 
 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: 
 extension=pdo.so 
 extension=pdo_sqlite.so 
 extension=pdo_mysql.so

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

</html>
 <?php
 exit();
}

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

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

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

$temp_db_value = getenv("MYSQL_PASSWORD", true);
    if ($USE_ENV_FOR_DB && $temp_db_value != false && $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)) {
 ?>
 
 
 
 Database is not yet installed! Possible problems: 
 - Login file not yet configured. 
 - Database not yet installed. 
 Go to the <a href="admin">administration area</a> to solve this problem.
 De database is nog niet bereikbaar! Mogelijke oorzaken: 
 - Het login bestand is niet goed ingevuld. 
 - De database is nog niet gemaakt. 
 Ga naar het <a href="admin">administratie scherm</a> om dit probleem op te lossen.
 
 
 <?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->getMessage() . " ";
 if (!isset($ADMIN)) {
 ?>
 
 
 
 Database is not yet installed! Possible problems: 
 - Login file not yet configured. 
 - Database not yet installed. 
 Go to the <a href="admin">administration area</a> to solve this problem.
 De database is nog niet bereikbaar! Mogelijke oorzaken: 
 - Het login bestand is niet goed ingevuld. 
 - De database is nog niet gemaakt. 
 Ga naar het <a href="admin">administratie scherm</a> om dit probleem op te lossen.
 
 
 <?php
 exit();
 }
 }
}

if (isset($database_check) && $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->query("SET SESSION sql_mode=(SELECT REPLACE(REPLACE(@@SESSION.sql_mode,'NO_ZERO_DATE',''),'NO_ZERO_IN_DATE',''));");

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

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

<head>
 <title>HuMo-genealogy</title>
 </head>

<body>
 Installation of HuMo-genealogy is not yet completed. 
 Installatie van HuMo-genealogy is nog niet voltooid.
 </body>

</html>
<?php
 exit();
 }
}

Exit & Reset Text mode: syntax highlighting auto-detects file type.

Directory Contents

Dirs: 6 × Files: 14

Sort:

Enable drag-to-move

Name	Size	Perms	Modified	Actions
images DIR	-	drwxr-xr-x	2026-07-14 10:09:12	Edit Download recursive recursive
php53 DIR	-	drwxr-xr-x	2026-07-14 10:09:12	Edit Download recursive recursive
php56 DIR	-	drwxr-xr-x	2026-07-14 10:09:12	Edit Download recursive recursive
php71 DIR	-	drwxr-xr-x	2026-07-14 10:09:12	Edit Download recursive recursive
php81 DIR	-	drwxr-xr-x	2026-07-14 10:09:12	Edit Download recursive recursive
php82 DIR	-	drwxr-xr-x	2026-07-14 10:09:12	Edit Download recursive recursive
clone.php	3.84 KB	lrw-r--r--	2026-07-14 01:40:46	Edit Download recursive recursive
db_login.php	5.72 KB	lrw-r--r--	2026-07-14 01:34:10	Edit Download recursive recursive
edit.php	5.00 KB	lrw-r--r--	2026-07-14 01:40:46	Edit Download recursive recursive
edit.xml	433 B	lrw-r--r--	2021-12-23 06:54:36	Edit Download recursive recursive
extend.php	3.69 KB	lrw-r--r--	2026-07-14 01:40:46	Edit Download recursive recursive
fileindex.php	257 B	lrw-r--r--	2026-07-14 01:34:10	Edit Download recursive recursive
import.php	3.27 KB	lrw-r--r--	2026-07-14 01:40:46	Edit Download recursive recursive
info.xml	2.55 KB	lrw-r--r--	2026-07-14 01:34:10	Edit Download recursive recursive
install.js	921 B	lrw-r--r--	2021-12-23 06:54:36	Edit Download recursive recursive
install.php	4.06 KB	lrw-r--r--	2026-07-14 01:40:46	Edit Download recursive recursive
install.xml	2.38 KB	lrw-r--r--	2024-01-30 01:54:34	Edit Download recursive recursive
md5	1007 B	lrw-r--r--	2026-07-14 01:40:46	Edit Download recursive recursive
notes.txt	249 B	lrw-r--r--	2026-07-14 01:34:10	Edit Download recursive recursive
update_pass.php	499 B	lrw-r--r--	2021-12-23 06:54:36	Edit Download recursive recursive