Showing posts with label mysql. Show all posts
Showing posts with label mysql. Show all posts

Wednesday, October 08, 2008

Wednesday, May 23, 2007

This weekend

Now the fires are red hot for getting sh!t together for our move. By the end of this weekend:
  1. get a shopping cart installed on the server
  2. start photographing items to get rid of
  3. big heater
  4. small heater
  5. toyu tanks and pumps
  6. take fish to Homey Homer
  7. clean out fish tank
Since this is my tech blog, I'm most focussed on the shopping cart now. I've been looking at a couple of options. I don't need a lot so I should just focus on the easiest to install and friendliest to navigate.
  • Commerce.CGI - the first script I looked at; offers free scripts for basic installation and a one-time paid membership to access add-ons
  • Shop-script - a pretty slick looking system that features three different tiers of functionality for quite a price increase; clear features description available
  • AgoraCart.com - an open source option; also features paid membership upgrade but it's unclear what the features differences are
We'll need to get our stuff ready for the shopping cart as well.
  • photograph everything from a couple of different angles
  • measurements
  • price
  • description
  • date of availability
The only information we'll need is a name since we'll be collecting cash for everything.

Monday, February 19, 2007

phpMyAdmin

I got phpMyAdmin running on my server the other night. It was my second attempt to get it running. I had problems configuring it to work since the scripts couldn't connect to mysql even thought it was already running. I thought it was a problem with the sockets, but it was the "localhost" string. Apparently with my server, I need to use 127.0.0.1 whenever installation directions call for "localhost". Once I did that it fired up with out a hitch.

The second problem I ran into was an authentication issue. The database user that I defined wasn't able to connect to mysql via the script. When I removed the password for the user in the script, phpMyAdmin worked well enough. I didn't like the idea of running the scripts without password verification, so I took it off line temporarily until I figure out what's going on.

It's always best if I jam on a problem for a while, then leave it and come back to it later. The fresh perspective always helps me to see a different solution. I almost get frustrated at the things I missed the previous attempts, but I'm usually just happy that I figured out the solution.