Re: [qmailadmin] Password encryption

2004-12-12 Thread Tom Collins
On Dec 11, 2004, at 7:02 PM, [EMAIL PROTECTED] wrote: So what happens when I try to authenticate to the db? If I get the crypted password and do a query such as: SELECT * FROM table WHERE user = 'user' AND password = 'encryptedpassword' It would obviously not work since it tries to do an exact

Re: [qmailadmin] Password encryption

2004-12-11 Thread rbartlett
> On Dec 10, 2004, at 5:24 PM, [EMAIL PROTECTED] wrote: >> Thanks for the reply, the problem though is if you crypt the current >> password it does not turn out like the encrypted password above. I get >> different results when using the function from the link you provided. >> This >> is the passwo

Re: [qmailadmin] Password encryption

2004-12-11 Thread Geoff
Try passing the entire encrypted password to the crypt function. This should use the same first hash and produce the same encrypted string. in php this is done using crypt("encryptme", "salt") [EMAIL PROTECTED] wrote: On Dec 10, 2004, at 5:24 PM, [EMAIL PROTECTED] wrote: Thanks for the reply

Re: [qmailadmin] Password encryption

2004-12-10 Thread rbartlett
> On Dec 10, 2004, at 5:24 PM, [EMAIL PROTECTED] wrote: >> Thanks for the reply, the problem though is if you crypt the current >> password it does not turn out like the encrypted password above. I get >> different results when using the function from the link you provided. >> This >> is the passwo

Re: [qmailadmin] Password encryption

2004-12-10 Thread rbartlett
Hmm. Interesting, I changed the password in mysql and the old password still works. I even made it blank, it still authenticates me correctly. Every account I create shows up in mysql table, am I doing something wrong? Do I have to update password in 2 places? Robert > Thanks for the reply, the p

Re: [qmailadmin] Password encryption

2004-12-10 Thread Tom Collins
On Dec 10, 2004, at 5:24 PM, [EMAIL PROTECTED] wrote: Thanks for the reply, the problem though is if you crypt the current password it does not turn out like the encrypted password above. I get different results when using the function from the link you provided. This is the password I get when I

Re: [qmailadmin] Password encryption

2004-12-10 Thread Jeremy Kitchen
On Friday 10 December 2004 07:24 pm, [EMAIL PROTECTED] wrote: > Thanks for the reply, the problem though is if you crypt the current > password it does not turn out like the encrypted password above. I get > different results when using the function from the link you provided. This > is the passwor

Re: [qmailadmin] Password encryption

2004-12-10 Thread rbartlett
Thanks for the reply, the problem though is if you crypt the current password it does not turn out like the encrypted password above. I get different results when using the function from the link you provided. This is the password I get when I encrypt the same password in the original email: $1$34

Re: [qmailadmin] Password encryption

2004-12-10 Thread Michael Bowe
- Original Message - From: <[EMAIL PROTECTED]> > I am still unable to determine how my mail server is encrypting passwords. > An example encrypted password is: > > $1$AaAkCUIr$tq.YJ2hHJDQ56Zbgg83eh1 > > I need to be able to query the mysql db to authenticate the user via the > encrypted

[qmailadmin] Password encryption

2004-12-10 Thread rbartlett
I am still unable to determine how my mail server is encrypting passwords. An example encrypted password is: $1$AaAkCUIr$tq.YJ2hHJDQ56Zbgg83eh1 I need to be able to query the mysql db to authenticate the user via the encrypted password above. Please help Thanks Robert

Re: [qmailadmin] Password encryption

2004-12-10 Thread Rick Widmer
[EMAIL PROTECTED] wrote: I am still unable to determine how my mail server is encrypting passwords. An example encrypted password is: $1$AaAkCUIr$tq.YJ2hHJDQ56Zbgg83eh1 I need to be able to query the mysql db to authenticate the user via the encrypted password above. Please help crypt() with md5

Re: [qmailadmin] Password encryption

2004-10-27 Thread Robert Bartlett
So if I called it via a php script I would use php function crypt? Or would I use encrypt in the mysql call? Robert > On Wednesday 27 October 2004 05:40 pm, Robert Bartlett wrote: >> When you add an account in qmailadmin, it enters it into a mysql db >> since >> I setup vpopmail to do this. My qu

Re: [qmailadmin] Password encryption

2004-10-27 Thread Jeremy Kitchen
On Wednesday 27 October 2004 05:40 pm, Robert Bartlett wrote: > When you add an account in qmailadmin, it enters it into a mysql db since > I setup vpopmail to do this. My question is what encryption does it use in > the mysql db for the password? the encryption that vpopmail uses. I believe this

[qmailadmin] Password encryption

2004-10-27 Thread Robert Bartlett
When you add an account in qmailadmin, it enters it into a mysql db since I setup vpopmail to do this. My question is what encryption does it use in the mysql db for the password? Thanks Robert