On Mon, 2011-03-07 at 13:51 +0100, Johan De Meersman wrote:
> Umm... I'm no crypto guru, but I've never heard of MD5 having variants, let
> alone a salt. MD5 is MD5 is MD5. APR, incidentally, is the Apache Runtime,
> afaik - part of the build kit for apache modules.
>
>
Umm... I'm no crypto guru, but I've never heard of MD5 having variants, let
alone a salt. MD5 is MD5 is MD5. APR, incidentally, is the Apache Runtime,
afaik - part of the build kit for apache modules.
I strongly suspect your problem is on another level.
- Original Message --
s into mysql
we want not to use apache auth of encrypt, but use md5 for longer password
apache use variant of md5, called md5 -apr, but mysql md5 only uses the -1
type
so, when CRM add userlike
INSERT INTO users (..other`appass`) values (...other... 'MD5('$PASS')
the
Sorry but what about are you speaking?
what are you doing?
and what has this to do with mysql?
Am 06.03.2011 05:34, schrieb Edward avanti:
> Hi, I am having all sorts of problem getting apache to accept its MD5
> version, this is from a CRM using perl
> I've tried concat $apr1$foo
Hi, I am having all sorts of problem getting apache to accept its MD5
version, this is from a CRM using perl
I've tried concat $apr1$foo$ and md5(bar)
as best I can tell It doesnt like the md5 part
Is there anyway to get this to work? the only thing that does is encrypt,
and thats sad,
I just tried and it appears the functions DO NOT work in version 3.23
From: "Neil Tompkins" <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Subject: FW: Re: MD5()
Date: Mon, 12 Mar 2007 09:28:27 +
I thought the DES_ENCRYPT/DES_DECRYPT functions were released in mysql
v
I thought the DES_ENCRYPT/DES_DECRYPT functions were released in mysql
version 4 however they work with my version of mySQL 3.23 ?
Neil
From: "Neil Tompkins" <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Subject: FW: Re: MD5()
Date: Sat, 10 Mar 2007 18:24:19 +
Strange
Strange the DES_ENCRYPT/DES_DECRYPT functions work with my version of mySQL
3.23
From: "Neil Tompkins" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: MD5()
Date: Sat, 10 Mar 2007 18:20:43 +
DES_ENCRYPT/DES_DECRYPT appears to be what we
DES_ENCRYPT/DES_DECRYPT appears to be what we require.
Thanks
Neil
From: "Mogens Melander" <[EMAIL PROTECTED]>
To: "Neil Tompkins" <[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com
Subject: Re: MD5()
Date: Sat, 10 Mar 2007 12:19:53 +0100 (CET)
Or you might wa
ona
MSN/Windows Messenger: [EMAIL PROTECTED] (don't send email to the hotmail
address.)
- - Original Message -
From: "Neil Tompkins" <[EMAIL PROTECTED]>
To:
Sent: Saturday, March 10, 2007 4:17 AM
Subject: MD5()
I'm looking to use MD5() to encrypt credit card numbe
Or you might want to take a look at DES_ENCRYPT/DES_DECRYPT
funktions in the mysql manual.
On Sat, March 10, 2007 11:18, Ian P. Christian wrote:
> Neil Tompkins wrote:
>> I'm looking to use MD5() to encrypt credit card numbers. How do I
>> unencrypt this when reading the valu
Neil Tompkins wrote:
The problem I have is our mysql database version is 3.23 and we are not
in a position to upgrade.
Because you are unlikely to be selecting on this data directly, you
could use functions of whatever language you're using to connect to the
database... for example if you're
The problem I have is our mysql database version is 3.23 and we are not in a
position to upgrade.
From: "Ian P. Christian" <[EMAIL PROTECTED]>
To: Neil Tompkins <[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com
Subject: Re: MD5()
Date: Sat, 10 Mar 2007 10:24:45 +
Neil
Neil Tompkins wrote:
What do you recommend I use ?
http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html
That should help you.
However... keep in mind that if your application is likely to be
accessing this data all the time anyway, if someone compromises your
database, chances a
What do you recommend I use ?
From: "Ian P. Christian" <[EMAIL PROTECTED]>
To: Neil Tompkins <[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com
Subject: Re: MD5()
Date: Sat, 10 Mar 2007 10:18:41 +
Neil Tompkins wrote:
I'm looking to use MD5() to encrypt cre
Neil Tompkins wrote:
I'm looking to use MD5() to encrypt credit card numbers. How do I
unencrypt this when reading the value ?
you can't.
Google for MD5, or better still look at wikipedia, I'm sure they will
have something
--
Ian P. Christian ~ http://pookey.co.uk
-
I'm looking to use MD5() to encrypt credit card numbers. How do I unencrypt
this when reading the value ?
Thanks,
Neil
_
Get Hotmail, News, Sport and Entertainment from MSN on your mobile.
http://www.msn.txt4conten
On 18/08/2005, Martin Schwarz wrote:
> When using
> 'update TABLE set FIELD=PASSWORD('foo');'
> the query
> 'select * from TABLE where FIELD=PASSWORD('foo');'
> delivers an empty set.
>
> Same with the SHA1 or MD5 functions.
What
Hello!
I am facing the following problem:
When using
'update TABLE set FIELD=PASSWORD('foo');'
the query
'select * from TABLE where FIELD=PASSWORD('foo');'
delivers an empty set.
Same with the SHA1 or MD5 functions.
I am using Mac OS X Tiger (same
C.F. Scheidecker Antunes wrote:
I will have the password stored in the database with MD5.
What I actually need is a manual way to get the password back, that is
decoding it.
The whole point of MD5 is that you cannot decode it once encoded.
When someone enters their password, just MD5 what
C.F. Scheidecker Antunes wrote:
I am sorry. I meant another thing and wrote something else.
If I issue: INSERT INTO table1 values ('username',MD5('password'))
I will have the password stored in the database with MD5.
What I actually need is a manual way to get the pa
I am sorry. I meant another thing and wrote something else.
If I issue: INSERT INTO table1 values ('username',MD5('password'))
I will have the password stored in the database with MD5.
What I actually need is a manual way to get the password back, that is
decoding it.
MySQL actually has an MD5() function:
mysql> select MD5('password');
+------+
| MD5('password') |
+--+
| 5f4dcc3b5aa765d61d8327deb882cf99 |
+--+
1 row in s
Hello all,
Is there any function that I could use on a SQL statement to store a
password on a table manually using an algorithm like MD5?
Thanks,
C.F.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello.
See:
http://dev.mysql.com/doc/mysql/en/encryption-functions.html
symbulos partners <[EMAIL PROTECTED]> wrote:
> Dear friends,
>
> where is the description of the functions md5 in the manual? where is the
> description of the function crypt()?
>
Please stop writing "high priority" e-mails to a mailinglist.
Although the problem might be important for you, it's in no
way important for the receiver (which is quite a lot of people).
People will answer mailinglist questions for free, in their time.
I hope you understand.
--
Martijn Tonies
On Monday 21 Mar 2005 16:32, Michael Stassen wrote:
> Which is the first hit if you enter "md5 crypt" in the manual's search box.
I use the manual offline, because my connection is too slow.
I wonder why the encryption-function chapter is not in my manual.
--
symbulos par
Tom Crimmins wrote:
On Monday, March 21, 2005 09:27, symbulos partners wrote:
Dear friends,
where is the description of the functions md5 in the manual? where is
the description of the function crypt()?
are there are good alternatives?
http://dev.mysql.com/doc/mysql/en/encryption-functions.html
On Monday, March 21, 2005 09:27, symbulos partners wrote:
> Dear friends,
>
> where is the description of the functions md5 in the manual? where is
> the description of the function crypt()?
>
> are there are good alternatives?
http://dev.mysql.com/doc/mysql/en/encrypt
Dear friends,
where is the description of the functions md5 in the manual? where is the
description of the function crypt()?
are there are good alternatives?
--
symbulos partners
-.-
symbulos - ethical services for your organisation
http://www.symbulos.com
--
MySQL General Mailing List
For
On Mon, Dec 06, 2004 at 04:21:38PM -0600, [EMAIL PROTECTED] wrote:
> does anyone know what type of encryption is used in the PASSWORD(str)
> function? When would you use the MD5 vs the PASSWORD function?
>
> We have a campus standard to use the MD5 encryption so I need to conf
does anyone know what type of encryption is used in the PASSWORD(str)
function? When would you use the MD5 vs the PASSWORD function?
We have a campus standard to use the MD5 encryption so I need to confirm
if the PASSWORD function will offer that or not.
Thanks,
Lauren
--
MySQL General
Egor Egorov wrote:
"Andy B" <[EMAIL PROTECTED]> wrote:
hi...
what would be the best field type and length for an md5 encrypted password sort of thing??
You can store it in the CHAR(32) column (or VARCHAR(32)).
Or for binary MD5 (and not the hex version) a TINYBLOB(16) sh
"Andy B" <[EMAIL PROTECTED]> wrote:
> hi...
>
> what would be the best field type and length for an md5 encrypted password sort of
> thing??
You can store it in the CHAR(32) column (or VARCHAR(32)).
--
For technical support contracts, goto https://order.mysql.c
hi...
what would be the best field type and length for an md5 encrypted password sort of
thing??
encrypted passwords with md5, dumping it to a text file with
mysqldump and then running that script on a different server. For some strange reason
the encrypted passwords lose their encrypted state and are nothing more now than text
strings. Is there any way to preserve the state of md5 encryp
221b
>
>
> SELECT username+password+somethingelse FROM user;
>
> 49726b60ccbf03d6c619632e1db6
> f8ec2c9d79b5f969a96be968e7152bbd
>
>
>
> So that way, if someone gets the username/password for this user, they
> can't get any data off of the database.
>
>
fe3b4b388a69ceed38d6a0066e6a221b
> >
> >
> > SELECT username+password+somethingelse FROM user;
> >
> > 49726b60ccbf03d6c619632e1db6
> > f8ec2c9d79b5f969a96be968e7152bbd
> >
> >
> >
> > So that way, if someone gets the username/passwor
2e1db6
> f8ec2c9d79b5f969a96be968e7152bbd
>
>
>
> So that way, if someone gets the username/password for this user, they
> can't get any data off of the database.
>
> One thing you have to watch is that you don't use the md5 function for a
> user that has o
, if someone gets the username/password for this user, they can't
get any data off of the database.
One thing you have to watch is that you don't use the md5 function for a
user that has only md5read permission, because that would double-hash it,
and whatever you're checking would fail.
Benjamin Pflugmann wrote:
So what's left is that you save the real md5 string instead of it's
hex representation, e.g. in a CHAR BINARY. That's easiest if you have
the binary representation on the client side. I see no easy way of
doing it in MySQL if you only have the hex rep (
Hello.
On Thu 2002-10-31 at 13:54:18 -0500, [EMAIL PROTECTED] wrote:
> Am I right in assuming that comparing two md5 strings would be faster
> if they were compared as two hexadecimal numbers than if they were
> compared as two strings?
>
> If so, is there any way to insist o
Am I right in assuming that comparing two md5 strings would be faster
if they were compared as two hexadecimal numbers than if they were
compared as two strings?
If so, is there any way to insist on this in a SQL query? I am using
PHP, and would like to know from that perspective if it makes
> -Original Message-
> From: Joshua J.Kugler [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, June 20, 2002 4:30 PM
> To: Kiss Dániel; [EMAIL PROTECTED]
> Subject: Re: MD5
>
> If you are running Linix, at the prompt type:
>
> md5sum filename
>
> I'm sure
If you are running Linix, at the prompt type:
md5sum filename
I'm sure you can get md5sum for other Unices as well.
j- k-
On Thursday 20 June 2002 13:00, Kiss Dániel wrote:
> Hi everyone,
>
> Can anyone tell me how to create an MD5 checksum on a file.
> I tried to do
Hi everyone,
Can anyone tell me how to create an MD5 checksum on a file.
I tried to do this by using the MySQL MD5 function, but it does not work on
too big files (above 650MB), even if I set max_allow_packet size very big.
Is there any small program to do this, anyway?
Thx
Daniel
On Tuesday 09 April 2002 2:13 pm, Andrew Hazen wrote:
> Hi,
> Can I use the MD5 function in the where clause, as in:
>
> Select * from table where md5(column)=value
>
I see no reason why not but note that you are likely MUCH better off storing
column as an MD5 hash, compu
Hi,
Can I use the MD5 function in the where clause, as in:
Select * from table where md5(column)=value
spam filter: mysql
Andrew Hazen
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
the password function can not be decrypted can it, `cuz i need to show the
users' pass to the sis adm therefore i am considering to use the
encode/decode functions, although i am not secure to use those functions, i
have read in somewhere its not so confident.
does anybody here have some experienc
On 25 Jan 2002 07:05:32 +0800, [EMAIL PROTECTED] (Steven Roussey)
wrote:
>Does anyone have a best practices for efficiently storing md5 hash
>values in MySQL?
>
--snip--
>
>Md5 hash-- 16 bytes.
>char(32) binary -- 32 bytes.
>BIGINT -- 8 bytes
--snip--
Does anyone have a best practices for efficiently storing md5 hash
values in MySQL?
Since it is a 32 character string of hex numbers, I originally stored
them in a char(32) binary column. But that is wasted space (by a factor
of 2). And of course, these things add up, both in data files and
Make them a char(32). They will also be 32 chars long, have the DB expect
that.
At 10:48 AM 3/21/2001 -0600, roger westin wrote:
>Whats the best way, any realy good space saving way to store a MD5 value?
>
>/roger
--
Whats the best way, any realy good space saving way to store a MD5 value?
/roger
53 matches
Mail list logo
