Archive for the tag 'Mysql'

 

 

Feb 28 2021

Change Procedure/Function Security Type and DEFINER

Published by under Mysql

Mysql procedures and functions security type is set as DEFINER which is the default value, as described in the “Create Procedure and create function chapter” on mysql.com.Why one needs to be cautious? Anyone with EXECUTE privilege can run the procedure or function with the DEFINER permissions. This might not be what you want. An error […]

No responses yet

May 11 2013

Freeradius Usage Graphs

Published by under Freeradius

Radius servers generate a lot of accounting records. Is it worth keeping them? Damn yeah! Beside the fact they could be used to check if a customer was connected at a given date, or find out who got IP address X.X.X.X that same day, the most interesting is to generate traffic reports and show customers […]

4 responses so far

May 08 2013

Mysql Stored Procedures Backup

Published by under Mysql

Be aware while backing up Mysql databases: triggers are included by default but NOT the stored procedures/functions. Do not forget to add the –routines switch when running a backup.   mysqldump -u user -p my_database –routines backup.sql   Check your backup scripts before running into a disaster recovery.

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

Next »