Difference between revisions of "User:Rfs/Installing wobble motions"

From FreekiWiki
Jump to navigation Jump to search
Line 16: Line 16:
 
  CREATE ROLE
 
  CREATE ROLE
 
  postgres@boq:~$  
 
  postgres@boq:~$  
 +
 +
Set the user's password:
 +
rfs@boq:~/wobble/motions/trunk$ psql template1
 +
Welcome to psql 8.2.5, the PostgreSQL interactive terminal.
 +
 +
Type:  \copyright for distribution terms
 +
      \h for help with SQL commands
 +
      \? for help with psql commands
 +
      \g or terminate with semicolon to execute query
 +
      \q to quit
 +
 +
template1=# ALTER USER rfs password 'PUT_THE_PASSWORD_HERE';
 +
ALTER ROLE
 +
template1=#
  
 
Create the databases (empty for now):
 
Create the databases (empty for now):
Line 24: Line 38:
 
  rfs@boq:~/wobble/motions/trunk$ createdb motions_prioduction
 
  rfs@boq:~/wobble/motions/trunk$ createdb motions_prioduction
 
  CREATE DATABASE
 
  CREATE DATABASE
 +
 +
Populate the database:
 +
rfs@boq:~/wobble/motions/trunk$ rake db:migrate
 +
(in /home/rfs/wobble/motions/trunk)
 +
rake aborted!
 +
could not connect to server: Connection refused
 +
        Is the server running on host "localhost" and accepting
 +
        TCP/IP connections on port 5433?
 +
 +
(See full trace by running task with --trace)
 +
 +
''(Hmmm.. that's a problem.)''
  
 
Start the server:
 
Start the server:
Line 36: Line 62:
 
Using a browser, go to:
 
Using a browser, go to:
 
  http://localhost:3000
 
  http://localhost:3000
 +
 +
Click on a link, which will take you to a log in page. Log in:
 +
PGError in LoginController#login
 +
 +
could not connect to server: Connection refused
 +
Is the server running on host "localhost" and accepting
 +
TCP/IP connections on port 5433?
 +
 +
''(OK. That needs fixing too.)''

Revision as of 10:53, 8 October 2007

Install necessary pacakages:

sudo aptitude install rails rubygems postgresql-8

Trying to start the server, I got a message that said to do this as well:

sudo gem install -v=1.1.6 rails

Get the application(s) from the svn server:

svn co svn+ssh://dev.freegeek.org/svn/wobble/trunk wobble/trunk

(??? actually I need to get motions which is a sub-project of wobble.)

Create a user for the database:

rfs@boq:~/wobble/motions/trunk$ sudo su - postgres
postgres@boq:~$ createuser rfs
Shall the new role be a superuser? (y/n) y
CREATE ROLE
postgres@boq:~$ 

Set the user's password:

rfs@boq:~/wobble/motions/trunk$ psql template1
Welcome to psql 8.2.5, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
      \h for help with SQL commands
      \? for help with psql commands
      \g or terminate with semicolon to execute query
      \q to quit

template1=# ALTER USER rfs password 'PUT_THE_PASSWORD_HERE';
ALTER ROLE
template1=# 

Create the databases (empty for now):

rfs@boq:~/wobble/motions/trunk$ createdb motions_test
CREATE DATABASE
rfs@boq:~/wobble/motions/trunk$ createdb motions_development
CREATE DATABASE
rfs@boq:~/wobble/motions/trunk$ createdb motions_prioduction
CREATE DATABASE

Populate the database:

rfs@boq:~/wobble/motions/trunk$ rake db:migrate
(in /home/rfs/wobble/motions/trunk)
rake aborted!
could not connect to server: Connection refused
       Is the server running on host "localhost" and accepting
       TCP/IP connections on port 5433?
(See full trace by running task with --trace)

(Hmmm.. that's a problem.)

Start the server:

rfs@boq:~/wobble/motions/trunk$ ./script/server 
=> Booting WEBrick...
=> Rails application started on http://0.0.0.0:3000
=> Ctrl-C to shutdown server; call with --help for options
[2007-10-08 10:19:56] INFO  WEBrick 1.3.1
[2007-10-08 10:19:56] INFO  ruby 1.8.5 (2006-08-25) [i486-linux]
[2007-10-08 10:19:56] INFO  WEBrick::HTTPServer#start: pid=7392 port=3000

Using a browser, go to:

http://localhost:3000

Click on a link, which will take you to a log in page. Log in:

PGError in LoginController#login

could not connect to server: Connection refused

Is the server running on host "localhost" and accepting TCP/IP connections on port 5433?

(OK. That needs fixing too.)