Plesk 11.x / Windows :: Adding Second MySQL Server

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


ADVERTISEMENT

Plesk Automation :: Local Server Visible When Adding New MySQL Database

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

Plesk 11.x / Windows :: Account Not Adding DNS Record On MS-DNS Server

Apr 24, 2013

I have one domain who's not create dns in MS DNS server, i try create manuall but after this the record is missing, but on plesk showing, How to fix this ?

View 2 Replies View Related

Plesk 12.x / Windows :: Adding Account To Thunderbird - Mail Server Doesn't Use Encryption

Jul 22, 2015

I have a problem while i'm trying to add a mail account to Thunderbird

I see the problem that Mail server doesn't use encryption !!!

View 1 Replies View Related

Plesk 11.x / Windows :: Adding A Record In DNS?

Aug 23, 2012

With provided information at [URL] .... did not work? when setting it up in control panel -> domain's dns panel and plesk version is 11.0.9

It needs the following DNS records

Record type: SRV
Service name *: _Autodiscover
Protocol name *: _tcp (it will automatically add your domain and to edit it again shows as invalid)
Port number *: 443
Priority of service: very high(0)
Weight of service: theres no 0 option so use 10 as the option and to edit it again shows as invalid)
Target host *: use your mail ip address?

View 1 Replies View Related

Plesk 12.x / Linux :: MySQL Remote - Adding External Resource?

Jun 15, 2015

I am looking to add a mysql external source to my plesk. So far no difficulty.

My question is if I remove the mysql server where the currently plesk. I have to say to the panel get the information (psa, roudcube, horde) on the remote mysql to invez mysql local server?

View 3 Replies View Related

Plesk 11.x / Windows :: Adding New Customer - Authorization?

Jun 13, 2014

I use Plesk 11.5.3 and have a problem with adding new customer. When i have add a new customer and type the domain in my browser, I have to authorisize, but I haven't set up a protect folder know. What's wrong with my plesk? I think this is a permission problem with IIS. 

View 1 Replies View Related

Plesk 11.x / Windows :: Adding Domain Alias

Jun 10, 2013

I use Plesk 11.0.9 Update #53 on Windows 2008 SP2. Nameservers and mail server are external servers and fully working.I have a 'fake' web site (roundcube. local) in which I've successfully installed roundcube and I would use it as webmail.I've added a domain alias 'webmail2.domain.com' and it works like a charm.Now I've moved the main domain "domain.com" on the plesk server and I would like to add a 'webmail.domain.com' domain alias to the 'roundcube.local' website.If I try to do it, I receive this error:

"Error: Wrong prefix for domain alias"..Even if I try to add webmail.anotherdomain.com (not installed on the Plesk server) I get the same error.The error shows up either the host is configured to the Plesk machine or not.If I set the binding directly in IIS it works but I'd like to use the plesk to do this.

View 3 Replies View Related

Plesk 12.x / Windows :: Error When Adding IP On Panel

Oct 10, 2014

We are getting an error every time that i try to add a new IP on Plesk panel. I go to "Tool and settings" than "IP address", "Add ip address" on fields i already try to ip:

xx.xx.xx.xx/32
and
xx.xx.xx.xx/submask

every time that i click on OK, the button become loading an never finish....

View 7 Replies View Related

Plesk 11.x / Windows :: Adding Language Packs

Sep 4, 2012

We just installed a new Windows 2008 r2 server with Plesk v 11.0.9. We need to install the French Language pack, but can not find how to do it. nothing in the knowledge base on this. I tried the look in the add/removing components, but it is not there.

Is there a command line program to install language packs?

View 9 Replies View Related

Plesk 12.x / Windows :: Adding Subdomains - This Page Can't Be Displayed

Jan 17, 2015

Adding simple subdomain in plesk panel hosted on windows 2012, but browsing the subdomain returning:

This page can’t be displayed....

View 4 Replies View Related

Plesk 11.x / Windows :: Error - Migrating Websites Or Adding New Webspace

Dec 3, 2013

I'm migrating all of my websites form one server to a new one. And everything is working as planned with the plesk migration manager. But with my last website i'm having some problems and getting this error:

Short Error: Adding webspace manually

Code:
Error: System user update is failed: Unable to create system user: Unable to execute usermng: column login is not unique (Error code 1)
Full Error Log - Migration

Code:
Warning: server "server"
Unable to dump server settings. Server element will be empty[Object reference not set to an instance of an object.]
Warning: domain "teamswear.be"

[Code] ....

I've also tried to add the webspace manually but getting the same error.

View 9 Replies View Related

Plesk 11.x / Windows :: Adding Newly Registered Domain - Edit DNS?

Apr 25, 2014

I recently purchased a dedicated server with Godaddy, I also registered a domain with same Godaddy.

Now when I tried to add a new domain in plesk, I got a warning message that "the domain is pointed to 192.198.XX.XX" which is different from my dedicated server IP. The message also says I should edit the DNS.

Now my question is What do I need to edit from the default dns plesk has assigned to my domain? Do I need to use the domain's default IP. I want to be able to host multiple website on my server...

View 2 Replies View Related

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 View Related

Plesk 11.x / Windows :: PHP Open Basedir Restriction - Adding Paths Not Working

Aug 16, 2013

I'm trying to use server side includes in a PHP website but am getting the error open_basedir restriction in effect.

I've tried going in to the PHP Settings for the website and have selected the predefined option

{DOCROOT}{/}{:}{TMP}{/}

Which as I understand it should allow access to all files within my httpdocs folder but I still get the error:

PHP Warning: include(): open_basedir restriction in effect. File(/sparklyphp/cms/inc/checkAdminLogin.php) is not within the allowed path(s): (F:PLESKWWWviwebsitedesign.comhttpdocs;C:WindowsTemp) in F:PLESKWWWwebsitedesign.comhttpdocssparklyphpcmsindex.php on line 1

The thing is I know 100% that the file it's having a problem with is in a subfolder of the

F:PLESKWWWwebsitedesign.comhttpdocs folder (the full F:PLESKWWWwebsitedesign.comhttpdocssparklyphpcmsinccheckAdminLogin.php).

View 2 Replies View Related

Plesk 11.x / Windows :: MySQL Could Not Start After Unexpected Server Shutdown

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

Adding Of User Defined Services In Windows 2000 Server

Jun 17, 2008

Just checking how do I add a Windows Defined service in Windows 2000. I saw some info.

But it seemed to apply to Microsoft Windows 2003 Server as there isn't instsrv or srvany in Windows 2000 server even after I uploaded the Resource Kit Tools. Am I missing something?

Or can someone tell me where to download these for Windows 2000?

View 2 Replies View Related

Plesk 11.x / Linux :: Error Adding Remote Database Server

May 9, 2014

PRODUCT, VERSION, MICROUPDATE, OPERATING SYSTEM, ARCHITECTURE
Plesk 11.5, 11.5.30 Update #44, last updated at April 30, 2014 03:25 AM, Centos 6.5 (Final), Linux 64bit

PROBLEM DESCRIPTION
When I try to add an extra MySQL server, running on a different server, I always get an error that the user has no admin access. But the user I created does have admin access to the database.
The remote database is a MySQL 5.5 on a Linux Ubuntu 12.04 LTS server

STEPS TO REPRODUCE
Tools & Settings -> Database Servers -> Add Databases server

ACTUAL RESULT
Error: Test connection to the database server has failed because the supplied account does not possess administrative privileges: Access denied for user 'admin'@'%' to database 'd536cedf97037e'

EXPECTED RESULT
A working database connection.

ANY ADDITIONAL INFORMATION
These queries are logged by MySQL:

140509 16:54:51 28 Connectadmin@10.1.0.162 as anonymous on
28 QuerySELECT VERSION()
28 Querycreate database `BUG115166_1374110215536CEC3816DD2` /*!40101 default charset=utf8 */
28 Querycreate database `bug115166_1374110215536cec3816dd2` /*!40101 default charset=utf8 */
28 Queryinsert into mysql.user (Host, User, Password) values ('%', 'bug115166_17546', password('BUG115166_1374110215536CEC3816DD2'))
28 QueryFLUSH PRIVILEGES

[Code] .....

If I just ignore this message, go to a subscription and create a database, then the database gets created just fine. It's just Plesk that thinks that something went wrong.

View 2 Replies View Related

Plesk 12.x / Linux :: Adding Multiple PHP Version / Error Reading Data From FastCGI Server

Jun 6, 2014

I'm trying to add multiple PHP version (current version installed: 5.5.13), using the official documentation. I always get 500 Internal Server Error after switching to the new version, with the following error_log content:

Code:
[Sat Jun 07 00:49:35 2014] [warn] [client XXX.XXX.XXX.XXX] (104)Connection reset by peer: mod_fcgid: error reading data from FastCGI server
[Sat Jun 07 00:49:35 2014] [error] [client XXX.XXX.XXX.XXX] Premature end of script headers: index.php
Here you can view phpinfo() obtained running php54-cgi index.php from the command line. Same script doesn't work as FastCGI.

I'm trying to add PHP 5.4.29. Here is how I compiled it:

Code:

./configure
--prefix=/usr/local/php54
--with-bz2
--with-config-file-path=/usr/local/php54/etc
--with-config-file-scan-dir=/usr/local/php54/etc/php.d
--with-curl

[code]....

Switching back to PHP 5.5.13 and the script works fine (a simple phpinfo() output).How can I try to understand/debug what's wrong with the installation?

View 5 Replies View Related

Plesk 11.x / Windows :: Upgrade MySQL From 5.1 To 5.5?

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

Plesk 11.x / Windows :: Mysql Could Not Start

Mar 23, 2014

I can't start MYSQL. How can i fix this?

View 3 Replies View Related

Plesk 11.x / Windows :: How To Upgrade Mysql 4.x Installation

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

Plesk 11.x / Windows :: Unable To Connect To MySQL?

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

Plesk 12.x / Windows :: MySQL 5.5 - Unknown OS Charset

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

Plesk 11.x / Windows :: Change Database From MySQL To MSSQL

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

Plesk 11.x / Windows :: List Of Suspend Domains From Mysql

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

Plesk 11.x / Windows :: MySQL Stopping With No Apparent Reason

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

Plesk 12.x / Windows :: PHP Connecting Over Localhost To MySQL Very Slow

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

Adding A Linux Machine To Windows Domain Controller

Oct 24, 2008

We have a domain portal controller for windows. All the machines in the n/w are connected to it. So, when ever an user enters the user name and password it gets authenticated from the domain portal controller. So, my login can be accessed anywhere in the netowrk.

Example : my login is sabarishks which can be used in any machine under this domain controller.

But, if the system is installed with both linux and windows only windows username will be authenticated using the domain controller. Whereas, the linux users will work with in the system using /etc/shadow file. Hope, I am clear so far.

The requirement is same as above. The authentication mechanism for linux should work as windows. When ever an user is entered with a username and passwd, it should get authenticated from domain controller.

I mean, the user created in a windows machine should be used for linux login also. More importantly, It should work in all systems.

Which technology can be used to do this? Samba,Ldap, NFs or what?

View 1 Replies View Related

Plesk 11.x / Windows :: Import MySQL - Database Failed After Upgrade

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

Plesk 12.x / Windows :: WordPress Install - MySQL Extension Was Not Found

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







Copyrights 2005-15 www.BigResource.com, All rights reserved