az mysql flexible-server connect command error:ModuleNotFoundError: No module named 'psycopg2._psycopg'

[pravasi]

Describe the bug

Till yester day I was able to connect to myDjango app's application server interactively..But now giving error:
he command failed with an unexpected error. Here is the traceback:
No module named 'psycopg2._psycopg'
Traceback (most recent call last):
File "/usr/lib64/az/lib/python3.12/site-packages/knack/cli.py", line 233, in invoke
cmd_result = self.invocation.execute(args)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib64/az/lib/python3.12/site-packages/azure/cli/core/commands/init.py", line 564, in execute
self.commands_loader.load_arguments(command)
File "/usr/lib64/az/lib/python3.12/site-packages/azure/cli/core/init.py", line 548, in load_arguments
self.command_table[command].load_arguments() # this loads the arguments via reflection
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib64/az/lib/python3.12/site-packages/azure/cli/core/commands/init.py", line 321, in load_arguments
super().load_arguments()
File "/usr/lib64/az/lib/python3.12/site-packages/knack/commands.py", line 104, in load_arguments
cmd_args = self.arguments_loader()
^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib64/az/lib/python3.12/site-packages/azure/cli/core/commands/command_operation.py", line 124, in arguments_loader
op = self.get_op_handler(self.op_path)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib64/az/lib/python3.12/site-packages/azure/cli/core/commands/command_operation.py", line 59, in get_op_handler
handler = import_module(mod_to_import)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3.12/importlib/init.py", line 90, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "", line 1387, in _gcd_import
File "", line 1360, in _find_and_load
File "", line 1331, in _find_and_load_unlocked
File "", line 935, in _load_unlocked
File "", line 999, in exec_module
File "", line 488, in _call_with_frames_removed
File "/home//.azure/cliextensions/rdbms-connect/azext_rdbms_connect/custom.py", line 10, in
import psycopg2
File "/home//.azure/cliextensions/rdbms-connect/psycopg2/init.py", line 51, in
from psycopg2._psycopg import ( # noqa
ModuleNotFoundError: No module named 'psycopg2._psycopg'

Related command

az mysql flexible-server connect -n -u -p "<my password"> -d --interactive

Errors

Traceback (most recent call last):
File "/usr/lib64/az/lib/python3.12/site-packages/knack/cli.py", line 233, in invoke
cmd_result = self.invocation.execute(args)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib64/az/lib/python3.12/site-packages/azure/cli/core/commands/init.py", line 564, in execute
self.commands_loader.load_arguments(command)
File "/usr/lib64/az/lib/python3.12/site-packages/azure/cli/core/init.py", line 548, in load_arguments
self.command_table[command].load_arguments() # this loads the arguments via reflection
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib64/az/lib/python3.12/site-packages/azure/cli/core/commands/init.py", line 321, in load_arguments
super().load_arguments()
File "/usr/lib64/az/lib/python3.12/site-packages/knack/commands.py", line 104, in load_arguments
cmd_args = self.arguments_loader()
^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib64/az/lib/python3.12/site-packages/azure/cli/core/commands/command_operation.py", line 124, in arguments_loader
op = self.get_op_handler(self.op_path)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib64/az/lib/python3.12/site-packages/azure/cli/core/commands/command_operation.py", line 59, in get_op_handler
handler = import_module(mod_to_import)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3.12/importlib/init.py", line 90, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "", line 1387, in _gcd_import
File "", line 1360, in _find_and_load
File "", line 1331, in _find_and_load_unlocked
File "", line 935, in _load_unlocked
File "", line 999, in exec_module
File "", line 488, in _call_with_frames_removed
File "/home//.azure/cliextensions/rdbms-connect/azext_rdbms_connect/custom.py", line 10, in
import psycopg2
File "/home//.azure/cliextensions/rdbms-connect/psycopg2/init.py", line 51, in
from psycopg2._psycopg import ( # noqa
ModuleNotFoundError: No module named 'psycopg2._psycopg'

Issue script & Debug output

az mysql flexible-server connect

Expected behavior

Able to connect to mysql database in interactive mode

Environment Summary

[ ~ ]$ az --version
azure-cli 2.71.0

core 2.71.0
telemetry 1.1.0

Extensions:
ai-examples 0.2.5
ml 2.36.0
rdbms-connect 1.0.4
ssh 2.0.6

Dependencies:
msal 1.31.2b1
azure-mgmt-resource 23.1.1

Python location '/usr/bin/python3.12'
Config directory '/home//.azure'
Extensions directory '/home//.azure/cliextensions'
Extensions system directory '/usr/lib/python3.12/site-packages/azure-cli-extensions'

Python (Linux) 3.12.9 (main, Mar 11 2025, 15:30:57) [GCC 13.2.0]

Legal docs and information: aka.ms/AzureCliLegal

Your CLI is up-to-date.

Additional context

Was working till yesterday.

[yonzhan]

Thank you for opening this issue, we will look into it.

[microsoft-github-policy-service]

Thanks for the feedback! We are routing this to the appropriate team for follow-up. cc @ambhatna, @savjani.

[github-actions]

Here are some similar issues that might help you. Please check if they can solve your problem.

• az mysql flexible-server command error in "azure-cli": "2.71.0" #31270
• az postgres flexible-server connect failing #22889
• unable to connect to serverless postgres db #21953

---

Possible solution (Extracted from existing issue, might be incorrect; please verify carefully)

Solution 1:

Please delete the rdbms-connect folder in the ~/.azure/cliextensions/ location and install the most recent version of this extension using the command:

az extension add --name rdbms-connect

After this, try to run the AzCli command again and check if the issue persists.

Reference:

• az postgres flexible-server connect failing #22889 (comment)

Solution 2:

Try running the following commands to install the necessary packages:

pip install psycopg
pip install psycopg-c
pip install psycopg-binary

Reference:

• az postgres flexible-server connect failing #22889 (comment)

Solution 3:

Ensure that gcc and musl-dev are installed, then run:

apk add gcc musl-dev
pip install psycopg

Reference:

• unable to connect to serverless postgres db #21953 (comment)

Powered by issue-sentinel

[microsoft-github-policy-service]

Thanks for the feedback! We are routing this to the appropriate team for follow-up. cc @ambhatna, @savjani.

[pravasi]

Solution 1 solved the issue
az extension remove --name rdbms-connect
az extension add --name rdbms-connect