[horde] PostgreSQL script missing...

[Michael Robinson]

On Fri, 2014-08-15 at 20:14 +0200, Jan Schneider wrote:
> Zitat von Michael Robinson <plug_1 at robinson-west.com>:
> 
> >> > That documentation might have worked ten years ago, but it doesn't
> >> > today.  Horde 5.2.1 as I understand it is supposed to create the
> >> > database automatically.  There was nothing advanced in the Horde 3
> >> > days about using PostgreSQL.  Something has obviously changed where
> >> > the documentation on the web hasn't.  The create the database step is
> >> > erroneous because the scripts directory is gone in Horde 5.2.  My
> >> > database of choice is supposed to be supported, better in fact than
> >> > MySQL because it is a better database.
> >>
> >> >From the install instructions...
> >>
> >> 4. Creating databases
> >>
> >>    Once you created the database configuration in the previous step, you
> >> can create all database tables by hitting the ``Update all DB schemas``
> >> button in the configuration screen.
> >>
> >>   * Please note that this requires the database that you entered in the
> >> database configuration to already exist, and the configured database user
> >> to have sufficient permissions to create new tables in this database.*
> >>
> >> Emphasis mine...
> >>
> >> https://github.com/horde/horde/blob/master/horde/docs/INSTALL
> >>
> >> You create the database.
> >> You make sure the user you configure horde to use has the right permissions.
> >> You press the button.
> >> Horde only creates the tables.
> >>
> >> > With all due respect, I am asking on the public mailing list how to set
> >> > up PostgreSQL and I never said I am not willing to pay a reasonable
> >> > amount to get the information if necessary.  Rudeness is uncalled for
> >> > and will only serve to drive people away from open source products.
> >>
> >> You're not asking, you're demanding.  You're clearly not doing anything to
> >> look for the answers either.  Entitlement only serves to drive away
> >> developers who develop and support for free.
> >>
> >> Simon
> >
> > You don't know what I'm doing to try and figure this out Simon.  I'm
> > trying to find an sql script that will create the database and all the
> > tables, but none exists.  I never get to the update DB schemas button,
> > horde white screens on me.  I have not demanded anything, I am asking
> > publicly which means that the answer is going to be on google for
> > anybody who needs it if someone will just answer the question.  Using
> > postgresql was easy when I started using horde back in the horde 3 days,
> > but it has become extremely difficult to set PostgreSQL up today.
> > Software that isn't documented well, open source or not, is garbage.
> > The postrgresql documentation will NOT tell me how to set the database
> > up for horde.  Horde is supposedly supposed to set the database up for
> > horde.  Unfortunately, horde is white screening instead of creating the
> > database.  I have a horde user with the correct password and what should
> > be adequate permissions, but it's no go.
> 
> You may have a misunderstanding what "setting up a database" is  
> supposed to mean.
> 
> Yes, Horde *does* set up a database (in a broader sense) in that it  
> asks you for configuration details and creates all the tables.
> But it does *not* set up a database (in the technical sense) in that  
> it could create the database that is used to store the tables.
> 
> So you have to create the database in PG yourself, or use an existing  
> database. It's not demanding too much from you that you know (or  
> learn) how to do this, if you picked PG as your database system of  
> choice. Anything else is done by Horde, if you follow the install  
> instructions.
> 
> You won't get a PG tutorial here. If you don't want to learn or read  
> how to create a database in PG, you should instead use a different  
> install method for Horde like Bitnami VMs where everything comes  
> pre-configured.
> 
> -- 
> Jan Schneider
> The Horde Project
> http://www.horde.org/
> https://www.facebook.com/hordeproject
> 
Would it be hard to fix horde so that it doesn't white screen when the
database is set up properly permissions and all, but there are no tables
in it?  Found out you have to manually create horde_prefs and every
column that horde can't find to solve the white screening problem, but
why can't horde create those columns and the tables under them itself?