• 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.

  • Life always offers you a second chance ... Its called tomorrow !!!

    Saturday, September 21, 2013

    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.


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


    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               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.

    Please follow the below links for more tutorials

    How to secure Apache web server in Linux using password (.htaccess)
    How to register Red Hat Linux with RHN (Red Hat Network )
    Red hat Enterprise Linux 5.5 Installation Guide (Screenshots)
    15 tips to enhance security of your Linux machine
    Why is Linux more secure than windows and any other OS
    What is the difference between "su" and "su -" in Linux?
    What is swappiness and how do we change its value?
    How to log iptables messages in different log file
    What are the s and k scripts in the etc rcx.d directories
    How to check all the currently running services in Linux
    How to auto start service after reboot in Linux
    What is virtual memory, paging and swap space?


    Post a Comment