Remote Access to MySQL for CyberPanel
The configuration is stored here. /etc/mysql/mariadb.conf.d/50-server.cnf Tested on CyberPanel 2.3 build 2
The configuration is stored here. /etc/mysql/mariadb.conf.d/50-server.cnf Tested on CyberPanel 2.3 build 2
Recently upgraded my CyberPanel to version 2.3.2 and found that my accounts’ SSL renewal starts to fail. I checked the logs and found that there is a process that checks the acme-challenge folder for a static file before able to renew the SSL. Before this, it was randomly generated files for verification purpose. This is … Read more
HeidiSQL is a great tool to manage MySQL and other supported databases. One useful feature it has is to remember last commands used. I love this feature, however, each time I moved on to another project, the previous command will be there. It has never bothered me but somehow, I just have to know how … Read more
If you are looking for a Cloud Storage and are new to OneDrive, use this link to get free additional 0.5Gb storage space. https://onedrive.live.com?invref=e6b16e5e0992e1b9&invscr=90 You and I will benefits from this. Thank you very much.
I’m from Malaysia and if I’m tested positive for COVID-19, I’d need to be quarantined in designated place such as MAEPS, Serdang or hotels. This post will serve as my personal checklist should the above happens. Clothes for a week or two Laundry bags Toiletries Toothbrush Toothpaste Toilet paper rolls (in case those provided runs … Read more
If you have your SSL certificate in p7b format and need to convert to pfx format, you’ll need 3 files. The private key you get when generating your CSR The p7b certificate file The rootca bundle file Use the following command to generate your pfx certificate. openssl pkcs12 -export -in p7bcert.crt -inkey private.key -out outfile.pfx … Read more
Recently we received complaints from our programmers saying their codes to send emails via smtp.office365.com were failing due to login failure. We checked and found that the issue is due to the introduction of Security Defaults in Azure security to block legacy authentication methods. As a quick solution, we resorted to turning off the securiy … Read more
I’ve recently upgraded my Microsoft Windows 10 to version 1909. The first issue I experience when I wanted to resume my programming tasks were “php artisan serve” encountered the following error. Error creating winpty: ConnectNamedPipe failed: Windows error 232 Based on my research, it was due to antivirus blocking winpty. I was using Git Bash … Read more
I’ve upgraded my Microsoft Outlook to Microsoft Outlook 2016/365 and added IMAP connection to my Gmail account. I was expecting that all IMAP folders to be listed as per my older Outlook. Unfortunately I found that all folders were available except the All Mail folder. This folder will list all emails available in my Gmail … Read more
If you’re on shared hosting using cPanel as the control panel, you’d probably has the same problem as mine. The ini_set function is disabled by the hosting company for security purposes. Yeah, I know it’s for security purposes, but if I have to use it, I have to use it. So I’ve learned from others … Read more