P2PU: Drupal Introduction #1

I’ve started two drupal courses through P2PU and want to keep my work on each separated.

To achieve this I need:

• Two separate drupal folders
• Two separate drupal databases
• Two separate virtual sites for apache

I made the first site “drupalintro” in the same manner as outlined in my earlier post P2PU: Drupal Social Web Application #1 with the following changes.

1. The drupal directory was named /var/www/drupalintro
2. $ mysqladmin –u root –p create drupalintro
3. mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON drupalintro.* TO ‘<drupaluser>’@’localhost’ IDENTIFIED BY ‘<drupalpass>’;
4. mysql> FLUSH PRIVILEGES;
5. mysql> \q
6. $ vim /var/www/drupalintro/sites/default/settings.php
7. edit:  $db_url = ‘mysql://<drupaluser>:<drupalpass>@localhost/drupalintro’;
8. $ cp /etc/apache2/sites-available/default /etc/apache2/sites-available/drupalintro
9. $ vim /etc/apache2/sites-available/drupalintro
10. edit: DocumentRoot /var/www/drupalintro
11. edit: Directory /var/www/drupalintro

Now to make the second site called “openhippel” I did the same again with the following changes:

1. The drupal directory was named /var/www/openhippel
2. $ mysqladmin –u root –p create openhippel
3. mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON openhippel.* TO ‘<drupaluser>’@’localhost’ IDENTIFIED BY ‘<drupalpass>’;
4. mysql> FLUSH PRIVILEGES;
5. mysql> \q
6. $ vim /var/www/openhippel/sites/default/settings.php
7. edit:  $db_url = ‘mysql://<drupaluser>:<drupalpass>@localhost/openhippel;
8. $ cp /etc/apache2/sites-available/default /etc/apache2/sites-available/openhippel
9. $ vim /etc/apache2/sites-available/openhippel
10. edit: DocumentRoot /var/www/openhippel
11. edit: Directory /var/www/openhippel

Now to change between the two virtual sites I simply use the following (shown for selecting drupalintro)

1. $ sudo a2dissite openhippel && sudo a2ensite drupalintro
2. $ sudo /etc/init.d/apache2 reload

Then I can browse to my localhost address and see the home page for the desired site.

Technorati Tags: drupal,p2pu,apache,ubuntu,howto,virtual sites,mysql

P2PU: Drupal Social Web Application #2

Just finished the first Tokbox session for the Drupal Social Web course. Bit of a bumpy start with the first session starting half an hour late!

I’m starting by forking three repositories from GitHub that will be used for this project. The repositories as I understand them are:

1. hippel_idea the features package
2. hippel_kit which will contain drush makefiles
3. hippelicious a hippel theme

It looks like the idea this week is to make sure we can fork these and edit them locally before commiting, pushing back to our own github forks and sending a pull request to the original repository.

At this stage I will consider it an added bonus if I can make these work in my drupal install…

Technorati Tags: p2pu,drupal,openhippel

P2PU: Drupal Social Web Application #1

I’ve enrolled in a P2PU course called Drupal Social Web Application. Over the next 6 weeks I’ll be learning how to use Drupal and git while working on development of the Open Hippel platform. Most of this stuff is pretty new to me so I’ll be in over my head. I’ll also be moving house at the same time, hopefully without too much of a no interwebs period. When it rains it pours!

I’ve been getting acquainted with Drupal this week and after some trials with the Ubuntu drupal6 package I’ve opted for the manual installation of Drupal as outlined in the Ubuntu Community Documentation. The manual installation allows me some more flexibility in terms of where I keep my files and which version I use when compared to a package install.

Here is a brief outline of the steps I followed on an Ubuntu Server 10.04 virtual machine.

1. $ cd ~
2. $ wget http://ftp.drupal.org/files/projects/drupal-6.19.tar.gz
3. $ tar zxvf drupal-6.19.tar.gz
4. $ sudo mkdir /var/www/drupal
5. $ sudo mv drupal-6.19/* drupal-6.19/.htaccess /var/www/drupal
6. $ sudo mkdir /var/www/drupal/sites/default/files
7. $ sudo chown www-data:www-data /var/www/drupal/sites/default/files
8. $ sudo cp /var/www/drupal/sites/default/default.settings.php /var/www/drupal/sites/default/settings.php
9. $ sudo chown www-data:www-data /var/www/drupal/sites/default/settings.php
10. $ mysqladmin –u root –p create drupal
11. $ mysql –u root –p
12. mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON drupal.* TO ‘<drupaluser>’@’localhost’ IDENTIFIED BY ‘<drupalpass>’;
13. mysql> FLUSH PRIVILEGES;
14. mysql> \q
15. $ vim /var/www/drupal/sites/default/settings.php
16. edit:  $db_url = ‘mysql://<drupaluser>:<drupalpass>@localhost/drupal’;
17. $ cp /etc/apache2/sites-available/default /etc/apache2/sites-available/drupal
18. $ vim /etc/apache2/sites-available/drupal
19. edit: DocumentRoot /var/www/drupal
20. $ sudo a2dissite default && a2ensite drupal
21. $ sudo /etc/init.d/apache2 reload
22. From the host (or any machine on the same network) browse to “<server ip>/install.php” and follow the web based setup for Drupal

Technorati Tags: p2pu,drupal,ubuntu,howto

Mount a Windows Share in Ubuntu Server

It is really ease to access a windows share from the console of Ubuntu Server. The following steps were performed on Ubuntu Server 10.04 to access a share on a QNAP NAS with no username or password required.

1. $sudo apt-get install smbfs
2. $mkdir ~/temp
3. $sudo mount.cifs //192.168.0.x/public ~/temp

Now it is possible to cd into temp and ls the contents of the public share.

Technorati Tags: windows,ubuntu,share,mount,howto