Solve WSUS error: Unable to open the physical file “C:\Windows\WID\Data\SUSDB.mdf”

If for some reason during the first initialization of the WSUS you get this error because the SUSDB database is missing you can fix it by removing the WSUS Role from the Server Manager Dashboard, and also remove the internal Windows database using this command in Powershell:

uninstall-windowsfeature -name windows-internal-database

After a reboot install the WSUS Role again and you’re done.

Zabbix reset Admin password

To reset the Admin password of Zabbix connect to the SQL console:
[root@zbx01 ~]# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 238
Server version: 5.5.60-MariaDB MariaDB Server

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)]> use zabbix;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [zabbix]> update zabbix.users set passwd=md5('newpass') where alias='Admin';
Query OK, 0 rows affected (0.11 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Suse Enterprise upgrade from 11 SP4 to 12 SP3 – Error with LVM partitions

If you’re upgrading from Suse Enterprise Server 11 SP4 to 12 SP3 and you get this error:

Some partitions in the system on /dev/XdYZ are mounted by kernel-device name. This is not reliable for the update since kernel-device names are unfortunately not persistent. It is strongly recommended to start the old system and change the mount-by method to any other method for all partitions.

Follow the Suse kb 7003734: