I am setting up monitoring for my PostgreSQL database server, and ran across a cool way to get around specifying the username/password via the command-line every time the checks are run: pg_service.conf. Unfortunately, there is very little documentation on the config file. As best as I can figure out, if you are connecting to a remote host, your definitions should look as follows:
[service.name.here]
dbname=db.name.here
user=user.name.here
host=host.name.here
password=password.here
On a Gentoo Linux server with PostgreSQL 8.4 installed, this file will need to be placed at /etc/postgresql-8.4/pg_service.conf. Then, to reference it, simply export the PGSERVICE environment variable with the value of the name of the service in brackets.
So, I haven’t posted anything really talking about the details of my life in 2009. This is likely attributed to my extremely busy schedule for the majority of the year, amongst being overwhelmed at times with the changes going on that directly and indirectly affect me and my family. I hope to cover the highlights of the year, and then wrap up with great news that has changed Melissa’s and my life forever.
Continue reading →
[root@sheerjira ~]# rpm -i rpmforge-release-0.5.1-1.el5.rf.i386.rpm
package rpmforge-release-0.5.1-1.el5.rf.i386 is already installed
[root@sheerjira ~]# rpm -e rpmforge-release-0.5.1-1.el5.rf.i386.rpm
error: package rpmforge-release-0.5.1-1.el5.rf.i386.rpm is not installed
‘Nuff said.
If you were a luck systems administrator who followed the instructions for a Tomcat container installation using the EAR-WAR install when setting up Atlassian JIRA, then you may have been privileged to see the following error message in your log files:
2009-12-06 22:56:25,762 main WARN [core.entity.transaction.JNDIFactory] [ConnectionFactory.getConnection]
Failed to find DataSource named java:comp/env/jdbc/JiraDS in JNDI server with name default.
Trying normal database. javax.naming.NameNotFoundException: Name jdbc is not bound in this Context
If you’d like the solution on how to get rid of this error, please read on.
Continue reading →
I recently upgraded my student worker workstations up to Snow Leopard (Mac OS X.6) to take advantage of the better integration with Active Directory and Exchange. The primary reason: getting network home drives working correctly. We have a set schedule for them, but they may come in early or late depending on their school schedule. This introduces problems if someone is on a workstation that another typically uses. If all of their data were on a network server, there would be no cause for concern because they could use any workstation and still have access to all of their data. This blog represents my trials and failures with getting mobility synchronization to work properly.
Continue reading →
I cannot believe i’ve never seen the first Star Trek: The Next Generation episode. Then again, it first aired in 1987, which would have made me about 3. I have to say, the later years were so much better!! the camera angles, acting, and music were quite campy in the first episodes. Oh, and Riker is really boy-ish. It’s weird.
Many airlines have lowered their maximum weight restrictions, such as Frontier, to just 50 lbs. We found this out this morning when going to Yellowstone when Melissa and I expected to save $15 by using 1 checked bag (because each bag checked after 0 costs). However, this put us only 11 lbs. overweight resulting in a whopping $75 overweight “penalty”. What ever happened to the good ole days where airlines didn’t charge for checked baggage?
After several updates of various systems software packages on my Gentoo Linux servers, I began to notice a problem where I was being denied sudo access. The solution was amazingly simple, once I actually Googled to figure out what was going on.
Continue reading →
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 principle of assigning permissions to resources. They’re moving away from the concept of users and groups and more to roles. As of PostgreSQL 8.3, the primary command to create new users OR groups is CREATE ROLE. The existing CREATE USER / CREATE GROUP commands still exist, but are becoming non-existent in hopes of replacing the user / group permissions model with a strictly role-based model.
In an attempt to move my projects towards this model, I ended up running into several problems.
Continue reading →
Posted in SQL
|
Tagged postgresql, sql
|
Recently I upgraded one of my projects from 1.6.1 to the latest in branch-1.8.x of the Zend Framework. This resulted in most of my 1200+ unit tests breaking for that project. After several hours of trying to figure out the cause of the break, I managed to stumble onto the differences that is causing the problems I was experiencing.
Continue reading →
Posted in PHP
|
Tagged PHP, zend framework
|
