Google Chrome will cache the DNS records, and always use the old records even the you update the hosts file.
Hold Ctrl + F5
Hold Command + Shift + R
How to enable instant host file reading in Chrome?
http://stackoverflow.com/questions/15289766/how-to-enable-instant-host-file-reading-in-chrome
MySQLdb is an thread-compatible interface to the popular MySQL database server that provides the Python database API.
|
1 2 3 4 5 6 |
# install mysql brew install mysql # update path export PATH=$PATH:/usr/local/mysql/bin # install MySQL-Python (MySQLdb) pip install MySQL-Python |
You need install mysql and link, before install MySQL-Python
|
1 2 3 4 |
# install mysql brew install mysql # update path export PATH=$PATH:/usr/local/mysql/bin |
Change the folder permission
|
1 |
sudo chown -R "$USER":admin /usr/local |
Unable to login linux console, always show login incorrect for any login name
Selected some security profile(e.g. PCI-DSS) during installation, but network connection is unavailable.
Installer unable to download some packages from the internet, and caused installation failure. You may feel the installation time longer than no security profile.
In my case is CentOS installer missing the web proxy settings 🙁
Select other security profile or setup correct network connection, and re-install the system.
CentOS-7 Installer Security Profiles
2.1. Requirements
These profiles require a connection to the internet to install. If you select a security profile that can not connect to the internet on port 80 (to mirror.centos.org), your install may fail spectacularly and not even allow access to the console locally. Please only try these profiles while connected to the internet.
Packages will be installed from the internet if you use security profiles, even if those packages also reside on the ISOs.
https://wiki.centos.org/TipsAndTricks/C7SecurityProfiles
MySQL throw the following error message on insert or update statement executed
|
1 |
ERROR 1366 (HY000): Incorrect integer value: '' for column 'id' at row 1 |
Try to update string value into integer column, and strict sql mode is enabled.
Mainly occurred on MySQL 5.x or above.
Update /etc/my.cnf , and remove STRICT_TRANS_TABLES from sql-mode
|
1 2 3 |
#sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" to sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" |
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_strict_trans_tables
I am running a small GitLab server for my personal use, but GitLab default concurrency settings up to 25.
So I try to update the max concurrency to free server resource.
|
1 |
vi /etc/gitlab/gitlab.rb |
Add or update the value
|
1 2 3 4 5 |
################## # GitLab Sidekiq # ################## sidekiq['concurrency'] = 5 |
|
1 2 |
gitlab-ctl reconfigure gitlab-ctl restart sidekiq |
|
1 |
mysqldump -u DATABASE_USER –p DATABASE_NAME > DATABASE_NAME.sql |
|
1 |
mysql -u DATABASE_USER –p DATABASE_NAME < DATABASE_NAME.sql |
Suggested to run the command in database server to get the fastest speed.
|
1 2 3 4 5 6 7 8 9 10 11 |
#install EPEL repo sudo yum install epel-release -y #install ATRPMS repo sudo rpm -ivh https://www.mirrorservice.org/sites/dl.atrpms.net/el7-x86_64/atrpms/stable/atrpms-repo-7-7.el7.x86_64.rpm # install ffmpeg sudo yum install ffmpeg -y # verify ffmpeg installation ffmpeg -version |
|
1 |
ffmpeg -i input.wav -f mp3 output.mp3 |
|
1 |
sudo yum install open-vm-tools -y |
|
1 2 3 |
# update system sudo yum install epel-release -y sudo yum update -y |
|
1 2 |
# temporary switches off SELinux enforcing sudo setenforce 0 |
|
1 2 3 4 5 6 7 8 9 |
# setup timezone sudo rm /etc/localtime sudo ln -s /usr/share/zoneinfo/Hongkong /etc/localtime # setup ntp service sudo yum -y install ntp sudo ntpdate pool.ntp.org sudo systemctl enable ntpd sudo systemctl start ntpd |
|
1 2 3 4 |
# install NGINX and PHP with PHP-FPM sudo yum install -y vim nginx php php-fpm php-mbstring php-gd php-bcmath php-mcrypt php-tidy php-xml php-xmlrpc php-soap php-mysql php-pdo php-devel sudo systemctl enable nginx php-fpm sudo systemctl start nginx php-fpm |
|
1 2 3 4 5 |
# update PHP configuration sudo vi /etc/php.ini :%s#;date.timezone =#date.timezone = Asia/Hong_Kong# :%s#expose_php = On#expose_php = Off# :wq |
|
1 2 3 4 |
# update php-fpm configuration sed -i 's/^user =.*$/user = nginx/g' /etc/php-fpm.d/www.conf sed -i 's/^group =.*$/group = nginx/g' /etc/php-fpm.d/www.conf cat /etc/php-fpm.d/www.conf |
|
1 2 3 4 5 6 |
# update NGINX configuration sudo cp /etc/nginx/nginx.conf /etc/nginx/nginx.conf.bak sudo tac /etc/nginx/nginx.conf.bak | awk '!p && /}/{print "\n}\n include /etc/nginx/vhosts/*.conf;";p=1;next} 1' | tac \ | awk '!p && /server {/{print " index index.php index.html index.htm;\n";p=1} 1' \ | awk '!p && /root/{print " root /var/www/html;";p=1;next} 1' \ | sudo tee /etc/nginx/nginx.conf |
|
1 2 3 4 5 6 |
# create folders and update permission sudo mkdir -p /etc/nginx/vhosts/ sudo mkdir -p /var/www/html/ sudo mkdir -p /var/www/vhosts/ sudo chown nginx:nginx /var/www/html/ -R sudo chown nginx:nginx /var/www/vhosts/ -R |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 |
# create dummy virtual host sudo cat > /etc/nginx/vhosts/example.com.conf <<- "EOF" # redirect to www ##server { ## listen 80; ## server_name example.com; ## return 301 http://www.example.com$request_uri; ##} server { listen 80; server_name www.example.com; root /var/www/vhosts/example.com/www; location / { try_files $uri $uri/ /index.php?$args; } location ~ .php$ { #fastcgi_pass unix:/var/run/php-fpm.sock; fastcgi_pass 127.0.0.1:9000; fastcgi_index /index.php; include /etc/nginx/fastcgi_params; fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name; fastcgi_read_timeout 300; } } EOF |
|
1 2 3 4 5 |
# create ip vhost from dummy virtual host cat /etc/nginx/vhosts/example.com.conf | sed '/^#/ d' | sed "s/[www.]*example.com/10.0.6.29/" | sudo tee /etc/nginx/vhosts/10.0.6.29.conf sudo mkdir -p /var/www/vhosts/10.0.6.29/www/ echo "<?php phpinfo();" | sudo tee /var/www/vhosts/10.0.6.29/www/index.php sudo nginx -s reload |
|
1 2 3 4 5 |
# create www vhost from dummy virtual host cat /etc/nginx/vhosts/example.com.conf | sed "s/example.com/yctin.com/" | sed "s/##//" | sudo tee /etc/nginx/vhosts/yctin.com.conf sudo mkdir -p /var/www/vhosts/yctin.com/www/ echo "<?php phpinfo();" | sudo tee /var/www/vhosts/yctin.com/www/index.php sudo nginx -s reload |
|
1 2 3 4 5 |
# create subdomain vhost from dummy virtual host cat /etc/nginx/vhosts/example.com.conf | sed '/^#/ d' | sed "s/example.com/yctin.com/g" | sed "s/www\./demo\./g" | sed "s/www;/demo;/g" | sudo tee /etc/nginx/vhosts/yctin.com.conf sudo mkdir -p /var/www/vhosts/yctin.com/demo/ echo "<?php phpinfo();" | sudo tee /var/www/vhosts/yctin.com/demo/index.php sudo nginx -s reload |
|
1 2 3 4 5 6 7 |
# setup firewall sudo yum install firewalld -y sudo systemctl enable firewalld sudo systemctl start firewalld sudo firewall-cmd --add-service=http --permanent sudo firewall-cmd --add-service=https --permanent sudo systemctl restart firewalld |
|
1 2 3 4 5 6 7 8 9 10 |
# update selinux policy, required for selinux enabled (p.s. not best practice) sudo setsebool -P httpd_anon_write 1 sudo chcon -u system_u -t httpd_sys_rw_content_t /var/www/html -R sudo chcon -u system_u -t httpd_sys_rw_content_t /var/www/vhosts/ -R # Allow PHP connect network setsebool -P httpd_can_network_connect 1 # Allow PHP connect remote database setsebool -P httpd_can_network_connect_db 1 |
|
1 |
sudo reboot |