Re: ruby pg connection fails on centos - okay on debian and dev machine

On 05/03/2016 06:18 PM, Adrian Klaver wrote:
> On 05/03/2016 05:07 PM, john.tiger wrote:
>> our model.rb runs fine on a dev machine and a debian server  but is
>> failing on a new centos server - checked the postgres db name and user
>> name and password - all seem fine
>
> The error message is?
>
>>
>> could it be:
>>
>> host => "localhost"
>>
>> or maybe CORS ?
>
> CORS as in:
>
> https://en.wikipedia.org/wiki/Cross-origin_resource_sharing
>
> or something else?
>
> Have you tried connecting using psql with same parameters?
>
> Have you looked at the pg_hba.conf files on the different platforms
> and see if they differ?

yeah, but we couldn't find any log file - not sure on centos where this
should be  - nothing in /var/log or /var/lib/pgsql/9.5/data

running psql dbname="ourdb" works
running psql dbname="ourdb" username="ouruser"  ==> FATAL peer
authentication failed for user"ouruser"

running \l  => shows db
    \du =>   ouruser {}  ? doesn't show login although we specified that
as when created role - could that be the problem ?? then how to add
login to user   alter role ouruser with login  => still shows {}

both pg_hba show:
local    all    all  peer
host     all    all  127.0.0.1
host     all   all ident


re cors - all on same linode server with postgres running on std port so
don't think should be an issue and is not issue on debian server - just
searching for possible answer

here is our model
@conn = PG.connect(
   :host => "localhost",
   :dbname => "ourdb",
   :user  => "ouruser",
   :password => "ourpassword"
)
again, this runs fine on debian and debian dev machine




>
>
>>
>>
>
>