Difference between revisions of "Drupal"
(→Notes: database setup) |
|||
| Line 5: | Line 5: | ||
* {{wikipedia|Drupal}} | * {{wikipedia|Drupal}} | ||
==Notes== | ==Notes== | ||
| + | ===Database Setup=== | ||
| + | The instructions assume you have shell access to the database server machine, which often isn't the case and is actually quite unnecessary. I installed Drupal on a server where all databases had to be created through a control panel. After creating the database, I gave my "root" user admin privileges on the new database and then created a new user specifically for Drupal to use, with read/write privileges only. Then on my ''local'' machine, I chdir to the directory with the database.4.1.mysql file and run mysql with the following command: | ||
| + | {{manpagelink|mysql}} -h<u>hostname</u> -u<u>username</u> -p<u>password</u> <u>databasename</u> < database.4.1.mysql | ||
| + | ...where <u>hostname</u> is the domain name of the server (e.g. mysql.yourhost.com), <u>databasename</u> is the name of the new database, and <u>username</u> and <u>password</u> are those of the "root" admin user (so it can create tables). After installation, I modify $db_url in the /sites/defaults/settings.php file to use the new read/write user's name and password. (When installing new modules or upgrading Drupal, you may need to temporarily grant this user CREATE and MODIFY permissions, or temporarily let Drupal use the "root" user.) (Note: I may not have this procedure quite right, as it is taking rather a long time the second time around. Will modify post when I know what's going on.) --[[User:Woozle|Woozle]] 14:18, 18 May 2006 (EDT) | ||
| + | ===Organic Groups=== | ||
I've twice had problems after installing the [http://drupal.org/project/og Organic Groups] module, but the second time around I was able to resolve it with a little help from [http://drupal.org/node/20419 this page]. The notes on that page are apparently for an earlier version of OG & Drupal; the equivalent sql code is now in og.install. There wasn't a problem with a doubled comma, but when I copied/pasted the SQL code into MySQL Query Browser and tried to execute it, it didn't like the way the table names had {brackets} around them. I took those out, and everything got happy again. (Couldn't figure out how to post a reply to the bug page, so my notes go here instead.) --[[User:Woozle|Woozle]] 21:59, 13 May 2006 (EDT) | I've twice had problems after installing the [http://drupal.org/project/og Organic Groups] module, but the second time around I was able to resolve it with a little help from [http://drupal.org/node/20419 this page]. The notes on that page are apparently for an earlier version of OG & Drupal; the equivalent sql code is now in og.install. There wasn't a problem with a doubled comma, but when I copied/pasted the SQL code into MySQL Query Browser and tried to execute it, it didn't like the way the table names had {brackets} around them. I took those out, and everything got happy again. (Couldn't figure out how to post a reply to the bug page, so my notes go here instead.) --[[User:Woozle|Woozle]] 21:59, 13 May 2006 (EDT) | ||
Revision as of 18:18, 18 May 2006
Computing: Software: Web Applications: Drupal
|
This page is a seed article. You can help HTYP water it: make a request to expand a given page and/or donate to help give us more writing-hours!
|
Drupal is a content management system written in PHP and using Apache (web server) and MySQL (though other database engines are either supported or will soon be).
Reference
Notes
Database Setup
The instructions assume you have shell access to the database server machine, which often isn't the case and is actually quite unnecessary. I installed Drupal on a server where all databases had to be created through a control panel. After creating the database, I gave my "root" user admin privileges on the new database and then created a new user specifically for Drupal to use, with read/write privileges only. Then on my local machine, I chdir to the directory with the database.4.1.mysql file and run mysql with the following command:
mysql -hhostname -uusername -ppassword databasename < database.4.1.mysql
...where hostname is the domain name of the server (e.g. mysql.yourhost.com), databasename is the name of the new database, and username and password are those of the "root" admin user (so it can create tables). After installation, I modify $db_url in the /sites/defaults/settings.php file to use the new read/write user's name and password. (When installing new modules or upgrading Drupal, you may need to temporarily grant this user CREATE and MODIFY permissions, or temporarily let Drupal use the "root" user.) (Note: I may not have this procedure quite right, as it is taking rather a long time the second time around. Will modify post when I know what's going on.) --Woozle 14:18, 18 May 2006 (EDT)
Organic Groups
I've twice had problems after installing the Organic Groups module, but the second time around I was able to resolve it with a little help from this page. The notes on that page are apparently for an earlier version of OG & Drupal; the equivalent sql code is now in og.install. There wasn't a problem with a doubled comma, but when I copied/pasted the SQL code into MySQL Query Browser and tried to execute it, it didn't like the way the table names had {brackets} around them. I took those out, and everything got happy again. (Couldn't figure out how to post a reply to the bug page, so my notes go here instead.) --Woozle 21:59, 13 May 2006 (EDT)