Raspberry Pi - Buster - mysql

[OneOfTheInfiniteMonkeys]

Hi,
I have been attempting an install of Snorter on a Raspberry Pi and debugging my way through some issues.

The most significant of which seems to be with mysql.

I have been manually stepping through the install script and this is where I have got to:

Command:
sudo apt-get install -y --force-yes mysql-server libmysqlclient-dev mysql-client autoconf libtool libdnet checkinstall yagiuda libdnet-dev locate

Issue:
Reading package lists... Done
Building dependency tree
Reading state information... Done
Package mysql-client is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source
However the following packages replace it:
mariadb-client-10.0

Package mysql-server is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source
However the following packages replace it:
mariadb-server-10.0

Package libmysqlclient-dev is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source
However the following packages replace it:
libmariadb-dev-compat libmariadb-dev

W: --force-yes is deprecated, use one of the options starting with --allow instead.
E: Package 'mysql-server' has no installation candidate
E: Package 'libmysqlclient-dev' has no installation candidate
E: Package 'mysql-client' has no installation candidate

Supporting Reference
I used mysql for a number of years on a personal Raspbery Pi project. When it was dropped from the distribution I switched over to mariaDB (which has operated just as well). Below is one of the many articles I read at the time.
https://devops.com/will-mariadb-soon-replace-mysql/

Commentry
Having installed mariaDB manually and manually configured the database. The next stumbling block became a file referenced for barnyard2 is not available i.e. mysql.h.

What is the best approach to take at this point?
Can (or should) the system be made to work with mariaDB or is it necessary to install mysql?
If it were possible to obtain mysql.h, would that be all barnyard2 needs to complete a make?

Finally with either approach, would a script modificaiton to install the preferred solution be available at some point?

Lookforward to hearing.

Version information
pi@pipig:~ $ cat /etc/os-release
PRETTY_NAME="Raspbian GNU/Linux 10 (buster)"
NAME="Raspbian GNU/Linux"
VERSION_ID="10"
VERSION="10 (buster)"
VERSION_CODENAME=buster
ID=raspbian
ID_LIKE=debian
HOME_URL="http://www.raspbian.org/"
SUPPORT_URL="http://www.raspbian.org/RaspbianForums"
BUG_REPORT_URL="http://www.raspbian.org/RaspbianBugs"

pi@pipig:~ $ uname -a
Linux pipig 5.4.51-v7+ #1333 SMP Mon Aug 10 16:45:19 BST 2020 armv7l GNU/Linux
pi@pipig:~/barnyard2 $ cat /proc/cpuinfo
processor : 0
model name : ARMv7 Processor rev 5 (v7l)
BogoMIPS : 42.66
Features : half thumb fastmult vfp edsp neon vfpv3 tls vfpv4 idiva idivt vfpd32 lpae evtstrm
CPU implementer : 0x41
CPU architecture: 7
CPU variant : 0x0
CPU part : 0xc07
CPU revision : 5

processor : 1
model name : ARMv7 Processor rev 5 (v7l)
BogoMIPS : 42.66
Features : half thumb fastmult vfp edsp neon vfpv3 tls vfpv4 idiva idivt vfpd32 lpae evtstrm
CPU implementer : 0x41
CPU architecture: 7
CPU variant : 0x0
CPU part : 0xc07
CPU revision : 5

processor : 2
model name : ARMv7 Processor rev 5 (v7l)
BogoMIPS : 42.66
Features : half thumb fastmult vfp edsp neon vfpv3 tls vfpv4 idiva idivt vfpd32 lpae evtstrm
CPU implementer : 0x41
CPU architecture: 7
CPU variant : 0x0
CPU part : 0xc07
CPU revision : 5

processor : 3
model name : ARMv7 Processor rev 5 (v7l)
BogoMIPS : 42.66
Features : half thumb fastmult vfp edsp neon vfpv3 tls vfpv4 idiva idivt vfpd32 lpae evtstrm
CPU implementer : 0x41
CPU architecture: 7
CPU variant : 0x0
CPU part : 0xc07
CPU revision : 5

Hardware : BCM2835
Revision : a01041
Serial : 00000000db3a6a9a
Model : Raspberry Pi 2 Model B Rev 1.1

Edit:
Corrected some typo's

[joanbono]

Hi,

Yes MariaDB should work with barnyard2 but it may need some adjustements on the code.

I’ll take a look on this when I have time but Pull Requests are welcome anyway :)

[Therodox]

HI, ist this still in progress?

[joanbono]

Hi @Therodox

Unfortunately not. Since Snort 3 is been released, I'll publish an update to install Snort 3 instead of Snort 2.