Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)

[Brandon Casci]

Matt....

I'm sorry I feel like I'm wracking on frequent flier miles in the most annoying way. You should come out to lunch...I'll buy, or Brian will buy ;)

On my latest instance, I now get this when trying to stop, or restart mysql since the initial deployment. It happens at the root console too.

   [web01.loudcaster.com] executing command
 ** [out :: web01.loudcaster.com] * Stopping MySQL database server mysqld
 ** [out :: web01.loudcaster.com] ...fail!
 ** [out :: web01.loudcaster.com] * Starting MySQL database server mysqld
 ** [out :: web01.loudcaster.com] ...done.
*** [err :: web01.loudcaster.com] /usr/bin/mysqladmin: connect to server at 'localhost' failed
*** [err :: web01.loudcaster.com] error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'


--
=========================================
I'm having a bout of spondylosis, so I can't hammer away at the keyboard too long. Please don't mistake short e-mails for rude e-mails..
=========================================

[Matthew Conway]

No worries.  This usually happens if you restore mysql from a full dump.  Debian/ubuntu create a random mysql admin password on install, which they store in /etc/my/debian.cnf.  This is also a problem in replication with rubber as I replicate all dbs, including "mysql" which contains authentication details.  For replication, one can copy debian.cnf from master to slave (I need to have a better solution here for rubber).  For dump, you need to run a command like the following in the mysql console:

GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;

flush privileges;

Replace PASSWORD with the value stored in /etc/my/debian.cnf

--

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

[Brandon Casci]

Hi Matt, I actually had /mnt/mysql mounted to an EBS volume and just at them mounted to the new instance...but I understand the problem and the end result is the same. 

Sent from my iPhone

[Brandon Casci]

Matt

Good to hang last night....I got bit by this again today. Just a thought to avoid this in the future, let me know if this sounds reasonable....

- generate /etc/my/debian.cnf with a template in config/rubber/roles/db
- always restart mysql after setup_volumes (mysql won't see the ebs volumes if it's started before they are attached)
- always kick off a "grant all...." sql statement after setup_volumes

[Jonathan Spooner]

Hi,

I just started using rubber but I keep running into this issue. ( Access denied for user ''@'web01.pushwood.com' to database 'pushwood_production')  Has there been any progress or is there anything I can patch?  Using the older version of Ubuntu didn't work for me but adding the grants by had did.  I'd like to get the mysql problem fixed so I don't have to keep doing it by hand.  I've been testing rubber for 2 days and I haven't been able to get a basic rails app working with nginx/mysql yet.

Thanks,

Jonathan

To unsubscribe from this group, send email to rubber-ec2+unsubscribe@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/rubber-ec2?hl=en.

--

You received this message because you are subscribed to the Google Groups "rubber" group.
To post to this group, send email to rubbe...@googlegroups.com.

To unsubscribe from this group, send email to rubber-ec2+unsubscribe@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/rubber-ec2?hl=en.

[Jonathan Spooner]

Yeah I was able to fix it by editing rubber-mysql.rb.  Specifically the the rubber:mysql:bootstrap task.  I noticed another thread this week on the same topic so hopefully the fix makes it into master.  Thanks!

On Friday, June 22, 2012 2:41:23 AM UTC-7, bertly_the_coder wrote:

Hi Jonathan,

Any luck with this problem? :-)

[Kevin Menard]

Hi Jonathan,

I'm not seeing anything in the issue tracker. Could you please open
an issue and recap what the problem is. A pull request would be even
better :-)

Thanks,
Kevin

>>>>> rubber-ec2+...@googlegroups.com.

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

>>>>> rubber-ec2+...@googlegroups.com.

>>>>> For more options, visit this group at
>>>>> http://groups.google.com/group/rubber-ec2?hl=en.
>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> =========================================
>>>> I'm having a bout of spondylosis, so I can't hammer away at the keyboard
>>>> too long. Please don't mistake short e-mails for rude e-mails..
>>>> =========================================
>

> --
> You received this message because you are subscribed to the Google Groups
> "rubber" group.

> To view this discussion on the web visit
> https://groups.google.com/d/msg/rubber-ec2/-/9IGHcJwt33AJ.

>
> To post to this group, send email to rubbe...@googlegroups.com.
> To unsubscribe from this group, send email to

> rubber-ec2+...@googlegroups.com.