Install the following packages for Postgresql database
# yum install postgresql postgresql-server postgresql-libs
Install openfire rpm
# rpm -ivh openfire-3.8.2-1.i386.rpm
Configure postgresql database for openfire
# cat /etc/passwd | grep postgres
Home Directory: /var/lib/pgsql
Default Shell: /bin/bash
Default Password: None
You need to manually assign a password to user "postgres" by using below command
# passwd postgres
# su - postgres
-bash-4.1$ initdb --pgdata=/var/lib/pgsql/data
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.
The database cluster will be initialized with locale en_US.UTF-8.
The default database encoding has accordingly been set to UTF8.
The default text search configuration will be set to "english".
creating directory /var/lib/pgsql/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 32MB
creating configuration files ... ok
creating template1 database in /var/lib/pgsql/data/base/1 ... ok
initializing pg_authid ... ok
initializing dependencies ... ok
creating system views ... ok
loading system objects' descriptions ... ok
creating conversions ... ok
creating dictionaries ... ok
setting privileges on built-in objects ... ok
creating information schema ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok
copying template1 to postgres ... ok
WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the -A option the
next time you run initdb.
Success. You can now start the database server using:
postgres -D /var/lib/pgsql/data
pg_ctl -D /var/lib/pgsql/data -l logfile start
Now once your database is initialized start postgresql service as root
$ su - root
# /etc/init.d/postgresql start
Starting postgresql service: [ OK ]
Creating a user and database for openfire
# useradd deepak
# passwd deepak
# su - postgres
-bash-4.1$ createdb openfire
-bash-4.1$ psql openfire
Type "help" for help.
openfire=# CREATE USER deepak WITH PASSWORD 'example123';
openfire=# GRANT ALL PRIVILEGES ON DATABASE openfire to deepak;
Now verify from command line if you can login to openfire database using user deepak. To quit from the postgres console
-bash-4.1$ su - deepak
[deepak@test ~]$ psql -d openfire -U deepak
Type "help" for help.
So we have sucessfully connected to our database using deepak user.
I got few error while connecting to the openfire database. I have created separate post for them. Please follow the below links if you get the same error messages in your /opt/openfire/logs/error.log file
FATAL: no pg_hba.conf entry for host "localhost", user "myuser", database "openfire", SSL off
Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections
Now go to the CLI of your openfire server to start the chat services
# cd /opt/openfire/bin
Openfire 3.8.2 [Sep 21, 2013 6:09:18 PM]
Admin console listening at:
Run the above given script
NOTE: Make sure you don't close this terminal as it will close the running services of your chat server
Follow the below links for more tutorials
How to configure Samba 4 Secondary Domain Controller
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?