[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

mysql error handle

Barabule Muci

1/17/2007 8:31:00 AM

Hello,
I am making an connection with mysql
Mysql.real_connect("127.0.0.1","root","","f_juso","3306")

The problem is when the user and pass is correct it works very well but
when the user and pass is wrong it display the debugger and display the
message:
Mysql::Error in ComenziController#login
Access denied for user 'roots'@'localhost' (using password: NO)
and all that ruby debugger stuff.

I wan't to get the error in ruby and to display only my message like
"Invalid password."
It's help me, because i have made an login script and i wan't to check
the user and password by connecting on mysql with that user and
password.
Thanks

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

4 Answers

Alex Young

1/17/2007 8:45:00 AM

0

Barabule Muci wrote:
> Hello,
> I am making an connection with mysql
> Mysql.real_connect("127.0.0.1","root","","f_juso","3306")
>
> The problem is when the user and pass is correct it works very well but
> when the user and pass is wrong it display the debugger and display the
> message:
> Mysql::Error in ComenziController#login
> Access denied for user 'roots'@'localhost' (using password: NO)
> and all that ruby debugger stuff.
>
> I wan't to get the error in ruby and to display only my message like
> "Invalid password."
> It's help me, because i have made an login script and i wan't to check
> the user and password by connecting on mysql with that user and
> password.
> Thanks
>
Mysql::Error is an exception, so you should just be able to rescue it
and move on:

conn = nil
begin
conn = Mysql.real_connect("127.0.0.1","root","","f_juso","3306")
# do something with the connection
rescue Mysql::Error => e
puts "Invalid password"
end

--
Alex

Barabule Muci

1/17/2007 8:48:00 AM

0

I try before but i get this message:

C:/work/aplicatie/app/controllers/comenzi_controller.rb:32: parse error,
unexpected kRESCUE, expecting kEND
rescue Mysql::Error => e
^
C:/work/aplicatie/app/controllers/comenzi_controller.rb:32: parse error,
unexpected tASSOC
rescue Mysql::Error => e
^
C:/work/aplicatie/app/controllers/comenzi_controller.rb:43: parse error,
unexpected kEND, expecting $

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

Michael W. Ryder

1/17/2007 8:57:00 AM

0

Barabule Muci wrote:
> Hello,
> I am making an connection with mysql
> Mysql.real_connect("127.0.0.1","root","","f_juso","3306")
>
> The problem is when the user and pass is correct it works very well but
> when the user and pass is wrong it display the debugger and display the
> message:
> Mysql::Error in ComenziController#login
> Access denied for user 'roots'@'localhost' (using password: NO)
> and all that ruby debugger stuff.
>
> I wan't to get the error in ruby and to display only my message like
> "Invalid password."
> It's help me, because i have made an login script and i wan't to check
> the user and password by connecting on mysql with that user and
> password.
> Thanks
>

Couldn't you create a separate account with a single table with only the
user names and passwords in it? This way you can use a set login to
access this account and check if the user account is in the table. If
it exists then check the password. If the information is correct
continue with logging into the desired database otherwise display the
error message of your choice.

Barabule Muci

1/17/2007 9:11:00 AM

0

No i create users on mysql with rights on tables, this is why i chose
this metode.
Every user has a table that can acces.

Michael W. Ryder wrote:
> Barabule Muci wrote:
>>
>> I wan't to get the error in ruby and to display only my message like
>> "Invalid password."
>> It's help me, because i have made an login script and i wan't to check
>> the user and password by connecting on mysql with that user and
>> password.
>> Thanks
>>
>
> Couldn't you create a separate account with a single table with only the
> user names and passwords in it? This way you can use a set login to
> access this account and check if the user account is in the table. If
> it exists then check the password. If the information is correct
> continue with logging into the desired database otherwise display the
> error message of your choice.


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