open-cmdb / cmdb Goto Github PK

HI，请问能否添加文本导入的操作呢？将现有信息汇总成excel。然后一键导入，谢谢！

"AttributeError at /api/v1/data/aliyun 'AnonymousUser' object has no attribute 'get_all_permission_names'

例: IP类字段无法存储为int

楼主为啥访问不到示例那个网址了

`(cmdb) C:\repo_git\cmdb\gitee\cmdb>python manage.py makemigrations
APP_NAME = C:\repo_git\cmdb\gitee\cmdb
(0.000) SELECT @@SQL_AUTO_IS_NULL; args=None
(0.000) SELECT VERSION(); args=None
(0.001) None; args=('read_all',)
Traceback (most recent call last):
File "C:\py_envs\cmdb-CdfGpvMc\lib\site-packages\django\db\backends\utils.py", line 64, in execute
return self.cursor.execute(sql, params)
File "C:\py_envs\cmdb-CdfGpvMc\lib\site-packages\django\db\backends\mysql\base.py", line 101, in execute
return self.cursor.execute(query, args)
File "C:\py_envs\cmdb-CdfGpvMc\lib\site-packages\MySQLdb\cursors.py", line 209, in execute
res = self._query(query)
File "C:\py_envs\cmdb-CdfGpvMc\lib\site-packages\MySQLdb\cursors.py", line 315, in _query
db.query(q)
File "C:\py_envs\cmdb-CdfGpvMc\lib\site-packages\MySQLdb\connections.py", line 239, in query
_mysql.connection.query(self, query)
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'cmdb.mgmt_permission' doesn't exist")

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "manage.py", line 32, in
execute_from_command_line(sys.argv)
File "C:\py_envs\cmdb-CdfGpvMc\lib\site-packages\django\core\management_init_.py", line 364, in execute_from_command_line
utility.execute()
File "C:\py_envs\cmdb-CdfGpvMc\lib\site-packages\django\core\management_init_.py", line 356, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "C:\py_envs\cmdb-CdfGpvMc\lib\site-packages\django\core\management\base.py", line 283, in run_from_argv
self.execute(*args, **cmd_options)
File "C:\py_envs\cmdb-CdfGpvMc\lib\site-packages\django\core\management\base.py", line 327, in execute
self.check()
File "C:\py_envs\cmdb-CdfGpvMc\lib\site-packages\django\core\management\base.py", line 359, in check
include_deployment_checks=include_deployment_checks,
File "C:\py_envs\cmdb-CdfGpvMc\lib\site-packages\django\core\management\base.py", line 346, in run_checks
return checks.run_checks(**kwargs)
File "C:\py_envs\cmdb-CdfGpvMc\lib\site-packages\django\core\checks\registry.py", line 81, in run_checks
new_errors = check(app_configs=app_configs)
File "C:\py_envs\cmdb-CdfGpvMc\lib\site-packages\django\core\checks\urls.py", line 16, in check_url_config
return check_resolver(resolver)
File "C:\py_envs\cmdb-CdfGpvMc\lib\site-packages\django\core\checks\urls.py", line 26, in check_resolver
return check_method()
File "C:\py_envs\cmdb-CdfGpvMc\lib\site-packages\django\urls\resolvers.py", line 256, in check
for pattern in self.url_patterns:
File "C:\py_envs\cmdb-CdfGpvMc\lib\site-packages\django\utils\functional.py", line 35, in get
res = instance.dict[self.name] = self.func(instance)
File "C:\py_envs\cmdb-CdfGpvMc\lib\site-packages\django\urls\resolvers.py", line 407, in url_patterns
patterns = getattr(self.urlconf_module, "urlpatterns", self.urlconf_module)
File "C:\py_envs\cmdb-CdfGpvMc\lib\site-packages\django\utils\functional.py", line 35, in get
res = instance.dict[self.name] = self.func(instance)
File "C:\py_envs\cmdb-CdfGpvMc\lib\site-packages\django\urls\resolvers.py", line 400, in urlconf_module
return import_module(self.urlconf_name)
File "C:\py_envs\cmdb-CdfGpvMc\lib\importlib_init.py", line 127, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
File "", line 1006, in _gcd_import
File "", line 983, in _find_and_load
File "", line 967, in _find_and_load_unlocked
File "", line 677, in load_unlocked
File "", line 728, in exec_module
File "", line 219, in call_with_frames_removed
File "C:\repo_git\cmdb\gitee\cmdb\cmdb\urls.py", line 28, in
url(r'^api/v1/mgmt/', include("mgmt.urls")),
File "C:\py_envs\cmdb-CdfGpvMc\lib\site-packages\django\conf\urls_init.py", line 50, in include
urlconf_module = import_module(urlconf_module)
File "C:\py_envs\cmdb-CdfGpvMc\lib\importlib_init.py", line 127, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
File "", line 1006, in _gcd_import
File "", line 983, in _find_and_load
File "", line 967, in _find_and_load_unlocked
File "", line 677, in _load_unlocked
File "", line 728, in exec_module
File "", line 219, in _call_with_frames_removed
File "C:\repo_git\cmdb\gitee\cmdb\apps\mgmt\urls.py", line 3, in
from . import views
File "C:\repo_git\cmdb\gitee\cmdb\apps\mgmt\views.py", line 32, in
from . import initialize
File "C:\repo_git\cmdb\gitee\cmdb\apps\mgmt\initialize.py", line 124, in
permission, is_new = models.Permission.objects.get_or_create(name="read_all")
File "C:\py_envs\cmdb-CdfGpvMc\lib\site-packages\django\db\models\manager.py", line 85, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File "C:\py_envs\cmdb-CdfGpvMc\lib\site-packages\django\db\models\query.py", line 464, in get_or_create
return self.get(**lookup), False
File "C:\py_envs\cmdb-CdfGpvMc\lib\site-packages\django\db\models\query.py", line 374, in get
num = len(clone)
File "C:\py_envs\cmdb-CdfGpvMc\lib\site-packages\django\db\models\query.py", line 232, in len
self._fetch_all()
File "C:\py_envs\cmdb-CdfGpvMc\lib\site-packages\django\db\models\query.py", line 1121, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "C:\py_envs\cmdb-CdfGpvMc\lib\site-packages\django\db\models\query.py", line 53, in iter
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch)
File "C:\py_envs\cmdb-CdfGpvMc\lib\site-packages\django\db\models\sql\compiler.py", line 899, in execute_sql
raise original_exception
File "C:\py_envs\cmdb-CdfGpvMc\lib\site-packages\django\db\models\sql\compiler.py", line 889, in execute_sql
cursor.execute(sql, params)
File "C:\py_envs\cmdb-CdfGpvMc\lib\site-packages\django\db\backends\utils.py", line 79, in execute
return super(CursorDebugWrapper, self).execute(sql, params)
File "C:\py_envs\cmdb-CdfGpvMc\lib\site-packages\django\db\backends\utils.py", line 64, in execute
return self.cursor.execute(sql, params)
File "C:\py_envs\cmdb-CdfGpvMc\lib\site-packages\django\db\utils.py", line 94, in exit
six.reraise(dj_exc_type, dj_exc_value, traceback)
File "C:\py_envs\cmdb-CdfGpvMc\lib\site-packages\django\utils\six.py", line 685, in reraise
raise value.with_traceback(tb)
File "C:\py_envs\cmdb-CdfGpvMc\lib\site-packages\django\db\backends\utils.py", line 64, in execute
return self.cursor.execute(sql, params)
File "C:\py_envs\cmdb-CdfGpvMc\lib\site-packages\django\db\backends\mysql\base.py", line 101, in execute
return self.cursor.execute(query, args)
File "C:\py_envs\cmdb-CdfGpvMc\lib\site-packages\MySQLdb\cursors.py", line 209, in execute
res = self._query(query)
File "C:\py_envs\cmdb-CdfGpvMc\lib\site-packages\MySQLdb\cursors.py", line 315, in _query
db.query(q)
File "C:\py_envs\cmdb-CdfGpvMc\lib\site-packages\MySQLdb\connections.py", line 239, in query
_mysql.connection.query(self, query)
django.db.utils.ProgrammingError: (1146, "Table 'cmdb.mgmt_permission' doesn't exist")

ry
_mysql.connection.query(self, query)
django.db.utils.ProgrammingError: (1146, "Table 'cmdb.mgmt_permission' doesn't exist")
`

我在尝试手动部署，之前，docker方式部署是ok的。

想问下，初始化数据库不能通过 python manage.py makemigrations 进行吗？
是不是只能 用docker命令初始化（sudo docker run -it --rm --link cmdb-db -e DB_HOST=cmdb-db -e ENV=PRO -e DB_PORT=3306 -e DB_USERNAME=root -e DB_PASSWORD=cmdbcmdb -e DB_NAME=cmdb mingmingtang/cmdb init-db）数据库？

正在拜读您的代码，确实对我这个刚入门vue的新手有很大的帮助，可否留下联系方式，vue的代码有些疑问点，多谢

"AttributeError at /api/v1/data/aliyun 'AnonymousUser' object has no attribute 'get_all_permission_names'

Using the URLconf defined in cmdb.urls, Django tried these URL patterns, in this order:

^api/v1/search/
^api/v1/record-data/
^api/v1/deleted-data/
^api/v1/token
^api/v1/mgmt/
^api-docs
^admin/
^c-test/
^api-auth/
The current path, api/v1/data/server1, didn't match any of these.

建完数据库的表之后，就不知道该怎么使用了

演示账号登陆不上

感觉这个挺不错的，也是开源的吗？

参考资料：
https://www.cnblogs.com/cjsblog/p/9439331.html

请问管理的是阿里云的资源吗

在测试过程中经常出现这样提示 The interface not defined!

api接口调用也会经常提示返回 {"detail": "The interface not defined!"}

为了国内用户体验好，建议中文支持；或者如果有中文版，发下链接；传统企业资产管理，可以考虑用。

python manage.py cmdb_create_superuser #这一步创建一可以登陆的管理员用户
错误如下，

但要是把mgmt.models.Permission加入到django的settings里面去的话，还是会报错，

安装好了 用什么账号登录呀 账号密码是什么

rt

我git clone了你的源代码，完全正确地安装了requirements.txt中的软件包，为什么提示
django.db.utils.OperationalError: no such table: mgmt_permission
执行 python manage.py makemigrations 也报错 。
删除 migrations目录 再执行，还是报同样的错误，网上搜索了好久也未找到解决方法，
请教大神如何解决。

下载这个源码，总是提示mysqldb模块 找不到

已经存在数据的表里面不能加字段了 只能新建

docker快速部署之后
docker ps可以看到db es cmdb都启动了，但是不能访问。

弹出报错 "\n\n<html lang="en">\n\n <meta http-equiv="content-

@tangmingming 3Q!

"C:\Program Files\JetBrains\PyCharm 2019.3\bin\runnerw64.exe" C:\py_envs\cmdb-CdfGpvMc\Scripts\python.exe "C:\Program Files\JetBrains\PyCharm 2019.3\plugins\python\helpers\pydev\pydevd.py" --multiproc --qt-support=auto --client 127.0.0.1 --port 52076 --file C:/repo_git/cmdb/gitee/cmdb/manage.py runserver 8000
pydev debugger: process 8260 is connecting

Connected to pydev debugger (build 193.5233.109)
APP_NAME = C:\repo_git\cmdb\gitee\cmdb
pydev debugger: process 15300 is connecting

APP_NAME = C:\repo_git\cmdb\gitee\cmdb
Performing system checks...

(0.001) SELECT @@SQL_AUTO_IS_NULL; args=None
(0.000) SELECT VERSION(); args=None
(0.001) SELECT mgmt_permission.id, mgmt_permission.name, mgmt_permission.alias FROM mgmt_permission WHERE mgmt_permission.name = 'read_all'; args=('read_all',)
(0.001) UPDATE mgmt_permission SET name = 'read_all', alias = '所有可读' WHERE mgmt_permission.id = 1; args=('read_all', '所有可读', 1)
(0.000) SELECT mgmt_permission.id, mgmt_permission.name, mgmt_permission.alias FROM mgmt_permission WHERE mgmt_permission.name = 'write_all'; args=('write_all',)
(0.000) UPDATE mgmt_permission SET name = 'write_all', alias = '所有可写' WHERE mgmt_permission.id = 2; args=('write_all', '所有可写', 2)
(0.000) SELECT mgmt_table.name, mgmt_table.alias, mgmt_table.readme, mgmt_table.creator_id, mgmt_table.creation_time FROM mgmt_table; args=()
System check identified no issues (0 silenced).
March 22, 2020 - 17:48:40
Django version 1.11.29, using settings 'cmdb.settings'
Starting development server at http://127.0.0.1:8000/
Quit the server with CTRL-BREAK.
(0.010) SHOW FULL TABLES; args=None
(0.001) SELECT django_migrations.app, django_migrations.name FROM django_migrations; args=()
"OPTIONS /api/v1/token HTTP/1.1" 200 504

步骤：
1.建表A
2.使用表A，插入一行记录
3.修改表结构，添加一个新列：报失败，“”表已经使用“”

可否用 D-R-F 也把发布系统，工单系统加进来？

垃圾，页面老是报错

怎么给用户分配表权限？

ubuntu 下run的时候提示
docker: invalid reference format: repository name must be lowercase.

list功能中，total是正确的数据行计数，但hits里只有10行结果

如何启用LDAP认证