Plesk 12.x / Linux :: Installation With Dedicated Database Server
Jul 21, 2015if I can install plesk panel with a dedicated database server... and how.
View 3 Repliesif I can install plesk panel with a dedicated database server... and how.
View 3 RepliesI found out a easy way to update the Database name of a WP installation through phpmyadmin panel, However I can't seem to update or refresh the Parallels WP Settings with correct information. Is this a bug?
This is how to reproduce:
From phpMyAdmin select the database you want to select, in the tabs there's one called Operations, Go to the rename section.
Update the user privileges to the new Database name and remove the old privileges (save)
Then manually update the wp-config file which contains the 'Database name' (save)
Then goto Parallels Plesk > Websites & Domains> WordPress Installations > Change Settings
Here you should notice the Change Settings for the WordPress Installation still contains the old Database name.
Is there any way of updating this?
I have a clean installation of Parallels Plesk on my server, and I installed wordpress on two of my domains. I'm scanning for installations through Plesk Admin, and it shows two installations with empty name and the toolkit is not functional at all. Check the attached screenshot.
View 2 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 would like to change the access control for datebase users via CL: command: /usr/local/psa/bin/database --update-dbuser web1_presta -server localhost:3306 reply: The database user was successfully updated. examination: mysql> select host, user from mysql.user;
+-----------+------------------+
| host | user |
+-----------+------------------+
| % | web1_presta |
| localhost | web1_oxid |
| localhost | web1_presta |
| localhost | web1_shopware |
| localhost | web1_wp |
+-----------+------------------+
Only when using the GUI:
home -> Subscriptions -> Website & Domains -> Databases -> Users -> web1_wp -> Access control
-> from Allow remote connections from any host
-> to Allow local connections only
is also the user adjusted:
mysql> select host, user from mysql.user;
+-----------+------------------+
| host | user |
+-----------+------------------+
| localhost | web1_oxid |
| localhost | web1_presta |
| localhost | web1_shopware |
| localhost | web1_wp |
+-----------+------------------+
Is it possible to use a remote database server on two or more Plesk installations without issue?
Plesk A (192.168.1.1):
Local MySQL (default)
Remote A MySQL (192.168.1.5)
Plesk B (192.168.1.2):
Local MySQL (default)
Remote A MySQL (192.168.1.5)
... etc etc. Is that possible? It'll allow me to create databases on the remote server from both/all the Plesk servers without conflict?
We like to create the mail accounts through php scripts in mywebsite.com website. So we request you to setup the Qmail with Vpopmail server in our server. As we have the following packages are already installed.
1. Qmail
2. Courier POP/IMAP
3. Horde Webmail client
providers who install the vpopmail in the our server and configure these four packages to create the mail accounts via php script. So that we can use vaddsuer command in php to create the mail ids and also imap_open commands to access the mails.
We will take the decision sooner since we need to live the website shortly.
Our server is configured by plesk control panel.
When I update servers via CLI autoinstaller, I always (afair) get this mysqldump error message:
Code:
Stopping psa... * Stopping Plesk engine pool manager sw-engine-fpm
...done.
done
-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
mysqldump: Got error: 1049: Unknown database 'atmail' when selecting the database
===> Cumulative APS controller database (apsc) upgrade has been started.
===> Cumulative upgrade of APS controller database has been completed.
===> Cumulative Plesk database upgrade (revertable stage) has been started.
===> Preparing Plesk database upgrade (revertable stage).
===> Cumulative upgrade of Plesk database (revertable stage) has been completed.
Reading package lists...
There is no database "atmail" on any of our Plesk servers. Simple solution should be to first check if the DB exists before performing actions on it.As a bonus, perhaps it would be possible to suppress the warning about mysql.event.
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 need a dedicated server sometime in the future and I was wondering if I should use Virtuozzo or Hypervm and how much can I get a dual core or quad core with good support? Thank you for your time.
View 1 Replies View RelatedI've had nothing but issues trying to restore a backup from another plesk installation.Running Plesk 12 on CentOS 6. I installed a php extension which required php 5.4. Yum updated our php version, which broke a couple of our sites. In trying to use yum to remove php 5.4, it also removed several components to plesk.
I then attempted to reinstall plesk and restore our backups from the previous day, but ran into several errors related to the way plesk hashes passwords in backups (as I now had a new key to hash against, they wouldn't work right). I solved that problem by running the fix passwords utility . But now I'm getting the following errors, I suspect the first one is the main problem.
WARNING: (server object '') Execution of /usr/local/psa/bin/sw-engine-pleskrun /usr/local/sb/utils/bru.php --restore --log=stdout --file=/usr/local/psa/PMM/tmp/sb54DVSHeFh.zip --target=server_settings failed with return code 1.
Stderr is
[code]....
I get this error by installing joomla attached...
View 2 Replies View RelatedAfter my HDD crashed, I replaced it and installed Plesk 12.0.18 but not some options are missing from the panel.I'm missing this functionality: Send from domain IP addresses and use domain names in SMTP greeting
Also now after the restoration of the backups in /var/www/vhosts/<DOMAIIN_NAME>/logs/There are no logs, but they are present in /var/www/ vhosts/ system/<DOMAIIN_NAME>/logs/Before they were symlinked to the first directory.all my domains with a dedicated IP are being sent from my main IP, and they are being marked as spam because of SPF.
During the installation procedure, the script stopped unexpectedly
Errors were encountered while processing:
/var/cache/apt/archives/psa-proftpd_1.3.5-ubuntu14.04.build1200140604.16_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)
Ubuntu 10.04.4 LTS
12.0.18 Update #46, last updated at May 15, 2015 03:57 AM
Just recently (after update #46) Fail2Ban stopped working and I couldn't restart it or pin point the reason behind it. I decided to uninstall F2B component via Plesk installer.
F2B uninstalled however when I try to install it again I get error : 'Installation will not continue'
Where to start and where can I find log files that could give me some clues?
Installation of the Plesk VPN extension reproducible fails on Debian Wheezy
Plesk 12.0.18 Update #24
Debian 7.7 Kernel 3.2.0-4-amd64 #1 SMP Debian 3.2.57-3+deb7u2 x86_64 GNU/Linux
Steps to reproduce:
Plesk Panel > Updates and Upgrades > Install "Plesk VPN extension"
Green Message "All operations with products and components have been successfully completed."
Going back from Upgrade window to Plesk Panel Home
[Code] .....
What I already have tried:
Shell > apt-get install psa-vpn
Getting error mossage:
Setting up psa-vpn (12.0.18-debian7.0.build1200140606.15) ...
ERROR: could not insert 'tun': Unknown symbol in module, or unknown parameter (see dmesg)
Shell > modprobe tun
ERROR: could not insert 'tun': Unknown symbol in module, or unknown parameter (see dmesg)
I'm just testing Plesk 12 on CentOs 7 and after installation is succesfully completed, I cant access [URL]
This is the environment and steps which I taken:
* Fresh CentOs 7 iso
* Windows 2008 R2 Hyper-v hypervisor
1) Installation of the CentOs successfully completed
2) Yum update
3) Download auto-installer
4) Run auto-installer
5) process successfully completed
6) NOW I CAN'T access the url ...
yesterday I have installed CloudLinux on my Centos 6.6 server. Today only my site was not reach. I have contacted cloudlinux support but this problems does not depend from they. In my personal site I have also WHMCS. For this issue I try: [URL] Then: [URL] I changed size of buffering: [URL] And at the end this: [URL] After that I have the same problem only for one domain.
View 5 Replies View RelatedIs it possible, that the script changes my admin password for MySQL? I can not connect to my MySQL Server any more.
View 1 Replies View RelatedInstalling Plesk Panel with Spamassassin on Ubuntu 14.04 LTS gives a significant error:
Restarting SpamAssassin Mail Filter Daemon: No /usr/bin/perl found running; none killed.
server socket setup failed, retry 1: spamd: could not create IO::Socket::INET6 socket on [::1]:783: Cannot assign requested address
server socket setup failed, retry 2: spamd: could not create IO::Socket::INET6 socket on [127.0.0.1]:783: Address already in use
server socket setup failed, retry 9: spamd: could not create IO::Socket::INET6 socket on [127.0.0.1]:783: Address already in use
spamd: could not create IO::Socket::INET6 socket on [127.0.0.1]:783: Address already in use
invoke-rc.d: initscript spamassassin, action "restart" failed.
dpkg: error processing package sa-compile (--configure):
even though spamassassin (i.e. spamd) is not running. The usual suspects for the before mentioned error, being
a) differences in the name of the PIDFILE variable in /etc/default/spamassassin and /etc/init.d/spamassassin
b) directory and/or file location are not readable/writable
are not causing this specific installation bug. The work-arounds:
1 - not installing spamassassin (not an option)
2 - installing spamassassin and (afterwards)
change /etc/default/spamassassin, add the option "-4" to the line OPTIONS, resulting in the line: OPTIONS="--nouser-config -4 --username=popuser --daemonize --helper-home-dir=/var/qmail --virtual-config-dir=/var/qmail/mailnames/%d/%l/.spamassassin --create-prefs --max-children=5"
run plesk-installer or autoinstaller again ..Work-around 2 works fine, after reinstallation the /etc/default/spamassassin is as it should be (note that the added "-4" is not present anymore).
The before mentioned work-around suggests some error in the installation process, very likely to be an issue with the chronological order of installation of the various components. In theory, it can be excluded that this bug/issue is caused by psa-spamassassin and/or spamassassin (version 3.3.x) packages, even though some current spamassassin bugs are known: URL....I sincerely hope that Parallels Team can investigate and patch both of the bugs/issues.
In the Wordpress Toolkit several WP installs appear with exclamation mark and title: "A Wordpress installation was previously detected at this path, but it is not operating properly".
View 1 Replies View Relatedon my Ubuntu 14.04 LTS server, I have ran the install script. This process stopped with the message: ERROR while trying to establish test connection. If you are installing Plesk on an already configured MySQL server, you need to specify the administrator's credentials to succeed with the installation.
To do this, you need to create a file - /root/.my.cnf with the 'client' section where you need to provide user and its password ("user = $admin_name" and "password = $admin_pass").
After installation is finished, the file /root/.my.cnf will be renamed to /root/.my.cnf.bak
Check the error reason(see log file: /var/log/plesk/install/plesk_12.0.18_installation.log), fix and try again
Accordingly, I have the existing my.conf copied to the ROOT directory and added the two missing lines in the client area. After that I started the plesk-installer.sh again. The process stopped at a line
"Installed product components are determined" and nothing still happend. The log files says nothing but the last information at the previous try.
Yesterday I have installed CloudLinux on my Centos 6.6 server. Today only my site was not reach. I have contacted cloudlinux support but this problems does not depend from they. In my personal site I have also WHMCS.
For this issue I try: [URL] ....
Then: [URL] ....
I changed size of buffering: [URL] .....
And at the end this: [URL] ....
After that I have the same problem only for one domain.
I am running phpbb 3.0.12 installed from Plesk. In Plesk it is showing me that there is an upgrade available to version 3.1.2-15 however when I Re-Check the version in phpbb it says that I already have the latest version 3.0.12. That's a little weird.
The problem is when I upgrade to 3.1.2-15 in Plesk, it will mess with the whole installation. The forum page will redirect in circles to /install/index.php which doesn't even exist and I can't do anything except revert to before the upgrade.
So my questions are: Why does Plesk show a version 3.1.2-15 but phpbb says the latest one is 3.0.12? How does the upgrade process from Plesk work? I expect it to automatically do everything, or why else would I want to let Plesk upgrade?
Iupdate to plesk 12.0.18
I tried to install open-xchange from application vault.
I got the following error message: Fehler: Die Installation von Open-Xchange ist fehlgeschlagen. Non-zero exit status returned by script. Output stream: 'Creating OX context user_30 Not Found Failed to create OX context user_30: Not Found '. Error stream: 'Creating OX context user_30 Not Found Failed to create OX context user_30: Not Found '.
the following properties I made:
public ox website: http://ox.mydomain.de
ox installation server: myip
I have been trying to identify why mi server has high load cpu, suddenly CPU load suddenly jumps, from 1 to 40 and until 110
If I restart mysqld and apache, the cpu gets back to normal, until this happen again
My server is
GenuineIntel, Intel(R)Core(TM) i5-2400 CPU @ 3.10GHz
VersionParallels Plesk Panel v11.0.9_build110120608.16 os_CentOS 6
CentOS 6.4 (Final)
CentOS 6 x64 Processor: Intel Core i5 - 3.10 GH
I already installed FAIL2BAN and DDOS DEFLATE without lock. I have CloudFlare Enabled.
When there is a high CPU load, I have checked netstats, and I don't identify many ips connected, so I think it could be an internet script (or virus).
I will paste the result of
ps fax
command, in a moment of high cpu load
I have installed the Wordpress application. The wordpress url is "server.com/wordpress", but I want to change it to something like "server.com/myblog".
In Plesk, the installation path cannot be changed (at least, it is not under "Change Settings").
Changing the Wordpress installation itself is not that difficult (renaming the folder in httpdocs and changing the siteurl and home parameter in the database), however, in Plesk still the old installation path is shown, and the Plesk interface to Wordpress obviously does not work any more.
How can I change the Wordpress installation path in Plesk?
Version Parallels Plesk v12.0.18_build1200140606.15 os_Ubuntu 12.04
OS Ubuntu 12.04.5 LTS
How to install PHP (v.5.3+) compatible with Plesk v.12.08 with support for sockets and pthreads, mysql and etc. for Centos 6.5 (I have some configuring options).
Should I build it or there are another options provided by Plesk panel?
I need only one PHP (not multiple releases) but fine working if possible.
I got and apt-get dependencies error while installing Postfix. At the end the log told me, to ask for free support - thats what I am trying to get here.
My system is Debian Wheezy with Plesk 12.0.18
How can I re-enable my Postfix?
I have a manual instalaltion of wordpress, how I can associate it to a webspace and manage like an webapp installed from plesk?
View 1 Replies View Related