[Maria-discuss] Adding MySQL database backup to rsnapshot for Linux Servers

2021-08-22 Thread Turritopsis Dohrnii Teo En Ming 
Subject: Adding MySQL database backup to rsnapshot for Linux Servers

Author: Mr. Turritopsis Dohrnii Teo En Ming (TARGETED INDIVIDUAL)
Country: Singapore
Date: 22 August 2021 Sunday Singapore Time

Type of Pulication: Plain Text

Document Version: 20210822.01

DETAILED INSTRUCTIONS
=

Looking for mysqldump
=

# which mysqldump
/usr/bin/mysqldump

Testing if mysqldump works
==

# /usr/bin/mysqldump --all-databases > mysqldump_all_databases.sql

Check the filesize of MySQL dump


# du -h mysqldump_all_databases.sql
23M mysqldump_all_databases.sql

Backup rsnapshot configuration file first
=

# cd /etc/

# cp rsnapshot.conf rsnapshot.conf.backup20082021

Deploying MySQL backup script
=

# cp /usr/share/doc/rsnapshot-1.4.3/utils/backup_mysql.sh /usr/local/bin/

# chown root.root /usr/local/bin/backup_mysql.sh

# chmod o-w /usr/local/bin/backup_mysql.sh

# chmod +x /usr/local/bin/backup_mysql.sh

# cat /usr/local/bin/backup_mysql.sh

===BEGIN of backup_mysql.sh===

#!/bin/sh

##
# backup_mysql.sh
#
# by Nathan Rosenquist 
# http://www.rsnapshot.org/
#
# This is a simple shell script to backup a MySQL database with rsnapshot.
#
# The assumption is that this will be invoked from rsnapshot. Also, since it
# will run unattended, the user that runs rsnapshot (probably root) should have
# a .my.cnf file in their home directory that contains the password for the
# MySQL root user. For example:
#
# /root/.my.cnf (chmod 0600)
#   [client]
#   user = root
#   password = thepassword
#   host = localhost
#
# This script simply needs to dump a file into the current working directory.
# rsnapshot handles everything else.
##

# $Id: backup_mysql.sh,v 1.6 2007/03/22 02:50:21 drhyde Exp $

umask 0077

# backup the database
/usr/bin/mysqldump --all-databases > mysqldump_all_databases.sql

# make the backup readable only by root
/bin/chmod 600 mysqldump_all_databases.sql

===END of backup_mysql.sh===

Edit rsnapshot configuration file
==

# nano /etc/rsnapshot.conf

Under BACKUP POINTS / SCRIPTS add the following line


backup_script   /usr/local/bin/backup_mysql.sh
secret.teo-en-ming-corp.com/mysqldump/

Test the rsnapshot configuration file for syntax errors
===

# rsnapshot configtest

require Lchown
Lchown module loaded successfully
Syntax OK



Mr. Turritopsis Dohrnii Teo En Ming, 43 years old as of 22 August
2021, is a TARGETED INDIVIDUAL living in Singapore. He is an IT
Consultant with a System Integrator (SI)/computer firm in Singapore.
He is an IT enthusiast.





-BEGIN EMAIL SIGNATURE-

The Gospel for all Targeted Individuals (TIs):

[The New York Times] Microwave Weapons Are Prime Suspect in Ills of
U.S. Embassy Workers

Link:
https://www.nytimes.com/2018/09/01/science/sonic-attack-cuba-microwave.html



Singaporean Targeted Individual Mr. Turritopsis Dohrnii Teo En Ming's
Academic Qualifications as at 14 Feb 2019 and refugee seeking attempts
at the United Nations Refugee Agency Bangkok (21 Mar 2017), in Taiwan
(5 Aug 2019) and Australia (25 Dec 2019 to 9 Jan 2020):

[1] https://tdtemcerts.wordpress.com/

[2] https://tdtemcerts.blogspot.sg/

[3] https://www.scribd.com/user/270125049/Teo-En-Ming

-END EMAIL SIGNATURE-

___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp

[Maria-discuss] How to Host Multiple Mail Domains (Email Hosting) in iRedMail Full Featured Linux Mail Server

2021-05-04 Thread Turritopsis Dohrnii Teo En Ming 
Subject: How to Host Multiple Mail Domains (Email Hosting) in iRedMail
Full Featured Linux Mail Server

Author: Mr. Turritopsis Dohrnii Teo En Ming (TARGETED INDIVIDUAL)
Country: Singapore
Date: 3rd May 2021 Monday
Type of Publication: PDF Manual
Document Version: 20210503.01

***IMPORTANT NOTICE*** Please note that Turritopsis Dohrnii Teo En
Ming’s guide is based on Xiao Guoan’s guide at linuxbabe.com.

Reference Guide Used by Teo En Ming: How to Host Multiple Mail Domains
in iRedMail with Nginx
Link: 
https://www.linuxbabe.com/mail-server/set-up-iredmail-multiple-domains-nginx
Original Author: Xiao Guoan

The following is a list of open-source software that will be
automatically installed and configured by iRedMail.

• Postfix SMTP server
• Dovecot IMAP server
• Nginx web server to serve the admin panel and webmail
• OpenLDAP, MySQL/MariaDB, or PostgreSQL for storing user information
• Amavised-new for DKIM signing and verification
• SpamAssassin for anti-spam
• ClamAV for anti-virus
• Roundcube webmail
• SOGo groupware, providing webmail, calendar (CalDAV), contacts
(CardDAV), tasks and ActiveSync services.
• Fail2ban for protecting SSH
• mlmmj mailing list manager
• Netdata server monitoring
• iRedAPD Postfix policy server for greylisting

In addition, you need to add MX, A and TXT records to your ISC BIND
DNS domain name server.

Redundant download links for Turritopsis Dohrnii Teo En Ming's PDF manual:

[1] 
https://www.mediafire.com/file/q6txmx0rc1cwfzw/Additional+Mail+Domains+1st+Release.pdf/file

[2] https://www.docdroid.net/Q9TRL5D/additional-mail-domains-1st-release-pdf

[3] 
https://www.scribd.com/document/506193434/Additional-Mail-Domains-1st-Release

[4] 
https://drive.google.com/file/d/10AYGt4-omBeC3vXJfzswQq0M7E09gXpG/view?usp=sharing

[5] 
https://drive.google.com/file/d/113dy0AKmBYGugBueK1vS_dJwI35J6XmJ/view?usp=sharing

[6] 
https://drive.google.com/file/d/1dhpYIZp31ug5hoiVNbjh6uh99s_PEx8q/view?usp=sharing

Mr. Turritopsis Dohrnii Teo En Ming, 43 years old as of 4th May 2021,
is a TARGETED INDIVIDUAL living in Singapore. He is an IT Consultant
with a System Integrator (SI)/computer firm in Singapore. He is an IT
enthusiast.






-BEGIN EMAIL SIGNATURE-

The Gospel for all Targeted Individuals (TIs):

[The New York Times] Microwave Weapons Are Prime Suspect in Ills of
U.S. Embassy Workers

Link:
https://www.nytimes.com/2018/09/01/science/sonic-attack-cuba-microwave.html



Singaporean Targeted Individual Mr. Turritopsis Dohrnii Teo En Ming's
Academic Qualifications as at 14 Feb 2019 and refugee seeking attempts
at the United Nations Refugee Agency Bangkok (21 Mar 2017), in Taiwan
(5 Aug 2019) and Australia (25 Dec 2019 to 9 Jan 2020):

[1] https://tdtemcerts.wordpress.com/

[2] https://tdtemcerts.blogspot.sg/

[3] https://www.scribd.com/user/270125049/Teo-En-Ming

-END EMAIL SIGNATURE-

___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp

[Maria-discuss] How to Easily Set Up a Full-Featured Linux Mail Server on Ubuntu 18.04.5 LTS with iRedMail 1.4.0

2021-04-26 Thread Turritopsis Dohrnii Teo En Ming 
Subject: How to Easily Set Up a Full-Featured Linux Mail Server on
Ubuntu 18.04.5 LTS with iRedMail 1.4.0

Good day from Singapore,

I followed linuxbabe.com's Xiao Guoan's guide and successfully setup a
full featured Linux mail server on Ubuntu 18.04.5 LTS with IRedMail
1.4.0.

Author: Mr. Turritopsis Dohrnii Teo En Ming (TARGETED INDIVIDUAL)
Country: Singapore
Date: 25 April 2021 Sunday

Type of Publication: PDF Manual
Document Version: 20210425.01 (1st release)

***IMPORTANT NOTICE*** Please note that Turritopsis Dohrnii Teo En
Ming’s guide is based on Xiao Guoan’s guide at linuxbabe.com.

Reference Guide Used by Teo En Ming: How to Easily Set Up a
Full-Featured Mail Server on Ubuntu 18.04 with iRedMail
Link: https://www.linuxbabe.com/mail-server/ubuntu-18-04-iredmail-email-server
Original Author: Xiao Guoan

The following is a list of open-source software that will be
automatically installed and configured by iRedMail.

• Postfix SMTP server
• Dovecot IMAP server
• Nginx web server to serve the admin panel and webmail
• OpenLDAP, MySQL/MariaDB, or PostgreSQL for storing user information
• Amavised-new for DKIM signing and verification
• SpamAssassin for anti-spam
• ClamAV for anti-virus
• Roundcube webmail
• SOGo groupware, providing webmail, calendar (CalDAV), contacts
(CardDAV), tasks and ActiveSync services.
• Fail2ban for protecting SSH
• mlmmj mailing list manager
• Netdata server monitoring
• iRedAPD Postfix policy server for greylisting

Redundant Download Links for Teo En Ming's PDF Manual:

[1] 
https://drive.google.com/file/d/1un8sLLmNSMIt7V6blWCvJEgwGvxMbd4B/view?usp=sharing

[2] 
https://drive.google.com/file/d/1i0vY7kfYkobu563qoI3_qCZg7G7BFoYR/view?usp=sharing

[3] 
https://drive.google.com/file/d/1U9MFN1EklLbA8TMweLV5ntiSJuBBVkpQ/view?usp=sharing

[4] https://www.docdroid.net/dW70KtS/iredmail-setup-1st-release-pdf

[5] 
https://www.mediafire.com/file/evar7j28knqyoj6/IRedMail+Setup+1st+Release.pdf/file

[6] https://www.scribd.com/document/504932780/IRedMail-Setup-1st-Release

Mr. Turritopsis Dohrnii Teo En Ming, 43 years old as of 26 April 2021,
is a TARGETED INDIVIDUAL living in Singapore. He is an IT Consultant
with a System Integrator (SI)/computer firm in Singapore. He is an IT
enthusiast.





-BEGIN EMAIL SIGNATURE-

The Gospel for all Targeted Individuals (TIs):

[The New York Times] Microwave Weapons Are Prime Suspect in Ills of
U.S. Embassy Workers

Link:
https://www.nytimes.com/2018/09/01/science/sonic-attack-cuba-microwave.html



Singaporean Targeted Individual Mr. Turritopsis Dohrnii Teo En Ming's
Academic Qualifications as at 14 Feb 2019 and refugee seeking attempts
at the United Nations Refugee Agency Bangkok (21 Mar 2017), in Taiwan
(5 Aug 2019) and Australia (25 Dec 2019 to 9 Jan 2020):

[1] https://tdtemcerts.wordpress.com/

[2] https://tdtemcerts.blogspot.sg/

[3] https://www.scribd.com/user/270125049/Teo-En-Ming

-END EMAIL SIGNATURE-

___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp

[Maria-discuss] Planning on setting up Postfix + Dovecot + Webmail + Apache + MariaDB + PHP using Webmin Control Panel in the Cloud

2021-04-21 Thread Turritopsis Dohrnii Teo En Ming 
Subject: Planning on setting up Postfix + Dovecot + Webmail + Apache +
MariaDB + PHP using Webmin Control Panel in the Cloud

Good day from the Republic of Singapore,

I am planning to setup Postfix Email Server + Dovecot IMAP/POP3
Incoming Mail Server + Webmail (Roundcube or Squirrelmail) + Apache
Web Server + MariaDB Database Server + PHP using Webmin Control Panel
specifically, in the cloud, preferably Amazon EC2.

Are there any very good and well written guides on doing this type of setup?

I am looking forward to your reply.

Thank you very much.

Mr. Turritopsis Dohrnii Teo En Ming, 43 years old as of 21 April 2021
Wed, is a TARGETED INDIVIDUAL (TI) living in Singapore. He is an IT
Consultant with a System Integrator (SI)/computer firm in Singapore.
He is an IT enthusiast.





-BEGIN EMAIL SIGNATURE-

The Gospel for all Targeted Individuals (TIs):

[The New York Times] Microwave Weapons Are Prime Suspect in Ills of
U.S. Embassy Workers

Link:
https://www.nytimes.com/2018/09/01/science/sonic-attack-cuba-microwave.html



Singaporean Targeted Individual Mr. Turritopsis Dohrnii Teo En Ming's
Academic Qualifications as at 14 Feb 2019 and refugee seeking attempts
at the United Nations Refugee Agency Bangkok (21 Mar 2017), in Taiwan
(5 Aug 2019) and Australia (25 Dec 2019 to 9 Jan 2020):

[1] https://tdtemcerts.wordpress.com/

[2] https://tdtemcerts.blogspot.sg/

[3] https://www.scribd.com/user/270125049/Teo-En-Ming

-END EMAIL SIGNATURE-

___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp

[Maria-discuss] How to Migrate Wordpress Website from 32-bit CentOS Linux 6.3 to 64-bit CentOS Linux 8.2 (2004)

2020-08-31 Thread Turritopsis Dohrnii Teo En Ming 

Subject: How to Migrate Wordpress Website from 32-bit CentOS Linux 6.3 to 
64-bit CentOS Linux 8.2 (2004)

Author of this Guide: Mr. Turritopsis Dohrnii Teo En Ming (TARGETED INDIVIDUAL)

Country: Singapore

Date: 31 August 2020 Monday Singapore Time

Type of Publication: Plain Text

Document Version: 20200831.01

Redundant links to my guide:

[1] https://lkml.org/lkml/2020/8/31/454

[2] http://lkml.iu.edu/hypermail/linux/kernel/2008.3/09047.html

[3] https://marc.info/?l=linux-kernel=159888024529073=2

[4] 
https://lwn.net/ml/linux-kernel/70ce3070fa816dbbe2e6424b2ae7f322%40teo-en-ming.com/

[5] http://lists.linuxfromscratch.org/pipermail/lfs-chat/2020-August/029149.html

[6] https://lists.centos.org/pipermail/centos/2020-August/351448.html

[7] https://marc.info/?l=apache-httpd-users=159888114229385=2

[8] https://marc.info/?l=php-general=159888203429670=2

[9] https://mta.openssl.org/pipermail/openssl-users/2020-August/012915.html






-BEGIN EMAIL SIGNATURE-

The Gospel for all Targeted Individuals (TIs):

[The New York Times] Microwave Weapons Are Prime Suspect in Ills of
U.S. Embassy Workers

Link: 
https://www.nytimes.com/2018/09/01/science/sonic-attack-cuba-microwave.html



Singaporean Mr. Turritopsis Dohrnii Teo En Ming's Academic
Qualifications as at 14 Feb 2019 and refugee seeking attempts at the United 
Nations Refugee Agency Bangkok (21 Mar 2017), in Taiwan (5 Aug 2019) and 
Australia (25 Dec 2019 to 9 Jan 2020):

[1] https://tdtemcerts.wordpress.com/

[2] https://tdtemcerts.blogspot.sg/

[3] https://www.scribd.com/user/270125049/Teo-En-Ming

-END EMAIL SIGNATURE-
___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp

[Maria-discuss] Re-configuring BIND DNS Servers for CentOS Web Panel Web Hosting Control Panel on Amazon AWS Cloud

2020-02-27 Thread Turritopsis Dohrnii Teo En Ming 
Subject: Re-configuring BIND DNS Servers for CentOS Web Panel Web Hosting 
Control Panel on Amazon AWS Cloud

Author: Mr. Turritopsis Dohrnii Teo En Ming, Singapore
Date: 27 Feb 2020 Thursday

Rationale for Re-configuration of BIND DNS Servers for CentOS Web Panel
===

I have originally followed the approach for cPanel where there are 2 DNS-ONLY 
servers and one or more cPanel webservers. However, CentOS Web Panel
implements DNS Clusters differently. Hence I have to re-configure BIND DNS 
Servers for CentOS Web Panel web hosting control panel.

PREREQUISITES
=

Part 1 of the series: Mr. Teo En Ming's Guide to Deploying CentOS Web Panel 
(CWP) Web Hosting Control Panel on Amazon AWS Cloud

Redundant Blogger and Wordpress blog links:

[1] 
https://tdtemcerts.blogspot.com/2020/02/mr-teo-en-mings-guide-to-deploying.html

[2] 
https://tdtemcerts.wordpress.com/2020/02/23/mr-teo-en-mings-guide-to-deploying-centos-web-panel-cwp-web-hosting-control-panel-on-amazon-aws-cloud/

Part 2 of the series: Setting Up Mail Server Operation for CentOS Web Panel Web 
Hosting Control Panel on Amazon AWS Cloud

Redundant Blogger and Wordpress blog links:

[1] 
https://tdtemcerts.blogspot.com/2020/02/setting-up-mail-server-operation-for.html

[2] 
https://tdtemcerts.wordpress.com/2020/02/25/setting-up-mail-server-operation-for-centos-web-panel-web-hosting-control-panel-on-amazon-aws-cloud/

THIS guide is Part 3 of the series.

EXTREMELY DETAILED INSTRUCTIONS OF TEO EN MING'S GUIDE
==

Login to Amazon AWS Console.

Setting Up Secondary/Slave DNS Server
=

On the EC2 Dashboard, click Instances.

Click Launch Instance.

Search for centos in the AWS Markpetplace.

Select CentOS 7 (x86_64) - with Updates HVM (free tier eligible).

Click Continue.

Select t2.micro (free tier eligible).

Click Next: Configure Instance Details.

Network: Teo En Ming VPC

Subnet: Public subnet | us-east-2a

Click Protect against accidental termination.

Click Next: Add Storage

Size (GiB): 8

Click Next: Add Tags

Key = Name

Value = slave

Click Next: Configure Security Group

Click Select an existing security group

Select NameServers

Click Review and Launch.

Click Launch.

Select Choose an existing key pair.

Key pair name: cwp

Click Launch Instances.

Click Instances.

Select slave, right click and select Networking > Manage IP Addresses.

Click Allocate an elastic IP to this instance.

Click Allocate.

Click Associate this Elastic IP Address.

Instance: slave

Click Associate.

IPv4 address of Secondary/Slave DNS server is 3.12.224.179

$ ssh -i cwp.pem centos@3.12.224.179

$ sudo passwd

$ su -

# yum -y update && yum -y install wget

# hostnamectl set-hostname ns2.teo-en-ming.com

# cd /usr/local/src && wget http://centos-webpanel.com/cwp-el7-latest && sh 
cwp-el7-latest

Started installing CentOS Web Panel at 9:00 PM on 26 Feb 2020 Wed.

Completed installing CentOS Web Panel at 9:05 PM on 26 Feb 2020 Wed.

Total duration: 5 mins.

#
#  CWP Installed#
#

Go to CentOS WebPanel Admin GUI at http://SERVER_IP:2030/

http://3.12.224.179:2030
SSL: https://3.12.224.179:2031
-
Username: root
Password: ssh server root password
MySQL root Password:

#
  CentOS Web Panel MailServer Installer
#
SSL Cert name (hostname): ns2.teo-en-ming.com
SSL Cert file location /etc/pki/tls/ private|certs
#

Visit for help: www.centos-webpanel.com
Write down login details and press ENTER for server reboot!
Please reboot the server!
Reboot command: shutdown -r now

# reboot

REFERENCE
=

Guide: Slave DNS Server & Manager - DNS Cluster

Link: https://wiki.centos-webpanel.com/slave-dns-server-manager-dns-cluster

REFERENCE
=

Guide: Slave DNS Server & Manager download version

Link: https://wiki.centos-webpanel.com/slave-dns-server-manager-download-version

Login to the CentOS Web Panel Admin Panel on the Slave.

>From the left menu, click on CWP Settings, then select Edit Settings.

Admin Email: c...@teo-en-ming-corp.com

Check Activate NAT-ed network configuration.

Click Save Changes.

Create a New Account on the Secondary/Slave DNS Server
==

>From the left menu, click User Accounts, then click New Account.

Domain name: teo-en-ming.com

Username: slave

Package: default

Click Create.

Download Slave DNS Manager and upload it to public_html folder on the 
Secondary/Slave DNS Server


ssh -i cwp.pem centos@3.12.224.179

su -

cd /home/

[Maria-discuss] Mr. Teo En Ming's Guide to Deploying CentOS Web Panel (CWP) Web Hosting Control Panel on Amazon AWS Cloud

2020-02-23 Thread Turritopsis Dohrnii Teo En Ming 
directory   "/var/named";
dump-file   "/var/named/data/cache_dump.db";
statistics-file "/var/named/data/named_stats.txt";
memstatistics-file "/var/named/data/named_mem_stats.txt";
recursing-file  "/var/named/data/named.recursing";
secroots-file   "/var/named/data/named.secroots";
allow-query     { any; };

/* 
 - If you are building an AUTHORITATIVE DNS server, do NOT enable 
recursion.
 - If you are building a RECURSIVE (caching) DNS server, you need to 
enable 
   recursion. 
 - If your recursive DNS server has a public IP address, you MUST 
enable access 
   control to limit queries to your legitimate users. Failing to do so 
will
   cause your server to become part of large scale DNS amplification 
   attacks. Implementing BCP38 within your network would greatly
   reduce such attack surface 
*/
recursion yes;

dnssec-enable yes;
dnssec-validation yes;

/* Path to ISC DLV key */
bindkeys-file "/etc/named.root.key";

managed-keys-directory "/var/named/dynamic";

pid-file "/run/named/named.pid";
session-keyfile "/run/named/session.key";
};

logging {
        channel default_debug {
                file "data/named.run";
                severity dynamic;
        };
};

zone "." IN {
type hint;
file "named.ca";
};

include "/etc/named.rfc1912.zones";
include "/etc/named.root.key";

include "/etc/named/named.conf.local";

# chmod 755 /etc/named

# nano /etc/named/named.conf.local

zone "teo-en-ming.com" {
    type slave;
    file "slaves/db.teo-en-ming.com";
    masters { 13.58.253.162; };  # ns1 private IP
};


# named-checkconf

# systemctl start named

# systemctl enable named

Testing the Secondary DNS Server


$ dig @3.20.186.205 teo-en-ming.com

Configuring Custom Name Servers At Your Domain Registrar


Go to DNS management.

Under host names,

Set ns1 to 13.58.253.162

Set ns2 to 3.20.186.205

Set custom name servers to:

ns1.teo-en-ming.com

ns2.teo-en-ming.com

REFERENCE
=

Guide: How to Set up a CentOS Web Panel

Link: https://www.alibabacloud.com/blog/how-to-set-up-a-centos-web-panel_595183

Setting Up CentOS Web Panel
===

$ sudo passwd

$ su -

# yum -y update && yum -y install wget

# hostnamectl set-hostname www.teo-en-ming.com

# cd /usr/local/src && wget http://centos-webpanel.com/cwp-el7-latest && sh 
cwp-el7-latest

Started installing CentOS Web Panel at 6.24 PM on 23 Feb 2020 Sunday.

Completed installing CentOS Web Panel at 6.30 PM on 23 Feb 2020 Sunday.

Total duration: 6 mins

#
#      CWP Installed        #
#

Go to CentOS WebPanel Admin GUI at http://SERVER_IP:2030/

http://3.21.30.127:2030
SSL: https://3.21.30.127:2031
-
Username: root
Password: ssh server root password
MySQL root Password: 

#
          CentOS Web Panel MailServer Installer          
#
SSL Cert name (hostname): www.teo-en-ming.com
SSL Cert file location /etc/pki/tls/ private|certs
#

Visit for help: www.centos-webpanel.com
Write down login details and press ENTER for server reboot!
Please reboot the server!
Reboot command: shutdown -r now

# shutdown -r now

Configuring CentOS Web Panel Web Hosting Control Panel
==

Go to https://3.21.30.127:2031

>From the left menu, click on CWP Settings, then select Edit Settings.

Admin Email: c...@teo-en-ming-corp.com

Check Activate NAT-ed network configuration.

Click Save Changes.

>From the left menu, click DNS Functions, then select Edit Nameservers IPs.

Name Server 1: ns1.teo-en-ming.com            13.58.253.162

Name Server 2: ns2.teo-en-ming.com            3.20.186.205

Click Save Changes.

That's all.

In future, go to https://www.teo-en-ming.com:2031

It works!

AUTHOR: MR. TURRITOPSIS DOHRNII TEO EN MING, SINGAPORE















-BEGIN EMAIL SIGNATURE-

The Gospel for all Targeted Individuals (TIs):

[The New York Times] Microwave Weapons Are Prime Suspect in Ills of
U.S. Embassy Workers

Link: 
https://www.nytimes.com/2018/09/01/science/sonic-attack-cuba-microwave.html





Singaporean Mr. Turritopsis Dohrnii Teo En Ming's Academic
Qualifications as at 14 Feb 2019 and refugee seeking attempts at the United 
Nations Refugee Agency Bangkok (21 Mar

[Maria-discuss] How do I determine if versions of phpMyAdmin before 4.8.5 is SQL Injectable using sqlmap?

2019-04-17 Thread Turritopsis Dohrnii Teo En Ming 
Subject/Topic: How do I determine if versions of phpMyAdmin before 4.8.5 is SQL 
Injectable using sqlmap?

Good evening from Singapore,

Our customer (company name is Confidential/not disclosed) reported that their 
MySQL database has been found missing or was deleted a few times. They are 
using Ubuntu 16.04 LTS Linux server with Apache2 Web Server, MySQL and PHP 
(LAMP).

We responded to these security incidents by changing the passwords of the 
regular user, root user, and MySQL database user root. We have also examined 
/var/log/auth.log and think that the hacker could not have come in through ssh 
or sftp over ssh. From /var/log/mysql/error.log, we can ascertain that the 
MySQL database has been deleted at certain timings. We have also found nothing 
abnormal after examining /var/log/apache2/access.log.

Even though we have secured the Ubuntu Linux server by changing passwords, the 
hacker was still able to delete our customer's MySQL database again and again. 
I have already proposed to install ModSecurity Open Source Web Application 
Firewall (WAF) to defend against web application attacks but my boss has told 
me to put that on hold at the moment. In fact, I have already deployed 
ModSecurity 2.9.0 on a Ubuntu 16.04 LTS *Testing* server and found that it 
actively detects and logs Nessus and sqlmap vulnerability scans in blocking 
mode.

Since we did not find any evidence that the hacker had breached our customer's 
Ubuntu 16.04 LTS production server through ssh or Teamviewer, we suspect that 
the hacker could have achieved it by SQL injection. I took the initiative of 
downloading and installing Nessus Professional 8.3.1 Trial version for Windows 
64-bit. The vulnerability scan report generated by Nessus Web Application Tests 
shows that our customer is using a version of phpMyAdmin prior to 4.8.5 which 
could be vulnerable to SQL injection using the designer feature.

Further research shows that I can use sqlmap to determine if phpMyAdmin is SQL 
injectable. I already have a Testing Ubuntu 16.04 LTS Linux server with a 
Testing MySQL database and a Testing phpMyAdmin 4.8.4. I have purposely 
installed phpMyAdmin 4.8.4 because this version was reported to be vulnerable 
to SQL injection using the designer feature, and our customer is using a 
vulnerable version, according to CVE-2019-6798 ( 
https://nvd.nist.gov/vuln/detail/CVE-2019-6798 ). Then I proceeded to download 
and execute sqlmap on our Ubuntu Linux desktop against our Testing server.

No matter how many commands I try, sqlmap always report that phpMyAdmin 4.8.4 
is *NOT* SQL injectable. Perhaps I was using the wrong sqlmap commands all the 
time? The following is one of the many sqlmap commands I have used.

$ python sqlmap.py -u "https://www.EXAMPLE.com/phymyadmin/index.php?id=1; 
--level=1 --dbms=mysql --sql-query="drop database"

Replace database by database name.

May I know what is the correct sqlmap command that I should use to determine 
that my Testing phpMyAdmin 4.8.4 is SQL injectable? I would like to know if I 
can successfully drop/delete the Testing database on our Testing server. If I 
can successfully drop/delete the Testing MySQL database using sqlmap, I would 
be able to conclude that the hacker must have carried out SQL injection to 
drop/delete the customer's database. I have already turned off the Testing 
ModSecurity Web Application Firewall on our Testing server to allow sqlmap to 
go through.

Please point me to any good tutorial on SQL injection using sqlmap. Maybe I do 
not understand SQL injection well enough. Our customer is also using a 
customised in-house inventory management system that relies on PHP application 
and MySQL database.

Would open source Snort Intrusion Detection System (IDS) and Intrusion 
Prevention System (IPS) be able to detect and block SQL injection as well?

Please advise.

Thank you very much.

-BEGIN EMAIL SIGNATURE-

The Gospel for all Targeted Individuals (TIs):

[The New York Times] Microwave Weapons Are Prime Suspect in Ills of
U.S. Embassy Workers

Link: 
https://www.nytimes.com/2018/09/01/science/sonic-attack-cuba-microwave.html



Singaporean Mr. Turritopsis Dohrnii Teo En Ming's Academic
Qualifications as at 14 Feb 2019

[1] https://tdtemcerts.wordpress.com/

[2] https://tdtemcerts.blogspot.sg/

[3] https://www.scribd.com/user/270125049/Teo-En-Ming

-END EMAIL SIGNATURE-


___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp

Re: [Maria-discuss] My Solution to MariaDB Database Server Crashed in Experimental Online Store

2018-10-22 Thread Turritopsis Dohrnii Teo En Ming 
Good morning from Singapore Reindl Harald,


The 1st time my MariaDB SQL Database Server crashed in my Experimental 
WooCommerce Online Store, I was TOO LAZY to check system logs 
/var/log/mariadb/mariadb.log


The 2nd time my MariaDB SQL Database Server crashed in my Experimental 
WooCommerce Online Store, I have NO CHOICE but to check system logs 
/var/log/mariadb/mariadb.log


I am very sorry for my laziness.



From: Maria-discuss 
 
on behalf of Reindl Harald 
Sent: Tuesday, October 23, 2018 5:39 AM
To: maria-discuss@lists.launchpad.net
Subject: Re: [Maria-discuss] My Solution to MariaDB Database Server Crashed in 
Experimental Online Store



Am 22.10.18 um 23:12 schrieb Daniel Black:
>> Giving my virtual server more than 1 GB of RAM will cost me more
>> money.
>
> Sometimes you can't run a real service on less memory than your phone

+1

with 1 GB you just survive basic operations and system-upgrades, below
768 MB you even don't surivive memory spikes of a "dnf upgrade"

and yes, i remember the times when i had run MS Windows Advances Server
with LAMP, Office, Photoshop, CorelDraw and a tiny Linux VM on a machine
with 192 MB RAM but sadly that times are gone by lazy developers wating
ressources

frankly i had seen page allocation errors leading to VMware HA trigger
in 2015 on Fedora guests wth just 1 GB RAM doing *nothing* than rsync
backups, that got better but doing anything useful with 1 GB RAM is a
bad job and shows lack of any expirience as well as the orginal post did
talking about crahses while not show any single sing of them but talk
about "sytemctl start/enable" which has nothing to do with crashes

___
Mailing list: https://launchpad.net/~maria-discuss
Maria Discuss in Launchpad
launchpad.net
Discussions about usage questions of the Maria project. Development discussions 
are done in the maria-developers group. 
(http://launchpad.net/~maria-developers) Commits are done by the Maria Captains 
(http://launchpad.net/~maria-captains)



Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
Maria Discuss in Launchpad
launchpad.net
Discussions about usage questions of the Maria project. Development discussions 
are done in the maria-developers group. 
(http://launchpad.net/~maria-developers) Commits are done by the Maria Captains 
(http://launchpad.net/~maria-captains)



More help   : https://help.launchpad.net/ListHelp
___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp

Re: [Maria-discuss] My Solution to MariaDB Database Server Crashed in Experimental Online Store

2018-10-22 Thread Turritopsis Dohrnii Teo En Ming 
Good evening from Singapore,


My virtual server is an Amazon AWS Linux instance. I only gave it 1 GB of RAM.


How much RAM/memory do I need to support MariaDB SQL database server without 
crashing?


Giving my virtual server more than 1 GB of RAM will cost me more money.



From: rhys.campb...@swisscom.com 
Sent: Monday, October 22, 2018 6:22 PM
To: Turritopsis Dohrnii Teo En Ming; maria-discuss@lists.launchpad.net
Subject: RE: [Maria-discuss] My Solution to MariaDB Database Server Crashed in 
Experimental Online Store

It's failing to allocate memory the innodb buffer pool. Check your memory usage 
/ total ram / add more ram

-Original Message-
From: Maria-discuss 
[mailto:maria-discuss-bounces+rhys.campbell=swisscom@lists.launchpad.net] 
On Behalf Of Turritopsis Dohrnii Teo En Ming
Sent: 22 October 2018 11:49
To: Reindl Harald ; maria-discuss@lists.launchpad.net
Subject: Re: [Maria-discuss] My Solution to MariaDB Database Server Crashed in 
Experimental Online Store

Good afternoon from Singapore,

My MariaDB SQL Database Server really crashed. I did not reboot my virtual 
server at all. It has crashed twice already.

Here is the output of /var/log/mariadb/mariadb.log.

[root@ip-10-0-0-76 mariadb]# tail -n 50 mariadb.log
181018  5:43:33 [Note] Server socket created on IP: '0.0.0.0'.
181018  5:43:33 [Note] Event Scheduler: Loaded 0 events
181018  5:43:33 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.60-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  
MariaDB Server
181018  7:22:34 [Warning] IP address '31.184.193.100' could not be resolved: 
Name or service not known
181018  7:55:41 [Warning] IP address '58.218.213.3' could not be resolved: Name 
or service not known
181018 12:58:57 [Warning] IP address '113.4.133.5' could not be resolved: Name 
or service not known
181018 19:59:04 [Warning] IP address '196.52.43.89' could not be resolved: Name 
or service not known
181019 09:04:06 mysqld_safe Number of processes running now: 0
181019 09:04:06 mysqld_safe mysqld restarted
181019  9:04:06 [Note] /usr/libexec/mysqld (mysqld 5.5.60-MariaDB) starting as 
process 15275 ...
181019  9:04:06 [ERROR] mysqld: Out of memory (Needed 128917504 bytes)
181019  9:04:06 [ERROR] mysqld: Out of memory (Needed 96681984 bytes)
181019  9:04:06 [ERROR] mysqld: Out of memory (Needed 72499200 bytes)
181019  9:04:06 InnoDB: The InnoDB memory heap is disabled
181019  9:04:06 InnoDB: Mutexes and rw_locks use GCC atomic builtins
181019  9:04:06 InnoDB: Compressed tables use zlib 1.2.7
181019  9:04:06 InnoDB: Using Linux native AIO
181019  9:04:06 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137756672 bytes) failed; errno 12
181019  9:04:06 InnoDB: Completed initialization of buffer pool
181019  9:04:06 InnoDB: Fatal error: cannot allocate memory for the buffer pool
181019  9:04:06 [ERROR] Plugin 'InnoDB' init function returned error.
181019  9:04:06 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
181019  9:04:06 [Note] Plugin 'FEEDBACK' is disabled.
181019  9:04:06 [ERROR] Unknown/unsupported storage engine: InnoDB
181019  9:04:06 [ERROR] Aborting

181019  9:04:06 [Note] /usr/libexec/mysqld: Shutdown complete

181019 09:04:07 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid 
ended
181022 02:54:37 mysqld_safe Starting mysqld daemon with databases from 
/var/lib/mysql
181022  2:54:37 [Note] /usr/libexec/mysqld (mysqld 5.5.60-MariaDB) starting as 
process 22837 ...
181022  2:54:37 InnoDB: The InnoDB memory heap is disabled
181022  2:54:37 InnoDB: Mutexes and rw_locks use GCC atomic builtins
181022  2:54:37 InnoDB: Compressed tables use zlib 1.2.7
181022  2:54:37 InnoDB: Using Linux native AIO
181022  2:54:37 InnoDB: Initializing buffer pool, size = 128.0M
181022  2:54:37 InnoDB: Completed initialization of buffer pool
181022  2:54:37 InnoDB: highest supported file format is Barracuda.
181022  2:54:37  InnoDB: Starting crash recovery from checkpoint LSN=94454915
InnoDB: Restoring possible half-written data pages from the doublewrite 
buffer...
181022  2:54:37  InnoDB: Starting final batch to recover 4 pages from redo log
181022  2:54:37  InnoDB: Waiting for the background threads to start
181022  2:54:38 Percona XtraDB (http://www.percona.com) 5.5.59-MariaDB-38.11 
started; log sequence number 94455139
181022  2:54:38 [Note] Plugin 'FEEDBACK' is disabled.
181022  2:54:38 [Note] Server socket created on IP: '0.0.0.0'.
181022  2:54:39 [Note] Event Scheduler: Loaded 0 events
181022  2:54:39 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.60-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  
MariaDB Server





===BEGIN SIGNATURE===
Turritopsis Dohrnii Teo En Ming's Academic Qualifications as at 30 Oct 2017 [1] 
https://tdtemcerts.wordpress.com/ [2] http://tdtemcerts.blogspot.sg/ [3] 
https://www.scribd.com/user/270125049/Teo-En-Ming
===END SIGNATURE===




From: Maria-discuss 
 
on behalf

Re: [Maria-discuss] My Solution to MariaDB Database Server Crashed in Experimental Online Store

2018-10-22 Thread Turritopsis Dohrnii Teo En Ming 
Good afternoon from Singapore,

My MariaDB SQL Database Server really crashed. I did not reboot my virtual 
server at all. It has crashed twice already.

Here is the output of /var/log/mariadb/mariadb.log.

[root@ip-10-0-0-76 mariadb]# tail -n 50 mariadb.log
181018  5:43:33 [Note] Server socket created on IP: '0.0.0.0'.
181018  5:43:33 [Note] Event Scheduler: Loaded 0 events
181018  5:43:33 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.60-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  
MariaDB Server
181018  7:22:34 [Warning] IP address '31.184.193.100' could not be resolved: 
Name or service not known
181018  7:55:41 [Warning] IP address '58.218.213.3' could not be resolved: Name 
or service not known
181018 12:58:57 [Warning] IP address '113.4.133.5' could not be resolved: Name 
or service not known
181018 19:59:04 [Warning] IP address '196.52.43.89' could not be resolved: Name 
or service not known
181019 09:04:06 mysqld_safe Number of processes running now: 0
181019 09:04:06 mysqld_safe mysqld restarted
181019  9:04:06 [Note] /usr/libexec/mysqld (mysqld 5.5.60-MariaDB) starting as 
process 15275 ...
181019  9:04:06 [ERROR] mysqld: Out of memory (Needed 128917504 bytes)
181019  9:04:06 [ERROR] mysqld: Out of memory (Needed 96681984 bytes)
181019  9:04:06 [ERROR] mysqld: Out of memory (Needed 72499200 bytes)
181019  9:04:06 InnoDB: The InnoDB memory heap is disabled
181019  9:04:06 InnoDB: Mutexes and rw_locks use GCC atomic builtins
181019  9:04:06 InnoDB: Compressed tables use zlib 1.2.7
181019  9:04:06 InnoDB: Using Linux native AIO
181019  9:04:06 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137756672 bytes) failed; errno 12
181019  9:04:06 InnoDB: Completed initialization of buffer pool
181019  9:04:06 InnoDB: Fatal error: cannot allocate memory for the buffer pool
181019  9:04:06 [ERROR] Plugin 'InnoDB' init function returned error.
181019  9:04:06 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
181019  9:04:06 [Note] Plugin 'FEEDBACK' is disabled.
181019  9:04:06 [ERROR] Unknown/unsupported storage engine: InnoDB
181019  9:04:06 [ERROR] Aborting

181019  9:04:06 [Note] /usr/libexec/mysqld: Shutdown complete

181019 09:04:07 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid 
ended
181022 02:54:37 mysqld_safe Starting mysqld daemon with databases from 
/var/lib/mysql
181022  2:54:37 [Note] /usr/libexec/mysqld (mysqld 5.5.60-MariaDB) starting as 
process 22837 ...
181022  2:54:37 InnoDB: The InnoDB memory heap is disabled
181022  2:54:37 InnoDB: Mutexes and rw_locks use GCC atomic builtins
181022  2:54:37 InnoDB: Compressed tables use zlib 1.2.7
181022  2:54:37 InnoDB: Using Linux native AIO
181022  2:54:37 InnoDB: Initializing buffer pool, size = 128.0M
181022  2:54:37 InnoDB: Completed initialization of buffer pool
181022  2:54:37 InnoDB: highest supported file format is Barracuda.
181022  2:54:37  InnoDB: Starting crash recovery from checkpoint LSN=94454915
InnoDB: Restoring possible half-written data pages from the doublewrite 
buffer...
181022  2:54:37  InnoDB: Starting final batch to recover 4 pages from redo log
181022  2:54:37  InnoDB: Waiting for the background threads to start
181022  2:54:38 Percona XtraDB (http://www.percona.com) 5.5.59-MariaDB-38.11 
started; log sequence number 94455139
181022  2:54:38 [Note] Plugin 'FEEDBACK' is disabled.
181022  2:54:38 [Note] Server socket created on IP: '0.0.0.0'.
181022  2:54:39 [Note] Event Scheduler: Loaded 0 events
181022  2:54:39 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.60-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  
MariaDB Server



 
 
===BEGIN SIGNATURE===
Turritopsis Dohrnii Teo En Ming's Academic Qualifications as at 30 Oct 2017 
[1] https://tdtemcerts.wordpress.com/ 
[2] http://tdtemcerts.blogspot.sg/ 
[3] https://www.scribd.com/user/270125049/Teo-En-Ming 
===END SIGNATURE=== 




From: Maria-discuss 
 
on behalf of Reindl Harald 
Sent: Friday, October 19, 2018 8:00 PM
To: maria-discuss@lists.launchpad.net
Subject: Re: [Maria-discuss] My Solution to MariaDB Database Server Crashed in 
Experimental Online Store
    


Am 19.10.18 um 13:17 schrieb Turritopsis Dohrnii Teo En Ming:
> Good evening from Singapore,
> 
> Here is my solution:
> 
> # systemctl start mariadb.service
> 
> # mysql
> Welcome to the MariaDB monitor.  Commands end with ; or \g.
> Your MariaDB connection id is 2
> 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)]> quit
> Bye
> 
> # systemctl enable mariadb.service

what has this to do with a crash?
you simply forgot to enable the service and rebootet

___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-dis

[Maria-discuss] My Solution to MariaDB Database Server Crashed in Experimental Online Store

2018-10-19 Thread Turritopsis Dohrnii Teo En Ming 
Good evening from Singapore,

Here is my solution:

# systemctl start mariadb.service

# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 2
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)]> quit
Bye

# systemctl enable mariadb.service




 
 
===BEGIN SIGNATURE=== 
Turritopsis Dohrnii Teo En Ming's Academic Qualifications as at 30 Oct 2017 
[1] https://tdtemcerts.wordpress.com/ 
[2] http://tdtemcerts.blogspot.sg/ 
[3] https://www.scribd.com/user/270125049/Teo-En-Ming 
===END SIGNATURE=== 

___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp

[Maria-discuss] Step-by-Step Tutorial: How to Setup Your Own e-Commerce Online Store using WooCommerce 3.4.5, Wordpress 4.9.8, and CentOS 1805 (LAMP) in Amazon AWS Cloud

2018-09-28 Thread Turritopsis Dohrnii Teo En Ming 
Good morning from Singapore,


You can read my step-by-step tutorial on How to Setup Your Own e-Commerce 
Online Store using WooCommerce 3.4.5, Wordpress 4.9.8, and CentOS 1805 (LAMP) 
in Amazon AWS Cloud at any one of my two redundant blogs. My blogs were 
configured in RAID 1 mirroring array.


https://tdtemcerts.wordpress.com/2018/09/29/step-by-step-tutorial-how-to-setup-your-own-e-commerce-online-store-using-woocommerce-3-4-5-wordpress-4-9-8-and-centos-1805-lamp-in-amazon-aws-cloud/


https://tdtemcerts.blogspot.com/2018/09/step-by-step-tutorial-how-to-setup-your.html


Thanks for reading! If there are any mistakes, please do let me know!





===BEGIN SIGNATURE===

Turritopsis Dohrnii Teo En Ming's Academic Qualifications as at 30 Oct 2017

[1] https://tdtemcerts.wordpress.com/

[2] http://tdtemcerts.blogspot.sg/

[3] 
https://www.scribd.com/user/270125049/Teo-En-Ming

===END SIGNATURE===
___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp