Comments (4)
着急!!!
我重新描述一下吧:
环境:
Centos 6.6 x86_64 内核信息Linux template 2.6.32-504.el6.x86_64
nginx 版本 1.10.2 编译安装
mysql 版本 5.6.19 二进制解压安装(mysql-5.6.19-linux-glibc2.5-x86_64.tar.gz)
php 版本5.6.29
编译参数:
./configure --prefix=/usr/local/php --with-config-file-path=/usr/local/php/etc/ --with-mysql=/usr/local/mysql --with-mysqli=/usr/local/mysql/bin/mysql_config --with-curl --enable-fpm --enable-pcntl --enable-mbregex --with-mhash --enable-zip --enable-mbstring --with-openssl
使用service php-fpm start 来启动!
在clone bk-cmdb源码之前测试过php解析.php页面和mysql的连接情况,都是OK的。
遇到的问题:浏览器输入域名,然后用户名密码,可以正常进入。但是一会我刷新了一下,就报错用户名密码错误(不知道为啥)。然后开启index.php 的debug模式(0改为1),提示错误 ,类似A PHP Error was encountered,挺多的。于是我删除cmdb数据库重新创建,重新导入bk-cmdb.sql 正常,又重新执行数据库初始化报错如下:
A PHP Error was encountered
Severity: Warning
Message: mysql_real_escape_string() expects parameter 2 to be resource, boolean given
Filename: mysql/mysql_driver.php
Line Number: 352
Backtrace:
File: /data/htdocs/cc_openSource/application/models/UserModel.php
Line: 19
Function: where
File: /data/htdocs/cc_openSource/application/libraries/Login.php
Line: 115
Function: getUserByUsername
File: /data/htdocs/cc_openSource/application/libraries/Login.php
Line: 86
Function: isValidUserPassword
然后我将debug模式关掉 了(index.php 中的1又改为了0),重新执行初始化,没报错,如下:
#php index.php /cli/Init/initUserData
begin truncate table
end truncate table
begin create classify host property
INSERT INTO cc_HostPropertyClassify
VALUES ('1', 'AssetID', '固资编号', 'basic', 'AssetID','12', '2016-02-24 11:26:57', '2016-02-24 18:00:57')
INSERT INTO cc_HostPropertyClassify
VALUES ('7', 'DeviceClass', '设备类型', 'basic', 'DeviceClass','11', '2016-02-24 17:24:04', '2016-02-24 18:01:24')
INSERT INTO cc_HostPropertyClassify
VALUES ('8', 'HostName', '主机名称', 'basic', 'HostName', '6','2016-02-24 17:26:00', '2016-02-24 18:01:48')
INSERT INTO cc_HostPropertyClassify
VALUES ('9', 'Status', '运行状态', 'basic', 'Status', '7','2016-02-24 18:02:23', '2016-02-25 14:45:38')
INSERT INTO cc_HostPropertyClassify
VALUES ('10', 'Operator', '维护人', 'basic', 'Operator','3', '2016-02-24 18:02:41', '2016-02-24 18:03:14')
INSERT INTO cc_HostPropertyClassify
VALUES ('11', 'BakOperator', '备份维护人', 'basic', 'BakOperator','4', '2016-02-24 18:03:37', '2016-02-24 18:03:37')
INSERT INTO cc_HostPropertyClassify
VALUES ('12', 'InnerIP', '内网IP', 'basic', 'InnerIP','1', '2016-02-24 18:04:01', '2016-02-24 18:04:01')
INSERT INTO cc_HostPropertyClassify
VALUES ('13', 'OuterIP', '外网IP', 'basic', 'OuterIP','2', '2016-02-24 18:04:31', '2016-02-24 18:04:31')
INSERT INTO cc_HostPropertyClassify
VALUES ('14', 'OSName', '操作系统', 'basic', 'OSName','7', '2016-02-24 18:04:53', '2016-02-24 18:04:53')
INSERT INTO cc_HostPropertyClassify
VALUES ('15', 'Description', '备注', 'basic', 'Description','13', '2016-02-24 18:05:10', '2016-02-24 18:05:10')
INSERT INTO cc_HostPropertyClassify
VALUES ('16', 'ZoneName', '可用区', 'basic', 'ZoneName','15', '2016-02-24 18:05:39', '2016-02-24 18:05:39')
INSERT INTO cc_HostPropertyClassify
VALUES ('17', 'ZoneID', '可用区ID', 'basic', 'ZoneID', '14','2016-02-24 18:06:07', '2016-02-24 18:06:07')
INSERT INTO cc_HostPropertyClassify
VALUES ('47', 'CreateTime', '入库时间', 'basic', 'CreateTime', '17','2016-02-24 19:11:25', '2016-02-24 19:11:25')
INSERT INTO cc_HostPropertyClassify
VALUES ('49', 'Region', '机房城市', 'basic', 'Region','16', '2016-02-24 19:12:21', '2016-02-24 19:12:21')
INSERT INTO cc_HostPropertyClassify
VALUES ('51', 'Cpu', 'Cpu', 'basic', 'Cpu', '8','2016-02-24 19:13:12', '2016-02-24 19:13:12')
INSERT INTO cc_HostPropertyClassify
VALUES ('52', 'Mem', '内存', 'basic', 'Mem', '9','2016-02-24 19:13:37', '2016-02-24 19:13:37')
INSERT INTO cc_HostPropertyClassify
VALUES ('60', 'HostID', '主机ID', 'basic', 'HostID','0', '2016-02-24 19:16:54', '2016-02-24 19:16:54')
INSERT INTO cc_HostPropertyClassify
VALUES ('72', 'ModuleName', '模块名称', 'basic', 'ModuleName','5', '2016-02-24 18:02:41', '2016-02-24 18:02:41')
end create classify host property
begin create set property
INSERT INTO cc_HostPropertyClassify
VALUES ('72', 'ModuleName', '模块名称', 'basic', 'ModuleName','5', '2016-02-24 18:02:41', '2016-02-24 18:02:41')
end create set property
begin create admin user
end create admin user
begin create resource pool
end create resource pool
begin create example app
end create example app
begin create example set
end create example set
begin create example module
end create example module
但是到数据库查看cc_user表是空的:
mysql> select * from cc_user;
Empty set (0.00 sec)
所以在浏览器访问,可以出现蓝鲸平台,但是输入用户名密码,依然无法进入!!!
求大神指导!
@zanyzhao @zhujianfeng @lowenitt
from bk-cmdb.
单独把cc_User表初始化下吧
from bk-cmdb.
@xingliguang ,既然都已经成功了,为何后面又突然不行了呢,解释不通。
建议你把cmdb所使用的database整个删掉重建,然后把初始化流程再重新跑一遍,既然成功过一次,说明这个初始化流程就算重复进行多次的也是可以得到正确结果的。
from bk-cmdb.
@raindylong nginx和php都没有错误日志。在@lowenitt提醒下才知道看application/logs下的日志,日志中显示:ERROR - 2016-12-23 15:12:55 --> connect to mysql server error! errno:1045,error:Access denied for user 'root'@'127.0.0.1' (using password: YES) 我也是百思不得其解,后来看到数据库中mysql.user表中只有
'localhost'@'root' 有用户名和密码,‘127.0.0.1’@‘root’没有密码,于是授予其密码。重新导入数据,重新初始化,就OK了!也许将db.php中改为localhost:3306也是可行的,这个问题应该是配置文件和数据库中的账号密码不匹配导致的!
from bk-cmdb.
Related Issues (20)
- fix:【CMDB+v3.13.2-feature-layered1】删除关联类型成功后,前端没有提示“删除成功”,建议加个提示
- fix:【CMDB+v3.13.2-feature-layered1】删除模型成功后,前端没有提示“删除成功”,建议加个提示
- fix:【CMDB+v3.13.2-feature-layered1】输入业务快照名称时 鼠标非要失焦后才会校验,导致仍然可以点击保存后二次弹窗取消不了
- fix:【CMDB+v3.13.2-feature-layered1】通用模型下没有“项目”实例
- fix:【CMDB+v3.13.2-feature-layered1】项目 操作没有‘启用/停用’功能 HOT 1
- fix:【CMDB+v3.13.2-feature-layered1】字段组合模板中新建字段唯一标识重复后,建议优化下提示,应该提示“唯一标识重复”
- fix:【CMDB+v3.13.2-feature-layered1】新建主机和集群/模块自定义字段,设置对应默认值后,在对应主机详情和集群节点信息下查看对应的字段直接显示了默认值,应该点击编辑后在显示默认值 HOT 3
- https页面登录超时后,弹出的登录框跨域
- 两台服务器之间通过多个端口相连,端口又通过网线相连,怎么通过关联关系导入到CMDB中呢? HOT 1
- authserver正常启用,登陆跳转后提示get user from bk-login failed
- make ui缺少一些包,需要手工安装 HOT 2
- 蓝鲸cmdb开源版release-v3.13.4 版本编译报错
- 【CMDB+v3.13.5-alpha1】新建集群集群名称输入特殊字符“*.+-*@%$%^&*(”提示集群名称校验不通过,建议直接输入特殊字符时直接校验
- {"result":false,"bk_error_code":1105000,"bk_error_msg":"迁移数据失败, server selection error: server selection timeout, current topology: { Type: ReplicaSetNoPrimary, Servers: [] }","permission":null,"data":null} HOT 1
- ./stop.sh命令不能有效停止所有服务进程
- 能否通过实现 adapter 支持 azure 和 gcp 的云资源同步能力?
- get_biz_brief_cache_topo接口返回的拓扑数据支持国际化
- 测试远程创建issue
- 【CMDB+v3.12.4】全文检索无法搜索表格子段内容
- 极速体验容器化部署蓝鲸CMDB无法新增业务
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from bk-cmdb.