Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Apache Logging to MS SQL Server 2000

Status
Not open for further replies.

JayKusch

MIS
Oct 30, 2001
3,199
US
Evening Folks ...

anyone know of a good man showing how to have Apache Server write its log directly into a SQL Server 2000 table. opsys is Windows 2000 Adv Server.

Thanks
 
We wish to avoid the steps of stopping the Apache Server to cut off the log file, Starting the Apache Server and then having a SQL job run to import it in. We have ported files in this way and there always seems to be an import error we have to fix each and every time. This is why we are trying to have Apache write its log into SQL Server directly. Thanks for the reply and have a great week!
 
Hi,

This should be theoretically possible through the TransferLog directive which supports writing to either a file or a pipe. For example the following would pipe output to the program /usr/bin/whatever :

TransferLog "|/usr/bin/whatever"

See -->
However, for practical use, I don't know whether anyone has actually coded a network aware 'handler' of this kind .

Hope this helps
 
Great Info!!! Thanks and of course keep the ideas coming. will post the solution(s) for everyone when it is achieved
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top