how to export squid access.log file in readable format?
Linux - GeneralThis Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
this line is not showing in my squid conf file.. when i open logs file in excel all data are showing in first column... i want to convert access log data in good and proper excel format please help
this line is not showing in my squid conf file.. when i open logs file in excel all data are showing in first column... i want to convert access log data in good and proper excel format please help
You can copy and rename the squid access.log to squid.csv for example. Then you can import the csv file into excel by specifying as separator the "space".
Please note that instead of using excel, you can use sarg to generate reports based on squid logs.
thank you very very much for you help bathory ... these two commands are very help full for me.. Sir can i generate these logs only TCP denied and with specific ip in readable date & time ???
Thanks
Last edited by danialnaeem; 05-16-2014 at 01:19 AM.
thank you very very much for you help bathory ... these two commands are very help full for me.. Sir can i generate these logs only TCP denied and with specific ip in readable date & time ???
Thanks
Please have a look at post #5 to see the change you need to do in access_log format in order to display date in human readable format.
Sir, I am using squid 3.1 and this line is not showing in my squid.conf file. when i add this line in squid.conf file and restart service nothing happenes. ???
access_log /var/log/squid/access.log common
Last edited by danialnaeem; 05-16-2014 at 02:37 AM.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.