//optional, setting LC_CTYPE https://gist.github.com/virbo/bcdfc0e41794b18ba4c538071828dd8d
- update dan upgrade
- install nano dan wget
- install perl (yum install perl)
- edit hostname
- wget http://software.virtualmin.com/gpl/scripts/install.sh
- sh install.sh
sudo rpm -Uvh https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
yum list postgresql*
yum install postgresql12-server postgresql12-contrib postgresql12
/usr/pgsql-12/bin/postgresql-12-setup initdb
Start postgres (CLI):
sudo systemctl start postgresql-12
sudo systemctl enable postgresql-12
or Edit command setting Webmin -> Servers -> PostgreSQL Database Server -> Setting
- Command to start PostgreSQL
- Command to stop PostgreSQL
- Command to initialize PostgreSQL
- Paths to host access config file
other version: https://yum.postgresql.org/repopackages.php or https://www.postgresql.org/download/linux/redhat/ Ref: https://techcyclist.com/postgres/upgrading-postgres-to-the-latest-version-on-centos-7-server/
nano /etc/yum.repos.d/MariaDB.repo
[mariadb10.4.8]
name = MariaDB
baseurl = http://yum.mariadb.org/10.4.8/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
yum list available –showduplicates MariaDB-Server.x86_64
yum remove mariadb-server mariadb mariadb-libs
yum clean all
yum -y install MariaDB-server MariaDB-client
systemctl start mariadb
systemctl enable mariadb
mysql_upgrade -u root -pp@pua8888
Ref: https://www.tecmint.com/upgrade-mariadb-5-5-to-10-centos-rhel-debian-ubuntu/ and https://www.liquidweb.com/kb/update-mariadb-from-10-0-to-10-3-on-centos-7/
mailbox_command = /usr/bin/procmail-wrapper -o -a $DOMAIN -d $LOGNAME
ERROR: Postfix can support per-domain outgoing IP addresses, but is not currently configured to do so. This can be setup in the Postfix Mailserver module.
solve with this https://www.virtualmin.com/documentation/email/dependent
https://www.woktron.com/secure/knowledgebase/77/Installation-CSF-Firewall-on-CentOS.html
yum install rh-php73 rh-php73-php-pgsql rh-php73-php-mysqlnd rh-php73-php-intl rh-php73-php-gd rh-php73-php-mbstring
scl enable rh-php73 bash