[horde] Installation problem

Thu Jan 16 17:56:11 UTC 2020

Em 16/01/2020 13:05, o1bigtenor escreveu:
> On Thu, Jan 16, 2020 at 9:32 AM Luis Felipe Marzagao
> <lfbm.andamentos at gmail.com> wrote:
>>
>> Em 16/01/2020 12:09, o1bigtenor escreveu:
>>> 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?????
>> You got horde-db-migrate to run, which is a good sign. But the error
>> appears to be still the same. At this point either you 1) set up a dev
>> install (https://www.horde.org/development/git) and try to fix the code
>> and submmit a fix; 2) file a bug report at https://bugs.horde.org/ or 3)
>> Try using MySQL
>>
> Greetings
>
> 1. Don't have any idea how I would 'fix' the code
> 2. Bug report has already been filed (as of 15 months ago)
> 3. Have been using Postgresql here for some projects and really was hoping
>      not to be having to learn 2 highly similar but still not the same
> SQL systems
>      at the same time.
> Maybe there could be an option 4
>
> 4. Have the dev team fix the issue
>
> (My guess is that using option 4 would mean either $10ks of funds or
> waiting until
> horde 6 is done - - - - by which time postgresql 13 or maybe 14 would
> be extant.)

Yes, unfortunatelly, the developers don´t always have the spare time to 
fix all pending codes. But, sure, you could hire professional assistance 
to get it fixed. As for pricing, I have no idea how much it would cost. 
Maybe it it´s simple. I don´t know. Take a look at the contact address 
here: https://www.horde.org/contact

> Oh well - - - - not much more for me to do here.
>
> Thanking you for your assistance