storing keyrings into SQL database?

[Jean-David Beyer]

This is a cryptographically signed message in MIME format.

--------------ms060305020407060003050804
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Ryan Malayter wrote:
 > From: Joseph Bruni [mailto:jbruni@mac.com]
 >
 >> Has anyone ever calculated the odds of a fingerprint collision?
 >> Sometimes its kind of nice to know just for perspective.
 >
 >
 > An OpenPGP fingerprint is 80 bits, the chances of a collision between
 >  any two fingerprints is about 1 in 2^80, and I think you would need
 > a collection of about 2^40 fingerprints to have a better-than-50%
 > chance of collision.
 >
That calculation did not seem right, but I guess it is. By analogy with
the problem in Freshman statistics class, I paraphrase you ...

A year of days is between 8 and 9 bits, and I think you would need a 
collection of about 2^4.5 people to have a better-than-50% chance of 
collision.

IIRC, it takes about 23 people to get that 50% chance. 2^4.5 is 22.6274 
on my dinky calculator.

-- 
   .~.  Jean-David Beyer           Registered Linux User 85642.
   /V\                             Registered Machine    73926.
  /( )\ Shrewsbury, New Jersey     http://counter.li.org
  ^^-^^ 12:55pm up 4 days, 18:29, 2 users, load average: 2.22, 2.34, 2.38

--------------ms060305020407060003050804
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIINvjCC
A2IwggLLoAMCAQICEAvaCxfBP4mOqwl0erTOLjMwDQYJKoZIhvcNAQECBQAwXzELMAkGA1UE
BhMCVVMxFzAVBgNVBAoTDlZlcmlTaWduLCBJbmMuMTcwNQYDVQQLEy5DbGFzcyAxIFB1Ymxp
YyBQcmltYXJ5IENlcnRpZmljYXRpb24gQXV0aG9yaXR5MB4XDTk4MDUxMjAwMDAwMFoXDTA4
MDUxMjIzNTk1OVowgcwxFzAVBgNVBAoTDlZlcmlTaWduLCBJbmMuMR8wHQYDVQQLExZWZXJp
U2lnbiBUcnVzdCBOZXR3b3JrMUYwRAYDVQQLEz13d3cudmVyaXNpZ24uY29tL3JlcG9zaXRv
cnkvUlBBIEluY29ycC4gQnkgUmVmLixMSUFCLkxURChjKTk4MUgwRgYDVQQDEz9WZXJpU2ln
biBDbGFzcyAxIENBIEluZGl2aWR1YWwgU3Vic2NyaWJlci1QZXJzb25hIE5vdCBWYWxpZGF0
ZWQwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBALtaRIoEFrtV/QN6ii2UTxV4NrgNSrJv
nFS/vOh3Kp258Gi7ldkxQXB6gUu5SBNWLccI4YRCq8CikqtEXKpC8IIOAukv+8I7u77JJwpd
trA2QjO1blSIT4dKvxna+RXoD4e2HOPMxpqOf2okkuP84GW6p7F+78nbN2rISsgJBuSZAgMB
AAGjgbAwga0wDwYDVR0TBAgwBgEB/wIBADBHBgNVHSAEQDA+MDwGC2CGSAGG+EUBBwEBMC0w
KwYIKwYBBQUHAgEWH3d3dy52ZXJpc2lnbi5jb20vcmVwb3NpdG9yeS9SUEEwMQYDVR0fBCow
KDAmoCSgIoYgaHR0cDovL2NybC52ZXJpc2lnbi5jb20vcGNhMS5jcmwwCwYDVR0PBAQDAgEG
MBEGCWCGSAGG+EIBAQQEAwIBBjANBgkqhkiG9w0BAQIFAAOBgQACfZ5vRUs4oLje6VNkIbzk
TCuPHv6SQKzYCjlqoTIhLAebq1n+0mIafVU4sDdz3PQHZmNiveFTcFKH56jYUulbLarh3s+s
MVTUixnI2COo7wQrMn0sGBzIfImoLnfyRNFlCk10te7TG5JzdC6JOzUTcudAMZrTssSr51a+
i+P7FTCCBSgwggSRoAMCAQICEGlfAhgT5dD2IHApDrAaq5owDQYJKoZIhvcNAQEEBQAwgcwx
FzAVBgNVBAoTDlZlcmlTaWduLCBJbmMuMR8wHQYDVQQLExZWZXJpU2lnbiBUcnVzdCBOZXR3
b3JrMUYwRAYDVQQLEz13d3cudmVyaXNpZ24uY29tL3JlcG9zaXRvcnkvUlBBIEluY29ycC4g
QnkgUmVmLixMSUFCLkxURChjKTk4MUgwRgYDVQQDEz9WZXJpU2lnbiBDbGFzcyAxIENBIElu
ZGl2aWR1YWwgU3Vic2NyaWJlci1QZXJzb25hIE5vdCBWYWxpZGF0ZWQwHhcNMDIwNjAyMDAw
MDAwWhcNMDMwNjE2MjM1OTU5WjCCARYxFzAVBgNVBAoTDlZlcmlTaWduLCBJbmMuMR8wHQYD
VQQLExZWZXJpU2lnbiBUcnVzdCBOZXR3b3JrMUYwRAYDVQQLEz13d3cudmVyaXNpZ24uY29t
L3JlcG9zaXRvcnkvUlBBIEluY29ycC4gYnkgUmVmLixMSUFCLkxURChjKTk4MR4wHAYDVQQL
ExVQZXJzb25hIE5vdCBWYWxpZGF0ZWQxMzAxBgNVBAsTKkRpZ2l0YWwgSUQgQ2xhc3MgMSAt
IE5ldHNjYXBlIEZ1bGwgU2VydmljZTEZMBcGA1UEAxQQSmVhbi1EYXZpZCBCZXllcjEiMCAG
CSqGSIb3DQEJARYTamRiZXllckBleGl0MTA5LmNvbTCCASIwDQYJKoZIhvcNAQEBBQADggEP
ADCCAQoCggEBAMv38/uuxXth9gQ9TcEZMARz9Ju+c2l0hzW2vpYYJUcQig/uCLJqmYLzsdoB
faSMHN8UlnHk1FC4MQ3r3l58v0iIz6ERC4RLWKFvntQNvk5teCqZ0Tmf9DdFNzh4gkffdhL8
Un9CsRrHogviVReyTXfzH039X/UjODAcvyRVTDpMVpNQ81bhR/VWxR7esbm1ewHVj+KOGxqr
rl2PD412TxxIXEAzVTACqVR/CCOBQZ7BrrztKXomz9ePav/ZTjdybWFve5p1NAUawFcl1ajA
JiEGL2Ug4qq26x4Z2cOosQCx9tJt0tpPy3qwORYbepKBDhkXicPBZVkzx7Lm7a961isCAwEA
AaOCATgwggE0MAkGA1UdEwQCMAAwgawGA1UdIASBpDCBoTCBngYLYIZIAYb4RQEHAQEwgY4w
KAYIKwYBBQUHAgEWHGh0dHBzOi8vd3d3LnZlcmlzaWduLmNvbS9DUFMwYgYIKwYBBQUHAgIw
VjAVFg5WZXJpU2lnbiwgSW5jLjADAgEBGj1WZXJpU2lnbidzIENQUyBpbmNvcnAuIGJ5IHJl
ZmVyZW5jZSBsaWFiLiBsdGQuIChjKTk3IFZlcmlTaWduMBEGCWCGSAGG+EIBAQQEAwIHgDAw
BgpghkgBhvhFAQYHBCIWIDMxYzVhODdmZDYxNjdhY2NlY2NmNWFhMjcxNjIyOTE5MDMGA1Ud
HwQsMCowKKAmoCSGImh0dHA6Ly9jcmwudmVyaXNpZ24uY29tL2NsYXNzMS5jcmwwDQYJKoZI
hvcNAQEEBQADgYEAZLD9KTpkxdd6cjpK6vjIkieu6V5o0PngC/Y6is1waG0nSRcnLrVn/ped
OlLtkViedt0kRuVcr/TmphHO34zAfLA0n6BNzYRN3QS4vYmvsIeJkDtyP13xd7TQIq3lJQsI
KewOFKr46/W5/RbESZ0StZ86TTvMIwYJB+nWF1KuaA4wggUoMIIEkaADAgECAhBpXwIYE+XQ
9iBwKQ6wGquaMA0GCSqGSIb3DQEBBAUAMIHMMRcwFQYDVQQKEw5WZXJpU2lnbiwgSW5jLjEf
MB0GA1UECxMWVmVyaVNpZ24gVHJ1c3QgTmV0d29yazFGMEQGA1UECxM9d3d3LnZlcmlzaWdu
LmNvbS9yZXBvc2l0b3J5L1JQQSBJbmNvcnAuIEJ5IFJlZi4sTElBQi5MVEQoYyk5ODFIMEYG
A1UEAxM/VmVyaVNpZ24gQ2xhc3MgMSBDQSBJbmRpdmlkdWFsIFN1YnNjcmliZXItUGVyc29u
YSBOb3QgVmFsaWRhdGVkMB4XDTAyMDYwMjAwMDAwMFoXDTAzMDYxNjIzNTk1OVowggEWMRcw
FQYDVQQKEw5WZXJpU2lnbiwgSW5jLjEfMB0GA1UECxMWVmVyaVNpZ24gVHJ1c3QgTmV0d29y
azFGMEQGA1UECxM9d3d3LnZlcmlzaWduLmNvbS9yZXBvc2l0b3J5L1JQQSBJbmNvcnAuIGJ5
IFJlZi4sTElBQi5MVEQoYyk5ODEeMBwGA1UECxMVUGVyc29uYSBOb3QgVmFsaWRhdGVkMTMw
MQYDVQQLEypEaWdpdGFsIElEIENsYXNzIDEgLSBOZXRzY2FwZSBGdWxsIFNlcnZpY2UxGTAX
BgNVBAMUEEplYW4tRGF2aWQgQmV5ZXIxIjAgBgkqhkiG9w0BCQEWE2pkYmV5ZXJAZXhpdDEw
OS5jb20wggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQDL9/P7rsV7YfYEPU3BGTAE
c/SbvnNpdIc1tr6WGCVHEIoP7giyapmC87HaAX2kjBzfFJZx5NRQuDEN695efL9IiM+hEQuE
S1ihb57UDb5ObXgqmdE5n/Q3RTc4eIJH33YS/FJ/QrEax6IL4lUXsk138x9N/V/1IzgwHL8k
VUw6TFaTUPNW4Uf1VsUe3rG5tXsB1Y/ijhsaq65djw+Ndk8cSFxAM1UwAqlUfwgjgUGewa68
7Sl6Js/Xj2r/2U43cm1hb3uadTQFGsBXJdWowCYhBi9lIOKqtuseGdnDqLEAsfbSbdLaT8t6
sDkWG3qSgQ4ZF4nDwWVZM8ey5u2vetYrAgMBAAGjggE4MIIBNDAJBgNVHRMEAjAAMIGsBgNV
HSAEgaQwgaEwgZ4GC2CGSAGG+EUBBwEBMIGOMCgGCCsGAQUFBwIBFhxodHRwczovL3d3dy52
ZXJpc2lnbi5jb20vQ1BTMGIGCCsGAQUFBwICMFYwFRYOVmVyaVNpZ24sIEluYy4wAwIBARo9
VmVyaVNpZ24ncyBDUFMgaW5jb3JwLiBieSByZWZlcmVuY2UgbGlhYi4gbHRkLiAoYyk5NyBW
ZXJpU2lnbjARBglghkgBhvhCAQEEBAMCB4AwMAYKYIZIAYb4RQEGBwQiFiAzMWM1YTg3ZmQ2
MTY3YWNjZWNjZjVhYTI3MTYyMjkxOTAzBgNVHR8ELDAqMCigJqAkhiJodHRwOi8vY3JsLnZl
cmlzaWduLmNvbS9jbGFzczEuY3JsMA0GCSqGSIb3DQEBBAUAA4GBAGSw/Sk6ZMXXenI6Sur4
yJInruleaND54Av2OorNcGhtJ0kXJy61Z/6XnTpS7ZFYnnbdJEblXK/05qYRzt+MwHywNJ+g
Tc2ETd0EuL2Jr7CHiZA7cj9d8Xe00CKt5SULCCnsDhSq+Ov1uf0WxEmdErWfOk07zCMGCQfp
1hdSrmgOMYIDtTCCA7ECAQEwgeEwgcwxFzAVBgNVBAoTDlZlcmlTaWduLCBJbmMuMR8wHQYD
VQQLExZWZXJpU2lnbiBUcnVzdCBOZXR3b3JrMUYwRAYDVQQLEz13d3cudmVyaXNpZ24uY29t
L3JlcG9zaXRvcnkvUlBBIEluY29ycC4gQnkgUmVmLixMSUFCLkxURChjKTk4MUgwRgYDVQQD
Ez9WZXJpU2lnbiBDbGFzcyAxIENBIEluZGl2aWR1YWwgU3Vic2NyaWJlci1QZXJzb25hIE5v
dCBWYWxpZGF0ZWQCEGlfAhgT5dD2IHApDrAaq5owCQYFKw4DAhoFAKCCAagwGAYJKoZIhvcN
AQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMDMwNTIzMTcwNDMxWjAjBgkqhkiG
9w0BCQQxFgQU3AGXqZ0vw9/tGB+xi93y2Q3c9ywwUgYJKoZIhvcNAQkPMUUwQzAKBggqhkiG
9w0DBzAOBggqhkiG9w0DAgICAIAwDQYIKoZIhvcNAwICAUAwBwYFKw4DAgcwDQYIKoZIhvcN
AwICASgwgfQGCyqGSIb3DQEJEAILMYHkoIHhMIHMMRcwFQYDVQQKEw5WZXJpU2lnbiwgSW5j
LjEfMB0GA1UECxMWVmVyaVNpZ24gVHJ1c3QgTmV0d29yazFGMEQGA1UECxM9d3d3LnZlcmlz
aWduLmNvbS9yZXBvc2l0b3J5L1JQQSBJbmNvcnAuIEJ5IFJlZi4sTElBQi5MVEQoYyk5ODFI
MEYGA1UEAxM/VmVyaVNpZ24gQ2xhc3MgMSBDQSBJbmRpdmlkdWFsIFN1YnNjcmliZXItUGVy
c29uYSBOb3QgVmFsaWRhdGVkAhBpXwIYE+XQ9iBwKQ6wGquaMA0GCSqGSIb3DQEBAQUABIIB
AH67izE/t0m7TchQBZiHE3fRWRnYoVlP0/Ld/W6jibD2nTcewHaCi9uy5qP36RGTB16LM4/p
INrYOqRpeIfAvuJTX7ma5kVjjUhErAGnPUdEFo0xcO7bKjZ6CbAb6fhoWV5joXYgL/n/AIsa
E82e5+cMxrWmpYWNCDkv6dxr+bze5uVKi+gpDyfV/YYpPebl0pu5UrS77lpaPXaSxuLPouXY
mjKl8vGF5uOtLUTNGRiIyfsnD3nH6+It5tqKOQTmPM4475x9c2FZ6jKe0EcCBDTrCkuiy2qk
tmn0QnhgjWoTLm5iv0bniBohUG5d9soDXpgitbFY+by2YrcLfRQkGpUAAAAAAAA=
--------------ms060305020407060003050804--