CPanel Remote MySQL
just want to know if you use 2 servers ( A & B ) both with cPanel, suppose that you do use the remote MySQL on server B serving website on server A.
How do we access phpmyadmin? Do you guys experience this?
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Cpanel Mysql Remote Connection USE EXIST DB
A have set up a cpanel with remote mysql server. My demo config: cpanel: centos VPS with cpanel WHM (demo) mysql: debian VPS the configuration is OK, it works. We have got 200 customers, and we will to change to cpanel. The MYSQL server is on a solaris zone. It is possible to make the remote connecting with it. I will import the 200 users MYSQL databases to cpanel, with privileges (user settings). The mail/web dir a will import manuali to cpanel server(copy-paste-setuser:group).
View Replies!
View Related
Remote MYSQL (cPanel) Small Error
I have create a remote mysql database in whm for another server on my network. Now my problem is that the remote mysql in fact works as the data is still being pulled from it with mysql disabled on the main server. I did however put in the root password during the remote mysql server setup. Now the only problem I seem to be having is the databases dont show up in any cpanel accounts and phpmyadmin doesnt work. but all sites using a database made before this change still work.
View Replies!
View Related
Allow Remote Mysql Access
I have a Ubuntu Lamp server setup in my building which is used for development purposes. So I also have phpmyadmin setup and am using a Mysql Query browser and Mysql Administrator desktop programs to administor the database on the server. However I am not able to connect to the server from my desktop. I am able to login to my myphpadmin but not able to login via the Mysql Query Browser program. Hopwing someone can help. I have read about port forwarding and also read a post about editing the my.cnf file on the server and changing the Bind-Address= 127.0.0.1 to the actual hostname but before I start editing the actual configuration files on the server I want to see if their is another way as I am worried that if I change the me.conf file that the phpmyadmin may stop working?
View Replies!
View Related
Remote MySQL 5.0 Hosting
I'm running a VPS at TekTonic.net and so far I have only one problem. I love TekTonic's services in general, but for some crazy reason, I can't get my MySQL server to work. I've asked MySQL's support staff, and they haven't found an answer to date. I can do just about anything on my MySQL server EXCEPT add/remove a database, which creates a problem. A BIG problem. what I'm looking for now is a remote MySQL host that will accept connections from my TekTonic-hosted VPS.
View Replies!
View Related
Connecting To Remote MySQL Failing
I'm facing some odd issues with 2 servers located in the same datacenter. One server is the HTTP server, and every 5 minutes it works, then for 5 minutes Server One and Server Two (MySQL) hate each other and refuse to talk to each other. Not only can neither not connect to each others MySQL, but also neither can ping each other. The odd thing is, Server Three can however connect to the Server Two MySQL with no problems during this period. It seems to be just the communication between Server One and Server Two that keeps getting halted. I've tried "service iptables stop" to disable the firewall, and changing SELinux to disabled, but neither have fixed it.
View Replies!
View Related
Host For Remote MySQL Connection
I have developed a desktop system that uses MySQL data. I want to use a host to access the data but my current provider only allows access to MySQL data via a web server. Can anyone suggest a host that would provide direct connection to a MySQL database?
View Replies!
View Related
Remote Dedicated Mysql Server
i am getting mysql down issues with my current dedicated server. I would like to move my database to a dedicated server where only mysql will be running. Just wondering if this will be faster than the localhost? I have planned to buy dedicated server from another hosting company so definitely there will be a good enough connectivity distance.
View Replies!
View Related
Move Mysql Db From Remote Server
how can i move mysql db from remote server ? (via SSH or most pratical way) suppose that... source server domain : google.com host : localhost user : zode pass : 123 db : source destination server domain : yahoo.com host : localhost user : hala pass : 456 db: target
View Replies!
View Related
Remote Mysql Server In WHM
I see option to setup remote Mysql server in WHTM but wonder can i connect 2 servers through private network then fill in Remote server address something like 192.168.1.2. If it is possible it would save me a lot of bandwidth for both servers.
View Replies!
View Related
DDos And Remote Mysql Server Two
i have two server one for running apache and second is sql server.Now come to problem. I have a very strange type of ddos attacks on my httpd server and due to these attacks my apche server failed many times (10 to 15 times)in a day. When i checked max http connection use by a single ip then i am surprised to see that my remote sql server ip is using maximum of http connections and behind this there is some other ips whose doing the same. I installed media layer it seems to work fine for me but suddenly he blocked my remote sql server ip due to using maximum http connection lolz its very strange any body please help me out of this problem.
View Replies!
View Related
Users Cannot Connect To Remote MySQL Server
I have a few users that have a hosting account with me and are trying to connect to their own MySQL servers elsewhere. Both said that they are able to connect to the MySQL server with other hosting accounts but not the ones hosted with me. I asked if they had setup permissions to allow remote connections from my server and they confirmed that they did. What am I missing? Do I need to configure my firewall somehow? I figured the connection is just using port 80 since it's from an PHP script right?
View Replies!
View Related
Connect To Mysql From Many Remote Virtual Hosts
I have a set up where server 1 holds a mysql DB and a virtual host. server 2 holds many virtual hosts in apache (16) connecting to this DB. The virtual hosts all hold the same script, but the single VH on server 1 receives about the same amount of visits as all the VHs of server 2. server 1 is very busy at times, like 100% CPU and a load around 10 for long period of times. server 2 is not very busy, around 30% CPU usage and 0.6 CPU load. Yet, users on server 2 experience *much slower* response times than the ones on server 1. The obvious reason could be the network between the two, but I'm not convinced (6 seconds for a query run from server 2 when it brings back 1 row and takes 0.01 second from server 1). I was wondering what other reasons it could be. The mysql processlist is weird: Code: mysql> show processlist; +-------+----------+---------------+----------+---------+------+--------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +-------+----------+---------------+----------+---------+------+--------------------+------------------------------------------------------------------------------------------------------+ | 81817 | mysite | localhost | mysite | Sleep | 865 | | NULL | | 94992 | mysite | server2:47927 | mysite | Sleep | 188 | | NULL | | 96890 | mysite | server2:50881 | mysite | Sleep | 26 | | NULL | | 97213 | mysite | server2:51010 | mysite | Sleep | 22 | | NULL | | 97391 | mysite | server2:51085 | mysite | Sleep | 36 | | NULL | | 97919 | mysite | server2:51300 | mysite | Sleep | 49 | | NULL | | 97927 | mysite | server2:51306 | NULL | Sleep | 49 | | NULL | | 97933 | mysite | server2:51282 | mysite | Sleep | 48 | | NULL | 97933 | mysite | server2:51282 | mysite | Sleep | 48 | | NULL | | 97958 | mysite | server2:51321 | mysite | Sleep | 26 | | NULL | | 97961 | mysite | server2:51323 | mysite | Sleep | 46 | | NULL | | 98104 | mysite | server2:51344 | mysite | Sleep | 39 | | NULL | | 98169 | mysite | server2:51376 | NULL | Sleep | 36 | | NULL | | 98177 | mysite | server2:51388 | mysite | Sleep | 9 | | NULL | | 98365 | mysite | server2:51461 | mysite | Sleep | 26 | | NULL | | 98377 | mysite | server2:51427 | mysite | Sleep | 26 | | NULL | | 98380 | mysite | server2:51468 | mysite | Sleep | 6 | | NULL | | 98394 | mysite | server2:51474 | mysite | Sleep | 26 | | NULL | | 98404 | mysite | server2:51479 | mysite | Sleep | 26 | | NULL | | 98418 | mysite | server2:51486 | mysite | Sleep | 26 | | NULL | | 98419 | mysite | server2:51487 | mysite | Sleep | 26 | | NULL | | 98429 | mysite | server2:51496 | mysite | Sleep | 2 | | NULL | | 98503 | mysite | server2:51520 | mysite | Sleep | 22 | | NULL | | 98512 | mysite | server2:51524 | mysite | Sleep | 22 | | NULL | | 98514 | mysite | server2:51525 | mysite | Sleep | 20 | | NULL | | 98519 | mysite | server2:51526 | mysite | Sleep | 22 | | NULL | | 98557 | mysite | server2:51514 | mysite | Sleep | 21 | | NULL | | 98568 | mysite | server2:51548 | mysite | Sleep | 20 | | NULL | | 98581 | mysite | server2:51557 | mysite | Sleep | 5 | | NULL | | 98617 | mysite | server2:51572 | mysite | Sleep | 18 | | NULL | | 98620 | mysite | server2:51574 | NULL | Sleep | 18 | | NULL | | 98630 | mysite | server2:51577 | mysite | Sleep | 17 | | NULL | | 98644 | mysite | server2:51584 | mysite | Sleep | 17 | | NULL | | 98681 | mysite | server2:51601 | mysite | Sleep | 15 | | NULL | | 98698 | mysite | server2:51604 | mysite | Sleep | 14 | | NULL | | 98704 | mysite | server2:51606 | mysite | Sleep | 14 | | NULL | | 98714 | mysite | server2:51610 | NULL | Sleep | 14 | | NULL | | 98736 | mysite | server2:51619 | NULL | Sleep | 13 | | NULL | | 98748 | mysite | server2:51626 | NULL | Sleep | 12 | | NULL | | 98753 | mysite | server2:51628 | mysite | Sleep | 12 | | NULL | | 98785 | mysite | server2:51635 | mysite | Sleep | 11 | | NULL | | 98820 | mysite | server2:51654 | mysite | Sleep | 10 | | NULL | | 98821 | mysite | server2:51655 | mysite | Sleep | 10 | | NULL | | 98822 | mysite | server2:51656 | mysite | Sleep | 10 | | NULL | | 98823 | mysite | server2:51657 | mysite | Sleep | 10 | | NULL | | 98836 | mysite | server2:51660 | mysite | Sleep | 9 | | NULL | | 98840 | mysite | server2:51662 | NULL | Sleep | 9 | | NULL | | 98841 | mysite | localhost | NULL | Query | 0 | NULL | show processlist | | 98901 | mysite | server2:51680 | mysite | Sleep | 6 | | NULL | | 98903 | mysite | server2:51651 | mysite | Sleep | 7 | | NULL | | 98920 | mysite | server2:51684 | mysite | Sleep | 6 | | NULL | | 98947 | mysite | localhost | mysite | Sleep | 1 | | NULL | | 98954 | mysite | server2:51696 | mysite | Sleep | 5 | | NULL | | 99024 | mysite | server2:51710 | mysite | Sleep | 1 | | NULL | | 99031 | mysite | server2:51712 | mysite | Sleep | 2 | | NULL | | 99032 | mysite | server2:51686 | mysite | Sleep | 2 | | NULL | | 99041 | mysite | server2:51694 | mysite | Sleep | 2 | | NULL | | 99049 | mysite | server2:51717 | mysite | Sleep | 2 | | NULL | | 99058 | mysite | server2:51720 | mysite | Sleep | 1 | | NULL | | 99063 | mysite | server2:51685 | mysite | Sleep | 1 | | NULL | | 99064 | mysite | server2:51722 | mysite | Sleep | 2 | | NULL | | 99073 | mysite | localhost | mysite | Sleep | 1 | | NULL | | 99075 | mysite | server2:51724 | mysite | Sleep | 1 | | NULL | | 99086 | mysite | localhost | mysite | Query | 1 | Creating tmp table | SELECT DISTINCT * | | 99089 | mysite | localhost | mysite | Sleep | 1 | | NULL | +-------+----------+---------------+----------+---------+------+----------- Why so many sleeping processes from server 2, and none or almost none from server 1 ? Is it normal that every query from server 2 is open on a different port ? Should they be grouped by virtual host, or is there one different port for each script running concurrently? What could be a reason for server 2 having problems to open connections on server 1, and how to solve it? Right now I'm about to deport more users from server 1 to new virtual hosts on server 2, hoping it will lower the load on the first machine and overall accelerate the response times. I just thought I'd post here first because this all seems very weird to me and i thought someone with an external look might tell me what I'm doing wrong. And also if network would be the problem maybe that's not the clever thing to do to make more users remote.
View Replies!
View Related
CPanel Remote Backups
We all know about backups, and compressing files, etc etc... so, what do you guys do in this situation? I have a quad core, 4gb ram, 250gb disk, when I run cpanel backups to my remote server, the server loads go up to 3. Is there any way I can control this and lets say... dont let it go bellow 2? Improved Backup Performance — Speed is safe. cPanel’s backup facilities in 11.24 have seen significant speed increases. In previous versions, load averages while backups were running could be as high as 3. With our reworked and enhanced backup system, load averages tend to stay around 1.2 when backups run on servers with many accounts. This is an extremely substantial performance increase that you and your customers will notice right away. With our new backup system, there is no reason not to keep your data safe."
View Replies!
View Related
Remote CPanel Backup
What's the best way to do a remote backup? Right now I have them all being backed up to a 2nd drive on the server. If I do a remote backup, is it just as easy to access the files and do a restore?
View Replies!
View Related
MySQL Remote Connection Problem After A Heavy Usage
I have 2 identical Fedora8 boxes with Apache 2.2.8, MySQL 5.0.45 and PhP 5.2.4. I use one as the Web+DB server (say box A), and the other (box B) just as the Web server connecting to the DB server on box A. I use this 2 machine configuration to test a LAMP based-Web application. I have a client program on other machines that can emulate a massive web workload to these 2 servers; it can emulate hundreds to thousands of users using the application simultaneously. Before running the test, the connection to the DB server from both boxes seem fine. Using the mysql client program on either box A or B trying to connect to the DB, the connection goes through instantly. In the /etc/my.cnf file, I have max_connections=4096 and max_user_connections=4096. Note that the web app uses one single db user to connect to the db. To allow remote connection, I inserted one record into the user table of the mysql db whose the host field's value is '%' (allow connection from all remote hosts). After running the test (which I found out that many requests sent to box B failed), mysql client program on box A is still able to connect to the db instantly; but the one on box B has a problem: it takes extremely long (5 - 10 minutes or even more) to establish the connection, it doesn't time out, just takes that long. I believe that's the cause for the failure of requests to box B.
View Replies!
View Related
Backing Up Cpanel With Remote Ftp?
I need to have a windows PC on my internal network connect via sftp and download the generated backups on my webserver. What files do I need? I'd like to do it on a daily basis as I run local tape backups every night. My backups are being put into /backup/cpbackup/daily/ but there is a tarball, dirs/, and files/. Do I just need to download the tarball? I was hoping to do this with psftp and the windows task manager so that I wouldn't have to do it manually every day.
View Replies!
View Related
Remote Cpanel Server Backup
i run cpanel on centos, and i backup all websites and system setting to the 2nd hd by whm's backup feature everyday, i want to ask if any script or method i can backup all the files to another server in a period of time, it may be a week or 3 three days...etc,
View Replies!
View Related
PhpMyAdmin, CPanel And Remote Database
I've just purchased a second server of which I wish to use a database server for a number of my databases and I'd like manage it remotely (from the web server) via phpmyadmin. I've configured my firewall and granted access to the web server on root@webserverip and also username@webserverip (username being just one of the database accounts I wish to grant access in order to test this). Accessing mysql remotely from the webserver now works on both accounts (via ssh and php). However, having configured the phpmyadmin config file to include the ip (network ip) of the 2nd server I am unable to see the 2nd server when logged in to phpmyadmin. I just have the usual root@localhost and username@localhost.
View Replies!
View Related
Incremental Backup Of CPanel Accounts To A Remote Server
I want to back-up accounts managed by cPanel/WebHostManager to a remote server. I want to be able to restore to any of the last 7 days. I believe doing an incremental back-up each night can accomplish this best, saving both bandwidth and disk space on the remote server. Using the back-up functionality built into WHM is appealing because WHM knows what files need to be backed up to do a full restore. However, WHM can't do exactly what I'm looking for either. I've been looking into using rsync as described in this document: [url] It looks becaue of the "hard link" capabilities of linux, rsync can be used to create what functions like a full back-up every night but requires a full backup the first day and then each day after that only the incremental changes have to be transfered. However, because I don't know what directories need to be backed up, I'm not sure how to implement an rsyc solution either. (BTW, I want to back-up everything necessary to be able to restore each account except the log files. So, that means MySQL, mail, config info, and whatever the user has uploaded)
View Replies!
View Related
Mass Backup Accounts To Remote FTP With ROOT Access And CPanel/WH
I have a VPS and about 140 accounts on it. I've also got cPanel and WHM installed. I'm moving to a new host, but the thought of having to move all these accounts manually really makes me lazy I have to go into each account and go to backup -> backup to remote FTP, and yeah.. Is there any way I can mass backup all of my accounts, or all accounts I select, to a specified FTP server? I only have root access on my VPS, but not on the server I'm moving all the backups to..
View Replies!
View Related
Mysql/cpanel
I accidentally clicked upgrade to 5.0 from 4.1 in Cpanel. Then I ran the update to latest version. EVERYTHING BROKE! Sites can't connect to mysql anymore, and also during the update, I'm getting: Code: md5sum mismatch (actual: 1f32cbcf13cce797cdc2a5c9553b5c35) (expected: 5a4c0dd1d71417a6d07452bb47d1259e) Download Failed... trying again...in....60....59....58....57....56....55....54....53....52....51....50....49....48....47....46....45....44....43....42....41....40....39....38....37....36....35....34....33....32....31....30....29....28....27....26....25....24....23....22....21....20....19....18....17....16....15....14....13....12....11....10....9....8....7....6....5....4....3....2....1..Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/cgi-sys/formmail.cgi (0)....@74.200.65.162......connected......receiving...1%...2%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%...32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...60%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done md5sum mismatch (actual: 1f32cbcf13cce797cdc2a5c9553b5c35) (expected: 5a4c0dd1d71417a6d07452bb47d1259e) ...skipping 74.200.65.162...Download Failed... trying again...in....60....59....58....57....56....55....54....53....52....51....50....49....48....47....46....45....44....43....42....41....40....39....38....37....36....35....34....33....32....31....30....29....28....27....26....25....24....23....22....21....20....19....18....17....16....15....14....13....12....11....10....9....8....7....6....5....4....3....2....1..Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/cgi-sys/formmail.cgi (0)....@75.126.236.226......connected......receiving...1%...2%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%...32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...60%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done md5sum mismatch (actual: 1f32cbcf13cce797cdc2a5c9553b5c35) (expected: 5a4c0dd1d71417a6d07452bb47d1259e) Download Failed... trying again...in....60....59....58....57....56....55....54....53....52....51....50....49....48....47....46....45....44....43....42....41....40....39....38....37....36....35....34....33....32....31....30....29....28....27....26....25....24....23....22....21....20....19....18....17....16....15....14....13....12....11....10....9....8....7....6....5....4....3....2....1..Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/cgi-sys/formmail.cgi (0)....@75.126.236.226......connected......receiving...1%...2%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%...32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...60%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done md5sum mismatch (actual: 1f32cbcf13cce797cdc2a5c9553b5c35) (expected: 5a4c0dd1d71417a6d07452bb47d1259e) Download Failed... trying again...in....60....59....58....57....56....55....54....53....52....51....50....49....48....47....46....45....44....43....42....41....40....39....38....37....36....35....34....33....32....31....30....29....28....27....26....25....24....23....22....21....20....19....18....17....16....15....14....13....12....11....10....9....8....7....6....5....4....3....2....1..Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/cgi-sys/formmail.cgi (0)....@75.126.236.226......connected......receiving...1%...2%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%...32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...60%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done md5sum mismatch (actual: 1f32cbcf13cce797cdc2a5c9553b5c35) (expected: 5a4c0dd1d71417a6d07452bb47d1259e) ...skipping 75.126.236.226...Download Failed... trying again...in....60....59....58....57....56....55....54....53....52....51....50....49....48....47....46....45....44....43....42....41....40....39....38....37....36....35....34....33....32....31....30....29....28....27....26....25....24....23....22....21....20....19....18....17....16....15....14....13....12....11....10....9....8....7....6....5....4....3....2....1..Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/cgi-sys/formmail.cgi (0)....@69.90.250.34......connected......receiving...1%...2%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%...32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...60%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done md5sum mismatch (actual: 1f32cbcf13cce797cdc2a5c9553b5c35) (expected: 5a4c0dd1d71417a6d07452bb47d1259e) Download Failed... trying again...in....60....59....58....57....56....55....54....53....52....51....50....49....48....47....46....45....44....43....42....41....40....39....38....37....36....35....34....33....32....31....30....29....28....27....26....25....24....23....22....21....20....19....18....17....16....15....14....13....12....11....10....9....8....7....6....5....4....3....2....1..Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/cgi-sys/formmail.cgi (0)....@69.90.250.34......connected......receiving...1%...2%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%...32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...60%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done md5sum mismatch (actual: 1f32cbcf13cce797cdc2a5c9553b5c35) (expected: 5a4c0dd1d71417a6d07452bb47d1259e) Download Failed... trying again...in....60....59....58....57....56....55....54....53....52....51....50....49....48....47....46....45....44....43....42....41....40....39....38....37....36....35....34....33....32....31....30....29....28....27....26....25....24....23....22....21....20....19....18....17....16....15....14....13....12....11....10....9....8....7....6....5....4....3....2....1..Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/cgi-sys/formmail.cgi (0)....@69.90.250.34......connected......receiving...1%...2%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%...32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...60%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done md5sum mismatch (actual: 1f32cbcf13cce797cdc2a5c9553b5c35) (expected: 5a4c0dd1d71417a6d07452bb47d1259e)
View Replies!
View Related
Copying Mysql Db In Cpanel
is there a way to copy mysql from an existing db, and then renaming it to another name? I would like to copy my current db from a live forum site, and because I got a test forum but I need that test forum to use my current live db...but i want it to use a copy of the live db. The db has to be a different name for the test site. Sorry hard for me to explain. Is there an easy way to do that? I would do it via cpanel backup and upload but the db is 2gb's gzip.... I can do it via ssh or whm as well.
View Replies!
View Related
CPanel MySQL/Clamav
A few weeks ago I installed clamav using the cPanel "Manage Plug-Ins". It all seemed fine but my server load kept going ridiculously high. I couldn't work out what was wrong until I managed to get a ps aux when it was very high and found that clamd was using ridiculous amounts of memory/cpu. It's not such a big deal having it on my server, so I decide to uninstall it. After uninstalling it, MySQL started to randomly turn off regularly (around every 30 minutes). I tried forcing a cPanel update, updating the MySQL files, reinstalling MySQL, etc. but nothing has seemed to fix it. So as a last resort, I've reinstalled Clamav and now my MySQL is fine but my server load keeps going ridiculously high again; causing problems still. Has anyone/cPanel ever experienced this problem? I need to find a solution as almost every account on my server uses MySQL as a basis for their website, so I can't have it going down even for less than a minute.
View Replies!
View Related
Upgrading To MySQL 5 On CPanel
I would like to start offering MySQL 5 on all my shared hosting accounts, seeing how it's an increasingly requested feature. However, by my understanding most applications still require MySQL 4 to operate (am particularly concerned with those bundled with Fantastico). I would like my current clients to be able to continue working with these older apps using MySQL 4 while allowing new clients to make use of the latest features available with MySQL 5. I would like to get people's opinions as to what the best approach would be here. Should I upgrade directly to MySQL 5, offer both versions 4 and 5 simultaneously, or just stick to version 4 until version 5 is better supported? If I choose to install both versions in parallel, is this an easily supported option with CPanel/WHM? Will the configuration change break anything for clients already using applications with MySQL 4?
View Replies!
View Related
MySQL Keeps Down (Cpanel Server)
I have a Cpanel server with a problem: SQL keeps failing Everytime I try to restart MySQL via WHM, it gives me: /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! mysql has failed, please contact the sysadmin (result was "mysql has failed"). I can only restart it successfully after 2nd attempt. Server load is always low. Memory usage is also low. It happens in very short interval (in less than every 1-10 minutes) It never happens until recently when my server management company tweak something I didn't know. They said fixed it and then it happens again every minutes. I have 9 servers and it never happens to the rest 8 servers. Just this server always happening.
View Replies!
View Related
Backup In CPanel/WHM Without Mysql
The automatic backups you can setup in cpanel/whm bundle the entire user account. Is it possible for it to save everything except the mysql databases? I have an account that has databases over 5GB+ and would like to handle backing those up separately.
View Replies!
View Related
[Cpanel::Mysql]: Not Updating Privileges
On a cPanel server, running RHEL 4 I got the following error (from cpanel logs) while associating an user with a DB from the cPanel admin: Fri Apr 11 17:02:47 2008 info [Cpanel::Mysql]: Not updating privileges for user (reseller login and no password specified in ~/.my.cnf) at /usr/local/cpanel/Cpanel/Mysql.pm line 268 Cpanel::Mysql::updateprivs('Cpanel::Mysql=HASH(0xa4a8768)') called at /usr/local/cpanel/bin/mysqladmin line 88 Fri Apr 11 17:02:47 2008 info [Cpanel::Mysql]: Not updating privileges for user (reseller login and no password specified in ~/.my.cnf) at /usr/local/cpanel/Cpanel/Mysql.pm line 268 In fact, from cPanel interface all privileges are added OK, but the MySQL itself is not connecting at all due to this error. I already tried: /scripts/mysqlup --force /scripts/upcp --force /usr/bin/mysql_fix_privilege_tables -u root --password=PASSWORD
View Replies!
View Related
Corrupted MySQL Backups CPanel
Just a warning to all other hosts out there using cPanel it currently generates corrupted mysql backups due to a bug in their pkgacct script which has been like this for over 6 days now. [url] So for anyone out there it's an easy fix. Of course not every host is doing it so the fun of helping a customer migrate data and explain to them that their hosts backups being made are all corrupted is lots of fun. Sort of sad but I've been told this isn't a critical enough issue to even push it out to all versions. Right now it makes a great lock in so customers cannot switch providers without a lot more work.
View Replies!
View Related
CPanel Just Setup, Doesn't Want To Update Mysql
I finally broke down and just got a cPanel license to fix my multiple account problems, and had it installed... But now I have a problem that I can't seem to fix - MySql won't update to 4.1.21, its stuck at 4.1.18 which means I can't use PHP 5+... I can't update to MySQL 5.0+ because my databases (Which I have yet to move over) are 4.1 and should probably stay 4.1 until I know for sure it won't break anything. Does anyone know whats going on and how I can fix this? I've tried "/scripts/mysqlup" and "/scripts/upcp --force", as well as Apache update in WHM, and manual cPanel update in WHM. Heres what it says when I use mysqlup: Quote: MySQL Setup Script Version 7.0 This is the MySQL installer for OS FreeBSD mysql-client-4.1 (4.1.18_1) is already installed. mysql-server-4.1 (4.1.18_2) is already installed. Install Complete
View Replies!
View Related
CPanel DNS Only, Now Cant Install PHP, MySQL Etc
i am running a VPS and recently installed cPanel DNS Only so it can operate as a standalone DNS server. I would also like to serve standard webpages on it via apache and php, i therefore tired to install php, mysql etc via 'yum install php' but it says there is no package to be installed. Has the cPanel DNS only install done someting to the yum config? I have installed Yum Priorities plugin, and my repos files are as follows: Code: root@stripe [~]# yum list installed | grep httpd httpd.i386 2.2.3-22.el5.centos.1 installed root@stripe [~]# yum list installed | grep php* root@stripe [~]# cat /etc/yum.repos.d/CentOS-Base.repo # CentOS-Base.repo # # This file uses a new mirrorlist system developed by Lance Davis for CentOS. # The mirror system uses the connecting IP address of the client and the # update status of each mirror to pick mirrors that are updated to and # geographically close to the client. You should use this for CentOS updates # unless you are manually picking other mirrors. # # If the mirrorlist= does not work for you, as a fall back you can try the # remarked out baseurl= line instead. # # [base] name=CentOS-$releasever - Base mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=os #baseurl=http://mirror.centos.org/centos/$releasever/os/$basearch/ gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-5 priority=1 #released updates [updates] name=CentOS-$releasever - Updates mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=updates #baseurl=http://mirror.centos.org/centos/$releasever/updates/$basearch/ gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-5 priority=1 #packages used/produced in the build but not released [addons] name=CentOS-$releasever - Addons mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=addons #baseurl=http://mirror.centos.org/centos/$releasever/addons/$basearch/ gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-5 priority=1
View Replies!
View Related
Mysql Character Set / Collation (Cpanel)
dedicated server with FreeBSD + Cpanel. After the installation, one problem is that Mysql doesn't have some international character sets /collation included such as Big5, gbk, ujis which are mostly for Asian language.Is this normal for Cpanel installation? I got a response from Cpanel stating this is a default setting for Mysql. Because we have lots Asian customers, it there any way can include new international character set /collation without reinstalling Cpanel?
View Replies!
View Related
Mysql User Privilege Changed By Cpanel Or What
I am using Cpanel. One Cpanel account is backup. I use it to backup my database. Under mysql, I gave this account ( backup ) many priviledges. But when the backup script ran, error said that backup account can not 'lock table'. I gave "lock table' priviledge again and run the script, it is ok. But after a while, when the script ran autmatically on daily basis, it lost the 'lock table' priviledge again. I wonder if Cpanel is messing me up? What can I do about it? anyone knows?
View Replies!
View Related
Mysql Character Set / Collation Problem (Cpanel)
We just had a new dedicated server with FreeBSD + Cpanel. After the installation, one problem is that Mysql doesn't have some international character sets /collation included such as Big5, gbk, ujis which are mostly for Asian language. Is this normal for Cpanel installation? I got a response from Cpanel stating this is a default setting for Mysql. Because we have lots Asian customers, it there any way can include new international character set /collation without reinstalling Cpanel?
View Replies!
View Related
Script (php / MySQL) Friendly Hoster That Uses Cpanel
I suspect people asking about tips on good hosters all the time here, and I'm no different. But I can start off with the basic req. that might narrow it a tad atleast. - - - - - - - 1 : Cpanel; w.cpanel.net en.wikipedia.org/wiki/CPanel This is the first basic req. I have. I myself are not the most skilled coder in the world, nor is the others around me and we like Cpanel since it "saves" us from confusion very often. - - - - - - - 2 : Script php / mySQL friendly; We use CMS scripts (MXP, Joomla, e107, etc) for our communities and forum scripts (phpbb, vBulletin, etc) at all times. So a good loading time is a must, nothing is as devestating for a communitie than a slooow forum. - - - - - - - 3 : And the regular ; BIG and cheap. We just doing noncommercial / fun / silly projects / communities so it needs to be cheap and with a good size. Have some photographers + communities with albums and that eats up a good chunk of webspace after awhile. - - - - - - - - We greatly appriciate any tips on hosters that covers this. Support don't have to superfast, we pretty relaxed when it comes to that, but the other reqs. is needed. If you know or even better USE a hoster like this please let us know. We badly need one at the moment. We would be very happy if you could post or PM us a link/s to your or other sites you know of that is active and uses scripts like; CMS systems Forum Photoalbums So we can check the loadingtime over here in Sweden.
View Replies!
View Related
MySQL Optimization, Intel E8300, 8Gb RAM, CPanel
I'm trying to optimize a server (Intel E8300) with 8Gb of RAM and WHM/cPanel administration panel. Now the server has only 46 accounts in WHM, and about 10.000 unique visitors / day As mysql is always on top for CPU ussage I have edited 2 values in my.cnf, but this was done in 10 minutes and not to much research, any more help will be appreciated. On this server as I see it's been using MyISAM for storage engine and maybe just a few tabels with InnoDB ....
View Replies!
View Related
|
TRACKER
