forum.proximacentauri.org

Install Ubuntu 18.04
Configure it to have no hardware errors.
Configure user accounts and remote access to it.
Install Webmin, Virtualmin and Cloudmin,
Install and run xrdp
Install necessary tools,
Install VMware Workstation and configure a virtual machine for the old Resurrection windows 2k8R2.
Install SQL servers:
MySQL
MSSQL 14
Postgres12
Oracle18c

Install Ubuntu 18.04

Initially:
uname -a reporting Linux 5.0.0-37-generic
lsb_release -a : Ubuntu 18.04.3 LTS bionic

EDAC amd64: Error: F0 not found, device 0x1460 (broken BIOS?)

Install ukuu https://linuxhint.com/upgrade-kernel-ubuntu-1804/

sudo apt-get install ukuu
Install kernel 5.3.9 yo fix the nvme 0000:03:00.0: aer_status: 0x00003000, aer_mask: 0x00006000
Resolve kernel error:
nvme 0000:03:00.0: AER: aer_status: 0x00003000, aer_mask: 0x00006000
go back to eth0 notation https://www.itzgeek.com/how-tos/mini-howtos/change-default-network-name-ens33-to-old-eth0-on-ubuntu-16-04.html
sudo nano /etc/default/grub
GRUB_CMDLINE_LINUX="net.ifnames=0 biosdevname=0"
sudo grub-mkconfig -o /boot/grub/grub.cfg
sudo nano /etc/network/interface
sudo nano //etc/systemd/resolved.conf

sudo apt install net-tools
sudo apt install htop
sudo apt install gcc

save partition information: sudo sfdisk -d /dev/nvme1n1 > /Public/nvme1n1.partition.table.2020_01_02.txt

restore partition information: sudo sfdisk -f /dev/nvme1n1 < /media/usb/nvme1n1.partition.table.2020_01_02.txt

System program problem detected
sudo ls -l /var/crash
https://itsfoss.com/how-to-fix-system-program-problem-detected-ubuntu/

https://community.spiceworks.com/how_to/155718-install-xrdp-on-ubuntu-18-04
http://c-nergy.be/blog/?p=13667
The xRDP client doesn't work while the user is logged-in on the console!
sudo adduser newuser
https://c-nergy.be/blog/?p=13390
sudo apt-get install xorgxrdp
sudo apt-get install xserver-xorg-core
sudo apt-get -y install xserver-xorg-input-all
sudo apt-get install xrdp
sudo apt-get install xserver-xorg-core
sudo apt-get -y install xserver-xorg-input-all
sudo apt-get install xorgxrdp
sudo apt-get -y install xserver-xorg-input-all

https://askubuntu.com/questions/1031519/xrdp-on-ubuntu-18-04lts
xRDP – The Infamous “Authentication Required to Create Managed Color Device” Explained
https://c-nergy.be/blog/?p=12073

Disrupts the GDBus. See: https://askubuntu.com/questions/1039958/error-instead-of-password-prompt-when-admin-privileges-needed

sudo systemctl enable xrdp
sudo systemctl status xrdp
sudo systemctl restart xrdp

Webmin: https://www.digitalocean.com/community/tutorials/how-to-install-webmin-on-ubuntu-18-04
sudo nano /etc/apt/sources.list
deb http://download.webmin.com/download/repository sarge contrib
wget http://www.webmin.com/jcameron-key.asc
sudo apt-key add jcameron-key.asc
sudo apt update
sudo apt install webmin
https://localhost:10000

Virtualmin: https://websiteforstudents.com/install-webmin-virtualmin-on-ubuntu-16-04-18-04-lts/
curl -O http://software.virtualmin.com/gpl/scripts/install.sh
sudo chmod +x install.sh
sudo ./install.sh

Cloudmin: https://www.virtualmin.com/documentation/cloudmin/gpl
http://cloudmin.virtualmin.com/gpl/scripts/cloudmin-kvm-debian-install.sh
Patch the script with qemu-kvm
sh cloudmin-kvm-debian-install.sh

sudo nano /etc/network/interfaces
iface br1 inet static
address 192.168.1.1
netmask 255.255.255.0
broadcast 192.168.1.255
network 192.168.1.0
pre-up brctl addbr br1

sudo /etc/init.d/networking restart

ifup br1

oracle account pwd: oracle_AMihail0
https://www.oracle.com/database/technologies/oracle18c-linux-180000-downloads.html
https://askubuntu.com/questions/1121649/how-to-install-oracle-18c-enterprise-edition-on-ubuntu-18-04
https://oracledbwr.com/step-by-step-oracle-19c-installation-on-linux/

https://computingforgeeks.com/install-postgresql-12-on-ubuntu/
sudo apt update
sudo apt -y install vim bash-completion wget
sudo apt -y upgrade

wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
echo "deb http://apt.postgresql.org/pub/repos/apt/ `lsb_release -cs`-pgdg main" |sudo tee /etc/apt/sources.list.d/pgdg.list
sudo apt update
sudo apt -y install postgresql-12 postgresql-client-12
systemctl status postgresql.service
systemctl status postgresql@12-main.service
systemctl is-enabled postgresql
sudo su - postgres
psql -c "alter user postgres with password 'Sql0Admin'"
psql
sudo nano /etc/postgresql/12/main/postgresql.conf
listen_addresses = '*'
sudo systemctl restart postgresql
netstat -tunelp | grep 5432


https://computingforgeeks.com/how-to-install-pgadmin-4-on-ubuntu/

https://computingforgeeks.com/how-to-install-ms-sql-on-ubuntu/

Code: Select all

sudo wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
[code]sudo add-apt-repository  "$(wget -qO-  https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2017.list)"[/code]
sudo apt-get update
sudo apt install libcurl3
sudo apt install openssl
sudo apt install libc++1 gdb libsss-nss-idmap0 libsasl2-modules-gssapi-mit
sudo apt-get install mssql-server=14.0.3192.2-2

wget http://archive.ubuntu.com/ubuntu/pool/main/o/openssl/openssl_1.0.2g-1ubuntu4_amd64.deb
sudo dpkg -i openssl_1.0.2g-1ubuntu4_amd64.deb
apt-get -y install mssql-server

/opt/mssql/bin/mssql-conf setup

2 - developer
systemctl status mssql-server.service

sudo apt install curl
curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list | sudo tee /etc/apt/sources.list.d/msprod.list
sudo apt-get update
sudo ACCEPT_EULA=Y apt-get -y install mssql-tools
sudo apt-get install unixodbc-dev

echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc

sqlcmd -S 127.0.0.1 -U SA
create database testDB;

prevent the mssql-server=14.0.3192.2-2 from upgrading to 15:
sudo apt-mark hold mssql-server
sudo apt-mark showhold

https://www.vmware.com/go/getworkstation-linux
https://vitux.com/how-to-install-vmware-workstation-on-ubuntu/

sudo apt install build-essential
sudo bash ./VMware-Workstation-Full-15.5.1-15018445.x86_64.bundle

Shared VMs at /var/lib/vmware/Shared VMs

gksu vmware
pkexec vmware

installed at http://192.168.1.41:8181/
Username root, password password.

Postgres 10 embedded at /opt/gitlab/embedded/postgresql/10/share.

Don't know username/password for embedded postgres.

Change gitlab root password: https://docs.gitlab.com/ee/security/reset_root_password.html

Change database details: Edit /etc/gitlab/gitlab.rb /etc/gitlab/gitlab.rb should have file permissions 0600 because it contains plain-text passwords.

# Disable the built-in Postgres
postgresql['enable'] = false
# Fill in the connection details for database.yml
gitlab_rails['db_adapter'] = 'postgresql'
gitlab_rails['db_encoding'] = 'utf8'
gitlab_rails['db_host'] = '127.0.0.1'
gitlab_rails['db_port'] = 5432
gitlab_rails['db_username'] = 'USERNAME'
gitlab_rails['db_password'] = 'PASSWORD'

sudo gitlab-ctl reconfigure
sudo service gitlab restart

https://docs.gitlab.com/omnibus/settings/database.html#seed-the-database-fresh-installs-only