From ezequias.rocha@gmail.com Sat Sep 2 20:42:40 2006 X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 7DDCE9FB53C for ; Sat, 2 Sep 2006 17:42:40 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 45511-01 for ; Sat, 2 Sep 2006 17:42:31 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.171]) by postgresql.org (Postfix) with ESMTP id 6E5209FB534 for ; Sat, 2 Sep 2006 17:42:31 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id s2so1440855uge for ; Sat, 02 Sep 2006 13:42:29 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=TLtza/Jzy/GsVxKSg8HokfybjeAAgHMaEwv/bcXvI1q92zDjy5c8UIPnFbDL9Aqy6dWr3onwS4iEl1RHscEM3oa5H5qrgdi1LkLLj0RBDAij5R6jbaC89QWM1lvh7JYP9zP9n079b1c4pyHQUEcyifL84o+weCFn4C8zzXxjL1k= Received: by 10.66.219.11 with SMTP id r11mr1934996ugg; Sat, 02 Sep 2006 13:42:29 -0700 (PDT) Received: by 10.67.118.11 with HTTP; Sat, 2 Sep 2006 13:42:29 -0700 (PDT) Message-ID: <55c095e90609021342u1728b3farc198d0c87dd7bb83@mail.gmail.com> Date: Sat, 2 Sep 2006 17:42:29 -0300 From: "Ezequias Rodrigues da Rocha" To: pgsql-sql@postgresql.org Subject: Mac Address MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_100590_789315.1157229749365" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.812 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_40_50, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200609/11 X-Sequence-Number: 26222 ------=_Part_100590_789315.1157229749365 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi list, It is possible to retrieve the MAC Address of a computer using a Postgresql function like others: http://www.postgresql.org/docs/8.1/static/functions-info.html I can retrieve a ip of some statement connection but I didn't find how to get the MAC Address. Is it possible ? Regards Ezequias --=20 =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D- Atenciosamente (Sincerely) Ezequias Rodrigues da Rocha =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D- A pior das democracias ainda =E9 melhor do que a melhor das ditaduras The worst of democracies is still better than the better of dictatorships http://ezequiasrocha.blogspot.com/ ------=_Part_100590_789315.1157229749365 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi list,

It is possible to retrieve the MAC Address of a computer us= ing a Postgresql function like others:

http://www.postgresql.org/docs= /8.1/static/functions-info.html

I can retrieve a ip of some statement connection but I didn't f= ind how to get the MAC Address. Is it possible ?


Regards
Ezeq= uias

--
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-= =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -=3D-=3D-=3D-=3D-=3D-=3D-=3D-
            = ;            &n= bsp;         Atenciosamente (S= incerely)
          &n= bsp;            = ; Ezequias Rodrigues da Rocha
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-= =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-
A pior das democracias ainda =E9 melho= r do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorshi= ps
http://ezequiasrocha.= blogspot.com/ ------=_Part_100590_789315.1157229749365-- From milen@radev.net Sat Sep 2 22:34:42 2006 X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id AD8179FB49D for ; Sat, 2 Sep 2006 19:34:42 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 84398-08 for ; Sat, 2 Sep 2006 22:34:38 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by postgresql.org (Postfix) with ESMTP id BB5499FB40A for ; Sat, 2 Sep 2006 19:34:38 -0300 (ADT) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1GJe4K-0004Tf-Rq for pgsql-sql@postgresql.org; Sun, 03 Sep 2006 00:34:29 +0200 Received: from 85.187.136.11 ([85.187.136.11]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sun, 03 Sep 2006 00:34:28 +0200 Received: from milen by 85.187.136.11 with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sun, 03 Sep 2006 00:34:28 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-sql@postgresql.org From: "Milen A. Radev" Subject: Re: Mac Address Date: Sun, 03 Sep 2006 01:34:27 +0300 Lines: 18 Message-ID: <44FA06F3.4090008@radev.net> References: <55c095e90609021342u1728b3farc198d0c87dd7bb83@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: 85.187.136.11 User-Agent: Mozilla Thunderbird 1.5.0.5 (Windows/20060719) In-Reply-To: <55c095e90609021342u1728b3farc198d0c87dd7bb83@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.498 tagged_above=0 required=5 tests=RCVD_NUMERIC_HELO, SPF_HELO_PASS, SPF_PASS X-Spam-Level: * X-Archive-Number: 200609/12 X-Sequence-Number: 26223 Ezequias Rodrigues da Rocha написа: > Hi list, > > It is possible to retrieve the MAC Address of a computer using a Postgresql > function like others: > > http://www.postgresql.org/docs/8.1/static/functions-info.html > > I can retrieve a ip of some statement connection but I didn't find how to > get the MAC Address. Is it possible ? No - the client and the server communicate using TCP/IP as transport/internet layer but that does not mean they use Ethernet as network access layer. -- Milen A. Radev From bruno@wolff.to Sat Sep 2 23:16:15 2006 X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 65DF99FB54C for ; Sat, 2 Sep 2006 20:16:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 54462-04 for ; Sat, 2 Sep 2006 20:16:10 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from wolff.to (wolff.to [66.93.197.194]) by postgresql.org (Postfix) with SMTP id 5F6749FB54B for ; Sat, 2 Sep 2006 20:16:10 -0300 (ADT) Received: (qmail 28263 invoked by uid 500); 2 Sep 2006 23:24:28 -0000 Date: Sat, 2 Sep 2006 18:24:28 -0500 From: Bruno Wolff III To: Ezequias Rodrigues da Rocha Cc: pgsql-sql@postgresql.org Subject: Re: Mac Address Message-ID: <20060902232428.GA26633@wolff.to> Mail-Followup-To: Bruno Wolff III , Ezequias Rodrigues da Rocha , pgsql-sql@postgresql.org References: <55c095e90609021342u1728b3farc198d0c87dd7bb83@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <55c095e90609021342u1728b3farc198d0c87dd7bb83@mail.gmail.com> User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.033 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200609/13 X-Sequence-Number: 26224 On Sat, Sep 02, 2006 at 17:42:29 -0300, Ezequias Rodrigues da Rocha wrote: > Hi list, > > It is possible to retrieve the MAC Address of a computer using a Postgresql > function like others: MAC Addresses are generally only transferred within a subnet and you aren't going to be able to get them in the general case. > http://www.postgresql.org/docs/8.1/static/functions-info.html > > I can retrieve a ip of some statement connection but I didn't find how to > get the MAC Address. Is it possible ? What is it that you are really trying to accomplish? There might be some other solution than having to get the mac address of a remote computer. From akretschmer@spamfence.net Sun Sep 3 07:07:05 2006 X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id A08D09FB4A8 for ; Sun, 3 Sep 2006 04:07:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 28890-03 for ; Sun, 3 Sep 2006 07:06:57 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from 137086.vserver.de (vs137086.vserver.de [62.75.137.86]) by postgresql.org (Postfix) with ESMTP id D289D9FB40A for ; Sun, 3 Sep 2006 04:06:56 -0300 (ADT) Received: from a-kretschmer.de (p54B3AFF7.dip0.t-ipconnect.de [84.179.175.247]) (authenticated bits=0) by 137086.vserver.de (8.12.8/8.12.8) with ESMTP id k8376fYs014309 for ; Sun, 3 Sep 2006 09:06:42 +0200 Received: from kretschmer by a-kretschmer.de with local (Exim 4.61) (envelope-from ) id 1GJm4U-00025F-FD for pgsql-sql@postgresql.org; Sun, 03 Sep 2006 09:07:10 +0200 Date: Sun, 3 Sep 2006 09:07:10 +0200 From: Andreas Kretschmer To: pgsql-sql@postgresql.org Subject: Re: Mac Address Message-ID: <20060903070710.GA6473@KanotixBox> References: <55c095e90609021342u1728b3farc198d0c87dd7bb83@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <55c095e90609021342u1728b3farc198d0c87dd7bb83@mail.gmail.com> X-OS: Debian/GNU Linux - weil ich es mir Wert bin! X-GPG-Fingerprint: EE16 3C01 7B9C 10F7 2C8B 3B86 4DB3 D9EE 7F45 84DA X-Message-Flag: "Windows" is not the answer. "Windows" is the question and the answer is "no"! X-Lugdd: Gerd Kube X-Info: My name is root. Just root. And I am licensed to kill -9 User-Agent: mutt-ng 1.5.9i (Linux) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.135 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200609/14 X-Sequence-Number: 26225 Ezequias Rodrigues da Rocha schrieb: > Hi list, > > It is possible to retrieve the MAC Address of a computer using a Postgresql > function like others: In the same subnet? Then you can use untrusted languages such as plperlu or plsh to retrieve the MAC for a IP. (arp -a ip) Btw.: please no HTML in eMails. HTH, Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknow) Kaufbach, Saxony, Germany, Europe. N 51.05082, E 13.56889