<html>
<body>
I've downloaded a few of the recent svns and have some issue upgrading my
existing auth install. I figured I'd<br>
post this to the group to see if anyone has come across similar issues.
There are two issues I'm running across right now.<br><br>
#1...<br><br>
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:<br><br>
<h1><font size=4><b>Administration account</b></font></h1><b>Warning</b>:
pg_query()
[<a href="http://wirelessguy.dyndns.org/wifidog/function.pg-query">
function.pg-query</a>]: Query failed: ERROR: duplicate key violates
unique constraint "idx_unique_username_and_account_origin" in
<b>/var/www/html/wifidog/classes/AbstractDb.php</b> on line
<b>394<br><br>
</b>execSqlUpdate(): An error occured while executing the following SQL
query : <br><br>
<pre>INSERT INTO users (user_id,username,
account_origin,email,pass,account_status,validation_token,reg_date)
VALUES
('2357722a03b949381ed732c382ed7c91','admin','LOCAL_USER','webmaster@localhost','UV+C7CFjW8ZMCVrL8X9AEw==','5','eec53598946b8eb6b7316066485526e4',CURRENT_TIMESTAMP)
</pre>Error message : <br>
ERROR: duplicate key violates unique constraint
"idx_unique_username_and_account_origin"<br>
<b>Fatal error</b>: 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@local...', '**********') #3 {main} thrown in
<b>/var/www/html/wifidog/classes/User.php</b> on line <b>236</b>
<br><br>
Looks to me like the SQL statement might need to be modified a bit to see
databases with existing admin accounts.<br><br>
Can anyone have a look at this?<br><br>
#2...<br><br>
My original auth was working fine, (Subversion $Id: index.php 1064 )<br>
The new versions 11xx do something using not only the gw_id but the new
node_id.<br>
Now when my routers try to connect they get an invalid node_id
message<br><br>
Example: <br>
Login: The node with NODE_ID: 000MAC_HERE000 could not be found in the
database! <br>
Portal page: No Hotspot specified! <br><br>
Any thoughts?<br><br>
<br>
Thanks<br><br>
- W<br>
</body>
</html>