Issue with mysql.login_create
Nobody has claimed this yet.
- 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.


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
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- 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