This how-to is for installing and configuring OpenVPN on a Gentoo server acting as a firewall/router. I’ll also discuss configuring a OpenVPN client on Windows XP. Here is a brief description of what OpenVPN is from their site: OpenVPN is a full-featured SSL VPN solution which can accomodate a wide range of configurations, including remote… Continue reading OpenVPN how-to including OpenVPNGui client for Windows XP

I just came across Technorati, a pretty great place for viewing Blogs, etc. I thought I’d give it a shot and submit Uno-Code! You can see my profile here: Technorati Profile

For the longest time I’ve been using LIKE and ‘%’ wildcard operators for doing my searching. This works great looking up one column in a database table. In a recent project I was needing the ability to search on multiple columns, as well as multiple tables. To do this efficiently, I decided to tryt he… Continue reading Full Text Searching in MySQL

I’ve run into this multiple times, and I always have to look it up so I’m going to write about it. If you have a recordset returned and you’ve looped through it once and need to loop through it again, you can use the mysql_data_seek() function. This will reset the pointer and it will be… Continue reading How to reset the cursor in MySQL recordset with PHP.

This site was going to originally be about Linux and PHP programming, but I thought I’d through this ASP/MSAccess problem in the mixer since it might benefit someone. I haven’t worked with Microsoft Access databases since my early days with ColdFusion. Just recently I had to work on a traditional ASP site using a MSAccess… Continue reading Microsoft Access and “ORDER BY clause conflicts with DISTINCT” problem

I’m hoping this might be a useful snip for somebody. I recently had to install/configure a osCommerce application on a GoDaddy hosted web site. I was using Authorize.Net’s AIM (Advanced Integration Method) for handling payments. No matter what I did, I failed connecting to Authorize’s API. After some heavy googlin’, I came across a similar… Continue reading PHP/cURL payment gateway handling with GoDaddy hosted site

This is article explains how to install amavisnewsql to your existing amavisd sytem. Amavisd-new (http://www.ijs.si/software/amavisd/) is an incredibly powerful application that sits between your MTA and various anti-virus and spam detection software. I’m currently using Amavisd-new with Postfix (http://www.postfix.org/), Spamassassin (http://spamassassin.apache.org/)and ClamAV (http://www.clamav.net/) all wrapped up with a MySQL backend to manage virtual users. In… Continue reading Amavisd Quarantine with amavisnewsql squirrelmail plugin