Posts made by Arrowtron

@Sebastian-Roth

Yes found this Wiki when I was migrating, thank you

@Sebastian-Roth

Yes i ran

apt-get remove mariadb-client mariadb-server

Didn’t try this command, it might have helped for the unmet dependencies problem

killall -9 mysqld

Yes i have some SQL backup’s from previous upgrade which I have restored onto a new server (just had to change IP’s etc which is fine)
It’s on a virtual machine where as physical before, snapshots will come in handy for next time!

Yes ran the apt --fix broken install and got the unmet dependencies for mysql errors. Didn’t have the time to keep looking into it

All goods, thanks for your help though!

@Sebastian-Roth said in FOG 1.5.7 Update Database Issue:

/var/lib/mysql

Thanks for the reply,

I get this when i run the command
apt-get install mysql-client mysql-server

There is a MySQL server running, but we failed in our attempts to stop it.
Stop it yourself and try again!

Tried a few commands found doing a web search that didn’t help
apt --fix-broken install

Failed to stop mysql.service: Unit mysql.service not loaded.
invoke-rc.d: initscript mysql, action "stop" failed.
invoke-rc.d returned 5
There is a MySQL server running, but we failed in our attempts to stop it.
Stop it yourself and try again!
dpkg: error processing archive /var/cache/apt/archives/mysql-server-5.7_5.7.27-0ubuntu0.18.04.1_amd64.deb (--unpack):
 new mysql-server-5.7 package pre-installation script subprocess returned error exit status 1
Errors were encountered while processing:
 /var/cache/apt/archives/mysql-server-5.7_5.7.27-0ubuntu0.18.04.1_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)

install mysql-client mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
mysql-client is already the newest version (5.7.27-0ubuntu0.18.04.1).
mysql-server is already the newest version (5.7.27-0ubuntu0.18.04.1).
You might want to run 'apt --fix-broken install' to correct these.
The following packages have unmet dependencies:
 mysql-server : Depends: mysql-server-5.7 but it is not going to be installed
E: Unmet dependencies. Try 'apt --fix-broken install' with no packages (or specify a solution).

=Update=
accidentally ran command sudo rm -rvf /var/lib
(thought i was typing in a new line, working too quick, was backing up mysql and purging etc) Going to start a fresh i think

@Arrowtron

Update, just refreshed the page and loaded into this

clicked Install/update now and can now see the dashboard, looks very empty. I will look more into this tomorrow

@Sebastian-Roth

These are my results below:

mariadb.service - MariaDB 10.1.40 database server
  Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
  Active: active (running) since Mon 2019-08-05 16:50:56 AEST; 9min ago
    Docs: man:mysqld(8)
          https://mariadb.com/kb/en/library/systemd/
Main PID: 22323 (mysqld)
  Status: "Taking your SQL requests now..."
   Tasks: 34 (limit: 4419)
  CGroup: /system.slice/mariadb.service
          └─22323 /usr/sbin/mysqld

drwxr-xr-x  4 mysql     mysql     4096 Aug  5 16:50 mysql
drwx------  6 mysql     mysql     4096 Aug  5 15:25 mysql-5.7
drwx------  2 mysql     mysql     4096 Oct 28  2018 mysql-files
drwx------  2 mysql     mysql     4096 Mar  7  2017 mysql-keyring

updated from 1.5.6 to 1.5.7, get the same issue as everyone is describing
changed to dev branch 1.5.7.2 re-installed to see if it would fix it. still the same

I am able to get into MariaDB with mysql -u root -p

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 28366
Server version: 10.1.40-MariaDB-0ubuntu0.18.04.1 Ubuntu 18.04

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> Ctrl-C -- exit!
Aborted

I have backup’s here, but not quite sure how to restore them so the installation works

/home/fogDBbackups

@arrowtron

Update:

@Sebastian-Roth Post about editing \root\fogproject\lib\common\functions.sh has fixed the issue

Thanks!

Hi there,

I am getting the same issue as well, please assist

Currently running FOG 1.5.0, trying to upgrade to 1.5.2 through PUTTY

I am not running through a Proxy, i have upgraded to 1.5.0 a few weeks ago i think

@sebastian-roth said in DBAN FOG Boot Menu:

kernel ${boot-url}/dban/dban.bzi nuke=“dwipe --autonuke --method quick” silent vga=785
boot || goto MENU

Ah of course!
I have tried all the commands above and this one worked well!

kernel ${boot-url}/dban/dban.bzi nuke="dwipe --autonuke --method quick" silent vga=785
boot || goto MENU

Yes may need to update the Wiki! Thanks for your replies and assistance!

@wayne-workman @Sebastian-Roth

http://${fog-ip}/dban/dban.bzi nuke="dwipe --autonuke --method quick" silent vga=785
${boot-ip}/dban/dban.bzi nuke="dwipe --autonuke --method quick" silent vga=785

Both give me this error message pretty much

dban.bzi and other files are defiantly listed under - http://awh-wc-fog/fog/dban/
’

Here is the tcpdump @Sebastian-Roth
https://www.dropbox.com/s/j8x6y88m1bickbp/dban.pcap?dl=0

Thanks for your Advanced Menu @x23piracy. I tried to select a portion of the code to use but it didn’t work well
’
’

Ive placed this in the DBAN iPXE Menu item Parameters

:dban
initrd http://${fog-ip}/iso/dban_2.3.0.iso
chain memdisk iso raw ||

@sebastian-roth I have placed the iso in this directory

/iso/dban.iso

executed this code below:

mount -t iso9660 -o loop /iso/dban.iso /var/www/html/dban

After that command it shows up like so:

Server

• FOG Version: 1.4.4
• OS: Ubuntu 16.10

Client

• Service Version:
• OS:

Description

Hello,

I have been trying to add Darik’s Boot and Nuke HDD Wipe on the fog iPXE menu and I have been getting some issues as described below:

Note: this was before i upgraded to 1.4.4, was on 1.4.2

I have upgraded Fog to 1.4.4. It gets past the screenshot above and just shows a black screen with a blinking underscore at the top left of the monitor and doesn’t go any further.

I have followed the instructions in this link:
https://wiki.fogproject.org/wiki/index.php?title=Include_any_ISO_in_the_FOG_Bootmenu

Any help will be greatly appreciated

@Tom-Elliott

Very good, fantastic!
Re-insalled using the existing installfog.sh - did its thing (checked packages, database scheme etc.)

cd /root/fogproject/bin
./installfog.sh

WOL and postdriver scripts seem to be working again!
Thanks! I shall run this command below so it doesn’t happen again until I am prepared to get Ubuntu updates.

apt-get -y remove unattended-upgrades

@Tom-Elliott

Thanks for your reply, yes, I have had a read around and my issue is 100% todo with Ubuntu updates. In my case your SQL root blank password code didn’t work. Do you think if I gave the SQL root password a password other then black would it fix it or won’t change? If so how should I do that?

If I re-install will it overwrite the existing database (current settings, hosts, groups and listed images)

Thanks for the link, yes tried that,
I followed the steps and got this result:

Query Ok, 0 Rows affected

Is that ok?

I ran this command as well
apt-get -y remove unattended-upgrades

Restarted the FOG server and issue still remains (tested Wake on LAN function)

Server

• FOG Version: 1.3.4
• OS: Ubuntu 16.10

Client

• Service Version:
• OS:

Description

Hi there,

I am trying to work out an issue with my FOG installation. It has been working extremely well for the past couple of months and just over the weekend, returning to work, I noticed the postdownloadscripts were not working (not transferring the drivers across). It was working last week.

Then I discovered that the Wake on LAN function was not working (was working last week without issue)
This has happened before in the past when the WOL stopped working, I ended up creating a new FOG server which was the easiest solution at the time.
These issues must be related somehow.

Has anyone else had this issue before?
I am not aware of any changes that have been made to the configuration. Where is the best place I should start looking and I shall provide logs/settings.

Any assistance is greatly appreciated

@george1421

Sorry for late reply, thanks heaps that did the job!

Server

• FOG Version: 1.3.4
• OS: Ubuntu Server 16.10 amd64

Client

• Service Version:
• OS: Windows 7 x64

Description

Hello,

I am trying to follow a couple threads regarding installing drivers after post image deployment.

Such as:
https://forums.fogproject.org/topic/4278/utilizing-postscripts-rename-joindomain-drivers-snapins/21?page=2
Examined and tried a couple of the scripts in this thread and I seemed to be getting:

/images/postdownloadscripts/fog.postdownload: line 2: syntax error near unexpected token ‘$‘in/r’’
/images/postdownloadscripts/fog.postdownload: line 2: 'case $osid in

/images/postdownloadscripts/fog.postdownload: line 19: syntax error near unexpcted token ‘fi’
/images/postdownloadscripts/fog.postdownload: line 19: ‘fi’
(I have checked the text file to see if there are any spaces at the end of the file) this is the main error message I get when I try scripts shown in threads listed

And:
https://forums.fogproject.org/topic/7391/deploying-a-single-golden-image-to-different-hardware-with-fog/4
Pasted the script in step 3 into the fog.postdownload script and gets:

/images/postdownloadscripts/fog.postdownload: line 3: $’\r’: command not found
/images/postdownloadscripts/fog.postdownload: line 46: syntax error: unexpected end of file

Are all these error messages related? Or is something not configured properly, perhaps permissions?
Or is there a better way of putting drivers into a deployed image so it is automated/detected by the model of the PC?

Any assistance is greatly appreciated!

Kind regards