From:
<jro...@gm...> - 2006-11-23 12:48:47
|
Hi all the steave metod is work fine. thanks Ronaldo On 11/22/06, Jos=E9 Ronaldo da Silva Costa Junior <jro...@gm...> wrot= e: > > Hi Steven and Brad. > > I will test both situations and I report you. > > Today is not a business day in Rio de Janeiro / Brazil. > > > Regards. > > Jose Ronaldo > > > On 11/22/06, Steven Acreman <sac...@gm...> wrote: > > > > Attached is my modified importer php file. I also use NTLM and this > > works to remove the annoying TCP_DENIED/407 messages. > > > > > > On 21/11/06, Brad Staszcuk <bst...@ar... > wrote: > > > > > > Try this setup.. it is what we use.. it's not the ideal way to do > > > things but it works: > > > > > > } > > > #$query=3D"DELETE FROM `traffic` WHERE `authuser` =3D '-'"; > > > #db_update($query); > > > #$query=3D"DELETE FROM `trafficSummaries` WHERE `usersID` =3D '1'"; > > > #db_update($query); > > > #$query=3D"DELETE FROM `traffic` WHERE `resultCode` =3D 'TCP_DENIED/4= 07'"; > > > #db_update($query); > > > my_exit(0); > > > ?> > > > > > > > > > ------------------------------ > > > *From:* mys...@li... [mailto: > > > mys...@li...] *On Behalf Of *Jos=E9 > > > Ronaldo da Silva Costa Junior > > > *Sent:* November 21, 2006 2:27 PM > > > *To:* mysar support mailing list > > > *Subject:* Re: [mysar-support] About TCP_DENIED/407 > > > > > > > > > Hi *Brad * > > > > > > *Thanks a lot a help* > > > *I tried it, but the mysar-importer still log the user in the table > > > users and the log the access of "-"* > > > ** > > > *When I delete the user, the IP of station still log in the db withou= t > > > user.* > > > ** > > > *Is there other way to deny the insert in the db where resultCode =3D > > > TCP_DENIED/407 ?* > > > ** > > > ** > > > *Jose Ronaldo* > > > > > > > > > > > > On 11/21/06, Brad Staszcuk <bst...@ar... > wrote: > > > > > > > > Change the end of your mysar-importer.php file to look like this: > > > > ... > > > > > > > > > > > > } > > > > #$query=3D"DELETE FROM `traffic` WHERE `authuser` =3D '-'"; > > > > #db_update($query); > > > > #$query=3D"DELETE FROM `traffic` WHERE `resultCode` =3D > > > > 'TCP_DENIED/407'"; > > > > #db_update($query); > > > > my_exit(0); > > > > ?> > > > > > > > > ------------------------------ > > > > *From:* mys...@li... [mailto: > > > > mys...@li...] *On Behalf Of *Jos=E9 > > > > Ronaldo da Silva Costa Junior > > > > *Sent:* November 21, 2006 1:45 PM > > > > *To:* mys...@li... > > > > *Subject:* [mysar-support] About TCP_DENIED/407 > > > > > > > > > > > > Hi everybody, > > > > > > > > I dont understand PHP and I need a help. > > > > > > > > My Squid is configured with NTLM auth mode and every access he log > > > > this event TCP_DENIED/407 and after log the correct user, URL and o= ther > > > > fields. > > > > > > > > I need mysar ignore every TCP_DENIED/407 of access.log because this > > > > event is normal when NTLM auth by groups of Active Directory is set= . > > > > > > > > Thanks a lot. > > > > > > > > > > > > Jose Ronaldo > > > > > > > > > > > > -------------------------------------------------------------------= ------ > > > > Take Surveys. Earn Cash. Influence the Future of IT > > > > Join SourceForge.net's Techsay panel and you'll get the chance to > > > > share your > > > > opinions on IT & business topics through brief surveys - and earn > > > > cash > > > > > > > > http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&= CID=3DDEVDEV > > > > > > > > _______________________________________________ > > > > mysar-support mailing list > > > > mys...@li... > > > > https://lists.sourceforge.net/lists/listinfo/mysar-support > > > > > > > > > > > > > > > > > > > > > ---------------------------------------------------------------------= ---- > > > Take Surveys. Earn Cash. Influence the Future of IT > > > Join SourceForge.net's Techsay panel and you'll get the chance to > > > share your > > > opinions on IT & business topics through brief surveys - and earn cas= h > > > > > > http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CI= D=3DDEVDEV > > > > > > _______________________________________________ > > > mysar-support mailing list > > > mys...@li... > > > https://lists.sourceforge.net/lists/listinfo/mysar-support > > > > > > > > > > > > > > > -----------------------------------------------------------------------= -- > > Take Surveys. Earn Cash. Influence the Future of IT > > Join SourceForge.net's Techsay panel and you'll get the chance to share > > your > > opinions on IT & business topics through brief surveys - and earn cash > > > > http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID= =3DDEVDEV > > > > _______________________________________________ > > mysar-support mailing list > > mys...@li... > > https://lists.sourceforge.net/lists/listinfo/mysar-support > > > > > > > > > |