87
edits
Changes
Jump to navigation
Jump to search
Line 21:
Line 21: − cd /opt/openfire/resources/database − mysql openfiredb < openfire_mysql.sql + + + + + + + + + + + + + + + + + + + +
→Create the Database
mysql -e "grant all privileges on openfiredb.* to openfireuser@localhost identified by 'yourpassword'"
mysql -e "grant all privileges on openfiredb.* to openfireuser@localhost identified by 'yourpassword'"
mysql -e "flush privileges"
mysql -e "flush privileges"
{{Warning box|You may wish to alter the "openfireuser" and "yourpassword" information in the grant privileges line above. Be sure to remember to remember what you used as the web manager will ask you for it!}}
{{Warning box|You may wish to alter the "openfireuser" and "yourpassword" information in the grant privileges line above. Be sure to remember to remember what you used as the web manager will ask you for it!}}
Edit the database schema:
# cd /opt/openfire/resources/database
# mcedit openfire_mysql.sql
At line 57 starts:
CREATE TABLE ofRoster (
rosterID BIGINT NOT NULL,
username VARCHAR(64) NOT NULL,
jid VARCHAR(1024) NOT NULL,
Change the jid line from 1024 to 255 as shown:
jid VARCHAR(255) NOT NULL,
Import the revised database schema:
# mysql openfire < openfire_mysql.sql
== Access MySQL from the local network ==
== Access MySQL from the local network ==