I am catching this thread late, so my apologies if I am restating someone elses ideas...
Some NAS's have a setting that causes them to send periodic accounting records during a session rather than just a start and stop record. Make sure yours are turned off. If you are doing proxying, there may be a server that is replicating the records to two or more servers for redundancy, and they are all being sent back to one accounting server/database. Tim > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Peter Nixon > Sent: Monday, July 28, 2003 2:25 PM > To: Daniel Destro do Carmo > Cc: [EMAIL PROTECTED] > Subject: Re: Duplicated records in MySQL Radacct table. > > > Then the records are not identical. > > I suggest you figure out WHY you are getting duplicated records > in the DB and > fix that. > > I don't use MySQL or the MySQL queries so I can't help you > directly with this, > other than to say, find the cause of the problem rather than > trying to fix > the symptom.. > > Peter > > On Mon July 28 2003 21:37, you wrote: > > I check everything you can imagine... > > > > used distinct, etc... > > nothing works! > > > > > On Thu July 24 2003 23:13, Daniel Destro do Carmo wrote: > > > > Hello All, > > > > > > > > I a program in Java to read the logs recorded in MySQL DB > > > > and > > > > > > then make the billing for each customer's calls. > > > > > > > > I have faced a big problem that is: When I list the record > > > > s > > > > > > from the table radacct or even if I use two table (one for > > > > start and another for stop) I find a lot of duplicated > > > > registers which makes my Billing incorrectly. > > > > > > > > How can I select (using SQL) just the unique records to se > > > > e > > > > > > how many calls and to calculate the total time each user h > > > > as > > > > > > used??? > > > > > > > > Thanks for your time > > > > Daniel > > > > > > Postgres has a UNIQUE keyword, not sure about MySQL.. > > > > > > -- > > > > > > Peter Nixon > > > http://www.peternixon.net/ > > > PGP Key: http://www.peternixon.net/public.asc > > > > > > > > > - > > > List info/subscribe/unsubscribe? See http://www.freeradius.o > > > > rg/list/users.html > > > > > > > > --- > > Acabe com aquelas janelinhas que pulam na sua tela. > > AntiPop-up UOL - � gr�tis! > > http://antipopup.uol.com.br > > -- > > Peter Nixon > http://www.peternixon.net/ > PGP Key: http://www.peternixon.net/public.asc > > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
