Linux:
# mysql -uadmin -p`cat /etc/psa/.psa.shadow` DATABASE_NAME
Windows:
This will retrieve admin password
cd %plesk_bin% plesksrvclient -get
Login to mysql
cd %plesk_dir%\mysql\bin mysql -uadmin -pPassword -P8306
Category: Plesk
Is it mysql or maria?
# service mysqld status Redirecting to /bin/systemctl status mysqld.service mysqld.service Loaded: not-found (Reason: No such file or directory) Active: inactive (dead)
]# systemctl status mariadb.service
mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled)
Active: active (running) since Mon 2015-10-05 21:03:57 EST; 3min 30s ago
Process: 26953 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=0/SUCCESS)
Process: 26922 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
Main PID: 26952 (mysqld_safe)
CGroup: /system.slice/mariadb.service
├─26952 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
└─27120 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/run/mariadb/mariadb.pid --socket=/var/lib/mysql/mysql.sock
Oct 05 21:03:55 domain.com mysqld_safe[26952]: 151005 21:03:55 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
Oct 05 21:03:55 domain.com mysqld_safe[26952]: 151005 21:03:55 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Oct 05 21:03:57 domain.com systemd[1]: Started MariaDB database server.
Find the existing password
# cat /etc/psa/.psa.shadow $AES-128-CBC$MnglmyKq3wJbZVgmb4YKTQ==$p/zX+xpnhJ20kIrrZiFsq7VLE3kI+86JwVdPYJtWdEE=[root@69-64-92-195 ~]#
Stop the database
]# systemctl stop mariadb.service
Edit my.cnf and add skip-grant-tables
[mysqld] local-infile=0 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 # Settings user and group are ignored when systemd is used. # If you need to run mysqld under a different user or group, # customize your systemd unit file for mariadb according to the # instructions in http://fedoraproject.org/wiki/Systemd skip-grant-tables [mysqld_safe] log-error=/var/log/mariadb/mariadb.log pid-file=/var/run/mariadb/mariadb.pid # # include all files from the config directory # !includedir /etc/my.cnf.d
Restart mysql
# systemctl restart mariadb.service
Reset the mysql password no
# mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa
mysql> UPDATE mysql.user SET Password=PASSWORD('# mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa
mysql> UPDATE mysql.user SET Password=PASSWORD('$AES-128-CBC......') WHERE User='admin';') WHERE User='admin';
Edit my.cnf and remove skip-grant-tables
[mysqld] local-infile=0 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 # Settings user and group are ignored when systemd is used. # If you need to run mysqld under a different user or group, # customize your systemd unit file for mariadb according to the # instructions in http://fedoraproject.org/wiki/Systemd # skip-grant-tables [mysqld_safe] log-error=/var/log/mariadb/mariadb.log pid-file=/var/run/mariadb/mariadb.pid
The installation of micro-updates started from the Plesk home screen fails:
Failed to update Panel. You can send the update log to Parallels support to try fixing the issue. View the update log.
Attempting to access the update log fails:
Error Internal error: File specified by 766460e6-7587-54f1-e1be-794e5655c4a4 was not found Message File specified by 766460e6-7587-54f1-e1be-794e5655c4a4 was not found File LogFile.php Line 36 Type Smb_Exception_NotFound
Cause
The Plesk Installer has failed or was terminated.
Workaround
1) (Linux only) Remove the /tmp/psa-installer.lock file
2) Remove stale records from the ‘psa.longtasks’ and ‘psa.longtaskparams’ tables:
mysql -uadmin -p`cat /etc/psa/.psa.shadow` mysql> use psa; mysql> begin; mysql> DELETE longtasks, longtaskparams FROM longtasks INNER JOIN longtaskparams WHERE longtasks.type='panel-update' AND longtaskparams.task_id=longtasks.id; mysql> commit;
Install updates through Tools & Settings > Updates and Upgrades or from the command-line
# /usr/local/psa/admin/bin/autoinstaller --select-product-id plesk --select-release-current --reinstall-patch --install-component base
If the update fails again, Check you logs:
/tmp/autoinstaller3.log
c:\ParallelsInstaller\autoinstaller3.log
Symptoms
When I use Plesk Migration Manager to migrate data manually I get the following error:
# tail -f /usr/local/psa/admin/logs/panel.log PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 64 bytes) in /usr/local/psa/admin/plib/backup/Conflicts/Detector/ConflictDetector.php on line 495
I get this error after starting import from the migration file /work_dir/dump.xml.
Resolution
There is not enough memory for Plesk Panel php. You need to increase memory_limit for Plesk Panel php in /usr/local/psa/admin/conf/php.ini file up to 512 Mb.
To check if settings were applied correctly you can run
/usr/local/psa/admin/bin/php -info | grep memory_limit memory_limit => 1024 => 1024
Change to:
# memory_limit = 1024M
Symptoms
Migration hangs
Migration fails with error:
[2015-04-19 22:36:29.393|52103] INFO: tError_ParseFile[9b85e473-5336-4e8b-8212-aa706386adbd]: The XML file - was not parsed successfully with the following errors:
Entity: line 6:parsererror :Opening and ending tag mismatch: hr line 5 and body</body> ^Entity: line 7:parsererror :Opening and ending tag mismatch: body line 3 and html</html> ^Entity: line 7:parsererror :Premature end of data in tag html line 1</html> ^ [./xml_parse.cpp:126]
plesk::tXmlDocument::tXmlDocument(const string&)
Migration fails with error
INFO: FailedDomainDeployment[8b8adf25-291f-4e3b-8624-63c3a4989bba]: Failed deployment of domain domain.tld [./domain_deploy.cpp:410]
void plesk::tDomainDeployer::operator()(plesk::XmlNode) const
Inner exception:
ExecCliGate::GateError[a0116883-7cd4-42c8-8f90-08c786e41318]: Error during CLI Gate interface usage: transfer closed with outstanding read data remaining [./cmd_exec.cpp:192]
void plesk::CliExec::makePostRequest(const string&)
Plesk becomes unaccessible during migration, error in migration logs:
[2015-04-19 22:36:29.393|52103] INFO: Normalized HTTP response: <html>
<head><title>504 Gateway Time-out</title></head>
Cause
sw-enginer stuck on destination server.
Resolution
Increase limit for open files:
Modify ‘/etc/init.d/sw-engine’, add the following into the startup script:
ulimit -n 65536
Restart the services:
#service sw-engine restart
#service sw-cp-server restart
If Nginx alredy service stuck:
a. Kill alll nginx processes using the below command:
# killall nginx
b. Restart nginx service:
# systemctl start nginx.service
Disable and re-enale nginx using nginxmng:
# /usr/local/psa/admin/bin/nginxmng -d
# /usr/local/psa/admin/bin/nginxmng -e
# /usr/local/psa/admin/bin/nginxmng -s
Enabled
Unable to create subscription/domain: IP address does not exist
Symptoms
An attempt to create a subscription / domain fails with the following error:
Error: Unable to find service node for ip address with id=2
Error: Failed domain creation: Unable to update domain data: IP address with ID ‘2’ does not exist
It is not possible to manage Web Hosting Access. An attempt fails with the following error:
Error: Unable to find service node for ip address with id=2
Cause
Database inconsistency.
Resolution
Create a backup of the psa database:
# mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` psa > /root/psa.sql
Check if the IP_Addresses table has record(s) with an IP address that does not exist in the ip_pool tables:
mysql> select * from ip_pool where ip_address_id not in (select id from IP_Addresses);
+----+---------------+--------+
| id | ip_address_id | type |
+----+---------------+--------+
| 1 | 2 | shared |
+----+---------------+--------+
1 row in set (0.00 sec)
mysql> select * from IP_Addresses where id =2;
Empty set (0.00 sec)
mysql> select id, serviceNodeId, ip_address from IP_Addresses;
+----+---------------+--------------+
| id | serviceNodeId | ip_address |
+----+---------------+--------------+
| 1 | 1 | x.x.x.x |
+----+---------------+--------------+
1 rows in set (0.00 sec)
As can be seen in this example, the ip_pool table includes an entry regarding a nonexistent IP address ( ip_address_id = 2);
Delete this record from the ip_pool table:
mysql> delete from ip_pool where ip_address_id=2;
Query OK, 1 row affected (0.00 sec)
http://kb.odin.com/en/118352
Just run in command line
# /usr/local/psa/bin/domain -u yourdomain.com -cgi-mode webspace
or
# /usr/local/psa/bin/domain -u yourdomain.com -cgi-mode www-root
or
# /usr/local/psa/bin/domain -u yourdomain.com -cgi-mode ols-style
and check results.
http://kb.odin.com/en/237
Here are some steps you can follow (It assumes that you have ASP.NET extension allowed in IIS mmc Web services extensions and your ASP.NET works — you can check event logs for possible errors):
1. Try Plesk Reconfigurator (Start->All Programs-SWsoft->Plesk Reconfigurator-> Repair Plesk installation->check File Security)
2. If above step has not helped:
Start->Run->cmd
cd %plesk_dir%
websrvmng –remove-vhost –vhost-name=your_domain_name_which_doesn’t_works
________________________________________
check for errors if they are present post their description here
________________________________________
websrvmng –reconfigure-vhost –vhost-name=your_domain_name_which_doesn’t_works
________________________________________
check for errors if they are present post their description here
________________________________________
3. If above steps haven’t helped:
a).In IIS mmc right click domain -> Click Properties->Click Directory Security Tab->Click Change
b).Ensure that anonymous access is selected
c). Ensure that IUSR_domain_user account is selected for access
d). Ensure that Windows integrated authentications is selected
4).
a).Click Start-> My Computer
b). type %plesk_vhosts%->click enter
c). Right click domain-> Click Sharing and Security-> Click Security Tab-> Click Advanced
d). Ensure following ACL schema is applied:
(Note: Domain user is an account you’ve created for domain user to access ftp)
_________________________________________
Administrator Full Control not inherited for this folder,and subfolders and files
System Full Control not inherited for this folder,and subfolders and files
Domain user Read not inherited for files only
Domain user Read and Execute not inherited for this folder,and subfolders
__________________________________________
e) Double click domain-> Right click httpdocs-> Click Sharing and Security-> Click Security Tab-> Click Advanced
f). Ensure following ACL schema is applied:
__________________________________________
Administrator Full Control not inherited for this folder,and subfolders and files
System Full Control not inherited for this folder,and subfolders and files
Domain user Full Control not inherited for subfolders and files
Domain User Special not inherited for this folder only (will be detailed later)
Plesk IIS WP USER (Machine\IWAM_application_pool) Read not inherited for files only
Plesk IIS WP USER (Machine\IWAM_application_pool) Read and Execute not inherited for this folder,and subfolders
Plesk IIS USER (Machine\IUSR_domain_user) Read not inherited for files only
Plesk IIS USER (Machine\IUSR_domain_user) Read and Execute not inherited for this folder,and subfolders
FPSE_xxxxx(Machine\FPSE_xxxxx) Read not inherited for files only
FPSE_xxxxx(Machine\FPSE_xxxxx) Read and Execute not inherited for this folder,and subfolders
_________________________________________
(Note: the last two permissions present only if you have MS Front Page allowed for domain)
_________________________________________
Domain User special permissions set to allow
Traverse folder/execute files
List Folder/ Read Data
Read Attributes
Read Extended Attributes
Create Files/Write Data
Create Folders/Append Data
Read Permissions
__________________________________________
5. If above two steps in addition to previous steps have not helped:
a). Right click My Computer->Click Manage
b) Double Click Local Users and Groups
c) Click Users->In right pane right-click IUSR_domain user->Click reset password->type desired password ->click OK
6. If above steps have not helped.
a).Backup Domain using Plesk backup (Start->All Programs-SWsoft->Plesk backup->Ensure only that one domain checked-> Click Start) Ensure domain successfully backed up!!!!!
________________________________________
check for errors if they are present post their description here
________________________________________
b).Remove domain from Plesk (If you have external SQL databases ensure you know db user password, also write down any DSN created for domain)
c). Restore domain from backup (Start->All Programs-SWsoft->Plesk restore-> select backup for domain->select by domains option-> Click next-> Ensure domain binded to right IP-> click next-> Ensure Keep current key option selected-> If you have MSSQL database enter user login and password-> Click Start
d) Restart IIS
If a manual transfer is required (for mail content, a complete server after a crash, database moving, etc.), refer to the following sources:
112699 How to restore a Plesk installation on the new server after a disaster
3072 How do I restore Plesk from the hard disk drive if the Operating System is broken and the HDD with the old OS and Plesk is mounted in the new system?
1152 How to migrate Plesk data manually with Plesk Migration Manager
6518 How to migrate local database between Plesk servers manually (applicable for versions 8.x and 9.x)
6158 How to migrate Сalendar, Personal Address Book, and Horde Webmail preferences manually
5882 How to migrate Plesk and SiteBuilder content and retain Plesk and SiteBuilder integration (applicable for versions 8.x and 9.x)
Steps
How do I restore Parallels Plesk from a hard disk drive if the Operating System is broken and the HDD with the old installation is mounted to the new server?