Archive for the ‘Nerding’ Category
Around this time last year, I had been in up to my neck dealing with a messy repair job at work. Every day my team and I had to work with issues revolving The Tickler, The Reacharound, and The Dumptruck. No, this isn’t some unsavory gay porno I’m talking about… these are real project names we have given to various software components of a fairly complex job. Specifically, these are the functional pieces of a physical access control system that we use at work which needed some significant tuning.
This topic comes up for me not necessarily as a rant, but as I was going through some old notes before tossing them away, and this issue came up. How much damage can an organization do to themselves by hiring discount, unqualified programming resources?
The answer: A hell of a lot.
If you own a small software development shop, do yourself a huge favor and keep reading.
Warning- this may not be really all that funny unless you are a database administrator or a geek with the right knowledge. This rather silly product I am working with stores its data in the backend via a Microsoft SQL Server database. There’s nothing wrong with that… but on further examination of the schema I found a pretty ridiculous jewel of a table setup. Click on the picture to see the bloody details.
For those not technically inclined- this is precisely NOT how you would utilize a relational database server. It’s poor design, and rather an extreme and laughable example.
You’re probably here because you searched for this:
Microsoft SQL-DMO (ODBC SQLState:42000)
[Microsoft][ODBC SQL Server Driver][SQL Server] To connect to this server you must use SQL Server Management Studio or SQL Server Management Objects (SMO).
We use Xythos at our workplace to provide a file repository for students and eventually faculty and staff. It’s basically a web front end for a file system.
My personal feelings about the product are somewhat ho-hum and indifferent. It makes funny noises under the hood, it’s a bit clunky, but it works, runs on Linux and it’s reliable.
So you’re probably here because you searched on this error:
java.lang.ClassFormatError: Truncated class file
The problem is that you’re probably running your Xythos installation over port 443 (as you should) but there are still components trying to pull files down from port 80. With Xythos, if SSL is enabled, any requests to port 80 get dumped over to 443, and you will get truncated errors like above.
I’m generally for the practice of pixel peeping, as long as it is done in moderation. In case you don’t know what pixel peeping entails, it’s real simple and roughly goes along these steps:
- Get two or more cameras that you want to compare. Let’s use one that you love, and one that you hate.
- Pick a subject to photograph, preferably a still life or something that won’t move much or change colors between shots.
- Set one camera up on a tripod, and take a shot.
- Set up the other camera to replace the first, using the same settings, and take a shot.
- Load the images from both cameras to your computer.
- Zoom into one section with high detail and compare the hell out of both images side by side.
- Linger around at step 6 or repeat EVERYTHING until you feel that the camera you love and always wanted to ‘win’ all along gets better results than the other one that you hate.
Okay, i’m being a bit sarcastic. But seriously, this is how pixel peeping usually ends up happening.
It’s not that pixel peeping isn’t without its merits, but if you have taken more pictures of $20 bills taped to a wall compared with actually interesting subject matter, you have chosen the wrong hobby. Perhaps chainsaw juggling would be a more suitable endeavor instead.
I use Gallery2 for the backend service of photos. It works rather well, despite a few quirks. But none of these issues are nearly as bad as something in the world of a closed-source vendor.
I recently tried to upgrade the Gallery software and found this nasty error in the logs right around when I was trying to push the big red ‘Upgrade’ button:
...Unable to selectAdminUser for core upgrade...
Hopefully if you are reading this, it is because you found this page on a web search and are grasping for some answers. I’m not saying I have all of them, but this is the process I used to figure things out.