Skip to content

Instantly share code, notes, and snippets.

Working from home

Achilleas Pipinellis axilleas

Working from home
View GitHub Profile
View download_parse_json.rb
require "rubygems"
require "json"
require "net/http"
require "uri"
uri = URI.parse("")
http =, uri.port)
request =
axilleas / db
Last active Aug 29, 2015 — forked from maellak-test/db
View db
In file C:\xampp\htdocs\openeclass\install\install_db.php on line 684
Error: Unable to execute statement with error: "You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the right syntax to
use near ' `attempt_status` tinyint(4) NOT NULL DEFAULT 1, ' at line 9" (SQLSTATE=1064 ERROR=42000)
[Statement='CREATE TABLE IF NOT EXISTS `exercise_user_record` ( `eurid` INT(11) NOT NULL AUTO_INCREMENT
`record_start_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `record_end_date` DATETIME DEFAULT NULL,
`total_score` INT(11) NOT NULL DEFAULT 0, `total_weighting` INT(11) DEFAULT 0, `attempt` INT(11) NOT NULL DEFAULT 0),
`attempt_status` tinyint(4) NOT NULL DEFAULT 1, `secs_remaining` INT(11) NOT NULL DEFAULT '0')
DEFAULT CHARACTER SET=utf8' Elapsed=0.00097599999999998]
View gitolab.php
#!/usr/bin/php -qC
* @file gitolab.php
* @author Benoit Zohar
* @link
* @last-edited 2015-01-09
* @description Migrate projects from Gitolite to GitLab
View gist:b0e7bc364a0bf44c998b
sam@ubuntu discourse % rm -fr tmp/cache
sam@ubuntu discourse % rm -fr public/assets
sam@ubuntu discourse % time RAILS_ENV=production bin/rake assets:precompile
58.55s user 1.79s system 100% cpu 1:00.02 total
echo 'export PATH=$HOME/local/bin:$PATH' >> ~/.bashrc
. ~/.bashrc
mkdir ~/local
mkdir ~/node-latest-install
cd ~/node-latest-install
curl | tar xz --strip-components=1
./configure --prefix=~/local
make install # ok, fine, this step probably takes more than 30 seconds...
curl | sh

Vagrant & NFS for systemd users

Create group vagrant and add your user to the vagrant group:

groupadd vagrant
usermod -aG vagrant user

Drop these lines in a new file /etc/sudoers.d/vagrant

View gist:b4fb3ba4ffc247976bea
user www-data;
worker_processes 4; # number of cores on machine
error_log /var/log/nginx/error.log;
events {
worker_connections 1024;
http {
axilleas /
Created Jun 17, 2012 — forked from cristianrasch/
Install Gitlab on Debian Squeeze/Wheezy
aptitude install -y git curl python-dev python-pip redis-server ruby1.9.1-full rubygems1.9.1
aptitude install -y mysql-server libmysqlclient-dev
adduser --system --shell /bin/sh --gecos 'git version control' --group --disabled-password --home /home/git git
adduser --disabled-login --gecos 'gitlab system' gitlab
usermod -a -G git gitlab
su - gitlab
ssh-keygen -q -N '' -t rsa -f /home/gitlab/.ssh/id_rsa
aptitude install gitolite
cp /home/gitlab/.ssh/ /home/git/
su - git
axilleas / gist:3115671
Created Jul 15, 2012
Adding magnet protocol association to Firefox
View gist:3115671
In about:config add the following:
Set it's initial value to false. When you open a magnet link you will be prompted with a Launch Application dialogue. From there simply select your chosen torrent client. This technique can also be used with other protocols.
View _django1.4.patch
--- 2012-06-16 23:48:07.256319726 +0900
+++ .compfunc/_django 2012-06-16 23:55:32.556331127 +0900
@@ -31,7 +31,6 @@
"cleanup:remove old data from the database"
"compilemessages:compile .po files to .mo for use with gettext"
"createcachetable:creates table for SQL cache backend"
- "createsuperuser:create a superuser"
"dbshell:run command-line client for the current database"
"diffsettings:display differences between the current settings and Django defaults"
"dumpdata:output contents of database as a fixture"