Re: Translators: Release next week

2020-04-26 Thread fred . escallier

hello 
in attachment french translation for upcoming relase 
bye 
Fred 


- Mail original -

De: "Akshay Joshi"  
À: "pgadmin-hackers"  
Envoyé: Vendredi 24 Avril 2020 15:03:07 
Objet: Translators: Release next week 


Hi Translators, 


We will have a release next week, so updates to translations before release 
would be helpful. The template and catalogs have been updated in git. 

-- 









Thanks & Regards 
Akshay Joshi 
Sr. Software Architect 

EnterpriseDB Software India Private Limited 

Mobile: +91 976-788-8246 



messages-fr.tar.xz
Description: application/xz-compressed-tar


Re: [pgAdmin][RM4279] : Issue with File Browser Home button

2020-04-26 Thread Aditya Toshniwal
Hi Yogesh,

Just did an eyeball review. You've included homedir path in the response
rendered JS file. You're exposing underlying directory structure to users
even in server mode. This is not appropriate. This info should remain at
the server and not at the client side.
+homedir=os.path.expanduser('~'),

On Fri, Apr 24, 2020 at 7:26 PM Yogesh Jain 
wrote:

> Hi Hackers,
>
> Attached is the patch to fix the issue with the file browser Home button.
>
> FYI : While clicking on the home button it was pointing to the user's root
> directory rather than home directory, which is fixed in this patch.
>
> Please review.
> PFA.
>
> --
> Regards,
> Yogesh Jain
> 8982696654
>


-- 
Thanks and Regards,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune
"Don't Complain about Heat, Plant a TREE"


[pgAdmin4][Patch] - Improve LDAP Error messages

2020-04-26 Thread Khushboo Vashi
Hi,

Please find the attached patch to improve the ldap error messages.

Thanks,
Khushboo


ldap_error_messages.patch
Description: Binary data


Re: Addition of support for base path in pgAdmin Web

2020-04-26 Thread Akshay Joshi
Hi Aditya

Can you please review it.

On Sat, Apr 25, 2020 at 3:28 PM Eldhose M Joy  wrote:

> Hi,
>
> I have added a commit on 2 files to include a base path that would avoid
> all the hassle while doing a reverse proxy on to the pgAdmin.  Please find
> the commits below.
>
> https://github.com/postgres/pgadmin4/compare/master...eldhosemjoy:patch-2
> https://github.com/postgres/pgadmin4/compare/master...eldhosemjoy:patch-3
>
> Thanks and Regards,
> Eldhose
>
> Sent from my iPhone
>


-- 
*Thanks & Regards*
*Akshay Joshi*

*Sr. Software Architect*
*EnterpriseDB Software India Private Limited*
*Mobile: +91 976-788-8246*


Re: [pgAdmin][RM4279] : Issue with File Browser Home button

2020-04-26 Thread Yogesh Jain
Hi Aditya,

Thanks for the feedback. Here is an updated patch, regarding the same.

Please Review.
PFA.

On Mon, Apr 27, 2020 at 9:05 AM Aditya Toshniwal <
aditya.toshni...@enterprisedb.com> wrote:

> Hi Yogesh,
>
> Just did an eyeball review. You've included homedir path in the response
> rendered JS file. You're exposing underlying directory structure to users
> even in server mode. This is not appropriate. This info should remain at
> the server and not at the client side.
> +homedir=os.path.expanduser('~'),
>
> On Fri, Apr 24, 2020 at 7:26 PM Yogesh Jain 
> wrote:
>
>> Hi Hackers,
>>
>> Attached is the patch to fix the issue with the file browser Home button.
>>
>> FYI : While clicking on the home button it was pointing to the user's
>> root directory rather than home directory, which is fixed in this patch.
>>
>> Please review.
>> PFA.
>>
>> --
>> Regards,
>> Yogesh Jain
>> 8982696654
>>
>
>
> --
> Thanks and Regards,
> Aditya Toshniwal
> pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune
> "Don't Complain about Heat, Plant a TREE"
>


-- 
Regards,
Yogesh Jain
8982696654
diff --git a/web/pgadmin/misc/file_manager/__init__.py b/web/pgadmin/misc/file_manager/__init__.py
index 39aa39315..6ec75716e 100644
--- a/web/pgadmin/misc/file_manager/__init__.py
+++ b/web/pgadmin/misc/file_manager/__init__.py
@@ -249,13 +249,14 @@ def file_manager_config(trans_id):
 pref = Preferences.module('file_manager')
 file_dialog_view = pref.preference('file_dialog_view').get()
 show_hidden_files = pref.preference('show_hidden_files').get()
-
+homedir ='/' if(config.SERVER_MODE) else os.path.expanduser('~')
 return Response(response=render_template(
 "file_manager/js/file_manager_config.json",
 _=gettext,
 data=data,
 file_dialog_view=file_dialog_view,
-show_hidden_files=show_hidden_files
+show_hidden_files=show_hidden_files,
+homedir=homedir
 ),
 status=200,
 mimetype="application/json"
diff --git a/web/pgadmin/misc/file_manager/static/js/utility.js b/web/pgadmin/misc/file_manager/static/js/utility.js
index 353baf560..181f75abb 100644
--- a/web/pgadmin/misc/file_manager/static/js/utility.js
+++ b/web/pgadmin/misc/file_manager/static/js/utility.js
@@ -1141,14 +1141,11 @@ define([
 
 setTimeout(function() {
   var b = $('.currentpath').val(),
-$level_up = $('.file_manager').find('button.level-up'),
-$home_btn = $('.file_manager').find('button.home');
+$level_up = $('.file_manager').find('button.level-up');
 
   if (b === '/') {
 $level_up.attr('disabled', 'disabled');
-$home_btn.attr('disabled', 'disabled');
   } else {
-$home_btn.removeAttr('disabled');
 $level_up.removeAttr('disabled');
   }
 }, 100);
@@ -1343,8 +1340,7 @@ define([
 $('.delete_item, .fileinfo .fm_dimmer').hide();
   });
 
-  // Disable home button on load
-  $('.file_manager').find('button.home').attr('disabled', 'disabled');
+  // Disable button on load
   $('.file_manager').find('button.rename').attr('disabled', 'disabled');
 
   // stop click event on dimmer click
@@ -1382,7 +1378,7 @@ define([
   $('.file_manager .home').on('click', function() {
 var currentViewMode = $('.fileinfo').data('view');
 $('.fileinfo').data('view', currentViewMode);
-getFolderInfo('/');
+getFolderInfo(config.options.homedir);
 enab_dis_level_up();
   });
 
diff --git a/web/pgadmin/misc/file_manager/templates/file_manager/js/file_manager_config.json b/web/pgadmin/misc/file_manager/templates/file_manager/js/file_manager_config.json
index b29fcfb5f..3a7ed8d5c 100644
--- a/web/pgadmin/misc/file_manager/templates/file_manager/js/file_manager_config.json
+++ b/web/pgadmin/misc/file_manager/templates/file_manager/js/file_manager_config.json
@@ -11,7 +11,8 @@
   "capabilities": [{% for i in data.capabilities %}{% if loop.index != 1 %}, {% endif %}"{{i}}"{% endfor %}],
   "allowed_file_types": [{% for i in data.supported_types %}{% if loop.index != 1 %}, {% endif %}"{{i}}"{% endfor %}],
   "platform_type": "{{ data.platform_type }}",
-  "show_volumes": {% if data.show_volumes %}true{% else %}false{% endif %}
+  "show_volumes": {% if data.show_volumes %}true{% else %}false{% endif %},
+  "homedir":"{{homedir}}"
  },
  "security": {
   "uploadPolicy": "{{ data.security.uploadPolicy }}",


Re: [pgAdmin][RM4279] : Issue with File Browser Home button

2020-04-26 Thread Yogesh Jain
Hi Hackers,

I have tested this patch in linux (Ubuntu 18.04) env only , which is
working fine. It will be great if someone can review/test in the Windows
environment as well as I don't have the setup ready for that.

On Mon, Apr 27, 2020 at 10:47 AM Yogesh Jain 
wrote:

> Hi Aditya,
>
> Thanks for the feedback. Here is an updated patch, regarding the same.
>
> Please Review.
> PFA.
>
> On Mon, Apr 27, 2020 at 9:05 AM Aditya Toshniwal <
> aditya.toshni...@enterprisedb.com> wrote:
>
>> Hi Yogesh,
>>
>> Just did an eyeball review. You've included homedir path in the response
>> rendered JS file. You're exposing underlying directory structure to users
>> even in server mode. This is not appropriate. This info should remain at
>> the server and not at the client side.
>> +homedir=os.path.expanduser('~'),
>>
>> On Fri, Apr 24, 2020 at 7:26 PM Yogesh Jain 
>> wrote:
>>
>>> Hi Hackers,
>>>
>>> Attached is the patch to fix the issue with the file browser Home button.
>>>
>>> FYI : While clicking on the home button it was pointing to the user's
>>> root directory rather than home directory, which is fixed in this patch.
>>>
>>> Please review.
>>> PFA.
>>>
>>> --
>>> Regards,
>>> Yogesh Jain
>>> 8982696654
>>>
>>
>>
>> --
>> Thanks and Regards,
>> Aditya Toshniwal
>> pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune
>> "Don't Complain about Heat, Plant a TREE"
>>
>
>
> --
> Regards,
> Yogesh Jain
> 8982696654
>


-- 
Regards,
Yogesh Jain
8982696654


Re: Addition of support for base path in pgAdmin Web

2020-04-26 Thread Aditya Toshniwal
Hi Eldhose,

The changes you've suggested are already implemented in pgAdmin (
https://github.com/postgres/pgadmin4/blob/master/web/pgAdmin4.py#L87).
Almost all the servers provide the way to set the header - "X-Script-Name".
pgAdmin uses X-Script-Name to set the prefix. You don't need to add any new
config in pgAdmin. For instance, in nginx it can be done as:
proxy_set_header X-Script-Name /pgadmin4;

Please refer:
https://www.pgadmin.org/docs/pgadmin4/4.20/server_deployment.html#hosting

In case, the above setting is not working then please log a bug at -
https://redmine.postgresql.org/projects/pgadmin4/issues/new


On Mon, Apr 27, 2020 at 10:29 AM Akshay Joshi 
wrote:

> Hi Aditya
>
> Can you please review it.
>
> On Sat, Apr 25, 2020 at 3:28 PM Eldhose M Joy 
> wrote:
>
>> Hi,
>>
>> I have added a commit on 2 files to include a base path that would avoid
>> all the hassle while doing a reverse proxy on to the pgAdmin.  Please find
>> the commits below.
>>
>> https://github.com/postgres/pgadmin4/compare/master...eldhosemjoy:patch-2
>> https://github.com/postgres/pgadmin4/compare/master...eldhosemjoy:patch-3
>>
>> Thanks and Regards,
>> Eldhose
>>
>> Sent from my iPhone
>>
>
>
> --
> *Thanks & Regards*
> *Akshay Joshi*
>
> *Sr. Software Architect*
> *EnterpriseDB Software India Private Limited*
> *Mobile: +91 976-788-8246*
>


-- 
Thanks and Regards,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune
"Don't Complain about Heat, Plant a TREE"


Re: [pgAdmin4][RM#5213] Fixed materialized view issue when user perform refresh on it

2020-04-26 Thread Akshay Joshi
Hi Murtuza

API test cases are not running, there is no error but all the tests are
skipped. I have run it for EPAS/PG 9.5 to 12 where the binary path for EPAS
is not set.

I also found one issue where the proper error message is not shown if the
binary path is not set in the Preferences dialog. I have fixed those issues
and attached is the patch.
Please continue working on the attached patch.

On Fri, Apr 24, 2020 at 6:27 PM Murtuza Zabuawala <
murtuza.zabuaw...@enterprisedb.com> wrote:

> Hi,
>
> PFA patch to fix the issue for materialized view when the user performs
> refresh on it, large size materialized view can take longer time to refresh
> the view hence we will run it same as we run maintenance commands and it
> will also allow the user to view the status of the refresh command.
>
>
> --
> Regards,
> Murtuza Zabuawala
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
>

-- 
*Thanks & Regards*
*Akshay Joshi*

*Sr. Software Architect*
*EnterpriseDB Software India Private Limited*
*Mobile: +91 976-788-8246*


RM_5213_v2.patch
Description: Binary data


Re: [pgAdmin][RM3787] Issue with Stop Process button

2020-04-26 Thread Akshay Joshi
Hi Nagesh

Your patch looks good to me, but it will not solve the issue that
"Richard" has mentioned in the RM. What if terminating the process takes a
long time?
Please consider that and provide the proper solution.

On Fri, Apr 24, 2020 at 7:12 PM Nagesh Dhope 
wrote:

> Hi Hackers,
> After the process is terminated, it's taking some time to return exit_code
> and our frontend code is waiting for exit_code to notify the user that the
> process is terminated by the user. Also *Stop Process *button is not
> getting disabled and which is misleading the user that nothing is
> happening, which may result in user clicking on the button multiple
> times(Backend is throwing process not found exception due to this).
>
> To fix this, I have disabled *Stop Process *button after the user clicks
> on it and added a message *"Terminating the process..." *till exit_code
> is received.
>
> --
> Thanks,
> Nagesh
>


-- 
*Thanks & Regards*
*Akshay Joshi*

*Sr. Software Architect*
*EnterpriseDB Software India Private Limited*
*Mobile: +91 976-788-8246*


Re: [pgAdmin4][RM#5213] Fixed materialized view issue when user perform refresh on it

2020-04-26 Thread Murtuza Zabuawala
Thanks Akshay, flag not to run tests set to true when the check
utility fails in-case if the binary path is not set, I will fix that issue
as I did not consider more than one server scenario.



On Mon, Apr 27, 2020 at 12:05 PM Akshay Joshi 
wrote:

> Hi Murtuza
>
> API test cases are not running, there is no error but all the tests are
> skipped. I have run it for EPAS/PG 9.5 to 12 where the binary path for EPAS
> is not set.
>
> I also found one issue where the proper error message is not shown if the
> binary path is not set in the Preferences dialog. I have fixed those issues
> and attached is the patch.
> Please continue working on the attached patch.
>
> On Fri, Apr 24, 2020 at 6:27 PM Murtuza Zabuawala <
> murtuza.zabuaw...@enterprisedb.com> wrote:
>
>> Hi,
>>
>> PFA patch to fix the issue for materialized view when the user performs
>> refresh on it, large size materialized view can take longer time to refresh
>> the view hence we will run it same as we run maintenance commands and it
>> will also allow the user to view the status of the refresh command.
>>
>>
>> --
>> Regards,
>> Murtuza Zabuawala
>> EnterpriseDB: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>>
>
> --
> *Thanks & Regards*
> *Akshay Joshi*
>
> *Sr. Software Architect*
> *EnterpriseDB Software India Private Limited*
> *Mobile: +91 976-788-8246*
>