Business

Making money in the software business

Here is an article from Manageability titled 101 Ways to Make Money off Open Source. There aren't actually 101 items listed yet, but still there are some good ideas.

More AJAX info

Some good information is available at ajaxpatterns.org.

Projects in SugarCRM

Problems with the current release 3.5.1a that we have installed:

  1. Project name does not display in list of project tasks.
  2. Project List does not display at all, nothing shows below the search box.
  3. Project Task edit edit does not work, the form is cut off after Order field and the rest of the page fails to display.
  4. Project Task dates do not save properly (or maybe it is displaying that is a problem). Either way, sometimes the dates change from what was saved.
  5. Project Tasks do not display on the home page.

Fixed Plesk again

Current problem to fix is that the mysql version has reverted back to 3.23, making SugarCRM fail in many areas and the Plesk console not work at all (it gives a connection refused message). Plesk update seems to have been the culprit, although I specifically did not update anything related to mysql or plesk itself. Currently mysql is showing:


mysql> status
--------------
mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386)

Connection id: 36326
Current database:
Current user: admin@localhost
Current pager: stdout
Using outfile: ''

More on Plesk/MySQL upgrade

In a previous posting, I gave details about a frustrating but presumed successful upgrade to MySQL. Now, I am not sure that it was - at least as far as Plesk is concerned. I am not sure what triggered this after it worked for a couple of weeks, but the Plesk control panel is no longer accessible. MySQL and all other applications seem to be working without any problems. A server restart has no effect, and 1and1's support is unhelpful at best. At this point, the most likely problem seems to be MySQL. Not that it isn't working, but that Plesk won't start properly because of some db access issue.

Drupal - taxonomy as menu block

The task is to create a block that contains a menu built automatically from a hierarchical taxonomy. Breadcrumb trail would be nice, but is optional. The menu module or blocks will do this, but as a mostly manual process of building a set of links into a hierarchy that looks and works like other menus in Drupal. This seems to be the quickest and easiest way for relatively static taxonomy or one where you want categories commingled with items from forums or aggregator or other areas of Drupal.

But my plan for this site is to create a taxonomy, and I would like to have the menu automatically built for this. There appears to be several candidates in the contributed modules list on the Drupal site.

Drupal Themes

The default (bluemarine) theme in Drupal seems like a bad choice, but programmers, even good ones, aren't known for their graphic design talents. The other 3 that are part of the default installation are better, and I have chosen the pushbutton for this site and am trying the chameleon, interlaced and spreadfirefox themes on other sites. These seem to work fine, but have various quirks with headers and styles. I am wanting a simple, preferably tableless theme as a starting point for building some custom themes.

I also tried argeebee briefly, but it doesn't seem to work in Firefox. So, in addition to the four available in the base install:

Upgrade MySQL on Linux with Plesk

From version 3.23 to 4.0, this installation is reputed to cause some difficulties with Plesk. Not having done much with Linux, I waited until we had a new server that would be easy to restore if necessary and not affect any needed sites or applications. Found and copied these files to the server:

MySQL-shared-compat-4.0.26-0.i386.rpm
MySQL-server-4.0.26-0.i386.rpm

The first was necessary because of a dependency issue with shared libs. Ran RPM -U with these and got a warning (MySQL-server-4.0.26-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5) but otherwise seemed to work ok. Plesk still works until I tried restarting and now gives this error without even showing the login screen:

New Plesk installation

After getting IP address, user name and password for our new server, the next step is to update a few things.

  • License: You get an initial message the you license is expired (or missing). Under Server - License Management, click the Retrieve Keys link to update the license automatically. You have to this regularly (every 45 days or so), and occasionally it is unavailable and you have to try again later.
  • Updater: Also under the Server node, this seems a good thing to do right away so that you are starting with the most recent version. I originally thought that frequent updates were wise until one of them broke many of our apps because of a php configuration issue. Now I am more selective. It also makes sense to not install anything that you do not anticipate using, since some may add overhead and all will take up some space.
XML feed