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 > [EMAIL PROTECTED] > > > ----- Original Message ----- > From: "Mike McCauley" <[EMAIL PROTECTED]> > To: "Hugh Irvine" <[EMAIL PROTECTED]>; "Tim Jung" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]>; "Dave Birkbeck" <[EMAIL PROTECTED]> > 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 > > > > [EMAIL PROTECTED] > > > > > > > > > > > > ----- Original Message ----- > > > > From: "Hugh Irvine" <[EMAIL PROTECTED]> > > > > To: "Tim Jung" <[EMAIL PROTECTED]> > > > > Cc: <[EMAIL PROTECTED]>; "Dave Birkbeck" <[EMAIL PROTECTED]> > > > > 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 > > > >>> [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. > > > >> > > > >> -- > > > >> 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 [EMAIL PROTECTED] > > > >> To unsubscribe, email '[EMAIL PROTECTED]' with > > > >> 'unsubscribe radiator' in the body of the message. > > > > > > > > === > > > > 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. > > > > -- > > Mike McCauley [EMAIL PROTECTED] > > 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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.