You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
virt/virsh_panel/ssh_keys.py

166 lines
6.1 KiB
Python

"""Per-account OpenSSH public keys for cloud-image guest access.
Only public key material is stored. Every lookup and mutation includes the
authenticated user's database ID, so an ID from another account is not an
authorization bypass. The unique fingerprint is calculated from the decoded
SSH wire-format blob, independent of whitespace or a trailing comment.
"""
from __future__ import annotations
import base64
import hashlib
import time
from typing import Any
from .cloud_init import _validate_ssh_public_key
from .database import DatabaseError, DatabaseStore, pymysql
class SSHKeyError(Exception):
def __init__(self, message: str, status: int = 400) -> None:
super().__init__(message)
self.status = status
def _user_id(value: int) -> int:
if isinstance(value, bool) or not isinstance(value, int) or value < 1:
raise ValueError("Invalid user ID")
return value
def _key_id(value: int) -> int:
if isinstance(value, bool) or not isinstance(value, int) or value < 1:
raise ValueError("Invalid SSH key ID")
return value
def _name(value: str) -> str:
if (not isinstance(value, str) or value != value.strip()
or not 1 <= len(value) <= 80
or any(ord(char) < 32 or ord(char) == 127 for char in value)):
raise SSHKeyError("公钥名称须为 1 至 80 个非控制字符")
return value
def _public_key(value: str) -> tuple[str, str]:
try:
validated = _validate_ssh_public_key(value)
except ValueError as exc:
raise SSHKeyError(str(exc)) from exc
key_type, encoded = validated.split(maxsplit=2)[:2]
blob = base64.b64decode(encoded, validate=True)
# Comments are operator hints, not key material. The user-chosen name is
# retained instead, and the canonical form avoids charset surprises.
canonical = f"{key_type} {base64.b64encode(blob).decode('ascii')}"
fingerprint = "SHA256:" + base64.b64encode(hashlib.sha256(blob).digest()).decode("ascii").rstrip("=")
return canonical, fingerprint
def _row(row: dict[str, Any] | None) -> dict[str, Any] | None:
if row is None:
return None
return {
"id": int(row["id"]),
"name": row["name"],
"public_key": row["public_key"],
"fingerprint": row["fingerprint"],
"created_at": int(row["created_at"]),
}
class DatabaseSSHKeyStore:
"""MariaDB-backed key library with owner-scoped SQL queries."""
def __init__(self, store: DatabaseStore) -> None:
self._store = store
def _connect(self):
return self._store._connect()
def list_for_user(self, user_id: int) -> list[dict[str, Any]]:
_user_id(user_id)
connection = self._connect()
try:
with connection.cursor() as cursor:
cursor.execute(
"SELECT id, name, public_key, fingerprint, created_at "
"FROM user_ssh_keys WHERE user_id=%s ORDER BY created_at DESC, id DESC",
(user_id,),
)
return [_row(row) for row in cursor.fetchall()]
except pymysql.MySQLError as exc:
raise DatabaseError("无法读取 SSH 公钥") from exc
finally:
connection.close()
def create_for_user(self, user_id: int, name: str, public_key: str,
*, now: int | None = None) -> dict[str, Any]:
_user_id(user_id)
name = _name(name)
public_key, fingerprint = _public_key(public_key)
timestamp = int(time.time()) if now is None else now
if isinstance(timestamp, bool) or not isinstance(timestamp, int) or timestamp < 0:
raise ValueError("Invalid SSH key creation time")
connection = self._connect()
try:
with connection.cursor() as cursor:
cursor.execute(
"INSERT INTO user_ssh_keys "
"(user_id, name, public_key, fingerprint, created_at) "
"VALUES (%s, %s, %s, %s, %s)",
(user_id, name, public_key, fingerprint, timestamp),
)
key_id = cursor.lastrowid
connection.commit()
return {
"id": key_id, "name": name, "public_key": public_key,
"fingerprint": fingerprint, "created_at": timestamp,
}
except pymysql.err.IntegrityError as exc:
connection.rollback()
if exc.args and exc.args[0] == 1062:
raise SSHKeyError("此 SSH 公钥已添加到当前账户", 409) from exc
raise DatabaseError("无法保存 SSH 公钥") from exc
except pymysql.MySQLError as exc:
connection.rollback()
raise DatabaseError("无法保存 SSH 公钥") from exc
finally:
connection.close()
def get_for_user(self, user_id: int, key_id: int) -> dict[str, Any] | None:
_user_id(user_id)
_key_id(key_id)
connection = self._connect()
try:
with connection.cursor() as cursor:
cursor.execute(
"SELECT id, name, public_key, fingerprint, created_at "
"FROM user_ssh_keys WHERE user_id=%s AND id=%s",
(user_id, key_id),
)
return _row(cursor.fetchone())
except pymysql.MySQLError as exc:
raise DatabaseError("无法读取 SSH 公钥") from exc
finally:
connection.close()
def delete_for_user(self, user_id: int, key_id: int) -> bool:
_user_id(user_id)
_key_id(key_id)
connection = self._connect()
try:
with connection.cursor() as cursor:
cursor.execute(
"DELETE FROM user_ssh_keys WHERE user_id=%s AND id=%s",
(user_id, key_id),
)
deleted = cursor.rowcount > 0
connection.commit()
return deleted
except pymysql.MySQLError as exc:
connection.rollback()
raise DatabaseError("无法删除 SSH 公钥") from exc
finally:
connection.close()