wget urls / kippo results

[Leon v/d Eijk]

Posted a article on my blog http://lvdeijk.wordpress.com with a list
of used url's where files where downloaded from on/to my kippo box.
Curious if you guys have similar results.

Cheers,
Leon

[mlwrcollect]

Hey,

these are my uniq wgets for:

Begin Log: 2010-07-04 00:00:55 (UTC)
End Log: 2010-09-28 16:00:05 (UTC)

http://www.xs4all.nl/~davewout/log/wget-uniq.txt

Greetz,
Dave

[Jacob]

how are you guys pulling the nice lists of these wget files. I have my dl folder but those files are not as pretty as the list you all posted. :-)

- biosshadow

--
You received this message because you are subscribed to the Google Groups "kippo users" group.
To post to this group, send email to kippo...@googlegroups.com.
To unsubscribe from this group, send email to kippousers+...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/kippousers?hl=en.

[Miguel Jacq]

On Wed, Sep 29, 2010 at 5:47 AM, Jacob <three...@gmail.com> wrote:

how are you guys pulling the nice lists of these wget files. I have my dl folder but those files are not as pretty as the list you all posted. :-)

Probably from the database.

In the latter's case, probably something like SELECT input FROM input WHERE input LIKE '%wget %';

Mig

[Miguel Jacq]

Except I left out the DISTINCT :)

Mig

[Jacob Kuehndorf]

Ahh. I need to add the database then. :-)

[Muhammad Najmi Ahmad Zabidi]

mine like this;

http://pastebin.com/ACmYnRN3

[Leon v/d Eijk]

Yes, you definitely should use a Mysql DB for reporting purposes. Use
Andrew's write-up http://blog.infosanity.co.uk/2010/07/25/kippo-svn-build/
Shout if you need some help.

Leon

On 29 sep, 01:38, Jacob Kuehndorf <jacob.kuehnd...@gmail.com> wrote:
> Ahh. I need to add the database then. :-)

> On Sep 28, 2010 3:25 PM, "Miguel Jacq" <miguel.j...@gmail.com> wrote:
>
> > On Wed, Sep 29, 2010 at 8:24 AM, Miguel Jacq <miguel.j...@gmail.com>
> wrote:

>
> >> On Wed, Sep 29, 2010 at 5:47 AM, Jacob <threedr...@gmail.com> wrote:
>
> >>> how are you guys pulling the nice lists of these wget files. I have my
> dl
> >>> folder but those files are not as pretty as the list you all posted. :-)
>
> >> Probably from the database.
>
> >> In the latter's case, probably something like SELECT input FROM input
> WHERE
> >> input LIKE '%wget %';
>
> > Except I left out the DISTINCT :)
>
> > Mig
>
> > --
> > You received this message because you are subscribed to the Google Groups
>
> "kippo users" group.> To post to this group, send email to kippo...@googlegroups.com.
> > To unsubscribe from this group, send email to
>

> kippousers+...@googlegroups.com<kippousers%2Bunsu...@googlegroups.com>
> .> For more options, visit this group at
>
> http://groups.google.com/group/kippousers?hl=en.
>
>

[Justin Elze]

Anyone else have any useful SQL queries to contribute?

To unsubscribe from this group, send email to kippousers+...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/kippousers?hl=en.

--
IMPORTANT NOTICE: This e-mail and any attachments thereto is intended only
for use by the individual or entity to whom it's addressed and may be
proprietary and/or legally privileged. If you are not the intended
recipient of this e-mail, you are hereby notified that any dissemination,
distribution or copying of this email, and any attachments thereto, without
the prior written permission of the sender is strictly prohibited.   If you
receive this e-mail in error, please immediately telephone or e-mail the
sender and permanently delete the original copy and any copy of this
e-mail, and any printout thereof.

[AndrewWaite]

I'm assuming you've got (or improved on) the simple queries I've
posted previously (http://blog.infosanity.co.uk/2010/07/21/initial-
kippo-honeypot-stats/)?

I'm planning on sticking my head back into the Kippo database this
weekend (currently got my head in Dionaea's), if I find anything
useful I'll let you know.

--Andrew

On 2 Oct, 01:44, Justin Elze <formula...@gmail.com> wrote:
> Anyone else have any useful SQL queries to contribute?
>

> On Wed, Sep 29, 2010 at 1:54 AM, Leon v/d Eijk <lvde...@gmail.com> wrote:
>
>
>
> > Yes, you definitely should use a Mysql DB for reporting purposes. Use

> > Andrew's write-uphttp://blog.infosanity.co.uk/2010/07/25/kippo-svn-build/

> > <kippousers%2Bunsu...@googlegroups.com<kippousers%252Buns...@googlegroups.com>

>
> > > .> For more options, visit this group at
>
> > >http://groups.google.com/group/kippousers?hl=en.
>
> > --
> > You received this message because you are subscribed to the Google Groups
> > "kippo users" group.
> > To post to this group, send email to kippo...@googlegroups.com.
> > To unsubscribe from this group, send email to
> > kippousers+...@googlegroups.com<kippousers%2Bunsu...@googlegroups.com>
> > .
> > For more options, visit this group at
> >http://groups.google.com/group/kippousers?hl=en.
>
> --