[SOLVED] ActiveRecord::StatementInvalid: Mysql2::Error: The used command is not allowed with this MySQL version

hi there... i just want to share about direct execution with ActiveRecord on Rails 4 its use effectively to load huge data, so  you need to bypass some needless functions. sometimes you need to load maybe via CSV or load by SQL, but i recommend to use Local Copy in postgress of load local infile in mysql  here is the solution  put localinfile option on database.yml default: &default  adapter:...

Read more ...

Cisco CDR Hex2Ip mysql format

Hi all, just my note about hex 2 ip conversion for Cisco UCM CDR log. DELIMITER ;;DROP FUNCTION IF EXISTS chex2ip;;CREATE FUNCTION chex2ip (x INTEGER)  RETURNS varchar(15)  DETERMINISTIC NO SQL  BEGIN    DECLARE x1 varchar(2);    DECLARE x2 varchar(2);    DECLARE x3 varchar(2);   ...

Read more ...

install phpmyadmin for multi server multi port, phpmyadmin single signon

i want to use one server to manage some mysql server in some ip's let start,. pre-requisites a. installed apache b. installed php and its library for mysql connection install phpmyadmin single signon 1. download phpmyadmin from sourceforge  extract it and put on your apache root document 2. edit your configuration file (copy...

Read more ...

accessing oracle with instant client and toad.

on server (oracle server) 1. ensure that listener is running, "C:\app\Administrator\product\11.2.0\dbhome_1\BIN\lsnrctl status", it use "C:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora". the sample as below :   # listener.ora Network Configuration File: C:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora#...

Read more ...

Jawaban simple untuk keanehan-website-kawalpemiluorg-bagian1

well, to the point aja, ini adalah comment saya dari website http://www.pksciktim.org/2014/07/keanehan-website-kawalpemiluorg-bagian1.html kesimpulannya: saya bilang web tersebut sangat tidak aneh sama sekali. Akhirnya saya coba membuka website www.kawalpemilu.org ini, hasilnya.. aneh?. Sebuah website dengan aplikasi JQUERY canggih...

Read more ...

activate im openerp 8

previously, on version 7, im already running (http://febru.soluvas.com/2013/09/how-to-activate-instant-messaging-on.html) now, i want to share how to activate im in openerp 8. first install your openerp 8. (http://febru.soluvas.com/2014/03/install-openerp-8-ubuntu-1310.html ) once you logged in, install im module on setting menu. then...

Read more ...

install vmware workstation ubuntu 14.04

Firstly : download from official wvware or from this website Secondly : create temporary file to patch. Let say : /tmp/temp.patch 205a206 > #if LINUX_VERSION_CODE < KERNEL_VERSION(3, 13, 0) 206a208,210 > #else > VNetFilterHookFn(const struct nf_hook_ops *ops,        // IN: >...

Read more ...

[SOLVED] iked "failed to attach to key daemon" ubuntu 14.04

previously, i write about how to install ipsec vpn, once you get an error "failed to attach to key daemon" you need to run these steps : 1. Upgrade your vpn client version. download here then re-install again, see how to install here. 2. make sure that iked service is running (ps -ef | grep iked), otherwise, you need to run manually (sudo...

Read more ...

install ipsec vpn ubuntu 13.10 shrew soft vpn connect

its ipsec vpn cd /usr/local/src ; sudo wget https://www.shrew.net/download/ike/ike-2.2.0-release.tbz2 sudo tar jxpvf ike-2.2.0-release.tbz2 ; cd ike sudo apt-get install cmake libqt4-core libqt4-dev libqt4-gui libedit-dev libssl-dev checkinstall bison flex sudo cmake -DCMAKE_INSTALL_PREFIX=/usr -DQTGUI=YES -DETCDIR=/etc -DNATT=YES sudo...

Read more ...

openerp fields permissions

on openerp 7, let say: you want to make some fields are can only update or create by specific group, then you can make it as : (on your model column) 'c50':fields.float('PO Amount',write= ['project_nsn.group_nsn_ppm',] ), or, you want to make it visible on specific group, then you can make as : 'c50':fields.float('PO Amount',groups=...

Read more ...

openerp 7 import csv

before you import your data (contact, product, invoice, sales order etc). You need to enable external identifier to make openerp recognize your data to be referred. example : you need to import product, which is have "manufacture_id" or "agent_id"  (refers to res_partner), to enable importing your data, you need to create external...

Read more ...

[SOLVED] Openerp 8 Access Denied by record rules for operation: create, model: res.partner

well, on openerp 8, you may get this error, the solution is simple, just follow my previous post here then you just create as below : ...

Read more ...

install openerp 8 ubuntu 13.10

its easy ways to install openerp 8 on ubuntu 13.10 first : follow this step http://febru.soluvas.com/2013/11/how-to-install-openerp-7-on-ubuntu-1310.html secondly :  sudo apt-get install python-pypdf python-psutil  sudo apt-get install apache2 libapache2-mod-gnutls libapache2-mod-python libapache2-mod-wsgi  sudo apt-get...

Read more ...

[SOLVED] openerp 8 TypeError: _postprocess_args() takes exactly 2 arguments (3 given)

Hi all, just a little solution for this error : in openerp 8, website addons TypeError: _postprocess_args() takes exactly 2 arguments (3 given) and this ...

Read more ...

[SOLVED] OpenERP 7 IOError: decoder zip not available

IOError: decoder zip not available its an error while you use PIL or Pillow with python-imaging together. On my case : with this environment : Openerp 7Ubuntu 13.10 x64 i've got an error as below :  then i test on console, its seem running >>> from PIL import Image>>>  but, still error while installing...

Read more ...

openvpn udp over tcp via SSH IP Tunnel

openvpn udp over tcp via SSH IP Tunnel tonight, i make a simple test to make udp over tcp with ssh IP tunnel, main tools is pppd and ssh connection. by this ways, you can transfer udp over tcp, but its too slow, then to raise its performance, i put openvpn udp. The speed is good enough for me.  before you use it, you need to...

Read more ...

[SOLVED] ERROR: unable to download video

when you download with youtube-dl, you get an error as this : [youtube] Setting language [youtube] pgEFfZOV9GQ: Downloading video webpage [youtube] pgEFfZOV9GQ: Downloading video info webpage [youtube] pgEFfZOV9GQ: Extracting video information [youtube] pgEFfZOV9GQ: Encrypted signatures detected. ERROR: unable to download video then...

Read more ...

inject links

i want to share this link so they can try to make their own "header inject", some of this links may have been blocked by broadband mobile provider, but some others is still ok. ...

Read more ...

install openvpn webmin ubuntu

here's simpler ways to use server as vpn server, you just need install webmin then everything will be run as you want. Let's start : install openvpn and webmin add webmin repository on your source list (/etc/apt/sources.list) deb http://download.webmin.com/download/repository sarge contrib add key and update repository sudo wget...

Read more ...

simple vpn over ssh

some people write a simple trick to make vpn connection over ssh tunnel without additional program or authentication files such ta, cert, ca etc. on linux, pppd and ssh are commonly used. So you can try this trick : PPPD is /usr/sbin/pppd SSH is /usr/bin/ssh ${PPPD} updetach noauth passive pty "${SSH} ${LOCAL_SSH_OPTS} ${SERVER_HOSTNAME}...

Read more ...

get free internet zero balance with default home page

First of all, i want to show you some vulnerable internet connection on mobile internet broadband provider, its depend on your service / internet plan. I've test this trick with ZERO balance, its ABSOLUTELY  FREE !!! How It Works when you connect with tour mobile modem, it will get default intenet-plan (or just as your profile,...

Read more ...

install openvpn admin gui web base administration part 1

there are so many openvpn administration software, there are :  http://openvpncertmgmt.sourceforge.net/  http://sourceforge.net/projects/openvpn-admin/?source=recommended http://sourceforge.net/projects/openvpn-control/?source=recommended http://www.bytemine.net/en/bytemine-manager http://sourceforge.net/projects/openvpn-control/files/?source=navbar but,...

Read more ...

install openvpn admin gui web base administration part 2

previously, we try to install openvpn administration gui, now lets move forward to its setting.  goto :  http://yourwebserver/purplenet/login then go to menu "manage" a. Create vpn Server b. Create organization c. Create Network then you need to link it, one server can have many organization, on one...

Read more ...