87
edits
Changes
From SME Server
Jump to navigationJump to search→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 ==
