Difference between revisions of "Ideas"

From Hack Sphere Labs Wiki
Jump to: navigation, search
(Notes)
 
(15 intermediate revisions by the same user not shown)
Line 1: Line 1:
 +
Site is now up @ http://ideas.hackspherelabs.com
 +
 
=Concept=
 
=Concept=
  
Line 13: Line 15:
 
*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.
  
=In progress=
+
=Idea Torrent Setup=
 +
http://www.ideatorrent.org/download
 
http://www.ideatorrent.org/docs/en/installation.txt.html
 
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
 
Steps
 
*PHP/Apache/PostgreSQL
 
*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
 
*Test connection to database
 
  psql -h localhost -p 5432 -U drupalapp -W -d drupaldb;
 
  psql -h localhost -p 5432 -U drupalapp -W -d drupaldb;
 
*Install Drupal6
 
*Install Drupal6
 
**The SQL part of the wizard does not work.  You have manually edit [[File | sites/default/settings.php ]]
 
**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 17:36, 7 January 2012

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

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;
 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';
+ *
  */

Notes

Syntax:

DROP TABLE films, distributors;