Re: [GENERAL] function that resolves IP addresses

2005-10-31 Thread Dennis Jenkins
--- "Joshua D. Drake" <[EMAIL PROTECTED]> wrote: It is not fully debugged, but this is what I wrote a few months ago for sh*ts and grins. /* djenkins, 2005-7-22 Implements poor-man's reverse DNS lookup tool for use in Postgresql SQL functions. CREATE FUNCTION reverse_dns_lookup

Re: [GENERAL] function that resolves IP addresses

2005-10-29 Thread Joshua D. Drake
Bruno Wolff III wrote: On Wed, Oct 19, 2005 at 14:36:46 +0200, Marcel Gsteiger <[EMAIL PROTECTED]> wrote: Hi all Does anybody know how I could create a database function that accepts an INET parameter and reverse-lookups the hostname via DNS PTR lookup? Something like the dnsname command l

Re: [GENERAL] function that resolves IP addresses

2005-10-29 Thread Bruno Wolff III
On Wed, Oct 19, 2005 at 14:36:46 +0200, Marcel Gsteiger <[EMAIL PROTECTED]> wrote: > Hi all > > Does anybody know how I could create a database function that accepts > an INET parameter and reverse-lookups the hostname via DNS PTR lookup? > Something like the dnsname command line utility in the

Re: [GENERAL] function that resolves IP addresses

2005-10-19 Thread Jim Buttafuoco
guage plperlu; select gethostbyaddr('199.181.132.250'::inet); -- Original Message --- From: "Marcel Gsteiger" <[EMAIL PROTECTED]> To: Sent: Wed, 19 Oct 2005 14:36:46 +0200 Subject: [GENERAL] function that resolves IP addresses > Hi all > >

Re: [GENERAL] function that resolves IP addresses

2005-10-19 Thread A. Kretschmer
am 19.10.2005, um 14:36:46 +0200 mailte Marcel Gsteiger folgendes: > Hi all > > Does anybody know how I could create a database function that accepts > an INET parameter and reverse-lookups the hostname via DNS PTR lookup? > Something like the dnsname command line utility in the djbdns package. I

Re: [GENERAL] function that resolves IP addresses

2005-10-19 Thread Richard Huxton
Marcel Gsteiger wrote: Hi all Does anybody know how I could create a database function that accepts an INET parameter and reverse-lookups the hostname via DNS PTR lookup? Something like the dnsname command line utility in the djbdns package. I need this function for analyzing firewall logs store

[GENERAL] function that resolves IP addresses

2005-10-19 Thread Marcel Gsteiger
Hi all Does anybody know how I could create a database function that accepts an INET parameter and reverse-lookups the hostname via DNS PTR lookup? Something like the dnsname command line utility in the djbdns package. I need this function for analyzing firewall logs stored in the database with ul