title: Openfire configuration dump link: https://onemoretech.wordpress.com/2013/04/10/openfire-configuration-dump/ author: phil2nc description: post_id: 4634 created: 2013/04/10 09:58:35 created_gmt: 2013/04/10 13:58:35 comment_status: closed post_name: openfire-configuration-dump status: publish post_type: post

Openfire configuration dump

Openfire is an advanced XMPP server written in Java. It uses a MySQL database backend but can also be configured to use an LDAP server for its user accounts. Since its configuration is stored in MySQL, being able to get a text dump of it can be useful. Log into the MySQL server as a user with at least read privileges on the database using the mysql client and use the "INTO OUTFILE" method to dump the config to text. The table containing the system configuration is named "ofProperty". In the example below my Openfire server db is called "openfire" (very creative, eh?).

mysql> use openfire;
Database changed
mysql> SELECT * INTO OUTFILE "/tmp/of-cfg.txt"
    -> FIELDS TERMINATED BY '\t'
    -> LINES TERMINATED BY '\n'
    -> FROM ofProperty;

This will print the contents of the ofProperty table to a passably formatted text file. Something nice to have when the auditors ask.

Copyright 2004-2019 Phil Lembo