Navigacija
Lista poslednjih: 16, 32, 64, 128 poruka.

Citanje IP adrese

[es] :: Firebird/Interbase :: Citanje IP adrese

[ Pregleda: 3449 | Odgovora: 2 ] > FB > Twit

Postavi temu Odgovori

Autor

Pretraga teme: Traži
Markiranje Štampanje RSS

darko_sudarov
ProConto Software doo
Kikinda

Član broj: 89262
Poruke: 136
82.208.201.*



Profil

icon Citanje IP adrese23.07.2007. u 10:59 - pre 203 meseci
Postoji li neka SQL konmanda (FIREBIRD 2.0) koja moze da iscita IP adresu korisnika koji se loguje na bazu?
 
Odgovor na temu

Mr. Rejn
Deki Karamatijević
Sremčica

Član broj: 2514
Poruke: 515
*.adsl.sezampro.yu.



+4 Profil

icon Re: Citanje IP adrese23.07.2007. u 20:43 - pre 203 meseci
^
Firebird 2.0.1 ima f-je tipa rdb$get_context i rdb$set_context za uzimanje/postavljanje
kontekstualnih promenljivih (ovo inače imaš na strani 33 Release notes za FB 2.0.1-
"New System Functions to Retrieve Context Variables",pa baci pogled ako imaš tu verziju
na mašini),npr:
Code:

SELECT
rdb$get_context('SYSTEM', 'CURRENT_USER'),
rdb$get_context('SYSTEM', 'SESSION_ID'),
rdb$get_context('SYSTEM', 'CLIENT_ADDRESS'),
current_timestamp
FROM rdb$database;

samo obrati pažnju u kom formatu dobijaš vrednosti za CLIENT_ADDRESS jer to za-
visi od vrste protokola:
Citat:

CLIENT_ADDRESS :: The wire protocol address of the remote client, represented as a string. The value is
an IP address in form "xxx.xxx.xxx.xxx" for TCPv4 protocol; the local process ID for XNET protocol; and
NULL for any other protocol.

npr. ovo gore daje:
Code:

RDB$GET_CONTEXT                                                                                                                                                                                                                                      
      RDB$GET_CONTEXT                                                                                                                                                                                                                                
            RDB$GET_CONTEXT                                                                                                                                                                                                                         
                          CURRENT_TIMESTAMP 
================================
================================ 
================================
SYSDBA                                                                                                                                                                                                                                          
      3                                                                                                                                                                                                                                  
            3720                                                                                                                                                                                                              
                  2007-07-23 21:28:46.1090 


3720 je lokalni process ID jer je povezan u lokalu (XNET).
Primer trigera (on connect i on disconnect) i tabela za logovanje konekcija uz upotrebu ovih f-ja imaš recimo
ovde: http://pabloj.blogspot.com/200...alpha-quick-glance-at-new.html (ovaj tip trigera postoji
za sada samo na 2.1,mislim da je beta 1 vec spremna za download).


Pozdrav,
Deki


[Ovu poruku je menjao Mr. Rejn dana 23.07.2007. u 22:02 GMT+1]
Ag + Na -> Xe
 
Odgovor na temu

darko_sudarov
ProConto Software doo
Kikinda

Član broj: 89262
Poruke: 136
82.208.201.*



Profil

icon Re: Citanje IP adrese08.08.2007. u 12:40 - pre 202 meseci
Zaboravio sam da se zahvalim,svaka cast na informisanosti Mr.Rejn.Puno pozdrava!
 
Odgovor na temu

[es] :: Firebird/Interbase :: Citanje IP adrese

[ Pregleda: 3449 | Odgovora: 2 ] > FB > Twit

Postavi temu Odgovori

Navigacija
Lista poslednjih: 16, 32, 64, 128 poruka.