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.
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?
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
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)]
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).
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.
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?
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
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.
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
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?
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
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.
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.
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.
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
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?
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?
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.
