Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Based on your last comment (you should update your question btw) I understand you need something to log all http traffic.</p> <p>You must understand that to do so easily you need to be in the middle between the private network and internet, likely with a linux firewall doing NAT for private network computers.</p> <p>If you are Ok with running non java software then you can use the software urlsnarf from <a href="http://monkey.org/~dugsong/dsniff/" rel="nofollow">dsniff</a> for what you want. You can run it and leave it in the background logging, you can filter also by port or ip.</p> <p>Most distributions already have a package called dsniff which includes the urlsnarf command.</p> <p>For basic start:</p> <pre><code>urlsnarf -n -i eth0 </code></pre> <p>That will start logging to stdout all url's on tcp port 80, 8080 or 3128. If you want to store a capture for later visualization (e.g. with wireshark) you can use <code>-p</code> option. </p> <p>If you ask me, I think you are doing it the wrong way, you should put a transparent proxy and just deny access to "not authorized" sites instead of recording every http url requested. Otherwise you are breaching people privacy and depending on the country it may be even illegal.</p> <p>Setting up a server for NAT it's not difficult, you just need a linux PC with two network cards, one firewall software like <a href="http://rocky.eld.leidenuniv.nl/joomla/" rel="nofollow">aifw</a> or <a href="http://www.bbassett.net/ipmasq/" rel="nofollow">ipmasq</a>, with this you already can prevent access to websites by blocking their IP's. If you also want to mess with http traffic packets data you need a transparent proxy (<a href="http://wiki.squid-cache.org/SquidFaq/ReverseProxy" rel="nofollow">not a reverse proxy</a>), the most popular is <a href="http://wiki.squid-cache.org/" rel="nofollow">Squid</a>.</p> <p>I would recommend to check out <a href="http://www.squidguard.org/" rel="nofollow">SquidGuard</a> if you go for Squid.</p> <p>If you insist in coding one yourself besides warnings lefts on comments, without a doubt you should use <a href="http://netresearch.ics.uci.edu/kfujii/Jpcap/doc/" rel="nofollow">jpcap library</a>, check the <a href="http://netresearch.ics.uci.edu/kfujii/Jpcap/doc/samples.html" rel="nofollow">examples section</a> where there's code already you can use to start quickly.</p> <p>Good luck!</p>
    singulars
    1. This table or related slice is empty.
    1. POsniffing visited sites and save to a file
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USValor
    1. USValor
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COExcuse me, I did not understood you wanted the solution to be done in Java, do you need the sniffing software to be done with Java?
      singulars
      1. PO
      1. USValor
    2. COthank you for the large answer. Fortunately I can refactor all the net of that company, because they bought a new internal program from a software house and need to re-install all the net, so I think there will be no problem to add a computer between the private and the internet, good tip. There will be a written consent, signed by each employee, so no legal problem. I'm starting to following the last paragraph of your answer, it's just install and go or there is something else that need to be coded?
      singulars
      1. PO
      1. USGianmarco
    3. COIt depends on your background, setting up a firewall to do NAT (not transparent proxy but just provide internet) it's pretty easy, you just need to configure your both IP's and tell any of those softwares which interface is internet and which private network. Squid it's a little more trickier but it's not rocket science. Keep in mind that anyway be it NAT or proxied you will be in the middle, so **if your installation fails all company employees es will be offline so I would strongly recommend you to read the manual of whatever software you use in such a project**.
      singulars
      1. PO
      1. USValor
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload