ISSUE: memsqlctl is configured to require that users be in the “memsql” group for read access
memsqlctl is configured to require that users be in the 'memsql' group for read access. Please rerun the command as a user in this group or the root user.
This message appears during any memsqlctl command if the current user is not in the configured management group.
The memsqlctl config file can be configured to restrict access to a single Linux user and that user’s primary group. When using singlestoredb-server Debian and RPM packages, this is set to memsql, which is the system user created by the package to run SingleStore DB.
There are multiple options for resolving this issue:
Run the command again as the configured user (
memsqlin this example).Run the command again as root or with
sudo.Change the management user by editing the
memsqlctlconfig file and changing the owner of all SingleStore DB-related files and directories.