Puppet users - Jun 2011 - Rake failing to create puppet dashboard database on RHEL6

Hi folks,

I''m trying to install puppet dashboard 1.1.1 on RHEL6 (following some
instructions in the excellent Pro Puppet book) but the rake command is
failing to create the database like so:

# rake RAILS_ENV=production db:create
(in /usr/share/puppet-dashboard)
Couldn''t create database for
{"encoding"=>"utf8",
"adapter"=>"mysql",
"username"=>"dashboard",
"database"=>"dashboard",
"password"=>"mypassword"}, charset: utf8, collation:
utf8_unicode_ci
(if you set the charset manually, make sure you have a matching
collation)

In the database.yml I have:

production:
  database: dashboard
  username: dashboard
  password: mypassword
  encoding: utf8
  adapter: mysql

Any ideas?  Thanks.

-- 
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.
To post to this group, send email to puppet-users@googlegroups.com.
To unsubscribe from this group, send email to
puppet-users+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/puppet-users?hl=en.

On Mon, 20 Jun 2011 09:21:04 -0700, Pheran wrote:
> 
> Hi folks,
> 
> I''m trying to install puppet dashboard 1.1.1 on RHEL6 (following
some
> instructions in the excellent Pro Puppet book) but the rake command is
> failing to create the database like so:
> 
> # rake RAILS_ENV=production db:create
> (in /usr/share/puppet-dashboard)
> Couldn''t create database for
{"encoding"=>"utf8",
"adapter"=>"mysql",
> "username"=>"dashboard",
"database"=>"dashboard",
> "password"=>"mypassword"}, charset: utf8, collation:
utf8_unicode_ci
> (if you set the charset manually, make sure you have a matching
> collation)
> 
> In the database.yml I have:
> 
> production:
>   database: dashboard
>   username: dashboard
>   password: mypassword
>   encoding: utf8
>   adapter: mysql
> 
> Any ideas?  Thanks.
> 
It looks like the dashboard MySQL user doesn''t have CREATE DATABASE
permissions.

This is a pretty reasonable restriction to have on the user, so you may
need to create the database manually using a more privileged user, and
skip the db:create step.

-- 
Jacob Helwig

Thanks Jacob, the book either forgot or glossed over creating the
database user with those permissions, but they do show how to manually
create the database using mysql, so I''ll give that a shot.

On Jun 20, 12:28 pm, Jacob Helwig <ja...@puppetlabs.com>
wrote:
> On Mon, 20 Jun 2011 09:21:04 -0700, Pheran wrote:
>
> > Hi folks,
>
> > I''m trying to install puppet dashboard 1.1.1 on RHEL6
(following some
> > instructions in the excellent Pro Puppet book) but the rake command is
> > failing to create the database like so:
>
> > # rake RAILS_ENV=production db:create
> > (in /usr/share/puppet-dashboard)
> > Couldn''t create database for
{"encoding"=>"utf8",
"adapter"=>"mysql",
> > "username"=>"dashboard",
"database"=>"dashboard",
> > "password"=>"mypassword"}, charset: utf8,
collation: utf8_unicode_ci
> > (if you set the charset manually, make sure you have a matching
> > collation)
>
> > In the database.yml I have:
>
> > production:
> >   database: dashboard
> >   username: dashboard
> >   password: mypassword
> >   encoding: utf8
> >   adapter: mysql
>
> > Any ideas?  Thanks.
>
> It looks like the dashboard MySQL user doesn''t have CREATE
DATABASE
> permissions.
>
> This is a pretty reasonable restriction to have on the user, so you may
> need to create the database manually using a more privileged user, and
> skip the db:create step.
>
> --
> Jacob Helwig
>
>  signature.asc
> < 1KViewDownload
-- 
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.
To post to this group, send email to puppet-users@googlegroups.com.
To unsubscribe from this group, send email to
puppet-users+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/puppet-users?hl=en.