(RADIATOR) Rodopi & Radiator
Tim Jung
tjung at igateway.net
Thu Feb 6 00:50:32 CST 2003
I can confirm that all the supposedly missing or not found stored
procedures are in fact in the AbacBill database. The "rodopi" user in
MS-SQL is the owner of those databases. When I tried to login only via
server login it appeared to lockup and stop responding. If I logged in via
domain login to the NT account "rodopi" you get the output listed below. I
have MS-SQL 7.0 SP3 setup so as to support mixed authentication. The NT
account "rodopi" has membership to the "Administrators" group and the
"Enterprise Admins" group. So it should have full admin rights on the
server.
I did look and see that MS-SQL is setup to support "pipes" and TCP/IP
connections. I have Rodopi setup to talk to MS-SQL over "pipes" since it
all runs on the same machine, the web interface and the database.
For "Interface_VircomDetails" public has EXEC permissions.
For "Interface_VircomDetails" rodopi has no permissions checked.
This is the same for all the other Interface_Vircom* stored procedures.
I even changed it so "rodopi" had EXEC permissions and I get the same
errors.
The SQL user "rodopi" is listed as the owner of both databases and has
"public" in it roles checked as well. When I look at the permission for the
SQL user "rodopi" I don't see checks in the boxes for different security
stuff but since it is the owner of the databases that shouldn't matter
should it? The "rodopi" account through domain login has admin privs so it
should be treated the same as logging in via SQL as the "sa", full
permissions, right?
Any other ideas?
Tim Jung
System Admin
Internet Gateway
tjung at igateway.net
----- Original Message -----
From: "Mike McCauley" <mikem at open.com.au>
To: "Hugh Irvine" <hugh at open.com.au>; "Tim Jung" <tjung at igateway.net>
Cc: <radiator at open.com.au>; "Dave Birkbeck" <dbirkbeck at ikano.com>
Sent: Thursday, February 06, 2003 12:08 AM
Subject: Re: (RADIATOR) Rodopi & Radiator
> Hello Tim,
>
> Hmmm, it appears that the Interface_VircomUsers stored procedure is not
> present in your database (or perhaps you dont have permission to run it).
>
> Can you confiirm whether or not such a stored procedure exists in your
> dbi:Sybase:Rodopi database (it should have been installed by the rodopi
> installation).
>
> Can you confirm that the username rodopi has permission to run that
stored
> procedure?
>
> Cheers.
>
>
> On Thu, 6 Feb 2003 04:59 pm, Hugh Irvine wrote:
> > Hi Tim -
> >
> > Quite right - my apologies (been looking at too many configuration
> > files :-/).
> >
> > I have copied this mail to Mike for further comments.
> >
> > Mike - could you take a look at the trace 4 debug below?
> >
> > regards
> >
> > Hugh
> >
> > On Thursday, Feb 6, 2003, at 16:32 Australia/Melbourne, Tim Jung wrote:
> > > If you look you will see this:
> > >> # Heres how you might connect to the Rodopi MS-SQL
> > >> # database from Unix using DBD-Sybase
> > >> DBSource dbi:Sybase:Rodopi
> > >> DBUsername rodopi
> > >> DBAuth secret
> > >
> > > These are not commented out. If they were I would not even be able to
> > > connect which I am able to do. The "Rodopi" source is defined in the
> > > FreeTDS.conf file, and I do have a login and password for getting in
> > > to the
> > > database.
> > >
> > > Tim Jung
> > > System Admin
> > > Internet Gateway
> > > tjung at igateway.net
> > >
> > >
> > > ----- Original Message -----
> > > From: "Hugh Irvine" <hugh at open.com.au>
> > > To: "Tim Jung" <tjung at igateway.net>
> > > Cc: <radiator at open.com.au>; "Dave Birkbeck" <dbirkbeck at ikano.com>
> > > Sent: Wednesday, February 05, 2003 9:45 PM
> > > Subject: Re: (RADIATOR) Rodopi & Radiator
> > >
> > >> Hello Tim -
> > >>
> > >> In what you show below, there is no DBSource, DBUsername or DBAuth
> > >> (they are commented out).
> > >>
> > >> These *must* be set to enable access to your database (the values
must
> > >> match what has been configured in your database).
> > >>
> > >> regards
> > >>
> > >> Hugh
> > >>
> > >>
> > >> On Thursday, Feb 6, 2003, at 12:11 Australia/Melbourne, Tim Jung
> > >>
> > >> wrote:
> > >>> 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
> > >>> tjung at igateway.net
> > >>>
> > >>>
> > >>> ----- Original Message -----
> > >>> From: "Dave Birkbeck" <dbirkbeck at ikano.com>
> > >>> To: "'Tim Jung'" <tjung at igateway.net>; <radiator at open.com.au>
> > >>> 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:dave at ikano.com
> > >>>> (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 admin at open.com.au
> > >>>
> > >>> 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 = "testikano at igateway.net"
> > >>> 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
> > >>> testikano at igateway.net, 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 = "testikano at igateway.net"
> > >>> 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
> > >>> testikano at igateway.net, 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 = "testikano at igateway.net"
> > >>> 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
> > >>> testikano at igateway.net, 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 radiator-announce at open.com.au
> > >>> To unsubscribe, email 'majordomo at open.com.au' with
> > >>> 'unsubscribe radiator' in the body of the message.
> > >>
> > >> --
> > >> Radiator: the most portable, flexible and configurable RADIUS server
> > >> anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
> > >> -
> > >> Nets: internetwork inventory and management - graphical, extensible,
> > >> flexible with hardware, software, platform and database
independence.
> > >>
> > >> ===
> > >> Archive at http://www.open.com.au/archives/radiator/
> > >> Announcements on radiator-announce at open.com.au
> > >> To unsubscribe, email 'majordomo at open.com.au' with
> > >> 'unsubscribe radiator' in the body of the message.
> > >
> > > ===
> > > Archive at http://www.open.com.au/archives/radiator/
> > > Announcements on radiator-announce at open.com.au
> > > To unsubscribe, email 'majordomo at open.com.au' with
> > > 'unsubscribe radiator' in the body of the message.
>
> --
> Mike McCauley mikem at open.com.au
> Open System Consultants Pty. Ltd Unix, Perl, Motif, C++, WWW
> 24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
> Phone +61 3 9598-0985 Fax +61 3 9598-0955
>
> Radiator: the most portable, flexible and configurable RADIUS server
> anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
> Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS,
> TTLS, PEAP etc on Unix, Windows, MacOS etc.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.
More information about the radiator
mailing list