Category Archives: Uncategorized

GrayLog2 and MongoDB

Playing with GrayLog2. The server requires Mongodb + OpenJDK.
Got some nice screenshot of my virtualbox servers.

Forwarding rsyslog is done by creating a file /etc/rsyslog.d/graylog2.conf with contents below.

# Forward all logs to Graylog2
# Replace x.x.x.x with your own Graylog2 server IP
*.*     @x.x.x.x  #udp forwarding

Restarting the rsyslog will send log messages to GrayLog2 server. 🙂

Coding with Flask and SQLAlchemy

On my previous post, I’ve been working with Flask,SQLAlchemy, and Gnunicorn for some REST API.

Setting up virtualenv with the following pip requirements.

Flask==0.6.1
Flask-SQLAlchemy==0.11
Jinja2==2.5.5
LEPL==5.0.0
MySQL-python==1.2.3
SQLAlchemy==0.6.6
Werkzeug==0.6.2
distribute==0.6.10
gevent==0.13.4
greenlet==0.3.1
gunicorn==0.12.1
lockfile==0.9.1
wsgiref==0.1.2
yolk==0.4.1

The model.py:

from flask import Flask
from flaskext.sqlalchemy import SQLAlchemy
from sqlalchemy import Table, Column, Integer, String, Date, Float 
import config  

# DB class 
app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] =  config.DB_URI
db = SQLAlchemy(app)

# DB classess 
class Player(db.Model):
    __tablename__ = 'player'

    playerid = db.Column('playerid', Integer, primary_key=True)
    username = db.Column('username', String(30), unique=True)
    email = db.Column('email', String(50), unique=True)
    password = db.Column('password', String(100), unique=False)
    avatarid = db.Column('avatarid', Integer,default=1)
    language = db.Column('language', Integer,default=1)
    regdate = db.Column('regdate', Date)
    activation_key = db.Column('activation_key', String(60))
    active = db.Column('active', Integer, default=0)

    def __init__(self, username=None, email=None,password=None):
	    self.username = username
	    self.email = email
	    self.password = password 

    def __repr__(self):
	    return '<player %s %s>' % (self.username, self.email)

Continue reading