[isf-wifidog] RADIUS fixed

[kaouete]

Hi,

i tested the bugfix for the logout and it looks like it doesnt work.
there is the new error :
Notice: Undefined variable: info in
/var/www/wifidog/classes/AuthenticatorRadius.php on line 297

Warning: pg_query() [function.pg-query]: Query failed: ERROR:
invalid input syntax for integer: "" in
/var/www/wifidog/classes/AbstractDbPostgres.php on line 287

ExecuterSqlResUnique(): ERREUR: Lors de l'exécution de la requête
SQL:

UPDATE connections SET timestamp_out=NOW(),token_status='USED'
WHERE conn_id='';

L'erreur est:
ERROR: invalid input syntax for integer: ""

If it can help you :)

kaouete

On Mon, Oct 24, 2005 at 05:46:02PM -0400, Benoit Grégoire wrote:
> On October 24, 2005 02:33 pm, kaouete wrote:
> > Hi,
> >
> > i tried it, now i can login, but when i logout from a radius
> > account on a radius network i get these errors :
> >
> > ExecSqlUniqueRes() : An error occured while executing the
> > following SQL query :
> > SELECT NOW(), *, CASE WHEN ((NOW() - reg_date) >
> > networks.validation_grace_time) THEN true ELSE false END AS
> > validation_grace_time_expired FROM connections JOIN users ON
> > (users.user_id=connections.user_id) JOIN networks ON
> > (users.account_origin = networks.network_id) WHERE
> > connections.conn_id='3
> >
> > Error message :
> > ERROR: unterminated quoted string at or near "'3" at character 295
> 
> I just commited a quick fix for that, untested.
> 
> 2005-10-24 Benoit Grégoire  <bock at step.polymtl.ca>
> 	* AuthenticatorRadius:  Fix bug reported by kouete, by inspection.  Fix not 
> actually tested. 
> 	 Guys, read the documentation of the function parameters when you code, it's 
> there to help you ;)
> 
> -- 
> Benoit Grégoire, http://benoitg.coeus.ca/


-------------- section suivante --------------
Une pièce jointe non texte a été nettoyée...
Nom: non disponible
Type: application/pgp-signature
Taille: 189 octets
Desc: Digital signature
Url: http://listes.ilesansfil.org/pipermail/wifidog/attachments/20051025/60b45347/attachment.pgp