auth.py 23 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623
  1. from datetime import timedelta
  2. from fastapi import APIRouter, Depends, HTTPException, status
  3. from sqlalchemy import select
  4. from sqlalchemy.ext.asyncio import AsyncSession
  5. from sqlalchemy.orm import selectinload
  6. from backend.app.api.routes.settings import get_external_login_url
  7. from backend.app.core.auth import (
  8. ACCESS_TOKEN_EXPIRE_MINUTES,
  9. Permission,
  10. RequirePermissionIfAuthEnabled,
  11. authenticate_user,
  12. authenticate_user_by_email,
  13. create_access_token,
  14. get_current_active_user,
  15. get_password_hash,
  16. get_user_by_email,
  17. get_user_by_username,
  18. )
  19. from backend.app.core.database import get_db
  20. from backend.app.models.group import Group
  21. from backend.app.models.settings import Settings
  22. from backend.app.models.user import User
  23. from backend.app.schemas.auth import (
  24. ForgotPasswordRequest,
  25. ForgotPasswordResponse,
  26. GroupBrief,
  27. LoginRequest,
  28. LoginResponse,
  29. ResetPasswordRequest,
  30. ResetPasswordResponse,
  31. SetupRequest,
  32. SetupResponse,
  33. SMTPSettings,
  34. TestSMTPRequest,
  35. TestSMTPResponse,
  36. UserResponse,
  37. )
  38. from backend.app.services.email_service import (
  39. create_password_reset_email_from_template,
  40. generate_secure_password,
  41. get_smtp_settings,
  42. save_smtp_settings,
  43. send_email,
  44. )
  45. def _user_to_response(user: User) -> UserResponse:
  46. """Convert a User model to UserResponse schema."""
  47. return UserResponse(
  48. id=user.id,
  49. username=user.username,
  50. email=user.email,
  51. role=user.role,
  52. is_active=user.is_active,
  53. is_admin=user.is_admin,
  54. groups=[GroupBrief(id=g.id, name=g.name) for g in user.groups],
  55. permissions=sorted(user.get_permissions()),
  56. created_at=user.created_at.isoformat(),
  57. )
  58. router = APIRouter(prefix="/auth", tags=["authentication"])
  59. async def is_auth_enabled(db: AsyncSession) -> bool:
  60. """Check if authentication is enabled."""
  61. result = await db.execute(select(Settings).where(Settings.key == "auth_enabled"))
  62. setting = result.scalar_one_or_none()
  63. if setting is None:
  64. return False
  65. return setting.value.lower() == "true"
  66. async def is_advanced_auth_enabled(db: AsyncSession) -> bool:
  67. """Check if advanced authentication is enabled."""
  68. result = await db.execute(select(Settings).where(Settings.key == "advanced_auth_enabled"))
  69. setting = result.scalar_one_or_none()
  70. if setting is None:
  71. return False
  72. return setting.value.lower() == "true"
  73. async def set_advanced_auth_enabled(db: AsyncSession, enabled: bool) -> None:
  74. """Set advanced authentication enabled status."""
  75. from sqlalchemy import func
  76. from sqlalchemy.dialects.sqlite import insert as sqlite_insert
  77. stmt = sqlite_insert(Settings).values(key="advanced_auth_enabled", value="true" if enabled else "false")
  78. stmt = stmt.on_conflict_do_update(
  79. index_elements=["key"], set_={"value": "true" if enabled else "false", "updated_at": func.now()}
  80. )
  81. await db.execute(stmt)
  82. async def set_auth_enabled(db: AsyncSession, enabled: bool) -> None:
  83. """Set authentication enabled status."""
  84. from sqlalchemy import func
  85. from sqlalchemy.dialects.sqlite import insert as sqlite_insert
  86. stmt = sqlite_insert(Settings).values(key="auth_enabled", value="true" if enabled else "false")
  87. stmt = stmt.on_conflict_do_update(
  88. index_elements=["key"], set_={"value": "true" if enabled else "false", "updated_at": func.now()}
  89. )
  90. await db.execute(stmt)
  91. # Note: Don't commit here - let get_db handle it or commit explicitly in the route
  92. async def is_setup_completed(db: AsyncSession) -> bool:
  93. """Check if setup has been completed."""
  94. result = await db.execute(select(Settings).where(Settings.key == "setup_completed"))
  95. setting = result.scalar_one_or_none()
  96. return setting and setting.value.lower() == "true"
  97. async def set_setup_completed(db: AsyncSession, completed: bool) -> None:
  98. """Set setup completed status."""
  99. from sqlalchemy import func
  100. from sqlalchemy.dialects.sqlite import insert as sqlite_insert
  101. stmt = sqlite_insert(Settings).values(key="setup_completed", value="true" if completed else "false")
  102. stmt = stmt.on_conflict_do_update(
  103. index_elements=["key"], set_={"value": "true" if completed else "false", "updated_at": func.now()}
  104. )
  105. await db.execute(stmt)
  106. # Note: Don't commit here - let get_db handle it or commit explicitly in the route
  107. @router.post("/setup", response_model=SetupResponse)
  108. async def setup_auth(request: SetupRequest, db: AsyncSession = Depends(get_db)):
  109. """First-time setup: enable/disable authentication and create admin user."""
  110. import logging
  111. logger = logging.getLogger(__name__)
  112. try:
  113. # If auth_enabled is true but no users exist, allow re-setup (recovery scenario)
  114. admin_created = False
  115. if request.auth_enabled:
  116. # Check if admin users already exist
  117. admin_users_result = await db.execute(select(User).where(User.role == "admin"))
  118. existing_admin_users = list(admin_users_result.scalars().all())
  119. has_admin_users = len(existing_admin_users) > 0
  120. if has_admin_users:
  121. # Admin users already exist, just enable auth (don't create new admin)
  122. logger.info(
  123. f"Admin users already exist ({len(existing_admin_users)} found), enabling authentication without creating new admin"
  124. )
  125. admin_created = False
  126. else:
  127. # No admin users exist, require admin credentials to create first admin
  128. if not request.admin_username or not request.admin_password:
  129. raise HTTPException(
  130. status_code=status.HTTP_400_BAD_REQUEST,
  131. detail="Admin username and password are required when enabling authentication (no admin users exist)",
  132. )
  133. # Check if username already exists (shouldn't happen if no admin users exist, but check anyway)
  134. existing_user = await get_user_by_username(db, request.admin_username)
  135. if existing_user:
  136. raise HTTPException(
  137. status_code=status.HTTP_400_BAD_REQUEST,
  138. detail="User with this username already exists",
  139. )
  140. # Create admin user FIRST (before enabling auth)
  141. try:
  142. logger.info("Creating admin user: %s", request.admin_username)
  143. admin_user = User(
  144. username=request.admin_username,
  145. password_hash=get_password_hash(request.admin_password),
  146. role="admin",
  147. is_active=True,
  148. )
  149. # Try to add user to Administrators group if it exists
  150. admin_group_result = await db.execute(select(Group).where(Group.name == "Administrators"))
  151. admin_group = admin_group_result.scalar_one_or_none()
  152. if admin_group:
  153. admin_user.groups.append(admin_group)
  154. logger.info("Added new admin user to Administrators group")
  155. db.add(admin_user)
  156. logger.info("Admin user added to session: %s", request.admin_username)
  157. admin_created = True
  158. except Exception as e:
  159. await db.rollback()
  160. logger.error("Failed to create admin user: %s", e, exc_info=True)
  161. raise HTTPException(
  162. status_code=status.HTTP_500_INTERNAL_SERVER_ERROR,
  163. detail=f"Failed to create admin user: {str(e)}",
  164. )
  165. # Set auth enabled and mark setup as completed
  166. await set_auth_enabled(db, request.auth_enabled)
  167. await set_setup_completed(db, True)
  168. await db.commit()
  169. if admin_created:
  170. await db.refresh(admin_user)
  171. logger.info("Admin user created successfully: %s", admin_user.id)
  172. logger.info("Setup completed: auth_enabled=%s, admin_created=%s", request.auth_enabled, admin_created)
  173. return SetupResponse(auth_enabled=request.auth_enabled, admin_created=admin_created)
  174. except HTTPException:
  175. raise
  176. except Exception as e:
  177. logger.error("Setup error: %s", e, exc_info=True)
  178. await db.rollback()
  179. raise HTTPException(
  180. status_code=status.HTTP_500_INTERNAL_SERVER_ERROR,
  181. detail=f"Setup failed: {str(e)}",
  182. )
  183. @router.get("/status")
  184. async def get_auth_status(db: AsyncSession = Depends(get_db)):
  185. """Get authentication status (public endpoint)."""
  186. auth_enabled = await is_auth_enabled(db)
  187. setup_completed = await is_setup_completed(db)
  188. # Only require setup if it hasn't been completed yet
  189. requires_setup = not setup_completed
  190. return {"auth_enabled": auth_enabled, "requires_setup": requires_setup}
  191. @router.post("/disable", response_model=dict)
  192. async def disable_auth(
  193. current_user: User = Depends(get_current_active_user),
  194. db: AsyncSession = Depends(get_db),
  195. ):
  196. """Disable authentication (admin only)."""
  197. import logging
  198. logger = logging.getLogger(__name__)
  199. # Reload user with groups for proper is_admin check
  200. result = await db.execute(select(User).where(User.id == current_user.id).options(selectinload(User.groups)))
  201. user = result.scalar_one()
  202. # Only admins can disable authentication
  203. if not user.is_admin:
  204. raise HTTPException(
  205. status_code=status.HTTP_403_FORBIDDEN,
  206. detail="Only admins can disable authentication",
  207. )
  208. try:
  209. await set_auth_enabled(db, False)
  210. await db.commit()
  211. logger.info("Authentication disabled by admin user: %s", user.username)
  212. return {"message": "Authentication disabled successfully", "auth_enabled": False}
  213. except Exception as e:
  214. await db.rollback()
  215. logger.error("Failed to disable authentication: %s", e, exc_info=True)
  216. raise HTTPException(
  217. status_code=status.HTTP_500_INTERNAL_SERVER_ERROR,
  218. detail=f"Failed to disable authentication: {str(e)}",
  219. )
  220. @router.post("/login", response_model=LoginResponse)
  221. async def login(request: LoginRequest, db: AsyncSession = Depends(get_db)):
  222. """Login and get access token.
  223. Supports username or email-based login. Username lookup is case-insensitive.
  224. """
  225. # Check if auth is enabled
  226. auth_enabled = await is_auth_enabled(db)
  227. if not auth_enabled:
  228. raise HTTPException(
  229. status_code=status.HTTP_400_BAD_REQUEST,
  230. detail="Authentication is not enabled",
  231. )
  232. # Try username-based authentication first
  233. user = await authenticate_user(db, request.username, request.password)
  234. # If username auth failed and advanced auth is enabled, try email-based authentication
  235. if not user:
  236. advanced_auth = await is_advanced_auth_enabled(db)
  237. if advanced_auth:
  238. user = await authenticate_user_by_email(db, request.username, request.password)
  239. if not user:
  240. raise HTTPException(
  241. status_code=status.HTTP_401_UNAUTHORIZED,
  242. detail="Incorrect username or password",
  243. headers={"WWW-Authenticate": "Bearer"},
  244. )
  245. # Reload user with groups for proper permission calculation
  246. result = await db.execute(select(User).where(User.id == user.id).options(selectinload(User.groups)))
  247. user = result.scalar_one()
  248. access_token_expires = timedelta(minutes=ACCESS_TOKEN_EXPIRE_MINUTES)
  249. access_token = create_access_token(data={"sub": user.username}, expires_delta=access_token_expires)
  250. return LoginResponse(
  251. access_token=access_token,
  252. token_type="bearer",
  253. user=_user_to_response(user),
  254. )
  255. @router.get("/me", response_model=UserResponse)
  256. async def get_current_user_info(
  257. current_user: User = Depends(get_current_active_user),
  258. db: AsyncSession = Depends(get_db),
  259. ):
  260. """Get current user information."""
  261. # Reload user with groups for proper permission calculation
  262. result = await db.execute(select(User).where(User.id == current_user.id).options(selectinload(User.groups)))
  263. user = result.scalar_one()
  264. return _user_to_response(user)
  265. @router.post("/logout")
  266. async def logout():
  267. """Logout (client should discard token)."""
  268. return {"message": "Logged out successfully"}
  269. # Advanced Authentication Endpoints
  270. @router.post("/smtp/test", response_model=TestSMTPResponse)
  271. async def test_smtp_connection(
  272. test_request: TestSMTPRequest,
  273. current_user: User | None = RequirePermissionIfAuthEnabled(Permission.SETTINGS_UPDATE),
  274. db: AsyncSession = Depends(get_db),
  275. ):
  276. """Test SMTP connection with provided settings (admin only when auth enabled)."""
  277. import logging
  278. logger = logging.getLogger(__name__)
  279. try:
  280. smtp_settings = SMTPSettings(
  281. smtp_host=test_request.smtp_host,
  282. smtp_port=test_request.smtp_port,
  283. smtp_username=test_request.smtp_username,
  284. smtp_password=test_request.smtp_password,
  285. smtp_security=test_request.smtp_security,
  286. smtp_auth_enabled=test_request.smtp_auth_enabled,
  287. smtp_from_email=test_request.smtp_from_email,
  288. )
  289. # Send test email
  290. send_email(
  291. smtp_settings=smtp_settings,
  292. to_email=test_request.test_recipient,
  293. subject="BamBuddy SMTP Test",
  294. body_text="This is a test email from BamBuddy. If you received this, your SMTP settings are working correctly!",
  295. body_html="<p>This is a test email from <strong>BamBuddy</strong>.</p><p>If you received this, your SMTP settings are working correctly!</p>",
  296. )
  297. logger.info(f"Test email sent successfully to {test_request.test_recipient}")
  298. return TestSMTPResponse(success=True, message="Test email sent successfully")
  299. except Exception as e:
  300. logger.error(f"Failed to send test email: {e}")
  301. return TestSMTPResponse(success=False, message=f"Failed to send test email: {str(e)}")
  302. @router.get("/smtp", response_model=SMTPSettings | None)
  303. async def get_smtp_config(
  304. current_user: User | None = RequirePermissionIfAuthEnabled(Permission.SETTINGS_READ),
  305. db: AsyncSession = Depends(get_db),
  306. ):
  307. """Get SMTP settings (admin only when auth enabled). Password is not returned."""
  308. smtp_settings = await get_smtp_settings(db)
  309. if smtp_settings:
  310. # Don't return password in response
  311. smtp_settings.smtp_password = None
  312. return smtp_settings
  313. @router.post("/smtp", response_model=dict)
  314. async def save_smtp_config(
  315. smtp_settings: SMTPSettings,
  316. current_user: User | None = RequirePermissionIfAuthEnabled(Permission.SETTINGS_UPDATE),
  317. db: AsyncSession = Depends(get_db),
  318. ):
  319. """Save SMTP settings (admin only when auth enabled)."""
  320. import logging
  321. logger = logging.getLogger(__name__)
  322. try:
  323. await save_smtp_settings(db, smtp_settings)
  324. await db.commit()
  325. logger.info(f"SMTP settings updated by admin user: {current_user.username if current_user else 'anonymous'}")
  326. return {"message": "SMTP settings saved successfully"}
  327. except Exception as e:
  328. await db.rollback()
  329. logger.error(f"Failed to save SMTP settings: {e}")
  330. raise HTTPException(
  331. status_code=status.HTTP_500_INTERNAL_SERVER_ERROR,
  332. detail=f"Failed to save SMTP settings: {str(e)}",
  333. )
  334. @router.post("/advanced-auth/enable", response_model=dict)
  335. async def enable_advanced_auth(
  336. current_user: User = Depends(get_current_active_user),
  337. db: AsyncSession = Depends(get_db),
  338. ):
  339. """Enable advanced authentication (admin only).
  340. Requires SMTP settings to be configured and tested first.
  341. """
  342. import logging
  343. logger = logging.getLogger(__name__)
  344. # Reload user with groups for proper is_admin check
  345. result = await db.execute(select(User).where(User.id == current_user.id).options(selectinload(User.groups)))
  346. user = result.scalar_one()
  347. if not user.is_admin:
  348. raise HTTPException(
  349. status_code=status.HTTP_403_FORBIDDEN,
  350. detail="Only admins can enable advanced authentication",
  351. )
  352. # Verify SMTP settings are configured
  353. smtp_settings = await get_smtp_settings(db)
  354. if not smtp_settings:
  355. raise HTTPException(
  356. status_code=status.HTTP_400_BAD_REQUEST,
  357. detail="SMTP settings must be configured before enabling advanced authentication",
  358. )
  359. try:
  360. await set_advanced_auth_enabled(db, True)
  361. await db.commit()
  362. logger.info(f"Advanced authentication enabled by admin user: {user.username}")
  363. return {"message": "Advanced authentication enabled successfully", "advanced_auth_enabled": True}
  364. except Exception as e:
  365. await db.rollback()
  366. logger.error(f"Failed to enable advanced authentication: {e}")
  367. raise HTTPException(
  368. status_code=status.HTTP_500_INTERNAL_SERVER_ERROR,
  369. detail=f"Failed to enable advanced authentication: {str(e)}",
  370. )
  371. @router.post("/advanced-auth/disable", response_model=dict)
  372. async def disable_advanced_auth(
  373. current_user: User = Depends(get_current_active_user),
  374. db: AsyncSession = Depends(get_db),
  375. ):
  376. """Disable advanced authentication (admin only)."""
  377. import logging
  378. logger = logging.getLogger(__name__)
  379. # Reload user with groups for proper is_admin check
  380. result = await db.execute(select(User).where(User.id == current_user.id).options(selectinload(User.groups)))
  381. user = result.scalar_one()
  382. if not user.is_admin:
  383. raise HTTPException(
  384. status_code=status.HTTP_403_FORBIDDEN,
  385. detail="Only admins can disable advanced authentication",
  386. )
  387. try:
  388. await set_advanced_auth_enabled(db, False)
  389. await db.commit()
  390. logger.info(f"Advanced authentication disabled by admin user: {user.username}")
  391. return {"message": "Advanced authentication disabled successfully", "advanced_auth_enabled": False}
  392. except Exception as e:
  393. await db.rollback()
  394. logger.error(f"Failed to disable advanced authentication: {e}")
  395. raise HTTPException(
  396. status_code=status.HTTP_500_INTERNAL_SERVER_ERROR,
  397. detail=f"Failed to disable advanced authentication: {str(e)}",
  398. )
  399. @router.get("/advanced-auth/status")
  400. async def get_advanced_auth_status(db: AsyncSession = Depends(get_db)):
  401. """Get advanced authentication status."""
  402. advanced_auth_enabled = await is_advanced_auth_enabled(db)
  403. smtp_configured = await get_smtp_settings(db) is not None
  404. return {
  405. "advanced_auth_enabled": advanced_auth_enabled,
  406. "smtp_configured": smtp_configured,
  407. }
  408. @router.post("/forgot-password", response_model=ForgotPasswordResponse)
  409. async def forgot_password(request: ForgotPasswordRequest, db: AsyncSession = Depends(get_db)):
  410. """Request password reset via email (advanced auth only)."""
  411. import logging
  412. logger = logging.getLogger(__name__)
  413. # Check if advanced auth is enabled
  414. advanced_auth = await is_advanced_auth_enabled(db)
  415. if not advanced_auth:
  416. raise HTTPException(
  417. status_code=status.HTTP_400_BAD_REQUEST,
  418. detail="Advanced authentication is not enabled",
  419. )
  420. # Get SMTP settings
  421. smtp_settings = await get_smtp_settings(db)
  422. if not smtp_settings:
  423. raise HTTPException(
  424. status_code=status.HTTP_500_INTERNAL_SERVER_ERROR,
  425. detail="Email service is not configured",
  426. )
  427. # Find user by email
  428. user = await get_user_by_email(db, request.email)
  429. # Always return success message to prevent email enumeration
  430. # but only send email if user exists
  431. if user and user.is_active:
  432. try:
  433. # Generate new password
  434. new_password = generate_secure_password()
  435. user.password_hash = get_password_hash(new_password)
  436. await db.commit()
  437. login_url = await get_external_login_url(db)
  438. # Send password reset email
  439. subject, text_body, html_body = await create_password_reset_email_from_template(
  440. db, user.username, new_password, login_url
  441. )
  442. send_email(smtp_settings, user.email, subject, text_body, html_body)
  443. logger.info(f"Password reset email sent to {user.email}")
  444. except Exception as e:
  445. logger.error(f"Failed to send password reset email: {e}")
  446. # Don't reveal error to user for security
  447. return ForgotPasswordResponse(
  448. message="If the email address is associated with an account, a password reset email has been sent."
  449. )
  450. @router.post("/reset-password", response_model=ResetPasswordResponse)
  451. async def reset_user_password(
  452. request: ResetPasswordRequest,
  453. current_user: User = Depends(get_current_active_user),
  454. db: AsyncSession = Depends(get_db),
  455. ):
  456. """Reset a user's password and send them an email (admin only, advanced auth only)."""
  457. import logging
  458. logger = logging.getLogger(__name__)
  459. # Reload user with groups for proper is_admin check
  460. result = await db.execute(select(User).where(User.id == current_user.id).options(selectinload(User.groups)))
  461. admin_user = result.scalar_one()
  462. if not admin_user.is_admin:
  463. raise HTTPException(
  464. status_code=status.HTTP_403_FORBIDDEN,
  465. detail="Only admins can reset user passwords",
  466. )
  467. # Check if advanced auth is enabled
  468. advanced_auth = await is_advanced_auth_enabled(db)
  469. if not advanced_auth:
  470. raise HTTPException(
  471. status_code=status.HTTP_400_BAD_REQUEST,
  472. detail="Advanced authentication is not enabled",
  473. )
  474. # Get SMTP settings
  475. smtp_settings = await get_smtp_settings(db)
  476. if not smtp_settings:
  477. raise HTTPException(
  478. status_code=status.HTTP_500_INTERNAL_SERVER_ERROR,
  479. detail="Email service is not configured",
  480. )
  481. # Find user to reset
  482. result = await db.execute(select(User).where(User.id == request.user_id))
  483. user = result.scalar_one_or_none()
  484. if not user:
  485. raise HTTPException(
  486. status_code=status.HTTP_404_NOT_FOUND,
  487. detail="User not found",
  488. )
  489. if not user.email:
  490. raise HTTPException(
  491. status_code=status.HTTP_400_BAD_REQUEST,
  492. detail="User does not have an email address configured",
  493. )
  494. try:
  495. # Generate new password
  496. new_password = generate_secure_password()
  497. user.password_hash = get_password_hash(new_password)
  498. await db.commit()
  499. login_url = await get_external_login_url(db)
  500. # Send password reset email
  501. subject, text_body, html_body = await create_password_reset_email_from_template(
  502. db, user.username, new_password, login_url
  503. )
  504. send_email(smtp_settings, user.email, subject, text_body, html_body)
  505. logger.info(f"Password reset by admin {admin_user.username} for user {user.username}")
  506. return ResetPasswordResponse(message=f"Password reset email sent to {user.email}")
  507. except Exception as e:
  508. await db.rollback()
  509. logger.error(f"Failed to reset password for user {user.username}: {e}")
  510. raise HTTPException(
  511. status_code=status.HTTP_500_INTERNAL_SERVER_ERROR,
  512. detail=f"Failed to reset password: {str(e)}",
  513. )