RE: [RadiusNT] RadiusNT ODBC error

Swick, Forrest ( (no email) )
Wed, 19 Apr 2000 15:44:42 -0600

Graeme,

I can't find the sql queries. I'm using the 45 day trial version. Where to I
get these SQL queries? I looked on ftp.iea-software.com but couldn't find
any.

Thanks in advance.

--Forrest
-----Original Message-----
From: Graeme Slogrove [mailto:Graeme@na.co.za]
Sent: Tuesday, April 18, 2000 11:45 PM
To: radiusnt@iea-software.com
Subject: RE: [RadiusNT] RadiusNT ODBC error

Looks like you haven't updated your tables to handle the new version. Run
the sql queries that come with the distribution (the upgrade one) to add
these columns to your database.

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

For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart