trovato pg_hba.conf si trova in /var/lib/pgsql/data/pg_hba.conf, a questo punto con gedit modifico pg_hba.conf # PostgreSQL Client Authentication Configuration File<br># ===================================================<br>
#<br># Refer to the "Client Authentication" section in the<br># PostgreSQL documentation for a complete description<br># of this file. A short synopsis follows.<br>#<br># This file controls: which hosts are allowed to connect, how clients
<br># are authenticated, which PostgreSQL user names they can use, which<br># databases they can access. Records take one of these forms:<br>#<br># local DATABASE USER METHOD [OPTION]<br> <span style="background-color: rgb(255, 255, 102);">
host promogest_db promoadmin <a href="http://127.0.0.1">127.0.0.1</a> <a href="http://255.255.255.0">255.255.255.0</a> trust</span><br style="background-color: rgb(255, 255, 102);"><br># host DATABASE USER CIDR-ADDRESS METHOD [OPTION]
<br># hostssl DATABASE USER CIDR-ADDRESS METHOD [OPTION]<br># hostnossl DATABASE USER CIDR-ADDRESS METHOD [OPTION]<br>#<br># (The uppercase items must be replaced by actual values.)<br>#<br># The first field is the connection type: "local" is a Unix-domain socket,
<br># "host" is either a plain or SSL-encrypted TCP/IP socket, "hostssl" is an<br># SSL-encrypted TCP/IP socket, and "hostnossl" is a plain TCP/IP socket.<br>#<br># DATABASE can be "all", "sameuser", "samerole", a database name, or
<br># a comma-separated list thereof.<br>#<br># USER can be "all", a user name, a group name prefixed with "+", or<br># a comma-separated list thereof. In both the DATABASE and USER fields<br># you can also write a file name prefixed with "@" to include names from
<br># a separate file.<br>#<br># CIDR-ADDRESS specifies the set of hosts the record matches.<br># It is made up of an IP address and a CIDR mask that is an integer<br># (between 0 and 32 (IPv4) or 128 (IPv6) inclusive) that specifies
<br># the number of significant bits in the mask. Alternatively, you can write<br># an IP address and netmask in separate columns to specify the set of hosts.<br>#<br># METHOD can be "trust", "reject", "md5", "crypt", "password",
<br># "krb5", "ident", "pam" or "ldap". Note that "password" sends passwords<br># in clear text; "md5" is preferred since it sends encrypted passwords.<br>#<br>
# OPTION is the ident map or the name of the PAM service, depending on METHOD.<br>#<br># Database and user names containing spaces, commas, quotes and other special<br># characters must be quoted. Quoting one of the keywords "all", "sameuser" or
<br># "samerole" makes the name lose its special character, and just match a<br># database or username with that name.<br>#<br># This file is read on server startup and when the postmaster receives<br># a SIGHUP signal. If you edit the file on a running system, you have
<br># to SIGHUP the postmaster for the changes to take effect. You can use<br># "pg_ctl reload" to do that.<br><br># Put your actual configuration here<br># ----------------------------------<br>#<br># If you want to allow non-local connections, you need to add more
<br># "host" records. In that case you will also need to make PostgreSQL listen<br># on a non-local interface via the listen_addresses configuration parameter,<br># or via the -i or -h command line switches.<br>
#<br><br><br><br># TYPE DATABASE USER CIDR-ADDRESS METHOD<br><br># "local" is for Unix domain socket connections only<br>local all all ident sameuser<br>
# IPv4 local connections:<br>host all all <a href="http://127.0.0.1/32">127.0.0.1/32</a> ident sameuser<br># IPv6 local connections:<br>host all all ::1/128 ident sameuser
<br>questo รจ il contenuto di pg_hba.conf <br>lancio ./install_db.sh <br>psql: FATAL: Ident authentication failed for user "postgres"<br>psql: FATAL: Ident authentication failed for user "promoadmin"<br>
createlang: impossibile connettersi al database promogest_nightly: FATAL: Ident authentication failed for user "postgres"<br>psql: FATAL: Ident authentication failed for user "promoadmin"<br>psql: FATAL: Ident authentication failed for user "promoadmin"
<br>psql: FATAL: Ident authentication failed for user "promoadmin"<br>psql: FATAL: Ident authentication failed for user "promoadmin"<br>psql: FATAL: Ident authentication failed for user "promoadmin"
<br>psql: FATAL: Ident authentication failed for user "promoadmin"<br>psql: FATAL: Ident authentication failed for user "promoadmin"<br>psql: FATAL: Ident authentication failed for user "promoadmin"
<br>psql: FATAL: Ident authentication failed for user "promoadmin"<br>psql: FATAL: Ident authentication failed for user "promoadmin"<br>psql: FATAL: Ident authentication failed for user "promoadmin"
<br>psql: FATAL: Ident authentication failed for user "promoadmin"<br>psql: FATAL: Ident authentication failed for user "promoadmin"<br><br><br><br><div><span class="gmail_quote">Il 09/10/07, <b class="gmail_sendername">
Francesco Steno</b> <<a href="mailto:overdrive@linux.it">overdrive@linux.it</a>> ha scritto:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>Il giorno 08/ott/07, alle ore 21:50, angelo morrone ha scritto:<br><br>> non ne vuole propio sapere di funzionare porc..................<br>> conil comando psql -l mi da:<br>> psql -l<br>> Lista dei database
<br>> Nome | Proprietario | Codifica<br>> -----------+--------------+----------<br>> postgres | postgres | UTF8<br>> template0 | postgres | UTF8<br>> template1 | postgres | UTF8<br>> (3 rows)
<br>><br>> il file che ho modifica sulla mia linux box suse si trova /usr/<br>> share/postgresql/pg_hba.conf.sample spero che intendevi questo.<br><br># find / -name "pg_hba.conf"<br>(incolla i'output)
<br><br>dopo la modifica, se lanci install_db.sh, cosa ti tira fuori ?<br><br><br><br><br>Saluti<br> Francesco Steno aka "oVERDRIVE"<br><br>--<br>Chuck Norris un giorno ha creato un lanciafiamme urinando in un
<br>accendino.<br><br>-=-=-=-=-=-=-=-=-=-=-=-=-=-generated by /dev/over-=-=-=-=-=-=-=-=-=-=<br> oVERDRIVE<br><<a href="mailto:overdrive@OpenGeeks.it">overdrive@OpenGeeks.it</a>><<a href="mailto:overdrive@BitchX.it">
overdrive@BitchX.it</a>><<a href="mailto:overdrive@Linux.it">overdrive@Linux.it</a>><br> GnuPG Public Key: <a href="http://cb.linux.it/lug/key/overdrive.asc">http://cb.linux.it/lug/key/overdrive.asc</a>
<br> Key Fingerprint: 146A E13D 9E68 3B96 40FB 11F5 9A10 2D1F 3973 C203<br><br><br><br><br><br>--<br>Mailing list info: <a href="http://lists.linux.it/listinfo/lugcb">http://lists.linux.it/listinfo/lugcb</a><br><br><br>
</blockquote></div><br>