Re: Help on installing pgadmin4 from rpm
On Wed, Jul 14, 2021 at 11:53 AM Prasanth M Sasidharan wrote: > That worked. Thanks Dave for the help and the guidance.Appreciate it. > Glad to hear it - you're welcome! > > On Wed, Jul 14, 2021 at 1:34 PM Dave Page wrote: > >> Hi >> >> On Wed, Jul 14, 2021 at 8:13 AM Prasanth M Sasidharan < >> prasha...@gmail.com> wrote: >> >>> Hello Dave, >>> >>> That actually worked . I did the rpm installation of python & pgadmin >>> and I was able to install it successfully. >>> >>> However, I am unable to login to the pgadmin4 page due to incorrect >>> username and password. I am using the same email address and password given >>> while running the /usr/pgadmin4/bin/setup-web.sh. >>> >>> Is there any additional configuration needed? >>> >> >> My guess is you've run into an issue caused by increased validation in >> the flask-security-too module, the workaround for which is described at >> https://redmine.postgresql.org/issues/6550#note-27 (it'll be fixed in >> the upcoming v5.5 release). Essentially, because your machine is isolated >> from the internet, your email address is probably failing the >> deliverability check that the python module now does by default. >> >> Essentially, you need to add: >> >> SECURITY_EMAIL_VALIDATOR_ARGS={"check_deliverability": False} >> >> to your config_local.py or config_system.py file. See >> https://www.pgadmin.org/docs/pgadmin4/5.4/config_py.html for more info >> on those files. >> >> >>> >>> >>> On Tue, Jul 13, 2021 at 7:31 PM Dave Page wrote: >>> Hi On Tue, Jul 13, 2021 at 2:56 PM Prasanth M Sasidharan < prasha...@gmail.com> wrote: > Hi Dave, > > Appreciate the reply. I downloaded the python package from > https://www.python.org/ftp/python/3.6.8/Python-3.6.8.tgz and compiled > it. > > However, it's still throwing the same error . Would appreciate if you > could point me to the right direction > Sure. Install the Python 3 package from CentOS/Redhat (as appropriate for whatever your OS is). The pgAdmin RPM is complaining because you don't have the python3 RPM installed. Using a from-source installation of Python isn't supported by the RPMs. If you really want to use a from-source installation, you'll have to build pgAdmin yourself, manually. Which is a lot of work, and quite complex. > > [image: image.png] > > On Tue, Jul 13, 2021 at 7:02 PM Dave Page wrote: > >> >> >> On Tue, Jul 13, 2021 at 2:13 PM Prasanth M Sasidharan < >> prasha...@gmail.com> wrote: >> >>> >>> Hello Team, >>> >>> I am trying to install pgadmin4 from rpm since my machine doesn't >>> have internet access to connect to the repo. >>> >>> I have manually installed python3 and have set python3 as the >>> default python. >>> >>> [image: image.png] >>> When I try to install the pgadmin server rpm, it throws the >>> following error. Any help would be much appreciated: >>> >>> [hadoop@v11 pgadmin]$ *rpm -ivv pgadmin4-server-5.1-1.el7.x86_64.rp* >>> m >>> >> >> If you're installing that RPM (which I'll note is an old version - >> you should use v5.4), you're presumably using CentOS/RHEL 7.x. On that >> platform, the python3 package is v3.6.8, not v3.9.6 which begs the >> question; how did you install Python 3? If you did not do so using the >> vendor supplied packages, then installing pgAdmin won't work, and it most >> likely won't work even if you forced the installation. >> >> -- >> Dave Page >> Blog: https://pgsnake.blogspot.com >> Twitter: @pgsnake >> >> EDB: https://www.enterprisedb.com >> >> > > -- > Live every day as if it were your last, because one of these days, it > will be. > > Regards, > > Prasanth M Sasidharan > -- Dave Page Blog: https://pgsnake.blogspot.com Twitter: @pgsnake EDB: https://www.enterprisedb.com >>> >>> -- >>> Live every day as if it were your last, because one of these days, it >>> will be. >>> >>> Regards, >>> >>> Prasanth M Sasidharan >>> >> >> >> -- >> Dave Page >> Blog: https://pgsnake.blogspot.com >> Twitter: @pgsnake >> >> EDB: https://www.enterprisedb.com >> >> > > -- > Live every day as if it were your last, because one of these days, it will > be. > > Regards, > > Prasanth M Sasidharan > -- Dave Page Blog: https://pgsnake.blogspot.com Twitter: @pgsnake EDB: https://www.enterprisedb.com
Re: Help on installing pgadmin4 from rpm
That worked. Thanks Dave for the help and the guidance.Appreciate it. On Wed, Jul 14, 2021 at 1:34 PM Dave Page wrote: > Hi > > On Wed, Jul 14, 2021 at 8:13 AM Prasanth M Sasidharan > wrote: > >> Hello Dave, >> >> That actually worked . I did the rpm installation of python & pgadmin and >> I was able to install it successfully. >> >> However, I am unable to login to the pgadmin4 page due to incorrect >> username and password. I am using the same email address and password given >> while running the /usr/pgadmin4/bin/setup-web.sh. >> >> Is there any additional configuration needed? >> > > My guess is you've run into an issue caused by increased validation in the > flask-security-too module, the workaround for which is described at > https://redmine.postgresql.org/issues/6550#note-27 (it'll be fixed in the > upcoming v5.5 release). Essentially, because your machine is isolated from > the internet, your email address is probably failing the deliverability > check that the python module now does by default. > > Essentially, you need to add: > > SECURITY_EMAIL_VALIDATOR_ARGS={"check_deliverability": False} > > to your config_local.py or config_system.py file. See > https://www.pgadmin.org/docs/pgadmin4/5.4/config_py.html for more info on > those files. > > >> >> >> On Tue, Jul 13, 2021 at 7:31 PM Dave Page wrote: >> >>> Hi >>> >>> On Tue, Jul 13, 2021 at 2:56 PM Prasanth M Sasidharan < >>> prasha...@gmail.com> wrote: >>> Hi Dave, Appreciate the reply. I downloaded the python package from https://www.python.org/ftp/python/3.6.8/Python-3.6.8.tgz and compiled it. However, it's still throwing the same error . Would appreciate if you could point me to the right direction >>> >>> Sure. Install the Python 3 package from CentOS/Redhat (as appropriate >>> for whatever your OS is). The pgAdmin RPM is complaining because you don't >>> have the python3 RPM installed. >>> >>> Using a from-source installation of Python isn't supported by the RPMs. >>> If you really want to use a from-source installation, you'll have to build >>> pgAdmin yourself, manually. Which is a lot of work, and quite complex. >>> >>> [image: image.png] On Tue, Jul 13, 2021 at 7:02 PM Dave Page wrote: > > > On Tue, Jul 13, 2021 at 2:13 PM Prasanth M Sasidharan < > prasha...@gmail.com> wrote: > >> >> Hello Team, >> >> I am trying to install pgadmin4 from rpm since my machine doesn't >> have internet access to connect to the repo. >> >> I have manually installed python3 and have set python3 as the >> default python. >> >> [image: image.png] >> When I try to install the pgadmin server rpm, it throws the following >> error. Any help would be much appreciated: >> >> [hadoop@v11 pgadmin]$ *rpm -ivv pgadmin4-server-5.1-1.el7.x86_64.rp*m >> > > If you're installing that RPM (which I'll note is an old version - you > should use v5.4), you're presumably using CentOS/RHEL 7.x. On that > platform, the python3 package is v3.6.8, not v3.9.6 which begs the > question; how did you install Python 3? If you did not do so using the > vendor supplied packages, then installing pgAdmin won't work, and it most > likely won't work even if you forced the installation. > > -- > Dave Page > Blog: https://pgsnake.blogspot.com > Twitter: @pgsnake > > EDB: https://www.enterprisedb.com > > -- Live every day as if it were your last, because one of these days, it will be. Regards, Prasanth M Sasidharan >>> >>> >>> -- >>> Dave Page >>> Blog: https://pgsnake.blogspot.com >>> Twitter: @pgsnake >>> >>> EDB: https://www.enterprisedb.com >>> >>> >> >> -- >> Live every day as if it were your last, because one of these days, it >> will be. >> >> Regards, >> >> Prasanth M Sasidharan >> > > > -- > Dave Page > Blog: https://pgsnake.blogspot.com > Twitter: @pgsnake > > EDB: https://www.enterprisedb.com > > -- Live every day as if it were your last, because one of these days, it will be. Regards, Prasanth M Sasidharan
Re: Help on installing pgadmin4 from rpm
Hi On Wed, Jul 14, 2021 at 8:13 AM Prasanth M Sasidharan wrote: > Hello Dave, > > That actually worked . I did the rpm installation of python & pgadmin and > I was able to install it successfully. > > However, I am unable to login to the pgadmin4 page due to incorrect > username and password. I am using the same email address and password given > while running the /usr/pgadmin4/bin/setup-web.sh. > > Is there any additional configuration needed? > My guess is you've run into an issue caused by increased validation in the flask-security-too module, the workaround for which is described at https://redmine.postgresql.org/issues/6550#note-27 (it'll be fixed in the upcoming v5.5 release). Essentially, because your machine is isolated from the internet, your email address is probably failing the deliverability check that the python module now does by default. Essentially, you need to add: SECURITY_EMAIL_VALIDATOR_ARGS={"check_deliverability": False} to your config_local.py or config_system.py file. See https://www.pgadmin.org/docs/pgadmin4/5.4/config_py.html for more info on those files. > > > On Tue, Jul 13, 2021 at 7:31 PM Dave Page wrote: > >> Hi >> >> On Tue, Jul 13, 2021 at 2:56 PM Prasanth M Sasidharan < >> prasha...@gmail.com> wrote: >> >>> Hi Dave, >>> >>> Appreciate the reply. I downloaded the python package from >>> https://www.python.org/ftp/python/3.6.8/Python-3.6.8.tgz and compiled >>> it. >>> >>> However, it's still throwing the same error . Would appreciate if you >>> could point me to the right direction >>> >> >> Sure. Install the Python 3 package from CentOS/Redhat (as appropriate for >> whatever your OS is). The pgAdmin RPM is complaining because you don't have >> the python3 RPM installed. >> >> Using a from-source installation of Python isn't supported by the RPMs. >> If you really want to use a from-source installation, you'll have to build >> pgAdmin yourself, manually. Which is a lot of work, and quite complex. >> >> >>> >>> [image: image.png] >>> >>> On Tue, Jul 13, 2021 at 7:02 PM Dave Page wrote: >>> On Tue, Jul 13, 2021 at 2:13 PM Prasanth M Sasidharan < prasha...@gmail.com> wrote: > > Hello Team, > > I am trying to install pgadmin4 from rpm since my machine doesn't > have internet access to connect to the repo. > > I have manually installed python3 and have set python3 as the > default python. > > [image: image.png] > When I try to install the pgadmin server rpm, it throws the following > error. Any help would be much appreciated: > > [hadoop@v11 pgadmin]$ *rpm -ivv pgadmin4-server-5.1-1.el7.x86_64.rp*m > If you're installing that RPM (which I'll note is an old version - you should use v5.4), you're presumably using CentOS/RHEL 7.x. On that platform, the python3 package is v3.6.8, not v3.9.6 which begs the question; how did you install Python 3? If you did not do so using the vendor supplied packages, then installing pgAdmin won't work, and it most likely won't work even if you forced the installation. -- Dave Page Blog: https://pgsnake.blogspot.com Twitter: @pgsnake EDB: https://www.enterprisedb.com >>> >>> -- >>> Live every day as if it were your last, because one of these days, it >>> will be. >>> >>> Regards, >>> >>> Prasanth M Sasidharan >>> >> >> >> -- >> Dave Page >> Blog: https://pgsnake.blogspot.com >> Twitter: @pgsnake >> >> EDB: https://www.enterprisedb.com >> >> > > -- > Live every day as if it were your last, because one of these days, it will > be. > > Regards, > > Prasanth M Sasidharan > -- Dave Page Blog: https://pgsnake.blogspot.com Twitter: @pgsnake EDB: https://www.enterprisedb.com
Re: Help on installing pgadmin4 from rpm
Hello Dave, That actually worked . I did the rpm installation of python & pgadmin and I was able to install it successfully. However, I am unable to login to the pgadmin4 page due to incorrect username and password. I am using the same email address and password given while running the /usr/pgadmin4/bin/setup-web.sh. Is there any additional configuration needed? On Tue, Jul 13, 2021 at 7:31 PM Dave Page wrote: > Hi > > On Tue, Jul 13, 2021 at 2:56 PM Prasanth M Sasidharan > wrote: > >> Hi Dave, >> >> Appreciate the reply. I downloaded the python package from >> https://www.python.org/ftp/python/3.6.8/Python-3.6.8.tgz and compiled it. >> >> However, it's still throwing the same error . Would appreciate if you >> could point me to the right direction >> > > Sure. Install the Python 3 package from CentOS/Redhat (as appropriate for > whatever your OS is). The pgAdmin RPM is complaining because you don't have > the python3 RPM installed. > > Using a from-source installation of Python isn't supported by the RPMs. If > you really want to use a from-source installation, you'll have to build > pgAdmin yourself, manually. Which is a lot of work, and quite complex. > > >> >> [image: image.png] >> >> On Tue, Jul 13, 2021 at 7:02 PM Dave Page wrote: >> >>> >>> >>> On Tue, Jul 13, 2021 at 2:13 PM Prasanth M Sasidharan < >>> prasha...@gmail.com> wrote: >>> Hello Team, I am trying to install pgadmin4 from rpm since my machine doesn't have internet access to connect to the repo. I have manually installed python3 and have set python3 as the default python. [image: image.png] When I try to install the pgadmin server rpm, it throws the following error. Any help would be much appreciated: [hadoop@v11 pgadmin]$ *rpm -ivv pgadmin4-server-5.1-1.el7.x86_64.rp*m >>> >>> If you're installing that RPM (which I'll note is an old version - you >>> should use v5.4), you're presumably using CentOS/RHEL 7.x. On that >>> platform, the python3 package is v3.6.8, not v3.9.6 which begs the >>> question; how did you install Python 3? If you did not do so using the >>> vendor supplied packages, then installing pgAdmin won't work, and it most >>> likely won't work even if you forced the installation. >>> >>> -- >>> Dave Page >>> Blog: https://pgsnake.blogspot.com >>> Twitter: @pgsnake >>> >>> EDB: https://www.enterprisedb.com >>> >>> >> >> -- >> Live every day as if it were your last, because one of these days, it >> will be. >> >> Regards, >> >> Prasanth M Sasidharan >> > > > -- > Dave Page > Blog: https://pgsnake.blogspot.com > Twitter: @pgsnake > > EDB: https://www.enterprisedb.com > > -- Live every day as if it were your last, because one of these days, it will be. Regards, Prasanth M Sasidharan
Re: Help on installing pgadmin4 from rpm
Hi On Tue, Jul 13, 2021 at 2:56 PM Prasanth M Sasidharan wrote: > Hi Dave, > > Appreciate the reply. I downloaded the python package from > https://www.python.org/ftp/python/3.6.8/Python-3.6.8.tgz and compiled it. > > However, it's still throwing the same error . Would appreciate if you > could point me to the right direction > Sure. Install the Python 3 package from CentOS/Redhat (as appropriate for whatever your OS is). The pgAdmin RPM is complaining because you don't have the python3 RPM installed. Using a from-source installation of Python isn't supported by the RPMs. If you really want to use a from-source installation, you'll have to build pgAdmin yourself, manually. Which is a lot of work, and quite complex. > > [image: image.png] > > On Tue, Jul 13, 2021 at 7:02 PM Dave Page wrote: > >> >> >> On Tue, Jul 13, 2021 at 2:13 PM Prasanth M Sasidharan < >> prasha...@gmail.com> wrote: >> >>> >>> Hello Team, >>> >>> I am trying to install pgadmin4 from rpm since my machine doesn't have >>> internet access to connect to the repo. >>> >>> I have manually installed python3 and have set python3 as the >>> default python. >>> >>> [image: image.png] >>> When I try to install the pgadmin server rpm, it throws the following >>> error. Any help would be much appreciated: >>> >>> [hadoop@v11 pgadmin]$ *rpm -ivv pgadmin4-server-5.1-1.el7.x86_64.rp*m >>> >> >> If you're installing that RPM (which I'll note is an old version - you >> should use v5.4), you're presumably using CentOS/RHEL 7.x. On that >> platform, the python3 package is v3.6.8, not v3.9.6 which begs the >> question; how did you install Python 3? If you did not do so using the >> vendor supplied packages, then installing pgAdmin won't work, and it most >> likely won't work even if you forced the installation. >> >> -- >> Dave Page >> Blog: https://pgsnake.blogspot.com >> Twitter: @pgsnake >> >> EDB: https://www.enterprisedb.com >> >> > > -- > Live every day as if it were your last, because one of these days, it will > be. > > Regards, > > Prasanth M Sasidharan > -- Dave Page Blog: https://pgsnake.blogspot.com Twitter: @pgsnake EDB: https://www.enterprisedb.com
Re: Help on installing pgadmin4 from rpm
Hi Dave, Appreciate the reply. I downloaded the python package from https://www.python.org/ftp/python/3.6.8/Python-3.6.8.tgz and compiled it. However, it's still throwing the same error . Would appreciate if you could point me to the right direction [image: image.png] On Tue, Jul 13, 2021 at 7:02 PM Dave Page wrote: > > > On Tue, Jul 13, 2021 at 2:13 PM Prasanth M Sasidharan > wrote: > >> >> Hello Team, >> >> I am trying to install pgadmin4 from rpm since my machine doesn't have >> internet access to connect to the repo. >> >> I have manually installed python3 and have set python3 as the >> default python. >> >> [image: image.png] >> When I try to install the pgadmin server rpm, it throws the following >> error. Any help would be much appreciated: >> >> [hadoop@v11 pgadmin]$ *rpm -ivv pgadmin4-server-5.1-1.el7.x86_64.rp*m >> > > If you're installing that RPM (which I'll note is an old version - you > should use v5.4), you're presumably using CentOS/RHEL 7.x. On that > platform, the python3 package is v3.6.8, not v3.9.6 which begs the > question; how did you install Python 3? If you did not do so using the > vendor supplied packages, then installing pgAdmin won't work, and it most > likely won't work even if you forced the installation. > > -- > Dave Page > Blog: https://pgsnake.blogspot.com > Twitter: @pgsnake > > EDB: https://www.enterprisedb.com > > -- Live every day as if it were your last, because one of these days, it will be. Regards, Prasanth M Sasidharan
Re: Help on installing pgadmin4 from rpm
On Tue, Jul 13, 2021 at 2:13 PM Prasanth M Sasidharan wrote: > > Hello Team, > > I am trying to install pgadmin4 from rpm since my machine doesn't have > internet access to connect to the repo. > > I have manually installed python3 and have set python3 as the > default python. > > [image: image.png] > When I try to install the pgadmin server rpm, it throws the following > error. Any help would be much appreciated: > > [hadoop@v11 pgadmin]$ *rpm -ivv pgadmin4-server-5.1-1.el7.x86_64.rp*m > If you're installing that RPM (which I'll note is an old version - you should use v5.4), you're presumably using CentOS/RHEL 7.x. On that platform, the python3 package is v3.6.8, not v3.9.6 which begs the question; how did you install Python 3? If you did not do so using the vendor supplied packages, then installing pgAdmin won't work, and it most likely won't work even if you forced the installation. -- Dave Page Blog: https://pgsnake.blogspot.com Twitter: @pgsnake EDB: https://www.enterprisedb.com