-
- 안녕하세요.
-
- 휴일인데도 시간을 내어 주심에 감사 드립니다.
-
Requirement already satisfied: psycopg2-binary==2.9.9 in ./venv/lib/python3.9/site-packages (from -r requirements.txt (line 59)) (2.9.9)
Requirement already satisfied: lxml==5.1.0 in ./venv/lib/python3.9/site-packages (from -r requirements.txt (line 60)) (5.1.0)
Requirement already satisfied: pbr>=1.8 in ./venv/lib/python3.9/site-packages (from testresources>=2.0.1->-r requirements.txt (line 48)) (6.0.0)
Requirement already satisfied: tzlocal!=3.*,>=2.0 in ./venv/lib/python3.9/site-packages (from APScheduler>=3.10.0->-r requirements.txt (line 57)) (5.2)
root@HumanpcNAS:/mnt/VOL1/base2# INFO: Will watch for changes in these directories: ['/mnt/VOL1/base2']
ERROR: [Errno 98] Address already in use
root@HumanpcNAS:/mnt/VOL1/base2#
-
- 위와 같은 에러가 발생하며 안 됩니다.
-
- 만약 저 port를 죽이면 -
root@HumanpcNAS:/mnt/VOL1/base2# kill -9 202857
root@HumanpcNAS:/mnt/VOL1/base2# bash start_uvi.sh
-
이렇게 서버가 정상 실행은 되나 -
root@HumanpcNAS:/mnt/VOL1/base2# INFO: Will watch for changes in these directories: ['/mnt/VOL1/base2']
INFO: Uvicorn running on http://0.0.0.0:66 (Press CTRL+C to quit)
INFO: Started reloader process [341138] using StatReload
INFO: Started server process [341140]
INFO: Waiting for application startup.
INFO: Application startup complete.
-웹페이지(
https://m.glitter.kr)가 링크(
https://policy.glitter.kr/qa_php/Server_Error.png )의 캡쳐처럼
> > >500 Server Error가 나면서 쉘 창에는 아래와 같은 에러가 - 주루룩 쏟아집니다.
cursor.execute(statement, parameters)
File "/mnt/VOL1/base2/venv/lib/python3.9/site-packages/pymysql/cursors.py", line 153, in execute
result = self._query(query)
File "/mnt/VOL1/base2/venv/lib/python3.9/site-packages/pymysql/cursors.py", line 322, in _query
conn.query(q)
File "/mnt/VOL1/base2/venv/lib/python3.9/site-packages/pymysql/connections.py", line 558, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/mnt/VOL1/base2/venv/lib/python3.9/site-packages/pymysql/connections.py", line 822, in _read_query_result
result.read()
File "/mnt/VOL1/base2/venv/lib/python3.9/site-packages/pymysql/connections.py", line 1200, in read
first_packet = self.connection._read_packet()
File "/mnt/VOL1/base2/venv/lib/python3.9/site-packages/pymysql/connections.py", line 772, in _read_packet
packet.raise_for_error()
File "/mnt/VOL1/base2/venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/mnt/VOL1/base2/venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1054, "Unknown column 'g5_poll.po_use' in 'field list'")
[SQL: SELECT g5_poll.po_id, g5_poll.po_subject, g5_poll.po_poll1, g5_poll.po_poll2, g5_poll.po_poll3, g5_poll.po_poll4, g5_poll.po_poll5, g5_poll.po_poll6, g5_poll.po_poll7, g5_poll.po_poll8, g5_poll.po_poll9, g5_poll.po_cnt1, g5_poll.po_cnt2, g5_poll.po_cnt3, g5_poll.po_cnt4, g5_poll.po_cnt5, g5_poll.po_cnt6, g5_poll.po_cnt7, g5_poll.po_cnt8, g5_poll.po_cnt9, g5_poll.po_etc, g5_poll.po_level, g5_poll.po_point, g5_poll.po_date, g5_poll.po_ips, g5_poll.mb_ids, g5_poll.po_use
FROM g5_poll
WHERE g5_poll.po_use = %(po_use_1)s ORDER BY g5_poll.po_id DESC]
[parameters: {'po_use_1': 1}]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
INFO: 192.168.0.252:55958 - "GET /favicon.ico HTTP/1.1" 404 Not Found
-
- .env 만를 지우는 재설치도 안 됩니다.
- ㅠ ㅠ ㅠ ㅠ ㅠ
-
- 결국은 처음부터 재설치를 해야합니다.
- 기존의 서버구동으로는 어떤 작동도 하지 않습니다.
-
===
- 아마도, G5의 DB를 가져와서 그런 것 같기도 합니다. !!!!
- 그누보드5의 DB(G5_)를 사용하지 않으면, 아래와 같이 메일서버가 잘 작동합니다.
Requirement already satisfied: pip in ./venv/lib/python3.9/site-packages (24.0)
INFO: Will watch for changes in these directories: ['/mnt/VOL1/base2']
INFO: Uvicorn running on http://0.0.0.0:66 (Press CTRL+C to quit)
INFO: Started reloader process [360520] using StatReload
INFO: Started server process [360526]
INFO: Waiting for application startup.
INFO: Application startup complete.
INFO: 192.168.0.252:61362 - "GET / HTTP/1.1" 200 OK
INFO: 192.168.0.252:61361 - "GET / HTTP/1.1" 200 OK
INFO: 192.168.0.252:61367 - "GET /admin HTTP/1.1" 307 Temporary Redirect
INFO: 192.168.0.252:61367 - "GET /admin/ HTTP/1.1" 200 OK
INFO: 192.168.0.252:61367 - "GET /admin/sendmail_test HTTP/1.1" 200 OK
INFO: 192.168.0.252:61367 - "POST /generate_token HTTP/1.1" 200 OK
INFO: 192.168.0.252:61367 - "POST /admin/sendmail_test_result HTTP/1.1" 200 OK
-