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.
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 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)]
My Plesk 11.5 server will not connect to my SQL 2008 server. It runs on a Windows 2008 server. I have turned the Windows firewall off. The servers are on the same IP subnet. I can ping the SQL server by name and address, remotely Login successfully using SQL management studio, and map a share to a drive.
The SQL server is in Mixed Mode. I can telnet to port 1433 and login. The SQL server has TCP/IP enabled. Connections made by web sites - mostly ASP driven - connect normally. The Plesk console fails to connect with the following error -
Error: Test connection to the database server has failed because of network problems:
Get database server version failed: Login failed for user '????'.
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 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.
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.
I can't add subscriptions, not even for the administrator account, comes up with:
Error: Filename: ?C:inetpubvhostsmygclive.comhttpdocsweb.config Error: The configuration section 'system.webServer/rewrite/rules' cannot be read because it is missing a section declaration In module Exception type: System.Runtime.InteropServices.COM
when i try to make backup of mssql 2012 on plesk 11.5 i have the following error:Error: dbbackup failed: Unable to backup database 'DBANME'. Unable to open connection: A specified logon session does not exist. It may already have been terminated.i already configured temp/network directory,
I installed plesk win 12 with mssql2012 , but nobody as abale to restore DB via plesk we recive this error Error: dbbackup failed: Unable to restore database 'degardis'Format of the initialization string does not conform to specification starting at index 29.the backup file is restored straight via sql management studio.
I have enabled mail for himivest.com and can access my eMail via Opera Mail as a download.
However, I cannot access webmail. Typing "[uRL] ...." into the address bar of my browser (Chrome) results in the message "No input file specified."
I believe this is a PHP setup error. I have tried disabling / enabling PHP support for himivest (in accordance with [URL] .... ) but this had no effect.
Unable to restore database '17' Not valid backup: Cannot open backup device 'C:Program Files (x86)ParallelsPleskBackupclub-panel.irdatabases171.bak'. Operating system error 5(Access is denied.). VERIFY DATABASE is terminating abnormally.
(Error code 22) ---------------------- Debug Info -------------------------------