Could not connect to postgresql

[Артём Большаков]

Hello.
I'm trying to run radiant on postgresql, but an error following appears;

/usr/lib/ruby/gems/1.8/gems/radiant-0.8.1/vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:968:in
`initialize': FATAL:  Ident authentication failed for user "radiant"
(PGError)

In postgre log:
2009-10-31 14:22:01 MSK FATAL:  Ident authentication failed for user "radiant"
2009-10-31 14:40:20 MSK FATAL:  Ident authentication failed for user "radiant"


I'm absolutely sure in my login and password, because another ruby apps uses
postgre and works perfect.

ruby 1.8.7 (2009-06-12 patchlevel 174) [i486-linux]
Radiant 0.8.1
Postgresql 8.3
$ uname -a
Debian Linux 2.6.26-2-686 #1 SMP Sat Oct 17 17:59:23 UTC 2009 i686 GNU/Linux

--
Regards
Artyom Bolshakov
_______________________________________________
Radiant mailing list
Post:   Radiant@...
Search: http://radiantcms.org/mailing-list/search/
Site:   http://lists.radiantcms.org/mailman/listinfo/radiant

[Jim Gay-2]

On Oct 31, 2009, at 7:41 AM, Артём Большаков wrote:

> Hello.
> I'm trying to run radiant on postgresql, but an error following  
> appears;
>
> /usr/lib/ruby/gems/1.8/gems/radiant-0.8.1/vendor/rails/activerecord/
> lib/active_record/connection_adapters/postgresql_adapter.rb:968:in
> `initialize': FATAL:  Ident authentication failed for user "radiant"
> (PGError)
>
> In postgre log:
> 2009-10-31 14:22:01 MSK FATAL:  Ident authentication failed for user  
> "radiant"
> 2009-10-31 14:40:20 MSK FATAL:  Ident authentication failed for user  
> "radiant"
>
>
> I'm absolutely sure in my login and password, because another ruby  
> apps uses
> postgre and works perfect.

Does your other ruby app use the same credentials?

>
> ruby 1.8.7 (2009-06-12 patchlevel 174) [i486-linux]
> Radiant 0.8.1
> Postgresql 8.3
> $ uname -a
> Debian Linux 2.6.26-2-686 #1 SMP Sat Oct 17 17:59:23 UTC 2009 i686  
> GNU/Linux

This might help http://www.depesz.com/index.php/2007/10/04/ident/


Jim Gay
http://www.saturnflyer.com




_______________________________________________
Radiant mailing list
Post:   Radiant@...
Search: http://radiantcms.org/mailing-list/search/
Site:   http://lists.radiantcms.org/mailman/listinfo/radiant

[Артём Большаков]

The problem was with access rights to my postgre.
I set 'host: localhost' field on database.yml and it works.
Thanks!

On Saturday 31 October 2009 20:51:08 Jim Gay wrote:

> On Oct 31, 2009, at 7:41 AM, Артём Большаков wrote:
> > Hello.
> > I'm trying to run radiant on postgresql, but an error following
> > appears;
> >
> > /usr/lib/ruby/gems/1.8/gems/radiant-0.8.1/vendor/rails/activerecord/
> > lib/active_record/connection_adapters/postgresql_adapter.rb:968:in
> > `initialize': FATAL:  Ident authentication failed for user "radiant"
> > (PGError)
> >
> > In postgre log:
> > 2009-10-31 14:22:01 MSK FATAL:  Ident authentication failed for user
> > "radiant"
> > 2009-10-31 14:40:20 MSK FATAL:  Ident authentication failed for user
> > "radiant"
> >
> >
> > I'm absolutely sure in my login and password, because another ruby
> > apps uses
> > postgre and works perfect.
>
> Does your other ruby app use the same credentials?
>
> > ruby 1.8.7 (2009-06-12 patchlevel 174) [i486-linux]
> > Radiant 0.8.1
> > Postgresql 8.3
> > $ uname -a
> > Debian Linux 2.6.26-2-686 #1 SMP Sat Oct 17 17:59:23 UTC 2009 i686
> > GNU/Linux
>
> This might help http://www.depesz.com/index.php/2007/10/04/ident/
>
>
> Jim Gay
> http://www.saturnflyer.com
>
>
>
>
> _______________________________________________
> Radiant mailing list
> Post:   Radiant@...
> Search: http://radiantcms.org/mailing-list/search/
> Site:   http://lists.radiantcms.org/mailman/listinfo/radiant

--
Artyom Bolshakov
_______________________________________________
Radiant mailing list
Post:   Radiant@...
Search: http://radiantcms.org/mailing-list/search/
Site:   http://lists.radiantcms.org/mailman/listinfo/radiant