Posts made by rets34

@wayne-workman ```

user@server:~$ ls -laht /var/www
total 12K
drwxr-xr-x  3 root root 4.0K Sep  1 09:25 html
drwxr-xr-x  3 root root 4.0K Aug 19 10:27 .
lrwxrwxrwx  1 root root   18 Aug 19 10:27 fog -> /var/www/html/fog/
drwxr-xr-x 12 root root 4.0K Aug 18 09:58 ..
user@server:~$ ls -laht /var/www/html
total 28K
drwxr-xr-x 11 www-data www-data 4.0K Sep  1 09:25 fog
drwxr-xr-x  3 root     root     4.0K Sep  1 09:25 .
drwxr-xr-x  3 root     root     4.0K Aug 19 10:27 ..
-rw-r--r--  1 www-data www-data   52 Aug 19 10:27 index.php
-rw-r--r--  1 root     root      11K Aug 18 10:01 index.html

@sebastian-roth After Running the command and trying again:

Apache2 error.log:

AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught UnexpectedValueException: RecursiveDirectoryIterator::__construct(/var/www/html/fog/service/ipxe): failed to open dir: Permission denied in /var/www/html/fog/commons/init.php:119\nStack trace:\n#0 [internal function]: RecursiveDirectoryIterator->__construct('/var/www/html/f...', 4096)\n#1 [internal function]: RecursiveDirectoryIterator->getChildren()\n#2 [internal function]: FilterIterator->next()\n#3 /var/www/html/fog/commons/init.php(119): iterator_to_array(Object(RegexIterator), true)\n#4 /var/www/html/fog/commons/init.php(257): Initiator->__construct()\n#5 /var/www/html/fog/commons/base.inc.php(48): Initiator::startInit()\n#6 /var/www/html/fog/maintenance/backup_db.php(22): require('/var/www/html/f...')\n#7 {main}\n  thrown in /var/www/html/fog/commons/init.php on line 119'

@sebastian-roth ```

total 59736
drwx------ 2 fogproject www-data     4096 Aug 19 10:39 .
drwx------ 3 www-data   www-data     4096 Aug 19 10:39 ..
-rw-r--r-- 1 fogproject www-data     1966 Aug 19 10:39 advanced.php
-rw-r--r-- 1 fogproject www-data    16272 Aug 19 10:39 bgdark.png
-rw-r--r-- 1 fogproject www-data    21280 Aug 19 10:39 bg.png
-rw-r--r-- 1 fogproject www-data     1139 Aug 19 10:39 boot.php
-rw-r--r-- 1 fogproject www-data  8471200 Aug 19 10:39 bzImage
-rw-r--r-- 1 fogproject www-data  7870272 Aug 19 10:39 bzImage32
-rw-r--r-- 1 fogproject www-data   234697 Aug 19 10:39 grub.exe
-rw-r--r-- 1 fogproject www-data      592 Aug 19 10:39 index.php
-rw-r--r-- 1 fogproject www-data 20574204 Aug 19 10:39 init_32.xz
-rw-r--r-- 1 fogproject www-data 21161356 Aug 19 10:39 init.xz
-rw-r--r-- 1 fogproject www-data    25340 Aug 19 10:39 memdisk
-rw-r--r-- 1 fogproject www-data  1839104 Aug 19 10:39 memtest.bin
-rw-r--r-- 1 fogproject www-data   202624 Aug 19 10:39 refind_aa64.efi
-rw-r--r-- 1 fogproject www-data    29719 Aug 19 10:39 refind.conf
-rw-r--r-- 1 fogproject www-data   262592 Aug 19 10:39 refind.efi
-rw-r--r-- 1 fogproject www-data   201600 Aug 19 10:39 refind_ia32.efi
-rw-r--r-- 1 fogproject www-data   208776 Aug 19 10:39 refind_x64.efi

Debian 10:
Running installfog.sh goes well until ‘go to x.x.x.x/fog/management’
The site reports http 500 error. And apache logs show:

Got error 'PHP message: PHP Fatal error:
Uncaught UnexpectedValueException:
RecursiveDirectoryIterator::__construct(/var/www/html/fog/service/ipxe): failed to open dir
Permission denied in /var/www/html/fog/commons/init.php:119\nStack trace:\n#0 [internal function]:

@Sebastian-Roth Makes sense to me.
Solved for me

@Sebastian-Roth

I went through and pointed a couple to the old location, and it’s not showing Size?

@Tom-Elliott I was just if I had to reboot the machine for whatever reason that I wouldn’t have to worry about it failing. But the solution you posted has worked to get it working.
Now I just need to figure out how to get all my images to show up in the WebUI, got them all on the machine but don’t have an exported CSV from prior to database dying.

root@fog-desktop:/home/admin# systemctl -l status mariadb
● mariadb.service - MariaDB database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
   Active: active (running) since Thu 2020-07-30 13:37:37 CDT; 17s ago
  Process: 23218 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status
  Process: 23215 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
  Process: 23104 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_rec
  Process: 23102 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=
  Process: 23101 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0
 Main PID: 23188 (mysqld)
   Status: "Taking your SQL requests now..."
    Tasks: 29 (limit: 4915)
   CGroup: /system.slice/mariadb.service
           └─23188 /usr/sbin/mysqld

Jul 30 13:37:39 fog-desktop /etc/mysql/debian-start[23221]: Processing databases
Jul 30 13:37:39 fog-desktop /etc/mysql/debian-start[23221]: information_schema
Jul 30 13:37:39 fog-desktop /etc/mysql/debian-start[23221]: mysql
Jul 30 13:37:39 fog-desktop /etc/mysql/debian-start[23221]: performance_schema
Jul 30 13:37:39 fog-desktop /etc/mysql/debian-start[23221]: Phase 6/7: Checking and upgrading tables
Jul 30 13:37:39 fog-desktop /etc/mysql/debian-start[23221]: Processing databases
Jul 30 13:37:39 fog-desktop /etc/mysql/debian-start[23221]: information_schema
Jul 30 13:37:39 fog-desktop /etc/mysql/debian-start[23221]: performance_schema
Jul 30 13:37:39 fog-desktop /etc/mysql/debian-start[23221]: Phase 7/7: Running 'FLUSH PRIVILEGES'
Jul 30 13:37:39 fog-desktop /etc/mysql/debian-start[23221]: OK

That fixed it, however after a reboot I got ‘database connection unavailable’ again.
And back to square one with:

 Setting up and starting MySQL...............................Failed!

@Tom-Elliott

root@fog-desktop:/home/admin# systemctl -l status mariadb
● mariadb.service - MariaDB database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
   Active: activating (start) since Thu 2020-07-30 12:16:53 CDT; 34s ago
  Process: 30832 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_rec
  Process: 30829 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=
  Process: 30828 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0
 Main PID: 30916 (mysqld)
    Tasks: 26 (limit: 4915)
   CGroup: /system.slice/mariadb.service
           └─30916 /usr/sbin/mysqld

Jul 30 12:16:53 fog-desktop systemd[1]: Starting MariaDB database server...
Jul 30 12:16:53 fog-desktop mysqld[30916]: 2020-07-30 12:16:53 139648654302336 [Note] /usr/sbin/mysqld (mysqld 1
root@fog-desktop:/home/admin# ^C
root@fog-desktop:/home/admin# systemctl -l status mariadb
● mariadb.service - MariaDB database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
   Active: failed (Result: timeout) since Thu 2020-07-30 12:18:26 CDT; 50min ago
  Process: 30916 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited
  Process: 30832 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_rec
  Process: 30829 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=
  Process: 30828 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0
 Main PID: 30916 (code=exited, status=0/SUCCESS)

Jul 30 12:16:53 fog-desktop systemd[1]: Starting MariaDB database server...
Jul 30 12:16:53 fog-desktop mysqld[30916]: 2020-07-30 12:16:53 139648654302336 [Note] /usr/sbin/mysqld (mysqld 1
Jul 30 12:18:23 fog-desktop systemd[1]: mariadb.service: Start operation timed out. Terminating.
Jul 30 12:18:26 fog-desktop systemd[1]: mariadb.service: Failed with result 'timeout'.
Jul 30 12:18:26 fog-desktop systemd[1]: Failed to start MariaDB database server.
root@fog-desktop:/home/admin#

@Tom-Elliott

Attached output below.

mariadb.txt

Boot drive has 295GB free

Output of df -h:

Filesystem      Size  Used Avail Use% Mounted on
udev            3.9G     0  3.9G   0% /dev
tmpfs           791M  1.7M  789M   1% /run
/dev/sda2       292G   18G  260G   7% /
tmpfs           3.9G     0  3.9G   0% /dev/shm
tmpfs           5.0M  4.0K  5.0M   1% /run/lock
tmpfs           3.9G     0  3.9G   0% /sys/fs/cgroup
/dev/loop0      1.0M  1.0M     0 100% /snap/gnome-logs/100
/dev/loop3      2.3M  2.3M     0 100% /snap/gnome-system-monitor/148
/dev/loop1      2.5M  2.5M     0 100% /snap/gnome-calculator/730
/dev/loop14     2.5M  2.5M     0 100% /snap/gnome-calculator/748
/dev/loop5      384K  384K     0 100% /snap/gnome-characters/539
/dev/loop6      384K  384K     0 100% /snap/gnome-characters/550
/dev/loop7       94M   94M     0 100% /snap/core/9066
/dev/loop8      1.0M  1.0M     0 100% /snap/gnome-logs/93
/dev/loop10      55M   55M     0 100% /snap/core18/1754
/dev/loop9      162M  162M     0 100% /snap/gnome-3-28-1804/128
/dev/loop12      55M   55M     0 100% /snap/gtk-common-themes/1502
/dev/loop16     141M  141M     0 100% /snap/gnome-3-26-1604/98
/dev/loop19      63M   63M     0 100% /snap/gtk-common-themes/1506
/dev/loop18     2.3M  2.3M     0 100% /snap/gnome-system-monitor/145
/dev/loop13     256M  256M     0 100% /snap/gnome-3-34-1804/33
/dev/loop11      97M   97M     0 100% /snap/core/9665
/dev/loop2      256M  256M     0 100% /snap/gnome-3-34-1804/36
/dev/loop17     161M  161M     0 100% /snap/gnome-3-28-1804/116
/dev/loop4      141M  141M     0 100% /snap/gnome-3-26-1604/100
/dev/loop15      55M   55M     0 100% /snap/core18/1880
/dev/sdb1       916G  447G  424G  52% /media/admin/Storage
/dev/sdc1       916G  357G  513G  42% /images
/dev/sda1       511M  2.7M  509M   1% /boot/efi
tmpfs           791M   56K  791M   1% /run/user/1001

I will attach the output of journalctl -xe, as it is a bit of a long mess.
journalctl.txt

Ubuntu 18.04 | 4.15.0-72generic
Attempting to upgrade fog server to 1.5.9-RC2 worked fine the first time, but after a reboot I got the ‘database connection unavailable’ so I went to run installfog.sh to fix it, and was met with the following issue.
I went and ran installfog.sh and everything goes fine until the MySQL part of the installation.

* Setting up and starting MySQL...............................Failed!

I’ve tried purging MySQL and the MariDB but I keep getting the same issue.

fog_error_1.5.9-RC2.log

@Sebastian-Roth So after taking your advice on the multiple DHCP servers, I went and checked for any possible Rogue DHCP servers using Wireshark, and I found a range that is not apart of our usual subnet, was offering and broadcasting DHCP. So the issue was rogue DHCP.

The only thing that we changed on the network while the FOG server was down was we disabled Spanning Tree on one of our 10G switches.

@Sebastian-Roth I set just one server to be DHCP and still got the same results when booting a machine.

• Yes we have 3 DHCP Servers, I will confirm tomorrow that they all have the same server options across the board.

• Option 66 & 67 are the same on all of them

• 9165 pts/0 S+ 0:00 grep --color=auto -e dhcp -e dnsmasq

• Running Ubuntu 18.04 | Kernal 4.15.0-33-generic

Currently I have run into an issue where, after having my FOG server offline for a few days, everytime I go to PXE boot a machine, I get ‘Please enter TFTP’ server.
My FOG server does not handle DHCP that is by our 3 other DHCP servers.
If I have the FOG server off, the PXE menu does not appear on the computer, if it is on I get to ‘Please enter TFTP server’.
FOG was fully working before the few days I had it offline, and I have doubled checked the Option 66, 67 on my DHCP servers. I’ve tried running a wireshark and don’t see any packets going to the FOG server which is why I am confused why when FOG is offline that iPXE never appears.
I have also verified from a Windows machine with ‘tftp -i 10.227.0.222 get undionly.kpxe’ and the Transfer is successful.
If there are any questions I can answer them as needed.