[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