tigase5.2.3使用mysql5.6出错
问题：1、使用jar包的console参数安装后出现用户无法登陆，在tigase-console.log的日志文件出现
UserRepositoryMDImpl.getData() WARNING:Couldn't obtain user repository for domain: vhost-manager, not even default one! 2、在mysql中查看tigase库，发现少了tig_users表。完整的表如下
+--------------------------+
| Tables_in_tigasedb |
+--------------------------+
| short_news |
| tig_nodes |
| tig_pairs |
| tig_pubsub_affiliations|
| tig_pubsub_items |
| tig_pubsub_jids |
| tig_pubsub_nodes |
| tig_pubsub_service_jids|
| tig_pubsub_subscriptions |
| tig_socks5_connections |
| tig_socks5_users |
| tig_users |
| xmpp_stanza |
+--------------------------+
3、如果使用database/mysql-schema-5-1.sql导入时出现报错
MySQL ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes 4、使用tigase-server-5.2.3-b3470-dist-max.tar.gz包里的scripts/db-create-mysql.sh脚本来创建数据库出现
MySQL ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes 原因：
This is>
With the> 解决办法：
在mysql的配置文件（linux下一般在/etc/my.cnf）里添加如下内容：
innodb_large_prefix=true
innodb_file_format=barracuda
innodb_file_per_table=true
重启mysql后，再重新安装或者导入sql文件就可以了。
参考：https://projects.tigase.org/boards/15/topics/3244
页:
[1]