search for: pg_hba

Me again! I have a recipe that looks like: class postgresql { file { pg_hba_conf: name => "/var/lib/pgsql/data/pg_hba.conf", source => "puppet://puppetmaster/files/workstations/common/var/lib/pgsql/data/pg_hba.conf", owner => postgres, group => postgres, mode => 600, subscribe => [ Packag...

Hello list, I am running Dovecot 1.0-test46 on FreeBSD with PostgreSQL as backend, runs _very_ nice, but i can not set "default_pass_scheme = CRYPT" (only PLAIN) for PostgreSQL Auth in dovecot-pgsql.conf. I have a valid entry in pg_hba.conf (and reloaded/restarted): "local mail mail crypt" If i replace crypt in pg_hba.conf with md5 it works also with plain in dovecot-pgsql.conf? -- Christian. PS: sorry for my poore english.

...s::bundled{ require => Postgres_execute_command[ovirt_db_create_role] } - exec {"postgres_add_all_trust": + single_exec {"postgres_add_all_trust": command => "/bin/echo 'local all all trust' > /var/lib/pgsql/data/pg_hba.conf", require => Single_exec[initialize_db], notify => Service[postgresql] @@ -75,13 +75,13 @@ class postgres::bundled{ exec {"postgres_add_localhost_trust": command => "/bin/echo 'host all all 127.0.0.1 255.255.255.0 trust' >> /var/lib/pgsql...

hello everybody i?m trying to connect to my postgresql via tcpip and it thow an error is not accepting tcp-ip connections I ask to google but i dont find the solution, people said about the prostgresql.conf enable tcpip, I try but when i start the service it thow an error. Other thing is add the option i to postmaster.opt but when i start the service this file is redefined anybody can helpme

...locale => ''en_NG'', } There is a new class for installing the necessary packages to provide the PostgreSQL JDBC client jars: class { ''postgresql::java'': } And we have a brand new defined resource for managing fine-grained rule sets within your pg_hba.conf access lists: postgresql::pg_hba { ''Open up postgresql for access from 200.1.2.0/24'': type => ''host'', database => ''app'', user => ''app'', address => ''200.1.2.0/24'',...

If the ::1 ipv6 loopback entry is missing in pg_hba.conf rake db:migrate will fail rake aborted! FATAL: no pg_hba.conf entry for host "::1", user "ovirt", database "ovirt_development", SSL off --- installer/modules/ovirt/manifests/postgres.pp | 8 +++++++- 1 files changed, 7 insertions(+), 1 deletions(-) diff --...

You need to change in /var/lib/pgsql/data/pg_hba.conf "ident" to "md5" When you create user password is encrypted, but PostgreSQL server is configured to read password not encrypted. Regards. -- _________________________________________________________________ D o m i n i k S k ? a d a n o w s k i

OS - CentOS4 PostgreSQL = 8.0.3 I think that I need to locate a custom pam module to use in pg_hba.conf that will allow phpPgAdmin to authenticate users against /etc/password (shadow). I cannot seem to find a straight forward reference to such a beast either in the documentation or on the web. The pam modules that I have found through google seem to be intended to allow one to authenticate...

...true } @@ -79,6 +79,12 @@ class postgres::bundled{ notify => Service[postgresql] } + exec {"postgres_add_ipv6_loopback_trust": + command => "/bin/echo 'host all all ::1/128 trust' >> /var/lib/pgsql/data/pg_hba.conf", + require => Exec[postgres_add_all_trust], + notify => Service[postgresql] + } + file { "/etc/ovirt-server/" : ensure => directory, require => Exec[postgres_add_localhost_trust] -- 1.6.2.5

Hi Firstly apologies but i have to install an app that uses postgres but i am more a MySQL/Oracle guy so i maybe doing something really wrong here.. I am following instructions for creating a DB user and encountering this # createuser -ADP -U postgres foo Enter password for new user: Enter it again: createuser: could not connect to database template1: FATAL: IDENT authentication failed for

Hi guys, Pls I need good and working instructions on how to install phpmyadmin on centos 6.3 ? I would appreciate your kind and timely response on this. regards kunle

Hi, I have been using myisam tables in mysql with rails because my client will soon want fulltext searchable content, however when I migrated my development db from schema.rb all of the tables generated were innodb. I understand that I can override this, but also like the transactions and foreign keys of innodb. So 2 questions really: 1. are transactions in activerecord dependent on innodb or do

..., Single_exec[wait_for_postgres]] } postgres_execute_command {"ovirt_db_create_role": @@ -70,13 +75,13 @@ class postgres::bundled{ exec {"postgres_add_all_trust": command => "/bin/echo 'local all all trust' > /var/lib/pgsql/data/pg_hba.conf", require => Single_exec[initialize_db], - notify => Service[postgresql] + notify => Single_exec[wait_for_postgres] } exec {"postgres_add_localhost_trust": command => "/bin/echo 'host all all 127.0.0.1 255.255.255.0 trust' >> /...

...nied root/locale_en_CA at yyyy-mmm-dd.tar.gz: Permission denied root/more_or_less_commands.txt: Permission denied root/named.conf.bind-9.8.2-default-2013-07-04: Permission denied root/named.conf.inet01-dns01-2013-07-04: Permission denied root/named.conf.inet03-dnm-2013-07-04: Permission denied root/pg_hba.conf: Permission denied root/pg_ident.conf: Permission denied root/pgadmin.log: Permission denied root/pgdg-91-centos.repo: Permission denied root/ping_host.sh: Permission denied root/ping_http.sh: Permission denied root/postgresql.conf: Permission denied root/root_voinet09.tgz: Permission denied r...

Hi folks. postgresql fresh install, roles, users, databases, all done. I can log in after I SSH to the box. I entered my user (myself) in pg_hba.conf: host all rich 192.168.1.4 255.255.255.255 md5 When I nmap the CentOS box, I can?t see that port open. I?ve turned off SELinux, so I?m not sure why I can?t see the open port 5432. What am I missing? It has to be something I?ve overlooked. - SELinux off - firewall poked hol...

...epaid Application) == Parsing '/etc/asterisk/prepaid.conf': Found Jun 22 14:38:43 ERROR[-1084964736]: app_prepaid.c:127 check_connected: app_prepaid: cannot connect to database server localhost. Calls will not be logged == Registered application 'Prepaid' Here is pgsql confs; pg_hba.conf: ------------ local all asterisk 127.0.0.1 255.255.255.0 trust local all prepaid 127.0.0.1 255.255.255.0 trust local all freerad 127.0.0.1 255.255.255.0 trust pg_indent.conf: --------------- # MAPNAME IDENT-USERNAME PG-USERNAME asterisk asterisk asterisk prepaid prepaid prep...

.... Using default. Dec 13 23:03:34 ERROR[2503]: PrepaidRatePlan: FATAL - Couldn't connect to database server 'localhost'. This is what I have in my config file: In prepaid.conf [global] hostname=localhost dbname=asterisk user=asterisk password=XXXXXX port=5432 ;sock=/tmp/pgsql.sock In pg_hba.conf local all asterisk trust In pg_ident.conf # MAPNAME IDENT-USERNAME PG-USERNAME asterisk asterisk asterisk

Folks, I know this must be a configuration problem. Just changed servers last nite -- an interim server running 1.6.1.6. Copied all of /etc/asterisk to the new server and fired it up. Now I'm getting: [Oct 14 12:28:10] ERROR[8471]: cdr_pgsql.c:309 pgsql_log: Failed to insert call detail record into database! [Oct 14 12:28:10] ERROR[8471]: cdr_pgsql.c:310 pgsql_log: Reason: ERROR: syntax

...er.bridge_ipfw_drop: 0 net.link.ether.bridge_ipfw_collisions: 0 The snort.conf is attached. I've attempted to start with a pretty generic config, just to ensure things work. The problem appears to be that snort simply doesn't log to the remote postgres box (yes, there are host entries in pg_hba.conf, and other databases are accessible remotely, so I believe that is not the issue). I've just been running trafshow to watch connections. Any hints/pointers/solutions welcome. Thanks -- Louis Kowolowski louisk@cryptomonkeys.org Crypto Monkeys:...

Hi Every one and Fabio Donaggio Fabio Donaggio you have faced same type of problem with postgresql with asterisk. Did you solved your problem. Please help me. The problem is as follows: When i reload the asterisk I had got this error "== Parsing '/etc/asterisk/cdr_pgsql.conf': Found Aug 23 14:22:33 ERROR[1076245120]: cdr_pgsql.c:299 my_load_module: cdr_pgsql: Unable to connect