Date: Fri, 10 Oct 2003 10:33:31 +0300 From: Nada <nadas@inco.com.lb> Subject: RE: [Emerald] Error while processing a custom search Message-id: <5.1.0.14.2.20031010094957.00aa50b0@pop.idm.net.lb>
Hello Dale,
Thank you for the support. I have though a problem with my radius servers
which sometimes stop to respond and block the authentication. We need to
restart it so the activity is back to normal.
The setup we have is as follows:
-----------------------------------------------
We are running radius version 4.0.28. We have 5 radius machines, on the
same LAN with the database server. We have around 3100 phone line
distributed on 36 heterogeneous access servers (we have cisco, livingston,
ascend, tigris).
What is the proper dimensioning of this network? What are the needed radius
machines in terms of memory, operating system, configuration, cpu ... ?
Can we arrive to a situation where we have only 2 Radius machines instead
of 5 ? this will avoid us duplicating machine to load balance the access
servers and leads to minimize the maintenance on these machines.
What is the recommended configuration (one radius backing up the others, or
a circular reference) does it integrate well with Emerald ?
We need to find the best solution for us in order to stop the
authentication failure.
Waiting for your comments,
Regards,
Nada Syriani,
IDM sal.
At 11:32 AM 10/9/2003 -0700, Dale Reed wrote:
>This issue along with the double search results for non-admin users was
>resolved in Emerald 4.5.5. You can download Emerald 4.5.5 from the
>download center on our website:
>
>http://www.iea-software.com/download/
>
>
>-----Original Message-----
>From: emerald-request@iea-software.com
>[mailto:emerald-request@iea-software.com]On Behalf Of Nada
>Sent: Thursday, October 09, 2003 1:50 AM
>To: emerald@iea-software.com
>Cc: support@iea-software.com
>Subject: [Emerald] Error while processing a custom search
>
>
>Hello,
>
>We have just installed the new version of Emerald 4.5.4. When we perform a
>custom search from the user which is not an admin user we get the below
>error. Please check and reply to us how can we solve it.
>
>Thank you for the support,
>Regards,
>Nada Syriani
>IDM sal.
>
>+++ error +++
>
>[Microsoft][ODBC SQL Server Driver][SQL Server]Ambiguous column name 'Data'.
>
>SELECT CASE WHEN ma.Active = 0 THEN 'inactive.gif' WHEN ma.CancelDate IS NOT
>NULL THEN 'canceled.gif' ELSE 'normal.gif' END AS status, ma.FirstName,
>ma.LastName, Company, adt.Description as Login, ad.Data as AccountType,
>ma.CustomerID FROM MasterAccounts ma, MasterAccountData ad,
>MasterAccountDataTypes adt , MetaTables mt, Objects o, OperatorGroupAccess
>oga WHERE ma.CustomerID = ad.CustomerID AND ad.DataTypeID = adt.DataTypeID
>AND ad.DataTypeID = 1 AND Data LIKE '%DM320%' AND mt.MetaTableID = o.Value
>AND o.ObjectTypeID = 2 AND mt.TableName = 'MasterAccounts' AND
>oga.OperatorGroupID = 3 AND oga.ObjectGroupID = o.ObjectGroupID AND
>oga.AccessType & 1 = 1 AND oga.GroupID IN (ma.GroupID,1)