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'?
Do you guys know anything about this?
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
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]....
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 windows server 2012 and Plesk v12.0.18 #30 - I noticed speed problem.
When I try to connect to mySQL with:
$conn = new mysqli('localhost', 'joomla_***', '*****', 'joomla_test');
Connection takes 1 second!!!When I try to connect with '127.0.0.1' instead of 'localhost' connection takes 0,009 seconds.
1. I tried solution to add line '127.0.0.1 localhost' to c:windowssystem32driversetshosts - but no luck.
2. I tried to edit C:Program Files (x86)ParallelsPleskMySQLDatamy.ini - adding lines
bind-address=127.0.0.1
skip-name-resolve
then restarted mySql but 1 second lag time on connection was still there.
3. I even tried to disable IPv6 but still no luck
I guess all users windows windows server 2012 has the same problem??!?!...
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'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.
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 :
www.domainA.com
www.domainB.com
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?
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
Cannot send mail via php mail send
Warning: fsockopen() [function.fsockopen]: unable to connect to localhost:25 in /home/user/public_html/smtpmail/class.smtp.php on line 105
How do I correct this? I'm using Cpanel with php 4.4.8, apache 2.2, mod suphp
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...
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/"
want enable mssql_connect on php
plesk panel 11.0.9
centos
I want enable mssql_connect for php.
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)...
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 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 RelatedI 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?
I am having trouble connecting to my ssh server. It responds with a lengthy error message about no network etc. but it is the last message that concerns me:
Sometimes, such troubles can be caused by a misconfigured firewall.
How can I check the firewall if I cannot connect to ssh? I am running plesk 11.5 control panel and CentOS 6. Is this something I can do from plesk?
I can see that the firewall in plesk is set to allow all for ssh, but I cannot see way to disable the firewall to test ssh connection. Can this be done from plesk?
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?
I have over 5 WP installations on my Server and i installed all manual and had never issues.
Now i installed a again a WP Site and after i go to the Wordpress Toolkit to search for the new installation i got the following Message:
PHP Parse error: syntax error, unexpected '?' in /usr/share/plesk-wp-cli/php/wp-cli.php(23) : eval()'d code on line 1 {"err_code":0,"err_message":"
With error cannot connect to DB.
So all WP installations are running fine instead of the new one.... I didn't change any configs files of PHP all is standard, the wp-config.php is correct, the Site is running fine.
From my point of view is this an issue by Plesk due to Parse error message at the files of Plesk, see error message!
System:
OS Debian 7.8
Plesk Version 12.0.18 Update #43, zuletzt aktualisiert: 20. April 2015 13:17:36
I know with an older Version of Plesk 12.0.18 it was working fine too, so the bug was implemented with a MU.
I checked the file as well and find out that at all PHP files the code is not closed at the end so the "?>" is always missing.
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
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'.
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 ....
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?
or is there any potential danger using IP?
