Hello Joel -
On Thu, 17 Feb 2000, Joel Michael wrote:
> 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 :)
I assume you have installed the Perl DBI and DBD modules?
If so could you please send me the configuration file (no secrets), a trace 4
debug showing the problem, the SQL output mentioned above, and your hardware
and software versions (including Radiator).
thanks
Hugh
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
NT, Rhapsody
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
