az postgres flexible-server connect failing

[muhd-azeem]

This is autogenerated. Please review and update as needed.

Describe the bug

Command Name
az postgres flexible-server connect

Errors:

The command failed with an unexpected error. Here is the traceback:
No module named 'psycopg2._psycopg'
Traceback (most recent call last):
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/cli.py", line 231, in invoke
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 561, in execute
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/__init__.py", line 515, in load_arguments
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 318, in load_arguments
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/commands.py", line 104, in load_arguments
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/command_operation.py", line 125, in arguments_loader
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/command_operation.py", line 59, in get_op_handler
  File "importlib\__init__.py", line 126, in import_module
  File "<frozen importlib._bootstrap>", line 1050, in _gcd_import
  File "<frozen importlib._bootstrap>", line 1027, in _find_and_load
  File "<frozen importlib._bootstrap>", line 1006, in _find_and_load_unlocked
  File "<frozen importlib._bootstrap>", line 688, in _load_unlocked
  File "<frozen importlib._bootstrap_external>", line 883, in exec_module
  File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed
  File "C:\Users\M66445\.azure\cliextensions\rdbms-connect\azext_rdbms_connect\custom.py", line 10, in <module>
    import psycopg2
  File "C:\Users\M66445\.azure\cliextensions\rdbms-connect\psycopg2\__init__.py", line 51, in <module>
    from psycopg2._psycopg import (                     # noqa
ModuleNotFoundError: No module named 'psycopg2._psycopg'

To Reproduce:

Steps to reproduce the behavior. Note that argument values have been redacted, as they may contain sensitive information.

• Put any pre-requisite steps here...
• az postgres flexible-server connect -n {} -u {} -d {} --interactive

Expected Behavior

Environment Summary

Windows-10-10.0.19043-SP0
Python 3.10.4
Installer: MSI

azure-cli 2.37.0

Extensions:
rdbms-connect 1.0.2

Dependencies:
msal 1.18.0b1
azure-mgmt-resource 21.1.0b1

Additional Context

[yonzhan]

route to CXP team

[navba-MSFT]

@azeem2020 Apologies for the late reply. Thanks for reaching out to us and sharing this feedback. We are looking into this issue and we will provide an update.

[navba-MSFT]

@azeem2020 Could you please delete the rdbms-connect folder n the ~/.azure/cliextensions/ location and install the most recent version of this extension using the below command ?

az extension add --name rdbms-connect

Post this, you can try to run the AzCli command az postgres flexible-server connect again and check if you see the issue. Awaiting your reply.

[muhd-azeem]

@navba-MSFT Still getting the similar error. Can you please suggest the other workaround?

PS C:\Users\M66445> az postgres flexible-server connect -n pgxxx-xxxx-001 -u xxxx -d postgres -p xxxx --interactive
Traceback (most recent call last):
  File "runpy.py", line 196, in _run_module_as_main
  File "runpy.py", line 86, in _run_code
  File "C:\Users\M66445\.azure\cliextensions\rdbms-connect\bin\pgcli.exe\__main__.py", line 4, in <module>
  File "C:\Users\M66445\.azure\cliextensions\rdbms-connect\pgcli\main.py", line 3, in <module>
    from pgspecial.namedqueries import NamedQueries
  File "C:\Users\M66445\.azure\cliextensions\rdbms-connect\pgspecial\__init__.py", line 13, in <module>
    from . import iocommands
  File "C:\Users\M66445\.azure\cliextensions\rdbms-connect\pgspecial\iocommands.py", line 9, in <module>
    import psycopg
  File "C:\Users\M66445\.azure\cliextensions\rdbms-connect\psycopg\__init__.py", line 9, in <module>
    from . import pq  # noqa: F401 import early to stabilize side effects
  File "C:\Users\M66445\.azure\cliextensions\rdbms-connect\psycopg\pq\__init__.py", line 114, in <module>
    import_from_libpq()
  File "C:\Users\M66445\.azure\cliextensions\rdbms-connect\psycopg\pq\__init__.py", line 106, in import_from_libpq
    raise ImportError(
ImportError: no pq wrapper available.
Attempts made:
- couldn't import psycopg 'c' implementation: No module named 'psycopg_c'
- couldn't import psycopg 'binary' implementation: No module named 'psycopg_binary'
- couldn't import psycopg 'python' implementation: libpq library not found

[navba-MSFT]

@azeem2020 Thanks for reopenning the issue and reaching out to us. Could you try running the below command and check if that helps ?

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

[navba-MSFT]

@azeem2020 A quick follow-up to check if you have tried the above action plan. Please let me know if you have any update on this.

[muhd-azeem]

Apology for late response as I was unavailable. Please see below error for pip install psycopg-c

pip install psycopg-c
Defaulting to user installation because normal site-packages is not writeable
Collecting psycopg-c
  Downloading psycopg-c-3.0.15.tar.gz (594 kB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 594.9/594.9 kB 705.3 kB/s eta 0:00:00
  Installing build dependencies ... done
  Getting requirements to build wheel ... done
  Preparing metadata (pyproject.toml) ... error
  error: subprocess-exited-with-error

  × Preparing metadata (pyproject.toml) did not run successfully.
  │ exit code: 1
  ╰─> [10 lines of output]
      C:\Users\M66445\AppData\Local\Temp\pip-build-env-zgajm2s_\overlay\Lib\site-packages\setuptools\config\setupcfg.py:463: SetuptoolsDeprecationWarning: The license_file parameter is deprecated, use license_files instead.
        warnings.warn(msg, warning_class)
      running dist_info
      creating C:\Users\M66445\AppData\Local\Temp\pip-modern-metadata-rzx3aatx\psycopg_c.egg-info
      writing C:\Users\M66445\AppData\Local\Temp\pip-modern-metadata-rzx3aatx\psycopg_c.egg-info\PKG-INFO
      writing dependency_links to C:\Users\M66445\AppData\Local\Temp\pip-modern-metadata-rzx3aatx\psycopg_c.egg-info\dependency_links.txt
      writing top-level names to C:\Users\M66445\AppData\Local\Temp\pip-modern-metadata-rzx3aatx\psycopg_c.egg-info\top_level.txt
      writing manifest file 'C:\Users\M66445\AppData\Local\Temp\pip-modern-metadata-rzx3aatx\psycopg_c.egg-info\SOURCES.txt'
      couldn't run 'pg_config' --includedir: [WinError 2] The system cannot find the file specified
      error: [WinError 2] The system cannot find the file specified
      [end of output]

  note: This error originates from a subprocess, and is likely not a problem with pip.
error: metadata-generation-failed

× Encountered error while generating package metadata.
╰─> See above for output.

note: This is an issue with the package mentioned above, not pip.
hint: See above for details.