Ideas

Site is now up @ http://ideas.hackspherelabs.com

Concept

ideas.hackspherelabs.org - An idea storage and orginazation platform.

• The site should allow one to brainstorm
• You should be able to travel and link ideas
• <idea> tag takes txt from other sites linked to the wiki
• Site should allow paper sketches and such to be uploaded and notated

Temp Store

• An array on top of the car with sensors and cameras intergrated into an in car computer.
• A pair of sun glasses that allow you to stare at the sun, with improved image color, etc.

Idea Torrent Setup

http://www.ideatorrent.org/download http://www.ideatorrent.org/docs/en/installation.txt.html

The following pieces of software are required for IdeaTorrent to function:

• A webserver with PHP5
• PostgreSQL 8.3
• Drupal 5.x OR 6.x

Steps

• PHP/Apache/PostgreSQL
  • http://wiki.debian.org/PostgreSql

Note: Make sure that the user owns the database

http://fatpenguinblog.com/scott-rippee/granting-postgresql-database-and-table-ownership-privileges-to-a-new-user/

ALTER DATABASE mynewdb OWNER TO newuser; 

• Test connection to database

psql -h localhost -p 5432 -U drupalapp -W -d drupaldb;

• Install Drupal6
  • The SQL part of the wizard does not work. You have manually edit sites/default/settings.php

 change the line:

 $db_url = 'mysql://username:password@localhost/databasename';

 to

 $db_url = 'pgsql://username:password@localhost/databasename';

Note: I had to use the full settings. That is the wizard will not try and configure the changed url. You must have the correct line.

Note: I also had to run install.php manually (I had to navigate to it)

Note: I use dreamhost. I had to do a custom php.ini and they told me that I would need to compile the module for postgreSQL (pgsql.so) but I did locate pgsql.so on the box that I was using and found a good module.

Here: http://wiki.dreamhost.com/Php.ini#PHP_5.2

A snippit of documentation code from http://drupal.org/files/issues/settings_4.patch :

+ * Specifying the database port:
+ *
+ * If you need to specify a port other than the default for your database
+ * you can put it in the $db_url:
+ * e.g:
+ *   $db_url = 'mysql://username:password@localhost:3306/databasename';
+ *   $db_url = 'mysqli://username:password@localhost:3306/databasename';
+ *   $db_url = 'pgsql://username:password@localhost:5432/databasename';
+ *
  */

• Install ideatorrent [1]
• Like it says make sure to enable clean urls [2]
• Enable Modules
• Most likley you may need autoaddignrole for drupal: http://drupal.org/project/autoassignrole