Pensei, nisto. Reli a simples documentacao do pgfouine. Vi que apenas pede-se para colocar log_line_prefix = 'user=%u,db=%d' o resto é default.
Bom . . . De qualquer forma, tudo bem, eu agradeço a atenção. Obrigado William. William Leite Araújo escreveu: > Fatalmente suas linhas de LOG não estão no formato que o pgfouine aceita. > Precisa ler a documentação pra configurar o servidor para "logar" do jeito > certo... > > Em 02/10/07, Rubens José Rodrigues <[EMAIL PROTECTED]> > escreveu: > >> William, >> >> Este é um dos erros que aparecem : >> "Unrecognized LOG or DEBUG line: user=pgsql,db=apoiorhLOG: PARSER >> STATISTICS - log line 1 >> Unrecognized LOG or DEBUG line: user=pgsql,db=apoiorhLOG: REWRITER >> STATISTICS - log line 25 >> Unrecognized LOG or DEBUG line: user=pgsql,db=apoiorhLOG: PARSER >> STATISTICS - log line 38 >> Unrecognized LOG or DEBUG line: user=pgsql,db=apoiorhLOG: REWRITER >> STATISTICS - log line 62 >> Unrecognized LOG or DEBUG line: user=pgsql,db=apoiorhLOG: PARSER >> STATISTICS - log line 75 >> Unrecognized LOG or DEBUG line: user=pgsql,db=apoiorhLOG: REWRITER >> STATISTICS - log line 99 >> Unrecognized LOG or DEBUG line: user=pgsql,db=apoiorhLOG: PLANNER >> STATISTICS - log line 111 >> Unrecognized LOG or DEBUG line: user=pgsql,db=apoiorhLOG: PARSER >> STATISTICS - log line 123 >> PHP Fatal error: Call to undefined function: appendcontext() in >> >> /usr/share/pgfouine/include/postgresql/lines/PostgreSQLContextLine.class.php >> on line 51 >> [EMAIL PROTECTED] log]$ pgfouine.php -debug -file /var/log/pgsql.log > >> log.html >> Using parser: SyslogPostgreSQLParser >> Using accumulator: PostgreSQLAccumulator >> Using listeners: GlobalCountersListener, SlowestQueriesListener, >> NormalizedQueriesListener >> Memory usage: 1.54 mo >> Unrecognized LOG or DEBUG line: user=pgsql,db=apoiorhLOG: PARSER >> STATISTICS - log line 1 >> we just closed a LogBlock, line number should be 1 and is 2 - log line 2 >> line command number: 1 >> we just closed a LogBlock, line number should be 1 and is 3 - log line 3 >> line command number: 1 >> we just closed a LogBlock, line number should be 1 and is 4 - log line 4 >> line command number: 1 >> we just closed a LogBlock, line number should be 1 and is 5 - log line 5 >> line command number: 1 >> we just closed a LogBlock, line number should be 1 and is 6 - log line 6 >> line command number: 1 >> we just closed a LogBlock, line number should be 1 and is 7 - log line 7 >> line command number: 1 >> we just closed a LogBlock, line number should be 1 and is 8 - log line 8 >> line command number: 1 >> we just closed a LogBlock, line number should be 1 and is 9 - log line 9 >> line command number: 1 >> we just closed a LogBlock, line number should be 1 and is 10 - log line 10 >> line command number: 1 >> we just closed a LogBlock, line number should be 1 and is 11 - log line 11 >> line command number: 1 >> we just closed a LogBlock, line number should be 1 and is 12 - log line 12 >> line command number: 1 >> Unrecognized LOG or DEBUG line: user=pgsql,db=apoiorhLOG: REWRITER >> STATISTICS - log line 25 >> we just closed a LogBlock, line number should be 1 and is 3 - log line 27 >> line command number: 3 >> current block command number: 2 >> we just closed a LogBlock, line number should be 1 and is 4 - log line 28 >> line command number: 3 >> we just closed a LogBlock, line number should be 1 and is 5 - log line 29 >> line command number: 3 >> we just closed a LogBlock, line number should be 1 and is 6 - log line 30 >> line command number: 3 >> we just closed a LogBlock, line number should be 1 and is 7 - log line 31 >> line command number: 3 >> we just closed a LogBlock, line number should be 1 and is 8 - log line 32 >> >> ...... >> >> >> PHP Fatal error: Call to undefined function: appendcontext() in >> >> /usr/share/pgfouine/include/postgresql/lines/PostgreSQLContextLine.class.php >> on line 51 >> >> >> William Leite Araújo escreveu: >> >>> Olhei no código do arquivo. Ele já a inclui... (ini_set( >>> >> 'include_path', >> >>> '.:/usr/share/pgfouine/').. >>> Acrescente a opção -debug e veja se algum erro é mostrado... >>> >>> >>> Em 02/10/07, Rubens José Rodrigues <[EMAIL PROTECTED]> >>> escreveu: >>> >>> >>>> William, >>>> >>>> Inclui o path (no meu caso é /etc/php.ini) e nada. >>>> A mesma mensagem de erro >>>> >>>> Rubens >>>> >>>> William Leite Araújo escreveu: >>>> >>>> >>>>> Bom, sabe onde fica o arquivo de configuração do cliente php >>>>> >>>>> >>>> instalado? >>>> >>>> >>>>> No Debian é /etc/php[5|4]/cli/php.ini >>>>> Procure pela linha "include_path" e veja se acrescentando à mesma >>>>> >> o >> >>>>> diretório "/usr/share/pgfouine/include" não resolve... >>>>> >>>>> >>>>> Em 02/10/07, Rubens José Rodrigues <[EMAIL PROTECTED]> >>>>> escreveu: >>>>> >>>>> >>>>> >>>>>> Olá, >>>>>> >>>>>> Meu Sistema : >>>>>> >>>>>> PostgreSQL 8.2.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) >>>>>> >> 3.4.3 >> >>>>>> 20041212 >>>>>> (Red Hat 3.4.3-9.EL4) >>>>>> >>>>>> Base : 64 GB >>>>>> >>>>>> Memoria : 6 GB >>>>>> >>>>>> 4 Discos SCSI 15K >>>>>> >>>>>> Método de Chamada do pgfouine : pgfouine -file /var/log/pgsql.log >>>>>> >>>>>> >>>>>> >>>>>>> relatorio.html >>>>>>> >>>>>>> >>>>>>> >>>>>> Obrigado >>>>>> >>>>>> Rubens >>>>>> >>>>>> >>>>>> Bom uso o linux >>>>>> William Leite Araújo escreveu: >>>>>> >>>>>> >>>>>> >>>>>>> Em 01/10/07, Rubens J Rodrigues <[EMAIL PROTECTED]> >>>>>>> >>>>>>> >>>>>>> >>>>>> escreveu: >>>>>> >>>>>> >>>>>> >>>>>>>> Pessoal, >>>>>>>> >>>>>>>> Baixei e instalei o pgfouine. >>>>>>>> Estou tentando rodar o log mas aparece a seguinte mensagem : >>>>>>>> >>>>>>>> "PHP Fatal error: Call to undefined function: appendcontext() in >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >> /usr/share/pgfouine/include/postgresql/lines/PostgreSQLContextLine.class.php >> >>>>>>>> on line 51" >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>> Linux? Windows? >>>>>>> Provavelmente um caminho errado nos "includes" (requires) do >>>>>>> >>>>>>> >>>>>>> >>>>>> arquivo. >>>>>> >>>>>> >>>>>> >>>>>>> E não gera o arquivo de saida. >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>>> Alguem pode me indicar uma lista de discussão e ou me ajudar a >>>>>>>> >>>>>>>> >>>>>>>> >>>>>> resolver >>>>>> >>>>>> >>>>>> >>>>>>>> isto? >>>>>>>> >>>>>>>> Obrigado, >>>>>>>> >>>>>>>> att >>>>>>>> >>>>>>>> Rubens J Rodrigues >>>>>>>> >>>>>>>> _______________________________________________ >>>>>>>> pgbr-geral mailing list >>>>>>>> pgbr-geral@listas.postgresql.org.br >>>>>>>> >>>>>>>> >> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>> >> ------------------------------------------------------------------------ >> >>>>>>> _______________________________________________ >>>>>>> pgbr-geral mailing list >>>>>>> pgbr-geral@listas.postgresql.org.br >>>>>>> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>> -- >>>>>> ----------------------------------------- >>>>>> >>>>>> ----------------------------------------- >>>>>> >>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> pgbr-geral mailing list >>>>>> pgbr-geral@listas.postgresql.org.br >>>>>> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >>>>>> >>>>>> >>>>>> >>>>>> >>>>> >>>>> >> ------------------------------------------------------------------------ >> >>>>> _______________________________________________ >>>>> pgbr-geral mailing list >>>>> pgbr-geral@listas.postgresql.org.br >>>>> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >>>>> >>>>> >>>>> >>>> -- >>>> ----------------------------------------- >>>> >>>> ----------------------------------------- >>>> >>>> >>>> >>>> _______________________________________________ >>>> pgbr-geral mailing list >>>> pgbr-geral@listas.postgresql.org.br >>>> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >>>> >>>> >>>> >>> >>> >>> ------------------------------------------------------------------------ >>> >>> _______________________________________________ >>> pgbr-geral mailing list >>> pgbr-geral@listas.postgresql.org.br >>> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >>> >>> >> -- >> >> >> >> _______________________________________________ >> pgbr-geral mailing list >> pgbr-geral@listas.postgresql.org.br >> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >> >> > > > > > ------------------------------------------------------------------------ > > _______________________________________________ > pgbr-geral mailing list > pgbr-geral@listas.postgresql.org.br > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > -- ----------------------------------------- Rubens J Rodrigues Analista de Suporte & TI Depto. de Informática Abrevo do Brasil Distribuidora Ltda. Phone : +55 (27) 2121-8734 Mobile Phone : +55 (27) 9979-0372 Skype-me : rjorodrigues ----------------------------------------- _______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral