Restoring from Failed VM

srussell

I host ITFlow in a Hyper-V virtual machine. The HOST failed so I moved the vhdx file to a new Hyper-V. setup exactly the same using the vhdx file. It boots no issue and I can get to the login screen.

I have renewed the Certificate for the domain, that went just fine..

But after entering the login, I get a "https://example.com is currently unable to handle this request.

HTTP ERROR 500"

hugo

srussell see in ssh wich error is

tail /var/log/apache/error.log

srussell

hugo

[Sat Jul 13 00:00:01.269484 2024] [mpm_prefork:notice] [pid 694] AH00163: Apach>

[Sat Jul 13 00:00:01.269504 2024] [core:notice] [pid 694] AH00094: Command line>

[Sat Jul 13 00:03:41.519670 2024] [php:warn] [pid 6586] [client 206.168.34.114:>

wrongecho

Nothing useful there in the logs..

Is MariaDB definitely running?

srussell

Current pager: stdout

Using outfile: ''

Using delimiter: ;

Server: MariaDB

Server version: 10.11.6-MariaDB-0+deb12u1 Debian 12

Protocol version: 10

Connection: Localhost via UNIX socket

Server characterset: utf8mb4

Db characterset: utf8mb4

Client characterset: utf8mb3

Conn. characterset: utf8mb3

UNIX socket: /run/mysqld/mysqld.sock

Uptime: 15 hours 42 min 53 sec

Threads: 2 Questions: 9802 Slow queries: 0 Opens: 43 Open tables: 36 Queries per second avg: 0.173

srussell

apache2-bin/stable,now 2.4.59-1~deb12u1 amd64 [installed,upgradable to: 2.4.61-1 ~deb12u1]

apache2-data/stable,now 2.4.59-1~deb12u1 all [installed,upgradable to: 2.4.61-1~ deb12u1]

apache2-utils/stable,now 2.4.59-1~deb12u1 amd64 [installed,upgradable to: 2.4.61 -1~deb12u1]

apache2/stable,now 2.4.59-1~deb12u1 amd64 [installed,upgradable to: 2.4.61-1~deb 12u1]

libapache2-mod-dnssd/stable,now 0.6-4 amd64 [installed,automatic]

libapache2-mod-md/stable,now 2.4.59-1~deb12u1 amd64 [installed,upgradable to: 2. 4.61-1~deb12u1]

libapache2-mod-php8.2/now 8.2.18-1~deb12u1 amd64 [installed,upgradable to: 8.2.2 0-1~deb12u1]

libapache2-mod-php/stable,now 2:8.2+93 all [installed]

php-common/stable,now 2:93 all [installed,automatic]

php-curl/stable,now 2:8.2+93 all [installed]

php-imap/stable,now 2:8.2+93 all [installed]

php-intl/stable,now 2:8.2+93 all [installed]

php-mailparse/stable,now 3.1.4+2.1.7~dev20160128-1 amd64 [installed]

php8.2-cli/now 8.2.18-1~deb12u1 amd64 [installed,upgradable to: 8.2.20-1~deb12u1 ]

php8.2-common/now 8.2.18-1~deb12u1 amd64 [installed,upgradable to: 8.2.20-1~deb1 2u1]

php8.2-curl/now 8.2.18-1~deb12u1 amd64 [installed,upgradable to: 8.2.20-1~deb12u 1]

php8.2-imap/now 8.2.18-1~deb12u1 amd64 [installed,upgradable to: 8.2.20-1~deb12u 1]

php8.2-intl/now 8.2.18-1~deb12u1 amd64 [installed,upgradable to: 8.2.20-1~deb12u 1]

php8.2-mailparse/stable,now 3.1.4+2.1.7~dev20160128-1 amd64 [installed,automatic ]

php8.2-mbstring/now 8.2.18-1~deb12u1 amd64 [installed,upgradable to: 8.2.20-1~de b12u1]

php8.2-mysql/now 8.2.18-1~deb12u1 amd64 [installed,upgradable to: 8.2.20-1~deb12 u1]

php8.2-opcache/now 8.2.18-1~deb12u1 amd64 [installed,upgradable to: 8.2.20-1~deb 12u1]

php8.2-readline/now 8.2.18-1~deb12u1 amd64 [installed,upgradable to: 8.2.20-1~de b12u1]

php8.2/now 8.2.18-1~deb12u1 all [installed,upgradable to: 8.2.20-1~deb12u1]

php/stable,now 2:8.2+93 all [installed]

python3-certbot-apache/stable,now 2.1.0-2 all [installed]

srussell

doesn't look like a SQL Error either

wrongecho

Can't say this is something I've run into much.

Out of interest, do you get the error 500 if you enter incorrect credentials too?

srussell

wrongecho

If I use the wrong login details it give me a incorrect user/password error

srussell

I think I found the cause, but no idea how to fix it. I rechecked the error.log in apache2 and this is what I see now:

[Sat Jul 13 00:00:01.269484 2024] [mpm_prefork:notice] [pid 694] AH00163: Apache/2.4.59 (Debian) OpenSSL/3.0.11 configured -- resuming normal operations

[Sat Jul 13 00:00:01.269504 2024] [core:notice] [pid 694] AH00094: Command line: '/usr/sbin/apache2'

[Sat Jul 13 00:03:41.519670 2024] [php:warn] [pid 6586] [client 206.168.34.114:53388] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71

[Sat Jul 13 00:38:43.174178 2024] [php:warn] [pid 6585] [client 118.107.220.50:50875] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71

[Sat Jul 13 00:38:44.978525 2024] [php:warn] [pid 6587] [client 23.191.80.8:48459] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71

[Sat Jul 13 00:45:26.674540 2024] [php:warn] [pid 6585] [client 185.245.84.37:43229] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71, referer: https://suppor>

[Sat Jul 13 00:45:27.292814 2024] [php:warn] [pid 6587] [client 149.88.98.69:51047] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71, referer: https://support>

[Sat Jul 13 00:45:29.560494 2024] [php:warn] [pid 6583] [client 167.88.60.235:44839] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71, referer: https://suppor>

[Sat Jul 13 00:49:24.535277 2024] [php:warn] [pid 6587] [client 147.185.132.94:59508] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71

[Sat Jul 13 01:15:20.062138 2024] [php:warn] [pid 6584] [client 205.210.31.86:64928] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71, referer: http://206.75.>

[Sat Jul 13 01:18:57.024278 2024] [php:warn] [pid 6585] [client 71.19.252.155:37723] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71, referer: https://suppor>

[Sat Jul 13 01:18:57.497493 2024] [php:warn] [pid 6587] [client 191.96.36.135:38785] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71, referer: https://suppor>

[Sat Jul 13 01:18:59.514099 2024] [php:warn] [pid 6583] [client 179.61.228.6:56969] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71, referer: https://support>

[Sat Jul 13 01:19:00.339988 2024] [php:warn] [pid 6632] [client 172.241.250.177:43347] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71, referer: https://supp>

[Sat Jul 13 01:31:17.151958 2024] [php:warn] [pid 6583] [client 191.96.36.135:46185] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71, referer: https://suppor>

[Sat Jul 13 01:54:28.325130 2024] [core:error] [pid 8431] [client 4.240.76.242:58864] AH10244: invalid URI path (/cgi-bin/.%2e/.%2e/.%2e/.%2e/.%2e/.%2e/.%2e/.%2e/.%2e/.%2e/bin/sh)

[Sat Jul 13 01:54:29.811353 2024] [core:error] [pid 8432] [client 4.240.76.242:58874] AH10244: invalid URI path (/cgi-bin/%%32%65%%32%65/%%32%65%%32%65/%%32%65%%32%65/%%32%65%%32%65/%%32%65%%32%65/%%32%65%%32%65/%%32%65%%32%65/bin/sh)

[Sat Jul 13 02:06:46.559766 2024] [php:warn] [pid 6586] [client 47.242.224.70:57268] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71, referer: https://suppor>

[Sat Jul 13 02:12:07.572790 2024] [core:error] [pid 6587] [client 57.155.64.190:54832] AH10244: invalid URI path (/cgi-bin/.%2e/.%2e/.%2e/.%2e/.%2e/.%2e/.%2e/.%2e/.%2e/.%2e/bin/sh)

[Sat Jul 13 02:12:08.926930 2024] [core:error] [pid 8431] [client 57.155.64.190:52988] AH10244: invalid URI path (/cgi-bin/%%32%65%%32%65/%%32%65%%32%65/%%32%65%%32%65/%%32%65%%32%65/%%32%65%%32%65/%%32%65%%32%65/%%32%65%%32%65/bin/sh)

[Sat Jul 13 02:35:09.761819 2024] [php:warn] [pid 6583] [client 147.185.133.4:61780] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71, referer: http://206.75.>

[Sat Jul 13 02:46:47.935407 2024] [core:error] [pid 6586] [client 8.220.202.139:52888] AH10244: invalid URI path (/cgi-bin/.%2e/.%2e/.%2e/.%2e/.%2e/.%2e/.%2e/.%2e/.%2e/.%2e/bin/sh)

[Sat Jul 13 02:46:48.773357 2024] [core:error] [pid 6584] [client 8.220.202.139:40458] AH10244: invalid URI path (/cgi-bin/%%32%65%%32%65/%%32%65%%32%65/%%32%65%%32%65/%%32%65%%32%65/%%32%65%%32%65/%%32%65%%32%65/%%32%65%%32%65/bin/sh)

[Sat Jul 13 03:59:19.583501 2024] [php:warn] [pid 6584] [client 212.102.57.167:57405] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71, referer: https://suppo>

[Sat Jul 13 03:59:39.874745 2024] [php:warn] [pid 7748] [client 212.102.57.167:59383] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71, referer: https://suppo>

[Sat Jul 13 04:00:14.895465 2024] [php:warn] [pid 8339] [client 179.61.197.168:42695] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71, referer: https://suppo>

[Sat Jul 13 04:00:35.023557 2024] [php:warn] [pid 8431] [client 179.61.197.168:47523] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71, referer: https://suppo>

[Sat Jul 13 04:01:08.829389 2024] [php:warn] [pid 6587] [client 37.120.213.169:54859] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71, referer: https://suppo>

[Sat Jul 13 04:01:30.079253 2024] [php:warn] [pid 6584] [client 37.120.213.169:34053] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71, referer: https://suppo>

[Sat Jul 13 04:02:19.925140 2024] [php:warn] [pid 6586] [client 167.94.145.102:40658] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71

[Sat Jul 13 05:43:35.828921 2024] [php:warn] [pid 10868] [client 184.105.247.195:31110] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71, referer: https://206>

[Sat Jul 13 06:16:55.910300 2024] [php:warn] [pid 6632] [client 35.203.211.241:59316] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71

[Sat Jul 13 06:18:33.593943 2024] [php:warn] [pid 8431] [client 184.105.247.195:45416] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71, referer: http://206.7>

[Sat Jul 13 06:54:41.462686 2024] [php:warn] [pid 6587] [client 198.235.24.18:63416] PHP Warning: Undefined array key "HTTP_USER_AGENT" in /var/www/support.bossknowledge.com/login.php on line 29

[Sat Jul 13 06:54:41.469340 2024] [php:warn] [pid 6587] [client 198.235.24.18:63416] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71

[Sat Jul 13 06:56:28.784884 2024] [php:warn] [pid 6632] [client 171.244.43.14:52270] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71

[Sat Jul 13 07:14:05.690385 2024] [php:warn] [pid 8431] [client 95.217.18.177:54950] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71, referer: https://suppor>

[Sat Jul 13 07:35:45.224525 2024] [php:warn] [pid 7748] [client 167.94.145.108:57326] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71

[Sat Jul 13 07:52:26.087980 2024] [php:warn] [pid 10891] [client 83.97.73.245:40872] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71, referer: https://206.75>

[Sat Jul 13 08:15:25.390822 2024] [php:warn] [pid 10868] [client 109.71.253.194:44356] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71, referer: http://examp>

[Sat Jul 13 08:15:26.454943 2024] [php:warn] [pid 6586] [client 109.71.253.194:44384] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71, referer: http://exampl>

[Sat Jul 13 08:22:38.827940 2024] [php:warn] [pid 6587] [client 104.236.72.33:27258] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71, referer: https://206.75>

[Sat Jul 13 08:52:56.959075 2024] [php:warn] [pid 10868] [client 165.232.125.178:16646] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71, referer: http://206.>

[Sat Jul 13 09:48:42.005254 2024] [php:warn] [pid 8431] [client 167.94.138.43:54322] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71

[Sat Jul 13 10:09:16.350975 2024] [php:warn] [pid 10868] [client 24.109.104.106:54926] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71, referer: https://supp>

[Sat Jul 13 10:09:16.403896 2024] [php:error] [pid 10868] [client 24.109.104.106:54926] PHP Fatal error: Uncaught mysqli_sql_exception: Unknown column 'email_cal_str' in 'field list' in /var/www/support.bossknowledge.com/functions.php:>

[Sat Jul 13 10:09:18.994028 2024] [php:warn] [pid 6632] [client 24.109.104.106:54925] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71

[Sat Jul 13 10:09:21.362911 2024] [php:warn] [pid 6632] [client 24.109.104.106:54925] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71, referer: https://suppo>

[Sat Jul 13 10:09:21.434468 2024] [php:error] [pid 6632] [client 24.109.104.106:54925] PHP Fatal error: Uncaught mysqli_sql_exception: Unknown column 'email_cal_str' in 'field list' in /var/www/support.bossknowledge.com/functions.php:1>

[Sat Jul 13 10:12:50.548014 2024] [php:warn] [pid 8433] [client 24.109.104.106:55118] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71, referer: https://suppo>

[Sat Jul 13 10:12:50.601291 2024] [php:error] [pid 8433] [client 24.109.104.106:55118] PHP Fatal error: Uncaught mysqli_sql_exception: Unknown column 'email_cal_str' in 'field list' in /var/www/support.bossknowledge.com/functions.php:1>

[Sat Jul 13 10:13:27.565545 2024] [php:warn] [pid 8339] [client 24.109.104.106:55172] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71

[Sat Jul 13 10:13:29.531469 2024] [php:warn] [pid 8339] [client 24.109.104.106:55172] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71

[Sat Jul 13 10:13:30.582122 2024] [php:warn] [pid 8339] [client 24.109.104.106:55172] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71, referer: https://suppo>

[Sat Jul 13 10:13:30.635439 2024] [php:error] [pid 8339] [client 24.109.104.106:55172] PHP Fatal error: Uncaught mysqli_sql_exception: Unknown column 'email_cal_str' in 'field list' in /var/www/support.bossknowledge.com/functions.php:1>

[Sat Jul 13 10:17:03.860720 2024] [php:warn] [pid 10868] [client 47.88.94.28:36025] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/login.php on line 71, referer: https://support>

wrongecho

So the app itself is working, doesn't seem like an issue with Apache/PHP/MariaDB on the infra side.

Go ahead and do the login, let it error out and then try and go to itflow.example.com/settings_update.php and check/run updates

srussell

Not Found

The requested URL was not found on this server.

Apache/2.4.59 (Debian) Server at support.bossknowledge.com Port 443

wrongecho

Okay so you're not on the older version, try /admin_update.php instead

srussell

wrongecho

Admin update brings me back to the login page

srussell

wrongecho

What if I run the update script from putty? would that fix the tables in the PHP files?

srussell

it looks like a corrupt install. I found a backup folder:

-rw-r--r-- 1 root root 71680 Jul 13 00:00 alternatives.tar.0

-rw-r--r-- 1 root root 4225 Jan 27 00:00 alternatives.tar.1.gz

-rw-r--r-- 1 root root 4220 Dec 8 2023 alternatives.tar.2.gz

-rw-r--r-- 1 root root 91193 May 26 10:47 apt.extended_states.0

-rw-r--r-- 1 root root 10110 Jan 26 10:33 apt.extended_states.1.gz

-rw-r--r-- 1 root root 10092 Dec 7 2023 apt.extended_states.2.gz

-rw-r--r-- 1 root root 0 Jul 13 00:00 dpkg.arch.0

-rw-r--r-- 1 root root 32 Jan 27 00:00 dpkg.arch.1.gz

-rw-r--r-- 1 root root 32 Dec 8 2023 dpkg.arch.2.gz

-rw-r--r-- 1 root root 237 Dec 7 2023 dpkg.diversions.0

-rw-r--r-- 1 root root 147 Dec 7 2023 dpkg.diversions.1.gz

-rw-r--r-- 1 root root 147 Dec 7 2023 dpkg.diversions.2.gz

-rw-r--r-- 1 root root 209 Dec 7 2023 dpkg.statoverride.0

-rw-r--r-- 1 root root 171 Dec 7 2023 dpkg.statoverride.1.gz

-rw-r--r-- 1 root root 171 Dec 7 2023 dpkg.statoverride.2.gz

-rw-r--r-- 1 root root 1629830 May 26 10:57 dpkg.status.0

-rw-r--r-- 1 root root 393172 Jan 26 10:35 dpkg.status.1.gz

-rw-r--r-- 1 root root 393111 Dec 7 2023 dpkg.status.2.gz

but I honestly have no idea what to do with it.

wrongecho

@srussell

I'm not convinced the issue is the app/database being out of date. Were you fully up to date at the time the host died?

srussell

wrongecho

Why can't I pm you.. lol

srussell

yes I had done a update a day or so before

wrongecho

This is a little puzzling to me. Assuming you just imported the VHDX you shouldn't be getting issues like this.

The only thing I can think is that you've run a git pull and are outstanding database updates?

PM creation is turned off for standard users as this is the public support forum - we have the donator support for private queries. What did you want to PM?

srussell

wrongecho

Was going to let you poke around. I haven't run any git or update commands. just restored the vhdx and turned it on.

How much is paid support?