Giter Club home page Giter Club logo

Comments (4)

xingliguang avatar xingliguang commented on May 5, 2024

着急!!!
我重新描述一下吧:
环境:
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.

owenlxu avatar owenlxu commented on May 5, 2024

单独把cc_User表初始化下吧

from bk-cmdb.

raindylong avatar raindylong commented on May 5, 2024

@xingliguang ,既然都已经成功了,为何后面又突然不行了呢,解释不通。
建议你把cmdb所使用的database整个删掉重建,然后把初始化流程再重新跑一遍,既然成功过一次,说明这个初始化流程就算重复进行多次的也是可以得到正确结果的。

from bk-cmdb.

xingliguang avatar xingliguang commented on May 5, 2024

@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)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo 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.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.