2026-05-02 20:04:40,777 - main - INFO - === Logging system initialized === 2026-05-02 20:04:40,777 - main - INFO - Log file: logs/app_20260502_200440.log 2026-05-02 20:04:40,778 - main - INFO - Log level: INFO 2026-05-02 20:04:40,778 - main - INFO - Timestamp: 20260502_200440 2026-05-02 20:04:40,859 - main - INFO - Included router: routers.admin_dashboard.router 2026-05-02 20:04:40,904 - main - INFO - Included router: routers.admin_users.router 2026-05-02 20:04:40,950 - main - INFO - Included router: routers.agent_availability.router 2026-05-02 20:04:41,693 - main - INFO - Included router: routers.ai_ticket_summary.router 2026-05-02 20:04:41,714 - main - INFO - Included router: routers.aihub.router 2026-05-02 20:04:41,727 - main - INFO - Included router: routers.audit_log.router 2026-05-02 20:04:41,737 - main - INFO - Included router: routers.auth.router 2026-05-02 20:04:41,756 - main - INFO - Included router: routers.cache_settings.router 2026-05-02 20:04:41,801 - main - INFO - Included router: routers.carts.router 2026-05-02 20:04:41,852 - main - INFO - Included router: routers.chat_analytics_daily.router 2026-05-02 20:04:41,895 - main - INFO - Included router: routers.chat_attachments.router 2026-05-02 20:04:41,958 - main - INFO - Included router: routers.chat_branding.router 2026-05-02 20:04:41,972 - main - INFO - Included router: routers.chat_branding_api.router 2026-05-02 20:04:42,128 - main - INFO - Included router: routers.chat_conversations.router 2026-05-02 20:04:42,170 - main - INFO - Included router: routers.chat_messages.router 2026-05-02 20:04:42,209 - main - INFO - Included router: routers.chat_routing_rules.router 2026-05-02 20:04:42,229 - main - INFO - Included router: routers.contact.router 2026-05-02 20:04:42,266 - main - INFO - Included router: routers.contact_inquiries.router 2026-05-02 20:04:42,308 - main - INFO - Included router: routers.ecom_checkout.router 2026-05-02 20:04:42,311 - main - INFO - Included router: routers.health.router 2026-05-02 20:04:42,352 - main - INFO - Included router: routers.kb_article_feedback.router 2026-05-02 20:04:42,397 - main - INFO - Included router: routers.kb_articles.router 2026-05-02 20:04:42,415 - main - INFO - Included router: routers.local_auth.router 2026-05-02 20:04:42,460 - main - INFO - Included router: routers.notification_preferences.router 2026-05-02 20:04:42,507 - main - INFO - Included router: routers.notifications.router 2026-05-02 20:04:42,512 - main - INFO - Included router: routers.notifications_extras.router 2026-05-02 20:04:42,613 - main - INFO - Included router: routers.oauth.router 2026-05-02 20:04:42,802 - main - INFO - Included router: routers.order_items.router 2026-05-02 20:04:42,874 - main - INFO - Included router: routers.orders.router 2026-05-02 20:04:42,880 - main - INFO - Included router: routers.password_reset.router 2026-05-02 20:04:42,931 - main - INFO - Included router: routers.plans.router 2026-05-02 20:04:42,975 - main - INFO - Included router: routers.product_categories.router 2026-05-02 20:04:43,023 - main - INFO - Included router: routers.product_reviews.router 2026-05-02 20:04:43,083 - main - INFO - Included router: routers.products.router 2026-05-02 20:04:43,108 - main - INFO - Included router: routers.role_management.router 2026-05-02 20:04:43,161 - main - INFO - Included router: routers.service_testimonials.router 2026-05-02 20:04:43,185 - main - INFO - Included router: routers.settings.router 2026-05-02 20:04:43,224 - main - INFO - Included router: routers.site_settings.router 2026-05-02 20:04:43,268 - main - INFO - Included router: routers.smtp_settings.router 2026-05-02 20:04:43,307 - main - INFO - Included router: routers.storage.router 2026-05-02 20:04:43,584 - main - INFO - Included router: routers.support_chat.router 2026-05-02 20:04:43,646 - main - INFO - Included router: routers.support_departments.router 2026-05-02 20:04:43,700 - main - INFO - Included router: routers.support_seats.router 2026-05-02 20:04:43,713 - main - INFO - Included router: routers.ticket_notifications_sync.router 2026-05-02 20:04:43,757 - main - INFO - Included router: routers.ticket_summaries.router 2026-05-02 20:04:43,797 - main - INFO - Included router: routers.ticket_sync_states.router 2026-05-02 20:04:43,808 - main - INFO - Included router: routers.user.router 2026-05-02 20:04:43,864 - main - INFO - Included router: routers.user_profiles.router 2026-05-02 20:04:43,914 - main - INFO - Included router: routers.user_roles.router 2026-05-02 20:04:43,937 - main - INFO - Included router: routers.whmcs.router 2026-05-02 20:04:44,007 - main - INFO - Included router: routers.whmcs_admin.router 2026-05-02 20:04:44,085 - main - INFO - Included router: routers.whmcs_extra.router 2026-05-02 20:04:44,087 - main - INFO - === Application startup initiated === 2026-05-02 20:04:44,087 - services.database - INFO - Ignore creating tables 2026-05-02 20:04:44,087 - services.mock_data - INFO - Ignore initialize data 2026-05-02 20:04:44,088 - services.auth - INFO - Ignore initialize admin 2026-05-02 20:04:44,088 - main - INFO - === Application startup completed successfully === 2026-05-02 20:11:22,974 - core.database - DEBUG - [DB_OP] Starting get_db session creation 2026-05-02 20:11:22,974 - core.database - WARNING - Database session maker not available, attempting lazy initialization... 2026-05-02 20:11:22,974 - core.database - WARNING - Database not initialized, attempting lazy initialization... 2026-05-02 20:11:22,974 - core.database - INFO - Starting database initialization... 2026-05-02 20:11:22,974 - core.config - DEBUG - Read dynamic attribute database_url from environment variable DATABASE_URL 2026-05-02 20:11:22,974 - core.database - INFO - Normalizing database URL for async compatibility... 2026-05-02 20:11:22,977 - core.database - INFO - Creating async database engine... 2026-05-02 20:11:22,978 - core.database - INFO - Using QueuePool with connection pooling for non-Lambda environment 2026-05-02 20:11:23,067 - core.database - INFO - Database engine created successfully 2026-05-02 20:11:23,067 - core.database - INFO - Creating async session maker... 2026-05-02 20:11:23,068 - core.database - INFO - Async session maker created successfully 2026-05-02 20:11:23,068 - core.database - INFO - Database connection initialized successfully 2026-05-02 20:11:23,068 - core.database - DEBUG - [DB_OP] Starting create_tables 2026-05-02 20:11:23,068 - core.database - INFO - 🔧 Starting table creation... 2026-05-02 20:11:23,076 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me 2026-05-02 20:11:23,081 - core.database - DEBUG - [DB_OP] Starting get_db session creation 2026-05-02 20:11:23,081 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s 2026-05-02 20:11:23,082 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None 2026-05-02 20:11:23,086 - core.database - DEBUG - [DB_OP] Starting get_db session creation 2026-05-02 20:11:23,087 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0008s 2026-05-02 20:11:23,088 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None 2026-05-02 20:11:24,513 - routers.site_settings - DEBUG - Found 0 site_settingss 2026-05-02 20:11:24,514 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.4271s 2026-05-02 20:11:24,516 - routers.site_settings - DEBUG - Found 0 site_settingss 2026-05-02 20:11:24,517 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.4361s 2026-05-02 20:11:26,579 - core.database - INFO - Tables initialized successfully 2026-05-02 20:11:26,580 - core.database - DEBUG - [DB_OP] Create tables completed in 3.5119s 2026-05-02 20:11:26,643 - core.database - INFO - Lazy database initialization completed successfully 2026-05-02 20:11:26,643 - core.database - DEBUG - [DB_OP] Database session created successfully in 3.6698s 2026-05-02 20:11:27,108 - core.database - DEBUG - [DB_OP] Database session cleanup after 4.1340s 2026-05-02 20:11:36,048 - core.database - DEBUG - [DB_OP] Starting get_db session creation 2026-05-02 20:11:36,048 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s 2026-05-02 20:11:36,048 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/admin/cache 2026-05-02 20:11:36,048 - core.database - ERROR - Database session error: 401: Authentication credentials were not provided Traceback (most recent call last): File "/workspace/app/backend/core/database.py", line 602, in get_db yield session File "/data/chats/99daa102ba1446f6aa2f99771f457055/.cache/python/lib/python3.10/site-packages/fastapi/routing.py", line 120, in app response = await f(request) File "/data/chats/99daa102ba1446f6aa2f99771f457055/.cache/python/lib/python3.10/site-packages/fastapi/routing.py", line 457, in app solved_result = await solve_dependencies( File "/data/chats/99daa102ba1446f6aa2f99771f457055/.cache/python/lib/python3.10/site-packages/fastapi/dependencies/utils.py", line 649, in solve_dependencies solved_result = await solve_dependencies( File "/data/chats/99daa102ba1446f6aa2f99771f457055/.cache/python/lib/python3.10/site-packages/fastapi/dependencies/utils.py", line 649, in solve_dependencies solved_result = await solve_dependencies( File "/data/chats/99daa102ba1446f6aa2f99771f457055/.cache/python/lib/python3.10/site-packages/fastapi/dependencies/utils.py", line 678, in solve_dependencies solved = await call(**solved_result.values) File "/workspace/app/backend/dependencies/auth.py", line 24, in get_bearer_token raise HTTPException(status_code=status.HTTP_401_UNAUTHORIZED, detail="Authentication credentials were not provided") fastapi.exceptions.HTTPException: 401: Authentication credentials were not provided 2026-05-02 20:11:36,087 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.0391s 2026-05-02 20:11:36,088 - core.database - DEBUG - [DB_OP] Starting get_db session creation 2026-05-02 20:11:36,088 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s 2026-05-02 20:11:36,089 - core.database - ERROR - Failed to create database session: 401: Authentication credentials were not provided Traceback (most recent call last): File "/workspace/app/backend/core/database.py", line 602, in get_db yield session File "/data/chats/99daa102ba1446f6aa2f99771f457055/.cache/python/lib/python3.10/site-packages/fastapi/routing.py", line 120, in app response = await f(request) File "/data/chats/99daa102ba1446f6aa2f99771f457055/.cache/python/lib/python3.10/site-packages/fastapi/routing.py", line 457, in app solved_result = await solve_dependencies( File "/data/chats/99daa102ba1446f6aa2f99771f457055/.cache/python/lib/python3.10/site-packages/fastapi/dependencies/utils.py", line 649, in solve_dependencies solved_result = await solve_dependencies( File "/data/chats/99daa102ba1446f6aa2f99771f457055/.cache/python/lib/python3.10/site-packages/fastapi/dependencies/utils.py", line 649, in solve_dependencies solved_result = await solve_dependencies( File "/data/chats/99daa102ba1446f6aa2f99771f457055/.cache/python/lib/python3.10/site-packages/fastapi/dependencies/utils.py", line 678, in solve_dependencies solved = await call(**solved_result.values) File "/workspace/app/backend/dependencies/auth.py", line 24, in get_bearer_token raise HTTPException(status_code=status.HTTP_401_UNAUTHORIZED, detail="Authentication credentials were not provided") fastapi.exceptions.HTTPException: 401: Authentication credentials were not provided 2026-05-02 20:11:36,090 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me 2026-05-02 20:11:36,091 - core.database - DEBUG - [DB_OP] Starting get_db session creation 2026-05-02 20:11:36,091 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s 2026-05-02 20:11:36,092 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None 2026-05-02 20:11:36,095 - core.database - DEBUG - [DB_OP] Starting get_db session creation 2026-05-02 20:11:36,096 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0008s 2026-05-02 20:11:36,096 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None 2026-05-02 20:11:36,482 - routers.site_settings - DEBUG - Found 0 site_settingss 2026-05-02 20:11:36,482 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3876s 2026-05-02 20:11:36,534 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4464s 2026-05-02 20:11:36,660 - routers.site_settings - DEBUG - Found 0 site_settingss 2026-05-02 20:11:36,661 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.5696s 2026-05-02 20:12:08,273 - core.database - DEBUG - [DB_OP] Starting get_db session creation 2026-05-02 20:12:08,273 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s 2026-05-02 20:12:08,274 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me 2026-05-02 20:12:08,285 - core.database - DEBUG - [DB_OP] Starting get_db session creation 2026-05-02 20:12:08,286 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s 2026-05-02 20:12:08,286 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None 2026-05-02 20:12:08,287 - core.database - DEBUG - [DB_OP] Starting get_db session creation 2026-05-02 20:12:08,288 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s 2026-05-02 20:12:08,288 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None 2026-05-02 20:12:08,596 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3233s 2026-05-02 20:12:08,667 - routers.site_settings - DEBUG - Found 0 site_settingss 2026-05-02 20:12:08,667 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3799s 2026-05-02 20:12:08,668 - routers.site_settings - DEBUG - Found 0 site_settingss 2026-05-02 20:12:08,668 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3828s 2026-05-02 20:12:36,037 - core.database - DEBUG - [DB_OP] Starting get_db session creation 2026-05-02 20:12:36,037 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s 2026-05-02 20:12:36,355 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3179s 2026-05-02 20:13:17,795 - services.database - DEBUG - [DB_OP] Starting database close 2026-05-02 20:13:17,994 - core.database - INFO - Database connection closed and engine disposed 2026-05-02 20:13:17,994 - services.database - INFO - Database connections closed 2026-05-02 20:13:17,995 - services.database - DEBUG - [DB_OP] Database close completed in 0.1998s