• VMware

    Learn about VMware virtualization for its products like vsphere ESX and ESXi, vCenter Server, VMware View, VMware P2V and many more

  • Linux

    Step by step configuration tutorials for many of the Linux services like DNS, DHCP, FTP, Samba4 etc including many tips and tricks in Red Hat Linux.

  • Database

    Learn installation and configuration of databases like Oracle, My SQL, Postgresql, etc including many other related tutorials in Linux.

    • Home / Error Logs / Postgresql / Red Hat 5 and 6 / no pg_hba.conf entry for host "*", user "*", database "*", SSL off

    no pg_hba.conf entry for host "*", user "*", database "*", SSL off

    , ,


    I got this error while trying to connect my postgresql database using openfire server.





    Error:

    FATAL: no pg_hba.conf entry for host "10.10.20.26", user "deepak", database "openfire", SSL off

    Solution:

    You need to make a host entry in the host access file of postgresql which is pg_hba.conf
    # vi /var/lib/pgsql/data/pg_hba.conf
    At the last line make a new entry as shown below
    host    all         all         0.0.0.0/0               md5
    Save and exit the file and restart the postgresql service
    # service postgresql restart
    Now re try to connect your database using openfire. Let me know your success and failure.


    Deepak Prasad

    is a techie and an author who is still trying to survive in this IT generation with very little knowledge he has on Linux/Unix, VMware, SAN Storage, Automation, networking etc

    You can follow him on Facebook or Google+


    Do you also have something to share here?
    Join GoLinuxHub Team as an Author, Click here for more information
    no pg_hba.conf entry for host "*", user "*", database "*", SSL off no pg_hba.conf entry for host "*", user "*", database "*", SSL off Reviewed by Deepak Prasad on Saturday, September 21, 2013 Rating: 5

    No comments:

    Subscribe to: Post Comments ( Atom )
    Powered by Blogger.