[horde] Installation Horde 6
R.J.Baart at Prompt.nl
R.J.Baart at Prompt.nl
Sun Feb 1 22:25:03 UTC 2026
Just found the problem:
modify the table:
alter table turba_objects add column object_photoorig bytea ;
Op 1-2-2026 om 22:48 schreef R.J.Baart at Prompt.nl:
> 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
>>>>>>
>>>>
More information about the horde
mailing list