I was unable to radlogin via when the service was started. If i run in -x15
mode I can authenticate against the NTSam.
I looked up the ODBC errors on Microsoft Support. I'm wanting to use 3com
Total Control (number 10) to dialin with. I looked in the RadValues Table
and there is no RadVendorID,RadVendorType columns only RadAttributeID, Name
and Value.
What's the best way to troubleshot the error?
Following is a the authlog.txt file.
I know I'm close on this and the temporary license will run out soon. Any
help would be appreciated.--Forrest
Apr 18 15:13:49 2000 [NOTICE]: Testing Datasources...
Apr 18 15:13:49 2000 [NOTICE]: Radius = OK
ODBC Error [07001] -3010:[Microsoft][ODBC Microsoft Access Driver] Too few
parameters. Expected 2. [SELECT ra.Name, rv.Name, rv.Value, rv.RadVendorID,
rv.RadVendorType FROM RadValues rv, RadAttributes ra WHERE rv.RadAttributeID
= ra.RadAttributeID AND rv.RadVendorType = ra.RadVendorType AND
rv.RadVendorID = ra.RadVendorID]
Apr 18 15:13:49 2000 [WARNING]: ODBC Error [07001] -3010:[Microsoft][ODBC
Microsoft Access Driver] Too few parameters. Expected 2. [SELECT ra.Name,
rv.Name, rv.Value, rv.RadVendorID, rv.RadVendorType FROM RadValues rv,
RadAttributes ra WHERE rv.RadAttributeID = ra.RadAttributeID AND
rv.RadVendorType = ra.RadVendorType AND rv.RadVendorID = ra.RadVendorID]
Apr 18 15:13:49 2000 [ERR]: Your Radius database may not have
RadVendorID,RadVendorType columns in the RadValues table. Please see
http://www.iea-software.com/support for more details. (Falling back to old
query)
Professional features enabled.
Apr 18 15:13:53 2000 [NOTICE]:
RadiusNT Professional Initialized...
ODBC Error [S0002] -1305:[Microsoft][ODBC Microsoft Access Driver] The
Microsoft Jet database engine cannot find the input table or query
'RadProxyAttributeGroups'. Make sure it exists and that its name is spelled
correctly. [SELECT
apg.RadProxyAttributeGroupID,apg.RadRoamServerID,ap.String,ap.SearchType,ap.
RadAttributeID FROM RadProxyAttributeGroups apg, RadProxyAttributes ap
WHERE apg.RadProxyAttributeGroupID = ap.RadProxyAttributeGroupID ORDER BY
apg.Priority ASC, apg.RadProxyAttributeGroupID;]
Apr 18 15:13:57 2000 [WARNING]: ODBC Error [S0002] -1305:[Microsoft][ODBC
Microsoft Access Driver] The Microsoft Jet database engine cannot find the
input table or query 'RadProxyAttributeGroups'. Make sure it exists and
that its name is spelled correctly. [SELECT
apg.RadProxyAttributeGroupID,apg.RadRoamServerID,ap.String,ap.SearchType,ap.
RadAttributeID FROM RadProxyAttributeGroups apg, RadProxyAttributes ap
WHERE apg.RadProxyAttributeGroupID = ap.RadProxyAttributeGroupID ORDER BY
apg.Priority ASC, apg.RadProxyAttributeGroupID;]
ODBC Error [07001] -3010:[Microsoft][ODBC Microsoft Access Driver] Too few
parameters. Expected 2. [SELECT sa.AccountID, sa.Login, sa.Password, '',
sa.AccountType, sa.LoginLimit, sa.TimeLeft,
DATEDIFF('d','1970-01-01',ma.maExpireDate + ma.Extension) AS MasterExpire,
DATEDIFF('d','1970-01-01',saExpireDate + sa.Extension) AS SubExpire FROM
SubAccounts sa, MasterAccounts ma WHERE sa.CustomerID = ma.CustomerID
AND sa.Active <> 0 AND ma.Active <> 0 UNION ALL SELECT
sa.AccountID, sa.Shell, sa.Password, '', sa.AccountType, sa.LoginLimit,
sa.TimeLeft, DATEDIFF('d','1970-01-01',ma.maExpireDate + ma.Extension) AS
MasterExpire, DATEDIFF('d','1970-01-01',saExpireDate + sa.Extension) AS
SubExpire FROM SubAccounts sa, MasterAccounts ma WHERE sa.CustomerID
= ma.CustomerID AND sa.Active <> 0 AND ma.Active <> 0 ]
Apr 18 15:13:57 2000 [WARNING]: ODBC Error [07001] -3010:[Microsoft][ODBC
Microsoft Access Driver] Too few parameters. Expected 2. [SELECT
sa.AccountID, sa.Login, sa.Password, '', sa.AccountType, sa.LoginLimit,
sa.TimeLeft, DATEDIFF('d','1970-01-01',ma.maExpireDate + ma.Extension) AS
MasterExpire, DATEDIFF('d','1970-01-01',saExpireDate + sa.Extension) AS
SubExpire FROM SubAccounts sa, MasterAccounts ma WHERE sa.CustomerID
= ma.CustomerID AND sa.Active <> 0 AND ma.Active <> 0
UNION ALL SELECT sa.AccountID, sa.Shell, sa.Password, '', sa.AccountType,
sa.LoginLimit, sa.TimeLeft, DATEDIFF('d','1970-01-01',ma.maExpireDate +
ma.Extension) AS MasterExpire, DATEDIFF('d','1970-01-01',saExpireDate +
sa.Extension) AS SubExpire FROM SubAccounts sa, MasterAccounts ma
WHERE sa.CustomerID = ma.CustomerID AND sa.Active <> 0 AND
ma.Active <> 0 ]
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart