[GNC-dev] Build Fail for GC 4.1 on Linux MInt 20

[David Cousens]

Hi John,
I didn't have either Mysql-8.0 or Mariadb-10.3 installed, either client or server at the time. Another user Mark
reported having built 4.1 from the maint branch without any problem. I also tried going back and rebuilding 3.905 and
3.10 and had the same problem. I am trying installing both mysql-80 and mariaDB (both are available on LM 20) to see if
something in the install there fixes it. Cmake doesn't throw up anything in the testing apart from gettext being
0.19.8.1 rather than 0.20. It may be something else which was previously in the default setup for LM 19 that was no
longer part of 20.  GC v4.0 is the default distro install and it runs fine. 
David

On Sun, 2020-08-02 at 20:40 -0700, John Ralls wrote:
> David,
> 
> The problem is very likely that Mint uses MySQL and MySQL-8 has dropped the C connector. Libdbi-drivers is no longer
> being maintained so there's no way to use the C++ connector that MySQL has replaced it with. Your best bet for now is
> probably to change to a distro that uses MariaDB as that appears to be unaffected for now.
> 
> Regards,
> John Ralls
> 
> > On Aug 2, 2020, at 8:16 PM, David Cousens <davidcousens at bigpond.com> wrote:
> > 
> > John, Frank,
> > 
> > Not sure what is happening here. Wehn Linux Mint 20 was released it was released with GnuCash 4.0 so someone
> > succeeded
> > in building it. I'v put a queston on the Mint forums to see if anyone there has had a similar proble. The same patch
> > versions of libdbi and the drivers are in the Ubuntu Focal release as well so i would have expected others to have
> > had
> > problems if it was something general.
> > 
> > David
> > 
> > On Sat, 2020-08-01 at 10:06 -0700, John Ralls wrote:
> > > > On Jul 31, 2020, at 9:15 PM, David Cousens <davidcousens at bigpond.com> wrote:
> > > > 
> > > > Has anyone had any problems building GC 4.1 on Linux (Mint 20 Ulyana)? Cmake completes without problems, but I
> > > > am
> > > > getting multiple errors during the ninja build related to the database backend libraries:
> > > > 
> > > > libdbi: Failed to load driver: /usr/lib/x86_64-linux-gnu/dbd/libdbdmysql.so
> > > > wrote `/home/david/Applications/gnucash-4.1/build/lib/x86_64-linux-gnu/guile/3.0/site-
> > > > ccache/gnucash/deprecated/gnucash/report/payables.go'
> > > > 
> > > > The default versions on LM20 of libdbi and the libdbd modules are:
> > > > dpkg -l | grep libdbi
> > > > ii  libdbd-mysql:amd64                                          0.9.0-
> > > > 8ubuntu1                      amd64        MySQL
> > > > database server driver for libdbi
> > > > ii  libdbd-pgsql:amd64                                          0.9.0-
> > > > 8ubuntu1                      amd64        PostgreSQL database server driver for libdbi
> > > > ii  libdbd-sqlite3:amd64                                        0.9.0-
> > > > 8ubuntu1                      amd64        SQLite3 
> > > > database driver for libdbi
> > > > ii  libdbi-dev                                                  0.9.0-
> > > > 5                             amd64        DB
> > > > Independent Abstraction Layer for C  -- development files
> > > > ii  libdbi1:amd64                                               0.9.0-5 
> > > > 
> > > > 0.8.3 of the above are the required version in the dpkg -l | grep libdbi
> > > > ii  libdbd-mysql:amd64                                          0.9.0-
> > > > 8ubuntu1                      amd64        MySQL
> > > > database server driver for libdbi
> > > > ii  libdbd-pgsql:amd64                                          0.9.0-
> > > > 8ubuntu1                      amd64        PostgreSQL database server driver for libdbi
> > > > ii  libdbd-sqlite3:amd64                                        0.9.0-
> > > > 8ubuntu1                      amd64        SQLite3 
> > > > database driver for libdbi
> > > > ii  libdbi-dev                                                  0.9.0-
> > > > 5                             amd64        DB
> > > > Independent Abstraction Layer for C  -- development files
> > > > ii  libdbi1:amd64                                               0.9.0-5 
> > > > 
> > > > 
> > > > dpkg -l | grep libdbi
> > > > ii  libdbd-mysql:amd64                                          0.9.0-
> > > > 8ubuntu1                      amd64        MySQL
> > > > database server driver for libdbi
> > > > ii  libdbd-pgsql:amd64                                          0.9.0-
> > > > 8ubuntu1                      amd64        PostgreSQL database server driver for libdbi
> > > > ii  libdbd-sqlite3:amd64                                        0.9.0-
> > > > 8ubuntu1                      amd64        SQLite3 
> > > > database driver for libdbi
> > > > ii  libdbi-dev                                                  0.9.0-
> > > > 5                             amd64        DB
> > > > Independent Abstraction Layer for C  -- development files
> > > > ii  libdbi1:amd64                                               0.9.0-5 
> > > > 
> > > > README.dependencies specifies v0.8.3 of the above libraries. Does anyone else have problems building with 0.9.0
> > > > or
> > > > will
> > > > I have to revert?
> > > 
> > > Libdbi 0.9.0 has been out for almost 10 years and is what most distros have been shipping since. That's not the
> > > problem. More likely is that MySQL/MariaDB got upgraded and the libdbd-drivers didn't so libdbdmysql.so can't link
> > > libmysql.so.
> > > 
> > > Regards,
> > > John Ralls
> > > 
-- 
Dr David R Cousens
B.Sc, M.Prof. Acc., Ph.D., G.C.Ed