* This is the VOP Radius mailing list * Yep, tried TinyInt 0 and 1 Y and N YES and No True and False T and F. Also Enum for each of those. I have tried Int also.
No joy.. For some reason my VOP Radius seems to ignore the Analog and digital fields and lets the user on regardless of how they are set. Is this a problem with VOP Radius maybe? I have spent quite a bit of time testing different datatypes and values etc. with no success. I looked at the SQL script when I was messing with this and it showed that the script would build the fields as type "Bit" which translates to TinyInt for MySql. As mentioned above, I tried TinyInt. Funny thing is, at one point I have one of these types working 3 or 4 times it seemed like them without any changes it just quit after I tried it several times. If it helps any, I have had this working from an Access DB for months.. We really have to get away form using Access though ASAP. Thanks for the info.. Anyone else? Thanks, Todd -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ron Sent: Sunday, November 24, 2002 2:39 AM To: [EMAIL PROTECTED] Subject: [VOP RADIUS] MySQL anyone? * This is the VOP Radius mailing list * I am just starting testing auth with MySQL next week so I don't have a definitive answer but you may want to try tinyint=0 for FALSE and tinyint=1 for TRUE Programming languages that I have dealt with have always accepted this is valid syntax for TRUE/FALSE In your Vircom\Radius directory is a file call 'Scripts.sql' in it should be the conversion tables for an SQL auth setup. I don't have one handy until tomorrow but inside that should tell you what you need to know, just open it with Notepad or another text editor. or. I hope this helps, Ron Fitzgerald ** To leave this list, send an email to [EMAIL PROTECTED] and put the word "LEAVE" in the BODY of the email. ** To leave this list, send an email to [EMAIL PROTECTED] and put the word "LEAVE" in the BODY of the email.
