FAQ Search Today's Posts Mark Forums Read
» Video Reviews

» Linux Archive

Linux-archive is a website aiming to archive linux email lists and to make them easily accessible for linux users/developers.


» Sponsor

» Partners

» Sponsor

Go Back   Linux Archive > Redhat > Fedora User

 
 
LinkBack Thread Tools
 
Old 11-09-2011, 05:14 AM
Leonardo
 
Default more postgresql problems

hello everyone,

i'm still having issues with fedora 16 postgresql.

now i am unable to connect with some customized user.

i've followed the steps from this page:

http://www.sakana.fr/blog/2007/06/06/postgresql-create-a-user-a-database-and-grant-accesses/

and it worked on fedora 15, debian, mac, and i am going to test on
fedora 14, but for sure there is something new in the field.

again, any help is welcome
--
users mailing list
users@lists.fedoraproject.org
To unsubscribe or change subscription options:
https://admin.fedoraproject.org/mailman/listinfo/users
Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines
 
Old 11-09-2011, 01:37 PM
Leonardo
 
Default more postgresql problems

Hello everyone,

i solved the problem, the pg_hba.conf file was different. this is the
working version, as found in debian, mac and the fedora 14 version
where modified by a tool and only by this reason it worked. basically
all i have on pg_hba.conf now is:

[root@gau ~]# cat /var/lib/pgsql/data/pg_hba.conf
local all all trust
host all all 127.0.0.1/32 md5
[root@gau ~]#

this works correctly on command line and java application can connect too.

however any suggestion about security is welcome.

2011/11/9 Leonardo <sombriks@gmail.com>:
> hello everyone,
>
> i'm still having issues with fedora 16 postgresql.
>
> now i am unable to connect with some customized user.
>
> i've followed the steps from this page:
>
> http://www.sakana.fr/blog/2007/06/06/postgresql-create-a-user-a-database-and-grant-accesses/
>
> and it worked on fedora 15, debian, mac, and i am going to test on
> fedora 14, but for sure there is something new in the field.
>
> again, any help is welcome
>
--
users mailing list
users@lists.fedoraproject.org
To unsubscribe or change subscription options:
https://admin.fedoraproject.org/mailman/listinfo/users
Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines
 
Old 11-09-2011, 01:43 PM
Itamar Reis Peixoto
 
Default more postgresql problems

On Wed, Nov 9, 2011 at 12:37 PM, Leonardo <sombriks@gmail.com> wrote:
> Hello everyone,
>
> i solved the problem, the pg_hba.conf file was different. this is the
> working version, as found in debian, mac and the fedora 14 version
> where modified by a tool and only by this reason it worked. basically
> all i have on pg_hba.conf now is:
>
> [root@gau ~]# cat /var/lib/pgsql/data/pg_hba.conf
> local all all trust
> host all all 127.0.0.1/32 md5
> [root@gau ~]#

create roles and change to md5


------------

Itamar Reis Peixoto
msn, google talk: itamar@ispbrasil.com.br
+55 11 4063 5033 (FIXO SP)
+55 34 9158 9329 (TIM)
+55 34 8806 3989 (OI)
+55 34 3221 8599 (FIXO MG)
--
users mailing list
users@lists.fedoraproject.org
To unsubscribe or change subscription options:
https://admin.fedoraproject.org/mailman/listinfo/users
Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines
 

Thread Tools




All times are GMT. The time now is 09:34 PM.

VBulletin, Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO ©2007, Crawlability, Inc.
Copyright 2007 - 2008, www.linux-archive.org