[horde] Installation problem

[o1bigtenor]

On Thu, Jan 16, 2020 at 8:52 AM Luis Felipe Marzagao
<lfbm.andamentos at gmail.com> wrote:
>
>
> Em 15/01/2020 20:40, o1bigtenor escreveu:
snip
> >>>>>> Working on installing horde groupwebmail on a debian buster (10) where
> >>>>>> apache 2.4.38, postgresql 11.5 and php 7.3.
> >>>>>>
> >>>>>> Chose to install using  # apt install  and the installation completed easily.
> >>>>>> It was in working through the configuration that a roadblock occurred.
> >>>>>>
> >>>>>> Quoting the terminal output:
> >>>>>>
> >>>>>> Creating and updating database tables...
> >>>>>>      Fatal Error:
> >>>>>>      SQLSTATE[42703]: Undefined column: 7 ERROR:  column "increment_by"
> >>>>>> does not exist
> >>>>>>      LINE 1: ...q', (SELECT COALESCE(MAX("sentmail_id") + (SELECT
> >>>>>> increment_...
> >>>>>>                                                                   ^
> >>>>>>      In /usr/share/php/Horde/Db/Adapter/Pdo/Base.php on line 233
> >>>>>>
> >>>>>>
> >>>>>> How do I resolve this?
> >>>>>>
> >>>>>>
> >>>>>> Apparently your database was not correctly created. Try running
> >>>>>> /usr/bin/horde-db-migrate from the command line.
snip
> >>>> If your db server is ok, then you had some problem when the database was
> >>>> created or you are missing horde dependencies, which could be caused by
> >>>> a broken distro package install, or, as Jan has already mentioned,
> >>>> "there are some patches for newer Postgresql versions on GitHub that
> >>>> haven't been incorporated yet. Feedback on those is welcome."
> >>> If you would be so kind as to point me to where I could find those
> >>> patches . . .    .
> >>
> >> You could start here: https://github.com/horde/Db/commits/master
> >>
> > OK s o I can see the patch. When I'm reading the code (total noob to
> > coding here)
> > I can understand what the change is. What I have no clue how to do (looked into
> > both the use of the program 'patch' and a few write ups on doing a git
> > patch but
> > its not clear how I do this.
> > Did some looking and have found the file on my system. Also have the 'patch'
> > available. Have not ever done this - - - - so - - - do I add the new
> > lines into the
> > file and remove the unwanted lines then save the new version?
> > Would this 'apply' the patch?
>
> It may be tricky to apply patches because you are not using a
> development installation. But if you think you´ve found the correct
> patch, and if there aren´t a lot of files involved in the commit, go
> ahead and try to manually replace the entire file. Dirty hack but pretty
> fast in order to make a quick test.
>
Greetings

So I applied the patch (meaning that I added in the new lines indicated in
green and removed the lines indicated in pink) and saved the file.
Tried one more time to effect and install.
Right back to where I started at :

Fatal Error:
  SQLSTATE[42703]: Undefined column: 7 ERROR:  column "increment_by"
does not exist
  LINE 1: ...q', (SELECT COALESCE(MAX("sentmail_id") + (SELECT
increment_...
                                                               ^
  In /usr/share/php/Horde/Db/Adapter/Pdo/Base.php on line 233

had been told earlier to try to use   /usr/bin/horde-db-migrate   which gives:

 # /usr/bin/horde-db-migrate
[  INFO  ] Migrating DB up.
[  INFO  ] Current imp schema version: 1
Migrating to ImpAutoIncrementSentmail (2)
== 2 ImpAutoIncrementSentmail: migrating ======================================
-- changeColumn('imp_sentmail', 'sentmail_id', 'autoincrementKey')
SQLSTATE[42703]: Undefined column: 7 ERROR:  column "increment_by"
does not exist
LINE 1: ...q', (SELECT COALESCE(MAX("sentmail_id") + (SELECT increment_...

and about a hundred more lines like the above.
Searching on the horde website then led me to  - - - -   bug number :

[#14878] Sequence reset incompatible with PostgreSQL 10+

bug listed november 2018 with a comment in early 2019 and nothing further

Seems to suggest that I'm not going to get an install.

Oh well - - - - suggestions?????