Ticket #384 (closed Bug report: fixed)

Opened 13 years ago

Last modified 8 years ago

Can't create an admin login during install.php setup.

Reported by: wifidog@… Owned by:
Priority: normal Milestone: Not yet assigned to a Milestone
Component: Auth server, Install script Version: Gateway 20090925
Keywords: Cc:

Description (last modified by benoitg) (diff)

Administration account

Warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "server_stakeholders" does not exist in /home/stewart/www/Portal/install.php on line 1060

Warning: pg_fetch_all() expects parameter 1 to be resource, boolean given in /home/stewart/www/Portal/install.php on line 1061

I'm getting this above the admin Username, Password, Email form. When I fill out the form and click next it goes on, but will not finish the install. I continue to get more errors.

I've used this program for sometime and was doing a little upgrade maintenance. Which of course caused me all kinds of issues. I ended up dumping my database and making a new one basically installing the entire program from scratch. I guess it might not have been me, but something the install script didn't like.

Sincerely,

Not much hair left

Change History

Changed 13 years ago by wifidog@…

Here is what I get after entering my admin info and clicking next:

Administration account

execSqlUniqueRes() : An error occured while executing the following SQL query : SELECT virtual_host_id FROM virtual_hosts WHERE hostname='hotspot.94stewart.com'

Error message : ERROR: relation "virtual_hosts" does not exist

execSqlUniqueRes() : An error occured while executing the following SQL query : SELECT default_virtual_host FROM server ORDER BY creation_date LIMIT 1

Error message : ERROR: relation "server" does not exist

execSqlUniqueRes() : An error occured while executing the following SQL query : SELECT virtual_host_id FROM virtual_hosts WHERE hostname='hotspot.94stewart.com'

Error message : ERROR: relation "virtual_hosts" does not exist

execSqlUniqueRes() : An error occured while executing the following SQL query : SELECT default_virtual_host FROM server ORDER BY creation_date LIMIT 1

Error message : ERROR: relation "server" does not exist

Fatal error: Uncaught exception 'Exception' with message 'Server::getDefaultVirtualHost: Fatal error: Unable to find the default virtual host!' in /home/stewart/www/Portal/classes/VirtualHost.php:194 Stack trace: #0 /home/stewart/www/Portal/classes/Network.php(133): VirtualHost::getDefaultVirtualHost() #1 /home/stewart/www/Portal/install.php(1049): Network::getDefaultNetwork() #2 {main} thrown in /home/stewart/www/Portal/classes/VirtualHost.php on line 194

Changed 13 years ago by benoitg

  • status changed from new to closed
  • resolution set to fixed

Darn, you probably just ran into a UI flaw in the install script that caused you not to update your database schema. I really wish the install script had a maintainer. I tried fixing the flaw in [1296], try going through the install script again, and tell us if it works

Changed 13 years ago by wifidog@…

  • status changed from closed to reopened
  • resolution fixed deleted

I've tried reinstalling it several times, I get further when I create a fresh database. If I try to reinstall after getting stuck I usually don't get as far. Let me try it one more time right now.

Database initialisation

On localhost, Database wifidog exists and is up to date (shema version 57).

I get to this and it won't let me click next. If I delete the db and start over I can get further to the admin setup part. Is there a way I can just manually create an admin account? Looks like that would solve my issues to at least let me get this working properly again.

Changed 13 years ago by wifidog@…

ok, I grabbed the latest svn as I notice there was an update concerning my issues. I'll give it a whirl.

Thanks

Changed 13 years ago by wifidog@…

good to go, thanks!

Changed 13 years ago by benoitg

  • status changed from reopened to closed
  • resolution set to fixed

Changed 10 years ago by jodoreps

  • version set to Gateway 20090925
  • description modified (diff)

Changed 8 years ago by 463343500@…

Hi,I also have the same problem.Can't create an admin login during install.php setup. below," Uncaught exception 'Exception' with message 'Server::getDefaultVirtualHost: Fatal error: Unable to find the default virtual host!' in C:\wwwroot\wifidog-auth\wifidog\classes\VirtualHost.php:194 Stack trace: #0 C:\wwwroot\wifidog-auth\wifidog\classes\Network.php(138): VirtualHost::getDefaultVirtualHost() #1 C:\wwwroot\wifidog-auth\wifidog\install.php(925):"

Changed 8 years ago by benoitg

  • description modified (diff)
Note: See TracTickets for help on using tickets.