如何在Openfire MySQL数据库中添加更多属性? [英] How to add more attributes to Openfire MySQL database?

问题描述

我使用openfire安装目录中的openfire_mysql.sql文件设置了带有外部MySQL数据库的Openfire服务器，以填充数据库，连接以及一切基本正常的方法.

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.

实际上，使用Smack API，已经有足够的属性可以根据API文档存储在用户的数据中:

Actually using the Smack API there are already enough attributes that can be stored in a User's data based on the API doc:

http://docs.jivesoftware. com/smack/latest/javadoc/org/jivesoftware/smack/AccountManager.html#getAccountAttributes ()

但是，当使用Map属性的参数执行createAccount时，该属性将不会保留，因为我认为默认数据库没有用于存储此属性的字段.因此，我使用了外部数据库，但是仍然无法在phpMyAdmin中看到该属性存储在哪些字段中?

However when doing createAccount with the parameter of Map attributes, the attribute is not persisted because I think the default database does not have fields to store this. So I used external database, yet still I can't see in the phpMyAdmin which fields this attribute get stored?

有什么想法吗?

推荐答案

是.您的问题的解决方案将保存在用户的vCard数据中.每个用户都有一个Vcard，可以向其中添加所需的所有数据.

Yes. The solution to your problem would be saved in the vCard data from the user. Each user has a Vcard and it can be added all the data you need.

这篇关于如何在Openfire MySQL数据库中添加更多属性?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！