[Puppet Users] mysql access denied on dashboard puppet

2013-06-21 Thread DJames
i am at a lost, i setup the db schema , database.yml and etc passwords 
are correct.

im getting the below error, im trying to get my dashboard to work .help 
any? i also chmod the database.yml file to 660

# mysql -u dashboard -p dashboard_production
Enter password:
ERROR 1045 (28000): Access denied for user 'dashboard'@'localhost' (using 
password: YES)

-- 
You received this message because you are subscribed to the Google Groups 
Puppet Users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to puppet-users+unsubscr...@googlegroups.com.
To post to this group, send email to puppet-users@googlegroups.com.
Visit this group at http://groups.google.com/group/puppet-users.
For more options, visit https://groups.google.com/groups/opt_out.




Re: [Puppet Users] mysql access denied on dashboard puppet

2013-06-21 Thread Jeffrey Watts
If you followed the instructions on the website it calls for you to create
a database named dashboard.  However, the example database.yml that comes
with the software calls for the database to be called
dashboard_production.  This bit me in the ass, and I suspect that it
might have bitten you as well.  Just create dashboard_production and you
should be okay.

J.


On Fri, Jun 21, 2013 at 12:54 PM, DJames dominicrja...@gmail.com wrote:

 i am at a lost, i setup the db schema , database.yml and etc passwords
 are correct.

 im getting the below error, im trying to get my dashboard to work
 .help any? i also chmod the database.yml file to 660

 # mysql -u dashboard -p dashboard_production
 Enter password:
 ERROR 1045 (28000): Access denied for user 'dashboard'@'localhost' (using
 password: YES)

  --
 You received this message because you are subscribed to the Google Groups
 Puppet Users group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to puppet-users+unsubscr...@googlegroups.com.
 To post to this group, send email to puppet-users@googlegroups.com.
 Visit this group at http://groups.google.com/group/puppet-users.
 For more options, visit https://groups.google.com/groups/opt_out.




-- 
You received this message because you are subscribed to the Google Groups 
Puppet Users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to puppet-users+unsubscr...@googlegroups.com.
To post to this group, send email to puppet-users@googlegroups.com.
Visit this group at http://groups.google.com/group/puppet-users.
For more options, visit https://groups.google.com/groups/opt_out.




Re: [Puppet Users] mysql access denied on dashboard puppet

2013-06-21 Thread DJames
still no luck, i changed the database to database_production, also even 
went into mysql to try to reset please see below..

# mysqld_safe --skip-grant-tables 

[1] 27589

[1]+  Exit 1  mysqld_safe --skip-grant-tables

# mysql -u root -p
Enter password:

mysql SELECT * FROM mysql.user;

localhost | dashboard | ** 
 | N   | N   | N   | 


---+---+
7 rows in set (0.00 sec)

mysql UPDATE mysql.user SET Password=PASSWORD('[ItPas83LogUSun]') WHERE 
User='[dashboard]';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0


]# service mysql stop

SUCCESS!
[1]+  Donemysqld_safe --skip-grant-tables

# service mysql start
Starting MySQL.. SUCCESS!


 mysql -u dashboard -p
Enter password:
ERROR 1045 (28000): Access denied for user 'dashboard'@'localhost' (using 
password: YES)






On Friday, June 21, 2013 2:04:49 PM UTC-4, Jeffrey Watts wrote:

 If you followed the instructions on the website it calls for you to create 
 a database named dashboard.  However, the example database.yml that comes 
 with the software calls for the database to be called 
 dashboard_production.  This bit me in the ass, and I suspect that it 
 might have bitten you as well.  Just create dashboard_production and you 
 should be okay.

 J.


 On Fri, Jun 21, 2013 at 12:54 PM, DJames domini...@gmail.comjavascript:
  wrote:

 i am at a lost, i setup the db schema , database.yml and etc 
 passwords are correct.

 im getting the below error, im trying to get my dashboard to work 
 .help any? i also chmod the database.yml file to 660

 # mysql -u dashboard -p dashboard_production
 Enter password:
 ERROR 1045 (28000): Access denied for user 'dashboard'@'localhost' (using 
 password: YES)

  -- 
 You received this message because you are subscribed to the Google Groups 
 Puppet Users group.
 To unsubscribe from this group and stop receiving emails from it, send an 
 email to puppet-users...@googlegroups.com javascript:.
 To post to this group, send email to puppet...@googlegroups.comjavascript:
 .
 Visit this group at http://groups.google.com/group/puppet-users.
 For more options, visit https://groups.google.com/groups/opt_out.
  
  




-- 
You received this message because you are subscribed to the Google Groups 
Puppet Users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to puppet-users+unsubscr...@googlegroups.com.
To post to this group, send email to puppet-users@googlegroups.com.
Visit this group at http://groups.google.com/group/puppet-users.
For more options, visit https://groups.google.com/groups/opt_out.