When using mysql client to login MySQL, it throws the following error: If it’s alpine linux, then simply install mariadb-connector-c
Category: Server
How to setup Gitlab runner with KVM enabled
To implement the CI pipeline for the Android project, I need to run Gitlab CI, in which KVM is enabled. TL; TR Enable VTx virtualization technology in your server BIOS Pass /dev/kvm to Gitlab runner Sample .gitlab-ci.yml However, the pipeline was failing with the following error. Enable VTx virtualization technology First, I had to configure…
Change Java OpenJDK version in Arch Linux
Issue: When execute npm run android for React Native, the build error occurred as below: Solution: It’s because currently Java version is lower than 11. Assuming already has another Java JDK, simply change Java for Arch Linux. Reference: https://edgardorl.com/blog/configure-java-in-arch-linux-to-run-a-react-native-application/
Convert gnome-boxes virtual machine image to Oracle Virtual Box image
First convert gnome-boxes image to Virtual Box image Open Virtual Box Click Add button and follow below steps
Gitlab troubleshooting
Environment: Gitlab is running under docker Error with ActiveModel::UnknownAttributeError (unknown attribute ‘author_name’ for SecurityEvent.):
Mount iPhone/iPad in Arch Linux
Install libimobiledevice and ifuse$ yays libimobiledevice ifuse (* important) Pair with iPad – make sure iPad is connected via USB cable$ idevicepair pair Run usbmuxd $ sudo usbmuxd -f -v Create mount folder$ sudo mkdir /media/ipad$ sudo chmod 777 /media/ipad Mount iPad using ifuse$ ifuse /media/ipad Open file manager, then you will see iPad is…
When Arch Linux installation, cannot find nvme0n1 in DELL XPS 13
When you do lsblk, it does not show your SSD, then it means RAID for SATA Operation is on. Simply open Bios -> System Configuration -> SATA Operation and set “AHCI” Refer Install Arch Linux with Full Disk Encryption (LVM on LUKS) for Dell XPS 13 – https://gist.github.com/chrisleekr/a23e93edc3b0795d8d95f9c70d93eedd
Linux Docker uses excessive memory
Issue: I have a 16G memory and configured swap as 16G. When start mysql docker, mysqld uses crazy amount of memory and make the system freeze. References: https://success.docker.com/article/node-using-swap-memory-instead-of-host-memory Solution
VirtualBox + Windows 7 USB storage not recognised
Environments: Arch Linux Oracle VM VirtualBox 6.0.8 + Extension Pack Issue: In “Device Manager”, Universal Serial Bus Controller driver is not installing correctly. USB storage is not showing. Driver not found for USB storage. Solution: Install Intel USB 3.0 eXtensible Host Controller Driver – https://downloadcenter.intel.com/download/21129/USB-3-0-Driver-Intel-USB-3-0-eXtensible-Host-Controller-Driver-for-Intel-7-Series-C216-Chipset-Family Then reboot References: https://forums.virtualbox.org/viewtopic.php?f=7&t=84793 https://dwaves.org/2016/10/11/linux-debian-host-virtualbox-5-x-windows-7-guest-usb-3-0-external-harddisk-hardware-verr_pdm_no_usb_ports/
Share clipboard between GNOME and Boxes (Windows)
Reference: https://help.gnome.org/users/gnome-boxes/stable/clipboard.html.en https://www.spice-space.org/download.html While express installation typically takes care of making shared clipboard available to you, express installation is not available for all operating systems. In such cases or if you choose manual installation, for shared clipboard to work the SPICE vdagent needs to be installed in the guest. In most Linux-based operating systems the…
Winetricks failed to install WMP9
References: https://www.hahwul.com/2018/08/install-kakaotalk-on-ubuntu-18.04.html https://www.playonlinux.com/en/topic-16540-MPSetup_wmp9_will_not_run.html Error message: Solution: Download MPsetup.exe from https://web.archive.org/web/20180404022333/http://download.microsoft.com/download/1/b/c/1bc0b1a3-c839-4b36-8f3c-19847ba09299/MPSetup.exe Save as /home/{username}/.cache/winetricks/wmp/MPSetup.exe Rerun winetricks
Certbot으로 무료 SSL/TLS 인증서 발급/재발급 하기
When you get 403 Forbidden error in VentraIP shared hosting
Out of nowhere, I started getting the error when I try to post any article. After in-depth investigation, I found if I add any code snippet, I cannot save or publish the article due to getting 403 Forbidden error in the server. Other articles are suggesting to do following things: Disable all plugins Fix folder/file…
Backup/Restore pacman & yaourt packages list
Arch linux Backup pacman package list pacman -Qqet | grep -v “$(pacman -Qqg base)” | grep -v “$(pacman -Qqm)” > pacman-packages.txt Restore pacman package pacman -S –needed $(cat pacman-packages.txt) Backup yaourt package list pacman -Qm > yaourt-packages.txt Backup yaourt package yaourt -S –needed –noconfirm $(cat yaourt-packages.txt)
Error on installing `networkmanager-l2tp 1.2.10-3` in Arch Linux
References: https://gist.github.com/pastleo/aa3a9524664864c505d637b771d079c9 https://askubuntu.com/questions/981165/l2tp-ipsec-failing-to-connect-kubuntu-17-10 When run the command to install the package `networkmanager-l2tp 1.2.10-3`, an error occurs like below: $ yaourt -S networkmanager-l2tp … ==> Validating source files with md5sums… network-manager-l2tp-1.2.10.tar.gz … Passed network-manager-l2tp-1.2.10.tar.gz.asc … Skipped ==> Verifying source file signatures with gpg… network-manager-l2tp-1.2.10.tar.gz … FAILED (unknown public key 49A7787EF8D3C039) ==> ERROR: One or more…
Get AWS EC2 tags to environment parameters for apache2
Objective: AWS instances are assigned tags per instance. Need tags to be environment parameters for Apache2; thus, web application can retrieve environment parameter. Step 1: Configure tags in AWS EC2 instance Step 2: Setup IAM user and get access key id and secret access key Step 3: Access to SSH and append…
How to re-compile imap.so with SSL enabled for MAMP Pro (Mac), macOS Sierra
Steps for re-compiling imap.so 1. Download imap source $ cd ~/Downloads $ wget -c ftp://ftp.cac.washington.edu/imap/imap-2007f.tar.gz $ rm -rf imap-2007f $ tar xvvfz imap-2007f.tar.gz $ cd imap-2007f $ nano Makefile 2. Find the text osx: and replace SSLINCLUDE=/usr/include/openssl to SSLINCLUDE=/usr/local/opt/openssl/include/openssl osx: osxok an $(TOUCH) ip6 $(BUILD) BUILDTYPE=$@ IP=$(IP6) EXTRAAUTHENTICATORS=”$(EXTRAAUTHENTICATORS) gss” \ SPECIALS=”SSLINCLUDE=/usr/local/opt/openssl/include/openssl SSLLIB=/usr/lib SSLCERTS=/System/Library/OpenSSL/certs SSLKEYS=/System/Library/OpenSSL/private…
How to install memcache.so/memcached.so for MAMP Pro (Mac)
Install memcache.so for PHP 5.6 1. Install memcached $ brew install memcached 2. Download php source code http://www.php.net/downloads.php 3. Copy source code to the folder /Applications/MAMP/bin/php/{php version}/include/php e.g.) /Applications/MAMP/bin/php/php5.6.10/include/php 4. Install libiconv $ brew install homebrew/dupes/libiconv 5. Execute configure in php source folder $ cd /Applications/MAMP/bin/php/php5.6.10/include/php $ ./configure –with-iconv=/usr/local/Cellar/libiconv/1.14/ 6….
Vagrant Box 디스크 용량 늘리기
참고(Reference): http://tuhrig.de/resizing-vagrant-box-disk-space/ http://derekmolloy.ie/resize-a-virtualbox-disk/ http://stackoverflow.com/questions/11659005/how-to-resize-a-virtualbox-vmdk-file 요약 Vagrant는 디스크 용량을 바꿀수있는 옵션을 주지 않는다. 기본으로 40G(기본 이미지 10GB)를 제공하는데, 이 용량을 바꾸는 옵션을 제공하지 않는다. Vagrant의 VirtualBox를 리사이징할려면 수동으로 리사이징을 해야한다. 순서 Vagrant VM을 먼저 종료시킨다. $ vagrant halt 그리고 Vagrant VirtualBox VM이 어디에 위치한지 VirtualBox에서 찾는다. 해당 Virtualbox VM 폴더로 가서 VMDK disk를 VDI디스크로…
[Linux] Remove all email & Reset /var/log files
Delete all mails $ mail > d * > q Force to reset log files not recommended $ sudo su $ cd /var/log $ > lastlog $ > wtmp $ > dpkg.log $ > kern.log $ > syslog $ > messages $ exit
Vagrant Scalable Web Application Architecture
Deploying scalable web application using Vagrant, Consul, Consul Template, nginx and HAProxy Source Repo: https://github.com/chrisleekr/vagrant-scalable-web-application-architecture This is proof-of-concept project to spin up scalable web application architecture with Vagrant. The project involves: Vagrant for launching multiple VM instances and persistent storage Consul for health checking and service discovery Consul Template for automated load balancer management nginx for…
Vagrant MySQL Master-Slave Replication
Vagrant MySQL Master-Slave Replication Source Repo: https://github.com/chrisleekr/vagrant-mysql-master-slave-replication Vagrantfile to spin up MySQL Master-Slave replication with persistent data storage Note: This project is created for just practice. Not suitable for production use. Prerequisites Vagrant 1.8.1+: http://www.vagrantup.com/ VirtualBox: https://www.virtualbox.org/ Usage $ git clone https://github.com/chrisleekr/vagrant-mysql-master-slave-replication.git $ cd vagrant-mysql-master-slave-replication $ vagrant up After vagrant machines are running, you can connect…
VPS – Apache & MySQL Performance Tuning
Apache 1. Open/Create /var/www/vhosts/{hostname}/conf/vhosts.conf 2. Add oradjust below code KeepAlive On MaxKeepAliveRequests 29 KeepAliveTimeout 15 3. Copy to make backup of apache configuration # cp -p /etc/httpd/conf/httpd.conf /etc/httpd/conf/httpd.conf.YYYY-MM-DD.bak 4. Execute below shell script one by one # ramCount=`awk ‘match($0,/vmguar/) {print $4}’ /proc/user_beancounters` # ramBase=-16 && for ((;ramCount>1;ramBase++)); do ramCount=$((ramCount/2)); done # perl -0 -p -i…
.htaccess GZIP Compression & Enable Keep-alive
To make faster webpage loading, use Gzip compress and Enable keep-alive in htaccess <ifModule mod_deflate.c> AddOutputFilterByType DEFLATE text/text text/html text/plain text/xml text/css application/x-javascript application/javascript </ifModule> <ifModule mod_headers.c> Header set Connection keep-alive </ifModule> In Plesk Control Panel, follow below steps Access SSH as root user Go to /var/www/vhosts/{domain}/conf Create or Modify vhosts.conf Add following code…
.htaccess to force browsers to display a download dialog for non-image files
.htaccess to force browsers to display a download dialog for non-image files Reference: jQuery File Upload # The following directives force the content-type application/octet-stream # and force browsers to display a download dialog for non-image files. # This prevents the execution of script files in the context of the website: ForceType application/octet-stream Header set Content-Disposition…