[CentOS] (OT): Horde initial SQL setup

Wed Jan 25 23:11:13 UTC 2012
Craig White <craig.white at ttiltd.com>

On Jan 25, 2012, at 3:45 PM, Bill Campbell wrote:

> On Wed, Jan 25, 2012, Craig White wrote:
>> 
>> On Jan 25, 2012, at 11:53 AM, Bill Campbell wrote:
>> 
>>> I haven't been able to find anything useful on the horde sites,
>>> and I haven't found anything useful with 'yum search'.
>>> 
> ...
>>> The options seem to be:
>>> 
>>>  + Get SQL scripts to create the necessary databases.
>>> 
>>>  + Find the appropriate SPRMs for the horde components to see how they
>>>    take care of this in their %post installation processing.
>>> 
>>>  + Uninstall the existing stuff using pear, and start from scratch after
>>>    first creating the appropriate database.
>>> 
>>>  + Give up and continue to use the older versions of horde components
>>>    which do work.
>>> 
>>> Suggestions, pointers to documentation, ???
>> ----
> 
>> you're going to have to make up your mind which you want to use, MySQL or
>> PostgreSQL
> 
> While I much prefer PostgreSQL, I have been using MySQL with
> horde as it looks like that's where there support is best.
> 
>> After that decision is made, you would simply create the databases using
>> the client tools of either or if you are unfamiliar/uncomfortable using
>> command line to create user/database/privileges for the database of choice,
>> you probably just want to use something like webmin (can do either postgres
>> or mysql), MySQL_Query_Browser (mysql) or PgAdmin3 (postgres)
> 
> I've been doing *nix systems since 1982 with Radio Shack Xenix so I'm fine
> with the CLI tools.  I've also done a fair amount of DB work in python and
> perl using their DBI modules.
> 
> What I haven't been able to find are the sql script files to do the initial
> database creation that were present in older versions of horde, imp,
> kronolith, turba, etc.
----
Don't quote me on this - you can probably get a better definitive answer from the horde mail list but I think the actual scripts are located in your PEAR directory (perhaps under Horde/Test)

Of course you need to get into mysql and create a user for horde, create a database for horde and grant permissions to the horde user for the horde database and obviously configure that in horde/config/conf.php (which should be possible with the web configuration tool.

Craig