Error accessing DB list 500 Internal error

1

Hi, I can’t access the db list as admin user but can access all other lists like web,DNS.

Error message in /var/log/hestia/nginx-error.log

" Fatal error : Uncaught TypeError: ksort(): Argument #1 ($array) must be of type array, null given in /usr/local/hestia/web/list/db/index.php:12 Stack trace: #0 /usr/local/hestia/web/list/db/index.php(12): ksort() #1 {main} thrown in /usr/local/hestia/web/list/db/index.php on line 12"

My db/index.php file is

<?php $TAB = "DB"; // Main include include $_SERVER["DOCUMENT_ROOT"] . "/inc/main.php"; // Data exec(HESTIA_CMD . "v-list-databases $user json", $output, $return_var); $data = json_decode(implode("", $output), true); if ($_SESSION["userSortOrder"] == "name") { ksort($data); } else { $data = array_reverse($data, true); } unset($output); // Render page render_page($user, $TAB, "list_db"); // Back uri $_SESSION["back"] = $_SERVER["REQUEST_URI"]; Can somebody help me.
2 
v-list-databases admin json

It should return a valid json file

3

It gives a valid json file as you said.

4

This is the error message that i got still " Fatal error : Uncaught TypeError: ksort(): Argument #1 ($array) must be of type array, null given in /usr/local/hestia/web/list/db/index.php:12 Stack trace: #0 /usr/local/hestia/web/list/db/index.php(12): ksort() #1 {main} thrown in /usr/local/hestia/web/list/db/index.php on line 12 "

5

We run json decode:

The line before and if the json it self is invalid it gives an error

1 Like
6

As @eris said, seems json is not valid.

Could you please show the output of this command?

v-list-databases admin json | cat -A

I’m looking for characters like ^I, ^M, etc.

7

Hi, This is what i got while executing that command,

{$
    "admin_hideco": {$
        "DATABASE": "admin_hideco",$
        "DBUSER": "admin_hidecou",$
        "HOST": "localhost",$
        "TYPE": "mysql",$
        "CHARSET": "UTF8MB4",$
        "U_DISK": "28",$
        "SUSPENDED": "no",$
        "TIME": "08:27:15",$
        "DATE": "2023-06-27"$
    },$
    "admin_wyrcrm": {$
        "DATABASE": "admin_wyrcrm",$
        "DBUSER": "admin_wyrcrmu",$
        "HOST": "localhost",$
        "TYPE": "mysql",$
        "CHARSET": "UTF8MB4",$
        "U_DISK": "4",$
        "SUSPENDED": "no",$
        "TIME": "10:02:13",$
        "DATE": "2023-06-27"$
    },$
    "admin_eve-crm": {$
        "DATABASE": "admin_eve-crm",$
        "DBUSER": "admin_eve-crmu",$
        "HOST": "localhost",$
        "TYPE": "mysql",$
        "CHARSET": "UTF8MB4",$
        "U_DISK": "12",$
        "SUSPENDED": "no",$
        "TIME": "15:22:34",$
        "DATE": "2023-07-01"$
    },$
    "admin_eve-vnu": {$
        "DATABASE": "admin_eve-vnu",$
        "DBUSER": "admin_eve-vnuu",$
        "HOST": "localhost",$
        "TYPE": "mysql",$
        "CHARSET": "UTF8MB4",$
        "U_DISK": "9",$
        "SUSPENDED": "no",$
        "TIME": "18:24:10",$
        "DATE": "2023-07-04"$
    },$
    "admin_demeve": {$
        "DATABASE": "admin_demeve",$
        "DBUSER": "admin_demeveu",$
        "HOST": "localhost",$
        "TYPE": "mysql",$
        "CHARSET": "UTF8MB4",$
        "U_DISK": "30",$
        "SUSPENDED": "no",$
        "TIME": "07:59:58",$
        "DATE": "2023-07-05"$
    },$
    "admin_evefun": {$
        "DATABASE": "admin_evefun",$
        "DBUSER": "admin_evefunu",$
        "HOST": "localhost",$
        "TYPE": "mysql",$
        "CHARSET": "UTF8MB4",$
        "U_DISK": "23",$
        "SUSPENDED": "no",$
        "TIME": "15:34:29",$
        "DATE": "2023-07-06"$
    },$
    "admin_pginfo": {$
        "DATABASE": "admin_pginfo",$
        "DBUSER": "admin_pginfou",$
        "HOST": "localhost",$
        "TYPE": "mysql",$
        "CHARSET": "UTF8MB4",$
        "U_DISK": "24",$
        "SUSPENDED": "no",$
        "TIME": "09:59:09",$
        "DATE": "2023-07-20"$
    },$
    "admin_dm1evefun": {$
        "DATABASE": "admin_dm1evefun",$
        "DBUSER": "admin_dm1evefunu",$
        "HOST": "localhost",$
        "TYPE": "mysql",$
        "CHARSET": "UTF8MB4",$
        "U_DISK": "8",$
        "SUSPENDED": "no",$
        "TIME": "12:54:15",$
        "DATE": "2023-08-03"$
    },$
    "admin_crmevefun": {$
        "DATABASE": "admin_crmevefun",$
        "DBUSER": "admin_crmevefunu",$
        "HOST": "localhost",$
        "TYPE": "mysql",$
        "CHARSET": "UTF8MB4",$
        "U_DISK": "12",$
        "SUSPENDED": "no",$
        "TIME": "05:26:03",$
        "DATE": "2023-08-07"$
    },$
    "admin_wedevefun": {$
        "DATABASE": "admin_wedevefun",$
        "DBUSER": "admin_wedevefunu",$
        "HOST": "localhost",$
        "TYPE": "mysql",$
        "CHARSET": "UTF8MB4",$
        "U_DISK": "4",$
        "SUSPENDED": "no",$
        "TIME": "17:20:21",$
        "DATE": "2023-08-31"$
    },$
    "admin_sudnet": {$
        "DATABASE": "admin_sudnet",$
        "DBUSER": "admin_sudnetu",$
        "HOST": "localhost",$
        "TYPE": "mysql",$
        "CHARSET": "UTF8MB4",$
        "U_DISK": "1",$
        "SUSPENDED": "no",$
        "TIME": "06:08:04",$
        "DATE": "2023-09-07"$
    },$
    "admin_myadinfo": {$
        "DATABASE": "admin_myadinfo",$
        "DBUSER": "admin_myadinfou",$
        "HOST": "localhost",$
        "TYPE": "mysql",$
        "CHARSET": "UTF8MB4",$
        "U_DISK": "28",$
        "SUSPENDED": "no",$
        "TIME": "02:09:06",$
        "DATE": "2023-09-19"$
    },$
    "admin_paysudnet": {$
        "DATABASE": "admin_paysudnet",$
        "DBUSER": "admin_paysudnetu",$
        "HOST": "localhost",$
        "TYPE": "mysql",$
        "CHARSET": "UTF8MB4",$
        "U_DISK": "1",$
        "SUSPENDED": "no",$
        "TIME": "07:47:22",$
        "DATE": "2023-09-20"$
    },$
    "admin_cardevefun": {$
        "DATABASE": "admin_cardevefun",$
        "DBUSER": "admin_cardevefunu",$
        "HOST": "localhost",$
        "TYPE": "mysql",$
        "CHARSET": "UTF8MB4",$
        "U_DISK": "6",$
        "SUSPENDED": "no",$
        "TIME": "07:19:25",$
        "DATE": "2023-09-21"$
    },$
    "admin_crdsevefun": {$
        "DATABASE": "admin_crdsevefun",$
        "DBUSER": "admin_crdsevefunu",$
        "HOST": "localhost",$
        "TYPE": "mysql",$
        "CHARSET": "UTF8MB4",$
        "U_DISK": "6",$
        "SUSPENDED": "no",$
        "TIME": "21:48:35",$
        "DATE": "2023-09-22"$
    },$
    "admin_dyrbill": {$
        "DATABASE": "admin_dyrbill",$
        "DBUSER": "admin_dyrbillu",$
        "HOST": "localhost",$
        "TYPE": "mysql",$
        "CHARSET": "UTF8MB4",$
        "U_DISK": "6",$
        "SUSPENDED": "no",$
        "TIME": "09:05:26",$
        "DATE": "2023-09-23"$
    },$
    "admin_demsudnet": {$
        "DATABASE": "admin_demsudnet",$
        "DBUSER": "admin_demsudnetu",$
        "HOST": "localhost",$
        "TYPE": "mysql",$
        "CHARSET": "UTF8MB4",$
        "U_DISK": "16",$
        "SUSPENDED": "no",$
        "TIME": "08:20:41",$
        "DATE": "2023-09-26"$
    },$
    "admin_datawyrcom": {$
        "DATABASE": "admin_datawyrcom",$
        "DBUSER": "admin_datawyrcomu",$
        "HOST": "localhost",$
        "TYPE": "mysql",$
        "CHARSET": "UTF8MB4",$
        "U_DISK": "20",$
        "SUSPENDED": "no",$
        "TIME": "10:16:37",$
        "DATE": "2023-09-30"$
    },$
    "admin_maildatcom": {$
        "DATABASE": "admin_maildatcom",$
        "DBUSER": "admin_maildatcomu",$
        "HOST": "localhost",$
        "TYPE": "mysql",$
        "CHARSET": "UTF8MB4",$
        "U_DISK": "8",$
        "SUSPENDED": "no",$
        "TIME": "12:05:42",$
        "DATE": "2023-10-01"$
    },$
    "admin_mycevefun": {$
        "DATABASE": "admin_mycevefun",$
        "DBUSER": "admin_mycevefunu",$
        "HOST": "localhost",$
        "TYPE": "mysql",$
        "CHARSET": "UTF8MB4",$
        "U_DISK": "1",$
        "SUSPENDED": "no",$
        "TIME": "06:47:11",$
        "DATE": "2023-10-05"$
    },$
    "admin_appdatcom": {$
        "DATABASE": "admin_appdatcom",$
        "DBUSER": "admin_appdatcomu",$
        "HOST": "localhost",$
        "TYPE": "mysql",$
        "CHARSET": "UTF8MB4",$
        "U_DISK": "1",$
        "SUSPENDED": "no",$
        "TIME": "07:13:30",$
        "DATE": "2023-10-07"$
    },$
    "admin_dm2evefun": {$
        "DATABASE": "admin_dm2evefun",$
        "DBUSER": "admin_dm2evefunu",$
        "HOST": "localhost",$
        "TYPE": "mysql",$
        "CHARSET": "UTF8MB4",$
        "U_DISK": "5",$
        "SUSPENDED": "no",$
        "TIME": "04:06:18",$
        "DATE": "2023-10-10"$
    },$
    "admin_dm1datcom": {$
        "DATABASE": "admin_dm1datcom",$
        "DBUSER": "admin_dm1datcomu",$
        "HOST": "localhost",$
        "TYPE": "mysql",$
        "CHARSET": "UTF8MB4",$
        "U_DISK": "7",$
        "SUSPENDED": "no",$
        "TIME": "13:12:15",$
        "DATE": "2023-10-11"$
    },$
    "admin_elesalon": {$
        "DATABASE": "admin_elesalon",$
        "DBUSER": "admin_elesalonu",$
        "HOST": "localhost",$
        "TYPE": "mysql",$
        "CHARSET": "UTF8MB4",$
        "U_DISK": "47",$
        "SUSPENDED": "no",$
        "TIME": "14:12:12",$
        "DATE": "2023-10-13"$
    },$
    "admin_juscoin": {$
        "DATABASE": "admin_juscoin",$
        "DBUSER": "admin_juscoinu",$
        "HOST": "localhost",$
        "TYPE": "mysql",$
        "CHARSET": "UTF8MB4",$
        "U_DISK": "11",$
        "SUSPENDED": "no",$
        "TIME": "04:53:17",$
        "DATE": "2023-10-29"$
    },$
    "admin_emlevefun": {$
        "DATABASE": "admin_emlevefun",$
        "DBUSER": "admin_emlevefunu",$
        "HOST": "localhost",$
        "TYPE": "mysql",$
        "CHARSET": "UTF8MB4",$
        "U_DISK": "9",$
        "SUSPENDED": "no",$
        "TIME": "04:55:11",$
        "DATE": "2023-11-16"$
    },$
    "admin_elecrm": {$
        "DATABASE": "admin_elecrm",$
        "DBUSER": "admin_elecrmu",$
        "HOST": "localhost",$
        "TYPE": "mysql",$
        "CHARSET": "UTF8MB4",$
        "U_DISK": "2",$
        "SUSPENDED": "no",$
        "TIME": "08:48:42",$
        "DATE": "2023-12-01"$
    },$
    "admin_inevefun": {$
        "DATABASE": "admin_inevefun",$
        "DBUSER": "admin_inevefunu",$
        "HOST": "localhost",$
        "TYPE": "mysql",$
        "CHARSET": "UTF8MB4",$
        "U_DISK": "5",$
        "SUSPENDED": "no",$
        "TIME": "16:24:41",$
        "DATE": "2023-12-05"$
    },$
    "admin_elepos": {$
        "DATABASE": "admin_elepos",$
        "DBUSER": "admin_eleposu",$
        "HOST": "localhost",$
        "TYPE": "mysql",$
        "CHARSET": "UTF8MB4",$
        "U_DISK": "3",$
        "SUSPENDED": "no",$
        "TIME": "13:51:05",$
        "DATE": "2023-12-07"$
    }$
    "admin_elepos": {$
        "DATABASE": "admin_elepos",$
        "DBUSER": "admin_eleposu",$
        "HOST": "localhost",$
        "TYPE": "mysql",$
        "CHARSET": "UTF8MB4",$
        "U_DISK": "3",$
        "SUSPENDED": "no",$
        "TIME": "13:51:05",$
        "DATE": "2023-12-07"$
    }$
}$
8

The output format is wrong, there is a missing comma separator on the last block (also, that block is duplicated).

Show the output of:

grep -i admin_elepos /usr/local/hestia/data/users/admin/db.conf

9

@sahsanu Sorry, I have reset the server and re-installed Hestia because I am running out of time. Thanks for your support.