Skip to main content

Posts

Showing posts from December, 2019

Unable to access Plesk Horde webmail (Windows), Table 'horde.horde_perfs' doesn't exist

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...

Powershell interview questions

1. Which is not a built-in variable out of this         a) $Args b) $Hostname c) $Pid d) $? 2. Which one will override the default alias in Powershell a) Set-Alias -Name ls -Value hostname -Scope Local -Force b) Set-Alias -Name ls -Value hostname -Force c) Set-Alias -Name ls -Value hostname -Option AllScope d) None of the above, we can't override the default aliases 3. Out of the below which command won't work ( Renaming directory ) a) Rename-Item "C:\`[Test File`]\" "Test" b) Rename-Item "C:\``[Test File``]\" "Test" c) Rename-Item -LiteralPath "C:\`[Test File`]\" "Test" d) Rename-Item -LiteralPath "C:\[Test File]\" "Test" 4. What is the default execution policy in Powershell     a) Bypass b) Restricted c) UnRestricted d) RemoteSigned 5. W...