mac osx server and mysql
grimmwerks
grimm at grimmwerks.com
Fri Mar 30 14:06:02 PDT 2007
On Mar 30, 2007, at 4:33 PM, Ryan Schmidt wrote:
>
> Wouldn't it be much better just to assign the ownership to the
> mysql user?
>
> sudo chown mysql:mysql /opt/local/var/db/mysql5
It's already set:
drwxr-xr-x 13 mysql mysql 442 Mar 29 21:05 mysql5
>
> In fact I was under the impression that this was done automatically
> for you when you initially create the database using the command
> printed at the end of the mysql5 port installation. Did this not
> happen for you?
It did create the inital db; I also created a user (retrospectiva)
and 2 databases (couldn't do it through mysql manager gui, I had to
do it in the command line as root). I assigned the retrospectiva
permissions to edit retrospectiva and retrospectiva_dev dbs. I edited
the retrospectiva conf.yml file to this info, so next....
>
> Are you seeing error messages? If so, what are they?
>
When I try to run rake:
subversion:/opt/apache2/htdocs/retrospectiva admin$ rake
RAILS_ENV=production db:retro:load --trace
(in /opt/apache2/htdocs/retrospectiva)
** Invoke db:retro:load (first_time)
** Invoke environment (first_time)
** Execute environment
Rails Error: Unable to access log file. Please ensure that /opt/
apache2/htdocs/retrospectiva/config/../log/production.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.
** Execute db:retro:load
** Invoke db:retro:load_schema (first_time)
** Invoke environment
** Execute db:retro:load_schema
===== Load the database schema
** Invoke db:schema:load (first_time)
** Invoke environment
** Execute db:schema:load
-- create_table("attachments", {:force=>true})
rake aborted!
Access denied for user 'retrospectiva'@'localhost' (using password: YES)
/opt/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/
active_record/connection_adapters/mysql_adapter.rb:389:in `real_connect'
/opt/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/
active_record/connection_adapters/mysql_adapter.rb:389:in `connect'
/opt/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/
active_record/connection_adapters/mysql_adapter.rb:152:in `initialize'
/opt/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/
active_record/connection_adapters/mysql_adapter.rb:82:in `new'
/opt/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/
active_record/connection_adapters/mysql_adapter.rb:82:in
`mysql_connection'
/opt/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/
active_record/connection_adapters/abstract/
connection_specification.rb:262:in `send'
/opt/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/
active_record/connection_adapters/abstract/
connection_specification.rb:262:in `connection_without_query_cache='
/opt/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/
active_record/query_cache.rb:54:in `connection='
/opt/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/
active_record/connection_adapters/abstract/
connection_specification.rb:230:in `retrieve_connection'
/opt/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/
active_record/connection_adapters/abstract/
connection_specification.rb:78:in `connection'
/opt/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/
active_record/migration.rb:275:in `method_missing'
/opt/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/
active_record/migration.rb:259:in `say_with_time'
/opt/local/lib/ruby/1.8/benchmark.rb:293:in `measure'
/opt/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/
active_record/migration.rb:259:in `say_with_time'
/opt/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/
active_record/migration.rb:273:in `method_missing'
./db/schema.rb:7
/opt/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/
active_record/schema.rb:43:in `instance_eval'
/opt/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/
active_record/schema.rb:43:in `define'
./db/schema.rb:5
/opt/local/lib/ruby/gems/1.8/gems/activesupport-1.4.2/lib/
active_support/dependencies.rb:488:in `load'
/opt/local/lib/ruby/gems/1.8/gems/activesupport-1.4.2/lib/
active_support/dependencies.rb:488:in `load'
/opt/local/lib/ruby/gems/1.8/gems/activesupport-1.4.2/lib/
active_support/dependencies.rb:342:in `new_constants_in'
/opt/local/lib/ruby/gems/1.8/gems/activesupport-1.4.2/lib/
active_support/dependencies.rb:488:in `load'
/opt/local/lib/ruby/gems/1.8/gems/rails-1.2.3/lib/tasks/
databases.rake:31
/opt/local/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake.rb:399:in `call'
/opt/local/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake.rb:399:in
`execute'
/opt/local/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake.rb:399:in `each'
/opt/local/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake.rb:399:in
`execute'
/opt/local/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake.rb:369:in `invoke'
/opt/local/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake.rb:362:in
`synchronize'
/opt/local/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake.rb:362:in `invoke'
/opt/apache2/htdocs/retrospectiva/config/../lib/tasks/database.rake:12
/opt/local/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake.rb:399:in `call'
/opt/local/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake.rb:399:in
`execute'
/opt/local/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake.rb:399:in `each'
/opt/local/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake.rb:399:in
`execute'
/opt/local/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake.rb:369:in `invoke'
/opt/local/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake.rb:362:in
`synchronize'
/opt/local/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake.rb:362:in `invoke'
/opt/apache2/htdocs/retrospectiva/config/../lib/tasks/database.rake:5
/opt/local/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake.rb:399:in `call'
/opt/local/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake.rb:399:in
`execute'
/opt/local/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake.rb:399:in `each'
/opt/local/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake.rb:399:in
`execute'
/opt/local/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake.rb:369:in `invoke'
/opt/local/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake.rb:362:in
`synchronize'
/opt/local/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake.rb:362:in `invoke'
/opt/local/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake.rb:1935:in `run'
/opt/local/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake.rb:1935:in `each'
/opt/local/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake.rb:1935:in `run'
/opt/local/lib/ruby/gems/1.8/gems/rake-0.7.2/bin/rake:7
/opt/local/bin/rake:16:in `load'
/opt/local/bin/rake:16
More information about the macports-users
mailing list