Re: Questions about database (PostgreSQL)

[roman () danyliw com]

Have you looked at the following ER diagram and table 
description?

http://acidlab.sourceforge.net/acid_db_er_v102.html

Roman

> Hi,
>
>       I am wondering what the table relationships are inthe Postgres database
> portion of Snort. I am trying to tie it all together into a PHP/Web
> front end, and I can't seem to relate a specific event to a specific
> signature. It all seems to come out a little off. Can anyone help me???
>
> Deven Phillips, CISSP
> Network Architect
> Viata Online, Inc.
> -- 
> Sorry if the spelling sucks, but my laptop battery is runn....
> --------------msDA58DB5BB838029F2483096A
> 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
>
> MIIH3gYJKoZIhvcNAQcCoIIHzzCCB8sCAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHAaCC
> BbEwggKAMIIB6aADAgECAgMDweAwDQYJKoZIhvcNAQEEBQAwgZIxCzAJBgNVBAYTAlpBMRUw
> EwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEPMA0GA1UEChMGVGhh
> d3RlMR0wGwYDVQQLExRDZXJ0aWZpY2F0ZSBTZXJ2aWNlczEoMCYGA1UEAxMfUGVyc29uYWwg
> RnJlZW1haWwgUlNBIDIwMDAuOC4zMDAeFw0wMDEyMDgwMzAyNDFaFw0wMTEyMDgwMzAyNDFa
> MEUxHzAdBgNVBAMTFlRoYXd0ZSBGcmVlbWFpbCBNZW1iZXIxIjAgBgkqhkiG9w0BCQEWE2Rw
> aGlsbGlwc0B2aWF0YS5jb20wgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAKWloQgay12A
> 9jBjwMGmnRsr/dIpSCdu8XmPirxx+pLlSJ/qusj/6aMI+PyIGDwxicJ9jepts120+VSFBJkf
> FLUCWLtNv0ceE4qqt8A8jKJx86fdayuZGeiwMRxN0kHk++mN8H/yBO2v5Be1Tcko9itN9NTn
> RRGtr3I9aGwY6egXAgMBAAGjMDAuMB4GA1UdEQQXMBWBE2RwaGlsbGlwc0B2aWF0YS5jb20w
> DAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQQFAAOBgQCK6wi2YG1VSQZ4kNY0nhp/cAvdH72I
> TrzhwFLPEh5jiytPEoBc+JZTMMZxR2DOHXgvwZ+azcLknn8GLC2J9XnhaoxLUwWJc/Qs1t9d
> ncLaLORjmwCCXTjQOQZhShc2p35o7HcTDEThjFhVySuP6V4shICw+IYfRKn1pHDJ5G9EUzCC
> AykwggKSoAMCAQICAQwwDQYJKoZIhvcNAQEEBQAwgdExCzAJBgNVBAYTAlpBMRUwEwYDVQQI
> EwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEaMBgGA1UEChMRVGhhd3RlIENv
> bnN1bHRpbmcxKDAmBgNVBAsTH0NlcnRpZmljYXRpb24gU2VydmljZXMgRGl2aXNpb24xJDAi
> BgNVBAMTG1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBDQTErMCkGCSqGSIb3DQEJARYccGVy
> c29uYWwtZnJlZW1haWxAdGhhd3RlLmNvbTAeFw0wMDA4MzAwMDAwMDBaFw0wMjA4MjkyMzU5
> NTlaMIGSMQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRIwEAYDVQQHEwlD
> YXBlIFRvd24xDzANBgNVBAoTBlRoYXd0ZTEdMBsGA1UECxMUQ2VydGlmaWNhdGUgU2Vydmlj
> ZXMxKDAmBgNVBAMTH1BlcnNvbmFsIEZyZWVtYWlsIFJTQSAyMDAwLjguMzAwgZ8wDQYJKoZI
> hvcNAQEBBQADgY0AMIGJAoGBAN4zMqZjxwklRT7SbngnZ4HF2ogZgpcO40QpimM1Km1wPPrc
> rvfudG8wvDOQf/k0caCjbZjxw0+iZdsN+kvx1t1hpfmFzVWaNRqdknWoJ67Ycvm6AvbXsJHe
> HOmr4BgDqHxDQlBRh4M88Dm0m1SKE4f/s5udSWYALQmJ7JRr6aFpAgMBAAGjTjBMMCkGA1Ud
> EQQiMCCkHjAcMRowGAYDVQQDExFQcml2YXRlTGFiZWwxLTI5NzASBgNVHRMBAf8ECDAGAQH/
> AgEAMAsGA1UdDwQEAwIBBjANBgkqhkiG9w0BAQQFAAOBgQBzG28mZYv/FTRLWWKK7US+Scfo
> DbuPuQ1qJipihB+4h2N0HG23zxpTkUvhzeY42e1Q9DpsNJKs5pKcbsEjAcIJp+9LrnLdBmf1
> UG8uWLi2C8FQV7XsHNfvF7bViJu3ooga7TlbOX00/LaWGCVNavSdxcORL6mWuAU8Uvzd6WID
> SDGCAfUwggHxAgEBMIGaMIGSMQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBl
> MRIwEAYDVQQHEwlDYXBlIFRvd24xDzANBgNVBAoTBlRoYXd0ZTEdMBsGA1UECxMUQ2VydGlm
> aWNhdGUgU2VydmljZXMxKDAmBgNVBAMTH1BlcnNvbmFsIEZyZWVtYWlsIFJTQSAyMDAwLjgu
> MzACAwPB4DAJBgUrDgMCGgUAoIGxMBgGCSqGSIb3DQEJAzELBgkqhkiG9w0BBwEwHAYJKoZI
> hvcNAQkFMQ8XDTAxMDcyNjAyMTIxOVowIwYJKoZIhvcNAQkEMRYEFKyxwfdalEfjJfER3AnI
> uaex27NCMFIGCSqGSIb3DQEJDzFFMEMwCgYIKoZIhvcNAwcwDgYIKoZIhvcNAwICAgCAMAcG
> BSsOAwIHMA0GCCqGSIb3DQMCAgFAMA0GCCqGSIb3DQMCAgEoMA0GCSqGSIb3DQEBAQUABIGA
> ZOJsCgPoSRTEGulmDvmd2RTIPRSZ5uVr7QH4Mly0d64kFTRYykAcBGZVoa9ggHTlmVtaVCcr
> JbMLNtRmaWOFvD/iW7upOudc6y7dWPQgks34cRsJNfJA6MHrT/2nBp2r5ghH/Wg2lX8zyHnB
> 0NYLeOpMua7x9RvLZvCNgZ0Ffwk=
> --------------msDA58DB5BB838029F2483096A--
>
>
> _______________________________________________
> Snort-users mailing list
> Snort-users () lists sourceforge net
> Go to this URL to change user options or unsubscribe:
> http://lists.sourceforge.net/lists/listinfo/snort-users
> Snort-users list archive:
> http://www.geocrawler.com/redir-sf.php3?list=snort-users



---------------------------------------------
This message was sent using Voicenet WebMail.
      http://www.voicenet.com/webmail/



_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
http://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users