Re: nginx access logs to mysql

2017-04-20 Thread oscaretu .
I was trying to say you that you don't need to store lots of unnecesary logs when you can store just the valuable information contained in the logs, in a processed way. Why store thousands of log lines that show some called function functionname1 instead of store something like this: { "date"

Re: nginx access logs to mysql

2017-04-20 Thread Reinis Rozitis
I tried to do that with syslog-ng but it doesn't work What exactly didn't work (before writing a longer configuration example)? It's kind of simple with syslog-ng - you set the nginx log file as source / provide mysql as destination and that's it. rr ___

Re: nginx access logs to mysql

2017-04-20 Thread SARA QUISPE MEJIA
yes, I could do it but I want just store for example the customer, the function name, the date after with those information I could filter my report through a page.php But with json I don't know how can I do that? 2017-04-20 9:57 GMT+02:00 oscaretu . : > If you extract the lines containing all

Re: nginx access logs to mysql

2017-04-20 Thread oscaretu .
If you extract the lines containing all the function names, and filter them with a script that counts the number of times that the function appears, you only have to store (for example in a JSON) the number of times that each function was used. And you can avoid storing all the logs in a database.

Re: nginx access logs to mysql

2017-04-20 Thread SARA QUISPE MEJIA
yes, I tried to do that and then I did the analysis with goaccess, but now I need to do an interface(page.php) for the user can choose the function that want to filter and then generate a report. So, I thought put all my information on a database like mysql 2017-04-20 9:11 GMT+02:00 oscaretu . :

Re: nginx access logs to mysql

2017-04-20 Thread oscaretu .
Sara, why don't you process the log file just with grep / pcregrep to get just the lines that containt that function name? On Thu, Apr 20, 2017 at 9:05 AM, SARA QUISPE MEJIA wrote: > I want to parse the log file respect to a client that means to make a > report of how the client is using my app