Plesk 12.x / Linux :: Unable To Connect To MySQL Hosts
Jul 18, 2014
After changing my web hosting (same system : VPS, same version of linux : CentOS 6 , but passage from Plesk 11 to 12), i am now unable to connect remotely via TCP-IP to my mysql databases (with third-party tools like Mysql Workbench, Toad...) ! I never met this problem before.
The only way to connect is to use a "Standard TCP-IP over SSH" connection method ... but i don't want (i did'nt need this method before) !
Though, remote connections are allowed from any host in the settings.
View 3 Replies
ADVERTISEMENT
Jul 17, 2012
I've upgraded to 11, but when I try and apply updates, I'm getting
WARNING: Unable to connect to local default MySQL server. Read carefully article [URL] ..... for details.
I've followed the directions in the KB mentioned, but haven't had any luck yet.
View 8 Replies
View Related
Aug 16, 2014
I recently upgraded to 12.0.18 and I am using Roundcube 1.0 from the panel. I read that the "Unable to connect to sieve serve" problem would be solved in version 12.It seems not. What to do?
View 12 Replies
View Related
May 30, 2015
I have the problem that I can't connect to my mailserver tru the mail client (Webmail works fine, I receive mails and can send mails)
But if i try to connect over mailclient I get this error in errorlog:
couriertls: connect: error:1408A0C1:SSL routines:SSL3_GET_CLIENT_HELLO:no shared cipher
What can I do to get connection over mailclient?
View 2 Replies
View Related
Aug 11, 2014
I had Plesk 10 installed on my openSUSE system (was a low version, maybe 11 or less) and then decided to upgrade to 11.5. So I did distribution upgrades to openSUSE 12.3 and everything went smoothly, except for some services like mysql and php. So I used Plesk autoinstaller to fix the php error and edited an outdated line in mysql configuration and both services ran smoothly!
Then I downloaded Plesk autoinstaller and ran the autoinstaller, but was surprised by this error message:
===> Checking for previous installation ... found.
ERR (3) [panel]: Error during product key mode determination, details: Unable to connect to database: ; trace: #0 /usr/local/psa/admin/plib/functions.php(2821): isPpaKeyRequired()
#1 /usr/local/psa/admin/plib/common_func.php3(11): require_once('/usr/local/psa/...')
#2 /usr/local/psa/admin/plib/api-common/cu.php(5): require_once('/usr/local/psa/...')
#3 /usr/local/psa/admin/sbin/httpdmng(8): include_once('/usr/local/psa/...')
#4 (main)
Unable to connect to database:
- My MySQL version is: 5.5.33 openSUSE package
- I did run mysql_upgrade with my admin username and password (password from: /etc/psa/.psa.shadow) and it worked successfully and fixed all of the errors, I did so after running the auto installer first, but then ran the installer again and the problem was still there
- I can access my web page, but it still doesn't connect to MySQL either.
I believe this is a problem with MySQL, but how can I make sure or detect what exactly the problem is
View 3 Replies
View Related
Nov 9, 2013
when I try to access to my plesk I obtain:
ERROR: PleskFatalException: Unable to connect to database: Access denied for user 'admin'@'localhost' to database 'psa' (auth.php:142).
If I restart with ssh /etc/init.d/psa start and I check plesk_11.5.30_reset_instance_data.log
I note: ERROR 1044 (42000): Access denied for user 'admin'@'localhost' to database 'mysql'.
View 10 Replies
View Related
Sep 21, 2014
Since we had Update to 12.x we have problem to connect to any ftp Server
We have this Problem on two diffrend Plesnikserver.
Both are running under Ubuntu 12.04 ....
View 1 Replies
View Related
Feb 6, 2015
I have a problem with connection to MySQL database over PHP.
If I define host address '127.0.0.1' works well. Problem occurs if host address is 'localhost'.
How to allow both 'localhost' and '127.0.0.1'?
View 1 Replies
View Related
Oct 5, 2013
With one from another server. Now roundcube does not want to connect to mysql anymore, i tried to edit this :
line:$rcmail_config['db_dsnw'] = 'mysql://roundcube:randompassword@localhost/roundcubemail';
i then used a MD5 generator to input the hash in the password field of the roundcube user in mysql, with no luck...I even tried to delete roundcube user from mysql, then remove psa-roundcube, then go through the plesk update manager and install roundcube again, did not change nothing, it didn't even create the roundcube user.
Is there anyway i can reinstall roundcube from scratch?PPP 11.5 up to date on ubuntu 12.04
Code:
[05-Oct-2013 14:03:54 +0200]: DB Error: _doConnect: [Error message: Access denied for user 'roundcube'@'localhost' (using password: YES)]
[Native code: 1045]
[Native message: Access denied for user 'roundcube'@'localhost' (using password: YES)]
[code]....
View 7 Replies
View Related
Jan 9, 2007
I have a set up where server 1 holds a mysql DB and a virtual host. server 2 holds many virtual hosts in apache (16) connecting to this DB.
The virtual hosts all hold the same script, but the single VH on server 1 receives about the same amount of visits as all the VHs of server 2.
server 1 is very busy at times, like 100% CPU and a load around 10 for long period of times.
server 2 is not very busy, around 30% CPU usage and 0.6 CPU load.
Yet, users on server 2 experience *much slower* response times than the ones on server 1.
The obvious reason could be the network between the two, but I'm not convinced (6 seconds for a query run from server 2 when it brings back 1 row and takes 0.01 second from server 1).
I was wondering what other reasons it could be.
The mysql processlist is weird:
Code:
mysql> show processlist;
+-------+----------+---------------+----------+---------+------+--------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+----------+---------------+----------+---------+------+--------------------+------------------------------------------------------------------------------------------------------+
| 81817 | mysite | localhost | mysite | Sleep | 865 | | NULL |
| 94992 | mysite | server2:47927 | mysite | Sleep | 188 | | NULL |
| 96890 | mysite | server2:50881 | mysite | Sleep | 26 | | NULL |
| 97213 | mysite | server2:51010 | mysite | Sleep | 22 | | NULL |
| 97391 | mysite | server2:51085 | mysite | Sleep | 36 | | NULL |
| 97919 | mysite | server2:51300 | mysite | Sleep | 49 | | NULL |
| 97927 | mysite | server2:51306 | NULL | Sleep | 49 | | NULL |
| 97933 | mysite | server2:51282 | mysite | Sleep | 48 | | NULL
| 97933 | mysite | server2:51282 | mysite | Sleep | 48 | | NULL |
| 97958 | mysite | server2:51321 | mysite | Sleep | 26 | | NULL |
| 97961 | mysite | server2:51323 | mysite | Sleep | 46 | | NULL |
| 98104 | mysite | server2:51344 | mysite | Sleep | 39 | | NULL |
| 98169 | mysite | server2:51376 | NULL | Sleep | 36 | | NULL |
| 98177 | mysite | server2:51388 | mysite | Sleep | 9 | | NULL |
| 98365 | mysite | server2:51461 | mysite | Sleep | 26 | | NULL |
| 98377 | mysite | server2:51427 | mysite | Sleep | 26 | | NULL |
| 98380 | mysite | server2:51468 | mysite | Sleep | 6 | | NULL |
| 98394 | mysite | server2:51474 | mysite | Sleep | 26 | | NULL |
| 98404 | mysite | server2:51479 | mysite | Sleep | 26 | | NULL |
| 98418 | mysite | server2:51486 | mysite | Sleep | 26 | | NULL |
| 98419 | mysite | server2:51487 | mysite | Sleep | 26 | | NULL |
| 98429 | mysite | server2:51496 | mysite | Sleep | 2 | | NULL |
| 98503 | mysite | server2:51520 | mysite | Sleep | 22 | | NULL |
| 98512 | mysite | server2:51524 | mysite | Sleep | 22 | | NULL |
| 98514 | mysite | server2:51525 | mysite | Sleep | 20 | | NULL |
| 98519 | mysite | server2:51526 | mysite | Sleep | 22 | | NULL |
| 98557 | mysite | server2:51514 | mysite | Sleep | 21 | | NULL |
| 98568 | mysite | server2:51548 | mysite | Sleep | 20 | | NULL |
| 98581 | mysite | server2:51557 | mysite | Sleep | 5 | | NULL |
| 98617 | mysite | server2:51572 | mysite | Sleep | 18 | | NULL |
| 98620 | mysite | server2:51574 | NULL | Sleep | 18 | | NULL |
| 98630 | mysite | server2:51577 | mysite | Sleep | 17 | | NULL |
| 98644 | mysite | server2:51584 | mysite | Sleep | 17 | | NULL |
| 98681 | mysite | server2:51601 | mysite | Sleep | 15 | | NULL |
| 98698 | mysite | server2:51604 | mysite | Sleep | 14 | | NULL |
| 98704 | mysite | server2:51606 | mysite | Sleep | 14 | | NULL |
| 98714 | mysite | server2:51610 | NULL | Sleep | 14 | | NULL |
| 98736 | mysite | server2:51619 | NULL | Sleep | 13 | | NULL |
| 98748 | mysite | server2:51626 | NULL | Sleep | 12 | | NULL |
| 98753 | mysite | server2:51628 | mysite | Sleep | 12 | | NULL |
| 98785 | mysite | server2:51635 | mysite | Sleep | 11 | | NULL |
| 98820 | mysite | server2:51654 | mysite | Sleep | 10 | | NULL |
| 98821 | mysite | server2:51655 | mysite | Sleep | 10 | | NULL |
| 98822 | mysite | server2:51656 | mysite | Sleep | 10 | | NULL |
| 98823 | mysite | server2:51657 | mysite | Sleep | 10 | | NULL |
| 98836 | mysite | server2:51660 | mysite | Sleep | 9 | | NULL |
| 98840 | mysite | server2:51662 | NULL | Sleep | 9 | | NULL |
| 98841 | mysite | localhost | NULL | Query | 0 | NULL | show processlist |
| 98901 | mysite | server2:51680 | mysite | Sleep | 6 | | NULL |
| 98903 | mysite | server2:51651 | mysite | Sleep | 7 | | NULL |
| 98920 | mysite | server2:51684 | mysite | Sleep | 6 | | NULL |
| 98947 | mysite | localhost | mysite | Sleep | 1 | | NULL |
| 98954 | mysite | server2:51696 | mysite | Sleep | 5 | | NULL |
| 99024 | mysite | server2:51710 | mysite | Sleep | 1 | | NULL |
| 99031 | mysite | server2:51712 | mysite | Sleep | 2 | | NULL |
| 99032 | mysite | server2:51686 | mysite | Sleep | 2 | | NULL |
| 99041 | mysite | server2:51694 | mysite | Sleep | 2 | | NULL |
| 99049 | mysite | server2:51717 | mysite | Sleep | 2 | | NULL |
| 99058 | mysite | server2:51720 | mysite | Sleep | 1 | | NULL |
| 99063 | mysite | server2:51685 | mysite | Sleep | 1 | | NULL |
| 99064 | mysite | server2:51722 | mysite | Sleep | 2 | | NULL |
| 99073 | mysite | localhost | mysite | Sleep | 1 | | NULL |
| 99075 | mysite | server2:51724 | mysite | Sleep | 1 | | NULL |
| 99086 | mysite | localhost | mysite | Query | 1 | Creating tmp table | SELECT DISTINCT * |
| 99089 | mysite | localhost | mysite | Sleep | 1 | | NULL |
+-------+----------+---------------+----------+---------+------+-----------
Why so many sleeping processes from server 2, and none or almost none from server 1 ?
Is it normal that every query from server 2 is open on a different port ? Should they be grouped by virtual host, or is there one different port for each script running concurrently?
What could be a reason for server 2 having problems to open connections on server 1, and how to solve it?
Right now I'm about to deport more users from server 1 to new virtual hosts on server 2, hoping it will lower the load on the first machine and overall accelerate the response times. I just thought I'd post here first because this all seems very weird to me and i thought someone with an external look might tell me what I'm doing wrong. And also if network would be the problem maybe that's not the clever thing to do to make more users remote.
View 4 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
Jul 11, 2014
After the upgrade of our Plesk installation from 9.5x to 11.5.30Everything works ok (sites,sites with databases, Plesk etc)but when I go to Home>Tools & Settings> Backup Manager.I see errors on every daily backup I have on schedule:
The backup Plesk_Daily_Full_Backup_1407060112.tar has completed with warnings. (View the details) Close this message
Error:mysql "myuser_drupal"
Unable to define superuser password for mysql server on localhost
Error:mysql "myuser_drupal"
Unable to get list of db servers (ErrorCode: 1, STDOUT.
Error:mysql "myuser_wp_eng"
Unable to define superuser password for mysql server on localhost
View 1 Replies
View Related
Aug 6, 2012
Lately whenever i try to connect to my Plesk Panel, I get Firefox's "Unable to connect" error and with Internet Explorer I get "Cannot display web page". I disabled all addons, still couldn't connect. Checked my Firewall, still nothing. I pinged the IP and got 51ms. My site is still up. And I just dont know what's wrong.
View 2 Replies
View Related
Dec 19, 2013
I have installed Plesk 11.x windows version. I use that for 1 month but now I want to login to panel by http://mysite.com:8880 get error:
The system cannot find the file specified. (Error code 2) at Unable to connect to pipe .pipeP_85da9518-b79d-49a6-a154-e5055dc53d7c
View 2 Replies
View Related
May 14, 2008
I was having issue with ibdata1 file which had grown to 5GB on the server machine. so after reading couple of blogs, i got the way how to remove it. i backedup my DB's, stopped the mysql and deleted that ibdata1 file.
now after that, i am unable to run mysql in ANYWAY!. I have searched accross the boards, across the blogs and i am still unable to figure out the problem.
every time i start it gives me following error
[root@server init.d]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]
and here is my my.cnf file
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
max_connections=50
table_cache=1000
thread_cache_size=40
thread_stack=100K
wait_timeout=10
join_buffer=2M
myisam_sort_buffer_size=6M
query_cache_size=6M
read_rnd_buffer_size=2M
#i wrote this line to recover, but failed. innodb_force_recovery=4
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
View 4 Replies
View Related
Oct 19, 2014
Since yesterday I can't connect to any of my ftp clients.For months I could login to my FTP using Coda and Filezilla and everything worked until yesterday.
Coda gives me this message:
Error -203: miscellaneous error occurred while trying to login to the host
Filezilla gives me this message:
Antwoord:220 ProFTPD 1.3.5 Server (ProFTPD) [MYSERVERIP]
Opdracht:USER username (username is my ftp username)
Antwoord:550 SSL/TLS required on the control channel
I have not changed anything on my server. Just out of the blue this errors appears and now my customers and I can't login anymore.I tried to restart the server, made a new ftp account..I don't know if I can reinstall the ProFTPD or need to open port 21?
View 3 Replies
View Related
Jan 18, 2015
I can not connect to the server with using "Require explicit FTP over TLS"
In /etc/proftpd.conf I have added from here [URL] ....:
<IfModule mod_tls.c>
TLSEngine on
TLSLog /var/log/tls.log
TLSProtocol SSLv23
[Code]....
PS: in Tools & Settings ->SSL Certificates ->I created a new self-signed certificate, set as default. In Tools & Settings ->IP Adress bind new certificate to IP
For each domain is created own certificate, but when try to connect, will be ascked to confirm a default certificate from Plesk I have create a new certificate (using SSH)
Service restarted too with: service sw-cp-server restart
View 1 Replies
View Related
May 27, 2015
We have many clients with same issue, when they try to connect into outlook they get a msg like this (print).
None of all them has the same issue, but a few of them.
When i restart all email services things works, but 30" later come back again...
View 4 Replies
View Related
Sep 10, 2014
after the login page, a blank page appears and I can't access to the Plesk Control Panel :
in the file : /var/log/sw-cp-server/error_log
2014/07/09 14:45:04 [error] 7422#0: *3551 FastCGI sent in stderr: "Primary script unknown" while reading response header from upstream, client: 91.204.25.4, server: , request: "GET /admin/ HTTP/1.1", upstream: "fastcgi://unix:/var/run/sw-engine.sock:", host: "91.204.25.4:8443", referrer: "https://91.204.25.4:8443/"
View 7 Replies
View Related
Nov 12, 2013
want enable mssql_connect on php
plesk panel 11.0.9
centos
I want enable mssql_connect for php.
View 2 Replies
View Related
Mar 8, 2009
I am unable to connect to corehoster at all again --
I have been having issues since I opened my alpha master reseller account
Any reseller account I create cant create cleints..
I am even unable to enter tickets or send email to them since they are unreachable
Nick S refuses to refund my account .
Any one else having issues with core hoster
View 1 Replies
View Related
May 27, 2007
I have been struggling with a couple of new servers that we want to run Centos 5 on. For a second assume that is our desire so going back to 4.x isn't an option yet.
Now while I mention Centos 5, the problem seems to be with PAM and x64.
When trying to login to the server via ssh, the login succeds but then immediately kicks the user out. I have tried this with root and another user created. I have set the UsePam option to no to try to resolve this in sshd_config.
On the H-Sphere forum I found this reference:
[url]
" if i try to connect with ssh and i enter the right password i get an error and ssh closes the connection. The answer already was in the ticket you opened:
Quote:
That is known bug dealt with PAM authentication.
The bug was fixed for i386 systems long time ago. But it was not fixed for x86_64 architecture.
We build FreeVPS kernel new version 1.5-13.1 for x86_64 architecture to fix the problem.
We also installed the kernel into the box IP 64.71.227.16.
Please reboot the box with the new FreeVPS kernel version: 2.6.9-freevps-1.5-13.1smp.
Let us know the result."
Does anyone know how to resolve this? A reinstall of PAM was attempted by a well known sysadmin here but to no avail.
View 7 Replies
View Related
Aug 30, 2014
Yesterday I tried to install Fail2Ban on centos 6.5.
Set up for 30 seconds due to, I don't have much domains on plesk.
Fail2Ban stopped working and failed really bad, and it stopped working.
Later on we tried to uninstall Fail2Ban through Add/remove components and we were stack on logging. (about 20 hours same thing)
Right now, add/remove components comes with an error message (Can't connect to backend. No such file or directory)...
View 3 Replies
View Related
Dec 12, 2014
How to connect nginx to work with directory web_users for some virtual host?
This directory contains two accounts (user1, user2) with a large amount of static content (files .jpg), the downloaded web users themselves. At the moment they are processed by Apache, which causes an additional load on the server.
In hosting configuration for virtual host "domain.tld" set:
document root: httpdocs. (That is, the "httpdocs" and "web_users" directories are on the same level).
In the web server configuration settings (in additional nginx directives) i can't use the directive "server" (refuses to save), where you can specify the location of the additional "document root" for nginx.
View 3 Replies
View Related
May 9, 2009
I've been getting a lot of complaints today on my forum that users cannot view their websites which are subdomains on a seperate domain that I own. It makes no sense why they would have access to the forums which is on the same dedicated server, using the same IP, and with the same nameservers as the site they cannot access. This issue started last night out of nowhere.
Where should I even start looking? It appears to only be with overseas users since none of the US and Canadian users have any issues with either domains or their subdomains.
View 2 Replies
View Related
Jan 28, 2008
Yesterday I had to install a renewed SSL Certificate. Managed to get it installed, in Plesk under domains/www_mydomain_com, but I also deleted the default SSL from the server/certificates area... So then I was getting an dns 500 error when browsingour site and I could not start httpd from within plesk. Went in through SSH and tried to start it from there and got and error stating it could not find the SSLCA cert it was looking for. So I edited my httpd.include file to point to my new certificate. Now http works, but my email has stopped? What gives how could the two be related!
I can log into my webmail, compose message and when I send I get:
Warning: fsockopen(): php_hostconnect: connect failed in /usr/share/psa-horde/pear/Net/Socket.php on line 108
Warning: fsockopen(): unable to connect to 127.0.0.1:25 in /usr/share/psa-horde/pear/Net/Socket.php on line 108
I have started and stopped psa, qmail. Rebooted the server. I tried the telnet localhost 25 but I get connection refused. Anytime I check qmail status it says stopped. Don't know if that is right or not. I know I am not recieving emails asI have sent many today through other accounts and they all come back undeliverable.
We do run an online store as well so I am kinda nervous when our email goes down! Time to hire a server admin?
I am running Plesk 7.5.4 on Red Hat 9 on a Virtual Dedicated Server with GoDaddy.
Here is my "Component Info" from Plesk:
bind 9.2.1-16
coldfusion-support 7.3-2.96.118
courier-imap 3.0.8-rh9.build75050824.12
frontpage 5.0.2.2634
httpd 2.0.40-21.17.legacy.1.swsoft
mod_perl 1.99_07-5
mod_python 3.0.1-4
mysql 3.23.58-1.9
perl-Apache-ASP 2.57-rh9.build75050824.12
php 4.3.2-psa.rh9.1
psa 7.5.4-rh9.build75050824.12
psa-api-rpc 7.5.4-rh9.build75050930.11
psa-bu Component was not installed
psa-horde 3.0.5-rh9.build75050824.12
psa-imp 4.0.3-rh9.build75050824.12
psa-logrotate 3.7-rh9.build75050824.12
psa-manual-custom-skin-guide 7.5.4-rh9.build75050824.12
psa-proftpd 1.2.10-rh9.build75050824.12
psa-qmail 1.03-rh9.build75050824.12
psa-qmail-rblsmtpd 0.70-rh9.build75050824.12
samba 2.2.7a-8.9.0.1.swsoft
SSHTerm 0.2.2-rh9.build75050824.12
stunnel 4.04-3
webalizer 2.01_10-11
View 1 Replies
View Related
Apr 5, 2007
I am stuck in re-installing mysql server..... Everything I have removed even mysql service give reboot the machine but still not able to complete the installation.
At the end I receive error " Can't connect to Mysql server with LocalHost (10061)
By the way if port 3306 is not enabled in firewall can this issue be occurred because of this?
View 5 Replies
View Related
Sep 25, 2007
I just switched to a new server last month and Im having a problem where a lot of my members and even some of my mods are unable to connect to my website. They are just getting a page cannot be displayed error. The website is ftascene(dot)com. Is everyone here able to connect to the site, and any idea why not everyone would be able to connect?
View 5 Replies
View Related
Jun 12, 2007
I have not been able to connect to my server via browser, ftp or email since my server had a OS reload & security package installed.
If I disconnect and remove my wireless router I can access the server directly from the modem. When the Linksys WRT54G is connected I can go anywhere on the net with no problems, except my server.
Is there something they might have done at the server to block wireless router access?
I get a timed out message when I ping any of the IP's on the server with the wireless router connected.
Linksys has been of no help and I have talked with Clearwire who owns my modem.
View 7 Replies
View Related
Mar 8, 2015
I installed Plesk on a VPS running on Ubuntu 14.04. When I try to open phpMyAdmin the following error message appears:
You probably did not create a configuration file. You might want to use the setup script to create one.
Error
MySQL said: cannot connect: invalid settings.
When I try to click on the setup script link another error message pops up:
Error in Processing Request
Error code: 404
Error text: Not Found
What do I have to do to make phpMyAdmin work?
View 1 Replies
View Related
