I have a mysql-only server and the server is constantly > 30 in server load. I'm ousted as to what is wrong with mysql and what can be done to optimize it. Using mysql report to generate the following:
Quote:
MySQL 4.1.22-standard uptime 0 0:22:30 Thu Feb 22 07:14:45 2007
__ Key _________________________________________________________________
Buffer used 30.93M of 256.00M %Used: 12.08
Current 60.41M %Usage: 23.60
Write ratio 0.891
Read ratio 0.001
I am just trying out MySQL on the external Apache server. I must have written down the wrong password. My commands to enter mysql with a password results in denied access.
What file do I undo in order to create a new password? I don't know the exact steps I'm supposed to take. I don't think this is a MySQL issue, but a server issue, right?
I used to create databases and tables on my regular computer and left off the password altogether while I was practicing. Now I'm taking steps to do it on the actual server, and have run across this problem.
mysql MySQL Support enabled Active Persistent Links 0 Active Links 0 Client API version 4.1.21 MYSQL_MODULE_TYPE external MYSQL_SOCKET /var/lib/mysql/mysql.sock MYSQL_INCLUDE -I/usr/include/mysql MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient
mysqli MysqlI Support enabled Client API library version 4.1.21 Client API header version 4.1.20 MYSQLI_SOCKET /var/lib/mysql/mysql.sock
I've a small reseller account with cPanel with 5 sites. After transfering to other host (full cPanel backup of old sites, restoring on new host) cPanel of 2 sites still displays the version number of the old host, the other 3 sites are correct.
Whats ur take on Wired Tree folks, shall i jump the ship and provide them with utter bunny mayhem (cause i am known to be intolerably insane when my server is down). How is their overall support, and network and performance ? Anyone current got "Server" from them who would like to throw some light on their performance and services ?
All I have is a big forum to host and I dont have much time to manage it - so a managed server is preferred. I also want cPanel on it.
futurehosting.biz really appealed to me but I was wondering if there was anything better, in terms of storage, bandwidth and RAM (also CPU, i dont know how much futurehosting give).
I would prefer if they had some kind of 24/7 live chat.
willing to find a cheap vps hosting provider and when l check some of the threats here , l m meeting new terms.
What is a Busrtable Ram ? How does it effect the Real Ram ? and How does it effect the cpu performance ? like page file ? l really dont know whats it means.
I have been with Blue Virtual (bluevirtual.com) for many years, since the Communitech days. However, the service these past few weeks has gone downhill big time.
The BV forums are dead, the webhosting is up and down like a yoyo, mail is intermittent.
Not just me but fellow users are experiencing the same.
Support tickets are going unanswered (accounts & tech. support).
I run a large community site, and i was wondering what the max amount of images I should have in an image folder? I'm looking to upgrade to an image only server and setup subdomain folders to split up the files. right now i have about 200k+ image files in just the public image folder... thats not counting the thumbnail folder, private folders etc...
what people think about jaguarpc I haven't been there too long yet I find the servers some what slow... or I should say VPS's there customer service is good yet I found knownhost to be better performance wise.. I just want to know what others think
We are in the process building a new colocation facility and I wanted to take some input from everyone here. We have most of the infrastructure planning and layout done but were still early on in the construction phase so now is the last chance to get some input. I have two main questions I wanted to ask.
1)When your looking for a colocation facility what things are most important to you?
2)Have you ever wished that datacenters offered something outside the normal things that most providers do.
I have never understand this? Honestly, what is the point if they all point to one web server? I mean if the web server fails it doesnt do any good if you have 10 DNS servers. The only time it makes sense to me to run multiple DNS servers is if your DNS server is a piece of junk, and always goes down, which honestly doesnt happen that much.
# 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.IFACE_IN="venet0"IFACE_OUT="venet0"
==================================
when i finish it and restart my apf its shows me like this ???
PHP Code:
[root@box ~]# apf -sapf(3107): {glob} activating firewallapf(3149): {glob} determined (IFACE_IN) venet0 has address 127.0.0.1apf(3149): {glob} determined (IFACE_OUT) venet0 has address 127.0.0.1apf(3149): {glob} loading preroute.rulesiptables: Unknown error 4294967295iptables: Unknown error 4294967295iptables: Unknown error 4294967295iptables: Unknown error 4294967295iptables: Unknown error 4294967295iptables: Unknown error 4294967295iptables: Unknown error 4294967295apf(3149): {resnet} downloading http://r-fx.ca/downloads/reserved.networksapf(3149): {resnet} download of http://r-fx.ca/downloads/reserved.networks failedapf(3149): {glob} loading reserved.networksapf(3149): {glob} SET_REFRESH is set to 10 minutesapf(3149): {glob} loading bt.rulesapf(3149): {dshield} downloading http://feeds.dshield.org/top10-2.txtapf(3149): {dshield} download of http://feeds.dshield.org/top10-2.txt failedapf(3149): {sdrop} downloading http://www.spamhaus.org/drop/drop.lassoapf(3149): {sdrop} parsing drop.lasso into /etc/apf/sdrop_hosts.rulesapf(3149): {sdrop} loading sdrop_hosts.rulesapf(3149): {glob} loading common drop portsapf(3149): {blk_ports} deny all to/from tcp port 135:139apf(3149): {blk_ports} deny all to/from udp port 135:139apf(3149): {blk_ports} deny all to/from tcp port 111apf(3149): {blk_ports} deny all to/from udp port 111apf(3149): {blk_ports} deny all to/from tcp port 513apf(3149): {blk_ports} deny all to/from udp port 513apf(3149): {blk_ports} deny all to/from tcp port 520apf(3149): {blk_ports} deny all to/from udp port 520apf(3149): {blk_ports} deny all to/from tcp port 445apf(3149): {blk_ports} deny all to/from udp port 445apf(3149): {blk_ports} deny all to/from tcp port 1433apf(3149): {blk_ports} deny all to/from udp port 1433apf(3149): {blk_ports} deny all to/from tcp port 1434apf(3149): {blk_ports} deny all to/from udp port 1434apf(3149): {blk_ports} deny all to/from tcp port 1234apf(3149): {blk_ports} deny all to/from udp port 1234apf(3149): {blk_ports} deny all to/from tcp port 1524apf(3149): {blk_ports} deny all to/from udp port 1524apf(3149): {blk_ports} deny all to/from tcp port 3127apf(3149): {blk_ports} deny all to/from udp port 3127apf(3149): {pkt_sanity} set active PKT_SANITYapf(3149): {pkt_sanity} deny inbound tcp-flag pairs ALL NONEapf(3149): {pkt_sanity} deny inbound tcp-flag pairs SYN,FIN SYN,FINapf(3149): {pkt_sanity} deny inbound tcp-flag pairs SYN,RST SYN,RSTapf(3149): {pkt_sanity} deny inbound tcp-flag pairs FIN,RST FIN,RSTapf(3149): {pkt_sanity} deny inbound tcp-flag pairs ACK,FIN FINapf(3149): {pkt_sanity} deny inbound tcp-flag pairs ACK,URG URGapf(3149): {pkt_sanity} deny inbound tcp-flag pairs ACK,PSH PSHapf(3149): {pkt_sanity} deny inbound tcp-flag pairs ALL FIN,URG,PSHapf(3149): {pkt_sanity} deny inbound tcp-flag pairs ALL SYN,RST,ACK,FIN,URGapf(3149): {pkt_sanity} deny inbound tcp-flag pairs ALL ALLapf(3149): {pkt_sanity} deny inbound tcp-flag pairs ALL FINapf(3149): {pkt_sanity} deny outbound tcp-flag pairs ALL NONEapf(3149): {pkt_sanity} deny outbound tcp-flag pairs SYN,FIN SYN,FINapf(3149): {pkt_sanity} deny outbound tcp-flag pairs SYN,RST SYN,RSTapf(3149): {pkt_sanity} deny outbound tcp-flag pairs FIN,RST FIN,RSTapf(3149): {pkt_sanity} deny outbound tcp-flag pairs ACK,FIN FINapf(3149): {pkt_sanity} deny outbound tcp-flag pairs ACK,PSH PSHapf(3149): {pkt_sanity} deny outbound tcp-flag pairs ACK,URG URGapf(3149): {pkt_sanity} deny all fragmented udpapf(3149): {pkt_sanity} deny inbound tcp port 0apf(3149): {pkt_sanity} deny outbound tcp port 0apf(3149): {blk_p2p} set active BLK_P2Papf(3149): {blk_p2p} deny all to/from tcp port 1214apf(3149): {blk_p2p} deny all to/from udp port 1214apf(3149): {blk_p2p} deny all to/from tcp port 2323apf(3149): {blk_p2p} deny all to/from udp port 2323apf(3149): {blk_p2p} deny all to/from tcp port 4660:4678apf(3149): {blk_p2p} deny all to/from udp port 4660:4678apf(3149): {blk_p2p} deny all to/from tcp port 6257apf(3149): {blk_p2p} deny all to/from udp port 6257apf(3149): {blk_p2p} deny all to/from tcp port 6699apf(3149): {blk_p2p} deny all to/from udp port 6699apf(3149): {blk_p2p} deny all to/from tcp port 6346apf(3149): {blk_p2p} deny all to/from udp port 6346apf(3149): {blk_p2p} deny all to/from tcp port 6347apf(3149): {blk_p2p} deny all to/from udp port 6347apf(3149): {blk_p2p} deny all to/from tcp port 6881:6889apf(3149): {blk_p2p} deny all to/from udp port 6881:6889apf(3149): {blk_p2p} deny all to/from tcp port 6346apf(3149): {blk_p2p} deny all to/from udp port 6346apf(3149): {blk_p2p} deny all to/from tcp port 7778apf(3149): {blk_p2p} deny all to/from udp port 7778apf(3149): {glob} loading log.rulesapf(3149): {glob} virtual net subsystem disabled.apf(3149): {glob} loading main.rulesapf(3149): {glob} opening inbound tcp port 20 on 0/0apf(3149): {glob} opening inbound tcp port 21 on 0/0apf(3149): {glob} opening inbound tcp port 22 on 0/0apf(3149): {glob} opening inbound tcp port 25 on 0/0apf(3149): {glob} opening inbound tcp port 53 on 0/0apf(3149): {glob} opening inbound tcp port 80 on 0/0apf(3149): {glob} opening inbound tcp port 110 on 0/0apf(3149): {glob} opening inbound tcp port 143 on 0/0apf(3149): {glob} opening inbound tcp port 443 on 0/0apf(3149): {glob} opening inbound tcp port 465 on 0/0apf(3149): {glob} opening inbound tcp port 993 on 0/0apf(3149): {glob} opening inbound tcp port 995 on 0/0apf(3149): {glob} opening inbound tcp port 8443 on 0/0apf(3149): {glob} opening inbound udp port 37 on 0/0apf(3149): {glob} opening inbound udp port 53 on 0/0apf(3149): {glob} opening inbound udp port 873 on 0/0apf(3149): {glob} opening outbound tcp port 20 on 0/0apf(3149): {glob} opening outbound tcp port 21 on 0/0apf(3149): {glob} opening outbound tcp port 22 on 0/0apf(3149): {glob} opening outbound tcp port 25 on 0/0apf(3149): {glob} opening outbound tcp port 53 on 0/0apf(3149): {glob} opening outbound tcp port 37 on 0/0apf(3149): {glob} opening outbound tcp port 43 on 0/0apf(3149): {glob} opening outbound tcp port 80 on 0/0apf(3149): {glob} opening outbound tcp port 113 on 0/0apf(3149): {glob} opening outbound tcp port 443 on 0/0apf(3149): {glob} opening outbound tcp port 465 on 0/0apf(3149): {glob} opening outbound tcp port 873 on 0/0apf(3149): {glob} opening outbound tcp port 5224 on 0/0apf(3149): {glob} opening outbound udp port 53 on 0/0apf(3149): {glob} opening outbound udp port 873 on 0/0apf(3149): {glob} opening inbound icmp type 3 on 0/0apf(3149): {glob} opening inbound icmp type 5 on 0/0apf(3149): {glob} opening inbound icmp type 11 on 0/0apf(3149): {glob} opening inbound icmp type 0 on 0/0apf(3149): {glob} opening inbound icmp type 30 on 0/0apf(3149): {glob} opening inbound icmp type 8 on 0/0apf(3149): {glob} opening outbound icmp all on 0/0iptables: Unknown error 4294967295iptables: Unknown error 4294967295iptables: Unknown error 4294967295iptables: Unknown error 4294967295iptables: Unknown error 4294967295apf(3149): {glob} resolv dns discovery for 207.218.192.38iptables: Unknown error 4294967295iptables: Unknown error 4294967295iptables: Unknown error 4294967295iptables: Unknown error 4294967295iptables: Unknown error 4294967295iptables: Unknown error 4294967295iptables: Unknown error 4294967295iptables: Unknown error 4294967295iptables: Unknown error 4294967295iptables: Unknown error 4294967295iptables: Unknown error 4294967295apf(3149): {glob} loading postroute.rules
I'm just looking for some background information or a place where I can learn more about this.
Here's the problem:
The web site runs on a dedicated Apache server. There's 2 SSL certificates installed, one for e-commerce for https://www.mysite.com and one to help with the administrative interface for https://admin.mysite.com. I run a custom php application that forces the web page from http://www.mysite.com to https://www.mysite.com when going to an e-commerce page.
Generally everything runs Ok but a few times this year there has been a problem where the php application points to https://www.mysite.com/ecom.php but instead it gets https://admin.mysite.com/ecom.php and gets a page not found.
In discussing this with my web hosting company they claim they haven't changed anything but they do manage to fix the problem and get the web site working correctly again.
I generally figure that the web hosting company has done some type of maintenance on the web server and messed-up the dns entries or something for the SSL part of the web site but this is really outside my area of experience. I'm trying to understand what went wrong and where the entries are that determine when going to SSL which SSL certificate/URL is used.
My server with APF (firewall script) with BFD logs over 1215 events today of some hack user or bot trying to login to my server from various of IP trying many kind of usernames...
Is it possible to customize BFD to automatically ban the IP directly if the username they try to login with it was wrong 2 times?
For example the username is qwerty The hack is trying with many usernames john, root, master, boot, etc...
A friend of mine has a server that the provider claims is a Core2Duo, but looking at /proc/cpuinfo, the cpu is shown as:
Intel(R) Pentium(R) D CPU 000 @ 1.86GHz
What would cause this? I'm not saying the host is lying, I've just never seen this before and I haven't found anyone else with this problem on google. The processor is supposed to be a e6300, so the 1.86GHz speed is right. Also, this has happened on 2 different linux distros.
I've been told by a few people that something's wrong with my nameservers. But I'm not sure what it is that's wrong.
the site => www.visualpoetry.ca
the DNSs: ns1.visualpoetry.ca / ns2.visualpoetry.ca
a zone check says:
Quote:
---- warning ---- w: Nameservers are all part of the same AS
* Adv: ZoneCheck
To avoid loosing all connectivity with the autoritative DNS in case of a routing problem inside your Autonomous System, it is advised to host the DNS on different AS.
* All the nameservers are part of the same Autonomous System (AS number 30058), try to have some of them hosted on another AS.
* generic
w: Host doesn't reply to ICMP requests (firewall?)
I have bought a dedicated server with FDC servers and installed a script. Initially everything was working fine but now the site is not accessible. Everything is alright with the script installed but looks like there is some issue with the DNS settings. When I ping the IP address (it's dedicated ip address) it gives me an error. When I Ping the domain name, it just closes the window after few mins. Can someone experienced with WHM help me to fix the DNS settings? Of course, I am ready to pay for your help (though i might not have a very higher budget)
add In httpd.conf to virtual őîńňó for instance: LayoutHeader "<H1>Test</H1>"
the text appears, but not there where it is necessary:
<H1>TEST</H1> ........ <head> <title>title</title> <meta http-equiv="Content-Type" content="text/html; charset==utf-8"/> </head> <body> the text of the site.....
That is required? It is Necessary ÷ňîá was removed so:
I've noticed in a few unrelated traceroutes from my dedicated server the error message shown below. Is this likely to be an issue with my provider or just a general backbone issue? It seems to show up after 4 or 5 hops on routers belonging to a number of different backbone providers.
More importantly does it indicate that there is packet loss/corruption on the line?
Code: # traceroute www.cisco.com traceroute to www.cisco.com (198.133.219.25), 30 hops max, 46 byte packets 1 XXX.XXX.XXX.XXX (XXX.XXX.XXX.XXX) 0.354 ms 0.294 ms 0.289 ms 2 66.154.95.219 (66.154.95.219) 0.486 ms 0.362 ms * 3 216.89.82.73 (216.89.82.73) 1.353 ms 1.047 ms 0.815 ms 4 dcr1-so-4-3-0.Atlanta.savvis.net (208.172.75.109) 2.617 ms 3.605 ms * 5 cw-gw.attga.ip.att.net (192.205.32.117) 2.892 ms 1.138 ms 1.178 ms Icmp checksum is wrong 6 tbr2.attga.ip.att.net (12.122.81.154) 55.510 msIcmp checksum is wrong 55.077 msIcmp checksum is wrong 55.550 ms Icmp checksum is wrong 7 tbr1.dlstx.ip.att.net (12.122.2.89) 54.579 msIcmp checksum is wrong 55.069 msIcmp checksum is wrong 54.964 ms Icmp checksum is wrong 8 tbr1.la2ca.ip.att.net (12.122.10.50) 55.622 msIcmp checksum is wrong 55.462 msIcmp checksum is wrong 56.408 ms 9 gar1.sj2ca.ip.att.net (12.122.2.249) 53.999 ms 54.947 ms 53.960 ms 10 12.118.124.10 (12.118.124.10) 54.596 ms 54.329 ms 54.727 ms 11 sjce-dmzbb-gw1.cisco.com (128.107.239.53) 58.822 ms 68.721 ms 79.009 ms