|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
September 19th, 2005, 05:21 AM
|
|||
|
|||
|
Password encryption
I'm writing a Perl script for a web page to change user passwords for Firebird databases and the passwd field in the users table needs to be encrypted. I thought I could use f_ibpassword to do this, requiring FreeUDFLib.dll, but the information I've found on FreeUDFLib.dll says that it can only be used with Windows and not Unix. Does anyone have any idea how I can use f_ibpassword or know any other methods I could use to encrypt the password?
Thanks for your help, Izabelle
|
|
#2
September 19th, 2005, 05:57 AM
|
||||
|
||||
|
Can't you just encrypt it in perl and insert the encrypted one?
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
#3
September 19th, 2005, 06:05 AM
|
|||
|
|||
|
I've tried using Perl's crypt function to encrypt it but when I try to connect to the database using the new password it tells me that the username or password is incorrect so I assume it doesn't work.
|
|
#4
November 11th, 2005, 08:23 AM
|
||||
|
||||
Quote:
I Have looked in the source code vi firebird2/src/jrd/enc.cpp and seems firebird useses an salt for generating password ENC_crypt(TEXT *string, TEXT *salt) Another option is to change password with gsec utility Free udf is using it for changing password http://www.ibexpert.com/download/udf/ Code:
szApp := IB_BIN + '\gsec.exe'; // This is lpApplicationName (See CreateProcess)
// szCmdLine is lpCommandLine (See CreateProcess)
case action[0] of
'A': szCmdLine := szApp + ' -add ' + uname + ' -pw ' + pword;
'D': szCmdLine := szApp + ' -delete ' + uname;
'M': szCmdLine := szApp + ' -modify ' + uname + ' -pw ' + pword;
|
|
#5
November 11th, 2005, 08:37 AM
|
||||
|
||||
firebird 1.5.2 password salt
seems to be "9z"
Quote:
|
|
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Password encryption |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
