[firebase-br] como desconectar estas estacoes ?

Qua Nov 19 18:33:30 -03 2008

delete from mon$attachments
where mon$remote_address = '127.0.0.1'
no firebird 2.x


2008/11/18 Fabiano Martins <fabiano em clippnet.com.br>

>      IP do Cliente Nome do Cliente Prioridade DataBase Usuario Inicio Tempo
> Ultima Atividade
>      192.168.4.44 192.168.4.44 Normal c:\clipp-net\clipp_ar.fdb CLIPP
> 13/11/2008 06:43:11 5.11:28:14 13/11/2008 06:43:11
>      192.168.4.3 192.168.4.3 Normal c:\clipp-net\clipp_ar.fdb SYSDBA
> 13/11/2008 09:20:39 5.08:50:47 13/11/2008 09:21:32
>      C  select RDB$FIELD_SOURCE from RDB$RELATION_FIELDS
>      where (RDB$RELATION_NAME = 'CO_PEDIDOSCOMPRASITENS') and
>      (RDB$FIELD_NAME = 'ITEMPEDIDOCOMPRA')
>     select RDB$FIELD_SOURCE from RDB$RELATION_FIELDS
>      where (RDB$RELATION_NAME = 'CO_PEDIDOSCOMPRASITENS') and
>      (RDB$FIELD_NAME = 'ITEMPEDIDOCOMPRA')
>     select RDB$FIELD_SOURCE from RDB$RELATION_FIELDS
>      where (RDB$RELATION_NAME = 'CO_PEDIDOSCOMPRASITENS') and
>      (RDB$FIELD_NAME = 'ITEMPEDIDOCOMPRA')
>     select RDB$FIELD_SOURCE from RDB$RELATION_FIELDS
>      where (RDB$RELATION_NAME = 'CO_PEDIDOSCOMPRASITENS') and
>      (RDB$FIELD_NAME = 'ITEMPEDIDOCOMPRA')
>     select RDB$FIELD_SOURCE from RDB$RELATION_FIELDS
>      where (RDB$RELATION_NAME = 'CO_PEDIDOSCOMPRASITENS') and
>      (RDB$FIELD_NAME = 'ITEMPEDIDOCOMPRA')
>     13/11/2008 09:21:32 5.08:49:54 13/11/2008 09:21:32
>      {...}  isc_tpb_read_committed, isc_tpb_rec_version, isc_tpb_nowait
> isc_tpb_read_committed, isc_tpb_rec_version, isc_tpb_nowait
> isc_tpb_read_committed, isc_tpb_rec_version, isc_tpb_nowait
> isc_tpb_read_committed, isc_tpb_rec_version, isc_tpb_nowait
> isc_tpb_read_committed, isc_tpb_rec_version, isc_tpb_nowait 13/11/2008
> 09:21:29 5.08:49:57 13/11/2008 09:21:29
>      F  select * from CO_PEDIDOSCOMPRASITENS
>      order by EMPRESA,FILIAL,PEDIDOCOMPRA,ITEMPEDIDOCOMPRA
>     select * from CO_PEDIDOSCOMPRASITENS
>      order by EMPRESA,FILIAL,PEDIDOCOMPRA,ITEMPEDIDOCOMPRA
>     select * from CO_PEDIDOSCOMPRASITENS
>      order by EMPRESA,FILIAL,PEDIDOCOMPRA,ITEMPEDIDOCOMPRA
>     select * from CO_PEDIDOSCOMPRASITENS
>      order by EMPRESA,FILIAL,PEDIDOCOMPRA,ITEMPEDIDOCOMPRA
>     select * from CO_PEDIDOSCOMPRASITENS
>      order by EMPRESA,FILIAL,PEDIDOCOMPRA,ITEMPEDIDOCOMPRA
>     13/11/2008 09:21:29 5.08:49:57 13/11/2008 09:21:29
>      192.168.5.57 192.168.5.57 Normal c:\clipp-net\clipp_ar.fdb CLIPP
> 13/11/2008 09:30:16 5.08:41:10 13/11/2008 09:30:16
>      192.168.5.57 192.168.5.57 Normal c:\clipp-net\clipp_ar.fdb CLIPP
> 13/11/2008 17:41:54 5.00:29:31 13/11/2008 17:41:54
>      192.168.5.210 192.168.5.210 Normal c:\clipp-net\clipp_ar.fdb CLIPP
> 13/11/2008 22:15:16 4.19:56:09 13/11/2008 22:15:17
>      192.168.5.210 192.168.5.210 Normal c:\clipp-net\clipp_ar.fdb CLIPP
> 13/11/2008 22:15:27 4.19:55:59 14/11/2008 02:12:18
>      192.168.5.113 192.168.5.113 Normal c:\clipp-net\clipp_ar.fdb CLIPP
> 13/11/2008 22:35:30 4.19:35:56 13/11/2008 22:35:30
>      192.168.5.113 192.168.5.113 Normal c:\clipp-net\clipp_ar.fdb CLIPP
> 13/11/2008 22:36:01 4.19:35:25 14/11/2008 01:11:21
>      192.168.4.127 192.168.4.127 Normal c:\clipp-net\clipp_ar.fdb CLIPP
> 13/11/2008 23:56:09 4.18:15:17 13/11/2008 23:56:09
>      192.168.4.127 192.168.4.127 Normal c:/clipp-net/clipp_ar.fdb SYSDBA
> 14/11/2008 00:09:34 4.18:01:51 14/11/2008 00:09:40
>      192.168.5.201 192.168.5.201 Normal c:\clipp-net\clipp_ar.fdb CLIPP
> 14/11/2008 13:03:23 4.05:08:03 14/11/2008 20:44:29
>      192.168.5.57 192.168.5.57 Normal c:\clipp-net\clipp_ar.fdb CLIPP
> 14/11/2008 13:52:53 4.04:18:33 14/11/2008 13:52:53
>      192.168.5.57 192.168.5.57 Normal c:\clipp-net\clipp_ar.fdb CLIPP
> 14/11/2008 13:53:02 4.04:18:24 14/11/2008 18:32:38
>      192.168.5.201 192.168.5.201 Normal c:\clipp-net\clipp_ar.fdb CLIPP
> 14/11/2008 20:36:19 3.21:35:07 14/11/2008 20:36:19
>      192.168.5.201 192.168.5.201 Normal c:\clipp-net\clipp_ar.fdb CLIPP
> 14/11/2008 20:36:21 3.21:35:04 15/11/2008 01:27:53
>
> Rodei o fbscanner e vi que ele apresenta varias conexoes atingas e
> inativas.
> Como posso fazer para tirar essas conexoes ?
> ______________________________________________
> FireBase-BR (www.firebase.com.br) - Hospedado em www.locador.com.br
> Para saber como gerenciar/excluir seu cadastro na lista, use:
> http://www.firebase.com.br/fb/artigo.php?id=1107
> Para consultar mensagens antigas: http://firebase.com.br/pesquisa
>


-- 
Abs
Daniel A. Bastos