CiviCRM Community Forums (archive)

 

I tried to install CiviCRM 2.1 Alpha on my Drupal 6.3 site and I got the following three errors:

CiviCRM Database Details
    "Can I access/create InnoDB tables in the database - Unable to create InnoDB tables. MySQL InnoDB support is required for CiviCRM but is either not available or not enabled in this MySQL database server."

File Permissions
"Is the files folder writeable? - The user account used by your web-server - xxxxxxx - needs to be granted write access to the following directory in order to configure the CiviCRM settings file: (file directory)"
"Is the sites/default folder writable? - (same as above)"

I am unsure of how to correct these problems.. Where would I go to enable those file permissions?

And with the InnoDB tables, I'm not sure where to go for that one either. I got onto the phpMyAdmin for my site and found the Engines tab and saw that it had InnoDB on there, but it was grayed out and said that there was "no detailed status information available for this storage engine" ... I know nothing really about phpMyAdmin nor how I should go about trying to enable this, so any help here would be greatly appreciated.

Quote

CiviCRM Database Details
    "Can I access/create InnoDB tables in the database - Unable to create InnoDB tables. MySQL InnoDB support is required for CiviCRM but is either not available or not enabled in this MySQL database server."

Looks like your MySQL is not configures for InnoDB support. Check with your server administrator.

I called our web host and they said they wont do it unless we shell out more money each month. Ugh. Is there any way to tell if a host will allow things like that to be enabled before you buy their product? (We were looking into new web hosters anyways since they charge us too much now anyways..) Or maybe a work around?

Quote

File Permissions
"Is the files folder writeable? - The user account used by your web-server - xxxxxxx - needs to be granted write access to the following directory in order to configure the CiviCRM settings file: (file directory)"
"Is the sites/default folder writable? - (same as above)"

You need to do chmod 777 for files directory. under sites/default

Also check http://wiki.civicrm.org/confluence/display/CRMDOC/Install+2.1+for+Drupal

HTH

Kurund

How do I do that? I've checked the Wiki and I cannot seem to find anything on it relating to my specific problems..

To run CiviCRM you need to have InnoDB support for MySQL..

Check the community moderated "Hosting Providers" listing on the wiki - pretty sure quite a few of them are relatively low cost and provide INNODB:
http://wiki.civicrm.org/confluence/display/CRM/Hosting+provider+information

kurund

The versions do matter CiviCRM 2.1 only runs with Drupal 6.x

I wouldn't put to much stock in what the host listings say... some entries are older  so you should contact the host.

The underlying MYSQL, PHP and apache requirements would drive whether you can run D5 & D6 on the same host... for the most part the answer will be yes.

There is not reason to suspect that  hosts that could run CiviCRM in the past will not be able to run the latest versions (though it is possible, though improbable that there might be issues with PHP/MySQL/Apache versions).

I am getting an error of "The user account used by your web-server needs to be granted write access to the following directory in order to configure the CiviCRM settings file" when trying to install CiviCRM 2.1 Alpha 4 on my Xampp/Drupal 6.4 WINDOWS XP box.

By default civicrm.settings.php is created in sites/default folder. So it looks like webserver cannot write to "default" folder.

Also, I'm getting "CiviCRM needs a minimum of 32M allocated to PHP, but recommends 64M. You only have 32M allocated". I've searched all my php.ini files for "memory_limit" and changed every occurance to 64M and restarted without success. It still reports 32M in CiviCRM's installer.

Not played much with Xampp, so may be google is your best friend.
Do check: http://forum.civicrm.org/index.php/topic,3102.0.html

Kurund