Amar Helloween

 Today we will learn how to post banner notification in Plesk -Windows. This is useful when you want to display a specific content like new features or downtime message in the homepage of customer panel. We will be using the plesk extension - Broadcast message to achieve this task. To install the extension : C:\> plesk bin extension --install broadcast-message Turn on the extension : C:\> plesk db "update ModuleSettings set value = 1 where name = 'enable' and module_id in (select id from Modules where name = 'broadcast-message')" Turn off the extension : C:\> plesk db "update ModuleSettings set value = 0 where name = 'enable' and module_id in (select id from Modules where name = 'broadcast-message')" Edit the notification text: C:\> plesk db "update ModuleSettings set value = '<new message>' where name = 'message' and module_id in (select id from Modules where name = 'broadcast-message')

Tested on : Plesk Obsidian, Windows 2012 R2 Few days back i was looking into a way to find the cron details of a customer and once its fetched remove the crons created by that user. Through GUI, it can be done in 2 ways : 1. Go to Tools & Settings > Scheduler Tasks -or- Domains > Schedule Tasks 2. Login to the server > Open Task scheduler (taskschd) and Look into the task with description. You will get the domain id there But the above mentioned process is quite cumbersome. So after digging a lot, I was able to figure it out using Powershell. To get all the cron details of a particular Customer : & "$Env:Plesk_Bin\Crontabmng.exe" get "CustomerName" To Remove all the crons of a particular Customer : & "$Env:Plesk_Bin\Crontabmng.exe" remove "CustomerName"

I would like to share one of the incident which we faced recently on our production environment. Horde webmail stopped working for two Plesk servers with the below errors : A fatal error has occurred SQLSTATE[42S02]: Base table or view not found: 1146 Table 'horde.horde_prefs' doesn't exist Details have been logged for the administrator. Server details : Windows 2012 R2 Plesk Onyx 17.5.3 Horde version 5.x Steps to Fix it : Step 1 : This issue mostly happens if Horde database is missing or corrupt. In our case it was missing somehow ( may be deleted by some admin by mistake ) Step 2 : Once verified that database is missing from the MySQL, only option is to recreate the Database and Horde DB user by reinstalling it. Step 3 : To reinstall Horde, execute the below command : #Take a backup of PSA Database before making any DB related changes. plesk db dump PSA > C:\temp\PSA<Date>.sql #Removing the existing horde webmail setup ( In my case t