Starting Mysqld With The --skip-name-resolve
Apr 19, 2007How can we start mysqld with --skip-name-resolve? Syntax Or Command?
View 7 RepliesHow can we start mysqld with --skip-name-resolve? Syntax Or Command?
View 7 Repliesif I should continue paying an extra $25 per month for Cpanel. Is it that hard to do without it? All I really do with Cpanel is configure Spamassassin, setup emails, and backups.
View 5 Replies View Relatedthe load of my server is high,
i login whm and check the CPU/Memory/MySQL Usage
User Domain %CPU %MEM MySQL Processes
mysql 3.30 45.97 0.0
Top Process %CPU 1.0 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/hostname.com.pid --skip-locking
Top Process %CPU 0.7 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/hostname.com.pid --skip-locking
Top Process %CPU 0.6 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/hostname.com.pid --skip-locking
the values are higher before,
i want to ask what is skip-locking and if i add skip-locking in my.cnf,
will the problem been improved? and will it take any effect or problem?
Do yo uguys know how to skip CLAMD and SPAMD on local emails on cpanel server?
our clietns send emails internall too crazily, running clamd and spamd cause high load often
Does anybody know a painless way to make webmail.mydomain.com go straight to the Squirrel Mail login page, bypassing the www.mydomain.com:2095 page?
Or is there a way to use that page, but go straight to the user's Squirrel Mail page?
Can I delete mysqld.log
Can I delete or empty mysqld.log
Its currently 850MB
If I can do I have to stop MYSQL first;?
I just bought new DS 3 days ago : Intel Core2Duo 2.33 GHz, 2GB DDR2 RAM , 250 GB.
Today mysql automatic stop and not auto restart :|
I checked cron job: has no cron job there. I have just only one site on this server.
I check Check mysql error log:
081115 10:47:52 [Note] /usr/sbin/mysqld: Normal shutdown
081115 10:47:52 InnoDB: Starting shutdown...
081115 10:47:54 InnoDB: Shutdown completed; log sequence number 0 72782
081115 10:47:54 [Note] /usr/sbin/mysqld: Shutdown complete
081115 10:47:54 mysqld ended
081115 10:47:55 mysqld started
/usr/sbin/mysqld: File '/var/log/mysql-slow-queries.log' not found (Errcode: 13)
081115 10:47:55 [ERROR] Could not use /var/log/mysql-slow-queries.log for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
081115 10:47:55 InnoDB: Started; log sequence number 0 72782
081115 10:47:56 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)
my.cnf file ....
I've got a strange situation here. We have some software which we run on multiple servers. As of today the software is using 100 percent (sometimes more) of the cpus.
Here is the result from top. It's usually far worse using 100 percent of both cpu's almost all of the time. I just restarted, but the server load is climbing to 20+. Any idea how I can figure out what is going on? The same software on two other identically configured servers runs fine. This server has had no problems for over 6 months, but suddenly this started today. The server is a dual opteron with 4GB of ram. The databases are innodb thus the high memory usage for mysql (innodb buffer pool size)
top - 13:52:54 up 3:14, 2 users, load average: 3.39, 4.42, 6.86
Tasks: 121 total, 4 running, 108 sleeping, 9 stopped, 0 zombie
Cpu(s): 66.1% us, 1.7% sy, 32.2% ni, 0.0% id, 0.0% wa, 0.0% hi, 0.0% si
Mem: 4090568k total, 3077004k used, 1013564k free, 52748k buffers
Swap: 2096440k total, 56k used, 2096384k free, 1796632k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
11871 mysql 15 0 2581m 1.0g 3844 S 96 26.2 13:05.73 mysqld
7569 root 39 19 8048 2024 1304 R 65 0.0 32:27.49 http
11984 apache 15 0 152m 14m 5860 S 12 0.4 0:24.27 httpd
11990 apache 15 0 152m 17m 8376 S 9 0.4 0:14.31 httpd
12002 apache 16 0 153m 15m 5408 R 6 0.4 0:08.60 httpd
12040 apache 15 0 152m 17m 8524 S 5 0.4 0:03.86 httpd
11966 apache 15 0 153m 17m 8280 S 3 0.4 0:22.99 httpd
I'm setting a local server on my network. Leopard 10.5.6
I went to mysql.com and installed the intel 32-bit version of mysql (package).
After install, i try to run mysqladmin command, but it returns command not found.
I search the location using
which mysql
nothing returns.
I find the install here:
/usr/local/mysql-5.1.34-osx10.5-x86/bin
even when i check the file and its there, running the command returns
mysqladmin: command not found
My server was having a high load so I stop httpd and mysqld. I tried to restart both service but only httpd is starting and mysqld failed. It keeps timing out.
service mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]
It was working and I only trying to restart it.
The load on my server now is 0 because the website is down.
we have set logrotate for rotate mysqld.log daily
file is compress, deleted and created from logrotate but mysql not write anything
Any idea about why?
I have 3 questions.
1.) I have a user that's kinda knows a lot about linux. More than me. He has a lot of stuff on the system which I have no idea what it is. Is there any way I can install a SSH log, so I can monitor what he does in shell?
2.) My server seems REALLY sluggish. I ran a top in shell, and mysqld was taking up from 70% to 110% of the cpu. Is there any way to fix this or find out why? I've restarted the server, and it's fluctuating between 50% and 90% now.
3.) I think this MIGHT be related to the sqld issue, but I've received about 12 emails saying
Quote:
"[statscheck] Stats/Server Overload on my server". "MPORTANT: Do not ignore this email.
This is cPanel stats runner on server1.cewxp.com!
While processing the log files for user cewxp, the cpu has been
maxed out for more than a 6 hour period. The current load/uptime line on the server at the time of this email is 15:49:16 up 5 days, 10:52, 2 users, load average: 27.59, 31.36, 31.83"
and also another email
Quote:
IMPORTANT: Do not ignore this email.
This is cPanel stats runner on server1.cewxp.com!
While processing the log files for user vegapunk, the cpu has been maxed out for more than a 6 hour period. The current load/uptime line on the server at the time of this email is 12:34:26 up 5 days, 7:37, 2 users, load average: 19.90, 17.59, 17.97
What is the best, stable and free dns resolver ips for shared hosting servers?
View 4 Replies View RelatedI am new to the dedicated servers. I have just upgraded myself to a dedicated machine.
I am getting error "couldnt resolve host" at every domain name when I type like
wget http://google.com
wget http://yahoo.com
I searched over internet and found some people telling that I should put nameserver to /etc/resolv.conf?
nameserver <ip here>
nameserver <ip here>
I dont know what IP to put here or if it is a solution to my problem.
I hope your day is going good. I've been trying to fix a problem I had all week. I receive daily email notification that "example.[url]" does not resolve to any IP. However, when in WHM, it already contains Server Main Ip: 208.53.183.125. I've tried a few solutions from the web, but to no avail:
IMPORTANT: Do not ignore this email.
The hostname (example.mydomainname.com) resolves to . It should resolve to 208.53.183.125. Please be sure to correct /etc/hosts as well as the 'A' entry in zone file for the domain.
Some are all of these problems can be caused by
/etc/resolv.conf being setup incorrectly. Please check this file if you
believe everything else is correct.
You may be able to automaticly correct this problem by using the
'Add an A entry for your hostname' under 'Dns Functions'
in your Web Host Manager
1) Within WHM, I have the following:
-Add an A entry for your hostname (I only have one listed)
Hostname: example.mydomainname.com
Server Main Ip: 208.53.183.125
-Primary/secondary nameserver
Primary Nameserver: ns1.mydomainname.com (A entry = 208.53.181.26)
Secondary Nameserver: ns2.mydomainname.com (A entry = 208.53.181.27)
-Resolver Configuration
Primary Resolver: 66.90.68.25
Secondary Resolver: 66.90.68.26
-Additional IP my webhost gave me to use:
208.53.181.26 (used in primary name server)
208.53.181.27 (used in secondary name server)
208.53.181.28
-Current DNS Zone listing:
example.com (my website URL that is currently working)
example.mydomainname.com (hostname I made myself that contains the server main IP)
ns1.mydomainname.com (A entry = 208.53.181.26)
ns2.mydomainname.com (A entry = 208.53.181.27)
2) My edit "edit /etc/resolv.conf" contains the following:
Search localdomain
nameserver 66.90.68.25
nameserver 66.90.68.26
Issue: I receive daily email notification that "example.mydomainname.com" does not resolve to any IP. However, when in WHM, it already contains Server Main Ip: 208.53.183.125.
I've been having this problem for a while now. I have a dedicated linix server running with the cpanel. I've setup my own nameservers and for the most part it all runs without a problem. However, every now and then the domains will not resolve for many people.
This may only last a few minutes but it happens regularly. There doesn't seem to be any pattern. The server is still available via IP address. Also, any domain name set as a nameserver with the registrar is not affected by this problem. All other domains are affected. This problem has persisted over many cpanel updates.
I have gone through all the nameserver files (I can think of or have read about) looking for something that may be causing this but everything looks normal.
I have nameservers setup on my server. As I have changed my servers, I need to resolve the sites. I changed the nameservers Ips to resolve to new one:
67.159.33.250 and 67.159.33.251
But my sites and my clients sites are going down.
[url]
And similar report by dnsreport is being given saying that NS didnt responded timely.
I have installed WHM 11 on centos 5.3.
Currently I get problems that domains at certain places not open.
Like e.g I write my server IP XXX.XXX.XXX.XXX it works fine and I get ping reply also, but at the same time I write [url]it would not resolve.
Similarly in web browser I write server IP it gives cpanel page but on same computer I write [url]I get page cannot be opened, when I refresh the page at certain times then it would open. Now once it is opened in the same computer it would work fine here.
In some internet connections it works fine i.e no problems, in some connections get similar problems that domains does not resolve properly.
I checked my named service works fine.
I've got several subdomains on the ethoshosting.com server, but I recently created a subdomain (the same way as before) and it doesn't resolve
The dig command run through shell works. DNS records seem to be setup. I restarted the DNS and even the http server.
What gives? (it was a WHM setup via whmcs)
how do i speed up dns resolving my website. It is taking much time about 5-8 seconds. My site is phpfavorites.com
usually when i type youtube.com and like other websites, those sites load much faster than anything. Is this dns or any other issue>
the DNS Server never resolves, i create one account on my server, i put the nameservers... about 6 Hours ago and nothing, i setup the Domain DNS and nothing, what can be? how i can fix this?
I have a Dedicated Server (Xeon 2.8 | 1 GB Ram)
OS: Fedora 6
I can't resolve hosted domains on ssh or via php on my server. All of other domains fine when i dig or ping but mine is not.
I did run fix scripts for dns and restarted named but result is still same.
Also, when i try to reach one of my domains via php's fsockopen function, i get "65 No route to host" or "68 Too many users" error.
My VPS was a clean build 2 weeks ago and so far i have installed cpanel and configured everything and added accounts. I began that one of my scripts that uses gethostbyaddr($ip) was failing to resolve any of the ip's it received. I made another PHP file to test this, with this code:
PHP Code:
<?phpecho file_get_contents[url];?>
Resulting in:
Warning: file_get_contents() [function.file-get-contents]: php_network_getaddresses: getaddrinfo failed: Name or service not known
The thing is, the VPS is resolving domains just fine
I can ping, send emails, even dig:
Code:
[root@server etc]# dig google.com
; <<>> DiG 9.2.4 <<>> google.com
;; global options: printcmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 34548
;; flags: qr rd ra; QUERY: 1, ANSWER: 3, AUTHORITY: 4, ADDITIONAL: 4
;; QUESTION SECTION:
;google.com. IN A
;; ANSWER SECTION:
google.com. 300 IN A 64.233.167.99
google.com. 300 IN A 64.233.187.99
google.com. 300 IN A 72.14.207.99
;; AUTHORITY SECTION:
google.com. 343652 IN NS ns2.google.com.
google.com. 343652 IN NS ns3.google.com.
google.com. 343652 IN NS ns4.google.com.
google.com. 343652 IN NS ns1.google.com.
;; ADDITIONAL SECTION:
ns1.google.com. 343143 IN A 216.239.32.10
ns2.google.com. 343143 IN A 216.239.34.10
ns3.google.com. 343143 IN A 216.239.36.10
ns4.google.com. 343143 IN A 216.239.38.10
;; Query time: 62 msec
;; SERVER: 83.149.80.123#53(83.149.80.123)
;; WHEN: Tue Jul 24 04:49:35 2007
;; MSG SIZE rcvd: 212
I have no clue what's up, and i think there must be a guru here that has an idea of what is going on?
Yesterday we registerd and created 2 domains in our server.
Everything is ok, files uploaded, dns zones created, httpd virtual host created...
The problem is that trying to browse the site trough http://www.site.com redirects me to [url] my main server IP address, this page shows a cPanel Welcome message.
But, using [url], the site is loaded ok, withouth any problems.
DNS zone shows:
Code:
; cPanel 11.11.0-BETA_16977
; Zone file for site.com
$TTL 14400
@ 86400 IN SOA mydns1.wolo.com. admin.hostingserver.com. (
2007092601 ; serial, todays date+todays
86400 ; refresh, seconds
7200 ; retry, seconds
3600000 ; expire, seconds
86400 ) ; minimum, seconds
site.com. 86400 IN NS mydns1.wolo.com.
site.com. 86400 IN NS mydns2.wolo.com.
site.com. IN A IP_ADDRESS
localhost.site.com. IN A 127.0.0.1
site.com. IN MX 0 site.com.
mail IN CNAME site.com.
www IN A IP_ADDRESS
ftp IN A IP_ADDRESS
Apache virtual host code
Code:
<VirtualHost IP_ADDRESS>
ServerAlias www.site.com
ServerAdmin webmaster@site.com
DocumentRoot /home/siteuser/public_html
ServerName site.com
<IfModule mod_suphp.c>
suPHP_UserGroup siteuser siteuser
</IfModule>
<IfModule mod_php4.c>
php_admin_value open_basedir "/home/siteuser:/usr/lib/php:/usr/local/lib/php:/tmp"
</IfModule>
<IfModule mod_php5.c>
php_admin_value open_basedir "/home/siteuser:/usr/lib/php:/usr/local/lib/php:/tmp"
</IfModule>
User siteuser
Group siteuser
BytesLog /usr/local/apache/domlogs/site.com-bytes_log
CustomLog /usr/local/apache/domlogs/site.com combined
Options -ExecCGI -Includes
</VirtualHost>
I set up a domain in plesk 8 (LAMP), but the www version of the domain doesn't resolve via the browser, wheras the non-www version does. I set the nameservers (and glue records) yesterday.
Why might this be? Could this be due to dns propagation?
i use centos based server. yesterday everything was OK. but now, when i connect via SSH, my server can't resolve hosts. wget, ping, or curl don't work. also i use VNC to remote desktop. when try to open a page via firefox, it says server not found.
View 1 Replies View Relatedon my server i have 104 accounts and the MySQL Usage for th cpus is 25.23
like this pic [url] is that danger? and how can i resolve it?
I have come accross an issue with DNS in cpanel 11.x , where named.conf is badly configured by cpanel ,
Here is how a DNS report from dnsstuff.com would look because of this :
FAILS for SOA record
Fails for lame nameservers .
Here's how to fix it ,
SSH to server ,
Backup your named.conf file by
cp /etc/named.conf named.conf.back
then
pico /etc/named.conf
Replace
Code:
include "/etc/rndc.key";
controls {
inet 127.0.0.1 allow { localhost; } keys { "rndc-key"; };
};
options
{
/* make named use port 53 for the source of all queries, to allow
* firewalls to block all ports except 53:
*/
query-source port 53;
// Put files that named is allowed to write in the data/ directory:
directory "/var/named"; // the default
dump-file "data/cache_dump.db";
statistics-file "data/named_stats.txt";
memstatistics-file "data/named_mem_stats.txt";
};
logging
{
/* If you want to enable debugging, eg. using the 'rndc trace' command,
* named will try to write the 'named.run' file in the $directory (/var/named).
* By default, SELinux policy does not allow named to modify the /var/named directory,
* so put the default debug log file in data/ :
*/
channel default_debug {
file "data/named.run";
severity dynamic;
};
};
// All BIND 9 zones are in a "view", which allow different zones to be served
// to different types of client addresses, and for options to be set for groups
// of zones.
//
// By default, if named.conf contains no "view" clauses, all zones are in the
// "default" view, which matches all clients.
//
// If named.conf contains any "view" clause, then all zones MUST be in a view;
// so it is recommended to start off using views to avoid having to restructure
// your configuration files in the future.
view "localhost_resolver"
{
/* This view sets up named to be a localhost resolver ( caching only nameserver ).
* If all you want is a caching-only nameserver, then you need only define this view:
*/
match-clients { localhost; };
match-destinations { localhost; };
recursion yes;
zone "." IN {
type hint;
file "/var/named/named.ca";
};
/* these are zones that contain definitions for all the localhost
* names and addresses, as recommended in RFC1912 - these names should
* ONLY be served to localhost clients:
*/
include "/var/named/named.rfc1912.zones";
};
view "internal"
{
/* This view will contain zones you want to serve only to "internal" clients
that connect via your directly attached LAN interfaces - "localnets" .
*/
match-clients { localnets; };
match-destinations { localnets; };
recursion yes;
zone "." IN {
type hint;
file "/var/named/named.ca";
};
// include "/var/named/named.rfc1912.zones";
// you should not serve your rfc1912 names to non-localhost clients.
// These are your "authoritative" internal zones, and would probably
// also be included in the "localhost_resolver" view above :
};
view "external"
{
/* This view will contain zones you want to serve only to "external" clients
* that have addresses that are not on your directly attached LAN interface subnets:
*/
match-clients { !localnets; !localhost; };
match-destinations { !localnets; !localhost; };
recursion no;
// you'd probably want to deny recursion to external clients, so you don't
// end up providing free DNS service to all takers
// all views must contain the root hints zone:
zone "." IN {
type hint;
file "/var/named/named.ca";
};
// These are your "authoritative" external zones, and would probably
// contain entries for just your web and mail servers:
// BEGIN external zone entries
With
Code:
include "/etc/rndc.key";
controls {
inet 127.0.0.1 allow { localhost; } keys { "rndc-key"; };
};
And then goto bottom of the file and remove
}; at the bottom .
Save file and exit
then test config
service named configtest
if you have done this correctly , it should display something like this:
zone blue.xxx.com/IN: loaded serial 2007070901
zone xxx.com/IN: loaded serial 2007070906
zone ns1.xxx.com/IN: loaded serial 2007070901
zone server.xxx.com/IN: loaded serial 2007071001
zone xxx.net/IN: loaded serial 2007071001
Then restart named by
service named restart
your DNS should be working now .
my server seems to have lost its ability to do name lookups:
Quote:
[root@cp ~]# wget =>`ossec-hids-2.0.tar.gz'
Resolving failed: Temporary failure in name resolution.
it hangs on the "Resolving bit for a long time.
my resolv.conf file is as follows:
Quote:
nameserver 66.90.68.16
nameserver 66.90.68.26
which are the 2 nameservers of my datacenter.
I tried doing a /scripts/upcp --force and I get this:
Quote:
[root@cp ~]# /scripts/upcp --force
Updating /scripts...
Sync Source:
and it just hangs there
the sites I am hosting use PHP script that make a lot of outbound web connections so this is crippling my server