[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

passing password to mysql

Stephan Wehner

4/26/2009 4:46:00 AM

I would like to use Ruby to open a mysql prompt for the user. The
password is read from a file, and should be passed to mysel. However, I
don't want to have the password appear in the list of processes (don't
use the mysql -p option)

A comment at the end of

http://dev.mysql.com/doc/refman/5.0/en/password-security...

shows how to accomplish that within bash scripts, which is quite nice.
It works like the string in this code:

exec <<-END
{ printf
'[client]\ndatabase=%s\nhost=%s\nsocket=%s\nuser=%s\npassword=%s'
'db-dev' 'localhost' '/var/run/mysqld/mysqld.sock' 'db-user' 'db-passwd'
|
3<&0 <&4 4<&- /usr/local/mysql/bin/mysql --defaults-file=/dev/fd/3
} 4<&0
END

As you can see some clever use of file-descriptors. The exec-call works
in Ruby, and the mysql prompt is opened, but running "ps" will reveal
the password (not that surprising).

Is there a way to do this in Ruby?

Stephan
--
Posted via http://www.ruby-....
4 Answers

Phlip

4/26/2009 5:24:00 AM

0

> Is there a way to do this in Ruby?

Grab ActiveRecord (part of Rails, ob-vossly), and write its database.yml file.
Oh, and actually use it to rip all your tables. It's just too easy to use!

Stephan Wehner

4/26/2009 5:34:00 AM

0

Phlip wrote:
>> Is there a way to do this in Ruby?
>
> Grab ActiveRecord (part of Rails, ob-vossly), and write its database.yml
> file.
> Oh, and actually use it to rip all your tables. It's just too easy to
> use!

Ok thanks; however I find the mysql prompt sometimes easier and faster.
Not always but often enough.

Stephan
--
Posted via http://www.ruby-....

Phlip

4/26/2009 5:56:00 AM

0

Stephan Wehner wrote:
> Phlip wrote:
>>> Is there a way to do this in Ruby?
>> Grab ActiveRecord (part of Rails, ob-vossly), and write its database.yml
>> file.
>> Oh, and actually use it to rip all your tables. It's just too easy to
>> use!
>
> Ok thanks; however I find the mysql prompt sometimes easier and faster.
> Not always but often enough.

If you mean raw SQL statements, just .execute() them. Otherwise, how does the
MySQL connection driver work? It has to solve your actual problem on the inside,
right?

Stephan Wehner

4/26/2009 1:53:00 PM

0

Phlip wrote:
> Stephan Wehner wrote:
>> Phlip wrote:
>>>> Is there a way to do this in Ruby?
>>> Grab ActiveRecord (part of Rails, ob-vossly), and write its database.yml
>>> file.
>>> Oh, and actually use it to rip all your tables. It's just too easy to
>>> use!
>>
>> Ok thanks; however I find the mysql prompt sometimes easier and faster.
>> Not always but often enough.
>
> If you mean raw SQL statements, just .execute() them. Otherwise, how
> does the
> MySQL connection driver work? It has to solve your actual problem on the
> inside,
> right?

Yes, I am aware of using connection.execute(..), select_all(...), etc.
However, I would like to be able to use the mysql prompt.


So is this a case where a bash script can do more than a Ruby script?


Stephan
--
Posted via http://www.ruby-....