Archive for the tag 'Mysql'

 

 

May 08 2013

Include Stored Procedures in Mysql Backups

Published by under Mysql

Most of us use mysqldump utility to backup Mysql databases. Be aware because mysqldump includes triggers by default but stored procedures and functions are ignored.Stored procedures and functions are called routines in Mysql all together. Run mysqldump –help and you will see FALSE for routine’s default value. You can include stored procedures and functions adding […]

No responses yet

Aug 16 2010

GLPI Ticket User Group Auto Assignment

Published by under GLPI

GLPI user has to select the group he belongs to when creating a ticket or else the field remains empty.This stored procedure automatically assigns all tickets to the user’s group. Setup a cron job on your Mysql server to run it as often as you need.  Also check out how to do a full hardware […]

No responses yet

May 30 2009

Daily Accounting in Freeradius

Published by under Cisco,Freeradius

We have seen a few posts on Freeradius user list and other forums asking how to collect accounting periodically. The Radius protocol provides accounting but not in the way that many would like. Here’s a short list of things we would like to modify or improve: Traffic is not collected at regular intervalsAs a result, […]

33 responses so far

Jul 26 2008

Mysql Ultra-Fast Backup with LVM

Published by under Backup,Mysql

It is generally good practice to respect the two following rules when backing up databases. The backup has to be: consistent fast Consistency is easily achieved putting a read lock on all tables beforehand. However, this isn’t always applied, and WILL definitely lead to a database integrity problem when restoring.Once a lock has been set […]

No responses yet

Jul 22 2008

Feedback on Freeradius IP Pools

Published by under Freeradius

If you wonder if you should use rlm_ippool or rlm_sqlippool to turn your Radius into a “DHCP” server, read on! rlm_ippool We first configured Freeradius to provide IP addresses through the ippool module. IPs are stored internally in a binary data file. radiusd.conf  Users In users, we’ve got: On startup, db.ippool and db.ipindex are created […]

7 responses so far

« Prev - Next »