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.