[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 ...