Web Hosting :: MySQL Stops Allowing External Connections

SMTP Only Allowing Connections Via SSL
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 Replies! View Related

MySQL Database Service Stops From Running
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 Replies! View Related

Weird MySQL: User/pass Stops Working After A While
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 Replies! View Related

Does A External Mysql Use A Lot Of Bandwidth?
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 Replies! View Related

Allow External To Access Mysql Server
how I can do to allow External Access Mysql Database on my server ? What's the procedure ?

View Replies! View Related

Allow External Access To The Mysql Db Under Plesk
how can I setup under plesk to allow a external server to access the mysql db.

View Replies! View Related

Is It Possible To Make Joomla Connect To An External Mysql Database Server
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 Replies! View Related

MySQL Connections
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 Replies! View Related

MySQL Max Connections
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 Replies! View Related

MySQL Max- Connections
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 Replies! View Related

Closing Mysql Connections
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 Replies! View Related

Mysql Connections Topping Out Within Seconds
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 Replies! View Related

MySQL Timeout On Active Connections
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 Replies! View Related

Best Host For Fast MySQL Connections
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 Replies! View Related

How To Limit Http/mysql Connections Per Domain
how i can limit http and mysql connection limit on per domain basis.

View Replies! View Related

How To Use External CPanel Mysql In Another CPanel Server
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 Replies! View Related

Apache Stops Responding
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 Replies! View Related

Website Stops Responding
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 Replies! View Related

VPS Stops Running Randomly
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 Replies! View Related

Mod_perl Stops Working When I Use RewriteEngine On
I have an account on my cPanel server with a cgi script in it wich works just fine under normal circumstances. I setup mod_perl and got it working just fine with the script. I edited the .htaccess file to do a 301 redirect and added the line “RewriteEngine on” and then whenever I try to access the cgi script I get:

Quote:

Forbidden
You don't have permission to access………..

If I disable mod_perl or remove the line “RewriteEngine on” from .htaccess it works fine.

In the cPanel error log I have:

Quote:

Options FollowSymLinks or SymLinksIfOwnerMatch is off which implies that RewriteRule directive is forbidden

But in htaccess I already have the line "Options +FollowSymLinks" which is part of the 301 redirect code.

View Replies! View Related

VPS Suddenly Stops Working
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 Replies! View Related

Attempt To Install RoR, Libsafe Stops Me
whenever I attempt to install RoR, libsafe stops me, how do I diable libsafe so I can install RoR, then re-enable libsafe.

[root@server1 ~]# gem install rails --include-dependencies
Libsafe version 2.0.16
Detected an attempt to write across stack boundary.

Terminating /usr/bin/ruby-bin.
uid=0 euid=0 pid=20960
Call stack:
0x4c0e6871 /lib/libsafe.so.2.0.16
0x4c0e6c5d /lib/libsafe.so.2.0.16
0x80549b8 /usr/bin/ruby-bin
0x8054a52 /usr/bin/ruby-bin
0x80556af /usr/bin/ruby-bin .....

View Replies! View Related

If Your Phpmyadmin Stops Working Under Cpanel, Read This
Many, many people seem to be having the 2002 error over the past 24 hours on phpmyadmin with cpanel

Doing this edit to the config got it going for me:
[url]

View Replies! View Related

Allowing Large Downloads
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 Replies! View Related

APF: Allowing By Hostnames
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 Replies! View Related

Softlayer Not Allowing Us To Cancel Server
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 Replies! View Related

Allowing Users To Change Their Passwrods Themselves
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 Replies! View Related

Allowing Users To See Only Their Own Processes In FreeBSD
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 Replies! View Related

Looking For Canadian Hosting Allowing Adult Sites
I am looking for a Canadian host who necessarily have their servers in Canada who offer dedicated hosting and who hosts adult sites. I don't have anything particular specifications as of now since my sites are overall small (1k/day).

View Replies! View Related

Cpanel Main Domain Not Allowing Subdomains
When trying to make a subdomain on my main cpanel domain, through cpanel, it acts like it is making it, and adds the dns entry, but it does not work. All other domains work fine.

I submitted a ticket to buycpanel, they asked for the login information this morning, and have not heard back from them. This has happened every since they installed cpanel.

I am hoping its something simple that one of you knowledgeable people may know how to fix.

View Replies! View Related

Cpanel Not Allowing Access To User Accounts
On a new server we have running CPanel, we have manually created a user account and when i try and log into mydomain.com/whm with that username/password it doesn't let me.

Now my second thought is that I should be logging into mydomain.com/cpanel rather than mydomain.com/whm but I get a 404 for /cpanel.

If i'm logged in as root, i cannot transfer into the user account cpanel either...

View Replies! View Related

VPS Hosts Allowing Unlimited Email Sending
I am looking for a VPS hosting company that basically allows unlimited email sending without restrictions. Does it necessarily have to be off-shore?

I will be sending about 300k per day, or somewhere in that neighborhood.

The bandwidth and storage I am not too concerned about.

View Replies! View Related

Allowing Whm Installed And Use In Share Hosting Account
This is one of my thoughts and a valid one based on my own experience.

One of the problems with shared hosting account that comes with multiple domain/web hosting, is that all the hosted domains shared one single cpanel and one root directory where all the addon domains directories and files are all jammed up together with the maindomain's directories and files.

Notably is some php scripted sites running on addon domains were unable to function effectively. One such example is using imagevue - a photo slideshow/gallery script. The problem of no photos or photos unable to load/show when the site is called directly from the addon domain [url]

However, when accessed through the maindomain [url] it has no such problem and the photos showed up.

With the above incident and having tried on three other different webhosts, it's clear that something has to be done or otherwise, having multiple domain hosting has no real benefits if you consider the above matters.

As such, the only solution I can think of is to install whm on our shared hosting account so that we can have each added domain to have its own independent cpanel.
So long as we are not doing any reselling activities, there is no reason for the webhost to object or refused.

If your webhost is genuinely care about you and truly to provide an enhanced and efficient webhosting experience, then whm is one way to overcome any shortcomings from existing facility of using a single cpanel for all your multiple addon domains.

Of course, another alternative is to use subdomains from the main domain and redirect all your addon domain sites to the subdomains. That would really defeat the purpose of having addon domains in the first place. Also, why should we? since the hosting account is for multiple domain hosting.

Webhosts offering so-called unlimited domain hosting or limited multiple domain hosting on a single cpanel, should review the existing known issues such as the one mentioned above, and consider using whm to overcome such issues, thus truly provide a pleasant and effective multiple domain web hosting experience to its customers.

Webhosts should tweak and enhance its existing features/softwares/hardwares to improve the overall webhosting services.

View Replies! View Related

CPanel Allowing / Disallows SSL Access On Subdomain
I am going to buy a godaddy wildcard subdomain SSL certificate. Basically I want the ability to enable and disable ssl on certain subdomains from cpanel. Basically I am going to charge customers extra for an SSL enabled subdomain.

Can I create an .htaccess file in the home folder of the subdomain which forces SSL or unforces/disables SSL? Maybe also do mod_rewrite so for example if they paid extra for ssl support:

[url] WOULD AUTO-REDIRECT TO [url]
Also if they didnt pay for SSL

[url] TO [url]

View Replies! View Related

Allowing Legit Traffic Permanently (CSF Iptables)
My server runs on CSF.

Very often the firewall automatically ban some of my customers IP who has fix IP to access to their webmail and website, because they have over 100 staffs, maybe that is why the IP was banned automatically for having too many connections to the server.

Everytime I unban the IP, it keeps being banned again. I have to stop / restart iptables to flush it.

How can I allow the IP permanently?

View Replies! View Related

Is There A VPS Hosting Provider Allowing Customized Xen Image Upload
I am a application/systems developer looking for a VPS hosting provider that would allow me upload a customized xen image that I could use as a template for additional VPSs.

Does anyone know of a hosting provider that could do this type of thing?

View Replies! View Related

Host Myself, Or External
I am an IT manager at a small company. Currently we host an ASP.net based web application (on an IIS server) that we do most of our business on. It was grown in house and uses our MS SQL server. We are looking at expanding this application within the next few months, and I need it to be "bulletproof", as in almost zero downtime.

The website also references and pulls up scanned documents that we have on a NAS server. Currently it is around 300 gig worth of documents, but expanding around 200 gig a year.

Ultimately, I would like this to be hosted someplace where there is a constant backup of the SQL and website. And someplace I don't have to worry about the hardware, because I am a one man operation and don't have all the needed experience to deal with the web application.

would it be beneficial for me to host the scanned documents onsite, and have a hosted solution reference them back at our HQ? I could put them in a DMZ or something like that.

View Replies! View Related

External Processing
I have a hosting provider who cannot provide enough ram to run my one time PHP script (gallery2) (and has a automatic background program kill my task)

So I would like to use processing and ram outside of that server.. via one of my other web servers.. (Dual 1 Ghz, 1 gb of ram) the thing is that the servers got plenty of power but not as much space..

So the ideal solution.. would be to utilize it's power while having it access the hard drive/data remotely and processing it remotely... using the internet/ssh to do this..

Does anyone first off know that this is possible?

2ndly what would be some of the commands?

View Replies! View Related

External Links
have a few different list of links in my link section for eg one page i give people links to about 20 or so games company where they can buy from. another has a small list of forums people can join eg, another list of places that i shop at.i do not have any reciprocal links with any of them and only included them cos i thought it would be handy for my readers. now can i leave the links or should i take it all off because all these external links would not help in my pr? there seems to be so many conflicting opinions

how many external links can you have in a page before it's bad for you.

idea to just use robots.txt on all these pages to be on the safe side?

View Replies! View Related

External Pop Email
One of my customer using google apps for his domain. He also fetch external emails using google mail solution.

Problem is all of his email accounts email fetched but his ISP email give error.

I check and found if he didn't use that ISP, Outlook also not check email and give error. Only he can check email when he logon on net with that ISP.

on webmail he can check using ISP site. Any other webmail services provider like mail2web.com not able to check emails.

Can any one recommend how I can bypass their ISP restriction security.

View Replies! View Related

Firewall, External Box
I have reach another decision. I never considered an external firewall for my server. It sounds like this would be beneficial to me to protect my interest.

Are all external firewalls the same?

What recommendations do you have for one, like name and where I can get one?

View Replies! View Related

How Can We Get Down Time External Page
How to display an information page if servergoes down?

View Replies! View Related

Booting From External HDD
I want to install Linux Ubuntu onto it, the thing is i dont know how to boot to it, there a partition one with XP backup files and one with Linux files I need it to boot from the Linux one so i can install it onto the HDD... but I dont know how I go into the BIOS and change Removable to top but it says it cant find anything...

View Replies! View Related

Traffic From External Subnets
I've got a few colocated servers hooked up to a 3COM switch. When I looked at the MRTG for the ports, I noticed that all the ports had a similar inbound traffic graphing. Thinking that something was amiss, I sniffed the port and found that I was seeing a lot of traffic from different subnets (could even see pop3 passwords!).

Now, I contacted the IDC and they said that this was normal, and that that was how their network was configured (I did tell them that other IDCs didn't have this issue). I think something's not right somewhere. And assuming that the IDC won't fix this issue, I don't want to have constant 1Mbps of inbound traffic that I don't even use.

View Replies! View Related

Qmail With External SMTP
I am using Qmail for most of my email accounts which is taking up a lot of my Singapore bandwidth which is extremely expensive. Anyway to configure such that POP goes to my Singapore servers, while I setup a pair of servers in USA for my SMTP needs?

View Replies! View Related

External DNS Service
We are hosting multiple servers for a site, web, db, media etc and all of them are in the same DC. I am getting worried that incase a server goes down, it would take DNS down along with and will also take emails out.

I was looking to use a good and reliable DNS service which would ensure that we are reliable and emails don't go out incase of an outage.

View Replies! View Related

External Mail Server
we have a cpanel server that has been running our website and emails. We have just obtained another dedicated server. I would like to keep our first server running our website and move all of our email for the domain to the new server. The second server has the same setup and runs cpanel as well. Can anyone point me in the right direction to achieve this?

View Replies! View Related

Best Setting For Nameserver External
I have 1 dedicated where is domain.com + ns1.domain.com + ns2.domain.com

ns1 and ns2 is setting on namecheap and on WHM

Now must set 6 new server and set nameserver from ns3 to ns14.domain.com and hostname from s1 to s6.domain.com

It's right to set this only under domain.com dns as
s1 14400 IN a IP_NEW_SERVER
ns3 14400 IN a IP_NEW_SERVER
ns4 14400 IN a IP_NEW_SERVER
..

OR we must also add

domain.com 14400 IN NS ns3.domain.com.
domain.com 14400 IN NS ns4.domain.com.
..

OR/AND is better to setting this also into namecheap "nameserver registration"?

View Replies! View Related

Starting Up OS From External Drive...
A few months ago i was playing around with ubuntu server and desktop version , i installed it on my external drive.

The external harddrive is Seagate 320 GB , connected via USB 2.0

I tried this about 20 times , every time i could not get it to boot to the harddrive. It would just not show up , i changed the bios settings and everything. It never worked , so i gave up.

Now i want to try again , is there a program i can use to test if my external drive is boot able? I was thinking it was my motherboard causing the problem, but i did set it to boot via USB , i tried every boot device.

View Replies! View Related