2026-04-30 13:17:02,356 - main - INFO - === Logging system initialized ===
2026-04-30 13:17:02,357 - main - INFO - Log file: logs/app_20260430_131702.log
2026-04-30 13:17:02,357 - main - INFO - Log level: INFO
2026-04-30 13:17:02,357 - main - INFO - Timestamp: 20260430_131702
2026-04-30 13:17:03,585 - main - INFO - Included router: routers.agent_availability.router
2026-04-30 13:17:35,591 - main - INFO - Included router: routers.ai_ticket_summary.router
2026-04-30 13:17:35,905 - main - INFO - Included router: routers.aihub.router
2026-04-30 13:17:35,984 - main - INFO - Included router: routers.auth.router
2026-04-30 13:17:36,123 - main - INFO - Included router: routers.chat_analytics_daily.router
2026-04-30 13:17:36,306 - main - INFO - Included router: routers.chat_attachments.router
2026-04-30 13:17:36,445 - main - INFO - Included router: routers.chat_branding.router
2026-04-30 13:17:36,554 - main - INFO - Included router: routers.chat_branding_api.router
2026-04-30 13:17:36,762 - main - INFO - Included router: routers.chat_conversations.router
2026-04-30 13:17:36,897 - main - INFO - Included router: routers.chat_messages.router
2026-04-30 13:17:37,163 - main - INFO - Included router: routers.chat_routing_rules.router
2026-04-30 13:17:37,352 - main - INFO - Included router: routers.contact.router
2026-04-30 13:17:37,475 - main - INFO - Included router: routers.contact_inquiries.router
2026-04-30 13:17:37,517 - main - INFO - Included router: routers.health.router
2026-04-30 13:17:37,641 - main - INFO - Included router: routers.kb_articles.router
2026-04-30 13:17:38,027 - main - INFO - Included router: routers.notification_preferences.router
2026-04-30 13:17:38,155 - main - INFO - Included router: routers.notifications.router
2026-04-30 13:17:38,272 - main - INFO - Included router: routers.plans.router
2026-04-30 13:17:38,327 - main - INFO - Included router: routers.settings.router
2026-04-30 13:17:38,420 - main - INFO - Included router: routers.site_settings.router
2026-04-30 13:17:38,618 - main - INFO - Included router: routers.smtp_settings.router
2026-04-30 13:17:38,797 - main - INFO - Included router: routers.storage.router
2026-04-30 13:17:38,997 - main - INFO - Included router: routers.support_chat.router
2026-04-30 13:17:40,028 - main - INFO - Included router: routers.support_departments.router
2026-04-30 13:17:40,640 - main - INFO - Included router: routers.support_seats.router
2026-04-30 13:17:40,685 - main - INFO - Included router: routers.ticket_notifications_sync.router
2026-04-30 13:17:40,794 - main - INFO - Included router: routers.ticket_summaries.router
2026-04-30 13:17:40,922 - main - INFO - Included router: routers.ticket_sync_states.router
2026-04-30 13:17:40,998 - main - INFO - Included router: routers.user.router
2026-04-30 13:17:41,116 - main - INFO - Included router: routers.user_profiles.router
2026-04-30 13:17:41,231 - main - INFO - Included router: routers.user_roles.router
2026-04-30 13:17:41,600 - main - INFO - Included router: routers.whmcs.router
2026-04-30 13:17:41,694 - main - INFO - Included router: routers.whmcs_admin.router
2026-04-30 13:17:41,761 - main - INFO - Included router: routers.whmcs_extra.router
2026-04-30 13:17:41,763 - main - INFO - === Application startup initiated ===
2026-04-30 13:17:41,763 - services.database - INFO - Ignore creating tables
2026-04-30 13:17:41,763 - services.mock_data - INFO - Ignore initialize data
2026-04-30 13:17:41,763 - services.auth - INFO - Ignore initialize admin
2026-04-30 13:17:41,764 - main - INFO - === Application startup completed successfully ===
2026-04-30 13:18:14,046 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-04-30 13:18:14,145 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:18:14,145 - core.database - WARNING - Database session maker not available, attempting lazy initialization...
2026-04-30 13:18:14,145 - core.database - WARNING - Database not initialized, attempting lazy initialization...
2026-04-30 13:18:14,145 - core.database - INFO - Starting database initialization...
2026-04-30 13:18:14,146 - core.config - DEBUG - Read dynamic attribute database_url from environment variable DATABASE_URL
2026-04-30 13:18:14,146 - core.database - INFO - Normalizing database URL for async compatibility...
2026-04-30 13:18:14,147 - core.database - INFO - Creating async database engine...
2026-04-30 13:18:14,148 - core.database - INFO - Using QueuePool with connection pooling for non-Lambda environment
2026-04-30 13:18:14,191 - core.database - INFO - Database engine created successfully
2026-04-30 13:18:14,191 - core.database - INFO - Creating async session maker...
2026-04-30 13:18:14,191 - core.database - INFO - Async session maker created successfully
2026-04-30 13:18:14,191 - core.database - INFO - Database connection initialized successfully
2026-04-30 13:18:14,192 - core.database - DEBUG - [DB_OP] Starting create_tables
2026-04-30 13:18:14,192 - core.database - INFO - 🔧 Starting table creation...
2026-04-30 13:18:14,196 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:18:14,196 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-04-30 13:18:14,197 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:18:14,302 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:18:14,303 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0011s
2026-04-30 13:18:15,563 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.2608s
2026-04-30 13:18:15,689 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:18:15,689 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.4935s
2026-04-30 13:18:16,881 - core.database - INFO - Tables initialized successfully
2026-04-30 13:18:16,882 - core.database - DEBUG - [DB_OP] Create tables completed in 2.6902s
2026-04-30 13:18:16,943 - core.database - INFO - Lazy database initialization completed successfully
2026-04-30 13:18:16,943 - core.database - DEBUG - [DB_OP] Database session created successfully in 2.7984s
2026-04-30 13:18:16,944 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:18:17,512 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:18:17,513 - core.database - DEBUG - [DB_OP] Database session cleanup after 3.3681s
2026-04-30 13:18:24,858 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/whmcs/me
2026-04-30 13:18:24,860 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:18:24,860 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-04-30 13:18:24,860 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:18:24,862 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-04-30 13:18:24,863 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:18:24,863 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-04-30 13:18:24,863 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:18:24,864 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:18:24,865 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-04-30 13:18:25,181 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3167s
2026-04-30 13:18:25,285 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:18:25,285 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4258s
2026-04-30 13:18:25,408 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:18:25,409 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.5461s
2026-04-30 13:18:32,518 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-04-30 13:18:32,519 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:18:32,519 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-04-30 13:18:32,520 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:18:32,521 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:18:32,521 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-04-30 13:18:32,523 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:18:32,523 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-04-30 13:18:32,523 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:18:32,886 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:18:32,887 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3647s
2026-04-30 13:18:32,888 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3673s
2026-04-30 13:18:32,897 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:18:32,898 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3786s
2026-04-30 13:18:34,774 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:18:34,775 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-04-30 13:18:34,775 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"login_page"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:18:34,780 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:18:34,780 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-04-30 13:18:34,780 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:18:35,139 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:18:35,140 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3661s
2026-04-30 13:18:35,145 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:18:35,146 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3660s
2026-04-30 13:18:58,929 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:18:58,929 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-04-30 13:18:58,930 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"login_page"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:18:59,312 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:18:59,312 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3833s
2026-04-30 13:18:59,550 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:18:59,551 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-04-30 13:18:59,551 - routers.site_settings - DEBUG - Creating new site_settings with data: key='login_page' value_json='{"layout":"split","welcomeTitle":"Welcome back to DoItEasy","welcomeSubtitle":"Manage hosting, VPS, domains and tickets from one premium dashboard.","backgroundUrl":"/assets/images/image-1.png","backgroundVideoUrl":"/assets/hero-servers-data.mp4","showSocialLogin":true,"showRememberMe":true,"showForgotPassword":true,"ctaLabel":"Sign In"}'
2026-04-30 13:19:00,358 - services.site_settings - INFO - Created site_settings with id: 1
2026-04-30 13:19:00,359 - routers.site_settings - INFO - Site_settings created successfully with id: 1
2026-04-30 13:19:00,360 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.8093s
2026-04-30 13:19:03,464 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:19:03,465 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-04-30 13:19:03,465 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"pending_registrations"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:19:03,467 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:19:03,468 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-04-30 13:19:03,468 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"registration"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:19:03,833 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:19:03,834 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3664s
2026-04-30 13:19:03,845 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:19:03,845 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3810s
2026-04-30 13:19:06,461 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:19:06,462 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-04-30 13:19:06,462 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"login_page"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:19:06,464 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:19:06,464 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-04-30 13:19:06,464 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:19:06,826 - routers.site_settings - DEBUG - Found 1 site_settingss
2026-04-30 13:19:06,827 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3654s
2026-04-30 13:19:06,827 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:19:06,828 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3640s
2026-04-30 13:19:09,354 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:19:09,355 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-04-30 13:19:09,355 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"registration"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:19:09,357 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:19:09,357 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-04-30 13:19:09,358 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"pending_registrations"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:19:09,721 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:19:09,721 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3641s
2026-04-30 13:19:09,738 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:19:09,739 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3846s
2026-04-30 13:19:32,524 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:19:32,525 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-04-30 13:19:32,889 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3647s
2026-04-30 13:20:02,217 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:20:02,218 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-04-30 13:20:02,218 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"registration"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:20:02,585 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:20:02,585 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3682s
2026-04-30 13:20:02,821 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:20:02,822 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-04-30 13:20:02,822 - routers.site_settings - DEBUG - Creating new site_settings with data: key='registration' value_json='{"open":true,"requireEmailVerify":true,"requireCaptcha":true,"requirePhone":true,"requireCompany":true,"requireCountry":true,"requirePlanSelection":true,"defaultRole":"client","approval":"auto","allowedDomains":[],"blockedDomains":[],"termsUrl":"/service-terms","welcomeMessage":"Welcome to DoItEasy"}'
2026-04-30 13:20:03,643 - services.site_settings - INFO - Created site_settings with id: 2
2026-04-30 13:20:03,643 - routers.site_settings - INFO - Site_settings created successfully with id: 2
2026-04-30 13:20:03,644 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.8222s
2026-04-30 13:20:13,403 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:20:13,403 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-04-30 13:20:13,403 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"pending_registrations"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:20:13,768 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:20:13,768 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3659s
2026-04-30 13:20:14,015 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:20:14,015 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-04-30 13:20:14,015 - routers.site_settings - DEBUG - Creating new site_settings with data: key='pending_registrations' value_json='{"items":[{"id":"r2","name":"Hassan Tariq","email":"hassan@fincorp.kw","company":"FinCorp KW","country":"Kuwait","plan":"Enterprise Dedicated","status":"pending","submittedAt":"2 h ago"},{"id":"r3","name":"Noura Farouk","email":"noura@gulfmed.eg","company":"GulfMed","country":"Egypt","plan":"Starter VPS","status":"approved","submittedAt":"Yesterday"},{"id":"r4","name":"Yousef Al-Jabri","email":"yousef@startupx.io","company":"StartupX","country":"UAE","plan":"Business VDS","status":"rejected","submittedAt":"2 days ago"}]}'
2026-04-30 13:20:14,700 - services.site_settings - INFO - Created site_settings with id: 3
2026-04-30 13:20:14,700 - routers.site_settings - INFO - Site_settings created successfully with id: 3
2026-04-30 13:20:14,700 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.6858s
2026-04-30 13:20:15,565 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:20:15,565 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-04-30 13:20:15,565 - routers.site_settings - DEBUG - Updating site_settings 3 with data: key='pending_registrations' value_json='{"items":[{"id":"r3","name":"Noura Farouk","email":"noura@gulfmed.eg","company":"GulfMed","country":"Egypt","plan":"Starter VPS","status":"approved","submittedAt":"Yesterday"},{"id":"r4","name":"Yousef Al-Jabri","email":"yousef@startupx.io","company":"StartupX","country":"UAE","plan":"Business VDS","status":"rejected","submittedAt":"2 days ago"}]}'
2026-04-30 13:20:16,439 - services.site_settings - INFO - Updated site_settings 3
2026-04-30 13:20:16,439 - routers.site_settings - INFO - Site_settings 3 updated successfully
2026-04-30 13:20:16,440 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.8753s
2026-04-30 13:20:16,622 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:20:16,622 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-04-30 13:20:16,622 - routers.site_settings - DEBUG - Updating site_settings 3 with data: key='pending_registrations' value_json='{"items":[{"id":"r4","name":"Yousef Al-Jabri","email":"yousef@startupx.io","company":"StartupX","country":"UAE","plan":"Business VDS","status":"rejected","submittedAt":"2 days ago"}]}'
2026-04-30 13:20:17,410 - services.site_settings - INFO - Updated site_settings 3
2026-04-30 13:20:17,410 - routers.site_settings - INFO - Site_settings 3 updated successfully
2026-04-30 13:20:17,411 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.7890s
2026-04-30 13:20:17,503 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:20:17,504 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-04-30 13:20:17,504 - routers.site_settings - DEBUG - Updating site_settings 3 with data: key='pending_registrations' value_json='{"items":[]}'
2026-04-30 13:20:18,313 - services.site_settings - INFO - Updated site_settings 3
2026-04-30 13:20:18,313 - routers.site_settings - INFO - Site_settings 3 updated successfully
2026-04-30 13:20:18,314 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.8105s
2026-04-30 13:20:20,520 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:20:20,520 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-04-30 13:20:20,520 - routers.site_settings - DEBUG - Updating site_settings 2 with data: key='registration' value_json='{"open":true,"requireEmailVerify":true,"requireCaptcha":true,"requirePhone":true,"requireCompany":true,"requireCountry":true,"requirePlanSelection":true,"defaultRole":"client","approval":"auto","allowedDomains":[],"blockedDomains":[],"termsUrl":"/service-terms","welcomeMessage":"Welcome to DoItEasy"}'
2026-04-30 13:20:21,212 - services.site_settings - INFO - Updated site_settings 2
2026-04-30 13:20:21,213 - routers.site_settings - INFO - Site_settings 2 updated successfully
2026-04-30 13:20:21,214 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.6943s
2026-04-30 13:20:24,369 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:20:24,369 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-04-30 13:20:24,370 - routers.site_settings - DEBUG - Updating site_settings 2 with data: key='registration' value_json='{"open":true,"requireEmailVerify":true,"requireCaptcha":true,"requirePhone":true,"requireCompany":true,"requireCountry":true,"requirePlanSelection":true,"defaultRole":"client","approval":"auto","allowedDomains":[],"blockedDomains":[],"termsUrl":"/service-terms","welcomeMessage":"Welcome to DoItEasy"}'
2026-04-30 13:20:25,044 - services.site_settings - INFO - Updated site_settings 2
2026-04-30 13:20:25,044 - routers.site_settings - INFO - Site_settings 2 updated successfully
2026-04-30 13:20:25,045 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.6763s
2026-04-30 13:20:27,645 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:20:27,645 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-04-30 13:20:27,646 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"security"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:20:28,027 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:20:28,028 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3833s
2026-04-30 13:20:32,521 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:20:32,521 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-04-30 13:20:32,825 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3041s
2026-04-30 13:20:45,819 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/admin/smtp-settings
2026-04-30 13:20:55,395 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:20:55,395 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-04-30 13:20:55,396 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"pricing_layout"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:20:55,762 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:20:55,762 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3675s
2026-04-30 13:21:07,025 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:21:07,025 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-04-30 13:21:07,026 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"users_roles"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:21:07,408 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:21:07,408 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3835s
2026-04-30 13:21:32,522 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:21:32,523 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-04-30 13:21:32,827 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3050s
2026-04-30 13:21:47,338 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:21:47,338 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-04-30 13:21:47,339 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"users_roles"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:21:47,704 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:21:47,705 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3672s
2026-04-30 13:21:48,170 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:21:48,170 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-04-30 13:21:48,171 - routers.site_settings - DEBUG - Creating new site_settings with data: key='users_roles' value_json='{"users":[{"id":"u1","name":"Hatem Yahia","email":"support@doiteasy.net","role":"admin","active":true,"lastLogin":"2h ago"},{"id":"u2","name":"Sara Mansour","email":"sara@doiteasy.net","role":"support","active":true,"lastLogin":"15m ago"},{"id":"u3","name":"Ahmed Al-Rashed","email":"ahmed@doiteasy.net","role":"billing","active":true,"lastLogin":"Yesterday"},{"id":"u4","name":"Fatima Noor","email":"fatima@doiteasy.net","role":"client","active":false,"lastLogin":"3w ago"}],"permissions":{"admin":["manage_users","view_billing","issue_refunds","manage_servers","manage_domains","manage_tickets","view_audit","edit_branding","edit_pricing","send_notifications"],"support":["manage_tickets","manage_users","manage_servers","manage_domains"],"billing":["view_billing","issue_refunds","manage_tickets"],"client":[]},"defaultRole":"client"}'
2026-04-30 13:21:48,857 - services.site_settings - INFO - Created site_settings with id: 4
2026-04-30 13:21:48,858 - routers.site_settings - INFO - Site_settings created successfully with id: 4
2026-04-30 13:21:48,858 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.6884s
2026-04-30 13:21:56,345 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:21:56,346 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-04-30 13:21:56,346 - routers.site_settings - DEBUG - Updating site_settings 4 with data: key='users_roles' value_json='{"users":[{"id":"u1","name":"Hatem Yahia","email":"support@doiteasy.net","role":"admin","active":true,"lastLogin":"2h ago"}],"permissions":{"admin":["manage_users","view_billing","issue_refunds","manage_servers","manage_domains","manage_tickets","view_audit","edit_branding","edit_pricing","send_notifications"],"support":["manage_tickets","manage_users","manage_servers","manage_domains"],"billing":["view_billing","issue_refunds","manage_tickets"],"client":[]},"defaultRole":"client"}'
2026-04-30 13:21:57,096 - services.site_settings - INFO - Updated site_settings 4
2026-04-30 13:21:57,096 - routers.site_settings - INFO - Site_settings 4 updated successfully
2026-04-30 13:21:57,097 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.7517s
2026-04-30 13:21:57,631 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:21:57,632 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-04-30 13:21:57,632 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:21:57,998 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:21:57,999 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3683s
2026-04-30 13:22:32,538 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:22:32,539 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-04-30 13:22:32,845 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3067s
2026-04-30 13:23:41,773 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:23:41,773 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0007s
2026-04-30 13:23:42,217 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4441s
2026-04-30 13:23:58,046 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:23:58,047 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-04-30 13:23:58,048 - routers.site_settings - DEBUG - Querying site_settingss: query=None, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:23:58,656 - routers.site_settings - DEBUG - Found 4 site_settingss
2026-04-30 13:23:58,657 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.6105s
2026-04-30 13:23:58,670 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:23:58,670 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-04-30 13:23:58,670 - routers.plans - DEBUG - Querying planss: query=None, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:23:59,282 - routers.plans - DEBUG - Found 16 planss
2026-04-30 13:23:59,283 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.6132s
2026-04-30 13:24:12,568 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:24:12,568 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-04-30 13:24:12,568 - routers.user_roles - DEBUG - Querying user_roless: query=None, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:24:13,085 - routers.user_roles - DEBUG - Found 0 user_roless
2026-04-30 13:24:13,086 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.5187s
2026-04-30 13:24:43,303 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:24:43,304 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-04-30 13:24:43,609 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3051s
2026-04-30 13:26:44,064 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-04-30 13:26:44,066 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:26:44,067 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-04-30 13:26:44,068 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:26:44,068 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-04-30 13:26:44,069 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:26:44,070 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:26:44,070 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-04-30 13:26:44,070 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:26:44,371 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3053s
2026-04-30 13:26:44,435 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:26:44,436 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3664s
2026-04-30 13:26:44,448 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:26:44,449 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3806s
2026-04-30 13:27:44,738 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:27:44,739 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-04-30 13:27:45,045 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3066s
2026-04-30 13:28:44,743 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:28:44,743 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-04-30 13:28:45,049 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3062s
2026-04-30 13:29:44,739 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:29:44,740 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0012s
2026-04-30 13:29:45,186 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4471s
2026-04-30 13:30:39,915 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:30:39,916 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-04-30 13:30:39,916 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:30:39,917 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-04-30 13:30:39,918 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:30:39,918 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-04-30 13:30:39,920 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:30:39,920 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-04-30 13:30:39,920 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:30:40,307 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:30:40,308 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3888s
2026-04-30 13:30:40,344 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4261s
2026-04-30 13:30:40,404 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:30:40,405 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4894s
2026-04-30 13:31:44,907 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:31:44,907 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-04-30 13:31:45,225 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3187s
2026-04-30 13:34:13,772 - services.database - DEBUG - [DB_OP] Starting database close
2026-04-30 13:34:13,966 - core.database - INFO - Database connection closed and engine disposed
2026-04-30 13:34:13,966 - services.database - INFO - Database connections closed
2026-04-30 13:34:13,966 - services.database - DEBUG - [DB_OP] Database close completed in 0.1940s