On 1/11/07, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > > > LOG: invalid IP mask "password" in file "C:/Program > > Files/PostgreSQL/8.2/data/pg_hba.conf" line 72: Unknown host > > You are missing a column in your pg_hba.conf. Do you have the real one > somewhere? > > Jochem
Which column am I missing? According to the docs ( http://www.postgresql.org/docs/8.2/static/auth-pg-hba-conf.html), the record can take one of seven forms: local *database* *user* *auth-method* [*auth-option*] host *database* *user* *CIDR-address* *auth-method* [*auth-option*] hostssl *database* *user* *CIDR-address* *auth-method* [*auth-option*] hostnossl *database* *user* *CIDR-address* *auth-method* [*auth-option*] host *database* *user* *IP-address* *IP-mask* *auth-method* [*auth-option*] hostssl *database* *user* *IP-address* *IP-mask* *auth-method* [*auth-option*] hostnossl *database* *user* *IP-address* *IP-mask* *auth-method* [*auth-option*] My pg_hba.conf file contains the following lines (below all of the instructions): # TYPE DATABASE USER IP-ADDRESS METHOD host all all 127.0.0.1/32 md5 host sameuser all (my.IP.addy.here) md5 The first line allows me to connect from localhost (CF DSN works wonderfully, etc). The second, as I understand it, *should* allow my IP to connect. Am I completely misunderstanding something here? Thanks, Matt ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266325 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
