Yes, I know the issues with replication. We specifically replicate the
serverports table to our support location server to allow our support
personnel to view the ports online using an ASP page locally.
Since we're only sending changes to serverports using replication, versus
resending an entire HTML file each time they press refresh, this uses far
less bandwidth (on 1400 ports)
Regards,
Graeme
---Graeme Slogrove, BSc (Eng) Elec (Wits)Chief Information Officer, NetActive InternetTel: 011-719-0333 Fax: 011-719-0444Support: 011-719-0300
-----Original Message-----From: Peter Deacon [mailto:peterd@iea-software.com]Sent: 14 September 2000 03:35To: radiusnt@iea-software.comCc: support@iea-software.comSubject: Re: [RadiusNT] ServerPorts problem with Rowguid Column
On Thu, 14 Sep 2000, Graeme Slogrove wrote:
> Hi there, > We are using replication on our tables and therefore the ROWGUID column.> This is giving Radius a problem -
I've got two replies :)
ServerPorts is a hot table who's constantly being updatedwhile anyone logs on/off at the moment. It just keeps track of "who'sonline".
If your replicating in real-time chances are constantly pushingupdates are not worth the overhead/concurrancy cost.
If one is scheduling replication the data in ServerPorts will be too oldto be useful. ServerPorts should be cleared if you start usingthe replicated database.
Therefore I'd exclude the ServerPorts table from replication, even ifROWGUID is not a problem.
If your replicating the calls table and have the calls trigger installedon the replicated database it can keep it's own server-portstable synchronized.
My second idea is to use the database triggers who come /wEmerald/RadiusNT and turn off manual calls update.
Have Fun!Peter
> -----> > SQL Statement: UPDATE ServerPorts SET>AcctSessionId='7C001BEE',UserName='savp',AcctStatusType=1,ConnectInfo='34000>LAPM/V42BIS',CallerId='0113460069',FramedAddress='196.22.188.95',CallDate='2> 0000912 7:18:20',CostPerMinute=NULL,rowguid=NULL,MaxSessionTime=NULL FROM> Servers s, ServerPorts sp WHERE sp.ServerID = s.ServerID AND> COALESCE(sp.IPAddress,s.IPAddress)='196.22.160.103' AND sp.Port=0 AND> ('20000912 7:18:20' >= sp.CallDate OR sp.CallDate IS NULL)> > ODBC Error [37000] 20062:[Microsoft][ODBC SQL Server Driver][SQL> Server]Update of columns with the rowguidcol property is not allowed.> [UPDATE ServerPorts SET>AcctSessionId='7C001BEE',UserName='savp',AcctStatusType=1,ConnectInfo='34000>LAPM/V42BIS',CallerId='0113460069',FramedAddress='196.22.188.95',CallDate='2> 0000912 7:18:20',CostPerMinute=NULL,rowguid=NULL,MaxSessionTime=NULL FROM> Servers s, ServerPorts sp WHERE sp.ServerID = s.ServerID AND> COALESCE(sp.IPAddress,s.IPAddress)='196.22.160.103' AND sp.Port=0 AND> ('20000912 7:18:20' >= sp.CallDate OR sp.CallDate IS NULL)]> > -----> > Radius is trying to set the rowguid to NULL, something that is notallowed.
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart