FreeBSD 12.1 Setup Testing

factor · Dec 24, 2020

Humm...
/usr/local/directadmin/custombuild]# ./build mariadb
Extracting mariadb-10.4.17.tar.gz ...
Downloading mariadb-10.4.17/ports_patches/freebsd-mysql57-server-patches.tar.gz...
/usr/local/directadmin/custombuild/mariadb-10. 9 kB 15 MBps 00s
??
Looks like MariaDB is trying to install the patches from Mysql..

DirectAdmin Support · Dec 29, 2020

Brent, you're the man of the hour

I've pushed CB 2624 with the pkg -y fix.

Thanks for the report on the mysql patches when mariadb is being installed.
CB was only checking for mysql version 5.7, but didn't check for mysql_inst=mysql

CB 2625 now has this fix as well.

Thanks again! Happy New Year

John

factor · Dec 29, 2020

DirectAdmin Support said:
Brent, you're the man of the hour

No I am the regular guy.

Happy New Year to you all as well..

Testing it now...

PCRE:
All repositories are up to date.
The following 1 package(s) will be affected (of 0 checked):

New packages to be INSTALLED:
pcre: 8.44

Number of packages to be installed: 1

Successful.

Mysql 5.7

Successful

looks like the pkg -y issue us good.

Looks like we still have issue with ICU. It's either not installing with custombuild or we need it added to preinstall?

checking whether to enable internationalization support... yes
checking for icu-uc >= 50.1 icu-io icu-i18n... no
configure: error: Package requirements (icu-uc >= 50.1 icu-io icu-i18n) were not met:

Package 'icu-uc', required by 'virtual:world', not found
Package 'icu-io', required by 'virtual:world', not found
Package 'icu-i18n', required by 'virtual:world', not found

Consider adjusting the PKG_CONFIG_PATH environment variable if you
installed software in a non-standard prefix.

Alternatively, you may set the environment variables ICU_CFLAGS
and ICU_LIBS to avoid the need to call pkg-config.
See the pkg-config man page for more details.

*** There was an error while trying to configure php. Check the configure file

More later..

k1l0b1t · Dec 30, 2020

Brent, you made me interested to give BSD a try, nice

Happy New Year

factor · Dec 30, 2020

k1l0b1t said:
Brent, you made me interested to give BSD a try, nice

Happy New Year

Glad to hear it. I wish I had started sooner with it. It’s very logical. Some might call it old fashion. If you want to try you might follow my quick and dirty guide several posts back. The DA installer is better now not 100% but report back issues on a separate thread if you would.

We all can’t wait for 2020 to be gone hopefully 2021 will get better. Happy New Year. Stay safe.

factor · Dec 30, 2020

bdacus01 said:
More later..

After installing ICU with

Code:

pkg install -y icu

The Standard default install completes.

Going to do build all now.

factor · Dec 30, 2020

bdacus01 said:
Going to do build all now.

Build All completes

Going to repeat the test and look for clues as to why ICU fails to install.

@wattie @k1l0b1t @DirectAdmin Support
Question: Should I write some kind of How to on this for people? We dont really have OS based Guides for DA but could be helpful?

wattie · Dec 30, 2020

The thread itself is kind of howto

I used to put some installation notes back in time myself and I reused them when we upgraded to a better server. So yes, they are useful.

factor · Dec 30, 2020

wattie said:
The thread itself is kind of howto

Thanks Yes but not organized

wattie said:
installation notes back in time myself

I will be glad to incorporate you notes as well.

Writing a pf firewall how to soon. Really loving BSD.

k1l0b1t · Dec 30, 2020

bdacus01 said:
Build All completes

Going to repeat the test and look for clues as to why ICU fails to install.

@wattie @k1l0b1t @DirectAdmin Support
Question: Should I write some kind of How to on this for people? We dont really have OS based Guides for DA but could be helpful?

Yes, you should do it. That will help people in the future.

factor · Dec 30, 2020

bdacus01 said:
Going to repeat the test and look for clues as to why ICU fails to install.

Found it.
Cannot find libicu, installing using pkg...
Updating FreeBSD repository catalogue...
FreeBSD repository is up to date.
All repositories are up to date.
pkg: No packages available to install matching 'libicu' have been found in the repositories

The package is just called "icu" in FreeBSD not libicu

FreshPorts -- devel/icu: International Components for Unicode (from IBM)

The International Components for Unicode (ICU) is a C and C++ library providing Unicode support (ex. character set conversions, locales, normalization, transliteration, etc.). More information on ICU can be found on the homepage

www.freshports.org

in build
it's here

Code:

cd /usr/local/directadmin/custombuild
$cat build |grep libicu
            echo "Cannot find libicu, installing using pkg..."
            pkg install -y libicu

should be

Code:

cd /usr/local/directadmin/custombuild
$cat build |grep libicu
            echo "Cannot find icu, installing using pkg..."
            pkg install -y icu

wattie · Dec 31, 2020

My notes are outdated a lot.

Sadly my current system is stalled for many updates because I must keep OpenSSL on version 1.0.2. Hopefully in near future we can get rid of the superoutdated websites and we can move on...

factor · Dec 31, 2020

wattie said:
superoutdated websites and we can move on...

is this at University? I hope you have luck converting.

factor · Dec 31, 2020

ICU issue fixed

bdacus01 said:
Found it.
Cannot find libicu, installing using pkg...
Updating FreeBSD repository catalogue...
FreeBSD repository is up to date.
All repositories are up to date.
pkg: No packages available to install matching 'libicu' have been found in the repositories

The package is just called "icu" in FreeBSD not libicu

FreshPorts -- devel/icu: International Components for Unicode (from IBM)

The International Components for Unicode (ICU) is a C and C++ library providing Unicode support (ex. character set conversions, locales, normalization, transliteration, etc.). More information on ICU can be found on the homepage

www.freshports.org

in build
it's here

Code:

cd /usr/local/directadmin/custombuild $cat build |grep libicu echo "Cannot find libicu, installing using pkg..." pkg install -y libicu

should be

Code:

cd /usr/local/directadmin/custombuild $cat build |grep libicu echo "Cannot find icu, installing using pkg..." pkg install -y icu

Updating FreeBSD repository catalogue...
FreeBSD repository is up to date.
All repositories are up to date.
The following 1 package(s) will be affected (of 0 checked):

New packages to be INSTALLED:
icu: 67.1,1

Number of packages to be installed: 1

Works thanks John..

factor · Jan 1, 2021

I am happy to report the Standard DA install with Mysql 5.7 fully installs in one session now.
It also will survive a ./build all and work well.
I then upgrade mysql 5.7 to version mysql 8 and had no errors.

Mysql Version 8 does not survive a ./build all it compiles which fails. Hunting that down.

Ok I found the issues and sent it all in to John. Who I assume is tired of me by now...

factor · Jan 1, 2021

the latest cmake for Mariadb up to 10.4
is

Code:

#!/bin/sh
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DFORCE_INSOURCE_BUILD=1 \
-DWITH_EXTRA_CHARSETS=all \
-DPLUGIN_AUTH_GSSAPI=NO \
-DPLUGIN_TOKUDB=NO \
-DPLUGIN_ROCKSDB=NO \
-DWITHOUT_MROONGA=YES

Please dont install mariaDB 10.5. Its still under investigation.

Thanks

factor · Jan 1, 2021

For Mysql 8 to compile
you need
Boost Libs installed

Code:

pkg install -y boost-libs

and cmake

Code:

#!/bin/sh
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DFORCE_INSOURCE_BUILD=1 \
-DWITH_EXTRA_CHARSETS=all \
-DWITH_BOOST=system \
-DWITH_PROTOBUF=system

wattie · Jan 2, 2021

bdacus01 said:
the latest cmake for Mariadb up to 10.4
is...

Compared to yours, mine still have these (guess they are not needed):

-DWITH_ZLIB=system \
-DWITH_JEMALLOC=system \
-DWITH_LIBWRAP=1 \

And yours have DFORCE_INSOURCE_BUILD=1: I am unsure if this is needed

factor · Jan 2, 2021

wattie said:
Compared to yours, mine still have these (guess they are not needed):

-DWITH_ZLIB=system \
-DWITH_JEMALLOC=system \
-DWITH_LIBWRAP=1 \

And yours have DFORCE_INSOURCE_BUILD=1: I am unsure if this is needed

Well based on the corrections to the build script These seem to work for me. I was trying to use as little options as possible.

I need to test the in source build addition again. I know it’s need for MySQL for sure

I also have tested so much my eyes could be crossed.

factor · Jan 2, 2021

wattie said:
Compared to yours, mine still have these (guess they are not needed):

-DWITH_ZLIB=system \
-DWITH_JEMALLOC=system \
-DWITH_LIBWRAP=1 \

And yours have DFORCE_INSOURCE_BUILD=1: I am unsure if this is needed

Well in looking at cmake -LH for MariaDB 10.4
with zlib it uses System by default
// Which zlib to use (possible values are 'bundled' or 'system')
WITH_ZLIB:STRING=system
So its not needed.

jemaloc gives
// Build with jemalloc. Possible values are 'yes', 'no', 'static', 'auto'
WITH_JEMALLOC:STRING=auto
There is no System so I dont think its working.. They also fixed this in the ./build

For TCPwrappers. I think you might be right it is Off by default
// Compile with tcp wrappers support
WITH_LIBWRAP:BOOL=OFF
So this should be
-DWITH_LIBWRAP=ON \
Also I have noted seems Mariadb use ON and OFF instead of 1 or 0

if we want federated we would add
// How to build plugin FEDERATED. Options are: NO STATIC DYNAMIC YES AUTO.
PLUGIN_FEDERATED:STRING=DYNAMIC
-DPLUGIN_FEDERATED=STATIC

As a note I dont think we need
-DWITH_INNOBASE_STORAGE_ENGINE=1
-DWITH_EXTRA_CHARSETS=all
Because on both Mysql and mariadb its defaulted as on. All compiled in as Static.

Going to retest.

FreeBSD 12.1 Setup Testing

Verified User

Administrator

Verified User

Verified User

Verified User

Verified User

Verified User

Verified User

Verified User

Verified User

Verified User

Verified User

Verified User

Verified User

Verified User

Verified User

Verified User

Verified User

Verified User

Verified User