Category: Memo(메모)

11월 10

C3550 Software Forced Crash Exception (0x0700) – 결국 고장남.

By snowffox in Memo(메모), Network(네트워크)

C3550 Software Forced Crash Exception (0x0700) – 결국 고장남. 사용중이던 c3550 스위치가 재부팅되며 아래와 같은 로그를 남김. 로그 남긴 3~4 시간 후에 대부분의 포트가 죽어버렸고, 재부팅 후에도 복구되지 않아서 다른 장비로 교체했다. 단지, 기록 차원에서 남겨 본다.

.Nov  2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: System previously crashed with the following message:
.Nov  2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: Cisco IOS Software, C3550 Software (C3550-IPBASE-M), Version 12.2(44)SE6, RELEASE SOFTWARE (fc1)
.Nov  2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: Copyright (c) 1986-2009 by Cisco Systems, Inc.
.Nov  2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: Compiled Mon 09-Mar-09 14:33 by gereddy
.Nov  2 15:19:00: %PLATFORM_CAT3550-1-CRASHED:  
.Nov  2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: Software Forced Crash Exception (0x0700)!
.Nov  2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: CPU Register Context:
.Nov  2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: Vector = 0x00000700  PC = 0x003EE914  MSR = 0x0002B030  CR = 0x20000004
.Nov  2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: LR = 0x003EE914  CTR = 0x00459FF4  XER = 0x00000000
.Nov  2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: R0 = 0x003EE914  R1 = 0x01B1DEC4  R2 = 0x00000000  R3 = 0x00000000
.Nov  2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: R4 = 0x00CB7FDC  R5 = 0x0000B030  R6 = 0xFEE00000  R7 = 0xBEEFCAFE
.Nov  2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: R8 = 0x01290000  R9 = 0x01450000  R10 = 0x013BB4F0  R11 = 0x000003E0
.Nov  2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: R12 = 0x44444028  R13 = 0xEFF7FFFF  R14 = 0x0046AF5C  R15 = 0x00000000
.Nov  2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: R16 = 0x00000000  R17 = 0x00000000  R18 = 0x00000000  R19 = 0x00000000
.Nov  2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: R20 = 0x00000000  R21 = 0x00000000  R22 = 0x00000000  R23 = 0x00000000
.Nov  2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: R24 = 0x00000000  R25 = 0x00000000  R26 = 0x00000000  R27 = 0x81000000
.Nov  2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: R28 = 0x00000006  R29 = 0x00000000  R30 = 0x00000000  R31 = 0x00000003
.Nov  2 15:19:00: %PLATFORM_CAT3550-1-CRASHED:  
.Nov  2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: Stack trace:
.Nov  2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: PC = 0x003EE914, SP = 0x01B1DEC4
.Nov  2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: Frame 00: SP = 0x01B1DED4    PC = 0x003EE914
.Nov  2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: Frame 01: SP = 0x01B1DEE4    PC = 0x003E6AF0
.Nov  2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: Frame 02: SP = 0x01B1DEFC    PC = 0x003F0C98
.Nov  2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: Frame 03: SP = 0x01B1DF48    PC = 0x003E564C
.Nov  2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: Frame 04: SP = 0x01B1DF70    PC = 0x00457830
.Nov  2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: Frame 05: SP = 0x01B1DF78    PC = 0x0045A080
.Nov  2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: Frame 06: SP = 0x01B1DF90    PC = 0x0046B02C
.Nov  2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: Frame 07: SP = 0x01B1DF98    PC = 0x003F08F0
.Nov  2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: Frame 08: SP = 0x00000000    PC = 0x003E7600
.Nov  2 15:19:00: %PLATFORM_CAT3550-1-CRASHED:

.Nov 2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: System previously crashed with the following message:

.Nov 2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: Cisco IOS Software, C3550 Software (C3550-IPBASE-M), Version 12.2(44)SE6, RELEASE SOFTWARE (fc1)

.Nov 2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: Compiled Mon 09-Mar-09 14:33 by gereddy

.Nov 2 15:19:00: %PLATFORM_CAT3550-1-CRASHED:

.Nov 2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: Software Forced Crash Exception (0x0700)!

.Nov 2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: CPU Register Context:

.Nov 2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: Vector = 0x00000700 PC = 0x003EE914 MSR = 0x0002B030 CR = 0x20000004

.Nov 2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: LR = 0x003EE914 CTR = 0x00459FF4 XER = 0x00000000

.Nov 2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: R0 = 0x003EE914 R1 = 0x01B1DEC4 R2 = 0x00000000 R3 = 0x00000000

.Nov 2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: R4 = 0x00CB7FDC R5 = 0x0000B030 R6 = 0xFEE00000 R7 = 0xBEEFCAFE

.Nov 2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: R8 = 0x01290000 R9 = 0x01450000 R10 = 0x013BB4F0 R11 = 0x000003E0

.Nov 2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: R12 = 0x44444028 R13 = 0xEFF7FFFF R14 = 0x0046AF5C R15 = 0x00000000

.Nov 2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: R16 = 0x00000000 R17 = 0x00000000 R18 = 0x00000000 R19 = 0x00000000

.Nov 2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: R20 = 0x00000000 R21 = 0x00000000 R22 = 0x00000000 R23 = 0x00000000

.Nov 2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: R24 = 0x00000000 R25 = 0x00000000 R26 = 0x00000000 R27 = 0x81000000

.Nov 2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: R28 = 0x00000006 R29 = 0x00000000 R30 = 0x00000000 R31 = 0x00000003

.Nov 2 15:19:00: %PLATFORM_CAT3550-1-CRASHED:

.Nov 2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: Stack trace:

.Nov 2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: PC = 0x003EE914, SP = 0x01B1DEC4

.Nov 2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: Frame 00: SP = 0x01B1DED4 PC = 0x003EE914

.Nov 2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: Frame 01: SP = 0x01B1DEE4 PC = 0x003E6AF0

.Nov 2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: Frame 02: SP = 0x01B1DEFC PC = 0x003F0C98

.Nov 2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: Frame 03: SP = 0x01B1DF48 PC = 0x003E564C

.Nov 2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: Frame 04: SP = 0x01B1DF70 PC = 0x00457830

.Nov 2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: Frame 05: SP = 0x01B1DF78 PC = 0x0045A080

.Nov 2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: Frame 06: SP = 0x01B1DF90 PC = 0x0046B02C

.Nov 2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: Frame 07: SP = 0x01B1DF98 PC = 0x003F08F0

.Nov 2 15:19:00: %PLATFORM_CAT3550-1-CRASHED: Frame 08: SP = 0x00000000 PC = 0x003E7600

.Nov 2 15:19:00: %PLATFORM_CAT3550-1-CRASHED:

dir 명령어로 crashinfo 관련 내용을 확인하면 아래처럼 crashinfo_ext와 crash_info 두개의 디렉토리가 보인다.

Switch #dir flash:
Directory of flash:/

    2  -rwx     4271779   Mar 1 1993 09:12:54 +09:00  c3550-i5q3l2-mz.121-22.EA7.bin
    4  -rwx        1048  Apr 22 2020 13:04:10 +09:00  multiple-fs
    5  -rwx     6719771  Feb 10 2011 17:05:48 +09:00  c3550-ipbase-mz.122-44.SE6.bin
    6  -rwx           5  Apr 22 2020 13:04:10 +09:00  private-config.text
    7  -rwx       11505  Apr 22 2020 13:04:10 +09:00  config.text
    8  -rwx           0  Feb 10 2011 17:11:11 +09:00  env_vars
    9  -rwx          42  Feb 10 2011 17:11:11 +09:00  system_env_vars
   10  drwx          64   Nov 2 2020 15:14:55 +09:00  crashinfo_ext
   12  drwx          64   Mar 1 1993 09:00:11 +09:00  crashinfo
   14  -rwx         676   Mar 1 1993 09:01:11 +09:00  vlan.dat

15998976 bytes total (4686336 bytes free)

Switch #dir flash:

Directory of flash:/

2 -rwx 4271779 Mar 1 1993 09:12:54 +09:00 c3550-i5q3l2-mz.121-22.EA7.bin

4 -rwx 1048 Apr 22 2020 13:04:10 +09:00 multiple-fs

5 -rwx 6719771 Feb 10 2011 17:05:48 +09:00 c3550-ipbase-mz.122-44.SE6.bin

6 -rwx 5 Apr 22 2020 13:04:10 +09:00 private-config.text

7 -rwx 11505 Apr 22 2020 13:04:10 +09:00 config.text

8 -rwx 0 Feb 10 2011 17:11:11 +09:00 env_vars

9 -rwx 42 Feb 10 2011 17:11:11 +09:00 system_env_vars

10 drwx 64 Nov 2 2020 15:14:55 +09:00 crashinfo_ext

12 drwx 64 Mar 1 1993 09:00:11 +09:00 crashinfo

14 -rwx 676 Mar 1 1993 09:01:11 +09:00 vlan.dat

15998976 bytes total (4686336 bytes free)

10월 05

django make migrations error. – table doesn’t exist

By snowffox in Memo(메모)

django app 에서 makemigrations 했을때, 테이블이 없다는 오류메시지가 나올때 처리방법.

(venv) D:\Python_Project\ipchaser\ipchaser>manage.py makemigrations chaser
Traceback (most recent call last):
  File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\db\backends\utils.py", line 86, in _execute
    return self.cursor.execute(sql, params)
  File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\db\backends\mysql\base.py", line 74, in execute
    return self.cursor.execute(query, args)
  File "D:\Python_Project\ipchaser\venv\lib\site-packages\MySQLdb\cursors.py", line 209, in execute
    res = self._query(query)
  File "D:\Python_Project\ipchaser\venv\lib\site-packages\MySQLdb\cursors.py", line 315, in _query
    db.query(q)
  File "D:\Python_Project\ipchaser\venv\lib\site-packages\MySQLdb\connections.py", line 239, in query
    _mysql.connection.query(self, query)
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'ipchaser.tools_macvendors' doesn't exist")

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

Traceback (most recent call last):
  File "D:\Python_Project\ipchaser\ipchaser\manage.py", line 21, in <module>
    main()
  File "D:\Python_Project\ipchaser\ipchaser\manage.py", line 17, in main
    execute_from_command_line(sys.argv)
  File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\core\management\__init__.py", line 401, in execute_from_command_line
    utility.execute()
  File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\core\management\__init__.py", line 395, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\core\management\base.py", line 328, in run_from_argv
    self.execute(*args, **cmd_options)
  File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\core\management\base.py", line 366, in execute
    self.check()
  File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\core\management\base.py", line 395, in check
    include_deployment_checks=include_deployment_checks,
  File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\core\management\base.py", line 382, in _run_checks
    return checks.run_checks(**kwargs)
  File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\core\checks\registry.py", line 72, in run_checks
    new_errors = check(app_configs=app_configs)
  File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\core\checks\urls.py", line 13, in check_url_config
    return check_resolver(resolver)
  File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\core\checks\urls.py", line 23, in check_resolver
    return check_method()
  File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\urls\resolvers.py", line 407, in check
    for pattern in self.url_patterns:
  File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\utils\functional.py", line 48, in __get__
    res = instance.__dict__[self.name] = self.func(instance)
  File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\urls\resolvers.py", line 588, in url_patterns
    patterns = getattr(self.urlconf_module, "urlpatterns", self.urlconf_module)
  File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\utils\functional.py", line 48, in __get__
    res = instance.__dict__[self.name] = self.func(instance)
  File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\urls\resolvers.py", line 581, in urlconf_module
    return import_module(self.urlconf_name)
  File "C:\Users\Works\AppData\Local\Programs\Python\Python37\lib\importlib\__init__.py", line 127, in import_module
    return _bootstrap._gcd_import(name[level:], package, level)
  File "<frozen importlib._bootstrap>", line 1006, in _gcd_import
  File "<frozen importlib._bootstrap>", line 983, in _find_and_load
  File "<frozen importlib._bootstrap>", line 967, in _find_and_load_unlocked
  File "<frozen importlib._bootstrap>", line 677, in _load_unlocked
  File "<frozen importlib._bootstrap_external>", line 728, in exec_module
  File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
  File "D:\Python_Project\ipchaser\ipchaser\ipchaser\urls.py", line 20, in <module>
    path('tools/', include('tools.urls')),
  File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\urls\conf.py", line 34, in include
    urlconf_module = import_module(urlconf_module)
  File "C:\Users\Works\AppData\Local\Programs\Python\Python37\lib\importlib\__init__.py", line 127, in import_module
    return _bootstrap._gcd_import(name[level:], package, level)
  File "<frozen importlib._bootstrap>", line 1006, in _gcd_import
  File "<frozen importlib._bootstrap>", line 983, in _find_and_load
  File "<frozen importlib._bootstrap>", line 967, in _find_and_load_unlocked
  File "<frozen importlib._bootstrap>", line 677, in _load_unlocked
  File "<frozen importlib._bootstrap_external>", line 728, in exec_module
  File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
  File "D:\Python_Project\ipchaser\ipchaser\tools\urls.py", line 2, in <module>
    from .views import DiffView, MacVenrorsView, WhoisSearch, DNSLookup
  File "D:\Python_Project\ipchaser\ipchaser\tools\views.py", line 23, in <module>
    class MacVenrorsView(View):
  File "D:\Python_Project\ipchaser\ipchaser\tools\views.py", line 26, in MacVenrorsView
    total = MacVendors.objects.count()
  File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\db\models\manager.py", line 82, in manager_method
    return getattr(self.get_queryset(), name)(*args, **kwargs)
  File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\db\models\query.py", line 397, in count
    return self.query.get_count(using=self.db)
  File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\db\models\sql\query.py", line 517, in get_count
    number = obj.get_aggregation(using, ['__count'])['__count']
  File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\db\models\sql\query.py", line 502, in get_aggregation
    result = compiler.execute_sql(SINGLE)
  File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\db\models\sql\compiler.py", line 1144, in execute_sql
    cursor.execute(sql, params)
  File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\db\backends\utils.py", line 100, in execute
    return super().execute(sql, params)
  File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\db\backends\utils.py", line 68, in execute
    return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
  File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\db\backends\utils.py", line 77, in _execute_with_wrappers
    return executor(sql, params, many, context)
  File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\db\backends\utils.py", line 86, in _execute
    return self.cursor.execute(sql, params)
  File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\db\utils.py", line 90, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\db\backends\utils.py", line 86, in _execute
    return self.cursor.execute(sql, params)
  File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\db\backends\mysql\base.py", line 74, in execute
    return self.cursor.execute(query, args)
  File "D:\Python_Project\ipchaser\venv\lib\site-packages\MySQLdb\cursors.py", line 209, in execute
    res = self._query(query)
  File "D:\Python_Project\ipchaser\venv\lib\site-packages\MySQLdb\cursors.py", line 315, in _query
    db.query(q)
  File "D:\Python_Project\ipchaser\venv\lib\site-packages\MySQLdb\connections.py", line 239, in query
    _mysql.connection.query(self, query)
django.db.utils.ProgrammingError: (1146, "Table 'ipchaser.tools_macvendors' doesn't exist")

100

101

102

103

104

105

106

(venv) D:\Python_Project\ipchaser\ipchaser>manage.py makemigrations chaser

Traceback (most recent call last):

File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\db\backends\utils.py", line 86, in _execute

return self.cursor.execute(sql, params)

File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\db\backends\mysql\base.py", line 74, in execute

return self.cursor.execute(query, args)

File "D:\Python_Project\ipchaser\venv\lib\site-packages\MySQLdb\cursors.py", line 209, in execute

res = self._query(query)

File "D:\Python_Project\ipchaser\venv\lib\site-packages\MySQLdb\cursors.py", line 315, in _query

db.query(q)

File "D:\Python_Project\ipchaser\venv\lib\site-packages\MySQLdb\connections.py", line 239, in query

_mysql.connection.query(self, query)

MySQLdb._exceptions.ProgrammingError: (1146, "Table 'ipchaser.tools_macvendors' doesn't exist")

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

Traceback (most recent call last):

File "D:\Python_Project\ipchaser\ipchaser\manage.py", line 21, in <module>

main()

File "D:\Python_Project\ipchaser\ipchaser\manage.py", line 17, in main

execute_from_command_line(sys.argv)

File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\core\management\__init__.py", line 401, in execute_from_command_line

utility.execute()

File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\core\management\__init__.py", line 395, in execute

self.fetch_command(subcommand).run_from_argv(self.argv)

File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\core\management\base.py", line 328, in run_from_argv

self.execute(*args, **cmd_options)

File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\core\management\base.py", line 366, in execute

self.check()

File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\core\management\base.py", line 395, in check

include_deployment_checks=include_deployment_checks,

File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\core\management\base.py", line 382, in _run_checks

return checks.run_checks(**kwargs)

File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\core\checks\registry.py", line 72, in run_checks

new_errors = check(app_configs=app_configs)

File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\core\checks\urls.py", line 13, in check_url_config

return check_resolver(resolver)

File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\core\checks\urls.py", line 23, in check_resolver

return check_method()

File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\urls\resolvers.py", line 407, in check

for pattern in self.url_patterns:

File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\utils\functional.py", line 48, in __get__

res = instance.__dict__[self.name] = self.func(instance)

File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\urls\resolvers.py", line 588, in url_patterns

patterns = getattr(self.urlconf_module, "urlpatterns", self.urlconf_module)

File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\utils\functional.py", line 48, in __get__

res = instance.__dict__[self.name] = self.func(instance)

File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\urls\resolvers.py", line 581, in urlconf_module

return import_module(self.urlconf_name)

File "C:\Users\Works\AppData\Local\Programs\Python\Python37\lib\importlib\__init__.py", line 127, in import_module

return _bootstrap._gcd_import(name[level:], package, level)

File "<frozen importlib._bootstrap>", line 1006, in _gcd_import

File "<frozen importlib._bootstrap>", line 983, in _find_and_load

File "<frozen importlib._bootstrap>", line 967, in _find_and_load_unlocked

File "<frozen importlib._bootstrap>", line 677, in _load_unlocked

File "<frozen importlib._bootstrap_external>", line 728, in exec_module

File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed

File "D:\Python_Project\ipchaser\ipchaser\ipchaser\urls.py", line 20, in <module>

path('tools/', include('tools.urls')),

File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\urls\conf.py", line 34, in include

urlconf_module = import_module(urlconf_module)

File "C:\Users\Works\AppData\Local\Programs\Python\Python37\lib\importlib\__init__.py", line 127, in import_module

return _bootstrap._gcd_import(name[level:], package, level)

File "<frozen importlib._bootstrap>", line 1006, in _gcd_import

File "<frozen importlib._bootstrap>", line 983, in _find_and_load

File "<frozen importlib._bootstrap>", line 967, in _find_and_load_unlocked

File "<frozen importlib._bootstrap>", line 677, in _load_unlocked

File "<frozen importlib._bootstrap_external>", line 728, in exec_module

File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed

File "D:\Python_Project\ipchaser\ipchaser\tools\urls.py", line 2, in <module>

from .views import DiffView, MacVenrorsView, WhoisSearch, DNSLookup

File "D:\Python_Project\ipchaser\ipchaser\tools\views.py", line 23, in <module>

class MacVenrorsView(View):

File "D:\Python_Project\ipchaser\ipchaser\tools\views.py", line 26, in MacVenrorsView

total = MacVendors.objects.count()

File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\db\models\manager.py", line 82, in manager_method

return getattr(self.get_queryset(), name)(*args, **kwargs)

File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\db\models\query.py", line 397, in count

return self.query.get_count(using=self.db)

File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\db\models\sql\query.py", line 517, in get_count

number = obj.get_aggregation(using, ['__count'])['__count']

File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\db\models\sql\query.py", line 502, in get_aggregation

result = compiler.execute_sql(SINGLE)

File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\db\models\sql\compiler.py", line 1144, in execute_sql

cursor.execute(sql, params)

File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\db\backends\utils.py", line 100, in execute

return super().execute(sql, params)

File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\db\backends\utils.py", line 68, in execute

return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)

File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\db\backends\utils.py", line 77, in _execute_with_wrappers

return executor(sql, params, many, context)

File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\db\backends\utils.py", line 86, in _execute

return self.cursor.execute(sql, params)

File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\db\utils.py", line 90, in __exit__

raise dj_exc_value.with_traceback(traceback) from exc_value

File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\db\backends\utils.py", line 86, in _execute

return self.cursor.execute(sql, params)

File "D:\Python_Project\ipchaser\venv\lib\site-packages\django\db\backends\mysql\base.py", line 74, in execute

return self.cursor.execute(query, args)

File "D:\Python_Project\ipchaser\venv\lib\site-packages\MySQLdb\cursors.py", line 209, in execute

res = self._query(query)

File "D:\Python_Project\ipchaser\venv\lib\site-packages\MySQLdb\cursors.py", line 315, in _query

db.query(q)

File "D:\Python_Project\ipchaser\venv\lib\site-packages\MySQLdb\connections.py", line 239, in query

_mysql.connection.query(self, query)

django.db.utils.ProgrammingError: (1146, "Table 'ipchaser.tools_macvendors' doesn't exist")

5월 16 2020

vmware tools 옛날버전 다운로드

By snowffox in Memo(메모)

vmware tools (vmware client) 옛날 버전은 아래 링크에서 다운로드 받을 수 있다. https://packages.vmware.com/tools/esx/

4월 05

Hyper-v VM을 vSphere에서 실행하도록 변환하기 [스크랩]

By snowffox in Memo(메모)

3월 14

참고문서:http:// https://www.cisco.com/c/en/us/support/docs/wireless/2000-series-wireless-lan-controllers/71094-wlcm-pwr.html 시스코 WLC(Wireless LAN Controller) 비밀번호를 모를때 초기화(?) 하는 방법으로 중요한것은 WLC 버전이 5.1 이상인지 아닌지가 중요하다. WLC 버전이 5.1이상인 경우는 정상적으로 부팅하고 Restore-Password 를 입력하면 새로운 사용자 계정을 등록할 수 있다. WLC 버전이 5.1 이전이면, 비밀번호를 초기화하는 방법은 공장초기화 뿐이며, 이 경우 설정또한 초기화되며 설정은 복구할 수 없으므로 주의해야한다. 초기화 후 다시 구성을 …

12월 04

HP smart array B120i 가 설치된 서버에 CentOS 7 설치 문제

By snowffox in H/W(하드웨어), Linux(리눅스), Memo(메모)

HP smart array B120i 가 설치된 서버에 CentOS 7 설치 문제 B120i raid 컨틀롤러에 2개의 HDD를 Raid-1 으로 구성하고 CentOS 7을 인스톨할때, HDD를 logical volume 한개로 인식하지 않고 2개의 물리적 디스크로 인식하는 문제가 발생했다. 이것은 CentOS 7부터 HP smart array를 지원하지 않기 때문에 발생한 문제이며, 설치전 드라이버를 미리 loading함으로써 해결 할 수 있다. 방법은 다운로드 …

2월 12

Hyper-v, Guest( windows server 2012R 2)부팅 문제

By snowffox in Memo(메모), Windows(M$윈도우)

HP DL380G9 서버, 윈도우 2012 R2를 Disk2vhd로 이미지 만든 후(vhdx 포맷) hyper-v 게스트로 만들었을때, 부팅 안되는 문제 발생 원인은 EFI 부트 영역이 이미지로 제대로 만들어지지 않아서 발생했고, 윈도우 CD로 부팅한 후에, EFI부트 영역을 만들어주면 정상적으로 부팅됨. 참고문서: https://social.technet.microsoft.com/Forums/windowsserver/en-US/9a668872-0f58-4da3-a407-2f2018d42b50/windows-server-2012-r2-datacenter-how-to-create-hyperv-which-will-be-the-replica-of-host-os?forum=winserverhyperv

12월 29

GNS3 vm VLAN tagging 문제

By snowffox in Memo(메모)

GNS3 vmware vm에서, IOU2(Cisco l2 switch) 및 EXOS(extreme switch) vlan tag(trunk port mode) 포트 통신 안되는 문제 확인 GNS3 vm에 로그인해서, 802.1q(VLAN) 커널 모듈 확인을 해 본 결과, vlan 모듈이 올라가지 않음을 확인. 아래 커맨드로 vlan 패키지를 설치

sudo apt-get install vlan
sudo modprobe 8021q

1 2	sudo apt-get install vlan sudo modprobe 8021q

lsmod 커맨드로 8021q 모듈 확인 이후 IOU2(Cisco 스위치)에서 vlan trunk 구성하면 통신 이상 없음. EXOS는 tagged …

12월 17

GNU parallel 사용 예.

By snowffox in Linux(리눅스), Memo(메모)

GNU parallel 사용 예 GNU parallel은 하나 이상의 컴퓨터를 사용하여 작업을 병렬로 실행하기위한 쉘 도구이다. 작업(job)은 입력의 각 행에 대해 실행할 단일 명령 또는 스크립트이다. 전형적인 입력은 파일 목록, 호스트 목록, 사용자 목록, URL 목록 또는 표 목록이다. 작업은 파이프에서 읽은 명령어일 수도 있다. GNU parallel은 입력을 분리하여 병렬로 명령을 파이프 할 수도 있다. 사용법: …

11월 30

Cisco 스위치 맥어드레스 유지시간

By snowffox in Memo(메모), Network(네트워크)

Cisco 스위치의 맥어드레스 유지 시간을 확인하는 방법. 맥어드레스 테이블의 aging-time 을 확인하면 됨. 기본값은 5분(300초)이며, 아래와 같이 확인 할 수 있다.

switch#show mac address-table aging-time 
Global Aging Time:  300
Vlan    Aging Time
----    ----------

switch#show mac address-table aging-time

Global Aging Time: 300

Vlan Aging Time

---- ----------

Category: Memo(메모)

C3550 Software Forced Crash Exception (0x0700) – 결국 고장남.

django make migrations error. – table doesn’t exist

vmware tools 옛날버전 다운로드

Hyper-v VM을 vSphere에서 실행하도록 변환하기 [스크랩]

시스코 WLC 비밀번호 초기화

HP smart array B120i 가 설치된 서버에 CentOS 7 설치 문제

Hyper-v, Guest( windows server 2012R 2)부팅 문제

GNS3 vm VLAN tagging 문제

GNU parallel 사용 예.

Cisco 스위치 맥어드레스 유지시간

카테고리

최근 글

Category: Memo(메모)

카테고리

최근 글

태그