1

I'm making a full LAMP using a Raspberry PI 4 w/ 4GB RAM, Apachie2, MariaDB 10.3.22 and PHP and a 4 Teribite HSF+ USB drive. Initial setup worked fine till I attempted to change to data store of mariaDB to the HSF+ data directory. Yes, I installed HSF functions and samba. Both in the GUI and command line have no problems with access the drives folders and files.

In mariadb.cnf I changed:

datadir = /mnt/LaCie/Shared/RasDBdata

Starting mariaDB fails and in journalctl -xe i get:

May 27 09:07:06 raspberrypi mysqld[13358]: 2020-05-27  9:07:06 0 [Note] /usr/sbin/mysqld (mysqld 10.3.22-MariaDB-0+deb10u1) starting as process 13358 ...
May 27 09:07:06 raspberrypi mysqld[13358]: 2020-05-27  9:07:06 0 [Warning] Setting lower_case_table_names=2 because file system for /mnt/LaCie/Shared/RasDBdata/ is case insensitive
May 27 09:07:08 raspberrypi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE

As you can see by the path I am using case sensitive names. How can I make mariadb or is it raspbian to know it is case sensitive?

goldilocks
  • 60,325
  • 17
  • 117
  • 234
Gary Scott
  • 11
  • 1

1 Answers1

2

I'm not familiar with MariaDB, but it's error message indicates that it uses case sensitive filenames and your filesystem does not support it. I suppose you are using a fat formated filesystem that uses case insensitive filenames. So you should either configure MariaDB to use case insensitive filenames (don't know if it is possible, look at the manual), or you use a case sensitive filesystem. The best choice would be to format the filesystem with ext4 because it is Raspbians default.

Ingo
  • 42,961
  • 20
  • 87
  • 207