Re: [awips2-users] Postgres Issues

• To: Brian Bernard <brian.brianbernard@xxxxxxxxx>
• Subject: Re: [awips2-users] Postgres Issues
• From: Michael James <mjames@xxxxxxxx>
• Date: Thu, 16 Oct 2014 12:09:15 -0600

Brian,

/awips2/data/pg_hba.conf should contain entries for your internal IP
subnet, and the log message

"CIDR mask is invalid: ".0/24"

indicates that the database host lines in that file have not been
configured correctly by the "edex setup" script. You will have to manually
edit the file or force reinstall the awips2-postgres package.

/awips2/data/pg_hba.conf entries should include your 192.168.1 subnet:

host    fxatext     all         192.168.1.0/24       trust
host    hd_ob92oax  all         192.168.1.0/24       trust
host    dc_ob7oax   all         192.168.1.0/24       trust
host    hmdb        all         192.168.1.0/24       trust
host    metadata    all         192.168.1.0/24       md5
host    maps        all         192.168.1.0/24       md5
host    postgres    all         192.168.1.0/24       md5
host    ncep        all         192.168.1.0/24       md5
host    ebxml       all         192.168.1.0/24       trust


Michael James
Unidata Program Center
Boulder, CO

On Thu, Oct 16, 2014 at 11:25 AM, Brian Bernard <
brian.brianbernard@xxxxxxxxx> wrote:

> I'm trying to start the EDEX server with edex start, but it hangs. I've
> also tried edex setup and again it hangs. typing 'edex' shows:
>
> [edex status]
>  postgres    :: not running
>  pypies      :: running :: pid 2709
>  qpid        :: running :: pid 3162
>  EDEXingest  :: running :: pid 3025 3436 5272
>  EDEXgrib    :: running :: pid 3074 3439 5282
>  EDEXrequest :: running :: pid 2888 3441 5290
>
>
>      edex (status|start|stop|setup|log)
>
> So, then I checked the postgresql-Thursday.log and it shows the following:
>
> 2014-10-16 17:04:45 GMT 0  :  : LOG:  specifying both host name and CIDR
> mask is invalid: ".0/24"
> 2014-10-16 17:04:45 GMT 0  :  : CONTEXT:  line 79 of configuration file
> "/awips2/data/pg_hba.conf"
> 2014-10-16 17:04:45 GMT 0  :  : LOG:  specifying both host name and CIDR
> mask is invalid: ".0/24"
> 2014-10-16 17:04:45 GMT 0  :  : CONTEXT:  line 82 of configuration file
> "/awips2/data/pg_hba.conf"
> 2014-10-16 17:04:45 GMT 0  :  : LOG:  specifying both host name and CIDR
> mask is invalid: ".0/24"
> 2014-10-16 17:04:45 GMT 0  :  : CONTEXT:  line 85 of configuration file
> "/awips2/data/pg_hba.conf"
> 2014-10-16 17:04:45 GMT 0  :  : LOG:  specifying both host name and CIDR
> mask is invalid: ".0/24"
> 2014-10-16 17:04:45 GMT 0  :  : CONTEXT:  line 88 of configuration file
> "/awips2/data/pg_hba.conf"
> 2014-10-16 17:04:45 GMT 0  :  : LOG:  specifying both host name and CIDR
> mask is invalid: ".0/24"
> 2014-10-16 17:04:45 GMT 0  :  : CONTEXT:  line 91 of configuration file
> "/awips2/data/pg_hba.conf"
> 2014-10-16 17:04:45 GMT 0  :  : LOG:  specifying both host name and CIDR
> mask is invalid: ".0/24"
> 2014-10-16 17:04:45 GMT 0  :  : CONTEXT:  line 94 of configuration file
> "/awips2/data/pg_hba.conf"
> 2014-10-16 17:04:45 GMT 0  :  : LOG:  specifying both host name and CIDR
> mask is invalid: ".0/24"
> 2014-10-16 17:04:45 GMT 0  :  : CONTEXT:  line 97 of configuration file
> "/awips2/data/pg_hba.conf"
> 2014-10-16 17:04:45 GMT 0  :  : LOG:  specifying both host name and CIDR
> mask is invalid: ".0/24"
> 2014-10-16 17:04:45 GMT 0  :  : CONTEXT:  line 100 of configuration file
> "/awips2/data/pg_hba.conf"
> 2014-10-16 17:04:45 GMT 0  :  : LOG:  specifying both host name and CIDR
> mask is invalid: ".0/24"
> 2014-10-16 17:04:45 GMT 0  :  : CONTEXT:  line 103 of configuration file
> "/awips2/data/pg_hba.conf"
> 2014-10-16 17:04:45 GMT 0  :  : FATAL:  could not load pg_hba.conf
>
>
> The EDEX server is installed on CentOS 6.5, and CAVE will be installed to
> the same computer. I connect to the internet through a router and ifconfig
> shows:
>
> eth0      Link encap:Ethernet  HWaddr xx:xx:xx:xx:xx:xx
>           inet addr:192.168.1.3  Bcast:192.168.1.255  Mask:255.255.255.0
>           inet6 addr: fe80::be5f:f4ff:fe8a:1188/64 Scope:Link
>           UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
>           RX packets:7039 errors:0 dropped:0 overruns:0 frame:0
>           TX packets:6182 errors:0 dropped:0 overruns:0 carrier:0
>           collisions:0 txqueuelen:1000
>           RX bytes:5000931 (4.7 MiB)  TX bytes:1080404 (1.0 MiB)
>           Interrupt:16
>
> Do I have to set the 192.168.1.3 in etc/hosts? My system is called
> localhost.localdomain .
>
> Thank you for any help.
>
> Brian Bernard
>
>
>
> _______________________________________________
> awips2-users mailing list
> awips2-users@xxxxxxxxxxxxxxxx
> For list information, to unsubscribe, or change your membership options,
> visit: http://www.unidata.ucar.edu/mailing_lists/
>
>

• References:
  • [awips2-users] Postgres Issues
    • From: Brian Bernard