mariadb by defaults uses UNIX_SOCKET plugin to authenticate user root. https://mariadb.com/kb/en/mariadb/unix_socket-authentication-plugin/. It works by retrieving uid of the process that has connected to the socket and allowing to connect to the MariaDB account with the corresponding user name. In another word, if you are running your RPi as pi user, when ...
MariaDB is a drop-in replacement for MySQL and should be mostly compatible to it.
Unless you need a very specific feature of MySQL, MariaDB should work just fine.
For more details about the compatibility of MySQL and MariaDB see the following two links:
Looks like you have a character encoding issue. The output \xfc means the character with (hexadecimal) code point 0xFC. That is indeed ü in the Latin-1 character set, but my guess is that it's not being interpreted in that way by Python (or at least it's got mangled somewhere along the way).
My suggestion would be to move everything to UTF-8. If possible, ...
I found a solution although this is not the straightforward way to compile all at once.
First I compiled and installed Qt 5.12.4 without the MySQL driver plugin as described in the tutorial referenced in my original question.
I'm not sure if this next step is really required, but then I created symbolic links to redirect from MySQL to MariaDB in order to ...
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 ...
By default, the MariaDB server listens for TCP/IP connections on a network socket bound to a single address [...] In Debian [...] the default bind_address is 127.0.0.1, which binds the server to listen on localhost only.
source: Server System Variables - MariaDB Knowledge Base
sudo netstat -ln shows in the column "Local Address" for your raspberry1 "0.0.0....
Mariadb is available, just not in the version you want. The reason that build-dep doesn't work is possibly because mariadb-server is actually a "metapackage depending on the latest version" (latest in the repo that is, not the universe as a whole); the actual binaries are in mariadb-server-10.3.
You don't actually need the source from the repo of ...
The answer for your question can't be given that easily. But here, let me try. Follow this flow.
Install and configure MariaDB
Install python framework that gives you the connectivity with the database.
Use pigpio with python and write a program to capture the readings and use the database library to save the data.
Last thing , you have to find the SPI pins ...
I resolved my problem by creating a new database dump that only includes the owncloud database:
mysqldump --single-transaction --routines --triggers owncloud
Of course, any additional databases need to be migrated separately.
You need to install the Mariadb packages and the mysql compatibility package in your sysroot.
apt install mariadb-client mariadb-common mysql-common
libmariadb-dev-compat package will create all the links necessary for compatibility between mariadb and mysql.
Then, when you call to qt configure script you must ...
On my build ouput MySQL did work according to my output ( but can't test as i get errors regarding OpenGl when i start my compiled application )
I compiled on on a 4GB Pi4 with the Raspbian Buster Lite .
Does EGLFS work for you ?
I did install these libs maybe this will fix it for you ? :
sudo apt-get install sense-hat libatspi-dev build-essential ...
Remove that mariadb junk with sudo rm /etc/apt/sources.list.d/mariadb.list.
Run sudo apt update then sudo apt install libmariadbclient18 mariadb-client-10.1 mariadb-client-core-10.1 mariadb-common mariadb-server mariadb-server-10.1 mariadb-server-core-10.1
If you need 10.2 you'll have to wait for Raspbian Stretch.
I do not understand what you want to achieve. At least one time you have to configure the default installation with your add ons and settings. So at the next time it boots it is ready as the final unit. It will not forget all your effort so you do not need to do it again or using a script.
If you want to distribute your setup just take an image from your ...