[horde] Set Privileges between Horde and MySQL

[Johannes Mock]

On 08/23/2014 03:42 PM, Johannes Mock wrote:
> On 08/21/2014 04:47 PM, lst_hoe02 at kwsoft.de wrote:
>> Zitat von Johannes Mock <mockjs at idmt.fraunhofer.de>:
>>
>>> That's clear. But I can't find any documentation how to do so.
>>> All I can find is:
>>> CREATE DATABASE horde;
>>> GRANT ALL PRIVILEGES ON horde.* TO 'horde'@'localhost' IDENTIFIED BY
>>> 'horde';
>>> FLUSH PRIVILEGES;
>>> I do so as mysql root-user.
>>>
>>> In the mysql table "db" there is now the following:
>>> | Host      | Db      | User  | Select_priv | Insert_priv | Update_priv
>>> | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv |
>>> Index_priv | Alter_priv | Create_tmp_table_priv | Lock_tables_priv |
>>> Create_view_priv | Show_view_priv | Create_routine_priv |
>>> Alter_routine_priv | Execute_priv | Event_priv | Trigger_priv |
>>> | localhost | horde   | horde | Y           | Y           | Y
>>> | Y           | Y           | Y         | N          | Y               |
>>> Y          | Y          | Y                     | Y                |
>>> Y                | Y              | Y                   |
>>> Y                  | Y            | Y          | Y            |
>>>
>>> In the table "user" there is set as host "localhost", as user "horde"
>>> and the password.
>>>
>>> Which settings must I configure and how?
>>> And which PHP and PEAR modules do I need?
>>> The following are installed:
>>> - php.x86_64
>>> - php-gd.x86_64
>>> - php-mysql.x86_64
>>> - php-xmlrpc.x86_64
>>> - php-xml.x86_64
>>> - php-imap.x86_64
>>> - php-ldap.x86_64
>>> - php-devel.x86_64
>>> - php-odbc.x86_64
>>> - php-pdo.x86_64
>>> - MySQL-python.x86_64
>>> - php-pear.noarch
>>> - re2c.x86_64
>>> - geoip.x86_64
>>> - telnet-0.17-47.el6_3.1.x86_64
>>> - libicu-4.2.1-9.1.el6_2.x86_64
>>> - php-intl-5.3.3-23.el6_4.x86_64
>>> - libmcrypt-2.5.8-9.el6.x86_64
>>> - libtidy-0.99.0-19.20070615.1.el6.x86_64
>>> - php-tidy-5.3.3-23.el6_4.x86_64
>>> - php-mcrypt-5.3.3-1.el6.rf.x86_64
>>> - php-idn-1.2c-1.el6.x86_64
>>> - php-soap-5.3.3-23.el6_4.x86_64
>>> - php-mbstring-5.3.3-23.el6_4.x86_64
>>>
>>> greetings
>>>
>>> On 08/21/2014 02:47 PM, lst_hoe02 at kwsoft.de wrote:
>>>> As "admin" user you have to first configure your database access
>>>> (user/password/location/db-name) in the stanza "database". Then you
>>>> have to configure the different settings to use the (SQL) database.
>>>> And of course your PHP and PEAR should include the modules needed to
>>>> access the database of choice.
>> You should use test.php (http://your-server/horde/test.php) as
>> explained here:
>> http://www.horde.org/apps/horde/docs/INSTALL
>> With this you should get a idea about what requirements are
>> fullfilled. If all is ok you go to 
>> http://your-server/horde/admin/config and set the database parameters
>> as explained.
>>
>> Regards
>>
>> Andreas
> Using test.php most requirements are highlighted green, some yellow and
> one red:
>
>
>   Local File Permissions
>
>   * Is /var/www/html/horde/lib/../static writable by the web server
>     user? *No*
>     *If caching javascript and CSS files by storing them in static files
>     (HIGHLY RECOMMENDED), this directory must be writable as the user
>     the web server runs as%s.*
>
>
> But I can't find a file called "/static" under this directory.
> So I use chown and chmod to change the rights for the web server, in
> hope, "/static" will be generated automatically. Well, it wasn't.
Sorry, I missed something: I changed the rights for the whole directory
"/var/www/html/horde/lib/"
>
> Can someone tell me the whole path to "/static" and how I can fix this
> problem with "/static"?
>
> Greeting
> Johannes