The open source database, often the default.
Netcraft: WordPress Distribution Compromised, Update Released
“A recent distribution of the popular blogging software WordPress was compromised during a server intrusion, the development team said late Friday. All WordPress users who have downloaded and installed version 2.1.1 are urged to immediately upgrade to version 2.1.2. Earlier versions of WordPress are not affected.”
Ouch! Get patching. I had downloaded but not yet upgraded. There’s a patch to avoid.
Charlie Farinella called the meeting to order promptly at 7 PM and cracked his whip to stick to his streamlined agenda. Brief announcements (“find GNHLUG events on www.gnhlug.org”) were followed by Ray Côté’s presentation of uniq. Ray explained the function and then introduced an increasingly complex set of examples, one building on another to show how uniq could remove duplicate lines from a sorted file, display various counts of duplicates and so forth.
Guy Pardoe was the main presenter. After the requisite wrestling with the projector, Guy talked about Joomla! Guy had hoped to be showing version 1.5, but it is still in early beta (beta 1 with beta 2 due rsn), so he didn’t feel it was ready to talk about for production sites. Guy explained when he volunteered for the presentation he thought 1.5 would be available, and promised to return when 1.5 was available and he had some experience in using it for production work. He briefly reviewed Barrie North’s presentation from DLSLUG last year (registration required) (and our notes from that meeting). Guy then showed us the Joomla! 1.0 correction: 1.5 install he had done that day, highlighting the basic features of the CMS and the ease of use of the administrative interface. It appeared to be a very open and accessible system. Templates and CSS files could be edited from within the interface and they appeared to be XHTML and CSS2 compliant.
A general Q&A followed. General concerns on the security of the core framework. Concern about the timeliness of the 1.5 release. General discussion of what CMS could do and what the target market was.
After the main presentation, the floor was opened up for general discussion. Maddog announced that he and Bill Sconce had met with faculty at the New Hampshire Technical Institute and that a plan to hold a series of MythTV Installfests was proposed (see the -org list for details).
Answering another question that has come up on the discusssion list, I came across this post while I was looking for Barrie’s presentation. While he is advocating for Joomla!, of course, he may be pointing out that WordPress would meet some peoples needs as well.
“Why you want to use Joomla! instead of WordPress”
Thirteen attendees were at the meeting. Thanks to Charlie for running the meeting, Ray and Guy for presenting, Ken and the Monadnock SAU for providing the facilities, and to maddog and all attendees for participating!
I’ve mentioned it before, but the dabo project rocks! dabo is intended to be a cross-platform (Mac/Linux/Windows/Everywhere) rich-client application (like FoxPro 2.5 before MS bought it) with the rich-client experience (grids, list boxes, checkboxes, pageframes, menus, multiple forms) in the appropriate widget-set for each OS. It supports a slew of backend data sources (MySQL, PostgreSQL, MSSQL, Oracle, more) and is designed with a similar architecture (UI-BizObjects-Data) to many of the FoxPro frameworks. Best of all, it’s written in Python and available under an Open Source license.
I’ve spent a couple days downloading the source, watching the excellent screencast tutorials, browing the extensive mailing list archives and wiki, running the demos, generating an app with the App Wizard and reading the code. I’ve got an existing LAMP application that would benefit from a rich-client component with reporting capabilities, and dabo looks like a good choice. Hope to blog my progress as I get into it.
The GNHLUG-discuss mailing list has been abuzz for the last month with disucssions about MythTV. I've learned a lot I had not yet gleaned from the documentation:
I hadn't realized that it was possible to receive and record HDTV-level broadcasts from the analog cable feed for those “broadcast” channels in the local area.
One GNHLUG member posted his How-To on building a MythTV front-end with no noisy fans or hot hard drives. This little box would work well in the entertainment center.
A link to a great discussion of the Architecture of MythTV.
At the MerriLUG meeting on Thursday, the January topic was announced: we'll be meeting Jarod Wilson, author of the Fedora Core MythTV HowTo. That's a meeting not to miss!
LXer reports trixbox 2.0 released. “Trixbox 2.0 beta will be available for download on Wednesday. This release will be Fonality's first big contribution to the trixbox/Asterisk community after the recent Fonality acquisition of trixbox. which certainly caused a stir within the Asterisk community. I spoke with Chris Lyman, CEO of Fonality, to find out more about this major new release of trixbox.”
I've seen TrixBox 1.0 demoed at MonadLUG in June by Tim Lind and it was an impressive piece of software. Looking forward to seeing what improvements are available in the 2.0 version. Tim's doing an Asterisk presentation in December at CentraLUG; perhaps he'll show off 2.0 there.
SlashDot misses the mark completely with in inaccurately-titled and summarized pointer to a great Tom’s Hardware story on MythTV. There’s nearly nothing in the story about the Microsoft media device, nor does there have to be. The MM is a plug-in-and-work device that locks you into their choices, their protocols and few extensions. MythTV is for the do-it-yourself tinkerer who wants to do lots more. This one’s been on my to-do list for way too long.
The comments on the Slashdot article are much more worthwhile than the post. Set your threshhold high and you’ll see the moderated posts. A pointer to Jarod Wilson’s installation guide was worth the browsing. Jarod integrates the great documentation on the MythTV site with his own experiences.
From Guy Pardoe's announcement:
The next meeting of the Monadnock Linux User Group (MonadLUG) will be this Thursday, August 10th, 7:00pm, at the SAU 1 Superintendent's Office behind South Meadow School in Peterborough.
For directions and other information, visit
http://wiki.gnhlug.org/twiki2/bin/view/Www/MonadLUG
Mark Witham discusses SugarCRM: SugarCRM is a complete CRM and groupware system for businesses of all sizes. Functionality includes sales force automation, marketing campaigns, support cases, project mgmt, calendaring, documents and more. Built on PHP and MySQL.
I never fail to pick up at least one great tip or idea from every meeting I attend, and the Upper Valley Computer Industry Association was no exception. This tip: CMS Matrix, a site comparing the features of a huge number of competing content management systems out there. Like that other Matrix, the problem with Open Source is … choice. Not too many choices, but many. This site helps narrow it down.
Accompanying me on the trip: an audiocast of Doc Searls' wrap-up at the Syndicate 05 conference. Good stuff!
I've been involved for a couple of years in developing Linux-Apache-MySQL-PHP/Perl/Python apps for various clients. During most of that time, I've used in-house Linux servers for prototype, development and testing, and Linux servers deployed at the client site or a hosting provider for production work. Recently, I wanted to spin off a second copy of an application on a local Windows laptop to test some radical changes while the rest of the development team continued to work away on the dev server. Ideally, I wanted to install the entire LAMP set on my local workstation without a lot of work, configuration, downloads, HowTos, and so forth. XAMPP offers free, prepackaged installation modules for Linux, Windows, OS X and Solaris, bundled with a dozen handy utilities like PEAR and phpMyAdmin. Installation was a click, click, click, done! process. Reading a few READMEs got a few non-standard settings like enabling InnoDB data storage. Slick!
If you need a quickly set up XAMPP stack, you'll want to check this out.
My first attempt at importing blog postings from Radio Userland to WordPress resulted in over seventy categories. Every post with a different combination of categories like “MySQL; LAMP; Technology; Security” created a new category with that exact name, rather than a one-to-many post-to-categories representation. WordPress supports this, as does Radio. The communication breakdown occured between the two, in an export routine I used that created MT-compatible text files.
I could have kept experimenting with different imports, but I’d rather just plow ahead with what I’ve got, so I took a look at the WordPress schema and figured out what I’d need to hack. I used Visual FoxPro to read in the category table, figure out which (multiple) category posts I should have instead of the single, multi-category category, and rewrote the many-to-many file that joins the posts to the categories.
That narrowed it down to 15 categories. I added a new one, “Personal” for notes about politics and personal goings-on. I hope to squash the four, now three “My” categories, which are the old example categories left over from the original Radio install. Stay tuned!
I noted the counts of the number of posts per category was showing zero for several categories. There’s a (denormalized) category_count field in the category table. I popped open phpMyAdmin on the server to poke around and finally issued a “update wp_categories set category_count = (select count(*) from wp_post2cat where category_id = cat_ID)” to get the counts to update. Thirteen rows updated in 0.0635 sec. Darn near as fast as Rushmore.