[isf-wifidog] can't login

[Pedro Bandim Faustino]

Hi all,

I've installed wifidog v1.1.4 on a x86 board running openwrt r11534.
Authentication server is running r1355 (on hostmonster provider).

The first problem was that on sql/wifidog-postgres-initial-data.sql I had:
INSERT INTO schema_info (tag, value) VALUES ('schema_version', '61');
but on wifidog/include/schema_validate.php I had
define('REQUIRED_SCHEMA_VERSION', 62);

so I've changed 61 to 63 on sql/wifidog-postgres-initial-data.sql

I'm able to add a node, configure it and get redirected to the auth server.
The problem is when I try to log in using an already validated user
(or the admin user) I get this error:

execSqlUpdate() : An error occured while executing the following SQL query :
DELETE FROM connections USING tokens WHERE
tokens.token_id=connections.token_id AND token_status='UNUSED' AND
user_id = '91a4ff627cc4620df1dd7f68c458a6eb'; INSERT INTO tokens
(token_owner, token_issuer, token_id, token_status) VALUES
('91a4ff627cc4620df1dd7f68c458a6eb',
'91a4ff627cc4620df1dd7f68c458a6eb',
'71a8614037dae33e3e6c1714b162d3c4', 'UNUSED'); INSERT INTO connections
(user_id, token_id, timestamp_in, node_id, node_ip, last_updated)
VALUES ('91a4ff627cc4620df1dd7f68c458a6eb',
'71a8614037dae33e3e6c1714b162d3c4', CURRENT_TIMESTAMP, 'default',
'85.218.14.86', CURRENT_TIMESTAMP)

Error message :
ERROR: syntax error at or near "USING" at character 25

Backtrace:

#0 /home/pedrofau/public_html/wifidog-auth/wifidog/classes/User.php(642):
AbstractDb->execSqlUpdate()
#1 /home/pedrofau/public_html/wifidog-auth/wifidog/login/index.php(208):
User->generateConnectionToken()


Warning: Cannot modify header information - headers already sent by
(output started at
/home/pedrofau/public_html/wifidog-auth/wifidog/classes/AbstractDb.php:490)
in /home/pedrofau/public_html/wifidog-auth/wifidog/login/index.php on
line 215


Do you know what's going on here?

Thanks for your help,
Pedro Faustino