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
ADVERTISEMENT
Nov 24, 2014
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?
View 1 Replies
View Related
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
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
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
Jul 14, 2015
My panel suddenly stop works to create databases from client account.This error shows:
Internal error.
PHP Notice: Undefined variable: dbType
From admin account there is no problem to create databases.I`ve run bootstrap.sh repair successfully but still not working.Plesk 12.0.18 #55 Ubuntu Linux 10.04
View 2 Replies
View Related
Oct 9, 2014
I just tested the WP creation feature of PP12 and I get the following error when I attempt to view the newly created CMS...
"Error establishing a database connection"
If I navigate to the database page and click webadmin, I can connect and see the WP database created. Everything works in phpMyAdmin.
Going to ../wordpress/wp_login.php returns the error.
View 3 Replies
View Related
Sep 9, 2013
I just upgraded from 11.0.9 and i got the following error
ERROR: Zend_Db_Statement_Exception
Eine Ebene höher
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ipAddress' in 'where clause'
A Google Search shows that under Windows there is dbupgrade.exe
Is there such a tool under Linux too??
View 4 Replies
View Related
Nov 20, 2014
I seem to have an error with backing up to my personal FTP repository. I have only just noticed the issue, but i believe it originated when I upgraded Plesk Panel 11 to Plesk Panel 12. I am currently running version 12.0.18 on Cent OS 6.5.
Note whether i check the "Use passive mode" option makes no difference to my problem.Below is what I get from the panel.log under /usr/local/psa/admin/logs
Code:
[2014-11-20 19:49:44] ERR [util_exec] proc_close() failed
[20-Nov-2014 19:49:44 UTC] PleskUtilException: '/usr/local/psa/admin/bin/pmm-ras' '--check-repository' '--dump-storage=ftp://USERNAME@IPADDRESS/MYFTPDIRECTORY/' '--use-ftp-passive-mode' failed with code 121.
stdout:
Transport error: unable to list directory: Curl error: Access denied to remote resource
stderr:
file: /usr/local/psa/admin/plib/Service/Agent/Transport/Local/Exec.php
line: 57
code: 0
trace: #0 /usr/local/psa/admin/plib/Service/Agent/Transport/Local.php(60): Service_Agent_Transport_Local_Exec->process(0, Object(Service_Agent_Command_Exec), Object(Service_Agent_Transport_LocalTransaction))
[code]....
View 8 Replies
View Related
Jun 16, 2014
why but autoupdate fails. It doesn't give a reason why it cant backup.
For line of log :
START pp11.5.30-bootstrapper-11.5.30-cos5.build115131216.11 installing AT Thu Mar 27 07:43:37 CET 2014
Last lines of log :
===> Upgrading database
Trying to start service mysqld... mysqld (pid 24610) is running...
done
Trying to establish test connection... connected
done
Trying to find psa database... version is 011005030
Version is OK, no need to create psa database.
Trying to backup MySQL database...
ERROR while trying to backup MySQL database
Check the error reason(see log file: /tmp/plesk_11.5.30_installation.log), fix and try again
Trying to start psa...
**** Product prep-install for BASE failed.
***** problem report *****
ERROR while trying to backup MySQL database
Check the error reason(see log file: /tmp/plesk_11.5.30_installation.log), fix and try again
STOP Bootstrapper 11.5.30 prep-install for BASE AT Tue Jun 17 04:04:48 CEST 2014
View 2 Replies
View Related
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
May 11, 2014
After a fresh install of Plesk 11.5 am unable to FTP the server.
The FTP client shows that successful but no file in the remote server and its lock I saw only / I cannot stroll the client on remote server
Site builders work ok, Wordpress and built software update and publish...
View 5 Replies
View Related
Jan 17, 2015
I have Plesk installed on the master nameserver ns1.example.com, the dns slave manager extension installed, a working slave ns2.example.com and Plesk installed with working WHMCS autocreation of customers and subscriptions on a shared hosting server web1.example.com. I feel there's probably something obvious that I'm missing, but I can't figure out how to autocreate DNS records on ns1.example.com for customers on web1.example.com when new accounts are created.
View 2 Replies
View Related
Dec 23, 2014
I'm having a problem with Plesk Panel 11.0.9 update #64. All other page running perfect. But when I go to "Backup Manager --> Database Backup Repository --> Upload Backup File" then Plesk Panel show error: Internal Server Error 500.0.
On server, it show detail below: .....
View 2 Replies
View Related
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
Jul 21, 2015
if I can install plesk panel with a dedicated database server... and how.
View 3 Replies
View Related
Jun 10, 2015
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 |
+-----------+------------------+
View 2 Replies
View Related
Jun 2, 2015
Is it possible to add a ssl to a IP number despite of domain name?
I would like to know if i can buy a ssl and set a IP on website address...
View 5 Replies
View Related
May 6, 2015
I seem to be having a strange problem with Plesk 12, after adding about 23 domains, i cant seem to add any more domains.
While adding the domain, it just keeps syncing, and then when i click on the subscriptions i see the domain has been added, but i cannot customise it.
View 3 Replies
View Related
Nov 23, 2014
Error: IP addresses for mail service of domain xxxxxx.com are not set
View 3 Replies
View Related
Feb 11, 2013
I would like to install mcrypt extension on my server and i don't find procedure .
My version is :
OSCentOS 6.3 (Final)
Version de Parallels Panel11.0.9 Mettre à jour #36, dernière mise à jour à Fév 8, 2013 06:32 PM
View 19 Replies
View Related
Jul 16, 2014
According to de Plesk Administrator Guide and according to the kb article: [URL] ...., Plesk Panel is suitable to enable multiple php versions After I performed the steps mentioned in the kb article, all seemed fine until somehow php-cgi and php-fcgi broke down after
Code:
# service httpd restart
After this event, all websites hosted on this particular the server only work running php as an apache module.
I am running Pleks Panel 12.0.18 #7 on top of CenOs 6.5 on this particular server, which means php version 5.3.3 is installed by default. PHP 5.3.3 also is was the php version for the "custom: false" php handlers (id's: cgi, fastcgi, module). Somehow all php handlers look like this:
Code:
# /usr/local/psa/bin/php_handler --list
id: display name: full version: version: type: cgi-bin: php-cli: php.ini: custom:
cgi 5.5.13 5.5.13 5.5 cgi /usr/bin/php-cgi /etc/php.ini false
fastcgi 5.5.13 5.5.13 5.5 fastcgi /usr/bin/php-cgi /etc/php.ini false
[Code]....
View 7 Replies
View Related
Jul 9, 2008
I have a 1GB MySQL database (compresses down to 300MB) and would like an automated method of backing it up to a remote server. Both accounts are shared hosting accounts (if it matters, both are running CPanel, no shell access on either).
View 13 Replies
View Related
Nov 20, 2014
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.
View 5 Replies
View Related
Dec 27, 2014
I would like to add spdy under all nginx configuration as below
listen 443 ssl spdy;
How to add them globally ?
View 4 Replies
View Related
Jan 20, 2015
When i add a Domain or Subdomain through Plesk Panel, I get the following Warning :
Attention: relink-vhost-logs failed: mkdir: cannot create directory `./vps118861.ovh.net/logs': File exists ERROR: Cannot relink logs. Target directory '/var/www/vhosts/vps118861.ovh.net/logs' is in invalid state.
[URL]
I tried the 2 solutions but I still have the error... here are the results of the two commands :
[root@vps118861 logs]# ls -alh
total 2,3M
drwxr-xr-x 16 administrateur root 4,0K 20 janv. 13:59 .
[Code]....
View 2 Replies
View Related
Aug 25, 2014
When adding a subscription with a certain plan, I get this error"Error: The plan was not applied: Custom changes in PHP settings" almost instantly after I initiated the creation of the new subscription. Another service plan doesn't have the issue, and though I tried finding the reason why one works while the other doesn't I simply wasn't able to. The service plan in question is used for over 40 others without a problem just when I select it for a new subscription, I get the mentioned error message.I am using Plesk 12 on Linux, all latest updates installed.
View 1 Replies
View Related
Feb 5, 2015
i registered some new domains and wanted to add them via Plesk. Before i did that i got the stanard Plesk default page saying that i have to add the domains via plesk as usual.
When i did that the domain switched to a white page and is not able to load .html pages, i can load a phpinfo.php or install wordpress etc. but when i try to load a simple .html file with css or something, i only get a whitepage..
i dont know why this is happening, other domains from december are working fine, new ones wont. the error.logs are empty and even after a whole server restart it wont work.I´m using Ubuntu 14.04 LTS Server 64bit + Plesk 12.0.18
View 3 Replies
View Related
