ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: NO)

ARUN Posted in ERROR, MYSQL, PLESK BACKEND, PLESK FRONTEND
0

While trying to use mysql in plesk I am getting the following error :

ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: NO)

ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)

Solution :

echo “use psa; truncate lockout;” | mysql -u root -p`cat /etc/psa/.psa.shadow`     —> this can be a solution, but I have not tested that with 100% success

Plesk goes in to a loop trying to load login page

ARUN Posted in PLESK BACKEND, PLESK FRONTEND
0

When I try to access plesk through https://IP ADDRESS:8443

It just repeats trying to load the login page but never gets the login page..ie. it looks like a loop has formed.

Solution :

Check if firewall is installed. If so open inbound port : 11444 in apf.conf or csf.conf

NOTE :  Also make sure the ports : 8880, 8443, 11222 are made open and tested.

If the above dont work try to disable sso.

/usr/local/psa/bin/sso –disable to fix plesk panel 10 404 error.

How to install plesk autoinstaller

ARUN Posted in PLESK BACKEND
0

Download and install the rpm package

http://autoinstall.plesk.com/PSA_9.0.1/dist-rpm-CentOS-5-i386/opt/updater/

How to add alternate SMTP port in plesk

ARUN Posted in MAIL, PLESK BACKEND, PLESK FRONTEND
0

You can do this using 2 methods.

1) Login to Plesk >> Mail Server Settings >> Check “Enable message submission”.

Click OK.

Open that port 587 in csf or apf firewall.

You should now be able to send mail through your server on port 587

2) Make a copy of “smtp_psa” and rename that to “smtp_alternate”

cp -ar /etc/xinetd.d/smtp_psa /etc/xinetd.d/smtp_alternate

Insert the following on top :

=============
service = smtp_alternate   (Should be the same name as the file created)
type = UNLISTED
port = 2525
=============

So that the file should look like :

[root @ a24uall ] # cat /etc/xinetd.d/smtp_alternate
service smtp
{
service = smtp_alternate
type = UNLISTED
port = 2525
socket_type     = stream
protocol        = tcp
wait            = no
disable        = no
user            = root
instances       = UNLIMITED
env             = SMTPAUTH=1
server          = /var/qmail/bin/tcp-env
server_args     = -Rt0  /var/qmail/bin/relaylock /var/qmail/bin/qmail-smtpd /var/qmail/bin/smtp_auth /var/qmail/bin/true /var/qmail/bin/cmd5checkpw /var/qmail/bin/true
}

Clear email queues using qmHandle

ARUN Posted in PLESK BACKEND, SPAMMING
0

Used to monitor, delete and clear mail queues in plesk server with qmail.

wget http://optusnet.dl.sourceforge.net/sourceforge/qmhandle/qmhandle-1.3.2.tar.gz

tar -xvzf qmhandle-1.3.2.tar.gz

service qmail stop

service qmail start

./qmHandle

qmHandle -s        -s to see some basic statistics

./qmHandle -h’[email protected]’    –> Delete mails that has  “[email protected]” in header  (Case Insensitive)

Plesk Installation

ARUN Posted in INSTALLATION, PLESK BACKEND
0
  • Execute “uname -i” to get the OS arch so that you can download the appropriate installer package.

[root@server ~]# uname -i
x86_64

  • Run “cat /etc/redhat-release” to check the name & version of the OS installed

[root@server ~]# cat /etc/redhat-release
CentOS release 5.2 (Final)

  • Run the following 3 commands, to check if Apache, PHP & MySQL are preinstalled by the OS:

[root@server ~]# rpm -qa | grep -i http
[root@server ~]# rpm -qa | grep -i php
[root@server ~]# rpm -qa | grep -i mysql

  • If the above are found to be installed [most of the time they are] by the OS, they conflict with the applications Plesk installs, hence remove them using…

[root@server ~]# yum remove http*
[root@server ~]# yum remove php*
[root@server ~]# yum remove mysql*

  • Check SELinux status, we have it disabled but still… execute “getenforce” it should say “Disabled” or “Not enforcing“. If it’s enforcing, disable it by executing: “setenforce 0“.

root@server [~]# getenforce
Disabled

Change your working directory to where you want to download the Auto-installer utility:

[root@server ~]# mkdir /root/plesk
[root@server ~]# cd /root/plesk

[root@server ]# wget plesk_auto_installer_link

You can get the link from plesk website.

Eg : http://www.parallels.com/download/plesk9

[root@server ]# chmod +x plesk_auto_installer_file_name

[root@server plesk]# ./plesk_auto_installer_file_name

Read installation notes displayed on the screen and type ‘n’ to proceed to the next screen. Press ENTER.

Select the product versions that you want to install: type the number corresponding to the product version you need and press ENTER, then type ‘n’ and press ENTER to continue.

Command to Find plesk version

ARUN Posted in PLESK BACKEND
0

[root@myserver] #  rpm -q psa
psa-9.3.0-cos5.build93091230.06?

[root@myserver]#  cat /usr/local/psa/version
9.3.0 CentOS 5 93091230.06

Open Plesk CP in the browser, the version will be printed in the title bar.

To view Plesk admin password

ARUN Posted in PLESK BACKEND
0

cat /etc/psa/.psa.shadow

For Plesk 10.2 onwards

[  /usr/local/psa/bin/admin --show-password  ]