(RADIATOR) Problem in installing DBD-ODBC
Hello All, I am facing problems in installing DBD-ODBC with DBD-DBI. I am using SQL server2000 with Radiator-3.6 installed on Solaris.7 with Perl version 5.6.1. When i m installing DBD-ODBC1.06 with DBD-DBI1.37 facing this error. "Makefile:297: *** missing separator. Stop." I have tried other versions of DBD-ODBC till 0.39 but giving same error. well with DBD-ODBC 0.38 its all working fine. Its an old version so any one face any strange problem like this ?? waiting for replies, Mushtaque. ___ This email and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to which they are addressed. This communication represents the originator's personal views and opinions, which do not necessarily reflect those of eWorld (Pvt) Ltd. If you are not the original / intended recipient or the person responsible for delivering the email to the intended recipient, be advised that you have received this email in error, and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error, we regret the inconvenience and request you to please immediately notify at [EMAIL PROTECTED] === 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.
Re: (RADIATOR) error in installing DBD-ODBC
Hello Hugh! Here the Information you asked for! ODBC openlink 3.0 hardware sparc (netra 105) software solaris 7 perl version 5.8.0 and we have tired DBD-ODBC-1.06 and i think this is the latest Driver on CPAN. regards, Mushtaque. ___ This email and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to which they are addressed. This communication represents the originator's personal views and opinions, which do not necessarily reflect those of eWorld (Pvt) Ltd. If you are not the original / intended recipient or the person responsible for delivering the email to the intended recipient, be advised that you have received this email in error, and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error, we regret the inconvenience and request you to please immediately notify at [EMAIL PROTECTED] - Original Message - From: Hugh Irvine <[EMAIL PROTECTED]> Date: Monday, August 25, 2003 6:44 am Subject: Re: (RADIATOR) error in installing DBD-ODBC > > Hello Mushtaque - > > This would appear to be a problem with DBD-ODBC - have you tried a > different version? > > And what ODBC driver are you using? > > What hardware/software platform are you running on and what > version of > Perl? > > regards > > Hugh > > > On Sunday, Aug 24, 2003, at 00:35 Australia/Melbourne, Muhammad > Mushtaque wrote: > > > Hello All, > > > > I am trying to install DBD-ODBC-1.06. > > > > I am having some problems in installing DBD-ODBC. After compiling > > Makefile.pl i m getting following error after compiling Makefile > which> is created by perl. > > > > Makefile:311: *** missing separator. Stop. > > > > Any ideas abt it? > > > > waiting for replies, > > > > regards, > > > > Mushtaque. > > > > > > ___ > > This email and any files transmitted with it are confidential > and are > > intended solely for the use of the individual or entity to which > they> are addressed. This communication represents the > originator's personal > > views and opinions, which do not necessarily reflect those of eWorld > > (Pvt) Ltd. If you are not the original / intended recipient or the > > person responsible for delivering the email to the intended > recipient,> be advised that you have received this email in error, > and that any > > use, dissemination, forwarding, printing, or copying of this > email is > > strictly prohibited. If you have received this email in error, we > > regret the inconvenience and request you to please immediately > notify> at [EMAIL PROTECTED] > > > > === > > Archive at http://www.open.com.a > > Announcements on [EMAIL PROTECTED] > > To unsubscribe, email '[EMAIL PROTECTED]' with > > 'unsubscribe radiator' in the body of the message. > > > > > > NB: have you included a copy of your configuration file (no secrets), > together with a trace 4 debug showing what is happening? > > -- > Radiator: the most portable, flexible and configurable RADIUS server > anywhere. Available on *NIX, *BSD, Windows, MacOS X. > - > Nets: internetwork inventory and management - graphical, extensible, > flexible with hardware, software, platform and database independence. > > === > Archive at http://www.open.com.a > 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.
(RADIATOR) error in installing DBD-ODBC
Hello All, I am trying to install DBD-ODBC-1.06. I am having some problems in installing DBD-ODBC. After compiling Makefile.pl i m getting following error after compiling Makefile which is created by perl. Makefile:311: *** missing separator. Stop. Any ideas abt it? waiting for replies, regards, Mushtaque. ___ This email and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to which they are addressed. This communication represents the originator's personal views and opinions, which do not necessarily reflect those of eWorld (Pvt) Ltd. If you are not the original / intended recipient or the person responsible for delivering the email to the intended recipient, be advised that you have received this email in error, and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error, we regret the inconvenience and request you to please immediately notify at [EMAIL PROTECTED] === 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) Radiator session hangs
Hello All, I am using Radiator-3.5 with SQL2000 and Platypus. Few of our users are getting the error showed in attached file. After this Error radiator hangs for a little time and our other users are also getting the error of timeout because radiator quites after this error or seems to be like hangs. In the above file user was trying to get ip from platypus. but after restarting radius, user was easily able to get ip from platypus. anybody experience this situation? waiting for suggestions, Mushtaque. __ This email and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to which they are addressed. This communication represents the originator's personal views and opinions, which do not necessarily reflect those of eWorld (Pvt) Ltd. If you are not the original / intended recipient or the person responsible for delivering the email to the intended recipient, be advised that you have received this email in error, and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error, we regret the inconvenience and request you to please immediately notify at [EMAIL PROTECTED] on Aug 18 01:54:52 2003: DEBUG: Handling request with Handler 'Realm=DEFAULT' on Aug 18 01:54:52 2003: DEBUG: Deleting session for irfan_haider, 202.63.217. 45, 64 on Aug 18 01:54:52 2003: DEBUG: Handling with Radius::AuthEMERALD on Aug 18 01:54:52 2003: DEBUG: Handling with Radius::AuthEMERALD: ID_0 on Aug 18 01:54:52 2003: DEBUG: Query is: select DateAdd(Day, ma.extension+ma.o erdue, maExpireDate), ateAdd(Day, sa.extension, saExpireDate), sa.AccountID, sa.AccountType, a.password, sa.login, sa.shell, sa.TimeLeft ,sa.LoginLimit,sa.cli4 rom masteraccounts ma, subaccounts sa here (sa.login = 'irfan_haider' or sa.shell = 'irfan_haider') nd ma.customerid = sa.customerid nd sa.active <> 0 and ma.active <> 0 on Aug 18 01:54:53 2003: DEBUG: Select results: 2004-08-18 01:52:42.06, 2004-08 18 01:52:42.06, 6556, eDedicated, pakistan, irfan_haider, , 2903, 2 on Aug 18 01:54:53 2003: DEBUG: Query is: select dn.DNISNumber from AccountType a, NISNumbers dn where a.AccountType='eDedicated' and a.DNISGroupID=dn.DNISGroupID nd dn.DNISNumber='7159' on Aug 18 01:54:53 2003: DEBUG: Query is: select sa.StartTime, sa.StopTime, a.MaxSessionLength from Servers s, ServerAccess sa here s.IPAddress='DEFAULT' nd s.ServerID = sa.ServerID nd sa.Port=64 nd sa.AccountType='eDedicated' BD::ODBC::st fetchrow failed: [OpenLink][ODBC][Driver]Function sequence error ( QL-S1010)(DBD: st_fetch/SQLFetch err=-1) at Radius/AuthEMERALD.pm line 188. on Aug 18 01:54:53 2003: DEBUG: Query is: select ra.RadAttributeID, ra.RadVendo ID, a.RadVendorType, ata, Value, Type, RadCheck rom RadConfigs rc, RadAttributes ra here ra.RadAttributeID = rc.RadAttributeID nd ra.RadVendorID = rc.RadVendorID nd ra.RadVendorType = rc.RadVendorType nd rc.AccountID=6556 on Aug 18 01:54:53 2003: DEBUG: Radius::AuthEMERALD looks for match with irfan_ aider on Aug 18 01:54:53 2003: DEBUG: Expiration date converted to: 1092805200 on Aug 18 01:54:53 2003: DEBUG: Expiration date converted to: 1092805200 on Aug 18 01:54:53 2003: DEBUG: Radius::AuthEMERALD ACCEPT: on Aug 18 01:54:53 2003: DEBUG: Access accepted for irfan_haider = Mon Aug 18 01:57:44 2003: DEBUG: Select results: 2004-08-18 01:55:33.73, 2004-08 -18 01:55:33.73, 6556, eDedicated, pakistan, irfan_haider, , 2903, 2 Mon Aug 18 01:57:44 2003: DEBUG: Query is: select dn.DNISNumber from AccountType s a, DNISNumbers dn where a.AccountType='eDedicated' and a.DNISGroupID=dn.DNISGroupID and dn.DNISNumber='7159' Mon Aug 18 01:57:44 2003: DEBUG: Query is: select sa.StartTime, sa.StopTime, sa.MaxSessionLength from Servers s, ServerAccess sa where s.IPAddress='DEFAULT' and s.ServerID = sa.ServerID and sa.Port=78 and sa.AccountType='eDedicated' DBD::ODBC::st fetchrow failed: [OpenLink][ODBC][Driver]Function sequence error ( SQL-S1010)(DBD: st_fetch/SQLFetch err=-1) at Radius/AuthEMERALD.pm line 188. Mon Aug 18 01:57:44 2003: DEBUG: Query is: select ra.RadAttributeID, ra.RadVendo rID, ra.RadVendorType,
Re: (RADIATOR) Allowing password caseinsensitive.
Dear All, sorry, i m resending question. I m using radiator3.5 with MS SQL2000. I want to authenticate users with caseinsensitive password through Database.what type of changes i hve to do in cfg file? waiting for replies, Regards Mushtaque. ___ This email and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to which they are addressed. This communication represents the originator's personal views and opinions, which do not necessarily reflect those of eWorld (Pvt) Ltd. If you are not the original / intended recipient or the person responsible for delivering the email to the intended recipient, be advised that you have received this email in error, and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error, we regret the inconvenience and request you to please immediately notify at [EMAIL PROTECTED] - Original Message - From: "Muhammad Mushtaque" <[EMAIL PROTECTED]> Date: Saturday, July 5, 2003 0:58 am Subject: (RADIATOR) Allowing password in Upper case. > Dear All, > > I m using radiator3.5 with MS SQL2000. > I want to authenticate users with Upper case password through > Database.what type of changes i hve to do in cfg file? > > waiting for replies, > > Regards > > Mushtaque. > > > ___ > This email and any files transmitted with it are confidential and > are > intended solely for the use of the individual or entity to which > they > are addressed. This communication represents the originator's > personal > views and opinions, which do not necessarily reflect those of > eWorld > (Pvt) Ltd. If you are not the original / intended recipient or > the > person responsible for delivering the email to the intended > recipient, > be advised that you have received this email in error, and that > any > use, dissemination, forwarding, printing, or copying of this email > is > strictly prohibited. If you have received this email in error, we > regret the inconvenience and request you to please immediately > notify > at [EMAIL PROTECTED] > > === > Archive at http://www.open.com.a > 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.
(RADIATOR) Allowing password in Upper case.
Dear All, I m using radiator3.5 with MS SQL2000. I want to authenticate users with Upper case password through Database. what type of changes i hve to do in cfg file? waiting for replies, Regards Mushtaque. ___ This email and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to which they are addressed. This communication represents the originator's personal views and opinions, which do not necessarily reflect those of eWorld (Pvt) Ltd. If you are not the original / intended recipient or the person responsible for delivering the email to the intended recipient, be advised that you have received this email in error, and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error, we regret the inconvenience and request you to please immediately notify at [EMAIL PROTECTED] === 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) radiator stops ...
Hi All, I hve upgraded to Radiator version 3.0 from 2.17. Radius is running on Solaris and we r using openlink for database access.Every thing was working fine ... but suddenly radiator stops and kills its process with the following error --- [OpenLink][ODBC][SQL Server]Violation of PRIMARY KEY constraint 'pk_RadLogs'. Ca nnot insert duplicate key in object 'RadLogs'. (SQL-S1000)(DBD: st_execute/SQLEx ecute err=-1) at Radius/SqlDb.pm line 218. DBD::ODBC::db do failed: (Unable to fetch information about the error) (DBD: st_p repare/SQLAllocStmt err=-1) at Radius/SqlDb.pm line 218. DBD::ODBC::db do failed: (Unable to fetch information about the error) (DBD: st_p repare/SQLAllocStmt err=-1) at Radius/SqlDb.pm line 218. DBD::ODBC::db do failed: (Unable to fetch information about the error) (DBD: st_p repare/SQLAllocStmt err=-1) at Radius/SqlDb.pm line 218. DBD::ODBC::db do failed: (Unable to fetch information about the error) (DBD: st_p repare/SQLAllocStmt err=-1) at Radius/SqlDb.pm line 218. DBD::ODBC::db do failed: (Unable to fetch information about the error) (DBD: st_p repare/SQLAllocStmt err=-1) at Radius/SqlDb.pm line 218. DBD::ODBC::db do failed: (Unable to fetch information about the error) (DBD: st_p repare/SQLAllocStmt err=-1) at Radius/SqlDb.pm line 218. DBD::ODBC::db do failed: (Unable to fetch information about the error) (DBD: st_p repare/SQLAllocStmt err=-1) at Radius/SqlDb.pm line 218. DBD::ODBC::db do failed: (Unable to fetch information about the error) (DBD: st_p repare/SQLAllocStmt err=-1) at Radius/SqlDb.pm line 218. Out of memory during "large" request for 16781312 bytes at /usr/local/lib/perl5/ site_perl/5.6.0/sun4-solaris/DBI.pm line 903. Attempt to free unreferenced scalar during global destruction. waiting for replies regards Mushtaque. ___ This email and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to which they are addressed. This communication represents the originator's personal views and opinions, which do not necessarily reflect those of eWorld (Pvt) Ltd. If you are not the original / intended recipient or the person responsible for delivering the email to the intended recipient, be advised that you have received this email in error, and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error, we regret the inconvenience and request you to please immediately notify at [EMAIL PROTECTED] === 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.
Re: (RADIATOR) little help required ...
Hi Tunde, I m trying to do so, but again i hve to pass same multiple AcctSQLStatement on that version also ... you mean that we will not get this error in version 3.3.1. is it ?? or u hve some idea that why we are getting this overflow error? regards, Mushtaque. ___ This email and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to which they are addressed. This communication represents the originator's personal views and opinions, which do not necessarily reflect those of eWorld (Pvt) Ltd. If you are not the original / intended recipient or the person responsible for delivering the email to the intended recipient, be advised that you have received this email in error, and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error, we regret the inconvenience and request you to please immediately notify at [EMAIL PROTECTED] - Original Message - From: "Ayotunde Itayemi" <[EMAIL PROTECTED]> Date: Tuesday, November 26, 2002 2:19 pm Subject: Re: (RADIATOR) little help required ... > Hi Muhammad, > Why not upgrade to version 3.3.1 ? > > Regards, > Tunde I. > > - Original Message - > From: "Muhammad Mushtaque" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, November 26, 2002 9:29 AM > Subject: (RADIATOR) little help required ... > > > > Dear All, > > > > We are facing a problem due to which radiator session hangs. > Actually i > > m executing few AcctSqlStatement for inserting some values in > Database. > > When calculation goes to infinity like (2/3 or 1/3) ... radiator > gives > > over flow error ... the other thing is that we are facing this > error in > > Radiator-3.0 not in Radiator 2.17 ... I m attaching the error > and our > > config file with this mail. > > > > waiting for replies > > > > Mushtaque. > > > > ___ > > This email and any files transmitted with it are confidential > and are > > intended solely for the use of the individual or entity to which > they > > are addressed. This communication represents the originator's > personal > > views and opinions, which do not necessarily reflect those of > eWorld > > (Pvt) Ltd. If you are not the original / intended recipient or > the > > person responsible for delivering the email to the intended > recipient, > > be advised that you have received this email in error, and that > any > > use, dissemination, forwarding, printing, or copying of this > email is > > strictly prohibited. If you have received this email in error, > we > > regret the inconvenience and request you to please immediately > notify > > at [EMAIL PROTECTED] > > > > === > Archive at http://www.open.com.a > 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.
(RADIATOR) little help required ...
Dear All,
We are facing a problem due to which radiator session hangs. Actually i
m executing few AcctSqlStatement for inserting some values in Database.
When calculation goes to infinity like (2/3 or 1/3) ... radiator gives
over flow error ... the other thing is that we are facing this error in
Radiator-3.0 not in Radiator 2.17 ... I m attaching the error and our
config file with this mail.
waiting for replies
Mushtaque.
___
This email and any files transmitted with it are confidential and are
intended solely for the use of the individual or entity to which they
are addressed. This communication represents the originator's personal
views and opinions, which do not necessarily reflect those of eWorld
(Pvt) Ltd. If you are not the original / intended recipient or the
person responsible for delivering the email to the intended recipient,
be advised that you have received this email in error, and that any
use, dissemination, forwarding, printing, or copying of this email is
strictly prohibited. If you have received this email in error, we
regret the inconvenience and request you to please immediately notify
at [EMAIL PROTECTED]
Sat Nov 23 13:05:41 2002: DEBUG: Handling request with Handler 'Realm=DEFAULT'
Sat Nov 23 13:05:41 2002: DEBUG: Deleting session for nawaz32, 202.63.217.241, 47
Sat Nov 23 13:05:41 2002: DEBUG: Handling with Radius::AuthEMERALD
Sat Nov 23 13:05:41 2002: DEBUG: Handling accounting with Radius::AuthEMERALD
Sat Nov 23 13:05:41 2002: DEBUG: do query is: update scratchcustomer set
timeleft=timeleft-('015553'/60) where scratchcustomer.username ='nawaz32'
Sat Nov 23 13:05:41 2002: DEBUG: do query is: update scratchcustomer set
expire_date=dateadd(m,1,getdate()),expirevalue=1,activation_date=getdate() where
username='nawaz32' and expirevalue=0
Sat Nov 23 13:05:41 2002: DEBUG: do query is: update customer set
amount=amount-('015553'/3600.00)*Monthlyprice from e30TimeYearly,customer where
customer.username ='nawaz32' and customer.accttype='e30TimeYearly'
Sat Nov 23 13:05:42 2002: ERR: do failed for 'update customer set
amount=amount-('015553'/3600.00)*Monthlyprice from e30TimeYearly,customer where
customer.username ='nawaz32' and customer.accttype='e30TimeYearly'': [Microsoft][ODBC
SQL Server Driver][SQL Server]Arithmetic overflow error converting numeric to data
type numeric. (SQL-22003)
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
(SQL-01000)(DBD: st_execute/SQLExecute err=-1)
Sat Nov 23 13:06:05 2002: DEBUG: Adding Clients from SQL database
Sat Nov 23 13:06:05 2002: DEBUG: Query is: select IPAddress,secret from Servers
Sat Nov 23 13:06:05 2002: INFO: Server started: Radiator 3.0 on development
Sat Nov 23 13:06:21 2002: DEBUG: Packet dump:
#RunAsDaemon: yes
# emerald.cfg
#
# Example Radiator configuration file that allows you to
# authenticate from and store accounting to the Emerald database
# from IEA (see http://www.iea-software.com), or from
# Platypus (see www.platypus.com) from Boradtown when running
# the RadiusNT compatibility mode.
# Caution: this config file and AuthBy EMERALD will not work with
# non-standard dictionary file.
#
# You should consider this file to be a starting point only
# $Id: emerald.cfg,v 1.5 2000/08/21 04:33:08 mikem Exp $
#DateFormat %b %e, %Y %H:%M:%S
Foreground
LogStdout
DbDir .
LogDir .
LogFile ./detail
Trace 4
# You will probably want to change this to suit your site.
Secret
IgnoreAcctSignature
DupInterval 2
FramedGroupBaseAddress *
DefaultSimultaneousUse 1
Filename %D/users
Nocache
Identifier ID_1
# Change DBSource, DBUsername, DBAuth for your database
# See the reference manual
# Default username and password for Platypus
# Typical username and password for Emerald. Make
# sure that you have added the users, and made their
# default database the Emerald database
# DBUsername emeralduser
# DBAuth emeralduser
# You can add to or change these if you want.
DBSourcedbi:ODBC:
DBUsername ***
DBAuth *
AccountingTable Calls
AcctColumnDef UserName,User-Name
AcctColumnDef CallDate,Timestamp,integer-date
AcctColumnDef AcctStatusType,Acct-Status-Type,integer
AcctColumnDef AcctDelayTime,Acct-Delay-Time,integer
AcctColumnDef AcctInputOctets,Acct-Input-Octets,integer
AcctColumnDef AcctOutputOctets,Acct-Output-Octets,integer
AcctColumnDef AcctS
(RADIATOR) help required ...
Hi All, I am using Radiator-3.0 and DB on SQL Server. I am implementing CLI through DB from more than one number ... radiator just read only the number from the first field not going to the second one ... i m attaching my configuration file and detail showing error. waiting for replies, Mushtaque. ___ This email and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to which they are addressed. This communication represents the originator's personal views and opinions, which do not necessarily reflect those of eWorld (Pvt) Ltd. If you are not the original / intended recipient or the person responsible for delivering the email to the intended recipient, be advised that you have received this email in error, and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error, we regret the inconvenience and request you to please immediately notify at [EMAIL PROTECTED] RunAsDaemon: yes # emerald.cfg # # Example Radiator configuration file that allows you to # authenticate from and store accounting to the Emerald database # from IEA (see http://www.iea-software.com), or from # Platypus (see www.platypus.com) from Boradtown when running # the RadiusNT compatibility mode. # Caution: this config file and AuthBy EMERALD will not work with # non-standard dictionary file. # # You should consider this file to be a starting point only # $Id: emerald.cfg,v 1.5 2000/08/21 04:33:08 mikem Exp $ #DateFormat %b %e, %Y %H:%M:%S Foreground LogStdout DbDir . LogDir . LogFile ./detail Trace 4 # You will probably want to change this to suit your site. Secret IgnoreAcctSignature DupInterval 2 FramedGroupBaseAddress 10.0.0.1 DefaultSimultaneousUse 1 Filename %D/users Nocache Identifier ID_1 # Change DBSource, DBUsername, DBAuth for your database # See the reference manual # Default username and password for Platypus # Typical username and password for Emerald. Make # sure that you have added the users, and made their # default database the Emerald database # DBUsername emeralduser # DBAuth emeralduser # You can add to or change these if you want. DBSourcedbi:ODBC:plat DBUsername * DBAuth *** AccountingTable Calls AcctColumnDef UserName,User-Name AcctColumnDef CallDate,Timestamp,integer-date AcctColumnDef AcctStatusType,Acct-Status-Type,integer AcctColumnDef AcctDelayTime,Acct-Delay-Time,integer AcctColumnDef AcctInputOctets,Acct-Input-Octets,integer AcctColumnDef AcctOutputOctets,Acct-Output-Octets,integer AcctColumnDef AcctSessionId,Acct-Session-Id AcctColumnDef AcctSessionTime,Acct-Session-Time,integer AcctColumnDef AcctTerminateCause,Acct-Terminate-Cause,integer AcctColumnDef NASIdentifier,NAS-Identifier AcctColumnDef NASIdentifier,NAS-IP-Address AcctColumnDef CallerID,Calling-Station-Id AcctColumnDef NASPort,NAS-Port,integer # AcctColumnDef FramedIPAddress,Framed-IP-Address AddToReply Service-Type=Framed-User DefaultSimultaneousUse 1 Identifier ID_0 # You can use this to force Radiator to limit # maximum session times to how many minutes # are left in subaccounts.timeleft TimeBanking # You can optionally honour the LoginLimit # column in the emerald database # or any other column like this: AuthSelect ,sa.LoginLimit,sa.cli1,sa.cli2 AuthColumnDef 0,Simultaneous-Use, check #AuthSelect ,sa.cli1 AuthColumnDef 1,Calling-Station-Id, check #AuthSelect ,sa.cli2 AuthColumnDef 2,Calling-Station-Id, check #AuthSelect select cli1 from subaccounts \ #where login='%n' and clicheck='Y' # Therefore you can add support for any number # of additional columns, if you wish. # Note that Platypus fixes LoginLimit at 1, so # if you enable this with Platypus, all your # users will be forced to a Sumultaneous-Use l
(RADIATOR) Cli Authentication through DB ...
Hi, I want to implement CLI Authentication through MSSQL Database, is there any way to match the attribute Calling-Station-ID from any other field in DB. like if the CLI Authentication field is Yes and user is connecting from any number, request should first check and match with that field and if number is matched then user gets connect else user should not be able to connect. any idea?? regards, Mushtaque. ___ This email and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to which they are addressed. This communication represents the originator's personal views and opinions, which do not necessarily reflect those of eWorld (Pvt) Ltd. If you are not the original / intended recipient or the person responsible for delivering the email to the intended recipient, be advised that you have received this email in error, and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error, we regret the inconvenience and request you to please immediately notify at [EMAIL PROTECTED] === 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) simultaneous use prob ...
Hi All,
We r using Radiator with the Platypus and As5300 ... i hve made some
users in users file with simultaneous use 2. they were working fine but
suddenly stops working ... but when i restarts radiator ... the user
get connected with two simultaneous sessions ... i m attaching the
debug trace file ... and also users file ...
any ideas abt it ...
regards
Muhammad Mushtaque
Network Operations
eWorld(Pvt)Ltd.
UAN:92-21-111246246
___
This email and any files transmitted with it are confidential and are
intended solely for the use of the individual or entity to which they
are addressed. This communication represents the originator's personal
views and opinions, which do not necessarily reflect those of eWorld
(Pvt) Ltd. If you are not the original / intended recipient or the
person responsible for delivering the email to the intended recipient,
be advised that you have received this email in error, and that any
use, dissemination, forwarding, printing, or copying of this email is
strictly prohibited. If you have received this email in error, we
regret the inconvenience and request you to please immediately notify
at [EMAIL PROTECTED]
Code: Access-Request
Identifier: 155
Authentic: t<217><240>-q<238><223>>m<22><141><239><31>k~<3>
Attributes:
NAS-IP-Address = 202.63.217.245
NAS-Port = 95
Cisco-NAS-Port = "Async95"
NAS-Port-Type = Async
User-Name = "fariya"
Called-Station-Id = "7159"
Calling-Station-Id = "215219321"
User-Password = "7<183><4><207>g<176>%<200>2F<178><137><229>H<18><4>"
Service-Type = Framed-User
Framed-Protocol = PPP
Sun Jun 16 21:34:47 2002: DEBUG: Handling request with Handler 'Realm=DEFAULT'
Sun Jun 16 21:34:47 2002: DEBUG: Deleting session for fariya, 202.63.217.245, 95
Sun Jun 16 21:34:47 2002: DEBUG: Handling with Radius::AuthEMERALD
Sun Jun 16 21:34:48 2002: DEBUG: Handling with Radius::AuthEMERALD
Sun Jun 16 21:34:48 2002: DEBUG: Query is: select DateAdd(Day,
ma.extension+ma.overdue, maExpireDate),
DateAdd(Day, sa.extension, saExpireDate), sa.AccountID, sa.AccountType,
sa.password, sa.login, sa.shell, sa.TimeLeft ,sa.LoginLimit
from masteraccounts ma, subaccounts sa
where (sa.login = 'fariya' or sa.shell = 'fariya')
and ma.customerid = sa.customerid
and sa.active <> 0 and ma.active <> 0
Sun Jun 16 21:34:48 2002: DEBUG: Query is: insert into badattempt
(date,userid,password,cli) values ('6/16/2002
21:34:48','fariya','7·_Ïg°%È2F²åH__','215219321')
Sun Jun 16 21:34:48 2002: DEBUG: Radius::AuthEMERALD looks for match with fariya
Sun Jun 16 21:34:48 2002: DEBUG: Query is: select DateAdd(Day,
ma.extension+ma.overdue, maExpireDate),
DateAdd(Day, sa.extension, saExpireDate), sa.AccountID, sa.AccountType,
sa.password, sa.login, sa.shell, sa.TimeLeft ,sa.LoginLimit
from masteraccounts ma, subaccounts sa
where (sa.login = 'DEFAULT' or sa.shell = 'DEFAULT')
and ma.customerid = sa.customerid
and sa.active <> 0 and ma.active <> 0
Sun Jun 16 21:34:48 2002: DEBUG: Query is: insert into badattempt
(date,userid,password,cli) values ('6/16/2002
21:34:48','fariya','7·_Ïg°%È2F²åH__','215219321')
Sun Jun 16 21:34:48 2002: DEBUG: Handling with Radius::AuthFILE
Sun Jun 16 21:34:48 2002: DEBUG: Reading users file ./users
Sun Jun 16 21:34:48 2002: DEBUG: Radius::AuthFILE looks for match with fariya
Sun Jun 16 21:34:48 2002: DEBUG: Radius::AuthFILE ACCEPT:
Sun Jun 16 21:34:48 2002: DEBUG: Access accepted for fariya
Sun Jun 16 21:34:48 2002: WARNING: No such attribute Simultaneous-Use
Sun Jun 16 21:34:48 2002: DEBUG: Packet dump:
*** Sending to 202.63.217.245 port 1645
Code: Access-Accept
Identifier: 155
Authentic: t<217><240>-q<238><223>>m<22><141><239><31>k~<3>
Attributes:
Framed-IP-Address = 202.63.217.224
Framed-IP-Netmask = 255.255.255.0
Service-Type = Framed-User
Framed-Protocol = PPP
Simultaneous-Use = 2
Code: Accounting-Request
Identifier: 156
Authentic: <225>m<255>d<6><28><222><160><30>:(<212>t<242><128><207>
Attributes:
NAS-IP-Address = 202.63.217.245
NAS-Port = 95
Cisco-NAS-Port = "Async95"
NAS-Port-Type = Async
User-Name = "fariya"
Called-Station-Id = "7159"
Calling-Station-Id = "215219321"
Acct-Status-Type = Start
Acct-Authentic = RADIUS
Service-Type = Framed-User
A
(RADIATOR) attribute from Platypus ...
Hi All, I m restricting our Async users to use ISDN Modems through NAS-Port- Type Check item in users file ... Its working fine ... I just want to pass this check item through platypus ... Attribute is there in RadiusNT ... but not effected from Platypus ... Is there any changes needed on Radiator to make it happen ... waiting for replies Mushtaque Network Operations eWorld(Pvt)Ltd. ___ This email and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to which they are addressed. This communication represents the originator's personal views and opinions, which do not necessarily reflect those of eWorld (Pvt) Ltd. If you are not the original / intended recipient or the person responsible for delivering the email to the intended recipient, be advised that you have received this email in error, and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error, we regret the inconvenience and request you to please immediately notify at [EMAIL PROTECTED] === 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) CLI facility on more than one number
Hi All, Can we assign more than one value on "Calling-station-Id" attribute?? Actually my aim is to give the facility of CLI on more than one number ... so that user can access his account from that two specified numbers. thanx in advance regards, Muhammad Mushtaque Network Operations eWorld(Pvt)Ltd. 506, Progressive Plaza, Beaumont Road Civil Lines, Karachi. UAN:92-21-111246246 This email and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to which they are addressed. This communication represents the originator's personal views and opinions, which do not necessarily reflect those of eWorld (Pvt) Ltd. If you are not the original / intended recipient or the person responsible for delivering the email to the intended recipient, be advised that you have received this email in error, and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error, we regret the inconvenience and request you to please immediately notify at [EMAIL PROTECTED] === 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.
Re: (RADIATOR) Strange problem ...
Hi Hugh, You were right about the error. I debug the Nas and its problem with the maximum limit of "timeout absolute" on each Async interface on Which our Dialup users are getting connected i-e (0-35790 mins) But we have to go beyond this limit through session timeout. Is there any way to write a hook which compares the value read from the database and always sends the max value of "session-timeout" attribute to the NAS until the value read from database drops below the max. In this case, it will send the actual value read from the database. or is there any other way to do acheive this task ?? thanks in advance, regards, Muhammad Mushtaque Network Operations eWorld(Pvt)Ltd. 506, Progressive Plaza, Beaumont Road Civil Lines, Karachi. UAN:92-21-111246246 This email and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to which they are addressed. This communication represents the originator's personal views and opinions, which do not necessarily reflect those of eWorld (Pvt) Ltd. If you are not the original / intended recipient or the person responsible for delivering the email to the intended recipient, be advised that you have received this email in error, and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error, we regret the inconvenience and request you to please immediately notify at [EMAIL PROTECTED] - Original Message - From: Hugh Irvine <[EMAIL PROTECTED]> Date: Thursday, January 17, 2002 5:46 am Subject: Re: (RADIATOR) Strange problem ... > > Hello Mushtaque - > > Thanks for sending the debug output. > > I suspect the problem is with the NAS, as the debug shows that you > are > returning the following: > >Session-Timeout = 216 > > You should have a look at the debug on the NAS to see what is > happening. > regards > > Hugh > > > On Wed, 16 Jan 2002 15:04, Muhammad Mushtaque wrote: > > Hi all, > > > > I m using Platypus with Radiator. I ve come across very strange > > problem. There is a field of Blockminleft in Platypus in which we > > insert prepaid time of our users ... when this time exceeds from > 36000> minutes ... the user is not able to connect. Its very > strange that the > > user is easily got connected on 35000 mins ... Normally it seems > to be > > a radiator issue ... I m attching the detail file part of the users > > which is not geeting connected with 36000 mins ... the user > > authenticates but getting disconnect after authentication ... the > > detail file part is as follows : > > > > *** Received from 202.63.217.245 port 1645 > > Code: Access-Request > > Identifier: 253 > > Authentic: <184><0>v<229><207><139>e<247><132><227> > > c<146><168><212><16> > > Attributes: > > NAS-IP-Address = 202.63.217.245 > > NAS-Port = 109 > > Cisco-NAS-Port = "Async109" > > NAS-Port-Type = Async > > User-Name = "test_discount1" > > Called-Station-Id = "7159" > > Calling-Station-Id = "215219321" > > User-Password > > = "<136>$<245>N@<173><170>j<189><130><239>md5C<172>" > > Service-Type = Framed-User > > Framed-Protocol = PPP > > > > Sat Jan 19 08:49:51 2002: DEBUG: Handling request with > > Handler 'Realm=DEFAULT' > > Sat Jan 19 08:49:51 2002: DEBUG: Deleting session for > test_discount1,> 202.63.217.245, 109 > > Sat Jan 19 08:49:51 2002: DEBUG: Handling with Radius::AuthEMERALD > > Sat Jan 19 08:49:51 2002: DEBUG: Handling with Radius::AuthEMERALD > > Sat Jan 19 08:49:51 2002: DEBUG: Query is: select DateAdd(Day, > > ma.extension+ma.overdue, maExpireDate), > > DateAdd(Day, sa.extension, saExpireDate), sa.AccountID, > sa.AccountType,> sa.password, sa.login, sa.shell, sa.TimeLeft > ,sa.LoginLimit> from masteraccounts ma, subaccounts sa > > where (sa.login = 'test_discount1' or sa.shell = 'test_discount1') > > and ma.customerid = sa.customerid > > and sa.active <> 0 and ma.active <> 0 > > > > Sat Jan 19 08:49:51 2002: DEBUG: Select results: 2003-01-16 > > 08:43:40.190, 2003-01-16 08:43:40.190, 6033, PPP, eworld, > > test_discount1, , 36000, 1 > > Sat Jan 19 08:49:51 2002: DEBUG: Query is: select ra.RadAttributeID, > > ra.RadVendorID, ra.RadVendorType, > > Data, Value, Type, RadCheck > > from RadConfigs rc, RadAttributes ra
(RADIATOR) Strange problem ...
(UserName, CallDate, AcctStatusType, AcctDelayTime,
AcctSessionId, NASIdentifier, CallerID, NASPort)
values
('test_discount1', 'Jan 19, 2002 08:49', 1,
0, '004C', '202.63.217.245', '215219321', 109)
Sat Jan 19 08:49:51 2002: DEBUG: Accounting accepted
Sat Jan 19 08:49:51 2002: DEBUG: Packet dump:
*** Sending to 202.63.217.245 port 1646
Code: Accounting-Response
Identifier: 254
Authentic:
<214>c<190><208><30>n<182><210><214><247><209><15><245><165>\+
Attributes:
Sat Jan 19 08:49:51 2002: DEBUG: Packet dump:
*** Received from 202.63.217.245 port 1646
Code: Accounting-Request
Identifier: 255
Authentic:
<132>&<178><250><27><198><203><190><5><200><180><207><172>w<231>V
Attributes:
NAS-IP-Address = 202.63.217.245
NAS-Port = 109
Cisco-NAS-Port = "Async109"
NAS-Port-Type = Async
User-Name = "test_discount1"
Called-Station-Id = "7159"
Calling-Station-Id = "215219321"
Acct-Status-Type = Stop
Acct-Authentic = RADIUS
Service-Type = Framed-User
Acct-Session-Id = "004C"
Framed-Protocol = PPP
Acct-Terminate-Cause = Host-Request
Acct-Input-Octets = 62
Acct-Output-Octets = 8
Acct-Input-Packets = 3
Acct-Output-Packets = 1
Acct-Session-Time = 0
Acct-Delay-Time = 0
Sat Jan 19 08:49:51 2002: DEBUG: Handling request with
Handler 'Realm=DEFAULT'
Sat Jan 19 08:49:51 2002: DEBUG: Deleting session for test_discount1,
202.63.217.245, 109
Sat Jan 19 08:49:51 2002: DEBUG: Handling with Radius::AuthEMERALD
Sat Jan 19 08:49:51 2002: DEBUG: Handling accounting with
Radius::AuthEMERALD
Sat Jan 19 08:49:51 2002: DEBUG: do query is: insert into Calls
(UserName, CallDate, AcctStatusType, AcctDelayTime,
AcctInputOctets, AcctOutputOctets, AcctSessionId, AcctSessionTime,
AcctTerminateCause, NASIdentifier, CallerID, NASPort)
values
('test_discount1', 'Jan 19, 2002 08:49', 2, 0, 62,
8, '004C', 0, 18, '202.63.217.245', '215219321', 109)
Sat Jan 19 08:49:51 2002: DEBUG: Accounting accepted
Sat Jan 19 08:49:51 2002: DEBUG: Packet dump:
*** Sending to 202.63.217.245 port 1646
Code: Accounting-Response
Identifier: 255
Authentic:
<132>&<178><250><27><198><203><190><5><200><180><207><172>w<231>V
Attributes:
Any one can help me out here ??
thanks in Advance ...
Best regards,
Muhammad Mushtaque
Network Operations
eWorld(Pvt)Ltd.
506, Progressive Plaza,
Beaumont Road Civil Lines,
Karachi.
UAN:92-21-111246246
This email and any files transmitted with it are confidential and are
intended solely for the use of the individual or entity to which they
are addressed. This communication represents the originator's personal
views and opinions, which do not necessarily reflect those of eWorld
(Pvt) Ltd. If you are not the original / intended recipient or the
person responsible for delivering the email to the intended recipient,
be advised that you have received this email in error, and that any
use, dissemination, forwarding, printing, or copying of this email is
strictly prohibited. If you have received this email in error, we
regret the inconvenience and request you to please immediately notify
at [EMAIL PROTECTED]
===
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) Idle-Timeout
Hi all, I m using Cisco As5300. Session-out attribute is working fine ... but i m not getting the desired result from Idle-Timeout ... this is user's configuration in user's file ... mushy User-Password = "mushy" Service-Type = Framed-User, Framed-Protocol = PPP, Framed-Group = 0, Session-Timeout = 900, Idle-Timeout = 300 Is there any changes required in NAS also ... ?? The user is getting Disconnected when session expires but not Idle time expires ... waiting for replies ... regards, Muhammad Mushtaque Network Operations eWorld(Pvt)Ltd. 506, Progressive Plaza, Beaumont Road Civil Lines, Karachi. UAN:92-21-111246246 This email and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to which they are addressed. This communication represents the originator's personal views and opinions, which do not necessarily reflect those of eWorld (Pvt) Ltd. If you are not the original / intended recipient or the person responsible for delivering the email to the intended recipient, be advised that you have received this email in error, and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error, we regret the inconvenience and request you to please immediately notify at [EMAIL PROTECTED] === 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.
