特殊:Badtitle/NS100:Drupal:修订间差异
小无编辑摘要 |
小无编辑摘要 |
||
第21行: | 第21行: | ||
<pre><nowiki> | <pre><nowiki> | ||
mysql -u root | mysql -u root | ||
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('yourpassword'); | mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('yourpassword'); | ||
</nowiki></pre> | </nowiki></pre> | ||
第52行: | 第53行: | ||
<pre><nowiki> | <pre><nowiki> | ||
mysql -u root -p | mysql -u root -p | ||
mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON drupal.* TO 'drupaluser'@'localhost' IDENTIFIED BY 'drupalpass'; | mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON drupal.* TO 'drupaluser'@'localhost' IDENTIFIED BY 'drupalpass'; | ||
</nowiki></pre> | </nowiki></pre> | ||
第122行: | 第124行: | ||
<pre><nowiki> | <pre><nowiki> | ||
# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD | # TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD | ||
host drupaldb drupaluser 127.0.0.1 255.255.255.255 password | host drupaldb drupaluser 127.0.0.1 255.255.255.255 password | ||
</nowiki></pre> | </nowiki></pre> | ||
Save the file (Ctrl + x, y) | Save the file (Ctrl + x, y) | ||
第172行: | 第174行: | ||
* Database URL format: | * Database URL format: | ||
$db_url = 'pgsql://username:password@localhost/databasename'; | $db_url = 'pgsql://username:password@localhost/databasename'; | ||
where username | where username = drupaluser password = drupaluserpass databasename = drupaldb | ||
</nowiki></pre> | </nowiki></pre> | ||
Save the file (Ctrl + x, y) | Save the file (Ctrl + x, y) |
2007年12月6日 (四) 10:12的版本
文章出处: |
{{#if: | {{{2}}} | https://help.ubuntu.com/community/Drupal }} |
点击翻译: |
English {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/af | • {{#if: UbuntuHelp:Drupal|Afrikaans| [[::Drupal/af|Afrikaans]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/ar | • {{#if: UbuntuHelp:Drupal|العربية| [[::Drupal/ar|العربية]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/az | • {{#if: UbuntuHelp:Drupal|azərbaycanca| [[::Drupal/az|azərbaycanca]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/bcc | • {{#if: UbuntuHelp:Drupal|جهلسری بلوچی| [[::Drupal/bcc|جهلسری بلوچی]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/bg | • {{#if: UbuntuHelp:Drupal|български| [[::Drupal/bg|български]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/br | • {{#if: UbuntuHelp:Drupal|brezhoneg| [[::Drupal/br|brezhoneg]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/ca | • {{#if: UbuntuHelp:Drupal|català| [[::Drupal/ca|català]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/cs | • {{#if: UbuntuHelp:Drupal|čeština| [[::Drupal/cs|čeština]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/de | • {{#if: UbuntuHelp:Drupal|Deutsch| [[::Drupal/de|Deutsch]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/el | • {{#if: UbuntuHelp:Drupal|Ελληνικά| [[::Drupal/el|Ελληνικά]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/es | • {{#if: UbuntuHelp:Drupal|español| [[::Drupal/es|español]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/fa | • {{#if: UbuntuHelp:Drupal|فارسی| [[::Drupal/fa|فارسی]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/fi | • {{#if: UbuntuHelp:Drupal|suomi| [[::Drupal/fi|suomi]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/fr | • {{#if: UbuntuHelp:Drupal|français| [[::Drupal/fr|français]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/gu | • {{#if: UbuntuHelp:Drupal|ગુજરાતી| [[::Drupal/gu|ગુજરાતી]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/he | • {{#if: UbuntuHelp:Drupal|עברית| [[::Drupal/he|עברית]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/hu | • {{#if: UbuntuHelp:Drupal|magyar| [[::Drupal/hu|magyar]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/id | • {{#if: UbuntuHelp:Drupal|Bahasa Indonesia| [[::Drupal/id|Bahasa Indonesia]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/it | • {{#if: UbuntuHelp:Drupal|italiano| [[::Drupal/it|italiano]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/ja | • {{#if: UbuntuHelp:Drupal|日本語| [[::Drupal/ja|日本語]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/ko | • {{#if: UbuntuHelp:Drupal|한국어| [[::Drupal/ko|한국어]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/ksh | • {{#if: UbuntuHelp:Drupal|Ripoarisch| [[::Drupal/ksh|Ripoarisch]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/mr | • {{#if: UbuntuHelp:Drupal|मराठी| [[::Drupal/mr|मराठी]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/ms | • {{#if: UbuntuHelp:Drupal|Bahasa Melayu| [[::Drupal/ms|Bahasa Melayu]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/nl | • {{#if: UbuntuHelp:Drupal|Nederlands| [[::Drupal/nl|Nederlands]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/no | • {{#if: UbuntuHelp:Drupal|norsk| [[::Drupal/no|norsk]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/oc | • {{#if: UbuntuHelp:Drupal|occitan| [[::Drupal/oc|occitan]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/pl | • {{#if: UbuntuHelp:Drupal|polski| [[::Drupal/pl|polski]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/pt | • {{#if: UbuntuHelp:Drupal|português| [[::Drupal/pt|português]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/ro | • {{#if: UbuntuHelp:Drupal|română| [[::Drupal/ro|română]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/ru | • {{#if: UbuntuHelp:Drupal|русский| [[::Drupal/ru|русский]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/si | • {{#if: UbuntuHelp:Drupal|සිංහල| [[::Drupal/si|සිංහල]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/sq | • {{#if: UbuntuHelp:Drupal|shqip| [[::Drupal/sq|shqip]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/sr | • {{#if: UbuntuHelp:Drupal|српски / srpski| [[::Drupal/sr|српски / srpski]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/sv | • {{#if: UbuntuHelp:Drupal|svenska| [[::Drupal/sv|svenska]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/th | • {{#if: UbuntuHelp:Drupal|ไทย| [[::Drupal/th|ไทย]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/tr | • {{#if: UbuntuHelp:Drupal|Türkçe| [[::Drupal/tr|Türkçe]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/vi | • {{#if: UbuntuHelp:Drupal|Tiếng Việt| [[::Drupal/vi|Tiếng Việt]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/yue | • {{#if: UbuntuHelp:Drupal|粵語| [[::Drupal/yue|粵語]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/zh | • {{#if: UbuntuHelp:Drupal|中文| [[::Drupal/zh|中文]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/zh-hans | • {{#if: UbuntuHelp:Drupal|中文(简体)| [[::Drupal/zh-hans|中文(简体)]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Drupal | UbuntuHelp:Drupal | {{#if: | :}}Drupal}}/zh-hant | • {{#if: UbuntuHelp:Drupal|中文(繁體)| [[::Drupal/zh-hant|中文(繁體)]]}}|}} |
{{#ifeq:UbuntuHelp:Drupal|:Drupal|请不要直接编辑翻译本页,本页将定期与来源同步。}} |
{{#ifexist: :Drupal/zh | | {{#ifexist: Drupal/zh | | {{#ifeq: {{#titleparts:Drupal|1|-1|}} | zh | | }} }} }} {{#ifeq: {{#titleparts:Drupal|1|-1|}} | zh | | }}
This documentation needs to be updated for installing Drupal using Postgresql-8.2 on Feisty. |
Drupal
Drupal is a robust Content Management System that runs on LAMP. Without any of its aditional modules, it can host blogs, forums, and a variety of other content. It has an astounding number of modules which bring added functionality to your site, including advertising, chatbox, e-commerce, various multimedia tools, instant messenger, light customer relationship management, printer friendly pages, webcam, etc... Follow these instructions to install Drupal on Ubuntu 6.06 (Dapper Drake), Ubuntu 6.10 (Edgy Eft) and Ubuntu 7.04 (Feisty Fawn). This page also explains the steps used to install the 5.1 branch of Drupal on Ubuntu. To install Drupal-5.1 with php5 and Postgresql-8.1, follow instructions at bottom of page.
Installing
An older version of Drupal is present in the repositories, but it is no longer supported upstream. A more recent version has more modules and themes. As well, since the package is so old, the installation of the Drupal package from the repositories will replace php5 in with php4. Also, none of the Drupal modules are packaged and present in the repositores. Therefore, it is advisable to install the latest version from drupal.org.
Install the LAMP stack
Use any method to install the LAMP stack packages.
apache2 php5-mysql php5-gd libapache2-mod-php5 mysql-server
Set a mysql-root password (not the same as a root password, but a password for mysql)
mysql -u root mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('yourpassword');
A successful mysql command will show: Query OK, 0 rows affected (0.00 sec) Quit the mysql prompt:
mysql> \q
You should now have a functional LAMP stack and a password for the mysql root user. Visit Apache PHP MySQL for more information on LAMP.
Get the most recent version of Drupal
There are two stable banches of Drupal. Currently 4.6.7 and 5.1. Both versions can be installed more or less the same way.
wget http://ftp.osuosl.org/pub/drupal/files/projects/drupal-4.7.6.tar.gz tar xvzf drupal-4.7.6.tar.gz sudo mkdir /var/www/drupal sudo mv drupal-4.7.6/* drupal-4.7.6/.htaccess /var/www/drupal
It is a good idea to create a files subdirectory in your drupal installation directory. It is not strictly neccessary, but will be used for files such as custom logos, user avatars, and other media associated with your new site.
sudo mkdir /var/www/drupal/files sudo chown www-data:www-data /var/www/drupal/files
Drupal needs a database, user and password
You need to create a drupal database and then load the database schema into it. You can do this with PhpMyAdmin or via the command line:
mysqladmin -u root -p create drupal
Where drupal is the name you picked for the mysql database that Drupal will use. You can call it anything you want.
mysql -u root -p mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON drupal.* TO 'drupaluser'@'localhost' IDENTIFIED BY 'drupalpass';
You do not want to have Drupal use the mysql root user to access the database. The above command creates a mysql user (other than the mysql root user) with some priviledges to use the drupal database. You should pick something different than drupaluser and drupalpass. If the command was successful, activate the new permissions:
mysql> FLUSH PRIVILEGES;
Quit the mysql prompt:
mysql> \q
Fill the database
(Skip this step if you are using Drupal 5.1. The tables are automatically loaded when you visit your web site for the first time.) Now, load the schema into the database. If you created a database with a different name, use that name instead of drupal.
mysql -u drupaluser -p drupal < /var/www/drupal/database/database.4.1.mysql
and enter the password at the prompt. For more details about configuring the mysql database for Drupal, read the INSTALL.mysql.txt file in the Drupal folder.
Settings
You need to edit the settings.php file so that drupal can know what user, password and database to use.
sudo nano /var/www/drupal/sites/default/settings.php
Add the proper user name (drupaluser), database name (drupal) and password (drupalpass) to the line that looks like: $db_url = "mysql://drupaluser:drupalpass@localhost/drupal";
PHP memory limit
Prior to 7.04, you may need to increase the amount of memory PHP can use to run scripts, Edit the /etc/php5/apache2/php.ini file and increase the memory_limit value to 32 megs or another value of your choice (8 megs is not enough for Drupal)
Reload Apache2
You probably need to force-reload apache2 if you have not done so since you installed LAMP.
sudo /etc/init.d/apache2 restart
Try it out
Point your browser to localhost/drupal, create an account and login. If you got a page full of warnings, it is because changing the settings.php file made Drupal incorrectly assume the DB had been created. The fix is to manually run the install script by pointing your browser to localhost/drupal/install.php The first account will automatically become the main administrator account with total control. Please refer to the drupal installation manual for more advanced hosting features.
Drupal 5.1
You need not edit the settings.php file buy hand when using the very latest version of Drupal. The installer now uses a graphical interface for setting up your site. The only caveat is that the settings.php file must be made writeable during the process. The installer will show you a message informing you that the file is not writeable if this is the case. It will also show you a message advising you to revert the permissions back to read-only after the changes have been saved, since keeping it writeable is a security risk. You may still edit the settings.php file by hand, as in the traditional way of installing, if you wish. Version 5.1 will automatically load the database when you first visit your site. You do not need to fill the database tables by hand.
POSTGRESQL-8.1 with PHP5 and DRUPAL5.1
Mysql is ideal for database-driven sites since it has better performance than Postgresql. Furthermore, some drupal modules are not tested using postgresql. However, if you want to run your drupal site using postgresql, follow these instructions. These instructions work on Ubuntu 6.06 and 6.10.
Install Postgresql 8.1
$ sudo aptitude install postgresql-8.1 $ sudo su postgres
Create a database and user for drupal on Postgresql
$ createuser -D -A -P drupaluser $ createdb -O drupaluser drupaldb
Modify the pg_hba.conf file of the postgresql DBMS
$ sudo nano /etc/postgresql/8.1/main/pg_hba.conf
comment out this line after
- "local" is for Unix domain socket connections only
# local all all ident sameuser
Add the following lines
# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD host drupaldb drupaluser 127.0.0.1 255.255.255.255 password
Save the file (Ctrl + x, y) Restart the postgresql database server engine
$ sudo /etc/init.d/postgresql* restart
Check your database connection:
$ psql -h 127.0.0.1 -p 5432 -U drupaluser -W drupaldb Enter the password for user drupaluser:
Install Drupal
Install drupal dependencies
# sudo aptitude install libapache2-mod-php5 php5-imagick php5-ldap php5-pgsql php5 zlib1g-dev
Download the drupal core files
$ sudo wget http://ftp.osuosl.org/pub/drupal/files/projects/drupal-5.1.tar.gz
Unpack the tarball
tar xvzf drupal-5.1.tar.gz
You can read the install file on creating postgresql database and user (already done above)
# sudo nano drupal-5.1/INSTALL.pgsql.txt
Make a folder for your drupal installation.
$ sudo mkdir /var/www/drupal
Move your drupal files into the drupal folder
$ sudo mv drupal-5.1/* drupal-5.1/.htaccess /var/www/drupal
Create a /files storage folder for things like files, images, etc
$ sudo mkdir /var/www/drupal/files
Make the data storage writeable
$ sudo chown -R www-data:www-data /var/www/drupal/files
Edit the settings.php file so that drupal can know what user, password and database to use.
$ sudo nano /var/www/drupal/sites/default/settings.php * Database URL format: $db_url = 'pgsql://username:password@localhost/databasename'; where username = drupaluser password = drupaluserpass databasename = drupaldb
Save the file (Ctrl + x, y) Edit the amount of memory PHP can use to run scripts. The default 8mb is not enough for drupal, set to 32mb or more
$ sudo nano /etc/php5/apache2/php.ini file ; Resource Limits ; memory_limit = 160M You may also edit the example lines to accommodate Postgresql options ; Example lines: ;extensions=pgsql.so
Save the changes to the php.ini file (Ctrl + x, y) Restart apache
sudo /etc/init.d/apache2 restart
Finish Installation
In a browser, enter: http://localhost/drupal/install.php
Configuration
File System Change the Download Method from public to private Select 'save configuration' Cron Click on 'You can run manually' For further configuration, please refer to:http://drupal.org/node/260