CFMyAdmin - The Free MySQL DB Administration Tool

Running CFMyAdmin on Red Hat Linux with ColdFusion MX 6.1 against MySQL 3.23 on LinuxI'd like to complement Digital Crew on the enhancements and bug fixes in the new CFMyAdmin tool since I first blogged about it earlier in their Beta cycle. They even volunteered their time on Friday night to conduct a Breeze Live meeting with me where I provided them access to use my desktop to resolve a problem that I was having.
I've found that I can now run CFMyAdmin to administer the various MySQL databases in our lab, and I can run the application from either Windows or Linux flawlessly. Although it is a free tool, the application is very professional. Great job!!
Daniel Mackey offered some recent changes and links, which I'll forward here. Check it out!!
Download URL:
Update List:


International Red Hat Meetup Day: May 6th

Come to Red Hat Meetup!The next monthly International Red Hat Meetup Day will be held Thursday, May 6th. I've confirmed that this event is definitely scheduled for the Boston area, with a meeting location of Circuit City, 84 Middlesex Turnpike, Burlington, MA at 7pm. Its right off of 128, East of the Burlington Mall.

Red Hat Meetup

May Agenda Discussion Points:

"Would Red Hat-specific Linux User Groups be a good idea (worldwide)?
"Red Hat Linux vs. Fedora vs. Red Hat Enterprise Linux: what's that all about?
"What's your favorite Red Hat distribution of all time?

Amazon BookKit CFC

I'd like to give proper credit and thanks to Cameron Childress of Sumo Consulting for the ColdFusion CFC that interfaces with Amazon's Web Service for Associate referals. Cameron has dubbed it the "BookKit CFC" and distributes it for free from his website. The books displayed in the Recommendations panel on this page are rendered using BookKit CFC.

The CFC is really a piece of art and I enjoyed reading the code and following the logic. The CFC queries Amazon's webservice, generates the HTML behind each book view rendered, and then caches the HTML result for some interval (controlled in a config.xml file). Each call to the method getRandomASID( ) pages through the cached result list, yielding a new for every page hit.

To enhance your experience here on, I've written a wrapper around the CFC that provides category-specific book recommendations based on which blog category you are viewing, although the main blog page displays a default set of recommendations, and categories such as ColdFusion, Flex, Linux, and Biology display a narrowed list of books. To implement this I use a csv text file to hold the list of book ids, then I filter on the blog category, and finally call the CFC while passing the filtered book list.

Thanks Cameron!

Discussion of How the GPL Applies to Red Hat Enterprise Linux

Repost of thread on Boston Linux and Unix Discussion List

Thread 1: Because I signed up for the Redhat update service last year, and Redhat 9 support will end this month, Redhat has given me access to the Redhat Enterprise Linux and Redhat Workstation Linux binaries and source. I'm looking for someone who can examine the licenses and tell me which portions of this software are GPL and which are not.


Flex Store Application: A Web Service From ID to Implementation

I'd like to repost my answer to a Forums question about Web Service mappings in Flex. This shows the relationship of a web service alias the Flex Store application to the class that implements the web service.


How does the sample flexstore identify the web service location? I've traced it to the flex-config.xml file, under the white list named service "FlexStoreCatalogWS. I guess my question is how, and to what, does {context.root}/services/CatalogWS?wsdl get resolved?


Resolving wsconfig Error: could not connect to port 2901

When using ColdFusion MX's web server configuration utility wsconfig on Linux servers, you may encounter a situation where wsconfig fails with a reference to could not connect to port 2901 as shown here:

Found port 2901 on host localhost
could not connect to port 2901 on host
javax.naming.ServiceUnavailableException: The connection to the remote
JNDI server on host at port 2901 has failed (as have all
backup hosts listed, if any) - please verify that the server is running
and the NamingService is available [Root exception is Connection refused]
{ java stack trace here }
Could not connect to any JRun/ColdFusion servers on host localhost.
Possible causes:
o Server not running
-Start Macromedia JRun4 or ColdFusion MX server
o Server running
-JNDI listen port in blocked by TCP/IP filtering or firewall on server
-host restriction in blocking communication with server

Following on some of the hints in the error message, some diagnostic questions include:

  • Is the ColdFusion MX server running?
  • Does the command netstat -a | grep 2901 list the open port?
  • Can you connect to the port using "telnet localhost 2901" ?
  • If not, is a firewall blocking the port? Try running the command lokkit to launch a program which can temporarily disable the firewall. Does wsconfig still fail when the firewall is off?
  • Is there any other program that might have been running and listening on port 2901?
  • Finally, check the HOST configuration files, including on Red Hat: /etc/hosts and /etc/sysconfig/network. Are there any mis-configurations in either one of these files? If so, try correcting it, then restart the network

Typically, when wsconfig fails with this error, one of these diagnostic steps will show up to be true. If you know of any other cause or resolution, please add a comment.

Robert Redford's Earth Day Message

I received an email from Robert Redford today, published to all subscribers of John Kerry's website, concerning the impact of White House policy on the environment. I'm rebroadcasting his email here because I agree with the argument and this is something I feel strongly about:


Parsing XML in ColdFusion 5 Using the Microsoft XML DOM Parser

Someone recently requested an example for using the Microsoft XML Parser with CF5. Here is a small example that pulls in an XML news feed from SlashDot, parses the result, and displays a simple table of the lastest stories.


SnapDialer Software for Laptop Internet Access using a Cellphone

Using SnapDialer Software from FutureDial to connect my laptop to the Internet using my Sprint Samsung A600 SPH Cellphone.

I recently purchased SnapDialer software from FutureDial to connect my laptop to the Internet by using my Sprint cellphone as the uplink over the Sprint 3G network. Should I need to connect to the internet anywhere within the Sprint cellphone coverage area, now I can just plug in my cell phone and dial up for rates about 5 times faster than a 56k modem (~250 kbps).

Although I can use the cellphone's built-in web browser and email clients that are already part of the Sprint PCS plan, I can get full page browsing with images and all by using the laptop with it. However, I did notice significant image degradation while using SnapDialer with my laptop, though. The images appeared to be somewhat compressed and grainy, but they are sufficient. While dialed up, the cellphone displays connection status and transfer rates. I noticed a very short idle disconnect time, such that if no internet activity occurred for about 30 to 60 seconds the connection would drop. This may be a means of efficiency and lower bandwidth usage, and hopefully it would help save on minutes used in the Sprint plan.

Page 23, At Work

My office bookshelf, part 1
Pete told me to:

  • Grab the nearest book.
  • Open the book to page 23.
  • Find the fifth sentence.
  • Post the text of the sentence in your journal along with these instructions.

The nearest books are all for web development, and the easiest to reach of those is Sams Teach Yourself MySQL in 21 Days (already I'm thinking I would prefer to Teach Myself Regular Expresssions in just 10 Minutes ! ).

"Each database has its corresponding directory, as well as files that store the data, configure the tables, and provide a way to access the data stored in the files."

The nearest literature of any other type is a magazine, Bio-IT World. Page 23 is an article on ZeroConf, a new ITEF working group:

"The answer is largely becauase our hardware and software have no inherent 'awareness' of other devices and services on the network, and require considerable manual effort to configure and maintain."

Don't have a Journal or Blog? Add your Page 23 here!

More Entries