Category Archives: SQL

PostgreSQL Group & User Role Inheritance

As I’m trying to finish up one of my consulting projects (and enhance other active projects), I decided to take a nice long hard look a PostgreSQL permissions – the correct way of doing it. PostgreSQL applies the commonly accepted … Continue reading

Posted in SQL | Tagged , | Leave a comment

MySQLd 5.0.40, MySQL Client, and SSL Connectivity Problems

So, I now have one of our new servers sitting in a datacenter in Dallas. It is to replace one of our dedicated servers we are renting through The Planet. Well, our client’s website is doing extremely well right now … Continue reading

Posted in SQL | Leave a comment

Mac Xserve Perl DBD::MySQL 4.001

Well now, here’s an interesting problem I had with Perl on the new Mac Xserve running Intel Xeon 64-bit processors. One of our customer’s had a CGI website (cringes) and was using DBD::MySQL to access the MySQL database. Upon initial … Continue reading

Posted in *nix, SQL, Software Development | 1 Comment

Getting the last inserted row

Okay, I feel silly for writing this post, but as many of you know, this blog is not only for other’s enrichment, but for me document what I find for my own purposes and future uses. It also helps me … Continue reading

Posted in SQL, Software Development | 3 Comments

MySQL Connection Problems?

If you are trying to use a program to connect to MySQL (in my case, BugTracker, and you encounter the following problem: Host ‘localhost.localdomain’ is not allowed to connect to this MySQL server. This means that the program is trying … Continue reading

Posted in *nix, SQL | Leave a comment

OSCON Day 3

Day 3 ended the tutorials and began the sessions – the events that the majority of people showed up for. Keystones also precluded the days events, and the first Keynotes were rather intriguing. I heard talks from one of the … Continue reading

Posted in *nix, Events, Networking, PHP, SQL, Software Development | Leave a comment

OSCON – Day 2

Day 2 of OSCON training was rather sluggish and disappointing. There were several things that I found out that I already knew, but many things I wasn’t expecting from one of the talks, the High Performance PHP. Going into this, … Continue reading

Posted in *nix, Events, Networking, PHP, SQL, Software Development | Leave a comment

OSCON – Training Day 1

Today: Ruby and Rails Verdict: Better than awesome! First thoughts: Instructor name’s David Thomas. First thing on my mind: Wendy’s. lol, sorry, had to get that off my mind. Anywho, David Thomas and Mike Clark were the instructors for The … Continue reading

Posted in *nix, Events, Networking, PHP, SQL, Software Development | 1 Comment

Here at OSCON

Well, I am officially writing on the WIFI here at OSCON. After a long, approximate 9 hours of flight, waiting, more flight, waiting, a prezel, and more flying, both myself and Melissa made it here to Portland. I don’t thing … Continue reading

Posted in *nix, Events, Networking, PHP, SQL, Software Development | Leave a comment

Prepping for OSCON

Well, in just over a week I’ll be going to Portland, Oregon to attend my very first OSCON. My boss usually goes, and since I got staff at CIS too late last year, I didn’t have a chance to go … Continue reading

Posted in *nix, Events, Networking, PHP, SQL, Software Development | 1 Comment