Archive for the 'Database' Category

 

 

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

Oct 04 2009

Compiling Freeradius with Oracle Support

Published by under Freeradius,Oracle

Compilation Error? The Oracle client being installed (11g R2 in my setup), Freeradius doesn’t seem to find Oracle headers. I get the following error message: Error compiling Oracle/Freeradius configure: WARNING: oracle headers not found. Use –with-oracle-home-dir=<path>. configure: WARNING: silently not building rlm_sql_oracle. configure: WARNING: FAILURE: rlm_sql_oracle requires: oci.h.   Specifying the path to –with-oracle-home-dir doesn’t […]

No responses yet

Aug 29 2008

Restrict LDAP or NIS Users Access on Unix

Published by under Ldap,Linux

A lot of networks use LDAP or NIS to authenticate users on servers. There is no policy control by default and access is granted to all users in the central database. Access can be restricted to some of the accounts adding them into the default passwd file if the compat mode is set. This works […]

No responses yet

Jul 26 2008

Mysql Ultra-Fast Backup with LVM

Published by under Mysql

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

No responses yet

Next »