aqua gatekeeper sql

This is a discussion on aqua gatekeeper sql within the FreeRADIUS Users forums, part of the Networking and Network Related category; Hi, freeradius-users. I'm using Aqua Gatekeeper to manage voip services. It makes accounting to sql. I've used ...


Go Back   Usenet Forums > Networking and Network Related > FreeRADIUS Users

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 03-16-2005
Dmitriy Milashenko
 
Posts: n/a
Default aqua gatekeeper sql

Hi, freeradius-users.

I'm using Aqua Gatekeeper to manage voip services.
It makes accounting to sql.
I've used src/billing/cisco_h323_db_schema-postgres.sql to create
tables. Table stopvoip have index

create UNIQUE index stopvoipcombo on stopvoip (h323SetupTime, nasipaddress, CallID);

but aqua sends answer and originate accounting records between 2
different clients with the same h323SetupTime. So the second row can
not be inserted into the database...

So the question... Will it be safely to modify this index like

create UNIQUE index stopvoipcombo on stopvoip (h323SetupTime,
nasipaddress, CallID, h323callorign);
--
Thank you,
Dmitriy mailto:jag_subs@ukr.net


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Reply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 06:48 AM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0