Category Archives: Databases

LOAD DATA INFILE and FILE Permissions on MySQL

By Donnie Bachan | Published: June 22, 2009

I ran into an issue running the LOAD DATA INFILE command from a PHP script the other day. When I logged in as ROOT and executed the script on MySQL Query Browser it worked like a charm. However, when I executed the script from PHP as another use with only SELECT, INSERT, UPDATE and DELETE [...]

Also posted in MySQL | Tagged Databases, MySQL, SQL | Leave a comment

Re-installation of MySQL 5.x

By Donnie Bachan | Published: May 6, 2009

A friend of mine recently had an issue while installing MySQL 5.1.34 on a Windows 2003 R2 system using the binary installer. All seemed to have gone well with the install except that when it was done he couldn’t log into the database as root. Obviously, we thought that the password was wrong, so we [...]

Also posted in MySQL | Tagged Databases, MySQL | Leave a comment

SQL Server 2005 Deadlock Tracking

By Donnie Bachan | Published: April 7, 2009

This is a very useful article for anyone experiencing deadlock issues with SQL Server 2005. http://www.simple-talk.com/sql/learn-sql-server/how-to-track-down-deadlocks-using-sql-server-2005-profiler/ I made use of this while tracking down the cause of the following error: Transaction (Process ID 97) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. When using Profiler [...]

Also posted in SQL Server | Tagged SQL Server | Leave a comment

Web data security paranoia

By Donnie Bachan | Published: February 23, 2009

My recent experiences with several hacking attacks has made me think more about application and data security on the web. In today’s world nothing can be taken for granted and security should be of the highest concern, no mater how simple you think your application or trivial the data you store. Many web applications are [...]

Also posted in ColdFusion, PHP, Security | Tagged ColdFusion, database, encryption, Security, SQL Server | 1 Comment

Preventing SQL Injection attacks in ColdFusion

By Donnie Bachan | Published: February 17, 2009

This is an article I came across on Ben Forta’s blog. This gives some very good tips on preventing SQL injection attacks and provides some excellent best practices. http://www.adobe.com/devnet/coldfusion/articles/sql_injection.html When I took up my current position we had to do a vulnerability scan to become PCI compliant and well we originally failed horribly. After much work we [...]

Also posted in ColdFusion, Programming, Security | Tagged ColdFusion, Security | 1 Comment