[Radiant] Database setup problem

[Charles McKnight]

Hi All,

I'm new to using Radiant although I've been doing some things in Rails
for a bit. When I set up a test project to learn how to use Radiant, I
tried to use the MySQL database (I've been using it for a while as well,
btw) and got the following errors (after following the installation
instructions in the handbook):

chuck at serenity:~/projects/pheonic/trunk/src/pheonic>
script/setup_database development
Run `setup_database --help` for information on additional options.

Loading development environment...OK

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

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 '/tmp/mysql.sock' (111) (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 ran a script/about and show the following:

chuck at serenity:~/projects/pheonic/trunk/src/pheonic> script/about
About your application's environment
Ruby version                 1.8.4 (i586-linux)
RubyGems version             0.9.0
Rails version                1.1.6
Active Record version        1.14.4
Action Pack version          1.12.5
Action Web Service version   1.1.6
Action Mailer version        1.2.5
Active Support version       1.3.1
Application
root             /home/chuck/projects/pheonic/trunk/src/pheonic
Environment                  development
Database adapter             mysql

and I'm using the following version of MySQL:

mysql  Ver 14.12 Distrib 5.0.18, for suse-linux (i686) using readline
5.1

I copied the database.mysql.yml file into database.yml and set the user
name and password to the same values that I used in the grant privileges
SQL. This is sort of a head scratcher for me, but I'm digging through
code trying to figure out what I've misconfigured.

Any clues appreciated!


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.radiantcms.org/pipermail/radiant/attachments/20061120/8f82b23e/attachment.html