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 RepliesIs it possible to update the MySQL version on the db nodes from 5.1 to 5.5 or is it supported?
View 3 Replies View RelatedPRODUCT, 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.
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...
We deployed a subscription (through PBAS), and realised afterwards that the database resource was missing.
This has now been added and the subscription synchronised.
However, the MySQL system is still not available on the subscription. How can we enable the MySQL (or indeed any added resource) after the subscription has been deployed.
I saw for Webspace you can add additional webspace, is there a similar feature for the Databases?
I have some problems adding a database and a webserver service-node:
Mar 19 13:44:13 plesk-db : DBG [SYSTEM 4:6600:f6affb70 lib]: [SMConfig] {module_id="Common"; code="1"} Internal error: SAXParseException while parsing /usr/local/pem/etc/service_config.xml: element 'SERVICE_CONFIG' is not allowed for content model '(SERVICES)'.
Mar 19 13:45:50 plesk-www : DBG [SYSTEM 3:9054:f6affb70 lib]: [SMConfig] {module_id="Common"; code="1"} Internal error: SAXParseException while parsing /usr/local/pem/etc/service_config.xml: element 'SERVICE_CONFIG' is not allowed for content model '(SERVICES)'.
Content of the service_config.xml
Code:
<?xml version="1.0" encoding="UTF-8" standalone="no" ?>
<!DOCTYPE SERVICE_CONFIG PUBLIC "SM" "SM 1.0">
<SERVICE_CONFIG/>
I am working on a new install of PPA, and after installation on the management node Im trying to add the other nodes. Ive tried to add a Apache, Postfix, DNS & DB node, and they all have the same issue. The installation task fails with the following error:
Destination host 'node.domain.com' (#3), IP '192.168.1.*' : The operation can not be completed because the following component is missing or is not running: pleskd (sc_name '', sc_id #45)
(domain and IP are removed here, correct in the original error. The IP is a backchannel IP, and the public IP was properly set in the management node).
I've verified that pleskd was installed and is running on each node:
Code:
24710 ? S 0:00 /usr/local/pem/sbin/pleskd --props-file /usr/local/pem/etc/pleskd.props --send-signal
24712 ? S 0:00 /usr/local/pem/sbin/pleskd --props-file /usr/local/pem/etc/pleskd.props --send-signal
24714 ? S 0:00 /usr/local/pem/sbin/pleskd --props-file /usr/local/pem/etc/pleskd.props --send-signal
...
I've verified that my management node can connect to the nodes in question via 8532:
Code:
]# telnet 192.168.1.* 8352
Trying 192.168.1.*..
Connected to 192.168.1.*.
Escape character is '^]'.
^]
telnet> quit
Connection closed.
So there shouldn't be any firewall or other networking issues.
What else can I try to get this running?
What could I fix by trying to start mysql server, recieve following errors:
plesk interface:
Code:
Failed to restart the "mysql" service.
Cannot start/stop/restart service: Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service mysql restart
Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the stop(8) and then start(8) utilities,
e.g. stop mysql ; start mysql. The restart(8) utility is also available.
start: Job failed to start
from the console:
Code:
sudo service mysql start
start: Job failed to start
Code:
mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
output of plesk_11.5.30_reset_instance_data.log:
[Code] ...
Starting point: a working site using a shared IPv4, dedicated IPv6, and SSL. HTTP and HTTPS work, the latter only using SNI of course.
The good news: If I simply allocate an IP resource of 1 to a subscription it is pulled from the pool, assigned to the service node, assigned to the web site, DNS is updated, and the site is automatically changed to using a Dedicated IPv4 and Dedicated IPv6.
The bad news: visitors land on the default web site of the service node, with the default SSL certificate.
Other info: I can't ping the new IP, even though it shows in "ip a l" and /etc/sysconfig/network-scripts/ifcfg-eth0:0. [edited]
After the IP assignment, it is still installed, and /etc/httpd/conf/plesk.conf.d/ip_default/domainname.conf shows the new certificate is being used.
However, a second set of VirtualHost entries is created in server.conf for this IP for ports 80 and 443, with NameVirtualHost enabled on the new IP. The port 443 entry uses the default certificate. Apache's setup this default VirtualHost entry will override the web site configuration because Apache is listening on port 443 with the wrong cert.
If I go to "Change webspace settings" and toggle to Shared IPv4, Dedicated IPv6 the site works again via HTTPS, and Dedicated IPv4 and Dedicated IPv6 breaks it again. Setting the SSL cert to None and back again does not work.
Setting the SSL cert to None, changing to a dedicated IP, and enabling SSL results in the server being inexplicably inaccessible...browsers no longer connect to either the default site or the correct site, and I don't see any entries in the vhosts's logs.
Text when you click Add New Database gives this error
subscription is Administrator
I added a mail resource and a database resource to the "branding" service template, and made sure the provisioning attributes match up to an actual node. I also made sure that under the resources for the branding template the "Branding Hosting (management node)" -> "Number of MySQL databases" is "1" and the "MySQL Database" is unlimited.
Ive made a primary branded domain assigned to the administrator account. When I then login to the account, I see that the mail resource is added and I can add email accounts. However, the database resource does not seem to be activated. Indeed, if I try to add a application in the domain that requires a database, it fails because there is not a database resource available.
The database server is a separate node from the management server.
I do not see any running tasks waiting, and the events log doesnt mention anything about provisioning a database.
Separately but tangentially related, once the account is up, I dont see it listed as an active subscription under the service template. I should see it there, right?
I have a question if it is possible to use my local server as database storage and even some uploaded files. I am planning to host my website even in a shared hosting server provided that I could used my local server as data storage.
View 2 Replies View RelatedI 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?
I freshly installed Plesk 12.0 on Ubuntu 14.04. Everything works accept the MySQL database creation.
When I try to create one, i get this error :
error: the test connection to the database server has failed because of network problems: connection refused...
I'd want to create a user and set custom privileges using the standard mysql-client, ie. create user and grant privileges, but I know that sometimes Plesk overwrites my config files for other services.
View 2 Replies View RelatedI've configured PPA management, web server and a mysql database server. Now I want that if a customer add a mysql, ftp or mail account, that the names begins with a prefix that I've defined.
View 4 Replies View RelatedI have 2 Nodes. Both of them are configured like this:
Node1: Roles: MySQL, Apache,. Postfix; Attributes: Apache, Postfix, Webhost; restricted=>Reseller1
Node2: Roles: MySQL, Apache,. Postfix; Attributes: Apache, Postfix, Webhost; restricted=>Reseller2
I log in as Reseller1 (clean login; not by switching from PPA Admin to Reseller1), create a Webspace and a Database. At that point I am able to see and create Databases on every Node, even on Reseller1 (Node1), which is set to restricted. I guess this behaviour is not intended, isn't it?
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?
mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/thesymbi/public_html/includes/class_core.php on line 274
I get this around 50 times a day!
I am fed up!
I add my site via ftp file to httpdocs but still appears in the default message domain parallels, I've made sure all correct indext.html and others, not to do.
View 1 Replies View RelatedOn windows 2008 server with Plesk 11.5, the Secure your Sites option is not displayed. In addition unable to share SSL certificates across many sites with shared IP address.
View 4 Replies View RelatedI have the problem described here: [URL]
But my Plesk's license allows to use MS SQL Servers.
This began to happen after upgrading Plesk 11 to 12.
In psa Database, in DatabaseServers table it appears. If I delete and add back into Plesk, it shows me no error, but neither added to the database servers.
OS : centos 6.5 2.6.32-431.23.3.el6.x86_64 actual plesk version 12.0.18 after auto-update google authentication and 3other extensions were enabled and now google authentication isn't in the list of installed extensions and not functioning i was able to login as before without google authentication but when I wanted to reinstall the extension catalog shows a empty screen I have ran /usr/local/psa/admin/sbin/autoinstaller --select-release-current --upgrade-installed-components & /usr/local/psa/bootstrapper/pp12.0.18-bootstrapper/bootstrapper.sh repair no luck where to look or to reinstall the extention catalog ?
View 3 Replies View RelatedWhere is a server's IP address for outgoing requests set? e.g. if a script on the server fetches ip-address.com, the IP that is identified there. A server may have multiple IPs pointing to it, but there's only one that outgoing requests are funneled through. I've tried changing "Main Shared IP" in WHM, but that doesn't seem to affect this.
Is this set server-side, in some setting file - or is this a datacenter thing?
I installed the MySQL binary packages in /usr/local/mysql/ after removing the MySQL RPM package. MySQL is functioning when I executed /usr/local/mysql/bin/safe_mysqld. I reinstalled MySQL before I installed PHP. When I used a PHP script to access a MySQL database, it outputs an error:
Code:
Warning: mysqli::mysqli() [function.mysqli-mysqli]: (HY000/2002): can't connect to local mysql server through socket /var/lib/mysql/mysql.sock in index.php on line 2
However, I installed MySQL in /usr/local/mysql, not in /var/lib/mysql. How do I fix MySQL?