*New 12.1 series Release:
2020-04-05: XigmaNAS 12.1.0.4.7509 - released

*New 11.3 series Release:
2020-04-05: XigmaNAS 11.3.0.4.7509 - released!


We really need "Your" help on XigmaNAS https://translations.launchpad.net/xigmanas translations. Please help today!

Producing and hosting XigmaNAS costs money. Please consider donating for our project so that we can continue to offer you the best.
We need your support! eg: PAYPAL

MariaDB Install - MySQL UID88 user goes missing at restart. (User created outside of GUI goes missing at restart)

XigmaNAS Extensions / Add-ons

Moderator: crest

Forum rules
Set-Up GuideFAQsForum Rules
Post Reply
tdiaz
Starter
Starter
Posts: 29
Joined: 08 Mar 2017 21:12
Status: Offline

MariaDB Install - MySQL UID88 user goes missing at restart. (User created outside of GUI goes missing at restart)

#1

Post by tdiaz »

To start MariaDB I've got to login as root and create the user/group with ID 88

pw useradd mysql -u 88 -g mysql -c "MySQL Daemon" -d /var/db/mysql -s /usr/sbin/nologin

service mysql-server start

The MariaDB install is on the ZFS_On_Root install, not within a jail.

It's not possible to create a user with the GUI that has no password, though creating the group via GUI seems to have made the group stick, so it's just the user.

It's as if any user created at the command line does not survive a system restart.

User avatar
ms49434
Developer
Developer
Posts: 834
Joined: 03 Sep 2015 18:49
Location: Neuenkirchen-Vörden, Germany - GMT+1
Contact:
Status: Offline

Re: MariaDB Install - MySQL UID88 user goes missing at restart. (User created outside of GUI goes missing at restart)

#2

Post by ms49434 »

Xigmanas differentiates between
  • Preset users and groups, they are hardcoded.
  • System users and groups, they are stored in config.xml under //system/usermanagement.
  • Regular users and groups, they are stored in config.xml under //access/user and //access/group and can be maintained in the WebGUI.
On en embedded installation you must edit /conf/config.xml if you want to create an additional system user and/or an additional system group.
Execute PHP command "echo uuid();" to create a unique and valid identifier for a system user record or a system group record.
1) XigmaNAS 12.1.0.4 amd64-embedded on a Dell T20 running in a VM on ESXi 6.7U3, 22GB out of 32GB ECC RAM, LSI 9300-8i IT mode in passthrough mode. Pool 1: 2x HGST 10TB, mirrored, SLOG: Samsung 850 Pro, L2ARC: Samsung 850 Pro, Pool 2: 1x Samsung 860 EVO 1TB , services: Samba AD, CIFS/SMB, ftp, ctld, rsync, syncthing, zfs snapshots.
2) XigmaNAS 12.1.0.4 amd64-embedded on a Dell T20 running in a VM on ESXi 6.7U3, 8GB out of 32GB ECC RAM, IBM M1215 crossflashed, IT mode, passthrough mode, 2x HGST 10TB , services: rsync.

User avatar
crest
Hardware & Software Guru
Hardware & Software Guru
Posts: 529
Joined: 02 Jul 2012 22:25
Location: Vienna, Austria - GMT+1
Status: Offline

Re: MariaDB Install - MySQL UID88 user goes missing at restart. (User created outside of GUI goes missing at restart)

#3

Post by crest »

tdiaz wrote:
27 Aug 2018 01:42
...
It's not possible to create a user with the GUI that has no password, though creating the group via GUI seems to have made the group stick, so it's just the user.
...
You could try the easy way, create a new user via the GUI and just delete the password afterwards in the config.xml file (/cf/conf/config.xml) with the built-in WebGUI editor.
NAS1: 11.2.0.4 - Omnius (Revision 6766) x64-embedded; MSI 760GM-P23; AMD Athlon(tm) II X2 250 7.58GiB RAM
NAS2: 11.2.0.4 - Omnius (Revision 6766) x64-embedded; MSI MS-7369; AMD Sempron(tm) LE-1250 8022MiB RAM
UPS: APC Back-UPS ES 550G
Extensions: OneButtonInstaller, Extended GUI, NextOwnCloud, BitTorrent Sync, Syncthing, Downloady, Midnight Commander, NCDU, MySQL, Rclone, Themes:

tdiaz
Starter
Starter
Posts: 29
Joined: 08 Mar 2017 21:12
Status: Offline

Re: MariaDB Install - MySQL UID88 user goes missing at restart. (User created outside of GUI goes missing at restart)

#4

Post by tdiaz »

Okay, makes sense now.. except for I'm using Root on ZFS, though I suppose thats basically an embedded installation regardless.
The config.xml storing the user data clears that up.

Post Reply

Return to “Extensions / Add-ons”