Forum: Radiant CMS installing on Ubuntu

Hello,

I am having problems installing Radiant on my ubuntu machine here is the
output

$ ruby script/setup_database production
Run `setup_database --help` for information on additional options.

Loading production environment...FAILED
/usr/lib/ruby/1.8/yaml.rb:133:in `load': syntax error on line 5, col 2: 
`
socket: /tmp/mysql.sock' (ArgumentError)
        from /usr/lib/ruby/1.8/yaml.rb:133:in `load'
        from 
/usr/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/initializer.rb:459:in
`database_configuration'
        from 
/usr/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/initializer.rb:181:in
`initialize_database'
        from 
/usr/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/initializer.rb:84:in
`process'
        from 
/usr/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/initializer.rb:42:in
`run'
        from ./script/../config/environment.rb:15
        from script/setup_database:78:in `load_environment'
        from script/setup_database:258:in `announce'
        from script/setup_database:77:in `load_environment'
        from script/setup_database:17:in `run'
        from script/setup_database:9:in `run'
        from script/setup_database:297

I took a look at the file, but nothing seems to be wrong. Any help would 
be
greatly appreciated


Sara Vasquez

Hi Sara

Try checking the path to your mysql.sock file, in the database yml
file in your radiant config folder... it may not be '/tmp/mysql.sock'
on your system...

Cheers,

Michael

Hi Sara,

on my machine (Ubuntu 6.10 Edgy Eft) the value for 'socket:'
(in 'config/database.yml') is set to: '/var/run/mysqld/mysqld.sock'.
Hope that helps.


Best regards,
Andreas Semt


Sara schrieb:

Semt,
I know I created a symlink to it and it still did not work and then I 
just
deleted the link and just enter the /vr/run/ location and now I get the 
same
eror just with that location
$ruby script/setup_database production

Run `setup_database --help` for information on additional options.

Loading production environment...FAILED
/usr/lib/ruby/1.8/yaml.rb:133:in `load': syntax error on line 5, col 2: 
`
socket:/var/run/mysqld/mysqld.sock' (ArgumentError)
        from /usr/lib/ruby/1.8/yaml.rb:133:in `load'
        from 
/usr/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/initializer.rb:459:in
`database_configuration'
        from 
/usr/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/initializer.rb:181:in
`initialize_database'
        from 
/usr/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/initializer.rb:84:in
`process'
        from 
/usr/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/initializer.rb:42:in
`run'
        from ./script/../config/environment.rb:15
        from script/setup_database:78:in `load_environment'
        from script/setup_database:258:in `announce'
        from script/setup_database:77:in `load_environment'
        from script/setup_database:17:in `run'
        from script/setup_database:9:in `run'
        from script/setup_database:297

anyone has any other ideas as to what could be wrong.

Sara Vasquez

The problem is definitely with the __format__ of the database
configuration file. You should post the entirety of that file
(preferably as an attachment).

I'm running Dapper and had this problem too. What worked for me was 
removing
the socket lines from database.yml and using host: 127.0.0.1 instead.

Hope that help!

Jim

Jim,

Thanks so if I understand that correctly you deleted the sockets lines 
all
together and instead wrote a
host:127.0.0.1 instead?

Sara,

Indeed if you delete the socket line and use either 127.0.0.1 or just
plain ol' localhost works fine.

Great Tutorial on setting up rails on Ubuntu.

I have been so tired of using Windows XP that this weekend I managed to 
setup a dual boot system with my current Windows XP install and my new 
favorite operating system Ubuntu.

I used this tutorial to get my ROR up and running.
http://paulgoscicki.com/archives/2005/09/ruby-on-rails-on-ubuntu/

Everything worked according to plan and today I am back coding in Ruby 
on Rails in my Linux environment.

If you are still using Windows, I suggest you take a look at Ubuntu it 
is fairly easy to install if you can follow directions.
You won’t be disappointed with this OS and hos much faster and 
friendlier it is to use.

http://www.ubuntu.com/

100% agree

have ubuntu server 7.04 up and running along with mysql + ror + mongrel 
also
acting
as my home router for small network.

perfect system for people who want to close windows :)

All,

i keep on getting the same error, I have no idea what might be going 
wrong
since I managed to install both mephisto and RAM so I am lost as to what 
is
going wrong. Loading production environment...FAILED
/usr/lib/ruby/1.8/yaml.rb:133:in `load': syntax error on line 5, col 2: 
`
host: localhost' (ArgumentError)
        from /usr/lib/ruby/1.8/yaml.rb:133:in `load'
        from 
/usr/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/initializer.rb:459:in
`database_configuration'
        from 
/usr/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/initializer.rb:181:in
`initialize_database'
        from 
/usr/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/initializer.rb:84:in
`process'
        from 
/usr/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/initializer.rb:42:in
`run'
        from ./script/../config/environment.rb:15
        from script/setup_database:78:in `load_environment'
        from script/setup_database:258:in `announce'
        from script/setup_database:77:in `load_environment'
        from script/setup_database:17:in `run'
        from script/setup_database:9:in `run'
        from script/setup_database:297

All,
If I try that I get this
$ ruby script/setup_database production
Run `setup_database --help` for information on additional options.

Loading production environment...FAILED
/usr/lib/ruby/1.8/yaml.rb:133:in `load': syntax error on line 7, col -3:
`test: (ArgumentError)
  adapter: mysql
  database: radiant_test
  username: myusername
  password: mypassword


production:
  adapter: mysql
  database: radiant_live
  username: myusername
  password:mypassword
'       from /usr/lib/ruby/1.8/yaml.rb:133:in `load'
        from 
/usr/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/initializer.rb:459:in
`database_configuration'
        from 
/usr/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/initializer.rb:181:in
`initialize_database'
        from 
/usr/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/initializer.rb:84:in
`process'
        from 
/usr/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/initializer.rb:42:in
`run'
        from ./script/../config/environment.rb:15
        from script/setup_database:78:in `load_environment'
        from script/setup_database:258:in `announce'
        from script/setup_database:77:in `load_environment'
        from script/setup_database:17:in `run'
        from script/setup_database:9:in `run'
        from script/setup_database:297
tikal26@tikal26-desktop:/usr/lib/ruby/gems/1.8/gems/radiant-0.5.2$ ruby
script/server webrick -e production
=> Booting WEBrick...
/usr/lib/ruby/1.8/fileutils.rb:243:in `mkdir': Permission denied - tmp
(Errno::EACCES)
        from /usr/lib/ruby/1.8/fileutils.rb:243:in `fu_mkdir'
        from /usr/lib/ruby/1.8/fileutils.rb:217:in `mkdir_p'
        from /usr/lib/ruby/1.8/fileutils.rb:215:in `mkdir_p'
        from /usr/lib/ruby/1.8/fileutils.rb:201:in `mkdir_p'
        from 
/usr/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/commands/server.rb:29
        from 
/usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:27:in
`require'

from 
/usr/lib/ruby/gems/1.8/gems/activesupport-1.3.1/lib/active_support/dependencies.rb:147:in
`require'
        from script/server:3

Ruben D. Orduz wrote:
> Sorry to hear you're having such a hard time getting Radiant to work.
> You can write me directly if you want, so we don't bother the rest.

If you continue off list, please post the solution here. It's helpful
when people are searching through the archives for the same problem in
the future.

--
John Long
http://wiseheartdesign.com

Ruben,
Gracias, I did so many thing that it strated to work it was probably a
cross-OS problem like you said, but now ig et the following error
Run `setup_database --help` for information on additional options.

Loading development environment...Rails Error: Unable to access log 
file.
Please ensure that script/../config/../log/development.log exists and is
chmod 0666. The log level has been raised to WARN and the output 
directed to
STDERR until the problem is fixed.
OK

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

Creating tables...
-- drop_table("config")
-- create_table("config", {:force=>true})
FAILED
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/mysql_adapter.rb:330:in
`real_connect': Can't connect to local MySQL server through
socket '/var/run/mysqld/mysqld.sock' (13) (Mysql::Error)

from 
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/mysql_adapter.rb:330:in
`connect'

from 
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/mysql_adapter.rb:87:in
`initialize'

from 
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/mysql_adapter.rb:36:in
`mysql_connection'

from 
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:251:in
`connection_without_query_cache='

from 
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/query_cache.rb:54:in
`connection='

from 
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:220:in
`retrieve_connection'

from 
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:78:in
`connection'

from 
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/migration.rb:273:in
`method_missing'
         ... 8 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

I am somehow confuces since I was able to installed it before in 
bluehost and
I think that right now I might just take a little break since I think 
that I
am just not thinking straight . I know I am probably being a pain, but 
if
anyone could provide me with some help I would appreciated it.

Sara Vasquez

Here's what my database.yml looks like for my Radiant install on
Unbuntu:

production:
   adapter: mysql
   database: cr_radiant_live
   username: user
   password: password

I'm running on SliceHost.  My RAILS_ENV is production (obviously).

Cheers,
Chris

John, will do. I'm almost certain it has to do with formating
(spacing/tabs) of her DB config files.

Sara,

Sorry to hear you're having such a hard time getting Radiant to work.
You can write me directly if you want, so we don't bother the rest. I
need to know the following:

* Are you sure mysqld is running?
* Are you developing on windows?
* Can you copy and paste both your db yml file and the db setup script?

no host specified? Or did you purposely ommited it?

Sara,

Other people have had problem with yml files since they ARE tab- and
space-sensitive. Make sure you're editing them in a text-safe
environment and that there's no cross-OS problems. Also, you can try
doing a SVN revert on that yml file and make sure you don't mess with
the spacing or tabs.

I believe I took the sample file and whacked the socket entry.

Ruben D. Orduz wrote:
> Sara,
> 
> Other people have had problem with yml files since they ARE tab- and
> space-sensitive. Make sure you're editing them in a text-safe
> environment and that there's no cross-OS problems. Also, you can try
> doing a SVN revert on that yml file and make sure you don't mess with
> the spacing or tabs.

If others run into this problem, I found a problem in mine that is 
related to this solution from Ruben.  When I put my actual password in 
the .yml file, I must have misfired when I went for the space key before 
the password, so I had something like this:

production:
   adapter: mysql
   database: cr_radiant_live
   username: user
   password:notmyrealpassword


just adding the space between password:  and  notmyrealpassword was all 
it took to get things rolling.

jp

I knwo this is an old post but since I found it when i searched for my 
problem in google I thought i would tell you what I found so if anyone 
is looking for a solution to this they would find it as well. Its the 
only way I can give back right now since I am still new to rails.

In my mongrel_cluster file I added an option:

set :mongrel_clean, true

 as per the manual I was working through. My app wouldnt start so I 
looked through the file and checked each item and after fiddling I found 
the corect way to write this was:

set: mongrel_clean, true

You will notice the spaces where in the wrong place. The space was 
before the : and not after and thus this option was not working 
correctly. So, if you get the error:

/usr/lib/ruby/1.8/yaml.rb:133:in `load': syntax error on line 9, col -1: 
`' (ArgumentError)
or something similar, where it states syntax error on line 9 is the line 
that has the problem in my config/mongrel_cluster.yml file. in my case 
line 9 had the above set: item on it and was needed to be changed.

Good luck in figuring things out.

Gigg

Grant Gray wrote:
> I knwo this is an old post but since I found it when i searched for my 
> problem in google I thought i would tell you what I found so if anyone 
> is looking for a solution to this they would find it as well. Its the 
> only way I can give back right now since I am still new to rails.
> 
> In my mongrel_cluster file I added an option:
> 
> set :mongrel_clean, true
> 
>  as per the manual I was working through. My app wouldnt start so I 
> looked through the file and checked each item and after fiddling I found 
> the corect way to write this was:
> 
> set: mongrel_clean, true
> 
> You will notice the spaces where in the wrong place. The space was 
> before the : and not after and thus this option was not working 
> correctly. So, if you get the error:
> 
> /usr/lib/ruby/1.8/yaml.rb:133:in `load': syntax error on line 9, col -1: 
> `' (ArgumentError)
> or something similar, where it states syntax error on line 9 is the line 
> that has the problem in my config/mongrel_cluster.yml file. in my case 
> line 9 had the above set: item on it and was needed to be changed.
> 
> Good luck in figuring things out.
> 
> Gigg


For me, I got this error when I was manually writing out my YAML file.
I had the following line when it gave the "col -1" error.

blahblah: [8] Some String

Yaml didn't like it, so I had to manually encode the square brackets 
(and then decode it when reading it into my app)

blahblah: <left_bracket/>8<right_bracket/> Game Title