[turba] how wrong is this?

Zemon zemon at ananzi.co.za
Tue Oct 21 02:01:18 PDT 2003


You seem to need an introduction to is the postgresql ORDMS
(http://www.postgresql.org/) and then you might have a better chance
with applications that depend on SQL e.g. Horde

Reading is really a required skill especially you don't have an idea of
what is what (Horde, Postgresql, *nix ethos).  This should have been your first
step! i.e RTFM - especially when your *nix skill level is basic.
* on the Fri, Oct 17, 2003 at 12:06:53PM -0400, Eric S. Johansson was tippering:
> the instructions for creating tables in the horde database are woefully 
> inadequate.  When you go to the postgresql script you are given the 
> instructions:
> 
> -- You can simply execute this file in your database.
> --
> -- Run as:
> --
> -- $ psql -d pgsql_create.sql
> 
> which leaves me scratching my chin and wonder what "simply executing this 
> filing your database" means.  I thought database is stored data.  so I try 
> the command and get:
> 
> [root at relay2 drivers]# psql -d pgsql_create.sql
> psql: FATAL:  IDENT authentication failed for user "root"
> 
> simple I think, let's run as the database owner horde...
> 
> [root at relay2 drivers]# psql -d pgsql_create.sql -U horde -W
> Password:
> psql: FATAL:  Database "pgsql_create.sql" does not exist in the system 
> catalog.
> 
> curses, foiled again.
> 
> So reading through the postgresql documentation (reminding myself why I 
> have steadfastly avoided databases for 20 years), I set up authentication 
> changes and when I am able to list databases as root, I run this command 
> line:
>  psql -d horde -f pgsql_create.sql -U horde -W
> 
> which gives me the results:
> 
> 
> [root at relay2 drivers]# psql -d horde -f pgsql_create.sql -U horde -W
> Password:
> psql:pgsql_create.sql:8: ERROR:  parser: parse error at or near "CONNECT" 
> at character 1
> psql:pgsql_create.sql:29: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
> implicit index 'turba_objects_pkey' for table 'turba_objects'
> CREATE TABLE
> CREATE INDEX
> GRANT
> 
> does this mean success or does this mean failure?  Beats the heck out of 
> me.  I don't have enough knowledge to know and the documentation doesn't 
> say.


More information about the turba mailing list