[geeklog-devel] postgresql and Geeklog 2.0.0b1

[Stanislav Palatnik]

Hello Dan,

Thanks for bringing this up. Can you verify if the admin account was added
to PostgreSQL. There should be an entry for a username "Admin" in the
"gl_users" table(if you used the default database name).

I think the problem has something to do with the gl_topic_assignments
table. I'm not sure why its id is a varchar(40).

On Mon, Jul 2, 2012 at 9:09 PM, Dan Stoner <danstoner at gmail.com> wrote:

> 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
> _______________________________________________
> geeklog-devel mailing list
> geeklog-devel at lists.geeklog.net
> http://eight.pairlist.net/mailman/listinfo/geeklog-devel
>
> --
> --
> My Best,
>
> Stanislav Palatnik
>
>  <http://eight.pairlist.net/mailman/listinfo/geeklog-devel>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://pairlist8.pair.net/pipermail/geeklog-devel/attachments/20120702/af3940b6/attachment.html>