Ayad knowledge base

1- plesk db  databasename < databasename.sql

or

2- mysql -uadmin -p”`cat /etc/psa/.psa.shadow`” databasename < databasename.sql

sed -i 's/original/new/g' file.txt

• sed = Stream EDitor
• -i = in-place (i.e. save back to the original file)
• The command string:
  • s = the substitute command
  • original = a regular expression describing the word to replace (or just the word itself)
  • new = the text to replace it with
  • g = global (i.e. replace all and not just the first occurrence)
• file.txt = the file name

Run the following command

/usr/local/psa/admin/bin/httpdmng –reconfigure-all

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