[horde] Installation Horde 6
R.J.Baart at Prompt.nl
R.J.Baart at Prompt.nl
Sun Feb 1 21:48:22 UTC 2026
Finally almost everything works. I will publish the way I installed
Horde6 + nginx. It was far from easy. Every time there was something
else that was a problem.
For now I have Horde working with Dovecot, nginx and Postfix on a Debian
Trixie system. Also cCalendar, tasks, mail, contacts. Also with active
sync (on Android) en Dav calendars.
One problem though, I can't see the details of a contact in detail. I
see the contact list but not the detail of a contact. Database error:
ERROR: column "object_photoorig" does not exist at character 300
2026-02-01 22:36:36.650 CET [1031446] dba_horde6 at horde6 STATEMENT:
SELECT object_id, owner_id, object_type, object_members, object_uid,
object_firstname, object_lastname, object_middlenames,
object_nameprefix, object_namesuffix, object_alias,
object_yomifirstname, object_yomilastname, object_bday,
object_anniversary, object_spouse, object_photo, object_phototype,
object_photoorig, object_homestreet, object_homepob, object_homecity,
object_homeprovince, object_homepostalcode, object_homecountry,
object_workstreet, object_workpob, object_workcity, object_workprovince,
object_workpostalcode, object_workcountry, object_otherstreet,
object_otherpob, object_othercity, object_otherprovince,
object_otherpostalcode, object_othercountry, object_department,
object_manager, object_assistant, object_tz, object_email,
object_homephone, object_homephone2, object_homefax, object_workphone,
object_workphone2, object_cellphone, object_carphone, object_radiophone,
object_companyphone, object_assistantphone, object_fax, object_pager,
object_title, object_role, object_company, object_logo, object_logotype,
object_notes, object_url, object_freebusyurl, object_pgppublickey,
object_smimepublickey, object_imaddress, object_imaddress2,
object_imaddress3 FROM turba_objects WHERE object_id IN ('<some id>')
AND owner_id = '<email address>'
Someone?
Op 26-1-2026 om 10:14 schreef R.J.Baart at prompt.nl:
> Op 25-1-2026 om 23:50 schreef Brent:
>>
>> Ensure that your <installdir>/horde/* is writable by the web user,
>> typically apache. If it isn't, then obviously apache can't write the
>> conf.php file to disk.
>>
> yes it is. I realize I wasn't clear: I can change the conf.php from
> web interface only if I does not change the database settings. In the
> beginning I think I made an error with file ownership. At some point I
> did "chown -R www-data:www-data" for the whole filestructure. I did
> the first installation however as root.
>>
>> I have dovecot 2.4.1 and use it to auth Horde 6.
>>
> Same Dovecot version here. But I see no emails. Dovecot is working. I
> have a working Thunderbird client on distance and did a telnet test
> local.
>>
>> Webroot dir setup in apache would be <install-dir>/web...not just
>> <installdir>.
>>
> so have I
>>
>>
>> So, I have /var/www/horde as my install dir, but my web root is
>> /var/www/horde/web
>>
> me too
>>
>>
>> This is a little different than H5.
>>
>> The REAL conf.php is in:
>>
>> <install-dir>/var/config/horde/conf.php
>>
>> There will be a symlink to this in vendor...
>>
>> <install-dir>/vendor/horde/horde/config/conf.php ->
>> <install-dir>var/config/horde/conf.php
>>
> <install-dir>/vendor/horde/horde/config/conf.php was missing. I think
> after the update procedure following the instructions from Ralf Lang -
> see below. However <install-dir>var/config/horde/conf.php is there.
> The error "Please create...." is coming from the index.php. The test
> in this file does not work correctly in my setup (after the Ralf Lang
> instructions). If I bypass this check and go directly to
> horde/index.php I get the login screen.
>
> Even after adding the link the home page does not work.
>
> ls -l horde/vendor/horde/horde/config/conf.php
> lrwxrwxrwx 1 www-data www-data 63 Jan 25 17:19
> horde/vendor/horde/horde/config/conf.php ->
> /home/websites/webmail.tiswe.fr/horde/var/config/horde/conf.php
>
>>
>> $ ls -l /var/www/horde/vendor/horde/horde/config/conf.php
>> lrwxrwxrwx 1 apache apache 40 Jul 3 2025
>> /var/www/horde/vendor/horde/horde/config/conf.php ->
>> /var/www/horde/var/config/horde/conf.php
>>
>> Here's the relevant sql stuff for my working config in conf.php:
>>
>> $conf['sql']['username'] = 'hordeuser';
>> $conf['sql']['password'] = '****pass***';
>> $conf['sql']['socket'] = 'localhost';
>> $conf['sql']['port'] = 5432;
>> $conf['sql']['protocol'] = 'unix';
>> $conf['sql']['database'] = 'horde6';
>> $conf['sql']['charset'] = 'utf-8';
>> $conf['sql']['splitread'] = false;
>> $conf['sql']['logqueries'] = false;
>> $conf['sql']['phptype'] = 'pgsql';
>>
> I have some differences:
>
> $conf['sql']['username'] = '<dba user>';
> $conf['sql']['password'] = '******';
> $conf['sql']['hostspec'] = 'localhost';
> $conf['sql']['protocol'] = 'tcp';
> $conf['sql']['database'] = 'horde6';
> $conf['sql']['charset'] = 'utf-8';
> $conf['sql']['splitread'] = false;
> $conf['sql']['logqueries'] = false;
> $conf['sql']['phptype'] = 'pgsql';
>
> But my connection to the database works.
>
>>
>>
>> brent
>>
>> Quoting R.J.Baart at prompt.nl:
>>
>>> All in all, I find it rather difficult. One of the problems I have
>>> is that the configuration horde/conf.php cannot be saved because
>>> every time I try, I get an error saying that the database details
>>> are incorrect, and then the error mentioned in my previous email
>>> appears in the logging.
>>>
>>> Not finding a solution for this problem, I decided to write the
>>> configuration myself in horde/conf.php. That works, and I then have
>>> a connection to the database. The database is also filled with
>>> tables, so that's fine.
>>>
>>> I can now also log in, so authentication via imp works.
>>> $conf[‘auth’][‘params’][‘app’] = ‘imp’;
>>> $conf[‘auth’][‘driver’] = ‘application’;
>>> After the login screen looks pretty good, like with Horde 5.
>>>
>>> But still problems.
>>>
>>> - error writing conf.php it is not practical at all.
>>>
>>> - I can't read my email. Dovecot is the imap server. In Horde 5 that
>>> worked immediately, now it doesn't. I don't see why. Nog errors in
>>> the logfiles, on screen "error when communicating with the server".
>>> I suppose it is something between dovecot (2.4) and Horde 6.
>>>
>>> Desperate I followed some update procedures from Ralf Lang:
>>>
>>> # Allow unreleased development code from branch
>>> composer config minimum-stability dev
>>> # Prefer released alpha, beta or stable code over less stable
>>> versions
>>> composer config prefer-stable true
>>> # Install the new version of the installer plugin
>>> composer require horde/horde-installer-plugin "^3 ||
>>> dev-FRAMEWORK_6_0"
>>> # Update everything according to environment set above
>>> composer update
>>> # Transition from symlink mode to proxy mode and rewrite
>>> registry files
>>> composer horde:reconfigure --force
>>>
>>> That resulted in some updates but not the result I hoped for. In
>>> ended that the login screen says:
>>>
>>> Please create a /<website
>>> directory>/horde/var/config/horde/conf.php file and then run
>>> 'composer horde-reconfigure' to activate Horde
>>>
>>> The file can't be created, it exists already and is read if login
>>> using the link
>>>
>>> https://<myserver>/horde/index.php
>>>
>>> This way I skip the error. But still not see my mail.
>>>
>>> I think I'm close but pff....
>>>
>>> Op 25-1-2026 om 19:15 schreef Brent:
>>>
>>>> I'd type in the port used for your database, just to be complete.
>>>> I had not setup postgresql before, so I just did it and it works
>>>> for me. A few things to test/check:
>>>>
>>>> Enable the test.php and ensure that you have all necessary php
>>>> modules installed, key would be php-pgsql
>>>>
>>>> Verify that you can connect to this db from the shell using this
>>>> user AND create a table.
>>>>
>>>> $ psql -h localhost -p 5432 -U mydatabase_user mydatabase_name
>>>> (type in password)
>>>>
>>>> If that also works, then be sure you can create a table as that user:
>>>>
>>>> mydatabase_name-> create table test123 (testname varchar(255) );
>>>>
>>>> If that works, then the database is operational.
>>>>
>>>> Next up would be the verify that you have the right stuff installed
>>>> via composer. Critical could be the DB package:
>>>>
>>>> $ sudo -u apache composer show | grep -i db
>>>> horde/db 3.0.0alpha6 Database abstraction
>>>> library
>>>>
>>>> See if any of that helps you.
>>>>
>>>> Good luck!
>>>>
>>>> brent
>>>>
>>>> Quoting Ruud Baart <r.j.baart at prompt.nl>:
>>>>
>>>>> Hi,
>>>>>
>>>>> Hope anyone can help.
>>>>>
>>>>> Thanks to Brent's brief instructions, I have now made considerable
>>>>> progress with the installation of Horde 6 on my new Debian trixie
>>>>> server (PHP8.4, Posgresql 17, nginx). I can now configure the
>>>>> server. It's pretty similar to Horde 5, so I think I understand it
>>>>> reasonably well. However, I'm going around in circles because I'm
>>>>> getting an error message that I can't resolve.
>>>>>
>>>>> The message is:
>>>>>
>>>>> Undefined variable $results [pid 329592 on line 1242 of "/<my
>>>>> webroot
>>>>> dir>/horde/vendor/horde/db/lib/Horde/Db/Adapter/Postgresql/Schema.php"]
>>>>>
>>>>> This message appears when I configure the “SQL Database Settings”:
>>>>>
>>>>> $conf[sql][phptype] PostgreSQL
>>>>>
>>>>> $conf[sql][username] mydatabase_user
>>>>>
>>>>> $conf[sql][password] ****
>>>>>
>>>>> $conf[sql][protocol] tcp/ip
>>>>>
>>>>> $conf[sql][hostspec] localhost
>>>>>
>>>>> $conf[sql][port] <empty>
>>>>>
>>>>> $conf[sql][database] mydatabase_name
>>>>>
>>>>> $conf[sql][charset] utf-8
>>>>>
>>>>> $conf[sql][splitread] Disabled
>>>>>
>>>>> Nothing fancy there, I think.
>>>>>
>>>>> --
>>>>> Horde mailing listFrequently Asked Questions:
>>>>> http://horde.org/faq/To unsubscribe, mail:
>>>>> horde-unsubscribe at lists.horde.org
>>>>>
>>>
--
Cordialement,
*
R.J. Baart
Portable: +33 7 88398245
*
More information about the horde
mailing list