MySQL Stops Allowing External Connections
Apr 3, 2008
Recently I've upgraded my MySQL server. I connect to it via a conection from NIC to NIC (Internal IP addresses). Since the upgrade/format, I've managed to get everything back to the way it was. Everything works fine for 15-20 minutes. Then the PHP server can no longer access the MySQL server.
I tried logging in from the PHP server, I get access denied. I then tried logging in locally, on the MySQL server and I get in fine...
It's not like it's a firewall issue though, it's strange...
I tried updating PHP/MySQL to a few releases, even the RC's to no avail...
Something to note is that when I try restarting MySQL it can take 4-5 minutes, sometimes not even complete.
View 2 Replies
ADVERTISEMENT
Jan 24, 2008
I have a CentOS server running WHM/cPanel and have just had a recent problem pop up:
My SMTP server will only accept connections if the client has their SMTP settings set to use SSL. It won't accept regular, non-SSL connections. Ordinarily I'd welcome the added encryption, however, most of my users who rely on the SMTP server have their mail clients set not to use SSL.
Is this a setting somewhere? If so, can someone direct me as to where it would be, because I've been looking for hours and can't find a thing!
View 1 Replies
View Related
Jan 4, 2008
I have a phpBB forum, which uses MySQl database.
For the last two months the forum has been going down every couple of days because the database service has been continuously stoped running on the server with no reason.
What can cause such a frequent database failures?
Can someone attack the forum/database/server in a way that will cause the above problem?
(there is a good reason I consider this possibility very seriously)
How can I prevent futher database failures?
View 2 Replies
View Related
Mar 29, 2009
I am having a very strange problem with 2 different cPanel accounts on a server with 500-600 accounts. For some reason after a day or two the mysql username/password stops working. We have tried changing the MySQL user and the password with no success. The log does not indicate that the MySQL password was changed in any way. Only these 2 accounts are affected and this problem occurred at least half dozen times each.
Again: these are two different accounts with 2 different MySQL users that after a while stop working (I am unable to determine if they stop working at the same time b/c they belong to different customers). When we reset the user (with the same pass) it works for a day or two. I have checked to connect not only from PHP but also from shell when it's down: it also doesn't work so this is a pure MySQL problem.
Also on the server we have Fantastico.
View 8 Replies
View Related
Dec 5, 2008
Does a external mysql use a lot of bandwidth?
On one of my sites, mysql uses most of the resources of the dedicated server. I'm thinking of putting multiple mysql servers at home and the rest in the data centre. Having mysql servers at home does not require much bandwidth does it? would a dsl line work ok?
View 6 Replies
View Related
Jan 16, 2008
My PHP application is starting to reach max mysql server user connections limit (currently set to 60). I listed mysql process list in phpmyadmin and found there lot of queries with status "LOCKED" these hang there for a long time(not always just sometimes - twice a day) and then connection limit is reached. It causes load average about 40 for as long as 10 - 20 minutes
I think it may be bacause of query structure. There are some queries with many inner joins...
Here is typical situation from phpmyadmin's process list:
1. select ... from table_1
inner join table_2
inner join table_3
inner join table_4
inner join table_5
This show status : "Copying to tmp table" in phpmyadmin
2. update table_2 set ....
This shows status: Locked
3. select ... from table_2
This shows status: Locked
Seems then when temp table is being created the table_2 is locked and it cannot make update to table_2. or maybe it's locked because of just that update on table_2.
I want to avoid of creating temp tables... Can it help if I'll make separate selects without large table joins ?
View 3 Replies
View Related
Jan 7, 2007
I'm currently using MySQL 4.1.12 for Windows 2003, and I need to know how much possible connections can MySQL achieve? I'm currently around 650. I'm having 4 new servers online, and that will bring my total concurrent connections to 1000+.
how high it can go?
View 3 Replies
View Related
May 24, 2007
I notice that most hosting have limit of mySQL connections.
If the max mySQL connections is 50 and I run a forum on this hosting,about how many people can visit my website at one time?
View 3 Replies
View Related
May 11, 2008
how I can do to allow External Access Mysql Database on my server ? What's the procedure ?
View 1 Replies
View Related
Jun 10, 2007
how can I setup under plesk to allow a external server to access the mysql db.
View 7 Replies
View Related
Feb 18, 2007
from what I view, wait_timeout is used for disconnecting connections. However, it applies to tcp/ip connection only. So, in my database connection, if I am using mysql server as localhost, that variable is not applied? In that case, how can I close connections automatically after xxx seconds?
View 8 Replies
View Related
May 13, 2009
i have a small cluster (one web and one db) setup and i host a rather popular group of 4-5 sites that allow users to dynamicly create their own mobile chat communitys automaticly. each site gets its own mysql db created and populated automaticly.
this is all fine,
but in the last 24hours weird things have begun happening, previously i had the sql max_connections set to 500 and this was perfectly adquate for the demand but now even when i set the connection to 4000+ they are all maxxed out within 5-10 minutes, and mysql processlist shows thousands of unauthenticated user connections sitting at login status,
i have gone through the sites and all their mysql configs are fine so i cant see what the issue is.
server specs below
db server:
dual amd opteron 246
8GB ram
120gb hd(64gb free)
33gb swap (rarly used but their for emergencys)
centos 5 64bit.
direct 100mbit lan to web serv
only mysql,ssh and webmin running, no other apps installed
web server:
amd athlon 64 3800+
plesk 9.2.1
4gb ram
2x120gb hds
apache status onthe web server only shows 120ish http connections but the sql keeps climbing
View 8 Replies
View Related
Oct 21, 2009
unfortunately my server crashes a lot recently. What happens is that some application creates a MySQL connection which hangs and then MySQL gets overloaded and takes the whole server down.
My question:
1. How do I configure MySQL to time out even on active connections ? I.e. after 30 seconds kill the process no matter if it is still active or not. Is that possible ?
2. How do I exclude the root user from that?
View 1 Replies
View Related
Dec 17, 2008
This has happened twice now. I have my wait_timeout variable set to 60 seconds, but occasionally my database gets overloaded with "locked" queries. Here's an example of my processlist:
Code:
| 14773848 | db_name | localhost | db_name | Query | 35483 | statistics | SELECT COUNT... |
| 14776290 | db_name | localhost | db_name | Query | 35144 | statistics | SELECT COUNT... |
| 14778877 | db_name | localhost | db_name | Query | 34841 | statistics | SELECT COUNT... |
| 14790744 | db_name | localhost | db_name | Query | 33056 | Locked | UPDATE... |
| 14791275 | db_name | localhost | db_name | Query | 32977 | Locked | SELECT... |
| 14791395 | db_name | localhost | db_name | Query | 32960 | Locked | SELECT... |
| 14791556 | db_name | localhost | db_name | Query | 32929 | Locked | SELECT... |
| 14791603 | db_name | localhost | db_name | Query | 32924 | Locked | SELECT... |
| 14791757 | db_name | localhost | db_name | Query | 32900 | Locked | SELECT... |
| 14792209 | db_name | localhost | db_name | Query | 32815 | Locked | SELECT... |
| 14792355 | db_name | localhost | db_name | Query | 32786 | Locked | SELECT... |
This continues on with locked queries all the way up to my limit of 450 connections, then the whole server goes down. Note the time spent processing these queries, 35483 seconds and counting! Surely the wait_timeout is supposed to prevent this from happening?!
Also, this appears to start with queries in the State "statistics". Then the State for the following queries becomes "locked". Does anyone know what these mean? Can I get them to timeout normally? Queries which never timeout are guaranteed to bring your server down eventually, surely this is not the desired behaviour.
View 4 Replies
View Related
Aug 12, 2008
for a linux web host that has extremely fast mysql connections, 100GB of bandwidth, and the amount of space has to be at least 1GB. Price doesn't really matter.
View 8 Replies
View Related
Jun 22, 2007
how i can limit http and mysql connection limit on per domain basis.
View 2 Replies
View Related
Jul 31, 2007
Is it possible to make Joomla connect to an external mysql database server?
Meaning, the database for Joomla won't be local, but on another server.
Will it work by just entering the mysql hostname, user and password in Joomla's config?
What issues might arose by doing this?
View 3 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 14, 2007
I have 2 servers both have cpanel. I want to use 2nd server's mysql in my site which is on 1st server. I think thats not that hard. I don't wanna do clustering as this is temproary.
View 2 Replies
View Related
Feb 8, 2007
It's possible to allow certain IP ranges to access certain ports by adding to allow_hosts.rules, but is it possible to allow certain domain names?
Eg: I want to allow all users of bell.ca to access port 41125-41130, and block all others from inbound/outbound.
View 2 Replies
View Related
Mar 9, 2009
I'm selling downloads of music files. The zip files are quite large. I've had several people complain that they get a message that the server resets their connection before the download finishes.
What can I do to allow these large downloads?
I'm on IIS.
View 21 Replies
View Related
Mar 24, 2009
I have a very strange problem. Yesterday morning I got a "server down" alert. Restarted httpd and everything run ok ... until today morning, the same problem again.
Symptoms:
1. The webserver did not stop working, it just took too much time to respond.
2. I cannot find anything suspicious in the logs.
3. I started to log the number of apache processes in 4 minutes interval, it did not increase during the failure but remained at a very reasonable number.
4. Now, almost 3 hrs from the last failure, there are 36 apache processes, each eating 14M RAM, server has 4GB ram total, no swapping, almost 3GB are free (cached).
The question is.
How should I prepare for the expected tommorow failure, to be able finaly localise the problem?
View 7 Replies
View Related
Apr 21, 2009
I have 3 servers ServerA(Web, mail), ServerB(MySQL+Master replication), ServerC(Mysqlslave+web)
It happens that my website stops responding for few mins and then it comes back again automatically. I checked the server logs but I couldn't find any suspicious.
Also, while the website is not accessible when I try to connect internally from ServerC to ServerA or ServerB using SSH. It takes lots of time (approx more than 60 seconds) to connect. When website starts working SSH is also working fine.
This is very complicated for me. Can anyone let me know what should be the problem or how can I find root cause of this problem?
View 3 Replies
View Related
May 29, 2008
The problem is that it switches from running to mounted without me having anything to do with it. It seems to be quite randomly, for example this morning at 1.42 am. This happens once a day and stops my vps and therefore my website - which is quite annoying.
I checked for log files or anything, but there was nothing mentioning resources or anything.
Does anyone have a clue what this might be? If I cannot fix the problem there is still the opportunity to just start the vps once it goes to status mounted. How would I automate this?
I am using Virtuozzo and Plesk.
View 9 Replies
View Related
Jun 7, 2007
i have a VPS on which i host one of my Proxy site and nothing else (no databases, no emails, just the usual proxy files needed).
just today it stopped working it is showing the Centos Page .the URL is [url]
here are the steps that i have taken till now without success:
1. restarted the server
2. stopped and restarted some critical services like httpd etc.
3. restarted my free crappy control panel also Ravencore
but all without success
if u feel that u can help me out then can tell u my webmin root password also via PM (u must be a reputed member).
View 9 Replies
View Related
Jun 9, 2008
we've been with Softlayer for a little over a year. The service has been good but their support has been a nightmare for us. There was a time that we were under a dos attack and they refused to do anything about it which is what forced us to switch.
But that's not the reason I'm here. My billing ends on the 12th, their terms require you cancel the server 3 days before billing ends. I pay manually each month by pay pal. I tried to cancel the server today, what I assumed was 3 days before the 12th and they told me I couldn't do it. That I had to pay for another full month. So I told them I just won't pay and they threatened me with a late fee. Is there anything legally these people can actually do to me if I don't pay? All they have is my contact information, I don't think they could submit to collections over that without my social security number.
View 14 Replies
View Related
Dec 7, 2008
I am providing consultancy for a SOHO type of organization - 6-10 employees. The budget is not much for hosting. So we can't go high end. The current hosting company, in a way addresses more than 60% of the needs. However 1 important need is for users to be able to change their password for their email account. The current host says that DirectAdmin and CPanel fall short on this and nothing can be done. Any suggestions for hosts that address this need?
This is what the current package looks like:
* Directadmin control panel
* Apache web server
* Exim smtp server
* PHP5 scripting language
* PHPMyAdmin database control
* Unlimited subdomains
* SSI server side includes
* Centos linux OS
* Great uptime
* Squirrelmail web mail
* MySQL 5 database server
* PERL private CGI-BIN
* Unlimited domain pointers
* Webalizer statistics
* 1,000 megabytes of space
* 5,000 megabytes of transfer
* Unlimited POP3 and FTP
* Unlimited mySQL databases
* Unlimited sub domains
View 8 Replies
View Related
Jul 26, 2008
I ran a shell server on FreeBSD 4.x and was able through (if I recall...) a kernel option to allow users to only see their own processes. For example, if a user ran top it only showed their processes and no others.
I'm racking my brain trying to remember what I did to make that happen and I'm not having much luck with google.
Any other FreeBSD folks here that are familiar with this and care to remind me?
I think it's time I start keeping notes.
View 2 Replies
View Related
