This is the second time this has happened last time my host fixed it and they should be right now but why does this happen to a server?
Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/xxxxx/domains/xxxxx.com/public_html/includes/open_db.php on line 12
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Im trying to get 64bit MYSQL 5.1 installed on a CENTOS 5.2 64bit box. But after a week of wrangling with it I just dont seem to be able to get it running. I have tried both installing via the MYSQL.com RPM's and via a added YUM Repo.
Below is my error log.
Quote:
090522 15:33:04 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 090522 15:33:04 [ERROR] Error message file '/usr/share/mysql/english/errmsg.sys' had only 472 error messages, but it should contain at least 630 error messages. Check that the above file is the right version for this program! /usr/libexec/mysqld: Unknown error 1146 090522 15:33:04 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 090522 15:33:04 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 090522 15:33:04 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 090522 15:33:04 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 090522 15:33:04 InnoDB: Started; log sequence number 0 0 090522 15:33:04 [ERROR] Aborting
My server very slow and the is very loaded. How can I fix this problem? My server specialities and loaded softwares which are below. And sometimes there is "mysql connect failed", "Lost connection to MySQL server during query" errors. Thanks for kinds...
-- MYSQL PERFORMANCE TUNING PRIMER -- - By: Matthew Montgomery -
MySQL Version 5.0.41-log i686
Uptime = 3 days 4 hrs 34 min 17 sec Avg. qps = 92 Total Questions = 25406284 Threads Connected = 1
Server has been running for over 48hrs. It should be safe to follow these recommendations
To find out more information on how each of these runtime variables effects performance visit: .............
SLOW QUERIES Current long_query_time = 5 sec. You have 115 out of 25406302 that take longer than 5 sec. to complete The slow query log is enabled. Your long_query_time seems to be fine
WORKER THREADS Current thread_cache_size = 8 Current threads_cached = 7 Current threads_per_sec = 0 Historic threads_per_sec = 0 Your thread_cache_size is fine
MAX CONNECTIONS Current max_connections = 500 Current threads_connected = 2 Historic max_used_connections = 110 The number of used connections is 22% of the configured maximum. Your max_connections variable seems to be fine.
MEMORY USAGE Max Memory Ever Allocated : 835 M Configured Max Per-thread Buffers : 3 G Configured Max Global Buffers : 46 M Configured Max Memory Limit : 3 G Total System Memory : 3.96 G
Max memory limit exceeds 85% of total system memory
KEY BUFFER Current MyISAM index space = 35 M Current key_buffer_size = 32 M Key cache miss rate is 1 : 73658 Key buffer fill ratio = 34.00 % Your key_buffer_size seems to be too high. Perhaps you can use these resources elsewhere
QUERY CACHE Query cache is enabled Current query_cache_size = 4 M Current query_cache_used = 1 M Current query_cach_limit = 1 M Current Query cache fill ratio = 29.83 % MySQL won't cache query results that are larger than query_cache_limit in size
SORT OPERATIONS Current sort_buffer_size = 2 M Current record/read_rnd_buffer_size = 1 M Sort buffer seems to be fine
JOINS Current join_buffer_size = 1.00 M You have had 14127 queries where a join could not use an index properly You should enable "log-queries-not-using-indexes" Then look for non indexed joins in the slow query log. If you are unable to optimize your queries you may want to increase your join_buffer_size to accommodate larger joins in one pass.
Note! This script will still suggest raising the join_buffer_size when ANY joins not using indexes are found.
OPEN FILES LIMIT Current open_files_limit = 2500 files The open_files_limit should typically be set to at least 2x-3x that of table_cache if you have heavy MyISAM usage. Your open_files_limit value seems to be fine
TABLE CACHE Current table_cache value = 256 tables You have a total of 636 tables You have 256 open tables. Current table_cache hit rate is 1% , while 100% of your table cache is in use You should probably increase your table_cache
TEMP TABLES Current max_heap_table_size = 16 M Current tmp_table_size = 32 M Of 2271787 temp tables, 3% were created on disk Effective in-memory tmp_table_size is limited to max_heap_table_size. Created disk tmp tables ratio seems fine
TABLE SCANS Current read_buffer_size = 1 M Current table scan ratio = 28 : 1 read_buffer_size seems to be fine
TABLE LOCKING Current Lock Wait ratio =1 : 112 You may benefit from selective use of InnoDB. If you have long running SELECT's against MyISAM tables and perform frequent updates consider setting 'low_priority_updates=1' If you have a high concurrentcy of inserts on Dynamic row-length tables consider setting 'concurrent_insert=2'.
how can i stop php and mysql errors from being displayed on a live site. I'd rather just check the error log than have the errors displayed to all users.
The main function of my dedicated server is the vBulletin forum that we run.
Ever since I had bastille firewall installed and configured on my server we have been getting regular vBulletin errors.
Everything runs pretty smoothly most of the time, we can carry lots of connections without any issues, server has plenty of free RAM and CPU is never overloaded even during peak hours. I have been told bastille firewall (iptables) is configured correctly, all ports that need to be open are open.
But about twice per day we have a MySQL "disconnect" that lasts about 30-60 seconds per incident. For example we will start getting the following message via e-mail, and it will amount to 20-30 e-mails like this during the 30-60 second incident. After that, the e-mails and problems will go away, until next time.
vBulletin Database Error! mysql_connect(): Can't connect to MySQL server on 'sql.datacolony.com' (4) /hsphere/local/home/site/site.com/forum/includes/class_core.php on line 274 MySQL Error : Error Number : Date : Saturday, January 26th 2008 @ 07:53:05 PM Script : [url] Referrer : [url] IP Address : 92.3.190.54 Username : Classname : vb_database
The server is running CentOS 4.6, PHP 4.4.7, MySQL 5.0.45. The vBulletin software has been patched to the latest version. The vBulletin people are not sure why this could be happening.
Well we never believed that the firewall was causing the issue BUT it only started happening on the day the new firewall was installed. So we tried stopping the firewall for a full week and the MySQL database errors stopped happening, completely. So I'm convinced the problem is the firewall blocking MySQL connections but I can't figure out why?
There are no entries in the MySQL .err logs pertaining to this. Can't figure this out, any help or ideas is appreciated since the people who installed the firewall are not sure either.
I'm noticed I was getting bounced email errors from a company I was sending email through and I further investigated this by running a dnsreport on my domain.
Turns out that it fails at Acceptance of NULL <> sender, Acceptance of postmaster address, and Acceptance of abuse address. The domain that I ran a test on is using a new IP that I had recently added to my Direct Admin server. None of the other domains on my server are having issues like this.
Is is possible that I need to do something to enable these new IP addresses in exim? I mean, exim obviously responds to that IP address, but it seems to be having some issues with it.
I installed the MySQL binary packages in /usr/local/mysql/ after removing the MySQL RPM package. MySQL is functioning when I executed /usr/local/mysql/bin/safe_mysqld. I reinstalled MySQL before I installed PHP. When I used a PHP script to access a MySQL database, it outputs an error:
Code: Warning: mysqli::mysqli() [function.mysqli-mysqli]: (HY000/2002): can't connect to local mysql server through socket /var/lib/mysql/mysql.sock in index.php on line 2 However, I installed MySQL in /usr/local/mysql, not in /var/lib/mysql. How do I fix MySQL?
I am doing the Security Check provided by Config Server Firewall.
It is giving me 3 errors, and I want to fix them, so here they are.
Check /dev/shm is mounted noexec,nosuid /dev/shm is not mounted with the noexec,nosuid options (currently: none). You should modify the mountpoint in /etc/fstab for /dev/shm with those options and remount On this one I actually went and added the noexec,no suid options. Here is what i've got configured and what it looks like. (it's most likely not correct so help correct it.) [url]
Check /etc/named.conf for DNS recursion restrictions
You have a local DNS server running but do not have any recursion restrictions set in /etc/named.conf. If the named process is using this configuration file, then this is a security and performance risk and you should look at restricting recursive lookups to the local IP addresses only
Check dovecot weak SSL/TLS Ciphers (ssl_cipher_list) Cipher list []. Due to weaknesses in the SSLv2 cipher you should disable SSLv2 in WHM > MailSever Configuration > SSL Cipher List > Remove +SSLv2 or Add -SSLv2 Alright so this one I followed the instructions, and i've got everything set correctly but it still shows up on the thing. I don't think the ssl_cipher_list is even available in WHM
I don't know much of anything about server settings or errors, so I need your help. Recently one of my servers have been getting a lot of 500 error messages, and I can't pinpoint the reason or replicate the error on my end. I did some Google searching and although I found out in general what a 500 error is, I still am not clear on what exactly causes them or how to reduce them. Could it be caused by intense amounts of traffic? Is the server just being overloaded?
Also, I see that my server is throwing a lot of 404 errors for a variety of URLs on my site, however when I visit the URLs specified by the error log they work fine for me - seems like only sometimes for whatever reason the server can't find/access them and throws a 404. Again, I can't replicate it and have no clue how to fix it since the list of 404 URLs work fine when I type them in.
I have a VPS account with an hosting site. For the past 2 days i have done a lot of uploads. I have 25+ sites on this account. Today when i try to login into my sites via ftp, its showing ftp login failed for all sites.
The hosting company is still sleeping on my queries regarding this matter.
Interestingly logins for WHM & cpanel for all sites are working fine.
Any experienced members plz guide me on how to get the ftp working to upload files to my sites.
there is "Cannot Resolve Dns" for my site for one or 2 regions .. Everytime i check my site my site with a Website Monitoring site , i get Cannot Resolve Dns for one or two regions .. can anyone please tell me what the problem can be ..
When i go to dnsreport.com , i get Fail in Missing (stealth) nameservers
Quote:
FAIL: You have one or more missing (stealth) nameservers. The following nameserver(s) are listed (at your nameservers) as nameservers for your domain, but are not listed at the parent nameservers (therefore, they may or may not get used, depending on whether your DNS servers return them in the authority section for other requests, per RFC2181 5.4.1). You need to make sure that these stealth nameservers are working; if they are not responding, you may have serious problems! The DNS Report will not query these servers, so you need to be very careful that they are working properly.
ns1.mysite.ws. ns2.mysite.ws. This is listed as an ERROR because there are some cases where nasty problems can occur (if the TTLs vary from the NS records at the root servers and the NS records point to your own domain, for example).
Jun 29 12:35:48 server kernel: Firewall: *TCP_OUT Blocked* IN= OUT=eth0 SRC=(my server ip) DST=(another server IP of mine) LEN=44 TOS=0x00 PREC=0x00 TTL=64 ID=3858 DF PROTO=TCP SPT=33891 DPT=2534 WINDOW=5840 RES=0x00 SYN URGP=0 Jun 29 12:35:49 server kernel: Firewall: *TCP_OUT Blocked* IN= OUT=eth0 SRC=(my server ip) DST=(another server IP of mine) LEN=44 TOS=0x00 PREC=0x00 TTL=64 ID=17089 DF PROTO=TCP SPT=33897 DPT=3306 WINDOW=5840 RES=0x00 SYN URGP=0 Jun 29 12:35:52 server kernel: Firewall: *TCP_OUT Blocked* IN= OUT=eth0 SRC=(my server ip) DST=(another server IP of mine) LEN=44 TOS=0x00 PREC=0x00 TTL=64 ID=17091 DF PROTO=TCP SPT=33897 DPT=3306 WINDOW=5840 RES=0x00 SYN URGP=0 Jun 29 12:35:53 server kernel: Firewall: *TCP_OUT Blocked* IN= OUT=eth0 SRC=(my server ip) DST=(another server IP of mine) LEN=44 TOS=0x00 PREC=0x00 TTL=64 ID=39040 DF PROTO=TCP SPT=33899 DPT=2534 WINDOW=5840 RES=0x00 SYN URGP=0 Jun 29 12:35:56 server kernel: Firewall: *TCP_OUT Blocked* IN= OUT=eth0 SRC=(my server ip) DST=(another server IP of mine) LEN=44 TOS=0x00 PREC=0x00 TTL=64 ID=39042 DF PROTO=TCP SPT=33899 DPT=2534 WINDOW=5840 RES=0x00 SYN URGP=0
Here's the strange thing. The part that says "another server IP of mine" are two different OTHER servers of mine, BUT do not have cpanel nor part of the cluster. What could it be?
Jan 31 04:39:22 servername kernel: ATA: abnormal status 0x7F on port 0xE807 Jan 31 04:39:22 servername kernel: ATA: abnormal status 0x7F on port 0xE007
I had made a page on my site earlier and when i went to it it gave me a 403 error so i tried fixing the .htacess then the site got messed up so i reset the .htacess to tis original settigns and now when i redirect to anything but the home directory it gives me a 403 error can anyone help?
Whenever am trying to post anything there server load increse upto 90 and Post takes so much time to publish.
and at that time sometime am getting this error
Error establishing the database connection
Here is the screenshot of the Cpanel stats:
[url]
and am getting these error in my apache error logs
[Wed Oct 28 19:46:19 2009] [error] [client 222.103.225.163] File does not exist: /usr/local/apache/htdocs/webadmin [Wed Oct 28 19:46:19 2009] [error] [client 222.103.225.163] File does not exist: /usr/local/apache/htdocs/myadmin [Wed Oct 28 19:46:18 2009] [error] [client 222.103.225.163] File does not exist: /usr/local/apache/htdocs/mysql [Wed Oct 28 19:46:18 2009] [error] [client 222.103.225.163] File does not exist: /usr/local/apache/htdocs/mysqlmanager [Wed Oct 28 19:46:17 2009] [error] [client 222.103.225.163] File does not exist: /usr/local/apache/htdocs/sqlmanager [Wed Oct 28 19:46:17 2009] [error] [client 222.103.225.163] File does not exist: /usr/local/apache/htdocs/admin [Wed Oct 28 19:46:16 2009] [error] [client 222.103.225.163] File does not exist: /usr/local/apache/htdocs/PMA [Wed Oct 28 19:46:16 2009] [error] [client 222.103.225.163] File does not exist: /usr/local/apache/htdocs/web [Wed Oct 28 19:46:16 2009] [error] [client 222.103.225.163] File does not exist: /usr/local/apache/htdocs/db [Wed Oct 28 19:46:15 2009] [error] [client 222.103.225.163] File does not exist: /usr/local/apache/htdocs/phpMyAdmin [Wed Oct 28 19:46:15 2009] [error] [client 222.103.225.163] File does not exist: /usr/local/apache/htdocs/phpmyadmin
Below are my zone files and i receive the errors as specified. [url]
Code:
BIND data file for mysite.org ; $TTL 604800 @ IN SOA [url] ( 2007011501 ; Serial 7200 ; Refresh 120 ; Retry 2419200 ; Expire 604800) ; Default TTL ; @ IN NS [url] @ IN NS [url] [url] IN MX 10 [url] [url] IN A 200.19.227.135 www IN CNAME [url] mail IN A 200.19.227.135 ftp IN CNAME [url] [url] IN TXT "v=spf1 ip4:200.19.227.135 a mx ~all" mail IN TXT "v=spf1 a -all" mysite:/etc/bind/zones/master#
Code:
; ;dns_rdata_fromtext: [url]:10: near eol: unexpected end of input zone [url]: loading master file [url]: unexpected end of input 200.19.227.rev
Code:
mysite:/etc/bind/zones/master# more 200.19.227.rev $TTL 1d ; $ORIGIN 227.19.200.IN-ADDR.ARPA. @ IN SOA [url] ( 2007011501 7200 120 2419200 604800 ) IN NS [url] IN NS [url] 1 IN PTR [url] 2 IN PTR [url] mysite:/etc/bind/zones/master#
Code: mysite:/etc/bind/zones/master# named-checkzone mysite.org 200.19.227.rev 200.19.227.rev:3: ignoring out-of-zone data (227.19.200.IN-ADDR.ARPA) dns_rdata_fromtext: 200.19.227.rev:8: near eol: unexpected end of input 200.19.227.rev:12: ignoring out-of-zone data (1.227.19.200.IN-ADDR.ARPA) 200.19.227.rev:13: ignoring out-of-zone data (2.227.19.200.IN-ADDR.ARPA) [url]/IN: loading master file 200.19.227.rev: unexpected end of input
We are facing with a strange issue about URLs. At any web site in our reseller account in php pages when we add http:// or http%3A%2F%2F to the URL as a query string server returns Internal Server Error 500.
For example when I try to access such page /index.php?q=http%3A%2F%2F[url] or /index.php?q=[url]I get this error. Is there any misconfiguration about PHP or Apache at server or what can we do to solve this problem?
Is there a way I can get more error messages with exim? I'm trying to log in using plaintext smtp authentication and all I get is this:
2009-06-21 06:51:23 Start queue run: pid=8021 2009-06-21 06:51:23 End queue run: pid=8021 2009-06-21 07:07:41 no host name found for IP address 220.80.173.17 2009-06-21 07:07:42 no host name found for IP address 220.80.173.17 2009-06-21 07:21:23 Start queue run: pid=8029 2009-06-21 07:21:23 End queue run: pid=8029 2009-06-21 07:41:18 no host name found for IP address 220.80.173.17 2009-06-21 07:51:23 Start queue run: pid=8074 2009-06-21 07:51:23 End queue run: pid=8074 2009-06-21 08:20:47 no host name found for IP address 220.80.173.17 2009-06-21 08:21:23 no host name found for IP address 220.80.173.17
I have performed chkrootkit and got the following results. It suggests that there are a lot of problems. how would i get rid of these?
Checking `lsof'... not infected Checking `mail'... not infected Checking `mingetty'... not infected Checking `netstat'... not infected Checking `named'... not infected Checking `passwd'... not infected Checking `pidof'... not infected Checking `pop2'... not found Checking `pop3'... not found Checking `ps'... not infected Checking `pstree'... not infected Checking `rpcinfo'... not infected Checking `rlogind'... not found Checking `rshd'... not found Checking `slogin'... not infected Checking `sendmail'... not infected Checking `sshd'... not infected Checking `syslogd'... not infected Checking `tar'... not infected Checking `tcpd'... not infected Checking `tcpdump'... not infected Checking `top'... not infected Checking `telnetd'... not infected Checking `timed'... not found Checking `traceroute'... not infected Checking `vdir'... not infected Checking `w'... not infected Checking `write'... not infected Checking `aliens'... no suspect files Searching for sniffer's logs, it may take a while... nothing found Searching for HiDrootkit's default dir... nothing found Searching for t0rn's default files and dirs... nothing found Searching for t0rn's v8 defaults... nothing found Searching for Lion Worm default files and dirs... nothing found Searching for RSHA's default files and dir... nothing found Searching for RH-Sharpe's default files... nothing found Searching for Ambient's rootkit (ark) default files and dirs... nothing found Searching for suspicious files and dirs, it may take a while...
568 Temporarily rejected RCPT: lowest numbered MX record points to local host 89 Temporarily rejected RCPT: Could not complete sender verify 12 Temporarily rejected RCPT: host lookup did not complete 9 Temporarily rejected RCPT: remote host address is the local host
May 16 16:00:32 server Cp-Wrap[6322]: Pushing "32121 GETDOMAINIP user.com " to '/usr/local/cpanel/bin/apacheadmin' for UID: 32121 May 16 16:00:32 server Cp-Wrap[6322]: CP-Wrapper terminated without error May 16 16:00:32 server Cp-Wrap[6325]: Pushing "32121 LISTSUBDOMAINS 0 " to '/usr/local/cpanel/bin/apacheadmin' for UID: 32121 May 16 16:00:32 server Cp-Wrap[6325]: CP-Wrapper terminated without error May 16 16:00:32 server Cp-Wrap[6328]: Pushing "32121 LISTMULTIPARKED 0 " to '/usr/local/cpanel/bin/apacheadmin' for UID: 32121 May 16 16:00:32 server Cp-Wrap[6328]: CP-Wrapper terminated without error May 16 16:00:32 server Cp-Wrap[6330]: Pushing "32121 COUNTDBS" to '/usr/local/cpanel/bin/mysqladmin' for UID: 32121 May 16 16:00:33 server Cp-Wrap[6330]: CP-Wrapper terminated without error May 16 16:00:33 server Cp-Wrap[6333]: Pushing "32121 LISTDBS" to '/usr/local/cpanel/bin/postgresadmin' for UID: 32121 May 16 16:00:33 server Cp-Wrap[6333]: CP-Wrapper terminated without error May 16 16:00:33 server Cp-Wrap[6338]: Pushing "32121 GETDISK" to '/usr/local/cpanel/bin/mysqladmin' for UID: 32121 May 16 16:00:33 server Cp-Wrap[6338]: CP-Wrapper terminated without error May 16 16:00:33 server Cp-Wrap[6342]: Pushing "32121 LIST 0 0 " to '/usr/local/cpanel/bin/ftpadmin' for UID: 32121 May 16 16:00:33 server Cp-Wrap[6342]: CP-Wrapper terminated without error
/home/cpapachebuild/buildapache/php-5.0.4/ext/curl/interface.c:173: error: `CURLOPT_FTPASCII' undeclared (first use in this function) /home/cpapachebuild/buildapache/php-5.0.4/ext/curl/interface.c:173: error: (Each undeclared identifier is reported only once /home/cpapachebuild/buildapache/php-5.0.4/ext/curl/interface.c:173: error: for each function it appears in.) /home/cpapachebuild/buildapache/php-5.0.4/ext/curl/interface.c:211: error: `CURLOPT_PASSWDFUNCTION' undeclared (first use in this function) make: *** [ext/curl/interface.lo] Error 1
make [@php-5.0.4]...(install).... Done
/home/cpapachebuild/buildapache/php-5.0.4/ext/curl/interface.c:173: error: `CURLOPT_FTPASCII' undeclared (first use in this function) /home/cpapachebuild/buildapache/php-5.0.4/ext/curl/interface.c:173: error: (Each undeclared identifier is reported only once /home/cpapachebuild/buildapache/php-5.0.4/ext/curl/interface.c:173: error: for each function it appears in.) /home/cpapachebuild/buildapache/php-5.0.4/ext/curl/interface.c:211: error: `CURLOPT_PASSWDFUNCTION' undeclared (first use in this function) make: *** [ext/curl/interface.lo] Error 1
i'm compiling php5.0.4, with default settings and Curl (Version 7.15.3), GD (Version 2.0.15), GetText, Freetype Support.
I installed internetseer.com against my server. I got this report:
Support-FAQ Advanced Monitoring 24/7 Tech Support
Now that your site is up, can anyone find it? Submit it to the Top 100 Search Engines for as little as $29.95!
Recovery Alert
Your Web Site is no longer on error
URL: [url] Time: Thu May 10 20:03:15 EDT 2007 Total Time on Error: 3 hours, 28 minutes, 17 seconds
Support-FAQ Why was your Web Site not responding? The error listed above could have been caused by any number of events including connectivity problems in the Internet. Please refer to our Error Codes for additional information on the specific error. This error is not necessarily a problem with your hosting service or Web server. Click here to learn more.
Cancel - If you no longer wish to have InternetSeer monitor your Web site, click here to cancel your account.