Import NetStumbler Data To MySQL Database

Wrote a little program that imports your NetStumbler text file export into a MySQL database. Very simple program that runs automatically using the data file uploaded into same directory. No fancy file uploading nor does it include viewing and sorting or doing anything with the data, yet. It also does not check against previous entries, so you’ll have to dump your MySQL before importing again.. The newest release checks for duplicates using MAC on import. That is up to you what you need it in a database for.

(excuse my poor versioning, etc, first time really trying to keep up with version numbers, details of improvements and GPL)

ns2db-v1.1b-with-viewer.zip – bug fix for lat/long field (thanks pixel), checks against MAC to prevent duplicates on import

ns2db-v1.1b.zip – added table view of data

ns2db-v1.0.zip

Simple Linux User Group (LUG) CMS

I wrote this simple CMS for keeping track of meetings, locations, information, and meeting archives/minutes/files of any sort of club or group events. The backend was created to CMSify the static site built by @thejonmoore of usefulgeek.com It’s not fully featured and may require some manual FTP uploading of your archives, etc, but it has just enough to play with. We ended up just using wiki for our LUG. Check out INKYLUG Indiana and Kentucky Linux Users Group.

download SimpleLUGCMS

Continue reading Simple Linux User Group (LUG) CMS

You don’t have permission to access /php/php-cgi.exe/index.php on this server. PHP 5 on Apache 2.2

Did you get this on your fresh install of PHP5 on Windows?

Forbidden
You don’t have permission to access /php/php-cgi.exe/index.php on this server.

You might encounter this with a default installation of Apache 2.2 (I used the exe installer) and a manual install of PHP5 as cgi on Windows. I placed this in my httpd.conf and followed other steps according to the PHP5 on Apache 2.2 instructions by using in httpd.conf:

#load php5 as cgi
ScriptAlias /php/ “c:/php/”
AddType application/x-httpd-php .php
Action application/x-httpd-php “/php/php-cgi.exe”

In order to fix the forbidden error I had to change this line:

<Directory “C:/Program Files/Apache Software Foundation/Apache2.2/cgi-bin/”>
AllowOverride None
Options None
Order allow,deny
Allow from all
</Directory>

to this:

<Directory “c:/php”>
AllowOverride None
Options None
Order allow,deny
Allow from all
</Directory>

EDIT: Looking back now, I see this solution at the bottom of the comments from 2006 on the Apache instructions. I probably didn’t find it because this error wasn’t mentioned. I had a feeling that replacing the line probably wasn’t a good thing and that you should add it additionally. That’s what the comment says so I also suggest that approach.