[geeklog-devel] postgresql and Geeklog 2.0.0b1

[Dan Stoner]

I just got back from a tech conference and I'm a little fired up about
open source again.  I allocated some time to test Geeklog with
postgresql.

Here is my environment (currently a RHEL 5.x clone):

PHP 5.3.3
PostgreSQL(libpq) Version	8.1.23


The first two issues might be worth documenting in the release notes
or something:


1. The default configuration in this packaged version of postgres
creates databases with UTF8 encoding, so I checked the box for this
during the Geeklog install.

2. Full privileges on the database itself do not seem to be
sufficient.  Without granting "Superuser" role to my postgres web
application user account, the install script aborts with this message:


Warning: pg_query(): Query failed: ERROR: must be superuser to create
procedural language CONTEXT: SQL function "make_plpgsql" statement 1
in /var/www/private/pgblog_private/system/databases/pgsql.class.php on
line 350


The Superuser role can be granted by issuing the following:

  ALTER USER geekloguser WITH superuser;

If this is only needed for the initial database config / creation it
might be worth making a note that the superuser role can be removed
after the initial install.

ALTER USER geekloguser WITH nosuperuser;



The third and fourth issues preventing me from using the site:

3.  The admin account with default password of "password" did not seem
to exist or let me log in.

4.  The main page seemed to render ok, as do some of the sub-pages,
but many of them error out with "Unfortunately, an error has occurred
rendering this page. Please try again later."

Looking in my geeklog error log, I see:


Mon 02 Jul 2012 20:51:34 EDT - 98.70.54.73 - 2 - pg_query(): Query
failed: ERROR:  column "e707dc1196bbd50f2cc5e1f51791c3e2d8862a75" does
not exist @ /var/www/private/pgblog_private/system/databases/pgsql.class.php
line 350
Mon 02 Jul 2012 20:51:48 EDT - 98.70.54.73 - Error, invalid username: 'admin'
Mon 02 Jul 2012 20:51:55 EDT - 98.70.54.73 - 2 - pg_query(): Query
failed: ERROR:  column "034f3c84e263ad32a1523e0a6323f4f0e6ced60e" does
not exist @ /var/www/private/pgblog_private/system/databases/pgsql.class.php
line 350
Mon 02 Jul 2012 20:52:03 EDT - 98.70.54.73 - 2 - pg_query(): Query
failed: ERROR:  column "gl_stories.title" must appear in the GROUP BY
clause or be used in an aggregate function @
/var/www/private/pgblog_private/system/databases/pgsql.class.php line
350
Mon 02 Jul 2012 20:52:14 EDT - 98.70.54.73 - 2 - pg_query(): Query
failed: ERROR:  column "gl_stories.date" must appear in the GROUP BY
clause or be used in an aggregate function @
/var/www/private/pgblog_private/system/databases/pgsql.class.php line
350
Mon 02 Jul 2012 20:52:34 EDT - 98.70.54.73 - 2 - pg_query(): Query
failed: ERROR:  column "gl_stories.title" must appear in the GROUP BY
clause or be used in an aggregate function @
/var/www/private/pgblog_private/system/databases/pgsql.class.php line
350
Mon 02 Jul 2012 20:55:33 EDT - 98.70.54.73 - Error, invalid username: 'admin'
Mon 02 Jul 2012 20:55:40 EDT - 98.70.54.73 - 2 - pg_query(): Query
failed: ERROR:  column "67b8bf5150a006c12953adf82b28e7bbe2477e21" does
not exist @ /var/www/private/pgblog_private/system/databases/pgsql.class.php
line 350



Let me know what I can do to help.

Regards,

- Dan Stoner