Menu
▾
▴
Re: [SL] While installing on SME 7.rc2 I get FATAL: missing or erroneous pg_hba.conf file
|
From: davidc <da...@mo...> - 2006-05-01 23:54:16
|
try just host all all 192.168.0.0 255 255.255.255 trust local all all trust host all all 127.0.0.1 255.255.255.0 trust but may not be secure, !!!!, don't know! ATM Logic wrote: >While reinstalling (see other post) > >Everything seems to go fairly smooth till this... > >su - postgres -c "createuser -a -d sql-ledger" >createuser: could not connect to database template1: FATAL: missing or >erroneous pg_hba.conf file >HINT: See server log for details. > >This is my pg.hba.conf file below: > ># PostgreSQL Client Authentication Configuration File ># =================================================== ># ># Refer to the PostgreSQL Administrator's Guide, chapter "Client ># Authentication" for a complete description. A short synopsis ># follows. ># ># This file controls: which hosts are allowed to connect, how clients ># are authenticated, which PostgreSQL user names they can use, which ># databases they can access. Records take one of seven forms: ># ># local DATABASE USER METHOD [OPTION] ># host DATABASE USER IP-ADDRESS IP-MASK METHOD [OPTION] ># hostssl DATABASE USER IP-ADDRESS IP-MASK METHOD [OPTION] ># hostnossl DATABASE USER IP-ADDRESS IP-MASK METHOD [OPTION] ># host DATABASE USER IP-ADDRESS/CIDR-MASK METHOD [OPTION] ># hostssl DATABASE USER IP-ADDRESS/CIDR-MASK METHOD [OPTION] ># hostnossl DATABASE USER IP-ADDRESS/CIDR-MASK METHOD [OPTION] ># ># (The uppercase quantities should be replaced by actual values.) ># The first field is the connection type: "local" is a Unix-domain socket, ># "host" is either a plain or SSL-encrypted TCP/IP socket, "hostssl" is an ># SSL-encrypted TCP/IP socket, and "hostnossl" is a plain TCP/IP socket. ># DATABASE can be "all", "sameuser", "samegroup", a database name (or ># a comma-separated list thereof), or a file name prefixed with "@". ># USER can be "all", an actual user name or a group name prefixed with ># "+" or a list containing either. IP-ADDRESS and IP-MASK specify the ># set of hosts the record matches. CIDR-MASK is an integer between 0 ># and 32 (IPv6) or 128(IPv6) inclusive, that specifies the number of ># significant bits in the mask, so an IPv4 CIDR-MASK of 8 is equivalent ># to an IP-MASK of 255.0.0.0, and an IPv6 CIDR-MASK of 64 is equivalent ># to an IP-MASK of ffff:ffff:ffff:ffff::. METHOD can be "trust", "reject", ># "md5", "crypt", "password", "krb4", "krb5", "ident", or "pam". Note ># that "password" uses clear-text passwords; "md5" is preferred for ># encrypted passwords. OPTION is the ident map or the name of the PAM ># service. ># ># This file is read on server startup and when the postmaster receives ># a SIGHUP signal. If you edit the file on a running system, you have ># to SIGHUP the postmaster for the changes to take effect, or use ># "pg_ctl reload". > ># Put your actual configuration here ># ---------------------------------- ># ># CAUTION: The default configuration allows any local user to connect ># using any PostgreSQL user name, including the superuser, over either ># Unix-domain sockets or TCP/IP. If you are on a multiple-user ># machine, the default configuration is probably too liberal for you. ># Change it to use something other than "trust" authentication. ># ># If you want to allow non-local connections, you need to add more# "+" or a >list containing either. IP-ADDRESS and IP-MASK specify the ># set of hosts the record matches. CIDR-MASK is an integer between 0 ># and 32 (IPv6) or 128(IPv6) inclusive, that specifies the number of ># significant bits in the mask, so an IPv4 CIDR-MASK of 8 is equivalent ># to an IP-MASK of 255.0.0.0, and an IPv6 CIDR-MASK of 64 is equivalent ># to an IP-MASK of ffff:ffff:ffff:ffff::. METHOD can be "trust", "reject", ># "md5", "crypt", "password", "krb4", "krb5", "ident", or "pam". Note ># that "password" uses clear-text passwords; "md5" is preferred for ># encrypted passwords. OPTION is the ident map or the name of the PAM ># service. ># ># This file is read on server startup and when the postmaster receives ># a SIGHUP signal. If you edit the file on a running system, you have ># to SIGHUP the postmaster for the changes to take effect, or use ># "pg_ctl reload". > ># Put your actual configuration here ># ---------------------------------- ># ># CAUTION: The default configuration allows any local user to connect ># using any PostgreSQL user name, including the superuser, over either ># Unix-domain sockets or TCP/IP. If you are on a multiple-user ># machine, the default configuration is probably too liberal for you. ># Change it to use something other than "trust" authentication. ># ># If you want to allow non-local connections, you need to add more ># "host" records. Also, remember TCP/IP connections are only enabled ># if you enable "tcpip_socket" in postgresql.conf. > ># TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD > ># IPv4-style local connections: >#host all all 127.0.0.1 255.255.255.255 trust ># IPv6-style local connections: >#host all all ::1 >ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff trust > ># Using sockets credentials for improved security. Not available everywhere, ># but works on Linux, *BSD (and probably some others) > >#local all all ident sameuser >host all all echo -n "Enter the IP mask of this server (probably >255.255.255.0) " trust >host all all 0.0.0.0 255.255.255.255 reject >host all all echo -n "Enter the IP mask of this server (probably >255.255.255.0) " trust >host all all 0.0.0.0 255.255.255.255 reject >host all all echo -n "Enter the IP mask of this server (probably >255.255.255.0) " trust >host all all 192.168.0.254 255.255.255.0 trust >host all all 0.0.0.0 255.255.255.255 reject >local all all trust >host all all 127.0.0.1 255.255.255.255 trust > > > > > >------------------------------------------------------- >Using Tomcat but need to do more? Need to support web services, security? >Get stuff done quickly with pre-integrated technology to make your job easier >Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo >http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 >_______________________________________________ >sql-ledger-users mailing list >sql...@li... >https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > |
