I have a problem with restore ms sql server 2008 database after restoring the message...Error: Unable to creste database user: Database user name is invalid. Only latin letters are allowed in the database user nameerror
View 1 Replies
Trying to restore a database in plesk 11 I got the following error.
Error: dbbackup failed: Unable to restore database 'database_name'Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
There is no wrong with the db, when I restore from it on local machine everything works.
I installed plesk win 12 with mssql2012 , but nobody as abale to restore DB via plesk we recive this error Error: dbbackup failed: Unable to restore database 'degardis'Format of the initialization string does not conform to specification starting at index 29.the backup file is restored straight via sql management studio.
View 1 Replies View RelatedUnable to restore database '17'
Not valid backup:
Cannot open backup device 'C:Program Files (x86)ParallelsPleskBackupclub-panel.irdatabases171.bak'. Operating system error 5(Access is denied.).
VERIFY DATABASE is terminating abnormally.
(Error code 22)
---------------------- Debug Info -------------------------------
I have daily backups for all accounts setup on our Plesk 11 server and was wondering how I would go about restoring a single database from the backup manager? I could restore the entire zip file, but that would make a mess of any other databases which of course isn't optimal. I see if I download a client's zip file that within the zip_file/databases/db_name there is another zip file which contains a tmp file which for a MySQL database it looks fairly standard, for MSSQL it looks to be in their format but is this what's really necessary? Can I even use those tmp files to restore manually through the Backup Manager -> Database Backup Repository? Why isn't there a simple way for a client to restore a database with the existing backups?
View 2 Replies View RelatedI 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...
When restoring a backup on Plesk 12, the error below is generated for some sites and the sites are only partially restored. Although the message talks about disk space, there is in fact plenty of free disk space - i.e. many GB. The backup was created on Plesk 11.5. The restore on Plesk 11.5 works.
I noticed that all the failed domains exceed the disk space allowed by their Service Plan. However, the 'Overuse is allowed' setting is selected. Strangely, I tried changing the Service Plan and retrying the backup and restore, and the same errors were generated.
<object type="domain" name="domain.com">
<object type="hosting" name="domain.com">
<message code="CantUnpackDomainContent" severity="warning" id="f3946c79-7ae2-4be2-8300-ba766bea7869">
<description>Can not deploy content of domain domain.com</description>
[Code] .....
I'm trying to restore a 600MB database which was uploaded to the repository in plesk. This database backup did NOT originate from this server, but rather I'm attempting to overwrite a blank database that was created with the same name via plesk.
The site is one of our web-spaces (not a customer subscription) so I am logged in as the plesk administrator.
System Info:
Plesk 11.5
Windows 2008 R2 (64Bit)
3GB RAM
MySQL 5.1
Full Error: dbbackup failed: Unable to restore database 'databasename' Exception of type 'System.OutOfMemoryException' was thrown.
I have tried altering the php.ini the PHP settings of the site (even though I'm logged in as the adminsitrator) as well as the php.ini of: C:ParallelsPleskadminphp.ini
memory_limit=2048M
It fails with the error after about 1GB of RAM usage on the server.
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: .....
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
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] ...
Can't restore.
plesk Internal error: Failed to exec pmm-ras: (array ( 'code' => 127, 'stdout' => 'Transport error: File '_info_1503031904.xml' not found ', 'stderr' => '', )).
in debug mode:
Internal error: Failed to exec pmm-ras: [2015-03-05 16:19:49.215|23284] INFO: pmm-ras started :
/usr/local/psa/admin/bin/pmm-ras --get-dump-info --dump-file-specification=_info_1503031904.xml
--session-path=/var/log/plesk/PMM/logs --debug [2015-03-05 16:19:49.215|23284]
INFO: Repository '/var/lib/psa/dumps': Initializing...
[Code] .....
I cant restore my back up. Get following warnings:
Warning:
php_version 5.3 is not supported. It will be replaced with php_version 5.4 for the following service plans: Unlimited, Admin Simple, Default Domain, Default Simple, Web Presence Builder, SiteBuilder
Warning:
python is not supported. It will be disabled for the following objects: Service plan 'Unlimited', Service plan 'Admin Simple', Service plan 'Default Domain', Service plan 'Default Simple'
Warning:
The component fail2ban is not installed. It will be disabled for the following objects: Server settings
Warning:
php_version 5.3 is not supported. It will be replaced with php_version 5.4 for the following websites: swen.flugzeugbilder.orgClick to expand...
Next error:
C:Windows>"%plesk_bin%mchk.exe" --all --fix=all
Data error (cyclic redundancy check). (Error code 23) at BCryptDecrypt()
I restore all mail accounts from backup and use this command : "%plesk_bin%mchk.exe" --all --fix=all
How can I fix this?
I'm backing up a domain in Plesk Panel 11.0.9 on Windows, it's a large backup with 50,000+ images in it so the backup gets split into multiple zips
xxxxxx__xxxxxx.com_vhost_1309200100.zip
xxxxxx__xxxxxx.com_vhost_1309200100.zip1
xxxxxx__xxxxxx.com_vhost_1309200100.zip2
xxxxxx__xxxxxx.com_vhost_1309200100.zip3
Now what I want to do is restore 11 files from the backup. What I certainly don't want to do is restore the entire domain as I don't want to loose any changes since the last backup.
As it seems impossible to extract files from the archives.
How can I restore/update permission for all domains -> only web-stats permission?
P.S. When users rename username for FTP access, web-stat remove old username and don't add new username to nfts permission.
I make full backup from my Plesk 11 server and Copy All files over %plesk_dir%/Backup to New server. When I tried to restore them I received this error !
Warning:reseller "banipersia"
Failed deployment of domain baqdad.com
Warning:
Execution of "C:Program Files (x86)ParallelsPleskbindomain.exe" --create baqdad.com -owner "" -do-not-apply-skeleton -notify false -guid D854C8FC-19DE-4256-A172-888155D012A9 -vendor-guid 194764FD-2B44-4F82-BA33-988DFF49FCFE -creation-date 2013-05-23 -ip 78.138.101.47 -ignore-nonexistent-options failed with return code 1.
Stderr is
Wrong syntax for command's '-owner' parameter. '' does not match the pattern '/^[^s]{1,255}$/'.
When i try to restore a domain from Server Repository I am getting this strange error
Internal server error:
ERROR: Call to a member function write() on a non-object (Apache.php:821)
How could I fix it?
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] ....
I restored Plesk Panel from web-gui up to 11 hours, is it normal?I have more that 300 accounts.
View 1 Replies View RelatedMy windows server's hard disk was crashed & now I have mounted it as secondary hard disk on the server .
Now I want to restore the data to new server .
After a server migration, some critical Plesk settings were not copied across, even though the option to backup/restore panel configuration was used. e.g.
skeleton (vhosts.skel folder)
php.ini (Program Files (x86)ParallelsPleskAdditionalPleskPHP5* folder)
Default site (vhostsdefault folder)
health config (Program Files (x86)ParallelsPleskadminconfcustom-health-config.xml)
Additional Administrator accounts
Is there a way to get these things to backup and restore that I am doing wrong?
Are there other important settings/data that I have missed from that list? I am still paying to keep the old server in case I discover something else!
Using Plesk Backup & Restore for disaster recovery will lose these settings unless they take extra steps. e.g. I now have a simple batch file that copies these files to a private folder on one of the domains before the daily backup kicks in.
Would like to know what are the dangers of backing up and restoring full entire system backups (with plesk installed) to another server with a different ip address? Will the restored plesk setup operate properly and offer an ip address change in the system, or will there be any pre-requisites required such as manual ip changing within the system core files?
View 1 Replies View RelatedI got this error when i try to active an account in Plesk.
Error: DNSZone::Table::select() failed: no such row in the table
And when o try to solve issue by the following steps,
1) Login to mysql psa database using the plesk administrator password,
cd %plesk_dir%Mysqlin
mysql -h 127.0.0.1 -uadmin -p -P 8306 psa
I got : Unknown psa Database...I'm ensure that database is founded on the server under C:Program Files(86x)MysqlData
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
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.
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.
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??
I have on my server vBulletin 1.7GB database in SQL format I try somany time to restore it but its hang! I transfer that file to another server and its working fine!
I see the MySQL Processes:
Code:
+----+--------------+-----------+--------------+---------+------+----------------------+--------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+--------------+-----------+--------------+---------+------+----------------------+--------------------------------------------+
| 11 | leechprotect | localhost | leechprotect | Sleep | 2073 | | |
| 22 | eximstats | localhost | eximstats | Sleep | 1902 | | |
| 25 | xxxtyyx_vb | localhost | xxxtyyx_vb | Query | 1494 | Repair with keycache | /*!40000 ALTER TABLE `post` ENABLE KEYS */ |
| 41 | root | localhost | | Query | 0 | | show processlist |
+----+--------------+-----------+--------------+---------+------+----------------------+--------------------------------------------+
Its stay like that for long time!
