Plesk 11.x / Linux :: Autoupdate Fails ERROR While Trying To Backup MySQL Database
Jun 16, 2014
why but autoupdate fails. It doesn't give a reason why it cant backup.
For line of log :
START pp11.5.30-bootstrapper-11.5.30-cos5.build115131216.11 installing AT Thu Mar 27 07:43:37 CET 2014
Last lines of log :
===> Upgrading database
Trying to start service mysqld... mysqld (pid 24610) is running...
done
Trying to establish test connection... connected
done
Trying to find psa database... version is 011005030
Version is OK, no need to create psa database.
Trying to backup MySQL database...
ERROR while trying to backup MySQL database
Check the error reason(see log file: /tmp/plesk_11.5.30_installation.log), fix and try again
Trying to start psa...
**** Product prep-install for BASE failed.
***** problem report *****
ERROR while trying to backup MySQL database
Check the error reason(see log file: /tmp/plesk_11.5.30_installation.log), fix and try again
STOP Bootstrapper 11.5.30 prep-install for BASE AT Tue Jun 17 04:04:48 CEST 2014
View 2 Replies
ADVERTISEMENT
Jun 3, 2015
I am having trouble with backing up a wordpress multisite.. When backup is on i am getting this error:
Not all the data was backed up into /var/lib/psa/dumps/domains/<domain>/databases/<db_name> successfully. mysqldump: Got error: 1016: Can't open file: './<db_name>/<some_table>.frm' (errno: 24) when using LOCK TABLES
View 3 Replies
View Related
Dec 12, 2014
On our Centos 6.5 Vps with Plesk 12.0.18 the scheduled backup to a personal repository ftp fails every time with this error:
ERROR: () Unable to rotate dump: The dump rotation is failed with code '126' at /usr/local/psa/admin/bin/plesk_agent_manager line 1041.
ERROR: () Can't upload file 'clients/vorrei-cloud/domains/vorrei.org/backup_vorrei.org_info_1412130307.xml' to ftp. Error code: 1
On the target server there are nothing.
View 1 Replies
View Related
Sep 6, 2014
I experienced an issue using an external backup repository on Plesk 12.0.18 machines using ftps. The ftp server uses ftps (explicit) connections.Plesk 11.5 works fine (and ordinary ftp client like Filezilla as well), Plesk 12 throws the following error when trying to add the server via the web interface:
Code:
Curl error: Login denied
Unencrypted connections will work. Plesk 11.5 machines (with the same settings) will work.
I've analyzed the problem and got so far: The backup manager tries to connect using "regular" transfer method + ssl, not ftp-ssl explicit.Is there a chance to force Plesk using explicit ftpes connections? Or is there another work around?Some additional infos about the (ftp) server: The ftp server is running ProFTP 1.3.4d, uses port 2000 for the control port and has a port range (2001 - 2100) for the passive connections.I tried to add the server using the address field of the gui IP:2000 and checkboxed "passive mode" and "ftps".
View 4 Replies
View Related
Feb 19, 2015
My OS is CentOS 5.8.
Plesk is 11.0.9.
Having problems with failed daily domain backups. All databases that have been created by Plesk cannot be backed up, thus backup fails with the following message:
<?xml version="1.0" encoding="UTF-8"?>
<execution-result status="error" log-location="/usr/local/psa/PMM/sessions/2015-02-19-044701.875/migration.result">
[Code]...
View 4 Replies
View Related
Feb 12, 2015
I'm new to Parallels Panel. I use version 11.0.9. I want to backup mysql database daily. First of all, what is the best way for daily database backup in plesk. I'm trying to do this in Scheduled Tasks and I use mysqldump command although I'm not sure.
I chose the time and day first and then I switched on the task. I typed the following command to Command line.
mysqldump -uusername -ppassword databasename | gzip -9 >/httpdocs/mydatabase.sql.gz
or
mysqldump -uusername -ppassword databasename >/httpdocs/mydatabase.sql.gz
This created only a blank file. When I use this without gzip, nothing changes.
1- Is mysqldump right command for database backup?
2- Should I define full path for mysqldump, gzip and database? If so, how can I find out the full path of mysqldump, gzip and my database? Because I can't see their locations in panel.
3- I can't see any error message. There is not any log file in httpdocs folder. Where does the log file exist?
4- It is weird but should the username be "database user" or should I write "root" ?
View 2 Replies
View Related
May 27, 2014
I need a command way of backing up my website files and Mysql databases. I no longer have access to the static ip to access the panel.
View 1 Replies
View Related
Feb 2, 2015
After successful creation of a full backup, pmm-ras hangs forever (100% CPU) while trying to export the dump to FTP. I have two identical Plesk 12.0.18 installations and this happens only on one of them.
I see the following in /opt/psa/PMM/sessions/*/.stderr:
Use of uninitialized value in numeric eq (==) at /opt/psa/admin/bin/plesk_agent_manager line 827.
View 3 Replies
View Related
Dec 29, 2014
after every autoupdate mail and ftp fail. Only an psa stopall / start can solve this.
Using DEB7 Plesk 12.0.x
View 19 Replies
View Related
May 5, 2015
Ive the problem that i must update my Plesk manual, after Server-Restart i become this Error:
ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [1045] Access denied for user 'admin'@'localhost' (using password: YES) (Abstract.php:144)
I tried this: URL....Ive got a Linux V-Server from Strato!
View 5 Replies
View Related
May 26, 2015
Plesk recently attempted to do an auto-update and it failed. I have not been able to get it to update since. When I connect using SSH, and try to do a manual yum update I get the following error:
Code:
Loaded plugins: fastestmirror
Setting up Update Process
Loading mirror speeds from cached hostfile
epel/metalink | 13 kB 00:00
Traceback (most recent call last):
File "/usr/bin/yum", line 29, in <module>
[Code] .....
View 3 Replies
View Related
Jun 1, 2015
I am getting an Error at running this command '/usr/local/psa/admin/sbin/mchk --with-spam'
boss@server:~# /usr/local/psa/admin/sbin/mchk --with-spam
==> Checking for: mailsrv_conf_init... ok
==> Checking for: mail_handlers_init... ok
==> Checking for: mailsrv_entities_dump... ok
==> Checking for: mail_admin_aliases... ok
==> Checking for: mail_auth_dump... ok
[Code] ....
The Dump Log of /usr/local/psa/admin/logs/panel.log
[URL] .....
Executing: /usr/lib/plesk-9.0/remote_mail_restore/mail_outgoing_restore
Log: [URL] ....
View 1 Replies
View Related
Mar 20, 2014
I have Plesk Windows version, when I want import my backup mysql, i see below error:
Error: dbbackup failed: Unable to restore database 'admin_IranDnn'
ERROR 2006 (HY000) at line 1: MySQL server has gone awayClick to expand...
View 7 Replies
View Related
Dec 23, 2014
I'm having a problem with Plesk Panel 11.0.9 update #64. All other page running perfect. But when I go to "Backup Manager --> Database Backup Repository --> Upload Backup File" then Plesk Panel show error: Internal Server Error 500.0.
On server, it show detail below: .....
View 2 Replies
View Related
Mar 28, 2015
12.0.18 update #39
Server 2012r2
Logged into my panel today to run a database backup on a site I'm working on to be confronted with the following:
Unable to backup database 'XXXXXXXXXX'
Cannot open backup device 'C:Program Files (x86)ParallelsPleskBackupXXXXXXXXX.co.nzdatabasesXXXXXXXXX-29 est'. Operating system error 5(Access is denied.).
BACKUP DATABASE is terminating abnormally.
(Error code 21)
I'm not sure why permissions would change on their own, I'm also not sure how to fix the permissions error. I get the same error on all databases.
PrivateTemp folder appears to have write permissions for Group MSSQLSERVER
View 6 Replies
View Related
Mar 12, 2015
Any way to backup every SQL Databases at once ?
At the moment i need to configure each subscription on my backup program to backup each sql database.
there is any way to set a login that back's up all the databases?
And for the ftp files?
View 1 Replies
View Related
Jul 14, 2015
My panel suddenly stop works to create databases from client account.This error shows:
Internal error.
PHP Notice: Undefined variable: dbType
From admin account there is no problem to create databases.I`ve run bootstrap.sh repair successfully but still not working.Plesk 12.0.18 #55 Ubuntu Linux 10.04
View 2 Replies
View Related
Oct 9, 2014
I just tested the WP creation feature of PP12 and I get the following error when I attempt to view the newly created CMS...
"Error establishing a database connection"
If I navigate to the database page and click webadmin, I can connect and see the WP database created. Everything works in phpMyAdmin.
Going to ../wordpress/wp_login.php returns the error.
View 3 Replies
View Related
May 9, 2014
PRODUCT, VERSION, MICROUPDATE, OPERATING SYSTEM, ARCHITECTURE
Plesk 11.5, 11.5.30 Update #44, last updated at April 30, 2014 03:25 AM, Centos 6.5 (Final), Linux 64bit
PROBLEM DESCRIPTION
When I try to add an extra MySQL server, running on a different server, I always get an error that the user has no admin access. But the user I created does have admin access to the database.
The remote database is a MySQL 5.5 on a Linux Ubuntu 12.04 LTS server
STEPS TO REPRODUCE
Tools & Settings -> Database Servers -> Add Databases server
ACTUAL RESULT
Error: Test connection to the database server has failed because the supplied account does not possess administrative privileges: Access denied for user 'admin'@'%' to database 'd536cedf97037e'
EXPECTED RESULT
A working database connection.
ANY ADDITIONAL INFORMATION
These queries are logged by MySQL:
140509 16:54:51 28 Connectadmin@10.1.0.162 as anonymous on
28 QuerySELECT VERSION()
28 Querycreate database `BUG115166_1374110215536CEC3816DD2` /*!40101 default charset=utf8 */
28 Querycreate database `bug115166_1374110215536cec3816dd2` /*!40101 default charset=utf8 */
28 Queryinsert into mysql.user (Host, User, Password) values ('%', 'bug115166_17546', password('BUG115166_1374110215536CEC3816DD2'))
28 QueryFLUSH PRIVILEGES
[Code] .....
If I just ignore this message, go to a subscription and create a database, then the database gets created just fine. It's just Plesk that thinks that something went wrong.
View 2 Replies
View Related
Sep 9, 2013
I just upgraded from 11.0.9 and i got the following error
ERROR: Zend_Db_Statement_Exception
Eine Ebene höher
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ipAddress' in 'where clause'
A Google Search shows that under Windows there is dbupgrade.exe
Is there such a tool under Linux too??
View 4 Replies
View Related
Nov 5, 2014
I have this error when i put import to mysql database
Code:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<script></script><p>ERROR: Maximum execution time of 300 seconds exceeded (Util.' at line 244
I have in domain > doemainname >
max_execution_time
Standaard
Geef een aangepaste waarde op 0
and insert in
usr/local/psa/admin/htdocs/domains/databases/phpmyadmin in the file config.sample.inc.php following command
$cfg['ExecTimeLimit'] = 70000;
but it will not work...
View 2 Replies
View Related
Jun 22, 2014
I upgraded Plesk 11.5 to the latest version 12.0.08 # 5 and now I can not configure the external FTP backup I get the error:Transport error: unable to list directory: Curl error: Timeout was reached. Also failing the backup shows this error: Unable to rotate dump: The dump rotation is failed with code '126 'at / opt / psa / admin / bin / plesk_agent_manager line 1041.
And this one:Can not upload file 'domains/domain.tld/backup_domain.tld_info_1406210716.xml' to ftp. Error code: 1..my SO Debian 6.0.8
View 19 Replies
View Related
Mar 30, 2015
I cant connect to the Database WebAdmin. If I click the icon, i got an "File not found." in the opening tab. Back in Plesk I get the following:
ERROR: PlexkFatalException
Server id is undefined?
I even cant connect via ssh to the mysql part of my server. But the server is running and both of my two wordpress pages run smoothly. I know this page: [URL] .... – but as I sad, cant enter die mysql.
It seems something is wrong with the permissions. I'm on the point where I just want to reset everything database related. But how?
View 2 Replies
View Related
Nov 16, 2014
i have make a full Plesk Backup on my Old Server with Plesk 12.0(Ubuntu) and will restore the Backup on my new Server with Plesk 12.0(CentOS).When i will restore the backup i get this error: "Error: The source file is not a valid XML file. If you supplied an archive file containing a backup from Plesk version 9 or later, then extract the contents of this archive, and process the extracted XML file with the converter. If you want to convert a backup file from a Plesk version earlier than 9, then you first need to process it with the pre9-backup-convert utility, and then process the resulting file with the pre10-backup-convert utility."
In the Logs i found this:
deployer.log - [URL] ...
import.log - [URL] ...
pmmcli.log - [URL] ...
View 4 Replies
View Related
Jun 4, 2014
I recently started getting errors when attempting to backup our web server.
Code:
Warning: mysql "db_xxx_0"
Failed to pack files webxx-fullbackup_db_xxx_0_1_1406050308 in /mnt/backup/location [ 412107659264 bytes free of 541129271296 bytes total on mount point 0]
Warning: mysql "db_xxx_0"
Use of chdir('') or chdir(undef) as chdir() is deprecated at /opt/psa/PMM/agents/shared/Storage/Bundle.pm line 38.
mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `wp_postmeta` at row: 1357
View 1 Replies
View Related
May 31, 2015
This is on a CentOS 7.1, Plesk 12. New.
On Plesk 10.4 I had a script that backed up my MySQL databases separately. The script doesn't work now. I get an error:
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
Do I need to do something different with this new "MariaDB" thing?
Here's the script:
DB_BACKUP="/pat/to/databackup/`date +%Y-%m-%d`"
DB_USER="admin"
DB_PASSWD="-p`cat /etc/psa/.psa.shadow`"
HN=`hostname | awk -F. '{print $1}'`
[Code] ....
View 4 Replies
View Related
May 7, 2015
I freshly installed Plesk 12.0 on Ubuntu 14.04. Everything works accept the MySQL database creation.
When I try to create one, i get this error :
error: the test connection to the database server has failed because of network problems: connection refused...
View 1 Replies
View Related
