Wednesday, 18 December 2019

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

7:39 pm
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 the horde site is webmail , it may differ in your case )
plesk installer --select-release-current --remove-component webmail

#Installing Horde again with the latest version
plesk installer --select-release-current --install-component webmail

Post that it got Fixed.

Powershell interview questions

2:48 pm

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. What will be the output of $Result
     $Result = Write-Host "This is my First script" ; $Result

a) Null
b) This is my First script
c) 0
d) None of the above

6. What will be the Output :

    $value = "Apple.Orange.Pineapple"
    $Orange, $Pineapple = $value.Split(".")
    Write-Host "$Orange ; $Pineapple ; $Apple"

a) Apple ; Orange Pineapple ;
b) Orange ; Pineapple ; Apple
c) Apple ; Orange ; Pineapple
d) None of the above

7. What will be the Output :

     $Value = "Global-Scope"
     function abc {
                  $Value = "Local-Scope"
                  Write-Host $global:Value
                  Write-Host $local:Value
                  Write-Host $Value

    Write-Host $local:Value
    Write-Host $Value

a) Local-Scope Global-Scope Local-Scope Local-Scope Global-Scope
b) Global-Scope Local-Scope Local-Scope Global-Scope Global-Scope
c) Global-Scope Local-Scope Global-Scope Local-Scope Global-Scope
d) Global-Scope Local-Scope Local-Scope Local-Scope Global-Scope

8. Which below cmdlet is wrong, To Remove a variable ($Var) from Memory

        a) Remove-Variable -Name var
b) rv var
c) Remove-Item Variable:\Var
d) rv $var

9. What will be the Output :

    $output1 = 4 + "2" ;
    $output2 = "4" + 2 ;
    Write-Output $output1 , $output2

a) 6 42
b) 42 42
c) 6 6
d) None of the above

10. Which port is used by default for Powershell remoting ( HTTP Listener )

       a) 5986
b) 5985
c) 5984
d) 5987

11. Print your name 10 times, Example :

     John Doe
     John Doe
     John Doe
     John Doe
     John Doe
     John Doe
     John Doe
     John Doe
     John Doe
     John Doe

Solution : PS C:\> 1..10 | %{write-host "John Doe"}

12. Create a Function to accept a parameter and then reverse it

Example :
Reverse-String -Phrase "Powershell"
Output : llehsrewoP

Solution :

Contact us


Email *

Message *