Ayad knowledge base

Resolution

To solve the problem and reconnect Plesk with the MySQL server, follow these steps:

1. Stop the MySQL server (but not “Plesk SQL Server”) from running on port 3306 using the Plesk Services Monitor tray utility.
2. Edit the MySQL configuration file, %plesk_dir%\\Databases\\MySQL\\Data\\my.ini , and add the line skip-grant-tables to the [mysqld]section.
3. Start the MySQL server.
4. Log into MySQL without the password:

“%plesk_dir%\\Databases\\MySQL51\\bin\\mysql.exe”

5. Change the password for the MySQL administrator:

UPDATE mysql.user SET Password = password(‘newpassword’) WHERE User = ‘admin’;

6. Remove skip-grant-tables from the MySQL configuration file and restart the service.

password should be reset already and no more issues

Reference

https://support.plesk.com/hc/en-us/articles/213947045-How-to-reset-the-MySQL-administrator-s-password-Windows-

Cause

Domain’s application pool does not support 32 applications.

Resolution

1. Open IIS->domains , find your domain name and name of application pool that domain uses.
2. Make sure that “Enable 32-Bit Applications” is enabled in IIS->Application pool->domain’s application pool->Advanced settings .

The below command need to be run in the source server to sync the files to the destination server

rsync -auvP /home/eplusglo/mail –rsh=”ssh -p 55000 ” root@124.216.218.39:/home/alzweac/

in the above command the mail folder will sync to the new server

leave a comment if you not understand.

Thanks.

If you got the above error. follow the below solutions

1. Go to Regedit.
2. Go to the path: Local_Machhine >> Software >> Wow6432Node >> Plesk >> Psa config >> config
3. Locate the record MAIL_PROVIDERW_DLL and change it to: C:\Program Files (x86)\Parallels\Plesk\admin\bin\smartermailprovider.dll
4. Locate the path: Local_Machhine >> Software >> Wow6432Node >> Plesk >> Psa config >> config >> Packages >> Mailserver and set Default regisrty entry to smartermail
5. Save the registry.
6. Open Plesk using admin login, go to  Tool and setting >> Server components >> and click on refresh.

du -sh * | sort -rh | head -6

Task: Create a Zip File

To create a zip file, enter:

zip filename.zip input1.txt input2.txt resume.doc pic1.jpg

Task: Decompress a zip

To decompress a zip file in Unix, enter:

unzip filename.zip

By default CentOS does not support the ‘NTFS’ file system, if you are tying to mount an NTFS file system  you will  need to have installed correct RPM package

#  wget  packages.sw.be/rpmforge-release/rpmforge-release-0.3.6-1.el5.rf.i386.rpm

# rpm -Uhv rpmforge-release-0.3.6-1.el5.rf.i386.rpm

warning: rpmforge-release-0.3.6-1.el5.rf.i386.rpm: Header V3 DSA signature: NOKEY, key ID 6b8d79e6
Preparing…        ########################################### [100%]
1:rpmforge-release  ########################################### [100%]

#  yum install fuse fuse-ntfs-3g dkms dkms-fuse

Make a directory for mount a file system to /mnt/usb

# mkdir /mnt/usb

# fdisk -l

Disk /dev/sda: 1999.8 GB, 1999844147200 bytes
255 heads, 63 sectors/track, 243133 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot      Start         End      Blocks   Id  System
/dev/sda1   *           1          64      514048+  83  Linux
/dev/sda5           14902       15921     8193118+  83  Linux
/dev/sda6           15922      243133  1825080358+  83  Linux

Disk /dev/sdb: 1000.2 GB, 1000204885504 bytes
255 heads, 63 sectors/track, 121601 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot      Start         End      Blocks   Id  System
/dev/sdb1               1      121602   976759808    7  HPFS/NTFS

Execute the mount command

# mount -t ntfs-3g /dev/sdb1 /mnt/usb/

Open the mounted directory /mnt/usb

# cd /mnt/usb/

# ls -al
drwxr-xr-x 39 root root       4096 May 11 09:34 .
drwxr-xr-x  5 root root       4096 Jan 11 09:34 ..

Now the ntfs partition mounts perfect.

#  df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda6             1.1T  179G  880G  12% /
/dev/sda5             6.6G  146M  6.1G   2% /tmp
/dev/sda1             587M   43M  519M  10% /boot
/dev/sdb1             932G  781M  931G   1% /mnt/usb

You will need to unmount the partition,

umount /mnt/usb

references

http://thelinuxfaq.com/41-mount-unknown-file-system-type-ntfs-centos

OpenSSH Installations under CentOS Linux

To install the server and client type:

# yum -y install openssh-server openssh-clients

Start the service:

# chkconfig sshd on
# service sshd start

Make sure port 22 is opened:

netstat -tulpn | grep :22

Firewall Settings

Edit /etc/sysconfig/iptables (IPv4 firewall),

vi /etc/sysconfig/iptables

Add the line

-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dport 22 -j ACCEP

If you want to restict access to 192.168.1.0/24, edit it as follows:
-A RH-Firewall-1-INPUT -s 192.168.1.0/24 -m state --state NEW -p tcp --dport 22 -j ACCEPT

If your site uses IPv6, and you are editing ip6tables, use the line:
-A RH-Firewall-1-INPUT -m tcp -p tcp --dport 22 -j ACCEPT

Save and close the file. Restart iptables:
# service iptables restart

———————-

OpenSSH Server Configuration

Edit /etc/ssh/sshd_config, enter:
# vi /etc/ssh/sshd_config

To disable root logins, edit or add as follows:
PermitRootLogin no

Restrict login to user tom and jerry only over ssh:
AllowUsers tom jerry

Change ssh port i.e. run it on a non-standard port like 1235
Port 1235

Save and close the file. Restart sshd:
# service sshd restart

vzctl set VEID –hostname VEID.domain.local –save

if in single file

sed -i ‘s/ugly/beautiful/g’ /home/bruno/old-friends/sue.txt

if in multiple files

$ find /home/bruno/old-friends -type f -exec sed -i ‘s/ugly/beautiful/g’ {} \;

Thanks.