# Unable to login to Postgresql 10.17 on CentOS 8 from a Perl App **URL:** \ **Category:** Virtualmin\ **Created:** [November 15, 2021, 6:07pm UTC](https://forum.virtualmin.com/t/unable-to-login-to-postgresql-10-17-on-centos-8-from-a-perl-app/112950 "2021-11-15T18:07:33Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![bislinks](https://cdn.forum.virtualmin.com/letter_avatar_proxy/v4/letter/b/b2d939/32.png) [@bislinks](https://forum.virtualmin.com/u/bislinks)\ **Post date:** [November 15, 2021, 6:07pm UTC](https://forum.virtualmin.com/t/unable-to-login-to-postgresql-10-17-on-centos-8-from-a-perl-app/112950/1 "2021-11-15T18:07:33Z")
I am unable to login/use postgresql 10.17 in a Mojolicious App in CentOS 8 VPS on [Linode.com](http://Linode.com) I am able to login to postgresql as upmanager with `psql` on cmdline. This very same app works perfectly fine on a raspberry pi on home public IP behind NAT i!! App setup details: Mojo App : [http://userpassmanager:33333](http://userpassmanager:33333) with proxy to URL [https://u.userpassmanager.com](https://u.userpassmanager.com) ([http://127.0.0.1:33333/](http://127.0.0.1:33333/)) Perl: 5.026003 Mojolicious: 9\>22 Apache: 2.4.37 What am i missing?? | SYSTEM INFORMATION | | | --- | --- | | | | | **OS type and version:** | CentOS 8.4.2105 | | **Webmin version:** | REQUIRED | | **Virtualmin version:** | REQUIRED | | **Related products version:** | RECOMMENDED | * * * ---
**Author:** ![Joe](https://cdn.forum.virtualmin.com/user_avatar/forum.virtualmin.com/joe/32/9_2.png) [@Joe](https://forum.virtualmin.com/u/Joe)\ **Post date:** [November 15, 2021, 8:22pm UTC](https://forum.virtualmin.com/t/unable-to-login-to-postgresql-10-17-on-centos-8-from-a-perl-app/112950/2 "2021-11-15T20:22:26Z")
We need to see the actual error. I’m guessing maybe there’s a difference of opinion about the hostname of the user logging in, maybe? I don’t really know much about how users and permissions and authentication work in PostgreSQL. ---
**Author:** ![bislinks](https://cdn.forum.virtualmin.com/letter_avatar_proxy/v4/letter/b/b2d939/32.png) [@bislinks](https://forum.virtualmin.com/u/bislinks)\ **Post date:** [November 15, 2021, 11:14pm UTC](https://forum.virtualmin.com/t/unable-to-login-to-postgresql-10-17-on-centos-8-from-a-perl-app/112950/3 "2021-11-15T23:14:55Z")
I am not seeing any error at all. The login screen (from my app) does appear but when i used user/pass from postgresql db, it does nothing. Here is the link for the same app on a raspberry pi behind NAT that works just fine: [https://up.userpassmanager.com](https://up.userpassmanager.com) This mojo app can be accessed in multiple ways: [http://userpassmanager.com:33333](http://userpassmanager.com:33333) or [https://u.userpassmanager.com](https://u.userpassmanager.com) or [https://userpassmanager.com:33334](https://userpassmanager.com:33334). I hope that clears the hostname confusion. ([u.userpassmanager.com](http://u.userpassmanager.com) is just proxy to [userpassmanager.com:33333](http://userpassmanager.com:33333)) I am also able to login to virtualmin as upmanager and edit/manage postgresql database upmanager; But not in my Mojolicious app. I think it has much to do with user/database/table/host permissions with PostgreSQL which you also alluded to. I hope someone with deeper PostgreSQL knowledge would help me with it. I am asking it here because I am trying it on Centos8 with Virtualmin ( same source code works just fine in the Raspberry Pi). ---
**Author:** ![bislinks](https://cdn.forum.virtualmin.com/letter_avatar_proxy/v4/letter/b/b2d939/32.png) [@bislinks](https://forum.virtualmin.com/u/bislinks)\ **Post date:** [November 20, 2021, 1:52am UTC](https://forum.virtualmin.com/t/unable-to-login-to-postgresql-10-17-on-centos-8-from-a-perl-app/112950/4 "2021-11-20T01:52:00Z")
Never mind. Nothing wrong with any configs. With all the servers/services running on the VPS, 8 GB RAM is not sufficient to run the PostgreSQL server I think!!! ---
**Author:** ![system](https://cdn.forum.virtualmin.com/uploads/default/original/2X/c/cd96d761e326db4b2bef94886a639109bd7a8e76.svg) [@system](https://forum.virtualmin.com/u/system)\ **Post date:** [January 19, 2022, 1:52am UTC](https://forum.virtualmin.com/t/unable-to-login-to-postgresql-10-17-on-centos-8-from-a-perl-app/112950/5 "2022-01-19T01:52:49Z")
Closed on January 19, 2022, 1:52am UTC This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.