• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Can't unblock domain after backup

Can any one give a set by set how to access Pleak Database and make some changes;

Problem with blocking solved. Solution:
1. In database MySQL «psa» table «domains» domain «example.ru» - in the "status" column change the value to "0" (found in "4").
2. Parallels Plesk Panel - block domain «example.ru».
3. Parallels Plesk Panel - unlock domain «example.ru».
4. In database MySQL «psa» table «suspend_handler_history» clear all data (if only «example.ru» blocked).
 
Am in the Database how i clear the block domain

mysql> show tables;
+-------------------------------+
| Tables_in_psa |
+-------------------------------+
| APSApplicationItems |
| APSCatalogUpdates |
| APSClientApplicationItems |
| APSLicenseTypes |
| APSLicenses |
| BackendCache |
| BackupsRunning |
| BackupsScheduled |
| BackupsSettings |
| BillingCache |
| Cards |
| ClientsTraffic |
| Components |
| DashboardPreset |
| DashboardPresetConfig |
| DatabaseServers |
| DomainServices |
| DomainsTraffic |
| GL_remote_domains |
| GL_settings |
| IP_Addresses |
| Limits |
| ListsParams |
| Logos |
| MailLists |
| MailMessagesStat |
| Modules |
| NewsArticles |
| Notes |
| Notifications |
| PMM |
| PMMDefault |
| Parameters |
| Permissions |
| PersistentCache |
| PleskPagesStat |
| Repository |
| SBConfig |
| SBResellers |
| SBSites |
| SSOBranding |
| SiteAppFiles |
| SiteAppPackages |
| SiteAppResources |
| SiteApps |
| SiteAppsHitsStat |
| SitePagesStat |
| Skins |
| Templates |
| TmplData |
| WebApps |
| Webmails |
| accounts |
| actions |
| ai_vendor_sources |
| anon_ftp |
| apscategories |
| badmailfrom |
| certificates |
| cl_param |
| clients |
| cp_access |
| custom_buttons |
| data_bases |
| db_users |
| disk_usage |
| dns_recs |
| dns_recs_t |
| dns_zone |
| dom_level_usrs |
| dom_param |
| domainaliases |
| domains |
| event_handlers |
| exp_event |
| forwarding |
| hosting |
| ip_pool |
| itmpl |
| itmpl_data |
| key_history |
| key_history_params |
| locales |
| lockout |
| log_actions |
| log_components |
| log_rotation |
| longtaskparams |
| longtasks |
| mail |
| mail_aliases |
| mail_redir |
| mail_resp |
| mass_mail |
| mass_mail_clients |
| mass_mail_domains |
| misc |
| mn_param |
| module_3_sbm_config |
| module_3_sbm_domains |
| module_3_sbm_resellers |
| module_3_sbm_sbservers |
| module_fileserver_hosts |
| module_fileserver_params |
| module_fileserver_shares |
| module_fileserver_users |
| module_fileserver_valid_users |
| module_firewall_objects |
| module_firewall_rules |
| module_vpn_objects |
| module_watchdog_disk |
| module_watchdog_disk_event |
| module_watchdog_param |
| module_watchdog_report |
| module_watchdog_service |
| module_watchdog_service_event |
| module_watchdog_sys_stat |
| password_secrets |
| pd_users |
| protected_dirs |
| report |
| report_auto |
| report_section |
| resp_attach |
| resp_forward |
| resp_freq |
| secret_keys |
| sessions |
| siteapppackages_apscategories |
| slave_params |
| slaves |
| smtp_poplocks |
| spamfilter |
| spamfilter_preferences |
| subdomains |
| suspend_handler_history |
| sys_users |
| tts_cats |
| tts_conf |
| tts_priorities |
| tts_queues |
| tts_reporters |
| tts_slave_info |
| tts_ticket_events |
| tts_tickets |
| upgrade_history |
| web_users |
| webalizer_group_referrer |
| webalizer_hidden_referrer |
+-------------------------------+
149 rows in set (0.00 sec)

mysql>
 
I resolved the issue by:

Login to Plesk as user ‘admin’

Click "Settings" >> "Database Hosting Preferences" >> click OK >>
"Local MySQL server" >> "Databases" tab >> "Webadmin".

Then:
Problem with blocking solved. Solution:
1. In database MySQL «psa» table «domains» domain «example.ru» - in the "status" column change the value to "0" (found in "4").
2. Parallels Plesk Panel - block domain «example.ru».
3. Parallels Plesk Panel - unlock domain «example.ru».
4. In database MySQL «psa» table «suspend_handler_history» clear all data (if only «example.ru» blocked).
 
Back
Top