Kelvin's tech-box

Topic

linux

A collection of 29 issues

Tar command usage

Create the tar file tar -czvp -f archive.tar.gz foo bar Create archive.tar.gz from files foo and bar with the preserved permission tar -cjvp -f archive.tar.bz2 foo bar How to split the file: split -b 4000k archive.tar.gz archive.20120829.tar.gz. -verbose creating

Install PIL on Ubuntu

Sometimes it's hard to install PIL on ubuntu, here are the tips to help fixing the install issue: Install the build dependencies sudo apt-get build-dep python-imaging Symlink the libraries: sudo ln -s /usr/lib/uname -i-linux-gnu/libfreetype.so /usr/lib/ sudo ln -s /usr/lib/uname -i-linux-gnu/libjpeg.

Setup Postgres on Ubuntu

Here is the brief step to setup the postgresql database on Ubuntu. Install sudo apt install postgresql postgresql-contrib sudo systemctl start postgresql.service Using postgres Roles and Database A default user account postgres is associated with role. sudo -i -u postgres psql postgres=# \q Create new role createuser --interactive or

Delete files with find results

When you tried to delete all files with the name abc.txt under the folder /home/kelvin, try the following commands(one of them works): find /home/kelvin -name abc.txt | xargs rm -rf find /home//kelvin -name abc.txt -exec rm -fv {} \; Refer the doc: http://www.linuxsir.org/

Start service automatically on linux server

Add the service as automatically startup 1. copy the startup script to /etc/init.d 2. sudo chmod 755 /etc/init.d/your_script 3. run the following commonds cd /etc/init.d sudo upate-rc.d your_script defaults xx(xx is the start sequence number) Remove the startup service

Enable the remote connection to the MySQL DB on Ubuntu Server

Create a MySQL user mysql> GRANT ALL PRIVILEGES ON remote.* TO remote@"%" IDENTIFIED BY "remotepwd"; Change the /etc/mysql/my.cnf disable the bind-address = 127.0.0.1 Restart the DB sudo /etc/init.d/mysql restart Done.

How to use the SSH in the proxy env

Sometimes you are working in the coperation dev environemnt and you found you stay behind the firewall, some ports are blocked, such as 22, and you have to access internet via corperation proxy server, but you do need to use ssh to connect some site outside of office. This post

Useful SSH commands

SSH is a great tool with all transport data encrypted, it provide safe tunnel and multiple identity verification approach. Here are some useful ssh command: * Copy SSH publish key to the target server ssh-copy-id user@host If you don't have the key pair, use ssh-keygen to generated keys

Common useful commands

* Copy remote single file to local scp username@host:/Users/xx/copyFile ./localDir * Copy remote directory to local scp -R username@host:/Users/xx/copyFile ./localDir * Delete all .svn folders recursively in current directory (Include the files in folders) find ./ -name ".svn" -type d -exec rm -rf {} \; * Delete