Ticket #353 (closed Bug report: fixed)

Opened 12 years ago

Last modified 9 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:

Change History

  Changed 12 years ago by benoitg

What version of postgres are your running?

  Changed 12 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 12 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 12 years ago by takalani@…

My situation has changed to desparate.

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

  Changed 12 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 12 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 12 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 12 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 12 years ago by benoitg

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

Experimental fix commited in [1283]

  Changed 12 years ago by benoitg

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

  Changed 9 years ago by jodoreps

  • version set to Gateway 20090925
  • description modified (diff)
Note: See TracTickets for help on using tickets.