Posted on Leave a comment

Changing LDAP Query size limit more than 1000

In PHP, you may get this warning (Warning: ldap_search(): Partial search results returned: Sizelimit exceeded in) when more than 1000 objects returned in single search, you can change using following guide:

  1. Open Command Prompt on a domain controller (You must use admin credentials)
  2. Type NTDSUTIL and press ENTER.
  3. In the ntdsutil: prompt, type ldap policies
  4. In the ldap policy: prompt, type connections
  5. In the server connections: prompt, type connect to server <FQDN of domain controller> (example: connect to server domain1.com)
  6. Once you are connected, type q to come back to the ldap policy: prompt.
  7. To change the value to allow up to 5,000 objects to be returned in a single LDAP query, type set MaxPageSize to 5000
  8. To commit changes type commit changes
  9. If you type show values, you can see the current value for the administration limits, including the MaxPageSize limit
Posted on Leave a comment

Run Multiple Viber on Windows

  1. Create Local Account on Windows, and login with that account.
  2. Now Download and install viber.
  3. Sync the viber with your Phone (So that the viber on your PC can be opened).
  4. Once the viber Opened, you can now Sign-out from that account.
  5. Go back to your Main Account (the one that you want to run Multiple viber).
  6. Right Click on Desktop and Create Shortcut
  7. Paste the following (Change username only):
    C:\Windows\System32\runas.exe /savecred /user:username “C:\Users\username\AppData\Local\Viber\Viber.exe”
  8. Done!
Posted on Leave a comment

Can not find data record in database table qtype_multichoice_options Moodle

This is because of buggy questions imported by file import.

1- Run below query and then save the result in text file

SELECT t1.id, t1.name
FROM mdl_question t1
LEFT JOIN mdl_qtype_multichoice_options t2 ON t1.id = t2.questionid
WHERE t1.qtype=’multichoice’ AND t2.id IS NULL

2- Then run another query to delete buggy questions by ID

Delete from mdl_question where id in (id1, id2, ….)

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"
    }
}