Openfire is an open-source real-time collaboration (RTC) server that provides instant messaging (IM), group chat, and voice/video chat services. It is built on top of the XMPP (Extensible Messaging and Presence Protocol) protocol and provides a web-based administration interface to manage users, groups, and chat rooms.
Openfire is highly extensible and can be customized through the use of plugins. There are several plugins available that extend the functionality of Openfire, including support for LDAP authentication, encryption, archiving, and integration with other messaging platforms such as WhatsApp and Slack.
Openfire can be installed on various platforms such as Windows, Linux, and macOS. It is written in Java and can be deployed on a standalone server or as a cluster for high availability and scalability. Openfire also supports multiple database systems, including PostgreSQL, MySQL, and Microsoft SQL Server.
Openfire is widely used in organizations of all sizes as it provides a secure and scalable solution for internal communication and collaboration. It is popular among developers due to its open-source nature, extensibility, and ease of integration with other systems.
Step 1 — Exporting MariaDB Database
The mysqldump console utility exports databases to SQL text files. This makes it easier to transfer and move databases. You will need your database’s name and credentials for an account whose privileges allow at least full read-only access to the database.
#mysqldump -u openfire -p openfire > openfire.sql
Step 2 — Importing a MySQL or MariaDB Database
Copy the database to the new server and also you can copy other way
#scp openfire.sql root@192.168.1.4:openfire.sql
Step 3 — Importing a MySQL or MariaDB Database
New Server for migration/restore Openfire server 192.168.1.4
MariaDB SQL Installation
Checking OS version
#cat /etc/centos-release
Updating and upgrading to the centos 9 stream
#dnf update -y && dnf upgrade -y
Rename to the server as chat.example.com
#nano /etc/hostname
Installing mariadb-server
#dnf install -y mariadb-server
MariaDB service enable
#systemctl enable mariadb.service
MariaDB service started
#systemctl start mariadb.service
secure MariaDB server
#mysql_secure_installation
You will be prompted with six questions. Choose options as shown below.
- Enter current password for root (enter for none): Press enter as there is no password by default.
- Set root password? [Y/n]: Select Y and enter a new password.
- Remove anonymous users? [Y/n]: Select Y
- Disallow root login remotely? [Y/n]: Enter Y
- Remove the test database and access to it? [Y/n]: Enter Y
- Reload privilege tables now? [Y/n]: Enter Y
Execute the following command to connect to MariaDB. When prompted, enter the root password you set up in the previous step.
# mariadb -u root -p
creating the database
CREATE DATABASE openfire;
checked database created or not
SHOW DATABASES;
Created user
CREATE USER ‘openfire’@’localhost’ IDENTIFIED BY ‘abc@12345’;
checked user
SELECT User FROM mysql.user;
Grant privileges.
grant all privileges on ‘openfire’.* to ‘openfire’@’localhost’ identified by ‘abc@12345’;
flush privileges
FLUSH PRIVILEGES;
exit from MariaDB server
Exit
Imported the dump
#mysql -u opefire -p openfire < openfire.sqlerate response
Installing Openfire Server on CentOS 9:
Download latest version (currently Openfire 4.6.4-1) from Ignite Realtime Website. There are two variations of Openfire are available here i.e. with or without JRE. We recommend you to download and install the Openfire with JRE. Otherwise you have to explicitly install OpenJDK before installing Openfire without JRE.
# cd /tmp
# wget -O openfire-4.7.4-1.noarch.rpm https://www.igniterealtime.org/downloadServlet?filename=openfire/openfire-4.7.4-1.noarch.rpm
Install Openfire package using rpm command.
# rpm -ivh openfire-4.7.4-1.noarch.rpm
# systemctl enable openfire.service
# service openfire restart
#service openfire status
To start Openfire setup, browse the URL http://192.168.1.4:9090/ in a client’s browser.