openfire安装The Openfire database schema does not appear to be installed. Follow the installation guid
来源:互联网 发布:php表达式去除a标签 编辑:程序博客网 时间:2024/05/17 12:02
安装了好几次openfire,这次安装用mysql数据库时居然出现The Openfire database schema does not appear to be installed. Follow the installation guide to fix this error.
这样的错误
原因:
在Navicat for MySQL中创建openfire数据库没有导入相应的表结构
方法:
点击openfire下的Tables右键Execute SQL file...
点击打开
但是悲催的是又出错
这次出错可以看Message Log
Error Code: 1071. Specified key was too long; max key length is 767 bytes
后发现是
CREATE TABLE ofRoster (
rosterID BIGINT NOT NULL,
username VARCHAR(64) NOT NULL,
jid VARCHAR(1024) NOT NULL,
sub TINYINT NOT NULL,
ask TINYINT NOT NULL,
recv TINYINT NOT NULL,
nick VARCHAR(255),
PRIMARY KEY (rosterID),
INDEX ofRoster_unameid_idx (username),
INDEX ofRoster_jid_idx (jid)
);
中的 jid VARCHAR(1024) 中的1024太大了,改为255后问题解决,可以成功创建表,openfire也可以正常连接数据库了。
- openfire安装The Openfire database schema does not appear to be installed. Follow the installation guid
- openfire 安装配置报错The Openfire database schema does not appear to be installed. Follow the installati解决
- openfire 安装配置报错The Openfire database schema does not appear to be installed. Follow the installati解决
- Openfire无法安装the jvm could not be started.
- VS 安装助手,弹出“The security key for this program currently stored on your system does not appear to be ”
- VS 安装助手,弹出“The security key for this program currently stored on your system does not appear to be ”
- linux下安装PHP的CI框架,出现Your view folder path does not appear to be set correctly. Please open the following file and correct this: i
- The security key for this program currently stored on your system does not appear to be valid for th
- You do not appear to have the sources for the 3.5.0-23-generic kernel installed
- Could not scan for classes inside "database/seeds" which does not appear to be a file nor a folde
- ArcServer10 安装中提示The following features cannot not be installed due to missing prerequisites"
- android 安装提示 app not installed the package appears to be corrupt
- the security settings could not be applied to the database
- win7 mysql 安装 报The security settings could not be applied to the database
- git does not appear to be a git repository
- VA番茄助手提示The security key for this program currently stored on your system does not appear to be vali
- Openfire出现Error:Could not start the Openfire server解决方案
- CMake Error: The source directory "/xxx/mysql-5.6.21" does not appear to contain CMakeLists.txt
- 拷贝构造函数
- osgExample - osgAnimate
- Java面向对象三大特征
- 新年新气象
- osgExample - osgAnimationMakepath
- openfire安装The Openfire database schema does not appear to be installed. Follow the installation guid
- osgExample - osgAnimationMorph
- Path in developing
- Android 用MediaCodec实现视频硬解码
- PHP IDE eclipse-php-luna 使用规范
- python mysql 插入特殊字符串处理
- Python的中文编码问题
- Web前端性能优化实践
- Qt+openGL学习记录(1)`Qt中openGL的三个重要事件处理函数的调用规则`