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 (
idint(11) DEFAULT NULL auto_increment PRIMARY KEY,
keyvarchar(40) DEFAULT '' NOT NULL,
valuevarchar(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