saltstack / saltstack/salt

Issue with mysql.login_create

Open
#64,207 2 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

bug needs-more-info needs-triage
Dominant language
Python
Stars
15.7k
Forks
5.6k
Avg merge
2d 44m
Merged PRs (30d)
80

Description

I am managing a user for a mysql database via salt.

The salt state runs correctly and no errors are show in the state apply.

Looking at the specific log for the mysql.login_create shows successful, but the detailed log message reports an error.
{
“Ret”: “Could not create the login: (18456, d’DB-Lib error message 20018, severity 14:]]nGeneral SQL Server error: Check messages from the SQL server\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (localhost)\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (localhost)\n’)”
}

The state apply should report the failure.

saltsls
salterror

Salt Version:
Salt: 3005.1

Dependency Versions:
cffi: 1.11.5
cherrypy: Not Installed
dateutil: 2.6.1
docker-py: Not Installed
gitdb: Not Installed
gitpython: Not Installed
Jinja2: 3.0.1
libgit2: Not Installed
M2Crypto: Not Installed
Mako: Not Installed
msgpack: 1.0.4
msgpack-pure: Not Installed
mysql-python: Not Installed
pycparser: 2.14
pycrypto: Not Installed
pycryptodome: 3.16.0
pygit2: Not Installed
Python: 3.6.8 (default, Jan 14 2022, 11:04:20)
python-gnupg: Not Installed
PyYAML: 3.12
PyZMQ: 24.0.1
smmap: Not Installed
timelib: Not Installed
Tornado: 4.5.3
ZMQ: 4.3.4

Salt Extensions:
saltext.vmware: 22.9.8.0rc1
SSEAPE: 8.10.1.6

System Versions:
dist: rhel 8.6 Ootpa
locale: UTF-8
machine: x86_64
release: 4.18.0-372.16.1.el8_6.x86_64
system: Linux
version: Red Hat Enterprise Linux 8.6 Ootpa

PASTE HERE

Additional context
Add any other context about the problem here.

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start at the mysql.login_create entry point and reproduce the state with Salt 3005.1 using the reported MySQL environment. Compare the successful state result with the detailed log containing the DB-Lib errors; the work is done when the state apply reports the login-creation failure. The missing state YAML and old unanswered report make further investigation necessary.

Written by the indexing model from the issue text.

Assessment

Tech stack
mysql, python
Domain
databases, devops
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.