CiviCRM Community Forums (archive)

Thanks for your response nextwave.  However, I am still in a cloud and am not sure what to tell the hosting company.  There is no access to WHM on this account, so whatever tweeks need to be done will be done by the hosting company.  And to do this, they want to know specifically, what triggers are required by CiviCRM?

@JMdezigns-
they have to access whm-
and you tell them to do this:
We go into cpanels whm-
to PHPmyAdmin
select> users
pick the database user- for Civi- and edit privileges
under admin- make it "super"

That's it.

Addition to my first post (creating this topic)
I have seen that i am using
    mysqlnd 5.0.10 (mysql native driver)
   phpinfo: Client API library version mysqlnd 5.0.10 - 20111026 
in php.ini php_pdo_mysql extension is enabled

Is this the good mysqlnd for mysql 5.5.24?

Hey friends!

I really want to mention that I am very sad that CiviCRM is not learning it's lessions and keeping with triggers, views a.s.o.

As DB-engineer I can definitely say that triggers are NOT needed at all. No reference-constraints and also no views. It is nothing else than bad practice and creation of dependency.

Please do not wonder if CiviCRM-usage will go down soon. RESTful and lightweight-solutions have green light.

The sentence written by admins: "CiviCRM is a heavy-weight-system" is not legitimated technically at all. Sorry, what shall be heavy-weight at a CRM??

The only heavy-weight-part might be the mailing-servers who have to handle thousands of recipients. Everything else is just a DB-web-app.

Sorry for the world, sorry for CiviCRM that there seems not to be the willingness to look into a simple future.

Keep it small and simple as long as you want the planet to be happy with CiviCRM. I expect there are not only positive-minded people working in the team any more. As usual, when something becomes too useful for the public, some other people jump into the team and care for the 'right way' of development.

Sorry for us all!

All (=) Love, Ernesto ~:)

Hey Donald!

First of all I want to say how thankful I am. I use CiviCRM for two+ organisations. One is big: Global Ecovillage Network and I suggest definitely donating to you, great developers!!

Maybe the reason why I like CiviCRM so much is also the reason why I am soooo sad that you use triggers, constraints and such..

Well, yes. I can find link telling what I want to tell you.

But get my point: There are many 'complex' systems out there and some proofed to keep simple and clean. Some are really easy to migrate and to switch between domains and so. E.g. Drupal 7

What do those systems do: They use standard-features and nothing else. That further helps them to be independent of the SQL-server and so.

Please think about that: Can you imagine ONE thing you really NEED to have something else than usual Tables, Keys and Indexes?!?!

I am developing for industries as well. I never saw one reason to use any other MySQL-feature than the mentioned ones.

There is simply NO use-case where you really NEED triggers or constraints. They are kind of 'luxury' which leads in a real hell.

---------------------------------
I am willing to jump into a development-branch of CiviCRM which removes all dependencies which are not common on cheap hosted servers.
---------------------------------

I just updated from Civi 4.2.7 to Civi 4.3.5. Man, that was bad. The updating-process just skipped with an error when it was not able to fullfill some reference-constraint. I had to remove/change the update-SQL inside the scripts in Civi/Updater/...  I was working locally (Had to fake the domain also, another dependency) and still, my root-MySQL-acount wasn't enough.

Or, look at the directory-entries in the file: sites\default\files\civicrm\ConfigAndLog\Config.IDS.ini   Why?? Why another place else than the setting-file.

Such things cost hundreds of hours at the customer-side. Why all this? I see no reason technically. Sorry. It is just bad design.

----

CiviCRM shall go REST and HTML5. Do you like this vision? If you need me, I am willing to contribute!

All (=) Love, Ernesto ~:)
 
PS: I am not allowed to post external links into the forum yet it seems.

Hey Donald!

I totally understand to keep with the way it has been. Even if there is nothing steady, but the change.

Well, new Open Source CRM are created at the moment using new approaches. It is sad for CiviCRM

* that it will only be used then if no migration-path is available to the customer
* that the great knowledge and experience you gathered will not sustain directly

Well, whenever you decide to open yourself for a mayor reengineering let me know. I would love this approach.

Thanks for being so open. Knowing that, I also know that I have to:

* ensure MySQL-privileges for 'all future'
* be aware that a RESTful CiviCRM is a question of many years

Thanks!! And thumbs up!!

All (=) Love, Ernesto ~:)

CPanel has changed the way you access trigger privileges- and made this really complex.
I have no clue what to do about this- these were the instructions from my Hosting center on a possible solution to this issue- and it sure looks overly complex:

For the phpMyAdmin issue, I'd recommend creating a new cPanel account and installing a non-cPanel driven copy of phpMyAdmin there.  cPanel made a *lot* of changes to their phpMyAdmin installation in the last release, and it appears they've removed all of the functions you use regularly.  We can edit their config to put them back, but it will get overwritten every night when cPanel updates.  If you create a "mysqladmin.nextwavehosting.net" account, you can install your own, non-cPanel copy of phpMyAdmin directly in public_html.  I'd recommend doing this, and making public_html password-protected so there are 2 levels of authentication.  The root MySQL password is in /root/.my.cnf on the server for the configuration of the new PMA instance, but this appears to be the best way for you to have a full, uninhibited copy of PMA to do what you require.

Since CPanel is running about a third of LAMP servers- I think some very detailed instructions on how exactly trigger privileges are set in this environment are MANDATORY- so CiviCRM can continue to be taken seriously.
I am more than willing to set up an account on my server for one of the Civi people who insist on including trigger privileges as part of the setup for Civi- to try to install and run the software using Cpanel as a setup tool- so they can document it for us n00bs who are trying to change the world- instead of becoming programmers.