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??
When I update servers via CLI autoinstaller, I always (afair) get this mysqldump error message:
Code:
Stopping psa... * Stopping Plesk engine pool manager sw-engine-fpm
...done.
done
-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
mysqldump: Got error: 1049: Unknown database 'atmail' when selecting the database
===> Cumulative APS controller database (apsc) upgrade has been started.
===> Cumulative upgrade of APS controller database has been completed.
===> Cumulative Plesk database upgrade (revertable stage) has been started.
===> Preparing Plesk database upgrade (revertable stage).
===> Cumulative upgrade of Plesk database (revertable stage) has been completed.
Reading package lists...
There is no database "atmail" on any of our Plesk servers. Simple solution should be to first check if the DB exists before performing actions on it.As a bonus, perhaps it would be possible to suppress the warning about mysql.event.
ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [1049] Unknown database 'psa' (Abstract.php:144)
View 3 Replies View RelatedI have a mysql database, and what I wanna do is to back up specific columns only. For example, I have a table with 2 columns:
City, Zipcode
How can I do that with mysqldump?
I've been with my Strato VServer and it installed Plesk on Linux a big problem.
I coming no longer in the Plesk Dashboard and the following code appears:
Syntax error or access violation: 1286 Unknown table engine 'InnoDB'
Here are the contents of my my.cnf
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
[Code] .....
I am using Parallels Plesk Panel v. 11.0.9 on a V-Server provided by Strato (Germany), the OS is Ubuntu 10.04 LTS. Established and running under Plesk is a MySQL-Database, administered via Plesk by PHPMyAdmin 3.5.8.1. PHPMyAdmin offers the following information:
Datenbank-Server
Server: Localhost via UNIX socket
Software: MySQL
Software-Version: 5.1.41-3ubuntu12.10 - (Ubuntu)
Protokoll-Version: 10
Benutzer: admin@localhost
Server Zeichensatz: UTF-8 Unicode (utf8)
Webserver
sw-cp-server
Datenbank-Client Version: libmysql - mysqlnd 5.0.8-dev - 20102224 - $Id: 731e5b87ba42146a687c29995d2dfd8b4e40b325 $
PHP-Erweiterung: mysql
Click to expand...
I have upgraded from 11.5 to 12, and now if I try to open Plesk on the port 8443 I have this error:
502 Bad Gateway
nginx
This is the log:
2014/06/27 18:25:13 [crit] 1629#0: *2 connect() to unix:/var/run/sw-engine.sock failed (2: No such file or directory) while connecting to upstream, client: 79.49.206.176, server: , request: "GET / HTTP/1.1", upstream: "fastcgi://unix:/var/run/sw-engine.sock:", host: "87.106.85.233:8443"
I have a V-Server account with Strato and just upgraded to 12.0.18 through the panel updater. The installation completed successfully, at least the installer gave me no error.
After the installation I tried to login and got the following error (I wasn't able to enter my credentials..):
I tried to repair permissions with:
Code:
/usr/local/psa/bin/repair --restore-vhosts-permissions
Which worked and I could now login. The Panel opened with the following error:
I can access certain areas of the panel without error (i.e. tools and settings etc, but I get the error when I try to access the control panel for single domains etc...)
Here an extract from the panel.log
Code:
[17-Jun-2014 19:49:12 Europe/Berlin] Exception: Permission denied
file: /opt/psa/admin/plib/Lock/Manager/Hierarchical.php
line: 105
code: 0
trace: #0 /opt/psa/admin/plib/Lock/Manager/Hierarchical.php(105): LockManagerClient->__construct()
[Code] ......
After upgrading Plesk today the panel is reachable however the content area displays the message "File not found." for all pages.
View 6 Replies View RelatedI just upgraded our Plesk 10.4.4 to 12.0.18 (on Ubuntu 10.04, about to be upgraded to 12.04). Now I get the dreaded 'queue file write error' in postfix on message delivery.
It tries to open /usr/lib/plesk-9.0/postfix-queue (which is not there) in this block in master.cf:
Code:
plesk_virtual unix - n n - - pipe flags=DORhu user=popuser:popuser argv=/usr/lib/plesk-9.0/postfix-local -f ${sender} -d ${recipient} -p /var/qmail/mailnames
127.0.0.1:10025 inet n n n - - spawn user=mhandlers-user argv=/usr/lib/plesk-9.0/postfix-queue 127.0.0.1 10027 before-queue
127.0.0.1:10026 inet n - - - - smtpd -o smtpd_client_restrictions= -o smtpd_helo_restrictions= -o smtpd_sender_restrictions= -o smtpd_recipient_restrictions=permit_mynetworks,reject -o smtpd_data_restrictions= -o receive_override_options=no_unknown_recipient_checks
127.0.0.1:10027 inet n n n - - spawn user=mhandlers-user argv=/usr/lib/plesk-9.0/postfix-queue 127.0.0.1 10026 before-remote
plesk_saslauthd unix y y y - 1 plesk_saslauthd status=5 listen=6 dbpath=/plesk/passwd.db
And on top of that, If disable all the milters/proxy and just try to deliver to plesk_virtual directly, the e-mail just disappears. Postfix thinks it was delivered, but it is not.
I also tried piping some text through /usr/lib/plesk-9.0/postfix-local with the same parameters postfix gives it, but also then nothing. No error, no exit code, no message in maildir.
There are a bunch of fixes around for the queue file write error, but nothing works because the nature of my problem is different. There is a KB article around for Plesk 9, which can hardly be useful.
I tried restoring postfix-queue from the backups, but if I try to use that, the mail.log eventually says:
Code:
Jan 30 01:20:00 ytechosting /usr/lib/plesk-9.0/psa-pc-remote[6621]: Message aborted.
I also used /usr/local/psa/admin/sbin/mchk to no avail: the only change it makes to my master.cf, is adding an empty line. And, I suspect it uninstalled my psa-courier, because it was gone at some point, and mchk was the only thing I did after knowing courier was still there.
How can the postfix config refer to that postfix-queue when it's not there? Is this even a valid master.cf file for Plesk 12?
I am trying to upgrade my Plesk 11.5.30 install to 12.x but I keep getting an error:
Exception: Failed to solve dependencies:
php-devel-5.4.29-35.el6.art.x86_64 requires php-cli(x86-64) = 5.4.29-35.el6.art
Error: The Yum utility failed to install the required packages.
Attention! Your software might be inoperable.
Please, contact product technical support.
I have run the boostrapper repair but the error remains.
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.
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 have a problem with my Parallels Plesk Panel (v 11.5.30) in CentOS 6.4.
When I try to send an email by RoundCube to an other email address with the same domain (that is hosted in my server) i get this error:
Error SMTP (550): ... "xxxxxx@mydomain.com" (5.1.1 <xxxxxx@mydomain.com>: Recipient address rejected: User unknown in virtual mailbox table)
i saw very often in the active sessions site following line:
Username Empty IP empty Date Nov 30, -0001 12:00 AM Idle time 00:45:39
What is that and how can is stop this or get it fixed ?
After Plesk Panel upgrade to 12.x I found a warning showing at Home>Tools & Settings> Database Servers
Warning: Unable to determine the TCP port number used by Microsoft SQL server '.SQLEXPRESS': TCP/IP protocol is not enabled in the server network configuration or the server is configured to use dynamic TCP ports.
To allow your customers to automatically configure firewall for remote database access, manually configure the SQL server to listen on a specific fixed TCP port.Click to expand...
Since we upgraded to Plesk 11.5 or (I'm not shure) the last Update 12, user can not import MySQL-Databases anymore.
If the user open phpMyAdmin for import and select the database and click on Ok, phpMyAdmin does nothing.
I heard that could be a problem with JQUERY and I checked the files in ParallelsadminhtdocsdomainsdatabasesphpMyAdminjsjquery and all files seems to be there.
Only if I check the source of the phpMyAdmin Import-Website it seems, there is a problem with jquery-1.6.2+fix-9521.js.
But how I can fix this problem for all Windows-Servers.
I have setup bind in centos 6.5 and then edited /etc/named.conf and added the lines
The extension produced but I am getting the following error when restarting the bind service
Error in named configuration:
/etc/named.conf:2: unknown option '...'
/etc/named.conf:14: unknown option '*'
/etc/named.conf:21: 'options' redefined near 'options'
The following code suggested by plesk slave dns manager extension
Code:
options {
...
allow-new-zones yes;
};
key "rndc-key-mainserver ip" {
[Code] .....
After I removed ... from the options now I get the following error :
/etc/named.conf:51: unknown key 'rndc-key'
After successful upgrade PHP, and not successful with ioncube i get:
Failed loading /usr/lib/php/modules/ioncube_loader_lin_5.4.so: /usr/lib/php/modules/ioncube_loader_lin_5.4.so: cannot open shared object file: No such file or directory
PHP Warning: Module 'ionCube Loader' already loaded in Unknown on line 0
The ionCube PHP Loader is disabled because of startup problems.
PHP Warning: Module 'ionCube Loader' already loaded in Unknown on line 0
The ionCube PHP Loader is disabled because of startup problems.
PHP 5.4.32 (cli) (built: Aug 21 2014 07:33:35)
Copyright (c) 1997-2014 The PHP Group
Zend Engine v2.4.0, Copyright (c) 1998-2014 Zend Technologies
with the ionCube PHP Loader v4.6.1, Copyright (c) 2002-2014, by ionCube Ltd., andClick to expand...
Now im having a prob in my vps.I am gettin an error when I restart my vps.
iptables: Unknown error 4294967295
iptables: Unknown error 4294967295
iptables: Unknown error 4294967295
iptables: Unknown error 4294967295
After upgrade to Plesk 11.5.30 trying to set up FTP-Backup Repository:
Repository error: Transport error: unable to list directory: Curl error: Access denied to remote resourceClick to expand...