Error: Test the database server connection failed:
mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD('your_existing_password'). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file
We have a little issue with the API, when we want to add an subscription, then we became "Error: Permission denied. (1006)" - but the subscription was added. The status Icon of the Subscription is a "!" and they say (tooltip), that the Plan wasn't correctly synchronized, but we don't use a Plan for this. The Reseller has all rights, there are now limits.
Warning: session_start() [function.session-start]: SQLite: failed to open/create session database `/var/cpanel/userhomes/cpanelphpmyadmin/sessions/phpsess.sdb' - malformed database schema - unable to open a temporary database file for storing temporary tables in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/session.inc.php on line 86
Fatal error: session_start() [<a href='function.session-start'>function.session-start</a>]: Failed to initialize storage module: sqlite (path: /var/cpanel/userhomes/cpanelphpmyadmin/sessions/phpsess.sdb) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/session.inc.php on line 86
I get that error in cPanel when I click to go to phpmyadmin.
This is a new test install of PPA 11.5.5 with currently 8 nodes: CP, Apache, IIS, MySQL, Mail, 2 BIND, and Webmail. Installation and adding nodes went pretty much without a hitch so I'm testing account creation, subscription settings, etc. but I'm not getting very far. Anytime I try to add a subscription (any subscription) to an account I get the error: "Owner with external ID = '211' does not exist in Plesk database" The actual ID number varies depending on which account I'm trying to add a subscription to, but otherwise it's always the same error. I've tried the built-in default subscriptions, I've tried creating my own...same results either way.
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;
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
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.
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" ?
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?
I have been trying to enable server-wide compression using deflate.My server is running a fresh install of plesk panel 11 installed over a fresh centos 6 64. The configs and settings (aside from files I mention) have not been changed at all from default.
I have created a new file in /etc/httpf/conf.d/deflate.conf This file is being included when Apache is restarted, so that's definitely working and the html doc compresses. But not matter what I do (I have tried every combination Google would find) css and js files will not compress. At my previous workplace we also used a Plesk server and nobody could ever get compression working there either.