[horde] PostgreSQL script missing...

[Jan Schneider]

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