[Radiant] setup_database error

[jlopez at hpcf.upr.edu]

Hi,

I'm having an installation problem with Radiant.

I'm on a shared hosting at a university.

I succesfully installed ruby-1.8.5,

since I'm on a shared and can't write on the /usr/ direcotry I used
--prefix=/home/cybrary/source/ruby

and then set up alias ruby=/home/cybrary/source/ruby/bin.ruby on my .bashrc

Then I installed rubygems-0.9.0 using ruby setup.rb

And set up the gem alias.

Finally I typed /gem install radiant --include dependencies, set up the
radiant alias, and typed radiant mysite

It succesfully created my new site.

This is my database.yml

I was only assigned two databases by the university 'test' and 'cybrary'
but I guess this shouldn't be a problem.

development:
  host: localhost
  socket: /var/lib/mysql/mysql.sock
  adapter: mysql
  database:
  username: p0pnfresh
  password: xxx

test:
  host: localhost
  socket: /var/lib/mysql/mysql.sock
  adapter: mysql
  database: test
  username: p0pnfresh
  password: xxx

production:
  host: localhost
  socket: /var/lib/mysql/mysql.sock
  adapter: mysql
  database: cybrary
  username: p0pnfresh
  password: xxx

-----------------------------------------------------------------------

When I cd radiant and ruby script/setup_database test I get the following
error:

Loading test environment...OK

WARNING! This script will overwrite information currently stored in the
database "test". Are you sure you want to continue? [Yn] Y

Creating tables...
-- drop_table("config")
-- create_table("config", {:force=>true})
FAILED
/home/cybrary/source/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract_adapter.rb:120:in
`log': Mysql::Error: Lost connection to MySQL server during query: CREATE
TABLE config (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `key`
varchar(40) DEFAULT '' NOT NULL, `value` varchar(255) DEFAULT '')
ENGINE=InnoDB (ActiveRecord::StatementInvalid)
        from
/home/cybrary/source/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/mysql_adapter.rb:184:in
`execute'
        from
/home/cybrary/source/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract/schema_statements.rb:104:in
`create_table'
        from
/home/cybrary/source/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/mysql_adapter.rb:297:in
`create_table'
        from
/home/cybrary/source/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/migration.rb:273:in
`send'
        from
/home/cybrary/source/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/migration.rb:273:in
`method_missing'
        from
/home/cybrary/source/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/migration.rb:257:in
`say_with_time'
        from /home/cybrary/source/ruby/lib/ruby/1.8/benchmark.rb:293:in
`measure'
        from
/home/cybrary/source/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/migration.rb:257:in
`say_with_time'
         ... 6 levels...
        from script/setup_database:99:in `create_tables'
        from script/setup_database:19:in `run'
        from script/setup_database:9:in `run'
        from script/setup_database:297

------------------------------------------------------------------------