Sophos UTM failes to boot – Postgres SQL Schema Update

After upgrading the Sophos UTM in my home lab the VM didnt boot anymore. The following message was visible on the console:

Starting PostgreSQLpg_ctl: could not start server
Examine the log output.
/usr/local/bin/pg92_schemaupgrade[3679]: Found schema upgrade files: /var/storage/pgsql92/upgrade_NUTM-5561.sh
/usr/local/bin/pg92_schemaupgrade[3679]: Wait 15 seconds for postgres to be ready
/usr/local/bin/pg92_schemaupgrade[3679]: psql: could not connect to server: No such file or directory
/usr/local/bin/pg92_schemaupgrade[3679]: Is the server running locally and accepting
/usr/local/bin/pg92_schemaupgrade[3679]: connection on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

2017-07-01 14_47_37-_UTM01_ auf _JMZBOOK_ - Verbindung mit virtuellen Computern

The UTM was not accessible with the management ip address.

Steps to get your UTM back to life

1.) Press the “Esc” button during the boot procedure.

2.) Select “Sophos UTM 9.x” and press the “e” button.

2017-07-01 15_05_45-_UTM01_ auf _JMZBOOK_ - Verbindung mit virtuellen Computern

3.) Select “kernel” mode and press the “e” button

2017-07-01 15_06_04-_UTM01_ auf _JMZBOOK_ - Verbindung mit virtuellen Computern

4.) Put the following command “init=/bin/bash” and press enter.

2017-07-01 15_07_13-_UTM01_ auf _JMZBOOK_ - Verbindung mit virtuellen Computern

5.) Now press the “b” key to boot up the UTM.

6.) Navigate to the path “/usr/local/bin” and delete the file “pg92_schemaupgrade”.

"rm pg92_schemaupgrade -f"

2017-07-01 15_47_11-_UTM01_ auf _JMZBOOK_ - Verbindung mit virtuellen Computern

7.) Reboot the VM and the UTM should be back online.

Why was the update not successful?

After inspecting the dashboard I realized the data disk was fully occupied. Thats why the update was crashing…

2017-07-01 15_53_26-WebAdmin - User admin - Device utm01.lab.local

The easiest way to expand the partition is to boot with the GParted Live CD.

2017-07-02 14_05_05-_UTM01_ auf _JMZBOOK_ - Verbindung mit virtuellen Computern

Lets try the update again…

2017-07-02 14_10_48-Up2Date Installation Progress

What about our “storage” partition? Looks fine 🙂

2017-07-02 14_10_37-_UTM01_ auf _JMZBOOK_ - Verbindung mit virtuellen Computern

Reminder for myself. Check the data partition before the next update. Even its not a productive system 💡

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

Up ↑

%d bloggers like this: