I setup a Openfire server with external MySQL database using the openfire_mysql.sql file from the openfire installation directory to populate the database, the connection and everything basic seems to be ok.
However I need to add another attribute of a User instead of just "name", "email", I need to add "phone" and a long text field for users to save some notes.
Any ideas?