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
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:
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.
071106 12:17:00 mysqld ended I have tried even chmod 777ing the msyqltf folder (my copy) to no avail.
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
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
I just installed mySQL server on a brand new dedicated server and am getting Timeout error occurred trying to start MySQL Daemon. I have uninstalled and reinstalled it a few times and am still getting the same error.
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.
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 ?
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+.
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?
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
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.
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.
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, [188.8.131.52] 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.
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.
Let's say you ordered new server,do you make active same moment(install httpd server and all other components)or you running test before like memory and hardware test? If yes,which programs you would recommend to test fully hardware?
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.
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, firstname.lastname@example.org is a current user. email@example.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)
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?