After spending a while getting AuthSQL to talk to informix (another story...) I finally got it. Now it prints the following in the log on trace level 4, and solidly refuses to authenticate anyone/anything: <snip> Thu Feb 17 15:20:45 2000: DEBUG: Radius::AuthSQL looks for match with [EMAIL PROTECTED] Thu Feb 17 15:20:45 2000: DEBUG: Query is: select au_password, au_idletimeout, au_ipnumber from access_users where au_username = '[EMAIL PROTECTED]' Thu Feb 17 15:20:45 2000: ERR: Execute failed for 'select au_password, au_idletimeout, au_ipnumber from access_users where au_username = '[EMAIL PROTECTED]'': SQL: -410: Prepare statement failed or was not executed. Thu Feb 17 15:20:45 2000: ERR: Execute failed for 'select au_password, au_idletimeout, au_ipnumber from access_users where au_username = '[EMAIL PROTECTED]'': SQL: -410: Prepare statement failed or was not executed. Thu Feb 17 15:20:45 2000: INFO: Access rejected for [EMAIL PROTECTED]: No such user </snip> I know that this record exists in the database, as I have run a select using Informix's SQL Editor, and it returned the results I expected (Un-encrypted Password, Idle Timeout Value, IP Address). Assuming that the error number that it returns is an error from Informix, the text of that error is as follows: -410 Prepare statement failed or was not executed. This EXECUTE statement refers to a statement id that has not been prepared. Either no PREPARE statement was done, or one was done but returned an error code. Review the program logic to ensure that a statement is prepared and the PREPARE return code is checked. A negative error code from PREPARE usually reflects an error in the statement being prepared. has anyone had any problems like this? anyone know what to do about it? if you need any more information (e.g. config files, etc) to help me with this problem, don't hesitate to contact me :) tia --- Joel Michael Junior System Administrator Diggy Internet Services 90 Petrie Terrace Brisbane Qld 4000 Ph: +61 7 3367 3555 Fax: +61 7 3367 3544 Mob: 0401 039 462 === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
