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 Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
More Than 'max_user_connections' Active Connections
i am having an website like a webdirectory. BUT i am getting this error after every 5-10 mintues : Warning: mysql_pconnect() [function.mysql-pconnect]: User USERNAME has already more than 'max_user_connections' active connections in /FIELPATH on line 93 Database error: pconnect(localhost,bstitne_netclass, $Password)failed. MySQL Error) Session halted. PLEASE suggest how can i solve this. May be it is an server issue
View Replies!
View Related
More Than 'max_user_connections' Active Connections
Since moving over to a new server, I have had to reboot my sql server about 5 times a day due to it crashing, and I always get the error: Warning: mysql_connect() [function.mysql-connect]: User food_user has already more than 'max_user_connections' active connections in /home/food/public_html/includes/functions.php on line 9 Not connected : User food_user has already more than 'max_user_connections' active connections I dont understand what is causing this...I used the tweaking guide as found on here and my.cnf file looks like this: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock skip-locking skip-innodb query_cache_limit=8M query_cache_size=256M query_cache_type=1 max_connections=500 max_user_connections=10 interactive_timeout=20 wait_timeout=20 connect_timeout=6 thread_cache_size=128 key_buffer=16M join_buffer=1M max_allowed_packet=16M table_cache=1024 record_buffer=1M sort_buffer_size=2M read_buffer_size=2M max_connect_errors=10 # Try number of CPU's*2 for thread_concurrency thread_concurrency=4 myisam_sort_buffer_size=64M #log-bin server-id=1 [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/lib/mysql/mysql.pid open_files_limit=8192 [mysqldump] quick max_allowed_packet=16M [mysql] no-auto-rehash #safe-updates [isamchk] key_buffer=32M sort_buffer=32M read_buffer=16M write_buffer=16M [myisamchk] key_buffer=32M sort_buffer=32M read_buffer=16M write_buffer=16M Through my WHM, i went to "Show Mysql Processes" and heres what it displays www.brinked.com/mysql.txt This problem has also occured on another one of my websites on the same server that makes use of mysql. Am I doing something wrong here? I dont think its the script because it ran for years on another server just fine.
View Replies!
View Related
Timeout Error Starting MySQL
I'm having a bit of trouble here with MySQL, I don't know what to do. Centos 4.3, Mysql 4.1 Data is stored in /var/lib/mysql/ I'm looking to move that information to a second hard drive soon, and did a quick test of just copying it to another place on my existing drive. It won't start. Quote: [root@localhost ~]# service mysqld start Timeout error occurred trying to start MySQL Daemon. Starting MySQL: [FAILED] Error logs Code: 071106 12:14:33 mysqld started 071106 12:14:33 [Warning] Can't create test file /var/lib/mysqltf/localhost.lower-test /usr/libexec/mysqld: Can't change dir to '/var/lib/mysqltf/' (Errcode: 13) 071106 12:14:33 [ERROR] Aborting 071106 12:14:33 [Note] /usr/libexec/mysqld: Shutdown complete 071106 12:14:33 mysqld ended 071106 12:17:00 mysqld started 071106 12:17:00 [Warning] Can't create test file /var/lib/mysqltf/localhost.lower-test /usr/libexec/mysqld: Can't change dir to '/var/lib/mysqltf/' (Errcode: 13) 071106 12:17:00 [ERROR] Aborting 071106 12:17:00 [Note] /usr/libexec/mysqld: Shutdown complete 071106 12:17:00 mysqld ended I have tried even chmod 777ing the msyqltf folder (my copy) to no avail. my.cnf Code: [mysqld] datadir=/var/lib/mysqltf/ socket=/var/lib/mysqltf/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid I've tried moving it to different locations. I even tried moving the original folder and renaming it, and still get this problem.
View Replies!
View Related
Some Websites Load Slow + Mysql Timeout
I'm hosting about 6 private websites on my server, and some have problems. My biggest website is a vb forum with 30.000 members and 1.5 million posts. When i browse with firefox i see that vb forum loads fast, but phpads which is integrated on the top and footer loads very slow. When i browse with IE, it takes like 10 seconds before the whole site is loaded and sometimes IE even crashes. When i try to login on another website / admin panel (oscommerce), i get a mysql gone away error, that means timeout. But why does it show that? I ran mysqlreport and can't find anything why it should display mysql gone away. # ./mysqlreport MySQL 5.0.15-standard uptime 3 19:36:47 Mon Feb 5 11:08:10 2007 __ Key _________________________________________________________________ Buffer usage 78.94M of 96.00M %Used: 82.23 Write ratio 0.60 Read ratio 0.00 __ Questions ___________________________________________________________ Total 19.61M 59.47/s Slow 9 0.00/s %Total: 0.00 %DMS: 0.00 DMS 7.17M 21.74/s 36.56 __ Table Locks _________________________________________________________ Waited 7.57k 0.02/s %Total: 0.05 Immediate 16.50M 50.03/s __ Tables ______________________________________________________________ Open 1.27k of 1800 %Cache: 70.56 Opened 1.82k 0.01/s __ Connections _________________________________________________________ Max used 47 of 500 %Max: 9.40 Total 2.62M 7.95/s __ Created Temp ________________________________________________________ Disk table 6.77k 0.02/s Table 635.25k 1.93/s File 50.37k 0.15/s I can't find any problems on the server which may lead to this strange problem. The server load is normal, around 1 to 1.5. No weird errors in the apache error log or system log. This strange behaviour started 2 weeks ago, and appears 2 to 3 time a week. The system is running: centos 4.3 64-bit kernel 2.6.16.17 #1 SMP directadmin 1.29.0 mysql 5.0.15 php 5.2 apache 2 Zend optimizer 3.2.0 Eaccelerator 1.95 One thing i noticed is that every night when the directadmin cron finished, the server acts normal again. The directadmin cronjobs are: * * * * * root /usr/local/directadmin/dataskq 2 0-23/6 * * * root echo 'action=vacation&value=all' >> /usr/local/directadmin/data/task.queue; #5 5 * * 0 root /sbin/quotaoff -a; /sbin/quotacheck -augm; /sbin/quotaon -a; 20 4 1 * * root echo 'action=reset&value=all' >> /usr/local/directadmin/data/task.queue 0 4 * * * root echo 'action=check&value=license' >> /usr/local/directadmin/data/task.queue 10 0 * * * root /usr/local/directadmin/plugins/awstats/hooks/cgi-bin/awstats_updateall.pl now -awstatsprog=/usr/local/directadmin/plugins/awstats/hooks/cgi-bin/awstats.pl && echo 'action=tally&value=all' >> /usr/local/directadmin/data/task.queue
View Replies!
View Related
Timeout Error Occured Trying To Start MySQL Daemon
I am getting the error (as listed in the title) on my server. This is a BRAND NEW FRESH install on a brand new server... OS: Unix Fedora Kernel Version: Kernel 2.6.18-1/2798.fc6 on an i686 Hardware Information: Brand new Dell SC1435 Server Software Version: MySQl 5 Control Panel: Nothing yet Apache starts ok but when I go to strart MySQL I get the following error... [root@server112]# /etc/rc.d/init.d/mysqld start Timeout error occurred trying to start MySQL Daemon Starting MySQL: [FAILED] Does anyone have any ideas? I did some pretty extensive searching... Web Hosting Talk article that basically describes the same error. I followed everything as listed in his suggestion and it didn't change anything. Also Checked here but this didn't work either.
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] Too Many Connections: Locked Queries
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 Replies!
View Related
MySQL Stops Allowing External Connections
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 Replies!
View Related
Status:ACTIVE
I have a message in queue for about 24 hours and checking the delivery log I found this. LOG: MAIN cwd=/usr/local/cpanel/whostmgr/docroot 4 args: exim -v -M 1INUw5-0007VU-DZ delivering 1INUw5-0007VU-DZ Connecting to mx.uol.xxx.br [xxx.xxx.com.br]:25 ... connected SMTP<< 220 starfury20.xxx.com.br ESMTP SMTP>> EHLO svr01.xx*********** SMTP<< 250-starfury20.xxx.com.br 250-PIPELINING 250-SIZE 20971520 250-VRFY 250-ETRN 250 8BITMIME SMTP>> MAIL FROM: SIZE=3111 SMTP>> RCPT TO: SMTP>> DATA SMTP<< 250 Ok SMTP<< 450 Client host rejected: cannot find your hostname, [74.86.12.2] SMTP<< 554 Error: no valid recipients SMTP>> QUIT I have checked dnsreport for this domain and found this WARNING: One or more of your mailservers is claiming to be a host other than what it really is (the SMTP greeting should be a 3-digit code, followed by a space or a dash, then the host name). If your mailserver sends out E-mail using this domain in its EHLO or HELO, your E-mail might get blocked by anti-spam software. This is also a technical violation of RFC821 4.3 (and RFC2821 4.3.1). Note that the hostname given in the SMTP greeting should have an A record pointing back to the same server. Note that this one test may use a cached DNS record. ***********.co claims to be host svr01.xx*********** [but that host is at 74.xx.xx.2 (may be cached), not 74.xx.xxx.13]. <br /> What should i do to correct this error? btw, I host about 100 sites on this server.
View Replies!
View Related
Active Directory Home Folder
I am using Windows Server 2003 SP2 Standard Edition. I have installed Active directory and created users and their home folders. Everything works fine except a problem. When a user from the domain uses the UNC to connect to the server, it shows the shared folder. The user can view and change all other users files, home directory etc. The user can browse all the folders. I need it to be setup so that the user can only view his own home folder and files and not others. Also when using UNC to browse the server, I want an administrator authentication even if the user is from the same domain. Here are my current permissions. NTFS Root folder permission ================================= Administrators - Full Control CREATOR OWNER - Special Permission System - Full Control Domain Users - Read & Execute, List Contents, Read, Special Permissions. Share permission of root folder ================================ Domain Users - Read NTFS Permission for user home folders ===================================== Created User - Full Control Administrators - Full Control CREATOR OWNER - Special Permission System - Full Control Domain Users - Read & Execute, List Contents, Read, Special Permissions.
View Replies!
View Related
Change Hostname On An Active Server
I currently have a server with CentOS 4x and cPanel with approximatley 100 active sites on. I would like to change the hostname on this box, is this possible without causing any disruption to services on this machine? Would I be correct in thinking its as simple as modifying /etc/hosts(Or doing it in cPanel) and then reactivating the cPanel License?
View Replies!
View Related
Group Policy For Active Desktop
I've been trying to set an active desktop of a group of users that log into XP machines to an html webpage. So far I haven't had any luck getting the webpage to appear. What exactly needs to be done in order for this to work correctly? The primary domain controller is running on windows 200 server.
View Replies!
View Related
Active Directory, Exchange, And Forward Mail
I have active directory setup. Two users are in there that have exchange mailboxes. One has been deleted, but still gets mail on occasion. So, to keep things simple, bob@mydomain.com is a current user. tim@mydomain.com is the one that was deleted. Can I forward mail from tim's address to bob's address without a using a distrobution list? I usually use contacts to forward mail, but that only appears to work for external addresses, and not for internal addresses (ie, mydomain.com) Any ideas?
View Replies!
View Related
Two Sessions Active At The Same Time With Same Socket Application
i hosted one server socket application in my dedicated server which is recving the data from different units(vehicle tracking system) through port no 4444.in dedicated machine i am keeping one active session always...that means my socket application exe is opened always in an active session ie sectionA.This session is not logged off insted i used to close the rdp for keeping this session active.Based on settings if userA accessing SessionA then userB cannot able to reach the active sessionA at the same time instead new sessionB will open for userB. now my question is if userB also opened socket application in SessionB with same portno ,then which soket application will recive data from the units...whther the applictaion from sessionA or from SessionB?
View Replies!
View Related
Considering A New Host For Active Forum & WP Site.
I've been with Bluehost for over three years. I've really not had any big problems with them. But I've learned that people usually don't have problems with hosts unless they actually have a website that has good traffic. Well, as my main site has grown, I think I'm outgrowing my host. I have a forum (SMF) with over 1500 members and close to 80K posts. It's got a good core of very active members. Doing well. The main part of the site is on WP platform. Friday, I try to bring up the forum and POOF! It's not there. Just a blank screen. No error, no nothing. Call support and they have no clue, but the support guy comments out a line in one of my SMF files and the site comes back up. Don't ask me how he knew to comment out that line or anything. Things go fine for a few days, then yesterday P.M. I start getting "exceeding CPU" errors and then a 500 error. Keep in mind, I've done nothing to my site in these days to cause any of this or any changes to even make me suspect anything. Called support two times last night and finally was told to submit a ticket to their scripting department. I could see the PHP errors in my CP and I knew it was something wrong on their end, but no one could figure it out. Well, I haven't heard from support but my site's back up today. I'm just thinking it may be time to consider switching. Not sure I really want to deal with that, but I'm having more errors and glitches with them in the last year. I know HostGator gets mostly great reviews. Will my experience there be any different though? I know lots of people here ask for web host suggestions. I could really use some guidance, not just in companies, but the things I need to keep in mind about my site in particular that would help me choose one.
View Replies!
View Related
Does Cron Timeout?
Simply wondering, does cron timeout? I have heard mixed reports and can't find any good info. Personally i've run a cronjob for up to 6 minutes, but as my best method was sending myself emails through php, its not exactly a highly accurate testing method. On the same note, what would happen if one cronjob is running a php script for over 10 minutes, then another cron job starts on the same script, before the first one has finished?
View Replies!
View Related
Vps Timeout
I got my VPS a few days ago and want to get started. I installed Webmin (with the rpm - centos 5), and it says it installed successfully and then I can login. I typed in my domain name with the ':10000' but I get a network timeout in Firefox. I know my DNS is right, because I have the domain name pointed to my IP address with an A record. SSH is working fine, I can login using the domain name and not my IP address. I tried installing Lighttpd, but still get the timeout. Replacing the domain name with the VPS IP address doesn't work either.
View Replies!
View Related
SSH Timeout
Is there a way to increase the timeout for a SSH connection when idle? Mine (on my server) seems to time out after 15-20 mins of inactivity. I'd like to increase this to like 60 mins or indefinitely.
View Replies!
View Related
CGI Timeout
When i try to login my forum after waiting alittle following error occured Code: CGI Timeout The specified CGI application exceeded the allowed time for processing. The server has deleted the process
View Replies!
View Related
Connection Timeout On SSH
where I can't access my terminal because my connections keep getting timed out. Its been ok previously but for the last 2 days I could not connect because the connection timed out 9/10 times. No modifications were made during this time so whats the problem guys?
View Replies!
View Related
VPS - Connection Timeout
I have a problem with my VPS. Hosting company have migrated my vps to a new and better dedicated server and now on all my sites(and IP) I got connection timeout error. I have changed "Main IP" and resolvers in HyperVM 10 minutes ago and it's not working(or I have to wait to wait like for nameservers registration?). I can ping my IP and all services(lxadmin,lighttpd etc are started successfully and its not wotking, I still getting connection timeout error.
View Replies!
View Related
Unique Apache Timeout
I have a new website that has a similar feature to tripadvisor's Reviews, where users share detailed thoughts and experiences. They fill in all this information on one form so there is no interaction with the system while they are writing. I know Apache has the TimOut setting which is set to 5 minutes by default. This ensures that you do not have users using active memory and sessions for a long period of time. But the problem I have seen is that some users are spending 15-20 minutes writing very detailed experiences and when they hit the submit button obviously their session has timed out and they lose everything and get a system error. I really don't want to change the TimeOut value in Apache to 20 min due to resource constraints, but is this my only option?
View Replies!
View Related
Scripts Timeout After 60 Sec
I have a phpbb3 forum that I post sound clips for my members to download and I had a few of them tell me that sometimes the downloads truncate. I asked my host what the deal is and they told me that their scripts time out after 60 seconds and that there was no way to make it longer. I have never heard of this before and I want to know, is that normal or standard for hosting companies? It seems weird that they would host a message board that allows attachments and their service doesn't allow enough time for people with dialup or slower connections to download files in their entirety.
View Replies!
View Related
HTTP Keapalive Timeout
I'm trying to solve an issue with certain customers timing out. In regards to the "http KeepAlive timeout" value.... When this timer expires, does the webserver have the tcp stack send a FIN? IF so, does it actually do it like at six or seven seconds? It's actually IBM IHS in this case.
View Replies!
View Related
Why Getting Session Timeout Error In IE
I am assisting a client who is linking to an online calculator, he is putting a frame on top of the calculator page, so people will still see his information. However, for some reason he is getting a Session Timeout Error in IE. I don't get this error in Firefox using this method, or ever going to the direct page in IE. Let me give a better explanation: If you visit: [url] Just put in a fake name and email, it loads a frame at top, and then the online calculator, which is this page: [url] Why I am getting a Session Timeout? Is there a better solution. I never get the same error if I go directly too: [url] We want a frame or better solution because we still want the contact information to be in front of the consumer. Does this maybe have to do with a cookie and frame?
View Replies!
View Related
Timeout- After Working For Awhile
I've been experiencing some annoying issues recently, trying to troubleshoot whether it's actually my server or my ISP - Using a HostGator standard box, php 5.2.3, optimized based on scribby's tutorial. Basically I'll be editing my website for about 10-15 minutes, going through the admin panel and uploading files from it several times. Suddenly it will begin timing out for about 1 min or so and then it will run very sluggish/slow unless I let it "cool down" for a bit and try again later. I ran "ping -t mysite.com" while editing the site and during the timeouts and there was no packet loss. I can access other sites on the server and WHM from the IP at normal speeds during the timeouts, and other people can access the affected site fine.
View Replies!
View Related
Server.lu Having Frequently Ping Timeout
globichen can explain about this. ping timeout happen frequently. this is the 2nd time happen in a week i've submit a ticket regarding about this customer service replies with server is online. i'm not bashing their service but frequently ping timeout really makes my business down lately. Loading website takes a few min & even couldn't access to server due to ping timeout.
View Replies!
View Related
Cpanel :: Timeout While Trying To Get Data From Service
I am facing some strange problems with one of my cPanel/WHM server. It's a dedicated server with Quad Core processor and 4gb ram. First i thought it was a ddos attack but now i think it's not. I am keep getting ftpd failed emails every 5-10 mins. ftpd failed @ Mon Jul 7 06:07:21 2008. A restart was attempted automagically. Failure Reason: Timeout while trying to get data from service server is extremely slow and load is over 10 for last 2 days. it shows that httpd, mysql, ftp is up but none of our site's are loading. 1 thing i noticed when i logged into WHM is that it says WHM VPS Optimized. Attachment 13075 I tried updating cPanel but same problems. SSH Top: .......
View Replies!
View Related
CSF Causing Server Ping Timeout
I just installed a fresh new server with CSF Soon I find out that my ping keeps dropping. The server was smoothly running, SSH is smooth, Website are loading fine, except I cannot ping my server. I disable SELINUX completely and it still doesn't help. When I disable CSF, my server ping are responding back! So I remove CSF installation and reinstall CSF, the same problem appear How can I solve this issue? My kernel is 2.6.18-92.1.6.el5PAE running on latest version of cPanel on CentOS 5.1
View Replies!
View Related
Ping Timeout On IPs Used For IP Based Sites
For some reason, my IPs that we use for a IP based site are un-pinable (ping time out) after some time. However, when I restart apf (firewall) the ip are back again and are pinable again. We added the IPs for the IP based site over the ensim panel. I belive its a Firewall issue, does anyone know how to check why the Ips are always getting un-pinable?
View Replies!
View Related
Proftpd Timeout Connection Attempt Failed
Currently having a problem with proftpd on my centos plesk 8.1 server. During large uploads, lets say around 10 MB the FTP connection fails within 5 minutes or so saying: "A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond." I have asked for help from my server provider but they have tried and are now unable to help. I currently have the APF firewall in my server. Has anyone experienced this? Below is the APF config file that i currently have & the proftpd config files that i have, if anyone can help it would be really really appreciated APF CONFIG: Code: #!/bin/sh # # APF 0.9.6 [apf@r-fx.org] # # NOTE: This file should be edited with word/line wrapping off, # if your using pico please start it with the -w switch # (e.g: pico -w filename) # ## # [Devel Mode] # !!! Do not leave set to (1) !!! # When set to enabled; 5 minute cronjob is set to stop the firewall. Set # this mode off (0) when firewall determined to be operating as desired. ## # Set firewall cronjob (devel mode) # 1 = enabled / 0 = disabled DEVEL_MODE="0" ## # [Main] ## # The installation path of APF; this can be changed but it has not # been tested what would happen. INSTALL_PATH="/etc/apf" # Untrusted Network interface(s); all traffic on defined interface will be # subject to all firewall rules. This should be your internet exposed # interfaces. Only one interface is accepted for each value. # NOTE: The interfacing structure is being worked towards support of MASQ/NAT IFACE_IN="eth0" IFACE_OUT="eth0" # Trusted Network interface(s); all traffic on defined interface(s) will by-pass # ALL firewall rules, format is white space or comma seperated list. IFACE_TRUSTED="" # Enable virtual network subsystem; creats independent policy ruleset for each # ip on a system (pulls data from 'ip addr list') to /etc/apf/vnet/ip.rules # Template is located in the vnet/ folder for rule files. This feature can # reduce apf start/stop performance and is not recommend for systems with more # than 255 (/24) ip's. [0 = Disabled / 1 = Enabled] SET_VNET="0" # Support Monolithic kernel builds [no LKM's]. This mode of operation is # not really supported and you use at your own risk. SET_MONOKERN="0" # Verifies that all inbound traffic is sourced from a defined local gateway MAC # address. All other traffic that does not match this source MAC address will be # rejected as untrusted traffic. It is quite trivial to forge a MAC address and as # such this feature executes NO default accept policy against this MAC address. VF_LGATE="" # Verifies that the IF and IFACE_TRUSTED interfaces are actually routed (/sbin/route) # to something. If not then chances are APF will not start properly if at all. VF_ROUTE="1" # Verifies that crond service is running when DEVEL_MODE=1; if not then APF will not # try to load as if lock-up occures no cron service to flush firewall VF_CROND="1" # Verifies that the current system uptime is greater than this value before APF # can activate. This is to prevent on-boot lockup issues or delays due to excessive # amount of firewall rules. Value is in seconds; should you wish to disable this # feature, simply set VF_UTIME to 0 value. !! NOTE: APF WILL NOT START ON IT's OWN; # IT WILL EXIT WITH FATAL ERROR BELOW SET UPTIME !! VF_UTIME="0" ## # [Packet Filtering/Handling] ## # How to handle TCP packet filtering? # # RESET (sends a tcp-reset; TCP/IP default) # DROP (drop the packet; stealth ?) # REJECT (reject the packet) TCP_STOP="DROP" # How to handle UDP packet filtering? # # RESET (sends a icmp-port-unreachable; TCP/IP default) # DROP (drop the packet; stealth ?) # REJECT (reject the packet) # PROHIBIT (send an icmp-host-prohibited) UDP_STOP="DROP" # How to handle all other packet filtering? (icmp,arp,igmp) # # DROP (drop the packet) # REJECT (reject the packet) DSTOP="DROP" # The sanity options control the way packets are scrutinized as # they flow through the firewall. The main PKT_SANITY option is a # top level toggle for all SANITY options and provides general # packet flag sanity as a pre-scrub for the other sanity options PKT_SANITY="1" # Block any packets that do not conform as VALID; this feature # is safe for most but some may experience protocol issues with # broken remote clients PKT_SANITY_INV="0"
View Replies!
View Related
DNS Lookup Timeout From Googlebot Indexing Webpages
One of my customers uses Webmasters Tools from google , looking at what pages he have indexed by Googlebot, found that 180 pages are giving a "DNS lookup timeout" error, tried searching for help on google and the only thing that i found is " We received a timeout on DNS lookup." DNS are ok, same as the zone file, everything is responding OK, I dont know what can be the issue.. ? any ideas ? Im using Ensim Pro and RHES 4.
View Replies!
View Related
FastCGI :: Aborted: (first Read) Idle Timeout (30 Sec)
I've got a server with FastCGI that at random produces 500 internal server errors. In the specific account the errors are as follows in the error_log: [Wed May 21 12:01:29 2008] [error] [client 1.2.3.4] FastCGI: comm with (dynamic) server "/usr/local/apache2/htdocs/user/php-wrapper" aborted: (first read) idle timeout (30 sec) [Wed May 21 12:01:29 2008] [error] [client 1.2.3.4] FastCGI: incomplete headers (0 bytes) received from server "/usr/local/apache2/htdocs/user/php-wrapper" As you can see this unfortunately does not tell me anything. Now viewing the apache error_log I see this Code: [Wed May 21 12:51:11 2008] [warn] FastCGI: scheduled the restart of the last (dynamic) server "/usr/local/apache2/htdocs/user/php-wrapper" process: reached dynamicMaxClassProcs (10) [Wed May 21 12:51:11 2008] [warn] FastCGI: (dynamic) server "/usr/local/apache2/htdocs/user/php-wrapper" (uid 514, gid 515) restarted (pid 20510) [Wed May 21 12:52:00 2008] [warn] FastCGI: (dynamic) server "/usr/local/apache2/htdocs/user/php-wrapper" (pid 20510) termination signaled [Wed May 21 12:52:00 2008] [warn] FastCGI: (dynamic) server "/usr/local/apache2/htdocs/user/php-wrapper" (pid 20510) terminated by calling exit with status '0' [Wed May 21 12:57:02 2008] [warn] FastCGI: (dynamic) server "/usr/local/apache2/htdocs/user/php-wrapper" (pid 20501) termination signaled [Wed May 21 12:57:02 2008] [warn] FastCGI: (dynamic) server "/usr/local/apache2/htdocs/user/php-wrapper" (pid 20501) terminated by calling exit with status '0' [Wed May 21 13:02:03 2008] [warn] FastCGI: (dynamic) server "/usr/local/apache2/htdocs/user/php-wrapper" (pid 20491) termination signaled [Wed May 21 13:02:03 2008] [warn] FastCGI: (dynamic) server "/usr/local/apache2/htdocs/user/php-wrapper" (pid 20491) terminated by calling exit with status '0' All warnings so I'm assuming these don't mean anything. Here's the php-wrapper: Code: #!/bin/sh PHPRC=/usr/local/lib export PHPRC PHP_FCGI_CHILDREN=8 export PHP_FCGI_CHILDREN PHP_FCGI_MAX_REQUESTS=500 export PHP_FCGI_MAX_REQUESTS exec /usr/local/bin/php-cgi Not a particularly well setup system for users and such but it worked for the user. The software versions are as follows: Apache 2.2.8 with Suexec on the FCGI FastCGI (Latest stable and also tried a CVS version) PHP 5.2.6 64 bit system how to go about debugging this?
View Replies!
View Related
VPN Timeout Issues - Cisco & Watchguard
I have 2 locations, one with a Watchguard Firebox II/1000 and the other with a Cisco ASA 5520. I have configured a VPN between them and have run into a snag. The VPN tunnel works fine until it expires, but there is a significant lag in re-establishing the tunnel. The lag is enough to cause Backup and Data transfer failures due to timeouts. Does anyone know how to configure the VPN tunnel to never expire, regardless of uptime or traffic volume? The Cisco doesn't seem to want to let me configure either phase for 0 or infinate kb expiration.
View Replies!
View Related
|