December « 2011 « Geospecialling

December 14, 2011

Mapguide 6.5 Server Not Found on Hardened Windows 2008 Server

Filed under: Mapguide — Tags: IIS 7, ISAPI, Mapguide, Windows 2008 — Darrin Maidlow @ 11:39 am

It seems I’ve become the “go to guy” when it comes to Mapguide 6.5 on modern platforms! This post builds on my previous post that documents how to install Mapguide 6.5 on Windows 2008. In this edition we look at the situation faced on a clients server. Basically the installation went off without a hitch with one exception. When attempting to test the Mapguide 6.5 ISAPI the following error occurred:

HTTP Error 500.19 – Internal Server Error The requested page cannot be accessed because the related configuration data for the page is invalid

Odd – but I realized immediately this server felt different. I added the Local Computer \ Users group to the folder permissions for the MapAgents folder and gave that group Read and Execute. This resulted in the page at least rendering. At this point the listener was active, but the Mapguide server could not be found.

MapGuide Server #1 [Local] Autodesk MapGuide Server could not be found. If you need more assistance, please contact your Autodesk MapGuide Server Administrator.

This looked similar to the old DCOM problem that occurred back on XP when you applied Windows XP service pack 2 – but the server service was running. I checked the DCOM permissions and everything there was correct. After a bit of messing around I realized that indeed this Windows server was hardened and the permissions has been restricted. To resolve this problem I had to give the local Users group read and execute permissions to the Mapguide folder. I had to give the local Users group write access to the logs folder. After that the mapagent could talk to the server no problem!

Now I admit I screwed up troubleshooting 101 here. I had a hard stop coming and really needed to get this resolved ASAP. Instead of doing one thing at a time and testing I added both permissions. When I tried to undo the permissions to see if I could replicate the problem I could not reproduce it. It may be possible that I only needed to give the local Users group modify access to the logs folder. If you encounter this problem and determine this to be the case please let me know!

If you’re having problems with Mapguide 6.5 and could use a little help – feel free to contact me via ChasmTech.

Technorati Tags: Mapguide,Windows 2008,ISAPI,IIS

Comments (0)

December 9, 2011

Country / State Lookup Tables for Oracle

Filed under: Oracle — Tags: Lookup, Province, SQL, State — Darrin Maidlow @ 3:10 pm

The time has come for Country / State-Province lookup tables for Oracle! Building on my earlier post on Country / State Lookup Tables for SQL Server I’ve built a new script for Oracle. This script will create two tables, two sequences for the primary keys, and two triggers to setup the auto-numbering. Run the script and you should be good to go!

Oracle Country / State / Province Lookup Tables

Technorati Tags: Oracle,State Province Lookup Table

Comments (1)

December 8, 2011

Star Wars: The Old Republic Install Download Breakout

Filed under: Gaming — Tags: MMORPG, Star Wars: The Old Republic — Darrin Maidlow @ 3:59 pm

And now for something completely random! Star Wars: The Old Republic has gone live for pre-orders today. Yesterday I was invited to start downloading the client. (Hey this is my “personal” blog – and sometimes I like to play computer games =)) This post is to smash the hopes of those rocking less than awesome internet! If you’re not rocking fiber or some other insane internet don’t get TOO excited when you first start downloading SWTOR. Since we moved out of the city we’ve been rocking the line-of-sight peasant-net – which actually costs a lot more than the fancy high bandwidth you city slickers get! I get 3MBit burst for 30 seconds then 2.5Mbit sustained and 0.5Mbit up. As I started my download I settled in for the long haul.. Here is a summary of my download experience – in point a point form list:

The initial download brought down a roughly 1.8GB video file. Ohh this doesn’t look to bad!
Ok that file is done, Doh, now its downloading an 11GB file. Ok time for bed.
Oooh 6AM conference call. Up super early. Mad at guy that scheduled call at 8am EST. Oh only 3GB left. Sweet!
Oh now we have a 60MB file. Nice.
Oh, shoot, 4GB file. Great. At least I’m getting 320KB/s.
Oh okay half a dozen small files totaling a couple hundred megs. Sweet its installed. Only what, 18GB downloaded?

Oh excellent. Now it’s installed but my account has not yet been activated for pre-release play…Oh well back to work. Maybe my account will be activated this afternoon? hmmmmm.