Hi, this is my first experience with Linux and I'm working on setting up an Openfire IM server on CentOS 5 using MySQL. I've created the database in mysql, created the user (openfire) and password, opened the ports on the firewall, etc. However, once I finish running the Openfire setup wizard (no errors) and I click on "Login to the admin console" it just starts the wizard all over again.

I appreciate your help in advance! (Sorry if I left out alot of relevent info but I'm not sure what else to add).

gubymike

When you installed Openfire did you restart the service first before trying to log in? If not, that is what you need to do.

I believe we did. Below are the basic instructions we followed aside form the fact that we go a newer version of Openfire (3.6.3). I appreciate any feedback:

Installing OpenFire on CentOS 5

Download and install the openfire rpm 3.3.2 (as of this writing).

# rpm -ivh openfire-3.3.2-1.i386.rpmOpenfire has an embedded database that you can use in case you don’t have MySQL installed, I prefer using MySQL though, I also tried using the embedded database, works just fine too. Create the database using mysql command line.

a. database name = openfire
b. database user = openfire
c. dbpassword = password

$ mysql -u root -pEnter password:mysql -> create database openfire;mysql -> GRANT ALL ON openfire.* TO openfire@localhost IDENTIFIED BY "password";q <-- exit mysqlGo to openfire’s directory

# cd /opt/openfire/resources/databaseImport the sql file to openfire database

# cat openfire_mysql.sql | mysql -u root -p openfireEnter password:Reload the database:

# mysqladmin -u root -p reloadEnter password:We’re almost done, now start openfire.

# cd /opt/openfire/bin# ./openfire.shThen launch your browser (Firefox) and enter this at the url box -> https://localhost:9091 then follow the procedure on screen and complete the installation process.

Verify English is selected and click Continue
Click Continue for the Server Settings
Verify Standard Database Connection is chosen and click Continue
Set the following Database Settings (then click Continue):
Database Driver Presets: MySQL
Database URL: jdbc:mysql://localhost:3306/openfire
Username: openfire
Password: password

Launch Gaim/Pidgin and create/register an account with the server, to send a message to user1, don’t forget to include the server hostname e.g. user@example.org

That’s all there is to it!

Cheers!

I don't know how you've managed to get into a setup loop. I tried 3 experimental installs and they all completed and I was able to log in as admin. Here is how I installed openfire:

1. I did rpm -ivh openfire*.rpm

2. I then issued service openfire restart

3. I opened hxxp://localhost:9090 (replace xx with tt)

4. Completed the wizard then logged in as admin.

Should you wish to start again using the same steps I used, you need to stop your current running openfire (service openfire stop) then uninstall it with: rpm -e openfire

BTW: I installed the same version as you.

Thank you so much!!! I'm not sure why I was stuck in that loop but your simple instructions fixed the problem! I truly appreciate all of your help.

Cheers!

The server was working fine for three weeks until the power blinked. The server is still working but, The control panel is replaced with the install script. The install script loops forever.

mysql --version
mysql Ver 14.12 Distrib 5.0.95, for redhat-linux-gnu (i686) using readline 5.1

cat /proc/version
Linux version 2.6.18-194.8.1.v5 (devel@clearos5x.lan) (gcc version 4.1.2 20080704 (Red Hat 4.1.2-48)) #1 SMP Thu Jul 15 01:14:04 EDT 2010

mysql -p
create database openfire;
create USER 'openfire'@'localhost';
SET PASSWORD FOR 'openfire'@'localhost' = PASSWORD('433e27e0');
GRANT ALL ON openfire.* TO 'openfire';