After upgrading the temBoard agent from version 7.6 to version 7.7, I have noticed an issue in regards to parsing of the dsn of the parameter primary_conninfo. I have described the issue here:<\/p>\n
https:\/\/github.com\/dalibo\/temboard-agent\/issues\/531<\/a><\/p>\n And this is the error which pops up in the Agent log file.<\/p>\n The issue applies on Red Hat 7 and Red Hat 8 on the PostgreSQL Standby side. Let’s take a look first on Red Hat 8.<\/p>\n Red Hat 8 comes with Python 3 per default, and also with a quite recent libpq version.<\/p>\n However, the Agent has issues with parsing the primary_conninfo if it looks like this one (which is perfectly valid from the PostgreSQL point of view):<\/p>\n After removing the single quotes from the passfile parameter it works. \ud83d\ude42<\/p>\n On Red Hat 7 it is a different story, because it is shipped per default with a quite old libpq.<\/p>\n To fix the issue, we must find a way to tell psycopg to use a different libpq shared object, or to upgrade psycopg to a more recent version.<\/p>\n There a different ways to upgrade to a more recent version on Red Hat 7 or to fix it in a different way.<\/p>\n Let’s get through the different options.<\/p>\n You could install a more recent version from the postgresql.org yum repository. However, this comes with it’s one issues. You could easily mess up your rpm repository.<\/p>\n You could compile psycopg yourself. For more information, take a look at the following links.<\/p>\n https:\/\/www.psycopg.org\/<\/a> You could change the parameter passfile to password. For example from<\/p>\n to<\/p>\n Or you could change the temBoard Agent systemd service, to point to a different library path, which is the most elegant solution from my point of view.<\/p>\n To do so, you just need to add the LD_LIBRARY_PATH to you systemd service file.<\/p>\n Afterwards reload the daemon and restart the agent.<\/p>\n Ready.<\/p>\n Fixing the issue is not too complicated. On Red Hat 8 you need just to remove the single quotes from the passfile parameter. On Red Hat 7 you need to remove the single quotes as well, and additionally add one environment variable to your systemd service.<\/p>\n","protected":false},"excerpt":{"rendered":" After upgrading the temBoard agent from version 7.6 to version 7.7, I have noticed an issue in regards to parsing of the dsn of the parameter primary_conninfo. I have described the issue here: https:\/\/github.com\/dalibo\/temboard-agent\/issues\/531 And this is the error which pops up in the Agent log file. 2021-06-07 14:52:38,583 temboardagent[2030906]: [probes] ERROR: File "\/usr\/lib64\/python3.6\/site-packages\/psycopg2\/extensions.py", line […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ocean_post_layout":"","ocean_both_sidebars_style":"","ocean_both_sidebars_content_width":0,"ocean_both_sidebars_sidebars_width":0,"ocean_sidebar":"","ocean_second_sidebar":"","ocean_disable_margins":"enable","ocean_add_body_class":"","ocean_shortcode_before_top_bar":"","ocean_shortcode_after_top_bar":"","ocean_shortcode_before_header":"","ocean_shortcode_after_header":"","ocean_has_shortcode":"","ocean_shortcode_after_title":"","ocean_shortcode_before_footer_widgets":"","ocean_shortcode_after_footer_widgets":"","ocean_shortcode_before_footer_bottom":"","ocean_shortcode_after_footer_bottom":"","ocean_display_top_bar":"default","ocean_display_header":"default","ocean_header_style":"","ocean_center_header_left_menu":"","ocean_custom_header_template":"","ocean_custom_logo":0,"ocean_custom_retina_logo":0,"ocean_custom_logo_max_width":0,"ocean_custom_logo_tablet_max_width":0,"ocean_custom_logo_mobile_max_width":0,"ocean_custom_logo_max_height":0,"ocean_custom_logo_tablet_max_height":0,"ocean_custom_logo_mobile_max_height":0,"ocean_header_custom_menu":"","ocean_menu_typo_font_family":"","ocean_menu_typo_font_subset":"","ocean_menu_typo_font_size":0,"ocean_menu_typo_font_size_tablet":0,"ocean_menu_typo_font_size_mobile":0,"ocean_menu_typo_font_size_unit":"px","ocean_menu_typo_font_weight":"","ocean_menu_typo_font_weight_tablet":"","ocean_menu_typo_font_weight_mobile":"","ocean_menu_typo_transform":"","ocean_menu_typo_transform_tablet":"","ocean_menu_typo_transform_mobile":"","ocean_menu_typo_line_height":0,"ocean_menu_typo_line_height_tablet":0,"ocean_menu_typo_line_height_mobile":0,"ocean_menu_typo_line_height_unit":"","ocean_menu_typo_spacing":0,"ocean_menu_typo_spacing_tablet":0,"ocean_menu_typo_spacing_mobile":0,"ocean_menu_typo_spacing_unit":"","ocean_menu_link_color":"","ocean_menu_link_color_hover":"","ocean_menu_link_color_active":"","ocean_menu_link_background":"","ocean_menu_link_hover_background":"","ocean_menu_link_active_background":"","ocean_menu_social_links_bg":"","ocean_menu_social_hover_links_bg":"","ocean_menu_social_links_color":"","ocean_menu_social_hover_links_color":"","ocean_disable_title":"default","ocean_disable_heading":"default","ocean_post_title":"","ocean_post_subheading":"","ocean_post_title_style":"","ocean_post_title_background_color":"","ocean_post_title_background":0,"ocean_post_title_bg_image_position":"","ocean_post_title_bg_image_attachment":"","ocean_post_title_bg_image_repeat":"","ocean_post_title_bg_image_size":"","ocean_post_title_height":0,"ocean_post_title_bg_overlay":0.5,"ocean_post_title_bg_overlay_color":"","ocean_disable_breadcrumbs":"default","ocean_breadcrumbs_color":"","ocean_breadcrumbs_separator_color":"","ocean_breadcrumbs_links_color":"","ocean_breadcrumbs_links_hover_color":"","ocean_display_footer_widgets":"default","ocean_display_footer_bottom":"default","ocean_custom_footer_template":"","ocean_post_oembed":"","ocean_post_self_hosted_media":"","ocean_post_video_embed":"","ocean_link_format":"","ocean_link_format_target":"self","ocean_quote_format":"","ocean_quote_format_link":"post","ocean_gallery_link_images":"on","ocean_gallery_id":[],"footnotes":""},"categories":[6,7],"tags":[21,24],"class_list":["post-274","post","type-post","status-publish","format-standard","hentry","category-postgresql","category-red-hat","tag-postgresql","tag-temboard","entry"],"yoast_head":"\n\n2021-06-07 14:52:38,583 temboardagent[2030906]: [probes] ERROR: File "\/usr\/lib64\/python3.6\/site-packages\/psycopg2\/extensions.py", line 155, in make_dsn\n2021-06-07 14:52:38,583 temboardagent[2030906]: [probes] ERROR: parse_dsn(dsn)\n2021-06-07 14:52:38,583 temboardagent[2030906]: [probes] ERROR: psycopg2.ProgrammingError: invalid dsn: missing "=" after "\/home\/postgres\/.pgpass''" in connection info string\n2021-06-07 14:52:38,597 temboardagent[2030906]: [probes] ERROR: invalid dsn: missing "=" after "\/home\/postgres\/.pgpass''" in connection info string\n2021-06-07 14:52:38,597 temboardagent[2030906]: [probes] ERROR: Traceback (most recent call last):\n2021-06-07 14:52:38,597 temboardagent[2030906]: [probes] ERROR: File "\/usr\/lib\/python3.6\/site-packages\/temboardagent\/plugins\/monitoring\/probes.py", line 865, in run\n2021-06-07 14:52:38,597 temboardagent[2030906]: [probes] ERROR: dsn = parse_dsn(get_primary_conninfo(conn))\n2021-06-07 14:52:38,597 temboardagent[2030906]: [probes] ERROR: psycopg2.ProgrammingError: invalid dsn: missing "=" after "\/home\/postgres\/.pgpass''" in connection info string\n<\/pre>\n
\n$ cat \/etc\/redhat-release\nRed Hat Enterprise Linux release 8.3 (Ootpa)\n$ uname -a\nLinux host01 4.18.0-240.15.1.el8_3.x86_64 #1 SMP Wed Feb 3 03:12:15 EST 2021 x86_64 x86_64 x86_64 GNU\/Linux\n<\/pre>\n
\n$ ldd \/usr\/lib64\/python3.6\/site-packages\/psycopg2\/_psycopg.cpython-36m-x86_64-linux-gnu.so | grep libpq\n libpq.so.5 => \/lib64\/libpq.so.5 (0x000014ef0d124000)\n$ ls -l \/lib64\/libpq.so.5\nlrwxrwxrwx. 1 root root 13 Dec 1 2020 \/lib64\/libpq.so.5 -> libpq.so.5.12\n$ ls -l \/lib64\/libpq.so.5.12\n-rwxr-xr-x. 1 root root 332608 Dec 1 2020 \/lib64\/libpq.so.5.12\n<\/pre>\n
\n$ cat postgresql.auto.conf.20210607a\n# Do not edit this file manually!\n# It will be overwritten by the ALTER SYSTEM command.\nprimary_conninfo = 'host=host00 port=55041 user=repmgr application_name=pgx connect_timeout=2 passfile=''\/home\/postgres\/.pgpass'''\nrecovery_target_timeline = 'latest'\n<\/pre>\n
\n$ cat postgresql.auto.conf\n# Do not edit this file manually!\n# It will be overwritten by the ALTER SYSTEM command.\nprimary_conninfo = 'host=host00 port=55041 user=repmgr application_name=pgx connect_timeout=2 passfile=\/home\/postgres\/.pgpass'\nrecovery_target_timeline = 'latest'\n<\/pre>\n
\n$ cd \/usr\/lib64\n$ ls -l | grep libpq\nlrwxrwxrwx. 1 root root 12 Jul 10 2020 libpq.so.5 -> libpq.so.5.5\n-rwxr-xr-x. 1 root root 197544 Feb 24 2020 libpq.so.5.5\n\n$ rpm -qa | grep postgres\npostgresql-libs-9.2.24-4.el7_8.x86_64\n<\/pre>\n
\n$ ldd \/usr\/lib64\/python3.6\/site-packages\/psycopg2\/_psycopg.cpython-36m-x86_64-linux-gnu.so | grep libpq\n libpq.so.5 => \/lib64\/libpq.so.5 (0x00002b464425e000)\n<\/pre>\n
\n
\n# Install the repository RPM:\nsudo yum install -y https:\/\/download.postgresql.org\/pub\/repos\/yum\/reporpms\/EL-7-x86_64\/pgdg-redhat-repo-latest.noarch.rpm\n<\/pre>\n
\nhttps:\/\/www.psycopg.org\/docs\/install.html<\/a>
\nhttps:\/\/github.com\/psycopg\/psycopg2<\/a><\/p>\n\nprimary_conninfo = 'user=repmgr connect_timeout=2 host=host00 port=55004 user=repmgr application_name=pgx ''passfile=\/home\/postgres\/.pgpass'''\n<\/pre>\n
\nprimary_conninfo = 'user=repmgr connect_timeout=2 host=host00 port=55004 user=repmgr application_name=pgx connect_timeout=2 password=***************'\n<\/pre>\n
\n$ cat temboard-agent@12-pg55000.service\n[Unit]\nDescription=PostgreSQL Remote Control Agent %I\nAfter=network.target postgresql@%i.service\nAssertPathExists=\/etc\/temboard-agent\/%I\/temboard-agent.conf\n\n[Service]\nType=simple\nUser=postgres\nGroup=postgres\nEnvironment="LD_LIBRARY_PATH=\/app\/lib\/postgres\/pgproduct\/pg-12.6\/lib"\nExecStart=\/usr\/bin\/env SYSTEMD=1 temboard-agent -c \/etc\/temboard-agent\/%I\/temboard-agent.conf\n\n[Install]\nWantedBy=multi-user.target\n<\/pre>\n
\n$ sudo systemctl daemon-reload\n$ sudo systemctl stop temboard-agent@12-pg55000.service\n$ sudo systemctl start temboard-agent@12-pg55000.service\n<\/pre>\n
Conclusion<\/h3>\n