Ok I went and looked at the configurations you mention and made a few changes. One of them was to try and use domain login rather than server login. It should not have made a difference, since there is both a "rodopi" NT account and SQL account, but all of a sudden I get a lot more information from Radiator. We are also running in mixed-mode authentication so it shouldn't have mattered. I have all the config files and logs below your message Dave, at the end of this message.
Now Radiator says that the account "testikano" doesn't exist when it in fact it does exist in Rodopi. In fact when Rodopi does it standard radius export to a "users" text file it shows up in there. If any of the passwords look strange it is because I changed them for obvious reasons. If your wondering about the port numbers is it because I have our original radius server running on the same machine only on the higher port numbers. So it looks like I am getting closer to getting this working, but it still isn't perfect yet. Any clues as to what exactly I might have screwed up or done wrong? It appears that the "stored procedure 'Interface_VircomUsers'" doesn't exist or it can't find it. So now what the heck am I suppose to do if this is the case? I think if I can just figure out this problem with the stored procedure stuff that it would probably start working. Any help would be appreciated. Tim Jung System Admin Internet Gateway [EMAIL PROTECTED] ----- Original Message ----- From: "Dave Birkbeck" <[EMAIL PROTECTED]> To: "'Tim Jung'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, February 05, 2003 5:55 PM Subject: RE: (RADIATOR) Rodopi & Radiator > Tim, > > What does your config look like? Also, what does your freetds.conf look > like? > > David Birkbeck > Network Engineer > IKANO Communications > mailto:[EMAIL PROTECTED] > (801)415-8022 Phone & FAX ------------------------ radius.cfg ---------------------------- Foreground LogStdout #LogDir . LogDir /var/log/radacct DbDir . DictionaryFile /etc/radiator/dictionary Trace 5 #AuthPort 1645, 1812 #AcctPort 1646, 1813 AuthPort 1645 AcctPort 1646 # # Default # <Client DEFAULT> Secret secret DupInterval 0 </Client> # # Nightowl # <Client 209.176.170.8> Secret secret DupInterval 0 </Client> # #Ikano # <Client 216.126.204.150> Secret secret /Client> <Client 216.126.204.151> Secret secret DupInterval 0 </Client> <Client 216.126.204.152> Secret secret DupInterval 0 </Client> <Client 216.126.204.153> Secret secret DupInterval 0 </Client> <Realm DEFAULT> <AuthBy RODOPI> # Change DBSource, DBUsername, DBAuth for your database # See the reference manual # ON NT, You will need to add a System DSN for Rodopi: # DBSource dbi:ODBC:Rodopi # DBUsername Rodopi # DBAuth secret # Heres how you might connect to the Rodopi MS-SQL # database from Unix using DBD-Sybase DBSource dbi:Sybase:Rodopi DBUsername rodopi DBAuth secret </AuthBy> # You will probably want to keep an accounting log file too # so you can recover from database outages. You will need # to add the URL for this file to the "Online Usage URL's" # page in the Administration section of RODOPI. RODOPI # will automatically rotate it when it is fetched. AcctLogFileName %L/detail </Realm> <Realm igateway.net> RewriteUsername s/^([^@]+).*/$1/ <AuthBy RODOPI> # Change DBSource, DBUsername, DBAuth for your database # See the reference manual # ON NT, You will need to add a System DSN for Rodopi: # DBSource dbi:ODBC:Rodopi # DBUsername Rodopi # DBAuth secret # Heres how you might connect to the Rodopi MS-SQL # database from Unix using DBD-Sybase DBSource dbi:Sybase:Rodopi DBUsername rodopi DBAuth secret </AuthBy> # You will probably want to keep an accounting log file too # so you can recover from database outages. You will need # to add the URL for this file to the "Online Usage URL's" # page in the Administration section of RODOPI. RODOPI # will automatically rotate it when it is fetched. AcctLogFileName %L/detail </Realm> --------------------- freetds.conf ------------------------------ [global] # TDS protocol version tds version = 7.0 initial block size = 512 swap broken dates = no swap broken money = no # Database server login method, if both server and domain # logins are enabled, domain login is tried first if a domain # is specified, and if that fails the server login will be used. try server login = yes try domain login = no # The default authentication domain, can be overridden by # specifying a username with a domain prefix, e.g. DOMAIN\username ; nt domain = WORKGROUP # If the server responds with different domain try that one? cross domain login = no # Whether to write a TDSDUMP file for diagnostic purposes # (setting this to /tmp is insecure on a multi-user system) dump file = /tmp/freetds.log debug level = 10 # Command and connection timeouts timeout = 10; connect timeout = 10; # This is a Sybase hosted database server, if you are directly on the # net you can use it to test. [JDBC] host = 192.138.151.39 port = 4444 tds version = 5.0 # A typical Microsoft SQL Server 7.0 configuration using domain logins [Rodopi] host = billing.igateway.net port = 1433 tds version = 7.0 try domain login = yes try server login = no nt domain = IGATEWAY -------------------- Radiator Debug ------------------------ /usr/bin/radiusd -config_file /etc/radiator/radius.cfg Wed Feb 5 19:57:40 2003: DEBUG: Finished reading configuration file '/etc/radiator/radius.cfg' This Radiator license will expire on 2003-06-01 This Radiator license will stop operating after 1000 requests To purchase an unlimited full source version of Radiator, see http://www.open.com.au/ordering.html To extend your evaluation period, contact [EMAIL PROTECTED] Wed Feb 5 19:57:40 2003: DEBUG: Reading dictionary file '/etc/radiator/dictionary' Wed Feb 5 19:57:42 2003: DEBUG: Creating authentication port 0.0.0.0:1645 Wed Feb 5 19:57:42 2003: DEBUG: Creating accounting port 0.0.0.0:1646 Wed Feb 5 19:57:42 2003: INFO: Server started: Radiator 3.5 on radius.igateway.net (DEMO) Wed Feb 5 19:58:53 2003: DEBUG: Packet dump: *** Received from 206.142.60.79 port 1062 .... Packet length = 108 01 9d 00 6c 31 32 33 34 35 36 37 38 39 30 31 32 33 34 35 36 01 18 74 65 73 74 69 6b 61 6e 6f 40 69 67 61 74 65 77 61 79 2e 6e 65 74 06 06 00 00 00 02 04 06 cb 3f 9a 01 05 06 00 00 04 d2 1e 0b 31 32 33 34 35 36 37 38 39 1f 0b 39 38 37 36 35 34 33 32 31 3d 06 00 00 00 00 02 12 42 05 d9 e1 00 3c e1 71 a9 ae 09 a1 07 78 87 21 Code: Access-Request Identifier: 157 Authentic: 1234567890123456 Attributes: User-Name = "[EMAIL PROTECTED]" Service-Type = Framed-User NAS-IP-Address = 203.63.154.1 NAS-Port = 1234 Called-Station-Id = "123456789" Calling-Station-Id = "987654321" NAS-Port-Type = Async User-Password = "B<5><217><225><0><<225>q<169><174><9><161><7>x<135>!" Wed Feb 5 19:58:53 2003: DEBUG: Handling request with Handler 'Realm=igateway.net' Wed Feb 5 19:58:53 2003: DEBUG: Rewrote user name to testikano Wed Feb 5 19:58:53 2003: DEBUG: Deleting session for [EMAIL PROTECTED], 203.63.154.1, 1234 Wed Feb 5 19:58:53 2003: DEBUG: Handling with Radius::AuthRODOPI Wed Feb 5 19:58:53 2003: DEBUG: Handling with Radius::AuthRODOPI: Wed Feb 5 19:58:53 2003: DEBUG: Query is: exec Interface_VircomUsers 'testikano' Wed Feb 5 19:58:53 2003: ERR: Execute failed for 'exec Interface_VircomUsers 'testikano'': Server message number=2812 severity=16 state=62 line=1 server=BILLINGtext=Could not find stored procedure 'Interface_VircomUsers'. DBI::db=HASH(0x866c298)->disconnect invalidates 1 active statement handle (either destroy statement handles or call finish on them before disconnecting) at /usr/lib/perl5/site_perl/5.6.1/Radius/SqlDb.pm line 273. Wed Feb 5 19:58:53 2003: ERR: Execute failed for 'exec Interface_VircomUsers 'testikano'': Server message number=2812 severity=16 state=62 line=1 server=BILLINGtext=Could not find stored procedure 'Interface_VircomUsers'. DBI::db=HASH(0x866d2a0)->disconnect invalidates 1 active statement handle (either destroy statement handles or call finish on them before disconnecting) at /usr/lib/perl5/site_perl/5.6.1/Radius/SqlDb.pm line 273. Wed Feb 5 19:58:53 2003: DEBUG: Radius::AuthRODOPI looks for match with testikano Wed Feb 5 19:58:53 2003: DEBUG: Query is: exec Interface_VircomUsers 'DEFAULT' Wed Feb 5 19:58:53 2003: ERR: Execute failed for 'exec Interface_VircomUsers 'DEFAULT'': Server message number=2812 severity=16 state=62 line=1 server=BILLINGtext=Could not find stored procedure 'Interface_VircomUsers'. DBI::db=HASH(0x848bd20)->disconnect invalidates 1 active statement handle (either destroy statement handles or call finish on them before disconnecting) at /usr/lib/perl5/site_perl/5.6.1/Radius/SqlDb.pm line 273. Wed Feb 5 19:58:53 2003: ERR: Execute failed for 'exec Interface_VircomUsers 'DEFAULT'': Server message number=2812 severity=16 state=62 line=1 server=BILLINGtext=Could not find stored procedure 'Interface_VircomUsers'. DBI::db=HASH(0x866d324)->disconnect invalidates 1 active statement handle (either destroy statement handles or call finish on them before disconnecting) at /usr/lib/perl5/site_perl/5.6.1/Radius/SqlDb.pm line 273. Wed Feb 5 19:58:53 2003: INFO: Access rejected for testikano: No such user Wed Feb 5 19:58:53 2003: DEBUG: Packet dump: *** Sending to 206.142.60.79 port 1062 .... Packet length = 36 03 9d 00 24 d7 6b e4 9a 1b 91 5f 3e 47 7b a2 0e 1f c6 52 9f 12 10 52 65 71 75 65 73 74 20 44 65 6e 69 65 64 Code: Access-Reject Identifier: 157 Authentic: 1234567890123456 Attributes: Reply-Message = "Request Denied" Wed Feb 5 19:58:53 2003: DEBUG: Packet dump: *** Received from 206.142.60.79 port 1062 .... Packet length = 112 04 9e 00 70 e8 e3 7c 42 1a f9 bb 3f d4 60 50 8d ff c0 45 a7 01 18 74 65 73 74 69 6b 61 6e 6f 40 69 67 61 74 65 77 61 79 2e 6e 65 74 06 06 00 00 00 02 04 06 cb 3f 9a 01 05 06 00 00 04 d2 3d 06 00 00 00 00 2c 0a 30 30 30 30 31 32 33 34 28 06 00 00 00 01 1e 0b 31 32 33 34 35 36 37 38 39 1f 0b 39 38 37 36 35 34 33 32 31 29 06 00 00 00 00 Code: Accounting-Request Identifier: 158 Authentic: <232><227>|B<26><249><187>?<212>`P<141><255><192>E<167> Attributes: User-Name = "[EMAIL PROTECTED]" Service-Type = Framed-User NAS-IP-Address = 203.63.154.1 NAS-Port = 1234 NAS-Port-Type = Async Acct-Session-Id = "00001234" Acct-Status-Type = Start Called-Station-Id = "123456789" Calling-Station-Id = "987654321" Acct-Delay-Time = 0 Wed Feb 5 19:58:53 2003: DEBUG: Handling request with Handler 'Realm=igateway.net' Wed Feb 5 19:58:53 2003: DEBUG: Rewrote user name to testikano Wed Feb 5 19:58:54 2003: DEBUG: Adding session for [EMAIL PROTECTED], 203.63.154.1, 1234 Wed Feb 5 19:58:54 2003: DEBUG: do query is: exec Interface_VircomDetails '00001234', 'Feb 5, 2003 19:58', 'testikano', '203.63.154.1', 1234, 'Framed-User', NULL, NULL, '987654321', NULL, 'Start', 0, NULL, NULL, NULL, NULL, NULL, NULL, 'Async', NULL, '123456789' DBI handle cleared whilst still active at /usr/lib/perl5/site_perl/5.6.1/Radius/Util.pm line 518. DBI Handle has uncleared implementors data at /usr/lib/perl5/site_perl/5.6.1/Radius/Util.pm line 518. dbih_clearcom (sth 0x84fd7e0 0x84eff80, com 0x867abe8, imp DBD::Sybase::st): FLAGS 0x113: COMSET IMPSET Warn PrintError PARENT DBI::db=HASH(0x84fd6a8) KIDS 0 (0 Active) IMP_DATA undef LongReadLen 32768 NUM_OF_FIELDS 0 NUM_OF_PARAMS 0 Wed Feb 5 19:58:54 2003: ERR: do failed for 'exec Interface_VircomDetails '00001234', 'Feb 5, 2003 19:58', 'testikano', '203.63.154.1', 1234, 'Framed-User', NULL, NULL, '987654321', NULL, 'Start', 0, NULL, NULL, NULL, NULL, NULL, NULL, 'Async', NULL, '123456789'': Server message number=2812 severity=16 state=62 line=1 server=BILLINGtext=Could not find stored procedure 'Interface_VircomDetails'. DBI handle cleared whilst still active at /usr/lib/perl5/site_perl/5.6.1/Radius/Util.pm line 518. DBI Handle has uncleared implementors data at /usr/lib/perl5/site_perl/5.6.1/Radius/Util.pm line 518. dbih_clearcom (sth 0x866f3f0 0x86446d0, com 0x8678cf8, imp DBD::Sybase::st): FLAGS 0x113: COMSET IMPSET Warn PrintError PARENT DBI::db=HASH(0x84fd828) KIDS 0 (0 Active) IMP_DATA undef LongReadLen 32768 NUM_OF_FIELDS 0 NUM_OF_PARAMS 0 Wed Feb 5 19:58:54 2003: ERR: do failed for 'exec Interface_VircomDetails '00001234', 'Feb 5, 2003 19:58', 'testikano', '203.63.154.1', 1234, 'Framed-User', NULL, NULL, '987654321', NULL, 'Start', 0, NULL, NULL, NULL, NULL, NULL, NULL, 'Async', NULL, '123456789'': Server message number=2812 severity=16 state=62 line=1 server=BILLINGtext=Could not find stored procedure 'Interface_VircomDetails'. Wed Feb 5 19:58:54 2003: DEBUG: Accounting accepted Wed Feb 5 19:58:54 2003: DEBUG: Packet dump: *** Sending to 206.142.60.79 port 1062 .... Packet length = 20 05 9e 00 14 1a bb 9b 06 1a cb 02 bc 51 b2 30 a9 09 8b fd 92 Code: Accounting-Response Identifier: 158 Authentic: <232><227>|B<26><249><187>?<212>`P<141><255><192>E<167> Attributes: Wed Feb 5 19:58:54 2003: DEBUG: Packet dump: *** Received from 206.142.60.79 port 1062 .... Packet length = 130 04 9f 00 82 04 11 7c 4f 3f a8 e3 41 8b df 76 d1 7d 51 82 96 01 18 74 65 73 74 69 6b 61 6e 6f 40 69 67 61 74 65 77 61 79 2e 6e 65 74 06 06 00 00 00 02 04 06 cb 3f 9a 01 05 06 00 00 04 d2 3d 06 00 00 00 00 2c 0a 30 30 30 30 31 32 33 34 28 06 00 00 00 02 1e 0b 31 32 33 34 35 36 37 38 39 1f 0b 39 38 37 36 35 34 33 32 31 29 06 00 00 00 00 2e 06 00 00 03 e8 2a 06 00 00 4e 20 2b 06 00 00 75 30 Code: Accounting-Request Identifier: 159 Authentic: <4><17>|O?<168><227>A<139><223>v<209>}Q<130><150> Attributes: User-Name = "[EMAIL PROTECTED]" Service-Type = Framed-User NAS-IP-Address = 203.63.154.1 NAS-Port = 1234 NAS-Port-Type = Async Acct-Session-Id = "00001234" Acct-Status-Type = Stop Called-Station-Id = "123456789" Calling-Station-Id = "987654321" Acct-Delay-Time = 0 Acct-Session-Time = 1000 Acct-Input-Octets = 20000 Acct-Output-Octets = 30000 Wed Feb 5 19:58:54 2003: DEBUG: Handling request with Handler 'Realm=igateway.net' Wed Feb 5 19:58:54 2003: DEBUG: Rewrote user name to testikano Wed Feb 5 19:58:54 2003: DEBUG: Deleting session for [EMAIL PROTECTED], 203.63.154.1, 1234 Wed Feb 5 19:58:54 2003: DEBUG: do query is: exec Interface_VircomDetails '00001234', 'Feb 5, 2003 19:58', 'testikano', '203.63.154.1', 1234, 'Framed-User', NULL, NULL, '987654321', NULL, 'Stop', 0, 20000, 30000, 1000, NULL, NULL, NULL, 'Async', NULL, '123456789' DBI handle cleared whilst still active at /usr/lib/perl5/site_perl/5.6.1/Radius/Util.pm line 518. DBI Handle has uncleared implementors data at /usr/lib/perl5/site_perl/5.6.1/Radius/Util.pm line 518. dbih_clearcom (sth 0x84fd624 0x8644c28, com 0x86789f8, imp DBD::Sybase::st): FLAGS 0x113: COMSET IMPSET Warn PrintError PARENT DBI::db=HASH(0x866d534) KIDS 0 (0 Active) IMP_DATA undef LongReadLen 32768 NUM_OF_FIELDS 0 NUM_OF_PARAMS 0 Wed Feb 5 19:58:54 2003: ERR: do failed for 'exec Interface_VircomDetails '00001234', 'Feb 5, 2003 19:58', 'testikano', '203.63.154.1', 1234, 'Framed-User', NULL, NULL, '987654321', NULL, 'Stop', 0, 20000, 30000, 1000, NULL, NULL, NULL, 'Async', NULL, '123456789'': Server message number=2812 severity=16 state=62 line=1 server=BILLINGtext=Could not find stored procedure 'Interface_VircomDetails'. DBI handle cleared whilst still active at /usr/lib/perl5/site_perl/5.6.1/Radius/Util.pm line 518. DBI Handle has uncleared implementors data at /usr/lib/perl5/site_perl/5.6.1/Radius/Util.pm line 518. dbih_clearcom (sth 0x866f468 0x8678de0, com 0x866de38, imp DBD::Sybase::st): FLAGS 0x113: COMSET IMPSET Warn PrintError PARENT DBI::db=HASH(0x866f210) KIDS 0 (0 Active) IMP_DATA undef LongReadLen 32768 NUM_OF_FIELDS 0 NUM_OF_PARAMS 0 Wed Feb 5 19:58:54 2003: ERR: do failed for 'exec Interface_VircomDetails '00001234', 'Feb 5, 2003 19:58', 'testikano', '203.63.154.1', 1234, 'Framed-User', NULL, NULL, '987654321', NULL, 'Stop', 0, 20000, 30000, 1000, NULL, NULL, NULL, 'Async', NULL, '123456789'': Server message number=2812 severity=16 state=62 line=1 server=BILLINGtext=Could not find stored procedure 'Interface_VircomDetails'. Wed Feb 5 19:58:54 2003: DEBUG: Accounting accepted Wed Feb 5 19:58:54 2003: DEBUG: Packet dump: *** Sending to 206.142.60.79 port 1062 .... Packet length = 20 05 9f 00 14 37 58 7c a9 46 f3 52 16 ba b4 5d 8e 26 16 ed da Code: Accounting-Response Identifier: 159 Authentic: <4><17>|O?<168><227>A<139><223>v<209>}Q<130><150> Attributes: === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
