The problem is that the type is "char" not varchar. Most databases will padd strings that are less than the size of the column to the column width with spaces. You will have to use the varchar type in order to avoid this.
Sincerely, Leon Oosterwijk ISDN-NET Inc. www.isdn.net +1 615-221-4200 > -----Original Message----- > From: Ronan Eckelberry [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 21, 2002 5:02 PM > To: 'Shaun Eck'; > Subject: RE: (RADIATOR) Radiator configuration File and Password > > > Are you putting spaces after the username in the database? > > -Ronan > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] On > Behalf Of Shaun Eck > > Sent: Thursday, 21 February, 2002 16:56 > To: [EMAIL PROTECTED] > Subject: (RADIATOR) Radiator configuration File and Password > > > Hi > > I would like to get some assistance on how to have the > password clipped from within the configuration file > radius.cfg. Let me explain further. We have configured the > radius.cfg file to be able to authenticate both from a file > and from a database. The authentication is done by > implementing the subscribers table as recommended by the > installation process. However we are denied access when the > user that is logging-in is in the subscribers table. We have > found that by including the additional spaces in the password > that equal the size of the password ,field define in the > subscribers table, only then are we able to login. > > Table: subscribers > username char(12) > > Example: > Login Name: vcas > Password: vcas+8spaces > > === > 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.
