CakePHP with Postgresql 8.3 and XAMPP 1.7.3 on Windows 7 64bit configuration

I just started using CakePHP 2.1 and wanted to switch to Postgresql as the database. CakePHP can be configured for postgres usage but it did not connect to the database when I switched over to it. I keep receiving the following error on the configuration page:

Cake is NOT able to connect to the database.
Database connection “Postgres” is missing, or could not be created.

After a considerable search I was not able to find a solution.  After taking a week break I finally ran into a post for SQL Server that pointed me in the right direction. The short answer is that the php.ini file for XAMPP needed to be changed to enable the postgres drivers. Additionally, my postgres install is 32 bit on a 64 bit OS. So I had to copy the posgres dll from the postgres bin directory to the apache bin directory. Not pretty but it works.

Here is the details on how to do it.  Once the CakePHP database.php file is changed to postgres I started getting the “Database connection “Postgres” is missing, or could not be created.” error.

public $default = array(
‘datasource’ => ‘Database/Postgres’,
‘persistent’ => true,
‘host’ => ’′,
‘port’ => ’5432′,
‘login’ => ‘postgres’,
‘password’ => ‘mypwd’,
‘database’ => ‘mydb’,
‘schema’ => ‘myschema’,
‘prefix’ => ”,
‘encoding’ => ‘utf8′

The web page error looks like this:

So I pointed to a controller that I created from the tutorial to get more debug information.

That lead me to this post:

I located my php.ini file in C:\xampp\php and change un-commented the following lines:


I bounced apache and got the error message the LIBPG.dll  is missing.  As stated about, the posgresql dll’s are not found in the postgres install because I am running Windows 7 64 bit.  Copy these dll’s from C:\Program Files (x86)\PostgreSQL\8.3\bin to C:\xampp\apache\bin.

comerr32.dll, gssapi32.dll, k5sprt32.dll, krb5_32.dll, libiconv-2.dll, libintl-8.dll, libpq.dll

Bounce apache one more time and CakePHP is now connected to my Postregsql server.

Posted in CakePHP, Software Development | Leave a comment

Samsung DMR78 Dishwasher Grinding Noises during Rinse Cycle.

The Samsung DMR78 dishwasher has been a good dishwasher machine for our household except the top rack quick release hold-tabs broke off and went into the waste pump.  I tried to fix by going in from the top mechanical area inside but had no luck.  A quick search brought me to the this link on how to fix this common problem.

To get the broken rack tabs out, the washer needs to be pulled out and placed on its side to clean out the waste pump.  Here are the tools that I used.

  • LED Flashlight and a look around mirror
  • Flat blade (big and small) phillips screw drivers
  • Block of wood and a pry bar
  • Wire ties and a clippers
  • 5/8″ wrench
  • Pliers
  • Level
  • Towel for water
  • Blanket or floor protection for lay the washer on.

Oh ya… do this at your own risk.  I am not responsible for anything you do wrong.  Haha

Start out by removing the bottom skirt and the two countertop screws.  Unplug from the wall or shutoff the power to the dishwasher at the breaker box.  Disconnect the waterline with the 5/8″ wrench.

The important part of getting the washer out is making it easy to level it when you put it back into the cabinet space.  The picture above shows you the white front leg levelers.  They are white and plastic.  I used a combination of the pry bar and my hand at the top of the washer to push up on the washer.  Once up I used my fingers screw the white leveler legs up.  Be careful, the entire bottom is plastic and it brakes easily.

Do not lower adjust the back plastic legs because it will make re-installation leveling harder.  Next, lay the dishwasher on its side so the bottom can be opened up.  In the next set of pictures you can see the gray waste line and the washer’s bottom.  Use a phillips screw driver to remove the two screws.  Gently use the flat blade screwdriver to pry the cover off.

The waste pump that I am pointing to in the picture above is where the broken tabs go.  All the grinding noise come from that pump.  I originally hoped they would pass out the drain, but when you look inside the gray tube, you can see that they will never make it past the ball valve inside the tube end.

The next thing to do is open the waste pump.  At first look it appears to be a solid unit.  I used the mirror tool to check out both sides.  There are two simple snap clips that hold the magnetic induction motor on the plastic shaft.  Use the small flat screw driver to carefully release the electric motor.  Remember the plastic on this washer breaks every easily!  Once the electric motor is off, there is a small clip molded in the plastic on the waste pump.  Carefully release it and turn the shaft 1/16th of a turn counter-clockwise.  It will pop open and the plastic rack tabs will fall out.

The last picture above shows the broken tab in the waste pump.  Reverse the tear apart process and set the washer back on its feet.  Slide the washer back into the cabinet and level it out front to back and side to side.  For side to side I used the top door and for front to back I used the bottom rack track.  If it is not level, the computer will not let it start.  Screw the counter top tabs back into the same hole they came out of.

Next, I hooked the water back up and turned on the power.  Before I tested it, I decided to fix the top rack brackets.  What to use?  Zip-ties of course.  Check out the pictures on how I laced them around.  It works good so far…  Maybe I will buy new brackets some day, but at least the zip-ties will not go down into the waste pump.

I ran the dishwasher on the quick cycle and it was back to the nice quite dishwasher machine that it should be.

Posted in Appliance Repair | Leave a comment

MS SQL Server Instance Name with JDBC and Spoon Pentaho

I had trouble implementing an Named Instance of Microsoft SQL Server 2005 with JDBC in Pentaho Spoon database connection.   The first thing to know is that MS SQL instances has a port assigned to the instance name.  Generally, you can connect to SQL Server from client tools and ODBC something like this: MYSERVER1,7110.  The ODBC method connects but the PDI transformation job throughs a “Connection is busy with results for another command” error.  I did not find a way around that error in PDI. 

I tried many different methods to confirure a pure JDBC connection and failed.  I ending up downloading the sqljdbc4.jar from Microsoft here and it fixed the connection refused errors. I used the sqljdbc4.jar because I am run Java 1.6.

From the Spoon Repository Explorer Connections Tab select MS SQL Server (Native)

Host Name: MYSERVER1
Database Name: db_test
Instance Name: “leave blank”
Port Number: 7110
User Name: myuser
Password: mypassword

Posted in Pentaho | Leave a comment