Goodbye Civicrm

[tastymouse]

Hi, my first is post is to say goodbye, allas. We have used Civicrm for many years and I have, as webmaster, used this forum as a knowledgebase for years.
And also now it did help me, in making it clear that it is not possible anymore to run Civicrm on a shared hosting account. Ik know it was discouraged to do so, but a VPS is to expensive for a small organisations as ours.

My recent problem started when I wanted to upgrade to from 4.0.4 to 4.4.0. I got an error: CiviCRM 4.4.0 requires MySQL trigger privileges. My hoster won't change that for security reasons. They offered to add the triggers for me, but I couldn't find the necassary information (see a post about this: https://forum.civicrm.org/index.php?topic=28366.15).

So now it's over and out. No fun, because we'll have to search for an other application and migrate the data.

What surprises me most is that Civicrm started a Wordpress version, like those are all hosted on a VPS?

Goodbye and good luck with the project, Tom

[totten]

Sorry to hear that! It's good of you to check in.

I don't know the exact price-points you need to meet, but it sounds like you're in the $5-$10/mo range. You may want to get in touch with http://civihosting.com/ or https://mayfirst.org/ . The pricing is a few dollars more -- but much more affordable than a typical VPS. They're passionate about small non-profits, have experience with Civi, and have good reputations in the community. Migrating to a friendly host is often easier than reworking your site/content/data or retraining users (although that's obviously something you have to assess for yourself).

[FrTommy]

I shared your frustrations as well tastymouse. I was with Dreamhost shared hosting and with every civi upgrade it became more and more difficult to run it. I finally got to the point that I was done and was leaving civi. I decided to try civihosting who offers a package that runs civi without any trouble at all for 15.00 a month. i switched and am extremely happy with their service.

[tastymouse]

I don't know the exact price-points you need to meet, but it sounds like you're in the $5-$10/mo range.

Actually I'm with a very good and professional hoster with a positive attitude to non-profits. And they do want to help me, but they can't since there isn't enough information available.
Yes we could switch to civihosting, but running CiviCRM is a means, not a goal.

[xavier]

I don't think they are other triggers than these ones you need:
https://github.com/civicrm/civicrm-core/blob/master/sql/trigger.mysql

But if you want to work around limited permissions -if your host has a oldish mysql version, creating a trigger needed a admin like permission, with more recent ones it's safer- it's probably easier to create locally a working civicrm, dump the sql and ask your host to import it to your server. the wiki has informations about how to migrate from one server/domain name to another

X+

[bmw]

Folks shouldn't be nervous or anxious about changing hosters as far as websites are concerned. Since most are all contained in a folder or just the webroot, compressing all the files and dropping them into a new host is pretty easy. Then make sure it all works with the help of the new host support team then change your DNS. Email is a little more difficult. And of the really cheap hosts, you get what you pay for.

If you are experienced enough to run your own server, Chunkhost.com provides very inexpensive dedicated VPS with a modicum of GNU/Linux operating systems. You can then install whatever control panel of your choosing ie, Webmin, etc. At my office, I did extensive study for manage VPS with 24/7/365 support, most current updates/upgrades, Internet connection, bandwidth speeds, unmetered bandwidth, knowledge base, etc. We went with Wiredtree.com

Check here, too, http://www.brownempower.org/best-vps-deals/

The more I work with clients now that want management over their own hosting environment, Managed VPS is the way to go. I tend to steer clear of Parallels Plesk because none of its internal functions are portable nor do they update one-for-one the files on the server. It is its own platform unlike cPanel which for any adjustment you make in the GUI directly affects the appropriate file and, vice-versa, from command line shows the change in the GUI.

[Chris Burgess]

Folks shouldn't be nervous or anxious about changing hosters as far as websites are concerned. Since most are all contained in a folder or just the webroot, compressing all the files and dropping them into a new host is pretty easy.

I agree with your first statement, but I don't feel this is true for CiviCRM. Unlike Drupal/Wordpress etc, there are special considerations when migrating a CiviCRM site.

* MySQL dumps need special handling to avoid running into "missing DEFINER" errors due to use of views.
* CiviCRM DB contains absolute path references which can cause issues when relocating on the filesystem.
* (maybe fixed now?) An absolute path was at one point stored by CiviCRM in Drupal's variables table also.

These are all easy enough to work around if you know what to look for, eg if you migrate CiviCRM sites frequently, but for "regular users" I think it's the sort of thing that discourages people from staying in the ecosystem. We (CiviCRM community) don't have unlimited resources to address these so they are wishlist items at present, but not addressing them pushes users (and therefore resources) out of the ecosystem.