[horde] Set Privileges between Horde and MySQL

[Johannes Mock]

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.

Can someone tell me the whole path to "/static" and how I can fix this
problem with "/static"?

Greeting
Johannes