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)
- 【3.10.x-feature-agent-id-alpha14 】自定义字段新建(集群)“枚举多选”业务字段后,编辑功能失效,且动态分组下没有正确查询 HOT 1
- 【3.10.x-feature-agent-id-alpha14 】自定义字段下新建业务分组名称超长时没有使用省略提示
- 【3.10.x-feature-agent-id-alpha14 】搜索不存在的关联类型后,清空筛选条件后提示暂无数据
- 【3.10.x-feature-agent-id-alpha14 】自定义字段新建集群/模块/主机分组下的业务字段,不能编辑业务字段名称 HOT 1
- clientset目录下没有discovery
- 【3.10.x-feature-agent-id-alpha14 】在自定义字段页面搜索框,输入搜索不存在的关键字后与规范设计不一致
- 【3.10.x-feature-agent-id-alpha14 】资源主机下搜索不存在的目录时,与设计规范不一致
- 【3.10.x-feature-agent-id-alpha14 】资源主机下在搜索框输入不存在的IP在进行搜索,与设计规范不一致
- 【3.10.x-feature-agent-id-alpha14 】资源主机下导入编辑功能失效,并没有更改内容 HOT 2
- 【3.10.x-feature-agent-id-alpha14 】资源主机在更多导出选中字段下输入不存在的字段进行搜索时,与设计规范不一致
- 【3.10.x-feature-agent-id-alpha14 】资源目录通用模型导入功能失效 HOT 2
- 【3.10.x-feature-agent-id-alpha14 】通用模型下查看删除历史,实例名超长时hover时没有tips显示完整信息
- 【3.10.x-feature-agent-id-alpha14 】CC和节点管理下云服务商 两边显示不一致 HOT 2
- 【3.10.x-feature-agent-id-alpha14 】在资源项目列表显示属性配置中搜索不存在的属性时显示与搜索空规范不一致
- 编译问题 HOT 3
- 源码编译报错 HOT 2
- cmdb前端ui项目eslint报错 HOT 1
- 实例名bk_inst_name 唯一校验不生效 HOT 2
- 通过api添加主机时,bool类型设置默认值是true ,但是实际添加后默认值始终是false
- monstache 编译后没有可执行文件 HOT 1
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.