Plesk 12.x / Linux :: Cannot Login - Unknown Database PSA
Feb 22, 2015ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [1049] Unknown database 'psa' (Abstract.php:144)
View 3 RepliesERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [1049] Unknown database 'psa' (Abstract.php:144)
View 3 RepliesWhen 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.
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??
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?
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 ?
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...
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...
Over the weekend, I upgraded from Plesk 10.3 to Plesk 11.5, using the updater in the control panel. Everything seemed to go well. However, this morning I've noticed that some, not all, email accounts are having trouble logging into the server to send and receive mail. Other accounts are working fine.Via POP, I get this error: -ERR Temporary problem, please try again later
Via SMTP, I get this error:
535 auth failure
I see this in the maillog:
Jun 17 07:15:05 [server] courier-pop3d: LOGIN FAILED, user=[username], ip=[::ffff:xxx.xxx.xxx.xxx]
Jun 17 07:15:05 [server] courier-pop3d: authentication error: Input/output error
And this... Jun 17 07:24:50 [server] smtp_auth: FAILED: [email address] - password incorrect from [host] [xxx.xxx.xxx.xxx]
I replaced the server name, username, host, and IP in the above.
Here are the steps I've tried so far.
- Changing the password using the control panel.
- Updating the number of daemons in authdaemonrc
- Restarting the services
I just upgraded my Plesk on Ubuntu (vServer) yesterday. But after the upgrade I couldn't login to the Panel anymore because all I get when I try to reach the panel (https://panel.examplesite.com:8443) is a white screen.
I rebooted the server and restarted the panel as well as Apache several times with no change.
I cannot login to Plesk server with admin credentials as it says Error: Access for administrator from address 'xx.xx.xx.xx' is restricted in accordance with IP Access restriction policy currently applied. Also I cannot SSH to server and it says connection refused.
View 2 Replies View RelatedI have VPS Server with Parallels Plesk 11.5.30 (64 bits) on OVH.ORG..Today i do Update to newest version via https://MY-IP:8447
Code: [URL] .....
Now i cant login to my server: [URL] ....
How can i repair it. I dont wanna install again Plesk Panel becouse i have a lot of configuration and email adress.All components like Apache Mysql, ftp works good, but i cant only login.
I cannot login server:8447
1. netstat -anp |grep 8447 = nothing
2. iptables -L Chain INPUT (policy ACCEPT) - empty; Chain FORWARD (policy ACCEPT) - empty; Chain OUTPUT (policy ACCEPT) - empty
This happened after the unsuccessful upgrade.
Code:
Execution failed.
Command: autoinstaller
Arguments: Array
(
[0] => --select-product-id
[1] => plesk
[2] => --select-release-current
[3] => --upgrade-installed-components
[4] => --include-components-from-class
[5] => vendor=parallels
[6] => --include-components-from-class
[7] => patched
[code]....
ERROR: Failed to download the package URL...transfer closed with 205 bytes remaining to read..Not all packages were installed.Please try installing packages again later.try installing the packages again.
It seems like I have got a lot of trouble with Plesk 12 on a CentOS 7 machine.
1. I could not install Plesk properly due to some drweb problem.
2. Than the smb configuration seems only to be implemented partly.
3. Suddenly FTP login is not possible anymore (503 Access denied)
And now even Apache is not running anymore!
Code:
Unable to generate the web server configuration file on the host <xxxxxxx.dyndns.org> because of the following errors:
Template_Exception: [Mon Jun 08 14:16:28.058302 2015] [so:warn] [pid 4230] AH01574: module actions_module is already loaded, skipping
[Mon Jun 08 14:16:28.063364 2015] [so:warn] [pid 4230] AH01574: module headers_module is already loaded, skipping
[Mon Jun 08 14:16:28.063957 2015] [so:warn] [pid 4230] AH01574: module logio_module is already loaded, skipping
[Mon Jun 08 14:16:28.066150 2015] [so:warn] [pid 4230] AH01574: module suexec_module is already loaded, skipping
httpd: Syntax error on line 357 of /etc/httpd/conf/httpd.conf: Syntax error on line 5 of /etc/httpd/conf.d
[code]....
I'm running plesk 11.0.9 on Centos 6. I can't login anymore, the administration login page is just a blank page. The error in the log file is:
(mod_fastcgi.c.2746) FastCGI-stderr: PHP Fatal error: Call to a member function getContext() on a non-object in /usr/local/psa/admin/plib/Navigation.php on line 54
I would like my clients only to be able to access Plesk Panels from a certain domain, instead all from or with all the domains hosted on our server, is there a way to accomplish that?
View 1 Replies View RelatedWhen I try to login via webmail horde I get always:
Login failed because your username or password was entered incorrectly.
The logfile shows:
Jul 13 12:23:32 HORDE [error] [imp] FAILED LOGIN for mail@domain.tld [1.2.3.4] to to {127.0.0.1:143 [imap/notls]} [pid 5358 on line 139 of "/usr/share/psa-horde/imp/lib/Auth/imp.php"]Click to expand...
I just finished installing Plesk Panel 12. I seems like that everything is working as it should, except for FTP. I am not able to login with any FTP accounts.
View 13 Replies View RelatedVersion: Parallels Plesk v12.0.18_build1200140610.21 os_Ubuntu 14.04
After a few minutes or after specific actions Plesk shows the login screen without obvious reason. For example when I am trying to modify a file online and try to save it for the second time it always shows the login screen.
Also, when I enter the credentials I can see that the previous session(s) remain open. I have configured the session idle time to 1000 minutes, although I do not remain idle for 300 min anyway.
After a fresh install on a Debian Wheezy system, I get the following error(s) when trying to access the control panel.
https://sub.example.com:8443/
404 Not Found
Nginx
My log
Code:
2014/06/09 19:04:15 [warn] 32236#0: conflicting server name "" on 0.0.0.0:8443, ignored
2014/06/09 19:04:26 [error] 22597#0: *43 "/usr/share/html/index.html" is not found (2: No such file or directory), client: 68.51.77.126, server: , request: "GET / HTTP/1.1", host: "sub.example.com:8443"
While http://sub.example.com:8880/ works fine
When a login to my plesk, i look this error:
ERROR: Zend_Db_Adapter_Exception: SQLSTATE[08004] [1040] Too many connections (Abstract.php:144)
ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory (Abstract.php:144)
ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] Connection refused (Abstract.php:144)
I cannot SSH or login into Plesk Admin panel. Once I tried SSH, it says 'connection refused'. Once I tried login into admin panel, it says 'Error: Access for administrator from address 'xxx.xxx.xxx.xxx' is restricted in accordance with IP Access restriction policy currently applied.
Tried restarting the plesk server too. Nothing seems working.
How do they redirect to the Server URL in CPanel.
Eg. <Domain.tld>/cpanel
I looked for directory called /cpanel but non-exist.
I wish to use the same method to redirect to Plesk Panel <Domain.tld>/ppp if possible.
I am using CentOS 6.4... I cannot login to the admin page. Showing this message:
Error: Unable to log you on. An internal error occurred in the Single Sign-on authorization engine. Please try to log in later, and contact your hosting service provider if the problem persists.
Error log:
Doing restart of Parallels Installer...
2014-05-17 01:08:38: (server.c.1543) server stopped by UID = 0 PID = 10122
2014/05/17 01:15:04 [crit] 16495#0: *1 connect() to unix:/var/run/sw-engine.sock failed (2: No such file or directory) while connecting to upstream, client: 127.0.0.1, server: , request: "POST /plesk-billing/task-manager.php HTTP/1.1", upstream: "fastcgi://unix:/var/run/sw-engine.sock:", host: "localhost:8443"
[Code] ....
I have tried this post: [URL] ....
[root@ns4008757 ~]# /usr/share/plesk-billing/integration --command=repair-all
Customer & Business Manager is not installed yet.
[root@ns4008757 ~]# /usr/local/psa/bin/sso -g
SSO status: on
SSO server url: https://XXX.XXX.XXX.XXX:8443
SSO API version: sw:sso:idp:1_0
SSO Application ID: z9fabw14uesl6ccoz0wnpwk68eghgvs6ny7
After running this two lines, when i login to admin panel, it shows: Can not extract SAML message.
I have a freshly installed Plesk 12 on CentOS 7.
FTP logins worked fine yesterday. Today I get a 530 Login incorrect.
I think the only change since yesterday was a server reboot.
/var/log/secure tells me that /etc/ftpusers is missing
Code:
Jun 8 00:33:19 macbook proftpd: PAM unable to dlopen(/usr/lib64/security/pam_stack.so): /usr/lib64/security/pam_stack.so: cannot open shared object file: No such file or directory
Jun 8 00:33:19 macbook proftpd: PAM adding faulty module: /usr/lib64/security/pam_stack.so
Jun 8 00:33:19 macbook proftpd: pam_listfile(proftpd:auth): Couldn't open /etc/ftpusers
What went wrong, what would be the solution?
Since the update from 11.5 to 12 working Horde login no longer, IMAP works otherwise perfect.
psa-horde.log:
ERR: HORDE [horde] FAILED LOGIN for info@xydomain.tld (info@xydomain.tld) [xx.xx.xx.xx] to horde [pid 20347 on line 216 of "/usr/share/psa-horde/login.php"]
xx.xx.xx.xx = Server-IP
Message from the Horde:
Login failed.
(Email / password are of course correct)
During the installation of Plesk, at first it used the root password, and then had me create an "admin" user.
When I log in using either I don't see any difference in the UI or options. Is there a difference or a reason to use one over the other?
Or is it just to give someone access to admin Plesk without giving them full root password of the server itself?