Thanks Ky and Jamis,
Still no 100% success. This however is something that I would like to
work on some more. I was just having a look and the interactive 'cap
shell' - very cool indeed. I could imaging interacting with MySql
through the cap shell.
So thanks again, I will post any real success I have!
meSleepy.
On Sep 16, 12:59 am, "Jamis Buck" <[EMAIL PROTECTED]> wrote:
> The reason the password is echoing originally is because Capistrano
> isn't prompting you--it's just echoing the text from the server, which
> happens to be a prompt. If you want to be able to enter the password
> when the server prompts, you need to be willing to do a bit more work:
>
> run "mysql -u root blah blah blah" do |ch, stream, data|
> if data =~ /Enter password:/
> ch.send_data(root_db_password)
> end
> end
>
> You're basically setting up an expect-like negotiation, checking the
> output from the server for what looks like a prompt, and then sending
> the password in response when you see it.
>
> I'd definitely be interested in a patch that simplified the
> expect-like interactions. I've not needed it much myself, but I know
> it's been a frequent pain-point on this list.
>
> - Jamis
>
> On 9/14/07, meSleepy <[EMAIL PROTECTED]> wrote:
>
>
>
> > Thanks KY,
>
> > This gives me some good ideas. I will post the results. I am going to
> > try this later, at the moment I am taking Monit for a spin - so there
> > goes a few hours at least. Keep you posted.
>
> > - meSleepy
>
> > On Sep 15, 2:31 pm, ky <[EMAIL PROTECTED]> wrote:
> > > if you include this:
>
> > > set(:root_db_password) do
> > > Capistrano::CLI.password_prompt "Root DB Password?: "
> > > end
>
> > > then your task would be:
> > > task :before_migrate, :roles => :db do
> > > run "mysql -u root -p #{root_db_password}"
> > > end
>
> > > ...which is actually a 1/2-assed solution b/c then your command will
> > > immediately echo your carefully hidden password. Lmk if you figure
> > > out how to not echo the command.
>
> > > btw, you may've already figured this out, but I find it handy to use
> > > here strings to get commands to mysql -- like:
> > > run "mysql -u root -p #{root_db_password} <<< \"create database
> > > my_prod_db character set utf8;\""
--~--~---------~--~----~------------~-------~--~----~
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/capistrano
-~----------~----~----~----~------~----~------~--~---
