Page 1 of 1

1.0-beta PostgreSQL installation trouble

Posted: Fri Apr 07, 2006 9:22 pm
by marcderooij
Hi!

I'm having trouble installing the 1.0 beta with PostgreSQL.
A part of the errors is below, some of the errors are in Dutch but I hope someone can understand, otherwise I can translate...
Controleer de database op aanwezigheid van de nodige tabellen... negatief
Maak standaard database aan...
Warning: pg_query() [function.pg-query]: Query failed: ERROR: permission denied for schema public in /local/home/marc/.html/libertas/include/db/postgres.inc.php on line 207
Error in create table libertas_authors (realname varchar(255) NOT NULL default '',username varchar(20) default null,password varchar(32) default null,authorid SERIAL primary key,mail_comments int2 default '1',mail_trackbacks int2 default '1',email varchar(128) not null default '',userlevel int4 not null default '0',right_publish int2 default '1') ;
ERROR: permission denied for schema public
array (
0 =>
array (
'file' => '/local/home/marc/.html/libertas/include/db/postgres.inc.php',
'line' => 279,
'function' => 'serendipity_db_query',
'args' =>
array (
0 => 'create table libertas_authors (realname varchar(255) NOT NULL default \'\',username varchar(20) default null,password varchar(32) default null,authorid SERIAL primary key,mail_comments int2 default \'1\',mail_trackbacks int2 default \'1\',email varchar(128) not null default \'\',userlevel int4 not null default \'0\',right_publish int2 default \'1\') ;',
),
),
1 =>
array (
'file' => '/local/home/marc/.html/libertas/include/functions_installer.inc.php',
'line' => 136,
'function' => 'serendipity_db_schema_import',
'args' =>
array (
0 => 'create table libertas_authors (realname varchar(255) NOT NULL default \'\',username varchar(20) default null,password varchar(32) default null,authorid {AUTOINCREMENT} {PRIMARY},mail_comments int(1) default \'1\',mail_trackbacks int(1) default \'1\',email varchar(128) not null default \'\',userlevel int(4) {UNSIGNED} not null default \'0\',right_publish int(1) default \'1\') {UTF_8};',
),
),
2 =>
array (
'file' => '/local/home/marc/.html/libertas/include/admin/installer.inc.php',
'line' => 474,
'function' => 'serendipity_installDatabase',
'args' =>
array (
),
),
3 =>
array (
'file' => '/local/home/marc/.html/libertas/serendipity_admin.php',
'line' => 117,
'args' =>
array (
0 => '/local/home/marc/.html/libertas/include/admin/installer.inc.php',
),
'function' => 'require_once',
),
)

Posted: Sat Apr 08, 2006 10:41 am
by marcderooij
The problem occurs at the very end of install when it's time to create the database tables and start the weblog. For clarity, I renamed "serendipity" to "libertas" for this install.

I tried it with a MySQL database on the same host and that works flawlessly (lot of improvements since 0.7, nice job!)

Posted: Sat Apr 08, 2006 6:02 pm
by garvinhicking
Hi!

I'm afraid this is a problem with your postgresql setup. It seems the user account you created and want to use for s9y doesn'T allow to create tables/schemas.

I'm no pgsql guy, but you must look at your pgsql setup, this is where a problem lies.

Regards,
Garvin

Posted: Sun Apr 09, 2006 9:39 am
by marcderooij
Thanks for the reply! I'll contact the admin.