Home / user-51312

icc97's questions

Martin Hope
icc97
Asked: 2012-10-18 03:15:54 +0800 CST
  • 0

I want to count file downloads for about 10 different files that a client has asked for. We've generated a separate log format for the apache logs that can be loaded into a MySQL database.

For such a specific query I was hoping to be able to write a SQL statement to count the downloads rather than installing an over-bloated log analyser.

This is the log format used for the MySQL logs:

LogFormat "\"%a\",%{%Y%m%d%H%M%S}t,%>s,\"%b\",\"%{Content-Type}o\", \"%U\",\"%{Referer}i\",\"%{User-Agent}i\"" mysql

This produces this kind of csv file:

"156.107.33.66",20121017113516,200,"10094440","application/x-msdos-program",          "/flexnet/FLEXnetWinSetup.exe","http://www.example.com/downloads/flexnet","Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.4 (KHTML, like Gecko) Chrome/22.0.1229.94 Safari/537.4"

But the larger 100MB+ files are split into chunks so its not a simple count of the logs.

Has anyone tried something similar?

apache-2.2
Martin Hope
icc97
Asked: 2012-06-09 17:03:45 +0800 CST
  • 1

Each plesk vhost only has one user access that httpdocs directory. I want to manage a whole bunch of separate virtual hosts using Git.

Does this mean installing a separate Git repository with a separate user / ssh public key combination for each virtual host or is there a way of centralising it at all?

Gitosis sounds like it might help - but I'm not sure if it gets round pushing the files to each virtual host.

git
Martin Hope
icc97
Asked: 2010-11-18 03:08:19 +0800 CST
  • 1

I'm currently using HTTP for pretty much all downloads. However the files on our UK based server is beings accessed by people all over the world often in 3rd world countries with dodgy internet connections (we give our software free to 3rd world countries).

The file is over 100MB in size and for a minority of people the HTTP download will think its complete after 0.5MB or some trivial amount. Repeated attempts to ask them to download again using HTTP after deleting their IE browser cache sometimes helps.

But what always works is to point them to the same file that they can download via FTP.

I'd always read that there was no advantage to using FTP over HTTP, but is there some kind of extra integrity checking that FTP uses? Is it worth just swapping completely over to FTP for our file downloads?

ftp http