(RADIATOR) Rodopi & Radiator
Mike McCauley
mikem at open.com.au
Thu Feb 6 00:59:08 CST 2003
Hello Tim,
this is looking increasingly like a MS-SQL permissions issue. I am noty very
expert in all the ways you can authenticate access to MS-SQL, but I do know
that named pipes work differently to TCP-IP (which is what the connection
across the network will use).
You might like to run the MS-SQL profile application, connect to the database
(via TCP-IP) as the rodopi user, and confirm whether or not you can run the
Interface_VircomUsers stored procedure by hand.
Cheers.
On Thu, 6 Feb 2003 05:50 pm, Tim Jung wrote:
> 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.
--
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