Safely inject the values into SQL

Uncategorized /

Other than using bind in SQL, this is the old school way to solve the SQL query to prevent injection attack Sample Code // a sample list of values to use in IN(): $values = [1,4,10,’12a’,’xy\’z’]; // VERSION 1. For integers: make sure all array elements are integers $in = implode(‘,’, array_map(‘intval’, $values)); // VERSION 2. For strings: apply PDO::quote() function to all elements $in = implode(‘,’, array_map([$pdo, ‘quote’], $values)); // VERSION 3. Custom sanitization: allow only letters a[…]

Safely inject the values into SQL Read More »

Installing PHP Extension in WP ENV

Docker, PHP, Wordpress /

I need pdo_mysql php extension to use on my Wordpress plugins. After a day of research, I found out that this is the limitation of wp-env. The developers do not want us to touch more to any setting of PHP and Docker. So we have to manually install everytime after wp-env start. You can use this way to install other php extensions. Install pdo_mysql after WP-ENV started. wp-env start docker ps docker exec -it [WORDPRESS_CONTAINER_ID] docker-php-ext-install pdo_mysql docker exec -it [WORDPRESS_CONT[…]

Installing PHP Extension in WP ENV Read More »

Restore Discourse from Terminal

Linux /

Restore discourse from terminal Preparing copy the backup file to from old host /var/discourse/shared/standalone/backups/default to new host /var/discourse/shared/standalone/backups/default Restore cd /var/discourse ./launcher enter app discourse enable_restore discourse restore juzhax-com-2021-03-21-043426-v20210315173137.tar.gz Rebuild cd /var/discourse ./launcher rebuild app

Restore Discourse from Terminal Read More »

Running two discourse in one server

Linux /

I’m going to duplicate from /var/discourse to /var/discourse2 and make it run both discourse docker together in a server. Preparing sudo -s git clone https://github.com/discourse/discourse_docker.git /var/discourse2 cd /var/discourse2 Transfer Create a directory for the second discourse mkdir -p /var/discourse2/shared/standalone/backups/default cp /var/discourse/container/app.yml /var/discourse/container/app2.yml Modify App2.yml expose: # – "80:80" # http – – Remember to change the port # – "443[…]

Running two discourse in one server Read More »

Error: Package: ImageMagick6-6.9.11.3-1.el7.remi.x86_64 (@remi)

Linux /

Error message Error: Package: ImageMagick6-6.9.11.3-1.el7.remi.x86_64 (@remi) Requires: ImageMagick6-libs(x86-64) = 6.9.11.3-1.el7.remi Removing: ImageMagick6-libs-6.9.11.3-1.el7.remi.x86_64 (@remi) ImageMagick6-libs(x86-64) = 6.9.11.3-1.el7.remi Obsoleted By: ImageMagick-libs-6.9.11.60-1.el7.remi.x86_64 (remi) ~ImageMagick-libs(x86-64) = 6.9.11.60-1.el7.remi Error: Package: ImageMagick6-c++-6.9.11.3-1.el7.remi.x86_64 (@remi) Requires: ImageMagick6-libs(x86-64) = 6.9.11.3-1.el7.remi Removing: Im[…]

Error: Package: ImageMagick6-6.9.11.3-1.el7.remi.x86_64 (@remi) Read More »

Error: Can’t find command linux during boot

Linux /

Recently one of my server unable to start during boot time. I received the screenshot from my web hosting company and showing with these error. error: can’t find command linux . Press any key to continue … Solution The problem is the linux and initrd command used in /boot/efi/EFI/centos/grub.cfg is not found in your centos (or any default boot OS). You must replace the linux to linuxefi and initrd to initrdefi inside the grub.cfg file. boot to your CentOS terminal (If can’t boot, you can try[…]

Error: Can’t find command linux during boot Read More »

Google Authenticator Crash After Update iOS 14.2

Google /

After updated iPhone to iOS 14.2, you may get crash on the Google Authenticator every time open. It makes many users cannot login to the APPs that need 2FA. The latest version is Version 3.0.1 and it was 2 years ago. I don’t think they will update soon. Solution I’ve find out this solution. Please make sure DO NOT remove or uninstall the APP. If you remove or uninstall, all your data will gone and you are not able to login to your accounts again. Settings General iPhone Storage Choose Authentica[…]

Google Authenticator Crash After Update iOS 14.2 Read More »

stack Error: EACCES: permission denied sqlite3

Linux /

Installing n8n npm install n8n -g npx n8n What is n8n ? n8n (pronounced n-eight-n) helps you to interconnect every app with an API in the world with each other to share and manipulate its data without a single line of code. It is an easy to use, user-friendly and highly customizable service, which uses an intuitive user interface for you to design your unique workflows very fast. Hosted on your server and not based in the cloud, it keeps your sensible data very secure in your own trusted databas[…]

stack Error: EACCES: permission denied sqlite3 Read More »

Server installation process already in progress – waiting and retrying

1 Comment / Visual Studio Code, Linux /

This happen after my MacBook Pro wakeup from sleep. I cannot connect back to my server using Visual Studio Code. Output log from Visual Studio Code [16:26:43.681] Server installation process already in progress – waiting and retrying [16:26:43.681] Terminating local server [16:26:43.687] Local server exit: 15 [16:26:44.688] askpass server listening on /var/folders/gx/czncylwj1hx6d3_l41862hf40000gn/T/vscode-ssh-askpass-53d9a6d10ba0ccdb298527c460e7eece6924ff2c.sock [16:26:44.689] Spawning local se[…]

Server installation process already in progress – waiting and retrying Read More »