From 8 to 5

Proxmox installation display out of range

2025-05-03T11:15:00.001+08:00

Reference:

https://forum.proxmox.com/threads/proxmox-ve-screen-out-of-range.131297/

Centos 7 reset root/ any user lost password / lockout due to cant remember password

2023-11-03T16:22:00.001+08:00

1. Need to be in front of the terminal. (Physically if not vm).

2. Reboot the server

3. Press 'e' in the GRUB2 boot screen.

3. bunch of text will come out. We can edit those text.

find the line that load the kernel - begins with 'linux16' in my case.
find text "rhgb quiet" , replace it with "rd.break enforcing=0".
When done. Press Ctrl X. The system will boot with the parameter edited.

[image text]

4. after boot. terminal prompt appear.

remount the root filesystem. "# mount -o remount,rw /sysroot"
set the environment to /sysroot "# chroot /sysroot/"
change desired password. root/any other user. "# passwd root"
when done. remount / to readonly back "# mount -o remount, ro /"
Then "# exit".
Then "# exit" again. system continue to boot.
login as root with the newly created password. DO NOT REBOOT YET.
SELinux will detect that the password file /etc/shadow has been changed and will restrict access to it). Instead, you must first restore the SELinux labels on that file:
"# restorecon /etc/shadow".
Then reboot

reference: https://www.datacentreplus.co.uk/support/knowledge-base/reset-root-password-in-centos-7/

mysql_upgrade return error "Can't get stat of './mysql/general_log.CSV"

2021-06-17T00:38:00.002+08:00

mysql_upgrade return error

Phase 3/6: Running 'mysql_fix_privilege_tables'
ERROR 13 (HY000) at line 286: Can't get stat of './mysql/general_log.CSV' (Errcode: 2 "No such file or directory")
ERROR 13 (HY000) at line 297: Can't get stat of './mysql/slow_log.CSV' (Errcode: 2 "No such file or directory")
ERROR 13 (HY000) at line 299: Can't get stat of './mysql/slow_log.CSV' (Errcode: 2 "No such file or directory")
ERROR 13 (HY000) at line 301: Can't get stat of './mysql/slow_log.CSV' (Errcode: 2 "No such file or directory")
FATAL ERROR: Upgrade failed

Solution:

Permalink

Elena Stepanova added a comment - 2016-10-11 17:42

This is very strange that general_log.CSV and slow_log.CSV did not exist, do you know how it happened? Did somebody remove them manually?
Did general_log.frm and slow_log.frm files exist?
The most likely reason for the problem is that due to the disappearance of CSV files, the tables were left in an inconsistent state.
You can try to do the following:

# Make sure there are no remains of the table

- rm ./mysql/general_log.* ./mysql/slow_log.*

# connect to the server and run

[MariaDB]> FLUSH TABLES;

# Then re-run

mysql_upgrade -uroot -p --force

It should work unless somebody previously tried to convert general_log and slow_log tables into InnoDB, in this case things can be a bit more complicated.

source: https://jira.mariadb.org/browse/MDEV-11032

Apache get concurrent connection

2020-11-25T22:22:00.001+08:00

Reference: https://www.cloudtechtiq.com/blog/check-apache-concurrent-connections-using-netstat-command

To Count Apache concurrent connection's, use any of the below commands.

netstat -nt | grep :80 | wc -l

netstat -plan|grep :80 | wc -l

netstat -an | grep 'EST' | wc -l

netstat -ant | grep ESTABLISHED | grep :80 | wc -l

ps -A | grep httpd | wc -l

ps -ef | grep http | wc -l

ps aux | grep httpd | wc -l

ps aux | grep http | grep -v "\(root\|grep\)" | wc -l

To print the active Internet connections to the server at port 80 and sort the results, use the below commands.

netstat -an | grep :80 | sort

netstat -plan | grep :80

netstat -anp | grep :80

To calculate and count, number of connection currently established from each IP address with server.

netstat -ntu | awk '{print $5}' | cut -d: -f1 | sort | uniq -c | sort -n

To calculate and count, number of connection currently established from each IP address through TCP or UDP protocol with server.

netstat -anp |grep 'tcp\|udp' | awk '{print $5}' | cut -d: -f1 | sort | uniq -c | sort -n

To Print ESTABLISHED connections instead of all connections, and displays the connections count for each IP

netstat -ntu | grep ESTAB | awk '{print $5}' | cut -d: -f1 | sort | uniq -c | sort -nr

To print the list of IP address and its connection count, that connect to port 80 on the server.

netstat -plan|grep :80|awk {'print $5'}|cut -d: -f 1|sort|uniq -c|sort -nk 1

To print all the apache httpd actual processes in Linux, use the below commands.

ps -aux | grep httpd  or  ps -ef | grep httpd

mysqldump comparison using compress option with bzip2 and gzip performance and the output size

2020-08-30T11:20:00.009+08:00

[root@server2 vagrant]# time mysqldump --compress myportal | gzip > test.gz

real 0m14.675s

user 0m7.426s

sys 0m0.618s

[root@server2 vagrant]# time mysqldump myportal | gzip > test.gz

real 0m9.455s

user 0m6.343s

sys 0m0.646s

[root@server2 vagrant]# time mysqldump --compress myportal | gzip > test-compress-gzip.gz

real 0m14.603s

user 0m7.371s

sys 0m0.580s

[root@server2 vagrant]# time mysqldump myportal | gzip > test--gzip.gz

real 0m9.357s

user 0m6.314s

sys 0m0.668s

[root@server2 vagrant]# time mysqldump myportal | bzip2 > test--bzip.bz2

real 1m10.520s

user 1m7.152s

sys 0m0.739s

[root@server2 vagrant]# time mysqldump --compress myportal | bzip2 > test-compress-bzip.bz2

real 1m15.358s

user 1m7.156s

sys 0m0.773s

[root@server2 vagrant]# du -h test-*

6.7M test--bzip.bz2

13M test--gzip.gz

6.7M test-compress-bzip.bz2

13M test-compress-gzip.gz

[root@server2 vagrant]# du test-*

6808 test--bzip.bz2

12376 test--gzip.gz

6808 test-compress-bzip.bz2

12376 test-compress-gzip.gz

bzip2 compress more than gzip but the process time is longer than gzip.

So please choose between speed and compression ratio, which suite ur needs.

Regex to find space

2019-12-09T20:19:00.001+08:00

(?:^.+?\K | (?=[0-9]+.+))

Show hidden files and sub directories in root directory

2019-12-03T18:57:00.001+08:00

By default the root directory will not show you the directories like /usr, /bin, /etc etc. To make them visible you need to show the hidden files.

Open terminal and type the following command and hit return.

defaults write com.apple.finder AppleShowAllFiles -bool TRUE;killall Finder

Reference: https://themacbeginner.com/view-content-root-directory-mac-os-x/

rescue corrupted mbr centos / linux

2019-07-09T10:50:00.001+08:00

https://wiki.centos.org/TipsAndTricks/ReinstallGRUB

Apache ProxyPass Proxy to remain original host ip on request.

2019-03-27T00:16:00.001+08:00

source: https://www.leaseweb.com/labs/2014/12/tutorial-apache-2-4-transparent-reverse-proxy/

Mysql On delete cascade reference information

2018-12-29T20:28:00.000+08:00

Tips to find tables affected by MySQL ON DELETE CASCADE action

Sometimes, it is useful to know which table is affected by the MySQL ON DELETE CASCADE referential action when you delete data from a table. You can query this data from the referential_constraints in the information_schema database as follows:

1
2
3
4
5
6
7
8
9
10
USE information_schema;
 
SELECT 
    table_name
FROM
    referential_constraints
WHERE
    constraint_schema = 'database_name'
        AND referenced_table_name = 'parent_table'
        AND delete_rule = 'CASCADE'

source: http://www.mysqltutorial.org/mysql-on-delete-cascade/

mariadb @ mysql change datadir to /home/ directory

2018-11-29T21:05:00.001+08:00

chcon -R -u system_u -r object_r -t mysqld_db_t $DATADIR

Troubleshooting “Permission denied” when attempting to connect to Redis from PHP script

2018-06-27T08:46:00.000+08:00

Problem solved, type:

/usr/sbin/setsebool httpd_can_network_connect=1

By default, SELinux does not allow Apache to make socket connections. More information can be found here.

source: https://stackoverflow.com/questions/8765848/troubleshooting-permission-denied-when-attempting-to-connect-to-redis-from-php

PHP / CentOS 7Connect DATABASE Error TYPE: 2002: Permission denied

2018-06-26T14:41:00.000+08:00

9down voteaccepted

I had the same issue after getting a new CentOS 7 box, running SELinux. I could connect to my remote MySQL DB server from the command line, but Drupal (and test PHP scripts) could not.

The issue turned out to be the SELinux security policies.

By default, the policy httpd_can_network_connect_db is disabled (meaning that your web server cannot contact a remote DB.)

Check this via:

getsebool -a | grep httpd

If httpd_can_network_connect_db is Off, enable it via:

setsebool -P httpd_can_network_connect_db 1

(The -P flag makes the change permanent, so the setting survives a reboot.)

source: https://stackoverflow.com/questions/41178774/connect-database-error-type-2002-permission-denied

Nginx php html permission denied

2018-06-26T09:21:00.000+08:00

After searching , I found it.It's all deals with SELINUX which is a security feature. when using ls -Z

drwxrwxrwx. ec2-user root system_u:object_r:httpd_sys_content_t:s0 www

change this to

drwxrwxrwx. ec2-user root system_u:object_r:httpd_sys_rw_content_t:s0 www

using cmd

chcon -R -t httpd_sys_rw_content_t /var/www

source: https://stackoverflow.com/questions/37710979/nginx-failed-to-open-stream-permission-denied-in-var-www-example-com

2:12

2017-07-18T18:06:00.000+08:00

https://xmovies8.ru/movie/2-22-2017.87767/watching.html

Sublime Text Licence

2017-07-13T20:30:00.001+08:00

-----Begin----------

TwitterInc
200 User License
EA7E-890007
1D77F72E 390CDD93 4DCBA022 FAF60790
61AA12C0 A37081C5 D0316412 4584D136
94D7F7D4 95BC8C1C 527DA828 560BB037
D1EDDD8C AE7B379F 50C9D69D B35179EF
2FE898C4 8E4277A8 555CE714 E1FB0E43
D5D52613 C3D12E98 BC49967F 7652EED2
9D2D2E61 67610860 6D338B72 5CF95C69
E36B85CC 84991F19 7575D828 470A92AB

----------End---------

Git delete merged remote branch

2016-11-01T17:10:00.000+08:00

git branch -r --merged origin/master | grep origin | grep -v '>' | grep -v master | awk '{sub(/origin\//,"");print}'| xargs git push origin --delete

phpstorm 2016.2

2016-10-01T07:33:00.001+08:00

code:

43B4A73YYJ-eyJsaWNlbnNlSWQiOiI0M0I0QTczWVlKIiwibGljZW5zZWVOYW1lIjoibGFuIHl1IiwiYXNzaWduZWVOYW1lIjoiIiwiYXNzaWduZWVFbWFpbCI6IiIsImxpY2Vuc2VSZXN0cmljdGlvbiI6IkZvciBlZHVjYXRpb25hbCB1c2Ugb25seSIsImNoZWNrQ29uY3VycmVudFVzZSI6ZmFsc2UsInByb2R1Y3RzIjpbeyJjb2RlIjoiSUkiLCJwYWlkVXBUbyI6IjIwMTctMDItMjUifSx7ImNvZGUiOiJBQyIsInBhaWRVcFRvIjoiMjAxNy0wMi0yNSJ9LHsiY29kZSI6IkRQTiIsInBhaWRVcFRvIjoiMjAxNy0wMi0yNSJ9LHsiY29kZSI6IlBTIiwicGFpZFVwVG8iOiIyMDE3LTAyLTI1In0seyJjb2RlIjoiRE0iLCJwYWlkVXBUbyI6IjIwMTctMDItMjUifSx7ImNvZGUiOiJDTCIsInBhaWRVcFRvIjoiMjAxNy0wMi0yNSJ9LHsiY29kZSI6IlJTMCIsInBhaWRVcFRvIjoiMjAxNy0wMi0yNSJ9LHsiY29kZSI6IlJDIiwicGFpZFVwVG8iOiIyMDE3LTAyLTI1In0seyJjb2RlIjoiUEMiLCJwYWlkVXBUbyI6IjIwMTctMDItMjUifSx7ImNvZGUiOiJSTSIsInBhaWRVcFRvIjoiMjAxNy0wMi0yNSJ9LHsiY29kZSI6IldTIiwicGFpZFVwVG8iOiIyMDE3LTAyLTI1In0seyJjb2RlIjoiREIiLCJwYWlkVXBUbyI6IjIwMTctMDItMjUifSx7ImNvZGUiOiJEQyIsInBhaWRVcFRvIjoiMjAxNy0wMi0yNSJ9XSwiaGFzaCI6IjMzOTgyOTkvMCIsImdyYWNlUGVyaW9kRGF5cyI6MCwiYXV0b1Byb2xvbmdhdGVkIjpmYWxzZSwiaXNBdXRvUHJvbG9uZ2F0ZWQiOmZhbHNlfQ==-keaxIkRgXPKE4BR/ZTs7s7UkP92LBxRe57HvWamu1EHVXTcV1B4f/KNQIrpOpN6dgpjig5eMVMPmo7yMPl+bmwQ8pTZaCGFuLqCHD1ngo6ywHKIQy0nR249sAUVaCl2wGJwaO4JeOh1opUx8chzSBVRZBMz0/MGyygi7duYAff9JQqfH3p/BhDTNM8eKl6z5tnneZ8ZG5bG1XvqFTqWk4FhGsEWdK7B+He44hPjBxKQl2gmZAodb6g9YxfTHhVRKQY5hQ7KPXNvh3ikerHkoaL5apgsVBZJOTDE2KdYTnGLmqxghFx6L0ofqKI6hMr48ergMyflDk6wLNGWJvYHLWw==-MIIEPjCCAiagAwIBAgIBBTANBgkqhkiG9w0BAQsFADAYMRYwFAYDVQQDDA1KZXRQcm9maWxlIENBMB4XDTE1MTEwMjA4MjE0OFoXDTE4MTEwMTA4MjE0OFowETEPMA0GA1UEAwwGcHJvZDN5MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAxcQkq+zdxlR2mmRYBPzGbUNdMN6OaXiXzxIWtMEkrJMO/5oUfQJbLLuMSMK0QHFmaI37WShyxZcfRCidwXjot4zmNBKnlyHodDij/78TmVqFl8nOeD5+07B8VEaIu7c3E1N+e1doC6wht4I4+IEmtsPAdoaj5WCQVQbrI8KeT8M9VcBIWX7fD0fhexfg3ZRt0xqwMcXGNp3DdJHiO0rCdU+Itv7EmtnSVq9jBG1usMSFvMowR25mju2JcPFp1+I4ZI+FqgR8gyG8oiNDyNEoAbsR3lOpI7grUYSvkB/xVy/VoklPCK2h0f0GJxFjnye8NT1PAywoyl7RmiAVRE/EKwIDAQABo4GZMIGWMAkGA1UdEwQCMAAwHQYDVR0OBBYEFGEpG9oZGcfLMGNBkY7SgHiMGgTcMEgGA1UdIwRBMD+AFKOetkhnQhI2Qb1t4Lm0oFKLl/GzoRykGjAYMRYwFAYDVQQDDA1KZXRQcm9maWxlIENBggkA0myxg7KDeeEwEwYDVR0lBAwwCgYIKwYBBQUHAwEwCwYDVR0PBAQDAgWgMA0GCSqGSIb3DQEBCwUAA4ICAQC9WZuYgQedSuOc5TOUSrRigMw4/+wuC5EtZBfvdl4HT/8vzMW/oUlIP4YCvA0XKyBaCJ2iX+ZCDKoPfiYXiaSiH+HxAPV6J79vvouxKrWg2XV6ShFtPLP+0gPdGq3x9R3+kJbmAm8w+FOdlWqAfJrLvpzMGNeDU14YGXiZ9bVzmIQbwrBA+c/F4tlK/DV07dsNExihqFoibnqDiVNTGombaU2dDup2gwKdL81ua8EIcGNExHe82kjF4zwfadHk3bQVvbfdAwxcDy4xBjs3L4raPLU3yenSzr/OEur1+jfOxnQSmEcMXKXgrAQ9U55gwjcOFKrgOxEdek/Sk1VfOjvS+nuM4eyEruFMfaZHzoQiuw4IqgGc45ohFH0UUyjYcuFxxDSU9lMCv8qdHKm+wnPRb0l9l5vXsCBDuhAGYD6ss+Ga+aDY6f/qXZuUCEUOH3QUNbbCUlviSz6+GiRnt1kA9N2Qachl+2yBfaqUqr8h7Z2gsx5LcIf5kYNsqJ0GavXTVyWh7PYiKX4bs354ZQLUwwa/cG++2+wNWP+HtBhVxMRNTdVhSm38AknZlD+PTAsWGu9GyLmhti2EnVwGybSD2Dxmhxk3IPCkhKAK+pl0eWYGZWG3tJ9mZ7SowcXLWDFAk0lRJnKGFMTggrWjV8GYpw5bq23VmIqqDLgkNzuoog==

window 8.1 product key

2016-09-25T21:38:00.001+08:00

Windows 8.1 Single Language

Y9NXP-XT8MV-PT9TG-97CT3-9D6TC
TNH8J-KG84C-TRMG4-FFD7J-VH4WX (CN)

2016-06-27T22:19:00.001+08:00

Kabinet reshuffle after muhyidin and mukhriz sacked.

FIMM EXAM

2016-06-20T20:44:00.001+08:00

Unit trust exam

Service motosikal

2016-06-10T16:20:00.001+08:00

#servicemoto
#symvts200

opencv car counting

2016-05-10T13:19:00.001+08:00

Prerequisite:
OpenCV C++ Installation/Configuration:
YouTube video: https://www.youtube.com/watch?v=7SM5O...
GitHub repository: https://github.com/MicrocontrollersAn...

Part 1: OpenCV 3 Play Video File C++
YouTube video: https://www.youtube.com/watch?v=VE-1U...
GitHub repository: https://github.com/MicrocontrollersAn...

Part 2: OpenCV 3 Image Subtraction C++
YouTube video: https://www.youtube.com/watch?v=5SzNu...
GitHub repository: https://github.com/MicrocontrollersAn...

Part 3: OpenCV 3 Mouse Move Prediction Algorithm C++
YouTube video: https://www.youtube.com/watch?v=Tbcn7...
GitHub repository: https://github.com/MicrocontrollersAn...

Part 4: OpenCV 3 Multiple Object Tracking by Image Subtraction C++ full source code
YouTube video: https://www.youtube.com/watch?v=A4UDO...
GitHub repository: https://github.com/MicrocontrollersAn...

Part 5: OpenCV 3 Car Counting C++ full source code
YouTube video: https://www.youtube.com/watch?v=Y3ac5...
GitHub repository: https://github.com/MicrocontrollersAn...

FATWA: Ajaran Ilmu Makrifat (Mengenal Allah/Diri) Oleh Mohd. Yusof Cik Wook Yang Disebarkan oleh Haji Shaari Mohd Yusof

2016-01-21T16:43:00.001+08:00

http://www.e-fatwa.gov.my/fatwa-kebangsaan/ajaran-ilmu-makrifat-mengenal-allahdiri-oleh-mohd-yusof-cik-wook-yang-disebarkan-ol

Excel get 5 digit number from a string in a cell

2015-10-27T09:43:00.001+08:00

Excel get 5 digit number from a string in a cell.

It might be a postcode or whatever you can think of a 5 digit or any digit number.

=LOOKUP(2,1/(MMULT(0+(ISNUMBER(-MID(" "&H95,ROW(INDIRECT("1:"&LEN(H95)))+{0,1,2,3,4,5,6},1))+0={0,1,1,1,1,1,0}),{1;1;1;1;1;1;1})=7),MID(H95,ROW(INDIRECT("1:"&LEN(H95))),5))