Ticket #353 (closed Bug report: fixed)

Opened 6 years ago

Last modified 3 years ago

Installation - Database initialization error

Reported by: takalani@… Owned by:
Priority: normal Milestone: WifiDog Auth Server 1.0
Component: Auth server, Install script Version: Gateway 20090925
Keywords: Cc:

Attachments

Change History

  Changed 6 years ago by benoitg

What version of postgres are your running?

  Changed 6 years ago by benoitg

Just a hunch, check if you have the plpgsql language installed. I heard some distributions still have that as a separate package.

follow-up: ↓ 4   Changed 6 years ago by takalani@…

Thanks for the reply,

I am using PostgreSQL 7.4.13

How do I check if I have plpgsql?

Thanks

in reply to: ↑ 3   Changed 6 years ago by takalani@…

My situation has changed to desparate.

Help....please.... :-(

  Changed 6 years ago by oe@…

I have something similar; Gentoo server, Postgresql 8.0.13, PHP 5.2.2

Svn checkout of auth-server 27.July.2007

When install script load DB schema/initial data i get the following message;

Creating wifidog database schema : Warning: pg_query() [function.pg-query]: Query failed: ERROR: function nextval(regclass) does not exist HINT: No function matches the given name and argument types. You may need to add explicit type casts. in /var/www/localhost/htdocs/wifidog/install.php on line 938 ERROR: function nextval(regclass) does not exist HINT: No function matches the given name and argument types. You may need to add explicit type casts. <=

  Changed 6 years ago by bmichalski@…

I'm having the same problem with PostgreSQL 7.4, looks like the function is supported PostgreSQL 8.1, which is unfortunately because the install guide for wifidog is only complete for 7.4.

Is there any solution yet?

  Changed 6 years ago by mathias@…

The nextval(regclass) problem is still there. Also upgraded to postgres-8.1 (under debian stable), but nothing changes. Would be nice to have this issue fixed.

  Changed 6 years ago by benoitg

  • priority changed from high to normal

About the original problem: It has probably been fixed in [1266]

About the nextval problem: Thats definitely a different issue. That being said, nextval() has existed since at least postgres 7.3. So either there is a problem with your postgres install, or the actual issue is the schema syntax.

But once again, postgresql 7.4 is not recommended.

  Changed 6 years ago by benoitg

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

Experimental fix commited in [1283]

  Changed 6 years ago by benoitg

  • milestone changed from Not yet assigned to a Milestone to WifiDog Auth Server 1.0

  Changed 3 years ago by jodoreps

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

Add/Change #353 (Installation - Database initialization error)

Author


E-mail address and user name can be saved in the Preferences.


Action
as closed
The resolution will be deleted. Next status will be 'reopened'
 
Note: See TracTickets for help on using tickets.