My server works perfectly with INSERT, UPDATE, DELETE for mysql. but after like 12 hours later, my application crashes and I get this "Can't connect to MySQL server on 'localhost' (10055)" and I would have to restart my applications and everything will be working perfectly.
Do you guys have any idea why this happen?
I do have a lot of connections coming in and out of my server. Would that mean anything?
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
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
[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)]
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 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 a PPP12.0 hosted on ubuntu 12.04, and several websites and domains, mail service active using postfix.
Lets take for example two domains :
DomainA uses postfix DomainB uses an external mail service , MX records are duly entered in the DNS zone of DomainB
If i send a mail from an adress of DomainA, lets say contact@domainA.com to any email of domainB lets say info@domainB.com, the server does not take into account the MX records, and i receive an answer from the server : 550 5.1.1 <info@domainB.com>: Recipient address rejected: User unknown in virtual alias table
But, if i send an email using any other external mail service (gmail, hotmail...), the mail is correctly forwarded to the mail server entered in the MX record of domainB.
There seems to be confusion and documentation conflicts around whether we should be whitelisting localhost or not when using Mailing Lists.
In this documentation it suggests that localhost is no longer needed, and in fact needs to be removed from the whitelist if Outbound Spam protection is to function correctly: [URL] ....
But on the other hand, this documentation suggests to add localhost to the whitelists, even though the warning says otherwise, and that outgoing mailing list mail will still be processed by Outgoing Spam Control. [URL] ....
Through trial and error, i've found that my mailing lists were not able to send mail to external email accounts unless localhost is whitelisted.
If I want all mail scripts to be going through the Outbound Spam Control, and also having my mailing lists working, should I be adding localhost to my whitelist?
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?
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 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've been using Dreamhost for years and they're very good, but their MySql databases are quite slow. Then I moved to ServInt with a VPS, and my MySql is on localhost instead of on a different server. WOW! It's so fast!
However, now I'm trying to find a shared hosting package that has fast MySQL service.
I'm not sure if the requirement is that it's on localhost but it sure doesn't hurt.
Is there anyone who is familiar of a good solid shared hosting package with fast MySQL service?
I am using localhost as mysql server name on my config file. then, when I enter [url], the address will automatically change to[url]that obviously getting error. when I change the mysql server name from localhost to the server public IP, everything seems ok.
My sql is 4.1.x with php 4.4.7, is that any way I may use localhost instead of IP?