Difference between revisions of "Ideas"
From Hack Sphere Labs Wiki
(→Concept) |
(→Notes) |
||
(18 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
+ | Site is now up @ http://ideas.hackspherelabs.com | ||
+ | |||
=Concept= | =Concept= | ||
Line 6: | Line 8: | ||
*You should be able to travel and link ideas | *You should be able to travel and link ideas | ||
*<idea> tag takes txt from other sites linked to the wiki | *<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= | =Temp Store= | ||
Line 12: | Line 14: | ||
*An array on top of the car with sensors and cameras intergrated into an in car computer. | *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. | *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 [[File | sites/default/settings.php ]] | ||
+ | |||
+ | <pre> | ||
+ | change the line: | ||
+ | |||
+ | $db_url = 'mysql://username:password@localhost/databasename'; | ||
+ | |||
+ | to | ||
+ | |||
+ | $db_url = 'pgsql://username:password@localhost/databasename'; | ||
+ | </pre> | ||
+ | |||
+ | {{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 [http://www.ideatorrent.org/docs/en/installation.txt.html] | ||
+ | *Like it says make sure to enable clean urls [http://drupal.org/getting-started/clean-urls] | ||
+ | *Enable Modules | ||
+ | *Most likley you may need autoaddignrole for drupal: http://drupal.org/project/autoassignrole | ||
+ | |||
+ | =Notes= | ||
+ | Syntax: | ||
+ | DROP TABLE films, distributors; |
Latest revision as of 16:36, 7 January 2012
Site is now up @ http://ideas.hackspherelabs.com
Contents
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
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';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
Notes
Syntax:
DROP TABLE films, distributors;