Good Morning from my Robotics Lab! This is Shadow_8472 and today I am targeting Nextcloud for major milestone completion. Let\u2019s get started.<\/p>\n\n\n\n
Previously on my Nextcloud saga, I finally managed to run a pod with both Nextcloud and MariaDB in their own containers and get them to talk. The words they exchanged were along the lines of \u201cAccess Denied.\u201d I also have a script to add a temporary third container for database command line access.<\/p>\n\n\n\n
My next immediate job is learning enough MySQL to diagnose Nextcloud\u2019s refusal to create an admin account. I found a few commands to try and learned that the database I expected to be there on container creation didn\u2019t appear to be. Container logs didn\u2019t report any errors. I need some more background research, even if that\u2019s the only thing I do this week.<\/p>\n\n\n\n
Most important things first: what is the relationship between MariaDB and MySQL? I\u2019ve been treating the former as if it were an implementation or distribution of the later \u2013 like the difference between Debian and Linux. But according to MariaDB\u2019s site, they\u2019re a fork that avoids \u201cvendor-lock\u201d while maintaining protocol compatibility with MySQL [1]. So MySQL help should still work for MariaDB on a \u201cclose enough\u201d basis, sort of like how Debian solutions may still work for Ubuntu systems. When available: use a matching guide.<\/p>\n\n\n\n
Contrary to what I said in my closing words last time I handled Nextcloud, commands being written in all caps is only convention \u2013 the software is usually a lot more forgiving. SELECT equals sELeCT which equals select and SelEct as well as the other 60 possible combinations.<\/p>\n\n\n\n
MariaDB is what is called a \u201crelational database.\u201d Fancy phrase to me, but here goes an explanation. Data is information. Information can be organized into tables for later retrieval. Zoom out one level, and now tables with information themselves become data that interacts with information in other tables. MariaDB can track these \u201crelations.\u201d<\/p>\n\n\n\n
Needless to say, relational databases gets messy fast. Considering how my database is meant to be locked up tight within a pod on a server that blocks direct access, a containerized webUI I can expose will do nicely. MariaDB\u2019s website has a lengthy list of graphical clients, but only phpMyAdmin showed up as having this feature when I used \u201cfind on page\u201d [2]. Importantly, it also shows up in Docker.io as a Docker Official Image, which I can run on Podman.<\/p>\n\n\n\n
Final Question<\/p>\n\n\n\n
As of posting, I\u2019m planning on spending a week or few each for learning phpMyAdmin and refining my MariaDB understanding. Otherwise, if someone can answer what my problem is that Nextcloud isn\u2019t finding the expected database. The following is a command from my pod creation script.<\/p>\n\n\n\n
podman create \\\n --pod NextcloudRedLaptop \\\n --name MariaDBContainer \\\n -v MariaDBVolume:\/var\/lib\/mysql:Z \\\n -e MARIADB_ROOT_PASSWORD=\"<gibberish1>\" \\\n -e MARIADB_DATABASE=NextcloudDB \\\n -e MARIADB_USER=nextcloudDbUser \\\n -e MARIADB_PASSWORD=\"Gibberish2\" \\\n --restart on-failure \\\n docker.io\/library\/mariadb:latest<\/code><\/pre>\n\n\n\nAnd here is what I think is the important output from MariaDB:<\/p>\n\n\n\n
MariaDB [(none)]> SHOW DATABASES;\n+--------------------+\n| Database |\n+--------------------+\n| information_schema |\n| mysql |\n| performance_schema |\n| sys |\n+--------------------+\n4 rows in set (0.010 sec)<\/code><\/pre>\n\n\n\nIf I understand what I need correctly, I should have had one show up titled \u201cNextcloudDB\u201d on container creation.<\/p>\n\n\n\n
And so, my final question is this: Why doesn\u2019t it work? Am I even looking in the right spot?<\/p>\n\n\n\n
If I oversimplified or got something wrong about relational databases, be sure to tell me all about it in the comments!<\/p>\n\n\n\n
Works Cited<\/h2>\n\n\n\n
[1] MariaDB, “MariaDB vs. MySQL The difference between choice and vendor lock-in,” MariaDB<\/em>, [Online]. Available: https:\/\/mariadb.com\/database-topics\/mariadb-vs-mysql\/<\/a>. [Accessed Sept. 18, 2023].<\/p>\n\n\n\n[2] MariaDB, “Graphical and Enhanced Clients,” MariaDB<\/em>, [Online]. Available: https:\/\/mariadb.com\/kb\/en\/graphical-and-enhanced-clients\/<\/a>. [Accessed Sept. 18, 2023].<\/p>\n","protected":false},"excerpt":{"rendered":"Good Morning from my Robotics Lab! This is Shadow_8472 and today I am targeting Nextcloud for major milestone completion. Let\u2019s get started. Previously on my Nextcloud saga, I finally managed to run a pod with both Nextcloud and MariaDB in their own containers and get them to talk. The words they exchanged were along the … <\/p>\n