Plesk 11.x / Windows :: Cannot Add Second Mysql Server
Nov 17, 2014
For one of my dedicated server I have the follwoing scenario:
Microsoft Windows Server 2012 X64
Plesk 11.5.30 Update #48
Plesk Panel - Tools and Settings -> Database Server -> Add Database Server
Type: MySql - host: localhost - Port 3307
Actual Result: error unable to connect to host
Expected result: New instance and service of MySql Server
Port 3307 is no firewalled and I have added a rule to allow connection on 3307
View 2 Replies
ADVERTISEMENT
Sep 12, 2014
I have a dedicated server and I am about to get a few high traffic sites that will be Joomla based and MySQL served. What I am thinking a about is to create another MySQL instance, leave the current websites on the "old" instance and get the new ones onto a separate instance.
I am on PPP 11.0.9 on windows and the current mysql version is 5.1.56 on port 3306 (I can get other ports for other instances).
What I did was the following:
In the Database Servers page, I hit "Add Database Server"
In the next page I add the following:
MySQL (from the dropdown)
localhost
3307
(leave blank the default check box)
I then add the Administrator's username and passwords and hit OK.
The next page, reports an error message (in between asterisks below):
************************
Error: Test connection to the database server has failed because of network problems:
No connection could be made because the target machine actively refused it.
************************
The primary (eg. current) mysql instance is working fine, it's just I cannot add a second server...
View 3 Replies
View Related
Aug 29, 2013
After an unexpected server shutdown. We cant start mysql anymore.
Error: Could not complete the operation: defpackagemng failed: The process terminated unexpectedly. (Error code 1067) at Start service MySQL
View 4 Replies
View Related
May 21, 2014
In order to install moodle, I need to upgrade MySQL from 5.1 to 5.5. I have gone through one of the KB articles [URL], but it's not very clear.
Can I upgrade it through Add/remove Components from Install and update products just like it can be done for PHP?? I see MySQL Server 2005, 2008 and 2012,
View 2 Replies
View Related
Mar 23, 2014
I can't start MYSQL. How can i fix this?
View 3 Replies
View Related
Jul 29, 2012
Plesk has mysql installed with it to run properly and I need to upgrade that version to the latest. Now I am not talking about the mysql server that it provides for me to create databases on. I am talking about the version it uses to run.
View 3 Replies
View Related
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
Sep 29, 2014
We have a special application that works on 3 servers, 1 of them is main server and others are mysql replicate servers basically used for generating reports or backups...
Server 1 - Centos 6.5/Mysql 5.5/Plesk 12
Server 2 - Centos 6.5/Mysql 5.5/Plesk 11
Server 3 - Server 2008 R2/Mysql 5.5/Plesk 12
Server 1->Server 2 replication works perfectly
Server 1->Server 3 replication sometimes fails with character issues (our database and tables use utf8_turkish_ci), when I tried to investigate this issue by logging in to mysql on Server 3 right after connection i saw "Unknown OS Character Set 'cp857' Switching to default character set latin1" and i am guessing that my replication issues are also related to this issue. I tried adding below settings to my.ini at "C:Program Files (x86)ParallelsPleskDatabasesMySQLdata"
[mysqld]
init_connect='SET collation_connection = utf8_turkish_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_turkish_ci
skip-character-set-client-handshake
[mysql]
default-character-set=utf8
default-collation=utf8_turkish_ci
[client]
default-character-set=utf8
default-collation=utf8_turkish_ci
but didnt change anything, i was wondering if these settings were wrong so i tried them at my local wamp installation which i was having same error, but error was gone after adding them to my.ini so i think settings are alright...
View 3 Replies
View Related
Apr 22, 2013
I have read about people wanting to change their database from MSSQL to MySQL. I however am wanting to change from MySQL to Microsoft SQL in our Plesk panel.
View 7 Replies
View Related
May 27, 2014
I need to get a list of suspend domains from mysql. The domains are suspend because they exceeded quota.So far I have done this query:
#############
select domains.id,
domains.name as domena,
Round(((sum(domains.real_size))/1048576),2) realMB,
(select Round((limits.value/1048576),2) from limits left join (domains, subscriptions, subscriptionproperties) on (domains.id=subscriptions.object_id and subscriptions.id=subscriptionproperties.subscription_id and subscriptionproperties.value=limits.id) where subscriptionproperties.name='limitsId' and limits.limit_name='disk_space' and domains.name=domena) quotaMB
from domains
where domains.status='2' and
(select (sum(domains.real_size)))>0
group by domains.cl_id;
but I didnt managed to get only those that exceed the quota.
View 3 Replies
View Related
Apr 2, 2014
PRODUCT, Plesk for Windows VERSION 11.5 latest update VERSION OF MICROUPDATE 11.5.30 Actualizar #39, OPERATING SYSTEM Windows 2008 Server Suddently with no apparent reason, MYSQL stops and Ihave to go to the panel and restart it.
Every Morning I have to restart MySQL thru the control panel in remote console of windows..Works all day long, and then stops at night..Should work as always did, for several months I did not even reboot the server, no I have to reboot the server to see if that fixes the problem. Latest windows update, latest Plesk for windows update, but I have the feeling that with the latest microupdate something has broken,
View 3 Replies
View Related
Jan 27, 2015
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??!?!...
View 3 Replies
View Related
Aug 13, 2013
Since we upgraded to Plesk 11.5 or (I'm not shure) the last Update 12, user can not import MySQL-Databases anymore.
If the user open phpMyAdmin for import and select the database and click on Ok, phpMyAdmin does nothing.
I heard that could be a problem with JQUERY and I checked the files in ParallelsadminhtdocsdomainsdatabasesphpMyAdminjsjquery and all files seems to be there.
Only if I check the source of the phpMyAdmin Import-Website it seems, there is a problem with jquery-1.6.2+fix-9521.js.
But how I can fix this problem for all Windows-Servers.
View 19 Replies
View Related
Feb 9, 2015
Running Plesk 12.0.18 on Windows 2012
I create a new domain then use Plesk Applications tab to install Wordpress. It shows the message:
Code:
Error: Unable to install the app because its installation requirements are not met. Contact your hosting provider to resolve this problem.
Requirements
PHP extension
The 'mysql' extension was not found.
However, php is installed and phpinfo shows that the mysql extension is installed. I try different versions of php, cgi/fastcgi but ll fail with the same error. I install Wordpress via FTP and it works fine.
There are knowledge-base articles relating to this error but they are for Linux and the solutions don't work in this case:
[URL] ...
[URL] ...
Maybe the Wordpress database has to be created before using Plesk to install Wordpress? If so, what should the database name be? How does Plesk know what the name of the database is that it should use? Why doesn't Plesk just create a database to use?
View 6 Replies
View Related
Apr 21, 2015
After installing Plesk 12.0.18 Update 43 on windows when I try to connect to Plesk Panel (https://myurl.com:8443/) I get error:
ERROR: PleskMainDBException: Host '127.0.0.1' is not allowed to connect to this MySQL server (db.php:435)
I tried to reset mysql admin password as described in article - with no luck : [URL] .....
I even tried to reset password:
%plesk_bin%plesksrvclient -set "newpassword" true
Again I get "Faild to connect to database: Host '127.0.01' is not allowed to connect to this mySQL server
All websites that uses mySql works but Plesk Panel is dead?
View 3 Replies
View Related
Mar 20, 2014
I have Plesk Windows version, when I want import my backup mysql, i see below error:
Error: dbbackup failed: Unable to restore database 'admin_IranDnn'
ERROR 2006 (HY000) at line 1: MySQL server has gone awayClick to expand...
View 7 Replies
View Related
Oct 8, 2007
how many of you (Windows Hosting Providers) have MySQL (any version) support on your servers?
View 8 Replies
View Related
May 7, 2013
when im trying to enable spam filter for a particular email account i get this mysql error:
Error: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'xxxx@domain.com' for key 3 (mail id i hid it for security reasons xxxx@domain.com)..
i searchd in the psa database but could not find any duplication...
View 2 Replies
View Related
Jun 19, 2009
Trying to install Mysql 5 on a Windows 2003 server but getting this error attached.
For one, trying to follow this guideline
[url]
Download from:
[url]
(msi file, x86)
Filename: mysql-essential-5.1.35-win32.msi
View 14 Replies
View Related
Aug 8, 2007
i want to know that how to install php and mysql on a windows server (2003). i have a windows server version 2003 and i need php and mysql to run on that.
View 3 Replies
View Related
Oct 22, 2009
The my sql seems to take much load in my VPs, configuration file is as follows
[mysqld]
set-variable=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
skip-bdb
set-variable = innodb_buffer_pool_size=2M
set-variable = innodb_additional_mem_pool_size=500K
set-variable = innodb_log_buffer_size=500K
set-variable = innodb_thread_concurrency=2
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
skip-bdb
set-variable = innodb_buffer_pool_size=2M
set-variable = innodb_additional_mem_pool_size=500K
set-variable = innodb_log_buffer_size=500K
set-variable = innodb_thread_concurrency=2
View 0 Replies
View Related
Oct 16, 2013
I have Plesk 11.5 (service provider mode) on a Windows 2008 server IIS7.Most of my sites are developed in .asp and therefore i use a custom 500-100.asp error page that check s the IP of the visitor then displays either a friendly error, or if its my IP a full error of what has happened (it also emails me the error). This allows me to debug pages easily whilst developing and to keep an eye on anyone trying SQL Injection hacks on my sites (as the error and email also have session variables and IP address).I dont have root access to the server as it is a Webfusion dedicated server.I have following the Plesk documentation -
1) Switch on custom errors for the subscription
2) Look in virtual directories and navigate to error documents
3) Find the error in question (500:100) and change it to point at either a file or URL
FILE - I had the data centre add in the 500-100.asp error page in to the virtual template so that my page is available in the list of virtual files - this didn't work but that maybe because its not a static page??
URL - when i add the path it says its incorrect, if i add a fully qualified address, it accepts it but it doesn't work.give me a specific example of the URL that can be entered relative to the root as the format in the documentation isn't accepted. The last step is to restart IIS which is also an issue as i cant seem to do this from the Plesk panel..It is as if it isn't catching the 500:100 error, and only catching the general 500 error??
View 1 Replies
View Related
Jul 14, 2008
I have a Win2003 dedicated server (with The Planet) that i use to host a large IPB forum site.
I got it about 3yrs ago and as I was a complete newbie to server management I got Plesk CP installed so that it would take care of all the SQL, PHP and mail installation and setup in one easy go.
I've since found Plesk for Windows to be a complete waste of space.. but it's still on there and has never been upgraded. I don't actually use it as a CP.
Similarly PHP and mySQL have never been upgraded.
Now I've got to the stage where, to upgrade the IPB forum software, I need to upgrade PHP and mySQL.. but looking at the installation, they seem to be embedded in the Plesk installation. They're inside the SWSoft/Plesk/ folders and none of the ini or config files appear to be in the places you'd expect them to be.
My question -
Would these upgrades be simple?? A case of just running an update package?? Or is the fact that PHP/mySQL are embedded in Plesk mean that it'll all mess up?
I'm worried that a failed upgrade will knacker the forum, which is why I've delayed for so long.
View 2 Replies
View Related
Jan 16, 2008
I currently have a decent server that runs around 10 websites, but 1 of those sites contributes around 99% of the total traffic. This large site is being moved onto a new server, leaving the remaining 9 sites rattling around on this big (and expensive!) server.
So, I am now looking for a smaller server to handle the other smaller sites. They get minimal traffic - around 5k uniques a day.
View 7 Replies
View Related
Jan 7, 2009
We are about to shift from linux server to plesk for some reasons given by our management.
I am interested to know that Plesk 8.X or 9.X comes with MS SQL edition in built? or we have to install that separately? This is for a hosting server so the server should have both MY SQL and MS SQL both, how to shift this in plesk, is it possible?
Also if we install plesk will it come with tomcat server? or not? some hosting clients need Java with tomcat?
View 2 Replies
View Related
Aug 2, 2008
I have a windows server with plesk 7.6 i want to install the new version of plesk 8.6, how can I do? I want my domain names (4) be working well with the new version of plesk. I don't know if I backup my domains, plesk 8.6 will recognize from 7.6.
the main reason I want plesk 8.6 is because i want to use the latest version of php and also i want to install wordpress and I think the new plesk will be working fine with these programas
do you have any ideas how can I keep my domain working after I install new plesk?
View 0 Replies
View Related
Mar 27, 2014
Somehow when customers add a new MySQL database they can select a Local MySQL server. It turns out this is the MySQL instance running on the CP server, can I somehow hide this server from the list?
View 1 Replies
View Related
Jun 13, 2007
I have been using MailEnable standard (free) edition for a few months and faced problems of such as mail server crashing every few days, users being disconnected while downloading mail via POP3 etc.
I'm serving not more than 20 sites and only a few of them user mail server frequently
a better mail server to use with Plesk on Windows.
View 12 Replies
View Related
Aug 15, 2012
I am just wondering if Plesk 11 supports the ability to manager smartermail installed on a different server?
I know 10 didn't, and I dont' see that in 11 but just wanted to check.
View 1 Replies
View Related
May 20, 2014
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 '????'.
(Error code 1)
View 2 Replies
View Related
Jun 16, 2015
I created a User Account with the Administrator Role for one of my colleagues & the User Role Properties indicate that access to all of the Plesk services has been granted.
However, when my colleague logs in, he's unable to see the Server tab (see attached screen shot).
Where do I configure the permissions so that he can see the Server tab?
View 2 Replies
View Related
