Hello community, here is the log from the commit of package pgadmin4 for openSUSE:Factory checked in at 2020-09-21 17:44:54 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Comparing /work/SRC/openSUSE:Factory/pgadmin4 (Old) and /work/SRC/openSUSE:Factory/.pgadmin4.new.4249 (New) ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Package is "pgadmin4" Mon Sep 21 17:44:54 2020 rev:13 rq:835690 version:4.26 Changes: -------- --- /work/SRC/openSUSE:Factory/pgadmin4/pgadmin4.changes 2020-06-15 20:32:22.722769385 +0200 +++ /work/SRC/openSUSE:Factory/.pgadmin4.new.4249/pgadmin4.changes 2020-09-21 17:47:40.837153740 +0200 @@ -1,0 +2,188 @@ +Sun Sep 20 16:43:55 UTC 2020 - Marcus Rueckert <[email protected]> + +- Update to 4.26: + - Added SQL Formatter support in Query Tool. + - Added a new button to the query tool toolbar to open a new + query tool window. + - Added shared server support for admin users. + - Warn the user when connecting to a server that is older than + pgAdmin supports. + - Ensure that schema names starting with 'pg' should be visible + in browser tree when standard_conforming_strings is set to off. + - Fixed an issue where --load-server does not allow loading + connections that use pg_services. + - Fixed string indices must be integers issue for PostgreSQL < + 9.3. + - Fixed an issue where the application ignores the fixed port + configuration value. + - Remove illegal argument from trigger function in trigger DDL + statement. + - Ensure that 'setup-web.sh' should work in Debian 10. + - Fixed excessive CPU usage by stopping the indefinite growth of + the graph dataset. + +------------------------------------------------------------------- +Fri Sep 11 13:03:51 UTC 2020 - Andreas Schneider <[email protected]> + +- Create a pgadmin user and group +- Add uwsgi configuration (fast, user privileges and apparmor support) + +------------------------------------------------------------------- +Thu Sep 10 19:24:29 UTC 2020 - Andreas Schneider <[email protected]> + +- Only activate the pgadmin4 apache config if the PGADMIN4 flag is set. + For mod_wsgi you should use `a2enmod wsgi` +- Create /etc/pgadmin/config_system.py with server mode for web + Run /usr/lib/python3.6/site-packages/pgadmin4-web/setup.py to create + the admin user +- Remove config_local.py with outdated options + +------------------------------------------------------------------- +Mon Sep 7 13:32:12 UTC 2020 - Paolo Stivanin <[email protected]> + +- Update to 4.25: + - Modified schema diff tool to compare two databases instead of + two schemas + - Resolve schema diff dependencies by selecting the appropriate + node automatically and maintain the order in the + generated script. + - Replace charting library Flotr2 with ChartJS using React. + - Upgrade font-awesome from v4 to v5. + - Fixed an issue where debugger doesn't work if the search path + is set other than 'public'. + - Fixed ssh tunnel hang issue when the user tries to disconnect + the server. + - Fixed an issue where conversion of bytea to the binary string + results in an error. + - Fixed an issue where the entire logs are in red text when the + user runs backup and restore. + - Ensure that the user will be able to modify the start value + of the Identity column. + - Fixed an issue where 'ALTER VIEW' statement is missing when + the user sets the default value of a column for View. + +------------------------------------------------------------------- +Tue Aug 4 14:42:39 UTC 2020 - Marcus Rueckert <[email protected]> + +- Update to 4.24 + - New features + - Issue #5235 - Support configuration files that are external + to the application installation. + - Issue #5484 - Added support for LDAP authentication with + different DN by setting the dedicated user for the LDAP + connection. + - Issue #5583 - Added support for schema level restriction. + - Issue #5601 - Added RLS Policy support in Schema Diff. + - Issue #5622 - Added support for permissive/restricted policy + type while creating RLS Policy. + - Issue #5650 - Added support for LDAP anonymous binding. + - Issue #5653 - Added High Contrast theme support. + - Housekeeping + - Issue #5323 - Improve code coverage and API test cases for + Foreign Data Wrapper. + - Issue #5326 - Improve code coverage and API test cases for + Domain and Domain Constraints. + - Issue #5329 - Improve code coverage and API test cases for + FTS Configuration, FTS Parser, FTS Dictionaries, and FTS + Template. + - Bug fixes + - Issue #3814 - Fixed issue of error message not getting + displayed when filename is empty for backup, restore, and + import/export. + - Issue #3851 - Add proper indentation to the code while + generating functions, procedures, and trigger functions. + - Issue #4235 - Fixed tab indent issue on a selection of lines + is deleting the content when ‘use spaces == true’ in the + preferences. + - Issue #5137 - Fixed save button enable issue when focusing in + and out of numeric input field. + - Issue #5287 - Fixed dark theme-related CSS and modify the + color codes. + - Issue #5414 - Use QStandardPaths::AppLocalDataLocation in the + runtime to determine where to store runtime logs. + - Issue #5463 - Fixed an issue where CSV download quotes + numeric columns. + - Issue #5470 - Fixed backgrid row hover issue where on hover + background color is set for edit and delete cell only. + - Issue #5530 - Ensure that the referenced table should be + displayed on foreign key constraints. + - Issue #5554 - Replace the runtime themes with ones that don’t + have sizing issues. + - Issue #5569 - Fixed reverse engineered SQL for partitions + when storage parameters are specified. + - Issue #5577 - Include LICENSE and DEPENDENCIES [inventory] + files in official packages. + - Issue #5621 - Remove extra brackets from reverse engineering + SQL of RLS Policy. + - Issue #5629 - Fixed an issue where the user is able to edit + properties when some of the collection nodes are selected. + - Issue #5630 - Fixed an issue where installation of pgadmin4 + not working on 32-bit Windows. + - Issue #5631 - Fixed ‘cant execute empty query’ issue when + remove the value of ‘USING’ or ‘WITH CHECK’ option of RLS + Policy. + - Issue #5633 - Ensure that create RLS Policy menu should not + be visible for catalog objects. + - Issue #5647 - Fixed an issue where difference DDL is showing + the wrong SQL when changing the policy owner. + - Issue #5662 - Fixed accessibility issue where few dialogs are + not rendering properly when we zoomed in browser window 200% + and screen resolution is low. + - Issue #5666 - Added missing dependencies/dependent and + corrected some wrongly identified. + - Issue #5673 - Fixed an issue where fetching the schema throws + an error if the database is not connected in Schema Diff. + - Issue #5675 - Fixed CSRF errors when pgAdmin opened in an + iframe on safari browser. + - Issue #5677 - Fixed text color issue in explain analyze for + the Dark theme. + - Issue #5686 - Fixed issue where the user was not able to + update policy if the policy is created with space. +- update requires to match requirements.txt + +------------------------------------------------------------------- +Tue Jul 14 13:27:20 UTC 2020 - Marcus Rueckert <[email protected]> + +- Update to 4.23 + - New features + - Issue #5468 - Added option to ignore the whitespaces while + comparing objects in schema diff. + - Issue #5500 - Added server group name while selecting servers + in schema diff. + - Issue #5516 - Added support of Row Security Policies. + - Issue #5576 - Improve error messaging if the storage and log + directories cannot be created. + - Housekeeping + - Issue #5325 - Improve code coverage and API test cases for + Collations. + - Issue #5574 - Cleanup Windows build scripts and ensure + Windows x64 builds will work. + - Issue #5581 - Documentation of Row Level Security Policies. + - Bug fixes + - Issue #3591 - Ensure that the query tool should display the + proper error message while terminating the active session. + - Issue #3669 - Ensure that proper error should be displayed + for the deleted node. + - Issue #3787 - Disabled the Stop process button after clicking + it and added a message ‘Terminating the process…’ to notify + the user. + - Issue #4226 - Fixed an issue where select all checkbox only + selects the first 50 tables. + - Issue #5416 - Ensure that the query tool panel gets closed + when clicking on the ‘Don’t Save’ button. + - Issue #5465 - Fixed an issue where the Edge browser version + is showing wrong and warning message gets displayed. + - Issue #5492 - Fixed an issue where the search object is + unable to locate inherited tables and constraint filters are + not working. + - Issue #5507 - Fixed connection and version number detection + issue when the database server is upgraded. + - Issue #5521 - Fixed an issue when dumping servers from a + desktop pgAdmin app by providing an option ‘–sqlite-path’. + - Issue #5539 - Fixed typo in exception keyword. + - Issue #5584 - Fixed an issue where two identical tables + showing different by schema diff tool. + - Issue #5592 - Ensure that pgadmin should be able to connect + to the server which has password more than 1000 characters. + +------------------------------------------------------------------- Old: ---- pgadmin4-4.22.tar.gz pgadmin4-4.22.tar.gz.asc pgadmin4.config_local.py.in New: ---- README.SUSE.uwsgi pgadmin4-4.26.tar.gz pgadmin4-4.26.tar.gz.asc pgadmin4.uwsgi ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Other differences: ------------------ ++++++ pgadmin4.spec ++++++ --- /var/tmp/diff_new_pack.IdLkgx/_old 2020-09-21 17:47:46.421159002 +0200 +++ /var/tmp/diff_new_pack.IdLkgx/_new 2020-09-21 17:47:46.425159006 +0200 @@ -17,8 +17,11 @@ %global pgadmin4instdir %{_libdir}/pgadmin4-%{version} +%global pgadmin4homedir /var/lib/pgadmin +%global user_group_name pgadmin + Name: pgadmin4 -Version: 4.22 +Version: 4.26 Release: 0 Summary: Management tool for PostgreSQL License: PostgreSQL @@ -32,9 +35,10 @@ Source2: %{name}.service.in Source3: %{name}.tmpfiles.d Source4: %{name}.desktop.in -Source5: %{name}.config_local.py.in Source6: %{name}.qt.conf.in -Source7: README.SUSE +Source7: %{name}.uwsgi +Source8: README.SUSE +Source9: README.SUSE.uwsgi Patch0: use-os-makedirs.patch Patch1: fix-python3-crypto-call.patch Patch2: fix-python-lib.patch @@ -82,8 +86,8 @@ Requires: python3-Jinja2 >= 2.7.3 Requires: python3-MarkupSafe >= 0.23 Requires: python3-SQLAlchemy >= 1.3.13 -Requires: python3-WTForms >= 2.1 -Requires: python3-Werkzeug >= 0.14.1 +Requires: python3-WTForms >= 2.2.1 +Requires: python3-Werkzeug >= 0.15.0 Requires: python3-beautifulsoup4 >= 4.4.1 Requires: python3-blinker >= 1.4 Requires: python3-click @@ -94,16 +98,16 @@ Requires: python3-itsdangerous >= 0.24 Requires: python3-ldap3 >= 2.5.1 Requires: python3-linecache2 >= 1.0.0 -Requires: python3-passlib >= 1.7.1 +Requires: python3-passlib >= 1.7.2 Requires: python3-pbr >= 3.1.1 Requires: python3-psutil >= 5.7.0 -Requires: python3-psycopg2 >= 2.7.4 +Requires: python3-psycopg2 >= 2.8 Requires: python3-pycrypto >= 2.6.1 Requires: python3-pyrsistent >= 0.14.2 -Requires: python3-python-dateutil >= 2.7.3 +Requires: python3-python-dateutil >= 2.8.0 Requires: python3-python-mimeparse >= 1.6.0 -Requires: python3-pytz >= 2018.3 -Requires: python3-simplejson >= 3.13.2 +Requires: python3-pytz >= 2018.9 +Requires: python3-simplejson >= 3.16.0 Requires: python3-six >= 1.12.0 Requires: python3-speaklater >= 1.3 Requires: python3-sqlparse >= 0.2.4 @@ -136,11 +140,25 @@ %if %{?pkg_vcmp:%{pkg_vcmp python3-devel >= 3.8}}%{!?pkg_vcmp:0} %patch2 -p1 %endif -cp %{S:7} . + +cp %{SOURCE8} . +cp %{SOURCE9} . # rpmlint chmod -x docs/en_US/theme/pgadmin4/static/style.css chmod -x docs/en_US/theme/pgadmin4/theme.conf +%package web-uwsgi +Summary: Pgamdin4 - uwsgi configuration +Group: Productivity/Networking/Web/Utilities +BuildArch: noarch +Requires: pgadmin4-web +Requires: uwsgi + +%description web-uwsgi +pgadmin4 is a management tool for PostgreSQL. + +This package holds the uwsgi configuration. + %build cd runtime export PYTHON_CONFIG=%{_bindir}/python3-config @@ -168,8 +186,9 @@ install -d %{buildroot}%{_datadir}/applications/ sed -e 's@PYTHONDIR@%{_bindir}/python3@g' -e 's@PYTHONSITELIB@%{python3_sitelib}@g' < %{SOURCE4} > %{buildroot}%{_datadir}/applications/%{name}.desktop -# Install config_local -install -m 0644 %{SOURCE5} %{buildroot}%{python3_sitelib}/%{name}-web/config_local.py +# Install config system for webapp +install -d -m 0755 %{buildroot}%{_sysconfdir}/pgadmin/ +echo "SERVER_MODE = True" > %{buildroot}%{_sysconfdir}/pgadmin/config_system.py # Install QT conf file # This directory will/may change in future releases. @@ -196,7 +215,16 @@ ln -s %{_sbindir}/service %{buildroot}%{_sbindir}/rcpgadmin4 %fdupes %{buildroot}/%{_prefix} +install -d -m 0755 %{buildroot}%{pgadmin4homedir} +install -d -m 0755 %{buildroot}%{pgadmin4homedir}/storage +install -d -m 0700 %{buildroot}%{pgadmin4homedir}/sessions + +install -d -m 0755 %{buildroot}%{_sysconfdir}/uwsgi/vassals +install -m 0644 %{SOURCE7} %{buildroot}%{_sysconfdir}/uwsgi/vassals/pgadmin4.ini + %pre web +/usr/sbin/groupadd -r %{user_group_name} &>/dev/null || : +/usr/sbin/useradd -g %{user_group_name} -s /bin/false -r -c "%{name}" -d %{pgadmin4homedir} %{user_group_name} &>/dev/null || : %service_add_pre %{name}.service %post web @@ -220,19 +248,36 @@ %files web %defattr(-,root,root,-) -%dir %{python3_sitelib}/%{name}-web/ -%{python3_sitelib}/%{name}-web/* %dir %{_sysconfdir}/apache2 %dir %{_sysconfdir}/apache2/conf.d %config(noreplace) %{_sysconfdir}/apache2/conf.d/%{name}.conf + +%dir %{python3_sitelib}/%{name}-web/ +%{python3_sitelib}/%{name}-web/* + %{_unitdir}/%{name}.service %{_tmpfilesdir}/%{name}.conf %{_sbindir}/rcpgadmin4 + +%defattr(-,root,%{user_group_name}) +%dir %{_sysconfdir}/pgadmin +%config(noreplace) %{_sysconfdir}/pgadmin/config_system.py + +%defattr(-,%{user_group_name},%{user_group_name}) %ghost %dir %{_rundir}/%{name} +%dir %{pgadmin4homedir} +%dir %{pgadmin4homedir}/storage +%attr(700,%{user_group_name},%{user_group_name}) %dir %{pgadmin4homedir}/sessions %files doc %defattr(-,root,root,-) %dir %{_docdir}/%{name}-docs %doc %{_docdir}/%{name}-docs/* +%files web-uwsgi +%defattr(-,root,root,-) +%dir %{_sysconfdir}/uwsgi +%dir %{_sysconfdir}/uwsgi/vassals +%config (noreplace) %{_sysconfdir}/uwsgi/vassals/pgadmin4.ini + %changelog ++++++ README.SUSE.uwsgi ++++++ To configure pgadmin with Apache and uwsgi, just add the follwing lines to a vhost: ProxyPass /pgadmin unix:/run/uwsgi/uwsgi-pgadmin.sock|uwsgi://localhost/ <Directory /usr/lib/python3.6/site-packages/pgadmin4-web/> Require all granted </Directory> ++++++ pgadmin4-4.22.tar.gz -> pgadmin4-4.26.tar.gz ++++++ /work/SRC/openSUSE:Factory/pgadmin4/pgadmin4-4.22.tar.gz /work/SRC/openSUSE:Factory/.pgadmin4.new.4249/pgadmin4-4.26.tar.gz differ: char 5, line 1 ++++++ pgadmin4.conf ++++++ --- /var/tmp/diff_new_pack.IdLkgx/_old 2020-09-21 17:47:46.541159115 +0200 +++ /var/tmp/diff_new_pack.IdLkgx/_new 2020-09-21 17:47:46.541159115 +0200 @@ -1,4 +1,11 @@ -LoadModule wsgi_module modules/mod_wsgi.so +# To enable the /pgadmin4 alias, run +# a2enmod wsgi && a2enflag PGADMIN && rcapache2 restart +# This will make /pgadmin4 available on all virtual hosts. +# +# If you want to have the /pgadmin4 alias only on a specific +# virtual host, add the alias to the config of that vhost. + +<IfDefine PGADMIN> WSGIDaemonProcess pgadmin processes=1 threads=25 WSGIScriptAlias /pgadmin4 /usr/lib/python3.6/site-packages/pgadmin4-web/pgAdmin4.wsgi @@ -17,4 +24,4 @@ Allow from ::1 </IfModule> </Directory> - +</IfDefine> ++++++ pgadmin4.tmpfiles.d ++++++ --- /var/tmp/diff_new_pack.IdLkgx/_old 2020-09-21 17:47:46.605159175 +0200 +++ /var/tmp/diff_new_pack.IdLkgx/_new 2020-09-21 17:47:46.609159179 +0200 @@ -1,2 +1 @@ -d /run/pgadmin4 0755 root root - - +d /run/pgadmin4 0755 pgadmin pgadmin - ++++++ pgadmin4.uwsgi ++++++ [uwsgi] #plugin = apparmor #apparmor-hat = pgadmin uid = pgadmin gid = pgadmin processes = 1 threads = 25 socket = /run/uwsgi/uwsgi-pgadmin.sock chmod-socket = 660 chown-socket = wwwrun:www plugin = python3 chdir = /usr/lib/python3.6/site-packages/pgadmin4-web/ mount = /=pgAdmin4:app
