This is just simple trick to retrieve data from mysql rows and turn into json. #!/usr/bin/env python import MySQLdb as mdb import sys con = mdb.connect(‘localhost’, ‘root’, ‘pass123’, ‘mydb1′, charset=’utf8’) cur = con.cursor(mdb.cursors.DictCursor) def get_post(): list = [] gw = {} cur.execute(“select * from tbl1_core”) rows = cur.fetchall() for i in rows: tes = [] # … Read more
Let’s setup jenkins with docker with local url : jenkins.local First, add local url to /etc/hosts $ sudo echo -e “127.0.0.1\tjenkins.local” >> /etc/hosts Install docker and pull newest jenkins image $ sudo apt-get install docker.io $ sudo docker pull jenkins $ sudo docker run -itd –name jenkins –publish 8080:8080 –publish 50000:50000 jenkins Setup nginx $ … Read more
Easy way to save session and load it again when you open up rtorrent, so you don’t have to start over again. Start rtorrent and set the session to some directory: $ rtorrent -s /tmp try to load it again: $ rtorrent -s /tmp
I moved my wordpress blog from my localhost to new hosting (new domain), and I was lazy to install the new one and I just copied all of my directory and upload it to new hosting. After a few configuration, my blog back to online with new domain, but the home page url was still referring to old … Read more
I guess my wordpress turned into jeopardy because I didn’t realize I moved from nginx to apache, and apache needs .htaccess file for permalink my links in wp. This is just default htaccess config : # BEGIN WordPress <IfModule mod_rewrite.c> RewriteEngine On RewriteBase / RewriteRule ^index\.php$ – [L] RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteRule … Read more
Sometimes you want to know the serial of your laptop that you’re using on ubuntu, use this command: sudo dmidecode | grep -A 9 “System Information” Or sudo dmidecode -s system-product-name
This is how I install python 2.7.13 without erasing the current version of python that exists inside the OS. It is an alternative install. $ wget https://www.python.org/ftp/python/2.7.13/Python-2.7.13.tar.xz $ tar xvf Python-2.7.13.tar.xz $ cd Python-2.7.13 $ ./configure $ make $ sudo make altinstall
Let’s say I want to have a project called webproject, and this project has own user with the same name to access the project directory. And this is supposed to be a python project and it needs virtual environment. also I want the project has specific python version 2.7 with virtualenv. So let’s get started. … Read more
Run playbook ansible by certain tag only, so the rest of task will be skipped ansible-playbook –tags mytag
what the heck is this? I tried to crop my image in wordpress but this error just showed up. The reason why the error showed up because I have not installed php-gd yet on my machine. So it messed up when trying to crop my image. Solution? try this: $ apt-get install php5-gd