Regards,
Graeme
---Graeme Slogrove, BSc (Eng) Elec (Wits)Director, Systems Development & Value Added ServicesNetActive InternetTel: 011-719-0333 Fax: 011-719-0444Support: 011-719-0300
-----Original Message-----From: Swick, Forrest [mailto:forrest.swick@UNCO.EDU]Sent: 19 April 2000 12:02To: 'radiusnt@iea-software.com'Subject: [RadiusNT] RadiusNT ODBC error
Today I attempted to run radius in the Service mode.
I was unable to radlogin via when the service was started. If i run in -x15mode I can authenticate against the NTSam.
I looked up the ODBC errors on Microsoft Support. I'm wanting to use 3comTotal Control (number 10) to dialin with. I looked in the RadValues Tableand there is no RadVendorID,RadVendorType columns only RadAttributeID, Nameand 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. Anyhelp would be appreciated.--Forrest
Apr 18 15:13:49 2000 [NOTICE]: Testing Datasources...Apr 18 15:13:49 2000 [NOTICE]: Radius = OKODBC Error [07001] -3010:[Microsoft][ODBC Microsoft Access Driver] Too fewparameters. 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 ANDrv.RadVendorID = ra.RadVendorID]Apr 18 15:13:49 2000 [WARNING]: ODBC Error [07001] -3010:[Microsoft][ODBCMicrosoft 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 ANDrv.RadVendorType = ra.RadVendorType AND rv.RadVendorID = ra.RadVendorID]Apr 18 15:13:49 2000 [ERR]: Your Radius database may not haveRadVendorID,RadVendorType columns in the RadValues table. Please seehttp://www.iea-software.com/support for more details. (Falling back to oldquery)Professional features enabled.Apr 18 15:13:53 2000 [NOTICE]: RadiusNT Professional Initialized...
ODBC Error [S0002] -1305:[Microsoft][ODBC Microsoft Access Driver] TheMicrosoft Jet database engine cannot find the input table or query'RadProxyAttributeGroups'. Make sure it exists and that its name is spelledcorrectly. [SELECTapg.RadProxyAttributeGroupID,apg.RadRoamServerID,ap.String,ap.SearchType,ap.RadAttributeID FROM RadProxyAttributeGroups apg, RadProxyAttributes apWHERE apg.RadProxyAttributeGroupID = ap.RadProxyAttributeGroupID ORDER BYapg.Priority ASC, apg.RadProxyAttributeGroupID;]Apr 18 15:13:57 2000 [WARNING]: ODBC Error [S0002] -1305:[Microsoft][ODBCMicrosoft Access Driver] The Microsoft Jet database engine cannot find theinput table or query 'RadProxyAttributeGroups'. Make sure it exists andthat its name is spelled correctly. [SELECTapg.RadProxyAttributeGroupID,apg.RadRoamServerID,ap.String,ap.SearchType,ap.RadAttributeID FROM RadProxyAttributeGroups apg, RadProxyAttributes apWHERE apg.RadProxyAttributeGroupID = ap.RadProxyAttributeGroupID ORDER BYapg.Priority ASC, apg.RadProxyAttributeGroupID;]ODBC Error [07001] -3010:[Microsoft][ODBC Microsoft Access Driver] Too fewparameters. 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 FROMSubAccounts sa, MasterAccounts ma WHERE sa.CustomerID = ma.CustomerIDAND sa.Active <> 0 AND ma.Active <> 0 UNION ALL SELECTsa.AccountID, sa.Shell, sa.Password, '', sa.AccountType, sa.LoginLimit,sa.TimeLeft, DATEDIFF('d','1970-01-01',ma.maExpireDate + ma.Extension) ASMasterExpire, DATEDIFF('d','1970-01-01',saExpireDate + sa.Extension) ASSubExpire 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][ODBCMicrosoft Access Driver] Too few parameters. Expected 2. [SELECTsa.AccountID, sa.Login, sa.Password, '', sa.AccountType, sa.LoginLimit,sa.TimeLeft, DATEDIFF('d','1970-01-01',ma.maExpireDate + ma.Extension) ASMasterExpire, DATEDIFF('d','1970-01-01',saExpireDate + sa.Extension) ASSubExpire FROM SubAccounts sa, MasterAccounts ma WHERE sa.CustomerID= ma.CustomerID AND sa.Active <> 0 AND ma.Active <> 0UNION 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 maWHERE sa.CustomerID = ma.CustomerID AND sa.Active <> 0 ANDma.Active <> 0 ]
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