I posted this on OpenSourceCMS as well but got no bites in the last five months, so I'll bring it here, where the userbase seems to be slightly more active/friendly.

We were all ready to use Drupal to migrate our church's website to CMS until we heard from our ISP (ADDR.com) that LOCK TABLES is impossible with our hosting package. Since increasing the cost/going to VPS is not feasible at this time, I'd like to ask for recommendations. We're currently using only 200MB of our disk space and 800MB/month of bandwidth, so usage is not severe, but unless ADDR.com practices some severe loyalty and grants us the permissions Drupal needs, we'll have to find another solution.

Requirements (very little of this is negotiable):
* Runs on Apache/2.0.52, PHP/5.1.4, and either MySQL 4.0.25 or PostgreSQL 7.4.5.
* Calendaring is a primary feature of our website, so must be extensible or included by default.
* Must be able to be hosted remotely without root access. Our ISP can install Joomla for us, but I am not sure about any others. We have access to hosted MySQL databases with general SQL privileges to CREATE/ALTER/etc, just not UN/LOCK TABLES.
* Allows custom user groups/roles; for example, Finance should be the only ones to be able to see certain pages, or edit others. Individual accounts can belong to multiple groups, so One-to-Many group membership is essential (many of us wear more than one hat). This was the primary reason we were going with Drupal; Guest/Editor/Publisher/Administrator is not fine-grained enough, which knocked out Joomla and (apparently?) Postnuke. Etomite appears to be almost able to do this, but appears to be stuck in Development Hell since this spring... :eek:

Strong preferences:
* Named links, rather than node/17/234/48569466 - if these are available in some circumstances (static pages) and not others (such as the calendar), that's fine.
* Multiple mailing list support. Archives ideal.
* Decent GUI for editors/publishers; many of our people are not HTML/CSS savvy. WYSIWYG not required, but some sort of rudimentary formatting buttons.
* Open Source, in case we need to edit/add something.

Preferences:
* Wiki or other collaborative effort support or integration. We currently use offsite wikis for tracking certain committee notes and planning.
* PayPal/other online payment system integration.

In addition to Etomite, I've seen that CMS Made Simple seems to have something like what we're looking for in the way of user permissions, but I don't really have time to help build a new CMS, so only tested solutions, if you please.

Thanks much in advance.

Well, if you want to use Drupal you shouldn't have any problem finding a host that will give you lock tables privileges. It has a reputation as a bit of a resource hog though so an application-hosting specialist would be good for it, eg. <plug>Medialayer (http://www.medialayer.com)</plug>.

In searching for a host I'd relax the version numbers in your not-very-negotiable requirements. The ones you listed are neither the latest nor the commonly used branches (does anyone still use MySQL 4.0?). Check the actual requirements for your preferred CMS.

Xaraya (http://xaraya.com/) is another rather powerful CMS with fine-grained user / roles / privilege controls - might be worth a look.

HTH

A good site to freely checkout CMS's before choosing one: http://opensourcecms.com/

Popular CMS's
-----------------------
CPG Dragonfly
Geeklog
Jetbox
Joomla
Mambo
Typo3
phpWebSite
Xoops


As to your requirements, pretty much any Hoster providing any version of Apache 1.3 or 2.x & mySQL 4.x or 5.x should suit your needs but I would choose one the is using any version of PHP v5.x. I would also think that Postgre SQL v7.3.19 as a minimum should suit your needs as well, as it is a commonly used version.

If you want a rock solid development CMS take a look at http://www.expressionengine.com/ - it's not free but you get what you pay for!

Requirements - runs on standard php/mysql setups

Calendaring - already integrated, customise to your needs

Must be able to be hosted remotely without root access - runs fine on shared hosting

Allows custom user groups/roles - yes you can define members groups/access

Guest/Editor/Publisher/Administrator - you can define as many permission variations as you want

Named links - yes

Multiple mailing list support yes

Decent GUI for editors/publishers - yes, customnise as you wish

Open source - yes you have full access to scripts and templates

Wiki - has Wiki module if you want to use it

PayPal/other online payment system integration - currently has simple ecommerce function for tangible goods, memberships or access. Improvements will be forthcoming

In searching for a host I'd relax the version numbers in your not-very-negotiable requirements. The ones you listed are neither the latest nor the commonly used branches (does anyone still use MySQL 4.0?). Check the actual requirements for your preferred CMS.Well, those specific version numbers are what ADDR.com has (or had in May when I last asked them), so they'd be minimums for using a different CMS, if we opt not to use Drupal.

I should have been more specific that there are two options available to us: finding a new host that will allow us to use Drupal, or finding a different CMS that will run on our current host. Thank you very much for the suggestion about Xaraya!