I am currently testing Drupal, a very mature and flexible content management system. Drupal is currently available in the stable version 6.19, which should be used for production systems. Drupal 7, which is currently in beta 3, brings a lot of new features and is definitely worth a test.
In preparation for moving my websites to Drupal, I had already installed some Drupal 6.x test systems on my 1&1 (German Internet Provider) dedicated managed server. The installation is not quite trivial on their servers, but you can find some good tutorials for Drupal 6 on the web. Yesterday I tried to install Drupal 7 on my server and I was about to despair if I had not found the following tip related to Piwik, a PHP web analysis software.
Drupal 6 or 7 have relatively high system requirements, and therefore usually an installation fails on simple standard hosts. Drupal needs PHP 5, a mySQL database and a good portion of RAM, depending on how many modules are activated.
My dedicated server is located in Germany; so I don’t really know if the following tips will work on servers located in the US. But I think it cannot hurt to try it, if nothing else works. The setup script for Drupal 7 especially fails on a 1&1 dedicated managed server if you try specifying “localhost” for the database host as 1&1 expects “localhost:/tmp/mysql5.sock” for this setting. And, if you try the settings for a Drupal 6 installation, this also does not work. However, if you try “localhost;unix_socket=/tmp/mysql5.sock” instead, this works well.
Settings for my Drupal installations on my 1&1 server
The first step I had done for installing Drupal 6 or Drupal 7 on my server is to edit the “.htaccess” file located in the install root directory and add the following lines on the top of the file. These statements are activating the PHP 5 support for the server.
Then, I optionally created a “php.ini” file containing the following statements:
The second statement increases the memory limit, as in general, these settings are set too low on 1&1 servers. If you are installing Drupal 6, you can edit the “settings.php” file located in the folder “sites/default” and setup the database connection parameters manually. Note: the break after the @ character must be removed, if you copy the statement.
And, if you are installing Drupal 7, you can enter “localhost;unix_socket=/tmp/mysql5.sock” to the database host setting in the advanced options. The “settings.php” reflects these settings as follows.