Re: [Maria-discuss] Maria-db refuses to start
On Thursday 13 October 2022 at 16:36:41, Jogchum Reitsma wrote: > >> mount --bind /var/lib/mysql > OK, I've done so, and now > > l /var/lib/mysql > > reads, no surprise, the contents of the original db location. > > In /etc/my.cnf I changed the location to /var/lib/mysql. > > But, starting the database server still fails with the same error and > warning messages: Have you tried setting the "alternative location" of your MariaDB files to some directory under /var/lib instead of trying to put them somewhere under /home? Antony. -- BASIC is to computer languages what Roman numerals are to arithmetic. Please reply to the list; please *don't* CC me. ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Re: [Maria-discuss] Maria-db refuses to start
Op 13-10-2022 om 15:36 schreef Reindl Harald: Am 13.10.22 um 15:29 schrieb Jogchum Reitsma: Op 13-10-2022 om 15:10 schreef Reindl Harald: There I have plenty of room in a raid6 configuration, where the default location is much smaller, and populated by the infamous (well, with me at least) btrfs filesystem. you can put the data in /home/mysql, make a bind-mount from /var/lib/mysql to /home/mysql and change the config to use /var/lib/mysql OK, so, to be quite sure, the command then is mount --bind /var/lib/mysql yes, the only difference to any other mount is type "bind" OK, I've done so, and now l /var/lib/mysql reads, no surprise, the contents of the original db location. In /etc/my.cnf I changed the location to /var/lib/mysql. But, starting the database server still fails with the same error and warning messages: okt 13 16:35:15 linux-mkay systemd[1]: Starting MariaDB database server... ░░ Subject: A start job for unit mariadb.service has begun execution ░░Defined-By: systemd ░░Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel ░░ ░░A start job for unit mariadb.service has begun execution. ░░ ░░The job identifier is 6638394. okt 13 16:35:15 linux-mkay mysql-systemd-helper[92738]: 2022-10-13 16:35:15 0 [Note] /usr/sbin/mysqld (server 10.8.3-MariaDB) starting as process 92738 ... okt 13 16:35:15 linux-mkay mysql-systemd-helper[92738]: 2022-10-13 16:35:15 0 [Warning] Can't create test file /var/lib/mysql/linux-mkay.lower-test okt 13 16:35:15 linux-mkay mysql-systemd-helper[92738]: [90B blob data] okt 13 16:35:15 linux-mkay mysql-systemd-helper[92738]: 2022-10-13 16:35:15 0 [ERROR] Aborting okt 13 16:35:15 linux-mkay systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE ░░ Subject: Unit process exited ░░Defined-By: systemd ░░Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel ░░ ░░An ExecStart= process belonging to unit mariadb.service has exited. ░░ ░░The process' exit code is 'exited' and its exit status is 1. okt 13 16:35:15 linux-mkay systemd[1]: mariadb.service: Failed with result 'exit-code'. ░░ Subject: Unit failed ░░Defined-By: systemd ░░Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel ░░ ░░The unit mariadb.service has entered the 'failed' state with result 'exit-code'. okt 13 16:35:15 linux-mkay systemd[1]: Failed to start MariaDB database server. ░░ Subject: A start job for unit mariadb.service has failed ░░Defined-By: systemd ░░Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel ░░ ░░A start job for unit mariadb.service has finished with a failure. ░░ ░░The job identifier is 6638394 and the job result is failed. So nothing is gained so far... regards, Jogchum my /etc/fstab for /home while "/mnt/data/home" is the phyiscal location on a 4 TB RAID /mnt/data/home /home none bind i don't create bind mounts manually because you can mount, unmount and comment out them in fstab like every other mountpoint and i perfer them to survive reboots ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
[Maria-discuss] Migration path for unix_socket authentication plugin
Hi, On MariaDB servers that were installed with >= MariaDB 10.4, I have one root user that was created as: MariaDB [(none)]> show create user 'root'@'localhost'; CREATE USER `root`@`localhost` IDENTIFIED VIA mysql_native_password USING 'invalid' OR unix_socket FWIW: The statements on https://mariadb.com/kb/en/authentication-from-mariadb-104/#description are reversed (`IDENTIFIED VIA unix_socket OR mysql_native_password USING 'invalid'` instead of `IDENTIFIED VIA mysql_native_password USING 'invalid' OR unix_socket`). On MariaDB servers that were installed with < MariaDB 10.4, I have 3 root users that were created as: MariaDB [(none)]> show create user 'root'@'localhost'; CREATE USER `root`@`localhost` MariaDB [(none)]> show create user 'root'@'::1'; CREATE USER `root`@`::1` MariaDB [(none)]> show create user 'root'@'127.0.0.1'; CREATE USER `root`@`127.0.0.1` I've upgraded all MariaDB servers that were installed with MariaDB <= 10.4 to MariaDB 10.6. I would like to update these root users, that were created when installing on < 10.4, to use UNIX socket authentication too. If I run: ALTER USER 'root'@'localhost' IDENTIFIED VIA mysql_native_password USING 'invalid' OR unix_socket ... I have a user with the same create statement as on servers that were installed with >= MariaDB 10.4: MariaDB [(none)]> show create user 'root'@'localhost'; CREATE USER `root`@`localhost` IDENTIFIED VIA mysql_native_password USING 'invalid' OR unix_socket I have 3 questions regarding this: 1. Is the ALTER USER statement above the correct migration path, to update root users created when installing on < 10.4 to use UNIX socket authentication, like root users created when installing on >= 10.4? Am I forgetting anything? 2. I presume the 'root'@'::1' and 'root'@'127.0.0.1' users were created to support TCP connections when skip_name_resolve=1. If so, they are no longer needed when using a UNIX socket. Can I safely delete these users, after updating the 'root'@'localhost' user to use UNIX socket authentication? 3. Is there a plan to automatically remove the debian-sys-maint user on future major upgrades? It still exists on servers that were installed on < 10.4. The /etc/mysql/debian.cnf file is deprecated already, so this user should be unused. FYI: All MariaDB servers were installed from the MariaDB Debian repository. Thank you! William Edwards ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Re: [Maria-discuss] Maria-db refuses to start
Am 13.10.22 um 15:29 schrieb Jogchum Reitsma: Op 13-10-2022 om 15:10 schreef Reindl Harald: There I have plenty of room in a raid6 configuration, where the default location is much smaller, and populated by the infamous (well, with me at least) btrfs filesystem. you can put the data in /home/mysql, make a bind-mount from /var/lib/mysql to /home/mysql and change the config to use /var/lib/mysql OK, so, to be quite sure, the command then is mount --bind /var/lib/mysql yes, the only difference to any other mount is type "bind" my /etc/fstab for /home while "/mnt/data/home" is the phyiscal location on a 4 TB RAID /mnt/data/home /home none bind i don't create bind mounts manually because you can mount, unmount and comment out them in fstab like every other mountpoint and i perfer them to survive reboots ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Re: [Maria-discuss] Maria-db refuses to start
Op 13-10-2022 om 15:10 schreef Reindl Harald: Am 13.10.22 um 14:54 schrieb Jogchum Reitsma: frankly why don#t you move the datadir out of your suerhome and change the path to the datadir in the config? 25 years ago I decided that the data is only useful to me, so why place it anywhere else than in my home directory? After all, that's where all my personal files reside, so why treat this data otherwise? but database files are not normal user files and can't be backuped while the service is running in a safe way like your personal document files so it makes little sense to handle different beasts identical OK, I get that. A philosophical issue in my feeling: what is more important, who's the owner of the (content of the) files, vs. what nature are they? There I have plenty of room in a raid6 configuration, where the default location is much smaller, and populated by the infamous (well, with me at least) btrfs filesystem. you can put the data in /home/mysql, make a bind-mount from /var/lib/mysql to /home/mysql and change the config to use /var/lib/mysql OK, so, to be quite sure, the command then is mount --bind /var/lib/mysql voila, ProtectHome no longer hits because from the viewpoint of systemd and mariadb the datadir isn't below /home https://unix.stackexchange.com/questions/198590/what-is-a-bind-mount ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Re: [Maria-discuss] Maria-db refuses to start
On Thursday 13 October 2022 at 15:22:01, Jogchum Reitsma wrote: > I did that, and now the database starts with de db location set to the > new one. > > But when I change it in /etc/my.cnf to the original (after making a copy > of that location), tha server crashes again, with the same error messages. What are you actually trying to achieve here? What problem do you have with running MariaDB with the database files in the standard location? Antony. -- Schrödinger's rule of data integrity: the condition of any backup is unknown until a restore is attempted. Please reply to the list; please *don't* CC me. ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Re: [Maria-discuss] Maria-db refuses to start
Op 13-10-2022 om 14:34 schreef Reindl Harald: Am 13.10.22 um 14:16 schrieb Jogchum Reitsma: Op 13-10-2022 om 01:46 schreef Daniel Black: In systemd ProtectHome=read-only is the default. systemctl edit mariadb.service and add: [Service] ProtectHome=false > When I read /usr/lib/systemd/system/mariadb.service it contains # Prevent accessing /home, /root and /run/user ProtectHome=true I know hardly anything about systemd, so not user waht I should do here? in the open "/etc/systemd/system/mariadb.service.d/override.conf" add what was told above [Service] ProtectHome=false I did that, and now the database starts with de db location set to the new one. But when I change it in /etc/my.cnf to the original (after making a copy of that location), tha server crashes again, with the same error messages. Maybe I should copy the databases in the original location to the new one, but probably not all of them? Just of my own databases? regards, Jogchum ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Re: [Maria-discuss] Maria-db refuses to start
Am 13.10.22 um 14:54 schrieb Jogchum Reitsma: frankly why don#t you move the datadir out of your suerhome and change the path to the datadir in the config? 25 years ago I decided that the data is only useful to me, so why place it anywhere else than in my home directory? After all, that's where all my personal files reside, so why treat this data otherwise? but database files are not normal user files and can't be backuped while the service is running in a safe way like your personal document files so it makes little sense to handle different beasts identical There I have plenty of room in a raid6 configuration, where the default location is much smaller, and populated by the infamous (well, with me at least) btrfs filesystem. you can put the data in /home/mysql, make a bind-mount from /var/lib/mysql to /home/mysql and change the config to use /var/lib/mysql voila, ProtectHome no longer hits because from the viewpoint of systemd and mariadb the datadir isn't below /home https://unix.stackexchange.com/questions/198590/what-is-a-bind-mount ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Re: [Maria-discuss] Maria-db refuses to start
Op 13-10-2022 om 14:34 schreef Reindl Harald: Am 13.10.22 um 14:16 schrieb Jogchum Reitsma: Op 13-10-2022 om 01:46 schreef Daniel Black: On Thu, Oct 13, 2022 at 12:27 AM Jogchum Reitsma wrote: Anyone an idea why /home/jogchum/mysql_recover/linux-mkay.lower-test can't be created and how to solve that? In systemd ProtectHome=read-only is the default. systemctl edit mariadb.service and add: [Service] ProtectHome=false > When I read /usr/lib/systemd/system/mariadb.service it contains # Prevent accessing /home, /root and /run/user ProtectHome=true I know hardly anything about systemd, so not user waht I should do here? in the open "/etc/systemd/system/mariadb.service.d/override.conf" add what was told above [Service] ProtectHome=false OK,thanks, I 'll give it a try and "Prevent accessing /home, /root and /run/user" as comment in system services should tell you something frankly why don#t you move the datadir out of your suerhome and change the path to the datadir in the config? 25 years ago I decided that the data is only useful to me, so why place it anywhere else than in my home directory? After all, that's where all my personal files reside, so why treat this data otherwise? There I have plenty of room in a raid6 configuration, where the default location is much smaller, and populated by the infamous (well, with me at least) btrfs filesystem. If I were convinced relocation would solve the problem, I could do that, but I have not seen that in the discussion so forth. Anyway, thanks for thinking with me - I may not agree with you in everything, but be sure I appreciate your replies! regards, Jogchum ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Re: [Maria-discuss] Maria-db refuses to start
Op 13-10-2022 om 14:08 schreef Reindl Harald: Am 13.10.22 um 13:55 schrieb Jogchum Reitsma: Op 13-10-2022 om 12:59 schreef Reindl Harald: All files and dir's under /home/jogchum/mysql_recover have mysql:mysql as owner:group and your userhome is 755 which is the default, when opensuse creates a new user. So, if I understand you right, that's wrong in your opinion? plain wrong but i don#t even know the default of my Fedora machines given that the last time i saw an os-installer was in 2011 thanks to RAID and backups Well, not only on (re-)install, but also when you create a new user via Yast, the default is 755. as well as systemd namespaces and SELinux allowing nosense like storing the databasedir in a userhome? Why is that nonsense? After all, it's not a company database we're talking about, just and how does that justify doing something different than anybody else out there? I don't think I have to justify that here, after all, it sits some 25 years on the place it is now (which is *not* /home/jogchum/mysql_recover, I explain that below). Never was a problem. - some addresses of friends and family, mainly used for sending Christmas cards, - some metadata about video's I recorded, - some data about the yield of our solar panels. Nothing secret in that. i wonder if the friends see that this relaxed too, in europe there is more undestanding of privacy and data security as in the USA... Yes, and in the Netherlands even more than in some other EU-countries.But to read it for others than me, my wife and son, one should hack one's way into my system. Which is not impossible, of course, but tin that case I think the damage will be more than a few addresses being read. just don't do that - and be it only because it's dumb set your userhome to chmod 755 which means any 644 file can be read by anyone As said, I did not chmod it to 755, it's the opensuse default (and maybe other distro's too, dunno). And anyone in my family is allowed to read anything on our systems. More important, you don't say anything about how I could start the database? dunno but this part of the logs is looking bad - on a updated machine that mustnt't have started at all and indicates for me the damage was that large that your installation looked like a fresh one okt 02 21:26:55 linux-mkay mysql-systemd-helper[45372]: Creating MySQL privilege database... okt 02 21:27:17 linux-mkay mysql-systemd-helper[45384]: Two all-privilege accounts were created. okt 02 21:27:17 linux-mkay mysql-systemd-helper[45384]: One is root@localhost, it has no password, but you need to okt 02 21:27:17 linux-mkay mysql-systemd-helper[45384]: be system 'root' user to connect. Use, for example, sudo mysql okt 02 21:27:17 linux-mkay mysql-systemd-helper[45384]: The second is mysql@localhost, it has no password either, but okt 02 21:27:17 linux-mkay mysql-systemd-helper[45384]: you need to be the system 'mysql' user to connect. Yes, it was a fresh installation, because I gave a new location, /home/jogchum/mysql_recover, before starting the db. As said in my first post, this was a solution that worked for someone with the same problem: roughly: - change the location of the db in /etc/my.cnf - start the database server, which will create the default environment in the new location - copy the existing database files to that new locatioN - restart the database server. In my case, this recipe fails in the second step: the new location is populated, but the server crashes immediately. Journalctl show only a warning regarding not being able to create a test file: Warning] Can't create test file /home/jogchum/mysql_recover/linux-mkay.lower-test which, according to Sergei, should not be a cause for the server to crash.And ideed, it's only a warning, no error. So, it still is a riddle why the server won't start. regards, Jogchum ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Re: [Maria-discuss] Maria-db refuses to start
Am 13.10.22 um 14:16 schrieb Jogchum Reitsma: Op 13-10-2022 om 01:46 schreef Daniel Black: On Thu, Oct 13, 2022 at 12:27 AM Jogchum Reitsma wrote: Anyone an idea why /home/jogchum/mysql_recover/linux-mkay.lower-test can't be created and how to solve that? In systemd ProtectHome=read-only is the default. systemctl edit mariadb.service and add: [Service] ProtectHome=false > When I read /usr/lib/systemd/system/mariadb.service it contains # Prevent accessing /home, /root and /run/user ProtectHome=true I know hardly anything about systemd, so not user waht I should do here? in the open "/etc/systemd/system/mariadb.service.d/override.conf" add what was told above [Service] ProtectHome=false and "Prevent accessing /home, /root and /run/user" as comment in system services should tell you something frankly why don#t you move the datadir out of your suerhome and change the path to the datadir in the config? ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Re: [Maria-discuss] Maria-db refuses to start
Op 13-10-2022 om 01:46 schreef Daniel Black: On Thu, Oct 13, 2022 at 12:27 AM Jogchum Reitsma wrote: Anyone an idea why /home/jogchum/mysql_recover/linux-mkay.lower-test can't be created and how to solve that? In systemd ProtectHome=read-only is the default. systemctl edit mariadb.service and add: [Service] ProtectHome=false If I issue that command, it translates to nano/etc/systemd/system/mariadb.service.d/.#override.conf5a67e18e4e904390 and the first lines of that file read ## Editing /etc/systemd/system/mariadb.service.d/override.conf ### Anything between here and the comment below will become the new contents of the file ### Lines below this comment will be discarded When I read /usr/lib/systemd/system/mariadb.service it contains # Prevent accessing /home, /root and /run/user ProtectHome=true I know hardly anything about systemd, so not user waht I should do here? regards, Jogchum https://mariadb.com/kb/en/systemd/#useful-systemd-options You may also need to selinux relabel the new directory: sudo semanage fcontext -a -t mysqld_db_t "/home/jogchum/mysql_recover(/.*)?" sudo restorecon -Rv /home/jogchum/mysql_recover https://mariadb.com/kb/en/selinux/#setting-the-file-context-for-the-data-directory ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Re: [Maria-discuss] Maria-db refuses to start
Am 13.10.22 um 13:55 schrieb Jogchum Reitsma: Op 13-10-2022 om 12:59 schreef Reindl Harald: All files and dir's under /home/jogchum/mysql_recover have mysql:mysql as owner:group and your userhome is 755 which is the default, when opensuse creates a new user. So, if I understand you right, that's wrong in your opinion? plain wrong but i don#t even know the default of my Fedora machines given that the last time i saw an os-installer was in 2011 thanks to RAID and backups as well as systemd namespaces and SELinux allowing nosense like storing the databasedir in a userhome? Why is that nonsense? After all, it's not a company database we're talking about, just and how does that justify doing something different than anybody else out there? - some addresses of friends and family, mainly used for sending Christmas cards, - some metadata about video's I recorded, - some data about the yield of our solar panels. Nothing secret in that. i wonder if the friends see that this relaxed too, in europe there is more undestanding of privacy and data security as in the USA... just don't do that - and be it only because it's dumb set your userhome to chmod 755 which means any 644 file can be read by anyone As said, I did not chmod it to 755, it's the opensuse default (and maybe other distro's too, dunno). And anyone in my family is allowed to read anything on our systems. More important, you don't say anything about how I could start the database? dunno but this part of the logs is looking bad - on a updated machine that mustnt't have started at all and indicates for me the damage was that large that your installation looked like a fresh one okt 02 21:26:55 linux-mkay mysql-systemd-helper[45372]: Creating MySQL privilege database... okt 02 21:27:17 linux-mkay mysql-systemd-helper[45384]: Two all-privilege accounts were created. okt 02 21:27:17 linux-mkay mysql-systemd-helper[45384]: One is root@localhost, it has no password, but you need to okt 02 21:27:17 linux-mkay mysql-systemd-helper[45384]: be system 'root' user to connect. Use, for example, sudo mysql okt 02 21:27:17 linux-mkay mysql-systemd-helper[45384]: The second is mysql@localhost, it has no password either, but okt 02 21:27:17 linux-mkay mysql-systemd-helper[45384]: you need to be the system 'mysql' user to connect. ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Re: [Maria-discuss] Maria-db refuses to start
Op 13-10-2022 om 12:59 schreef Reindl Harald: All files and dir's under /home/jogchum/mysql_recover have mysql:mysql as owner:group and your userhome is 755 which is the default, when opensuse creates a new user. So, if I understand you right, that's wrong in your opinion? as well as systemd namespaces and SELinux allowing nosense like storing the databasedir in a userhome? Why is that nonsense? After all, it's not a company database we're talking about, just - some addresses of friends and family, mainly used for sending Christmas cards, - some metadata about video's I recorded, - some data about the yield of our solar panels. Nothing secret in that. just don't do that - and be it only because it's dumb set your userhome to chmod 755 which means any 644 file can be read by anyone As said, I did not chmod it to 755, it's the opensuse default (and maybe other distro's too, dunno). And anyone in my family is allowed to read anything on our systems. More important, you don't say anything about how I could start the database? regards, Jogchum ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Re: [Maria-discuss] Retrieve authentication plugins for user
Hi, William, Don't use mysql.user. It's only preserved for compatibility with old application and intentionally does not support any new authentication features. You can see all plugins in `show create user`. The actual table where this information is stored is mysql.global_priv https://mariadb.org/authentication-in-mariadb-10-4/ Regards, Sergei VP of MariaDB Server Engineering and secur...@mariadb.org On Oct 13, William Edwards wrote: > Hi, > > When creating an account with multiple authentication plugins, in this > case 'unix_socket' OR 'mysql_native_password', the mysql.user.plugin > column is set to either one. > > How should I retrieve *all* used authentication plugins for a given > user? > > Example: > > ``` > MariaDB [(none)]> CREATE USER 'testing'@'localhost' IDENTIFIED VIA > unix_socket OR mysql_native_password USING 'invalid'; > Query OK, 0 rows affected (0.005 sec) > > MariaDB [(none)]> select user,host,password,authentication_string,plugin from > mysql.user where User = 'testing'; > +-+---+--+---+---+ > | User| Host | Password | authentication_string | plugin >| > +-+---+--+---+---+ > | testing | localhost | invalid | invalid | > mysql_native_password | > +-+---+--+---+---+ > 1 row in set (0.003 sec) > ``` ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Re: [Maria-discuss] Maria-db refuses to start
Am 13.10.22 um 12:14 schrieb Jogchum Reitsma: Op 12-10-2022 om 16:48 schreef Sergei Golubchik: Hi, Jogchum, Anyone an idea why /home/jogchum/mysql_recover/linux-mkay.lower-test can't be created and how to solve that? permission problem, perhaps? All files and dir's under /home/jogchum/mysql_recover have mysql:mysql as owner:group and your userhome is 755 as well as systemd namespaces and SELinux allowing nosense like storing the databasedir in a userhome? just don't do that - and be it only because it's dumb set your userhome to chmod 755 which means any 644 file can be read by anyone ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
[Maria-discuss] Retrieve authentication plugins for user
Hi, When creating an account with multiple authentication plugins, in this case 'unix_socket' OR 'mysql_native_password', the mysql.user.plugin column is set to either one. How should I retrieve *all* used authentication plugins for a given user? Example: ``` MariaDB [(none)]> CREATE USER 'testing'@'localhost' IDENTIFIED VIA unix_socket OR mysql_native_password USING 'invalid'; Query OK, 0 rows affected (0.005 sec) MariaDB [(none)]> select user,host,password,authentication_string,plugin from mysql.user where User = 'testing'; +-+---+--+---+---+ | User| Host | Password | authentication_string | plugin | +-+---+--+---+---+ | testing | localhost | invalid | invalid | mysql_native_password | +-+---+--+---+---+ 1 row in set (0.003 sec) ``` William Edwards ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Re: [Maria-discuss] Maria-db refuses to start
Op 12-10-2022 om 16:48 schreef Sergei Golubchik: Hi, Jogchum, normally the correct fix for that would be to install 10.5.8, start the server, shut it down, then upgrade. Searching that message, I saw a post on https://bbs.archlinux.org/viewtopic.php?id=259364 Like me, he had a non-default location for the databases configured in /etc/my.cnf. The solution that worked for him was to change that to another location in my.cnf, starting the database (which now succeeded), and copy the existing databases to that new location. That's not how I read it at all. It seems to be about innodb_log_files_in_group option. Are you sure the url is correct? No, sorry, it's not. The advice given there, to rename the log files, did not work for me. Funny thing, I can't find the posting any more which *did* the trick with editing my.cnf etc, I described above. 2022-10-02 21:27:17 0 [Warning] Can't create test file /home/jogchum/mysql_recover/linux-mkay.lower-test ... 2022-10-02 21:27:17 0 [ERROR] Aborting Anyone an idea why /home/jogchum/mysql_recover/linux-mkay.lower-test can't be created and how to solve that? permission problem, perhaps? All files and dir's under /home/jogchum/mysql_recover have mysql:mysql as owner:group it's not particularly important, as it's only a warning, and not a reason for the server failing to start. I get that, but then what is it that mariadb won't start in the new environment Thanks for your reply! regards, Jogchum Regards, Sergei VP of MariaDB Server Engineering and secur...@mariadb.org ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp