Posted on Leave a comment

This installation of MySQL is already upgraded to 5.7.29, use –force if you still need to run mysql_upgrade E: dpkg was interrupted, you must manually run ‘dpkg –configure -a’ to correct the problem.

This installation of MySQL is already upgraded to 5.7.29, use –force if you still need to run mysql_upgrade E: dpkg was interrupted, you must manually run ‘dpkg –configure -a’ to correct the problem.

The solution is:

1- Open this file for edit:
/var/lib/dpkg/info/mysql-server-5.7.postinst

2- At line # 370, comment the echo ALTER statement which would like  
#echo “ALTER USER ‘root’@’localhost’ IDENTIFIED WITH ‘auth_socket’;” >> “$initfile”
(just add # to the beginning of this line to convert it to comment)

3- Save above file and start updating it will be fine

Posted on Leave a comment

Site Migration Risks (URL Change)

https://support.google.com/webmasters/answer/34437
https://support.google.com/webmasters/topic/6033102?hl=en&ref_topic=6029673
https://support.google.com/webmasters/answer/6033049?hl=en&ref_topic=6033084&visit_id=637156175388140145-3776646314&rd=1
https://www.searchviu.com/en/website-relaunch-seo-checklist/#awareness
https://searchengineland.com/site-migration-seo-checklist-dont-lose-traffic-286880
https://www.geekytech.co.uk/website-migration-redesign-seo-checklist/
https://www.searchenginejournal.com/changing-url-structure/325249/#close
https://moz.com/community/q/will-changing-a-url-negatively-affect-ranking
https://moz.com/blog/should-i-change-my-urls-for-seo

Posted on Leave a comment

Enable inheritance for Bulk Ad User (Active Directory)

Run below script to enable inheritance for Bulk AD user under specific OU (enable inheritance on all AD user accounts)

$ADusers = Get-ADUser -ldapfilter "(objectclass=user)" -searchbase "OU=Students,DC=ukh,DC=edu,DC=krd"
ForEach($user in $ADusers)
{
    # Binding the users to DS
    $ou = [ADSI]("LDAP://" + $user)
    $sec = $ou.psbase.objectSecurity
 
    if ($sec.get_AreAccessRulesProtected())
    {
        $isProtected = $false ## allows inheritance
        $preserveInheritance = $true ## preserver inhreited rules
        $sec.SetAccessRuleProtection($isProtected, $preserveInheritance)
        $ou.psbase.commitchanges()
        Write-Host "$user is now inherting permissions";
    }
    else
    {
        Write-Host "$User Inheritable Permission already set"
    }
}