All Website VB On Server Database Error
Nov 7, 2009i transfer all customer in new server
and restore all backups
but all website VB appear Database error
although mysql work very good
ADVERTISEMENT
Plesk 11.x / Linux :: Error Adding Remote Database Server
May 9, 2014PRODUCT, 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.
Plesk 11.x / Windows :: Internal Server Error 500.0 When Upload Database Backup File
Dec 23, 2014I'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: .....
Apache :: Database Error On All Non-database Webpages
Mar 15, 2013I've just built a new LAMP server and I'm having a little issue where Apache doesn't serve a simple non-database webpage, instead, I get an error on all my virtual-host in the browser: Database Error: Unable to connect to the Database: Could not connect to MySQL.
I've googled the problem but since the error mentions MySql, everything I find is related to connecting to MySql, which I'm not trying to connect... and I've contacted my Linux mentor about this issue... This is something I've never seen before... don't know why Apache thinks I'm trying connect to MySQL on every browser call to the server...
However, MySQL is accessible via telnet, and all my permissions are correct...
Hosting For 4GB Website + 2GB SQL Database
Aug 9, 2008I have a friend who has a dedicated server right now that uses a good 4GB for all his website content. (not streaming media but just a whole bunch of scripts and etc. well thats what he tells me). And so anyways, his SQL database is about 1-2GB. And he is not too sure about his monthly traffic but its a social networking site with a good amount of users (so its actively used by many users). Would it be necessary for him to have a dedicated server or do you think he could cut costs with a shared hosting account at like host gator or some other shared hosting service like that? I guess my biggest concern is his current database. A lot of shared hosting companies (from what i saw) offer unlimited Mysql Tables do they have size limits? And does a bigger sql database drastically effect the performance of the overall server?
View 14 Replies View RelatedDatabase And Website On Different Servers
Oct 26, 2007We have 2 linux servers directly connected by Gigabyte Ethernet. On a First server (192.168.0.1) we have a website (PHP5, Apache2), on the Second server (192.168.0.2) (CentOS 5 64bit, kernel: 2.6.22.9xe5u) we have MySQL 5.0 Database. A website from a Fist server connects to the database on the Second. The problem is that this system is very slow. We triet to move our website from First server to the Second and it works 50-300 times faster.
This is very strange, because when we print SQL queries of a website we see that some similar queries which are not dependent on a data or where there are very small amount of data, are executing in very different time.
For example:
SELECT t.*, tl.title, tl.content FROM site_tree_public AS t INNER JOIN site_tree_public_localdata AS tl ON t.id=tl.site_tree_public_id WHERE t.hidden='0' AND tl.lang_keyword='eng' ORDER BY parent_id, orderid
0.61763
after refresh 0.00365
another refresh 0.86579
another refresh 0.00302
another refresh 1.22748
Another example:
Four similar queries to four different databases (shemas), on one page load:
SET NAMES utf8 0.00021
SET NAMES utf8 0.00012
SET NAMES utf8 0.00012
SET NAMES utf8 0.20491
When we moved website to the Second server these queries are executing in a good stable time.
Also some following problems were noticed:
1. While connecting to the FTP, server slowed down and sometimes connections were dropped
2. We tried to install Ubuntu unsuccesfully - the network didnt work at all, then we moved to CentOs 5
3. When we first installed CentOs 5 with standart kernel we had experienced problems with network (IP's aliases just didnt work) then we installed newer kernel and the problem was solved.
first server - SM-XE2, SuperMicro 6014H-82, Dual Xeon 3.4 Ghz, 4GB DDR RAM, 2x72GB U320 SCSI RAID1, Dual Intel PRO1000, 1U
second server - SM-XEW, SuperMicro 6015P-8, Dual Xeon 2.0 Ghz (Woodcrest 5130) , 8GB DDR RAM, 2x73GB U320 SCSI RAID1, Dual Intel PRO1000, 1U
So the question is - what do you think about the problem? Did you use such a system - when a website is on one server and the database on the second? And what was the experience? Could it be kernel problems?
we think that it might be problems with kernel that dont work properly with network, please comment this.
Which Host For Website With MySQL Database
Apr 19, 2008have just had a website created for me where I can store my photos on. It uses JSP + MySQL for the databse which stores the photo IDs, photo location etc. I want to get it up and running on the net but have no idea how to do this!
View 14 Replies View RelatedPlesk 11.x / Linux :: CentOS Backup Commands For Website Files And MySQL Database
May 27, 2014I need a command way of backing up my website files and Mysql databases. I no longer have access to the static ip to access the panel.
View 1 Replies View RelatedPlesk 11.x / Linux :: Website Files Copied To Another Domain But Database Remains On Old Site
May 18, 2014When I use website copy function the website files are copied to another domain but the database remains on old site. I use this function to move the website from devel state to the production state. All sites work fine but when i schedule the backups all databases are saved on old domain. How to move the database on production domain?
View 1 Replies View RelatedDatabase Error
Aug 18, 2007I have a client who moved a site from one linux server to another. This site uses a script with members. The script worked fine on the old server, but on the new one, when members try to update their information, they get this error:
Exchange process unavailable at this time because of database is conducting scheduled task.
Please try back in a few minutes
What can I do to troubleshoot this?