Re: access log request without query string

2017-04-20 Thread Frank Liu
I was thinking about lua but the map regex is much better. Thanks! Frank On Thu, Apr 20, 2017 at 2:25 AM, Oleg A. Mamontov wrote: > On Wed, Apr 19, 2017 at 09:23:11PM -0400, Zhang Chao wrote: > > Maybe lua-nginx-module is more convenient :) > > Please don't overcomplicate such a simple task ;)

Spawning of Nginx worker process

2017-04-20 Thread shivramg94
Hi All, When we issue a reload to Nginx binary ( -s reload), what are the steps involved inthe spawning of new set of worker processes? Is it something like, while the older worker processes are still running or are serving in flight requests, Nginx spawns the newer worker processes and then bri

Re: nginx-mail and proxy protocol

2017-04-20 Thread Kees Bos
On do, 2017-04-20 at 17:47 +0300, Maxim Konovalov wrote: > On 20/04/2017 17:41, Kees Bos wrote: > > > > On do, 2017-04-20 at 17:12 +0300, Maxim Konovalov wrote: > > > > > > Hi Kees, > > > > > > On 20/04/2017 17:06, Kees Bos wrote: > > > > > > > > > > > > Hi all, > > > > > > > > Does someone h

execution error - pcre limits exceeded (-8)

2017-04-20 Thread Dino Edwards
Hello, I have compiled nginx 1.12.0 with modsecurity on a Ubuntu 16.04 server and I'm running it as a reverse proxy in front of an Apache webserver which hosts a variety of different type of websites. After enabling modsecurity I'm starting to get a lot of the following errors in the error.log

Re: nginx-mail and proxy protocol

2017-04-20 Thread Maxim Konovalov
On 20/04/2017 17:41, Kees Bos wrote: > On do, 2017-04-20 at 17:12 +0300, Maxim Konovalov wrote: >> Hi Kees, >> >> On 20/04/2017 17:06, Kees Bos wrote: >>> >>> Hi all, >>> >>> Does someone have experience with nginx-mail and the proxy >>> protocol? >>> >>> Does nginx-mail have (or will is get) suppo

Re: nginx-mail and proxy protocol

2017-04-20 Thread Maxim Dounin
Hello! On Thu, Apr 20, 2017 at 05:12:18PM +0300, Maxim Konovalov wrote: > Hi Kees, > > On 20/04/2017 17:06, Kees Bos wrote: > > Hi all, > > > > Does someone have experience with nginx-mail and the proxy protocol? > > > > Does nginx-mail have (or will is get) support for the 'proxy_protocol' >

Re: nginx-mail and proxy protocol

2017-04-20 Thread Kees Bos
On do, 2017-04-20 at 17:12 +0300, Maxim Konovalov wrote: > Hi Kees, > > On 20/04/2017 17:06, Kees Bos wrote: > > > > Hi all, > > > > Does someone have experience with nginx-mail and the proxy > > protocol? > > > > Does nginx-mail have (or will is get) support for the > > 'proxy_protocol' > > pa

request_body capture regex

2017-04-20 Thread Musta Fa
is it possible to capture POST data, but as soon there is a "password" then this word and its value to mask or exclude from log. i was trying to split request_body, but it not working correct: map $request_body $request_body_nopwd { "~(.*)(&|%5B)password(%5D)?\=" $1; } also if request dont have

Re: nginx-mail and proxy protocol

2017-04-20 Thread Maxim Konovalov
Hi Kees, On 20/04/2017 17:06, Kees Bos wrote: > Hi all, > > Does someone have experience with nginx-mail and the proxy protocol? > > Does nginx-mail have (or will is get) support for the 'proxy_protocol' > parameter to the 'listen' directive? > It doesn't. There were no plans for that basically

nginx-mail and proxy protocol

2017-04-20 Thread Kees Bos
Hi all, Does someone have experience with nginx-mail and the proxy protocol? Does nginx-mail have (or will is get) support for the 'proxy_protocol' parameter to the 'listen' directive? Cheers, Kees ___ nginx mailing list nginx@nginx.org http://mailma

Re: upstream - behavior on pool exhaustion

2017-04-20 Thread Ruslan Ermilov
On Wed, Apr 19, 2017 at 05:26:17PM +0200, B.R. via nginx wrote: > On Wed, Apr 19, 2017 at 10:51 AM, Ruslan Ermilov wrote: > > > And what about the next request when all of servers are either "down" > > or "unavailable"? > > > > To me, all the unavailable servers have been 'tried', ie their state

Re: nginx access logs to mysql

2017-04-20 Thread oscaretu .
"date" : "20170420", "functionmname1": 33, "functionmname2": 18, "functionmname3": 51, "functionmname4": 68, ... } In JSON, in a database, or where you want... On Thu, Apr 20, 2017 at 10:10 AM, SARA QUISPE MEJIA wrote: > ye

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: access log request without query string

2017-04-20 Thread Oleg A. Mamontov
On Wed, Apr 19, 2017 at 09:23:11PM -0400, Zhang Chao wrote: > Maybe lua-nginx-module is more convenient :) Please don't overcomplicate such a simple task ;) The following approach should just work: map $request_uri $request_path { ~(?[^?]*) $path; } ---

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

nginx access logs to mysql

2017-04-20 Thread SARA QUISPE MEJIA
I want to parse the log file respect to a client that means to make a report of how the client is using my application through the information provided by a log file. So I need to filter some url where I find an especific name of a function. For that I thought in insert my log file to database li