thr3ads.net - Puppet users - [Puppet Users] puppet dashboard with mysql user not root [Apr 2010]

If this information is useful, please help other people find it:
Share via:

Asif Iqbal

2010-Apr-07 17:31 UTC

[Puppet Users] puppet dashboard with mysql user not root

Hi All

I am trying to install puppet dashboard and it is failing like this

root@sys-ubuntu { ~/puppet-dashboard }$ rake install
(in /home/iqbala/puppet-dashboard)
Couldn''t create database for
{"encoding"=>"utf8",
"username"=>"root",
"adapter"=>"mysql",
"database"=>"dashboard_development"}, charset:
utf8, collation: utf8_unicode_ci (if you set the charset manually,
make sure you have a matching collation)
-- create_table("assignments", {:force=>true})
rake aborted!
Access denied for user ''root''@''localhost''
(using password: NO)

(See full trace by running task with --trace)

I like to grant a non root user to create a database with a password .
What file to change on puppet dashboard to achieve that?


Here is the rake install with --trace

root@sys-ubuntu { ~/puppet-dashboard }$ rake install --trace
(in /home/iqbala/puppet-dashboard)
** Invoke install (first_time)
** Invoke copy_config (first_time)
** Invoke config/database.yml (first_time, not_needed)
** Invoke config/database.yml.example (first_time, not_needed)
** Execute copy_config
** Invoke db:create (first_time)
** Invoke db:load_config (first_time)
** Invoke rails_env (first_time)
** Execute rails_env
** Execute db:load_config
** Execute db:create
Couldn''t create database for
{"encoding"=>"utf8",
"username"=>"root",
"adapter"=>"mysql",
"database"=>"dashboard_development"}, charset:
utf8, collation: utf8_unicode_ci (if you set the charset manually,
make sure you have a matching collation)
** Invoke db:schema:load (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:schema:load
-- create_table("assignments", {:force=>true})
rake aborted!
Access denied for user ''root''@''localhost''
(using password: NO)
[..]

-- 
Asif Iqbal
PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?

-- 
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.

Asif Iqbal

2010-Apr-07 17:46 UTC

head link

[Puppet Users] Re: puppet dashboard with mysql user not root

On Wed, Apr 7, 2010 at 1:31 PM, Asif Iqbal <vadud3@gmail.com>
wrote:> Hi All
>
> I am trying to install puppet dashboard and it is failing like this
>
> root@sys-ubuntu { ~/puppet-dashboard }$ rake install
> (in /home/iqbala/puppet-dashboard)
> Couldn''t create database for
{"encoding"=>"utf8",
"username"=>"root",
> "adapter"=>"mysql",
"database"=>"dashboard_development"}, charset:
> utf8, collation: utf8_unicode_ci (if you set the charset manually,
> make sure you have a matching collation)
> -- create_table("assignments", {:force=>true})
> rake aborted!
> Access denied for user
''root''@''localhost'' (using password: NO)
>
> (See full trace by running task with --trace)
>
> I like to grant a non root user to create a database with a password .
> What file to change on puppet dashboard to achieve that?

found it. config/database.yml

-- 
Asif Iqbal
PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?

-- 
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.

Gustavo Soares

2010-Apr-07 19:44 UTC

head link

Re: [Puppet Users] Re: puppet dashboard with mysql user not root

I don''t know which OS you are using, but maybe

you should take a look on this post
http://zcentric.com/2010/03/11/install-puppet-dashboard-on-redhatcentos-5/

Cheers,
Gus

On Wed, Apr 7, 2010 at 2:46 PM, Asif Iqbal <vadud3@gmail.com> wrote:
> On Wed, Apr 7, 2010 at 1:31 PM, Asif Iqbal <vadud3@gmail.com> wrote:
> > Hi All
> >
> > I am trying to install puppet dashboard and it is failing like this
> >
> > root@sys-ubuntu { ~/puppet-dashboard }$ rake install
> > (in /home/iqbala/puppet-dashboard)
> > Couldn''t create database for
{"encoding"=>"utf8",
"username"=>"root",
> > "adapter"=>"mysql",
"database"=>"dashboard_development"}, charset:
> > utf8, collation: utf8_unicode_ci (if you set the charset manually,
> > make sure you have a matching collation)
> > -- create_table("assignments", {:force=>true})
> > rake aborted!
> > Access denied for user
''root''@''localhost'' (using password: NO)
> >
> > (See full trace by running task with --trace)
> >
> > I like to grant a non root user to create a database with a password .
> > What file to change on puppet dashboard to achieve that?
>
>
> found it. config/database.yml
>
> --
> Asif Iqbal
> PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu
> A: Because it messes up the order in which people normally read text.
> Q: Why is top-posting such a bad thing?
>
> --
> 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<puppet-users%2Bunsubscribe@googlegroups.com>
> .
> For more options, visit this group at
> http://groups.google.com/group/puppet-users?hl=en.
>
>
-- 
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.

Asif Iqbal

2010-Apr-07 22:09 UTC

head link

Re: [Puppet Users] Re: puppet dashboard with mysql user not root

On Wed, Apr 7, 2010 at 3:44 PM, Gustavo Soares <gustavosoares@gmail.com>
wrote:> I don''t know which OS you are using, but maybe
> you should take a look on this
>
post http://zcentric.com/2010/03/11/install-puppet-dashboard-on-redhatcentos-5/
>
> Cheers,
> Gus
> On Wed, Apr 7, 2010 at 2:46 PM, Asif Iqbal <vadud3@gmail.com> wrote:
>>
>> On Wed, Apr 7, 2010 at 1:31 PM, Asif Iqbal <vadud3@gmail.com>
wrote:
>> > Hi All
>> >
>> > I am trying to install puppet dashboard and it is failing like
this
>> >
>> > root@sys-ubuntu { ~/puppet-dashboard }$ rake install
>> > (in /home/iqbala/puppet-dashboard)
>> > Couldn''t create database for
{"encoding"=>"utf8",
"username"=>"root",
>> > "adapter"=>"mysql",
"database"=>"dashboard_development"}, charset:
>> > utf8, collation: utf8_unicode_ci (if you set the charset manually,
>> > make sure you have a matching collation)
>> > -- create_table("assignments", {:force=>true})
>> > rake aborted!
>> > Access denied for user
''root''@''localhost'' (using password: NO)
>> >
>> > (See full trace by running task with --trace)
>> >
>> > I like to grant a non root user to create a database with a
password .
>> > What file to change on puppet dashboard to achieve that?
>>
>>
>> found it. config/database.yml
Yes I found it there. Thanks for your help
>>
>> --
>> Asif Iqbal
>> PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu
>> A: Because it messes up the order in which people normally read text.
>> Q: Why is top-posting such a bad thing?
>>
>> --
>> 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.
>>
>
> --
> 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.
>


-- 
Asif Iqbal
PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?

-- 
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.

Puppet users - Apr 2010 - puppet dashboard with mysql user not root

[Puppet Users] puppet dashboard with mysql user not root

[Puppet Users] Re: puppet dashboard with mysql user not root

Re: [Puppet Users] Re: puppet dashboard with mysql user not root

Re: [Puppet Users] Re: puppet dashboard with mysql user not root