[isf-wifidog] Issues with install scripts in recent svns
Wireless Guy
wirelessguy at optonline.net
Ven 9 Fév 11:09:27 EST 2007
I've downloaded a few of the recent svns and have some issue
upgrading my existing auth install. I figured I'd
post this to the group to see if anyone has come across similar
issues. There are two issues I'm running across right now.
#1...
Running thru install.php I get to the point where it asks me for the
admin username and password and email account. when I submit the
forms post I get this error:
Administration account
Warning: pg_query()
[<http://wirelessguy.dyndns.org/wifidog/function.pg-query>function.pg-query]:
Query failed: ERROR: duplicate key violates unique constraint
"idx_unique_username_and_account_origin" in
/var/www/html/wifidog/classes/AbstractDb.php on line 394
execSqlUpdate(): An error occured while executing the following SQL query :
INSERT INTO users (user_id,username,
account_origin,email,pass,account_status,validation_token,reg_date)
VALUES
('2357722a03b949381ed732c382ed7c91','admin','LOCAL_USER','webmaster at localhost','UV+C7CFjW8ZMCVrL8X9AEw==','5','eec53598946b8eb6b7316066485526e4',CURRENT_TIMESTAMP)
Error message :
ERROR: duplicate key violates unique constraint
"idx_unique_username_and_account_origin"
Fatal error: Uncaught exception 'Exception' with message 'User id:
2357722a03b949381ed732c382ed7c91 could not be found in the database'
in /var/www/html/wifidog/classes/User.php:236 Stack trace: #0
/var/www/html/wifidog/classes/User.php(74):
User->__construct('2357722a03b9493...') #1
/var/www/html/wifidog/classes/User.php(216):
User::getObject('2357722a03b9493...') #2
/var/www/html/wifidog/install.php(1158):
User::createUser('2357722a03b9493...', 'admin', Object(Network),
'webmaster at local...', '**********') #3 {main} thrown in
/var/www/html/wifidog/classes/User.php on line 236
Looks to me like the SQL statement might need to be modified a bit to
see databases with existing admin accounts.
Can anyone have a look at this?
#2...
My original auth was working fine, (Subversion $Id: index.php 1064 )
The new versions 11xx do something using not only the gw_id but the
new node_id.
Now when my routers try to connect they get an invalid node_id message
Example:
Login: The node with NODE_ID: 000MAC_HERE000 could not be found in
the database!
Portal page: No Hotspot specified!
Any thoughts?
Thanks
- W
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listes.ilesansfil.org/pipermail/wifidog/attachments/20070209/6d23f448/attachment.htm
Plus d'informations sur la liste de diffusion WiFiDog