On my new unmanaged VPS i keep getting mass emails sent to me saying -
iptables v1.2.11: can't initialize iptables table `filter': iptables who? (do you need to insmod?)
Perhaps iptables or your kernel needs to be upgraded.
Im a bit of a n00b when it comes to unmanaged servers, just wondering if anyone knows whats wrong and how to fix.
my site is working fine for somedays and suddenly its stoped and hanged and also my PPP is not working , and file manager in PPP its give me this error
VZAgent returns error #422: "Cannot initialize connection to remote host"
and the suppord admin said I have problem in failcnt
[root@server ~]# cat /proc/user_beancounters
Version: 2.5
uid resource held maxheld barrier limit failcnt
1592: kmemsize 18353610 18355203 65536000 65536000 0
lockedpages 0 0 256 256 0
privvmpages 166455 171964 262144 262144 119810
shmpages 4885 4885 131072 131072 0
dummy 0 0 2147483647 2147483647 0
numproc 150 150 600 600 0
physpages 101554 108439 0 2147483647 0
vmguarpages 0 0 196608 196608 0
oomguarpages 101554 108439 196608 196608 0
numtcpsock 141 141 600 600 0
numflock 7 8 300 330 0
numpty 1 1 16 16 0
numsiginfo 0 1 384 384 0
tcpsndbuf 2350036 2625064 32768000 36864000 0
tcprcvbuf 2310144 2129920 32768000 36864000 0
othersockbuf 32976 573000 32768000 36864000 0
dgramrcvbuf 0 4284 1024000 1024000 0
numothersock 32 32 600 600 0
dcachesize 642510 653661 8192000 8192000 0
numfile 2636 2663 20000 20000 0
dummy 0 0 0 0 0
dummy 0 0 0 0 0
dummy 0 0 0 0 0
numiptent 228 228 700 700 0
I want to know what is my ram site and why that all errors?
I am attempting to install Apache HTTPD on a PC running Windows 7 Ultimate SP1.
VC9, VC10 & VC11 redistributables are installed.
When I attempt to start Apache - both from the command line and as a service - I receive the following error messages:
[Tue Aug 27 15:33:27.624800 2013] [mpm_winnt:notice] [pid 5192:tid 284] AH00455: Apache/2.4.6 (Win64) configured -- resuming normal operations
[Tue Aug 27 15:33:27.626800 2013] [mpm_winnt:notice] [pid 5192:tid 284] AH00456: Apache Lounge VC11 Server built: Jul 15 2013 20:45:22
[Tue Aug 27 15:33:27.626800 2013] [core:notice] [pid 5192:tid 284] AH00094: Command line: 'C:Apache24inhttpd.exe -d C:/Apache24'
[Tue Aug 27 15:33:27.667800 2013] [mpm_winnt:notice] [pid 5192:tid 284] AH00418: Parent: Created child process 7684
[Tue Aug 27 15:33:27.668800 2013] [mpm_winnt:debug] [pid 5192:tid 284] mpm_winnt.c(422): AH00402: Parent: Sent the scoreboard to the child
[Tue Aug 27 15:33:27.704800 2013] [:crit] [pid 7684] (-2146173818)Unknown error: AH00141: Could not initialize random number generator
[Tue Aug 27 15:33:27.709800 2013] [mpm_winnt:crit] [pid 5192:tid 284] AH00419: master_main: create child process failed. Exiting.
[Tue Aug 27 15:33:27.710800 2013] [core:info] [pid 5192:tid 284] AH00096: removed PID file C:/Apache24/logs/httpd.pid (pid=5192)
The Windows event viewer merely says that HTTPD stopped with an application-specific error #1.
I have also tried with SSL both enabled and commented out.
For what it is worth the message appears to be generated by the routine ap_init_rng in the server core.c module.
I am receiving below email everyday ....
Subject : Cron <aioftp@main> /usr/bin/php -q /var/www/vhosts/domain.com/subdomains/somedir/httpdocs/dir/cron.php
Failed loading /usr/lib64/php/modules/ioncube_loader_lin_5.4.so: /usr/lib64/php/modules/ioncube_loader_lin_5.4.so: cannot open shared object file: No such file or directory
PHP Warning: Module 'soap' already loaded in Unknown on line 0
PHP Warning: PHP Startup: XCache: Unable to initialize module
Module compiled with module API=20090626
PHP compiled with module API=20100525
These options need to match
in Unknown on line 0
I execute the following commands, in the following order:
iptables --flush
iptables --zero
iptables -A INPUT -s 218.65.12.161 -j DROP
will that last command successfully ban that IP until reboot?
If not, what needs to be done? I can't access my site if I don't flush + zero iptables first but I need to be able to ban with iptables.
Today i need to run "OPTIMIZE TABLE" from MySQLTuner recommendation.
Now i don't know how to run it ? I try to put in SQL Query via phpmyadmin and:
SQL query:
OPTIMIZE TABLE
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Can i expect a 7204VXR NPE-300 router with 256Meg to hold a full BGP table?
Would it be possible to hold to full BGP tables (multihoming) with a NPE-400 with 512Meg?
I have a site running on vps and the attachment table got crashed , I am unable to repair it :
thesymbi_vb.attachment
error : Not enough memory for blob at 605100 (need 6315809)
warning : Number of rows changed from 4 to 3081
status : OK
This is result of repairing from WHM, how to repair it?
i have update my.cnf with the following configuration and now i have a lor of customer that have lost him table, seem that this configuration have delete in random .Myi files, i would put this my.cnf also on others server but i would undestand which setting in this .cnf make problem for the table.
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
#skip-networking
safe-show-database
query_cache_limit=1M
query_cache_size=96M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections=200
max_connections=500
interactive_timeout=10
wait_timeout=20
connect_timeout=20
thread_cache_size=128
key_buffer=384M ## 128MB for every 1GB of RAM
join_buffer=1M
max_connect_errors=20
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=3M ## 1MB for every 1GB of RAM
read_buffer_size=3M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=3M ## 1MB for every 1GB of RAM
thread_concurrency=2 ## Number of CPUs x 2
myisam_sort_buffer_size=64M
server-id=1
log_slow_queries=/var/log/mysql-slow-queries.log
long_query_time=2
collation-server=latin1_general_ci
[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=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeout
mysql: Copying to tmp table, what causes that?
My server is majorly overloading and mysql is atop the cpu, and when I do a processlist there are about 20 copying to tmp table processes.
I have a table that is showing
MySQL Error: 145 (Table './dollarpt_ptc/flinks' is marked as crashed and should be repaired)
I've repaired it via
mysqlcheck --repair --all-databases
that didn't work. I've tried
find /var/lib/mysql/* -name *MYI |xargs myisamchk -o -r
as well with no luck.
I then dropped the table and I still get the message. I know it's using the correct database, so any help would be appreciated.
It's like there is a table where this data is kept, but I've looked and can't find anything.
Table '231_message' is marked as crashed and should be repaired
I haven't ever had this happen, is all my data truely lost or can i 'repair' it
i was moving sites to a different server (VPS -> dedicated) and on the vps i have a max of 20gb storage, well as i was using the cpanel transfer it filled this up because it didnt have a warning about this (i dont accept blame )
either way it seemed at this time someone on my site tried to make an adjustment to the table and it crashed it since there wasnt room? i really need to get this fixed asap so I can properly move this site with a working database
I have a sql backup and I just want to restore the attachment table from it! , can anyone explain me how to do so?
View 4 Replies View RelatedI optimized a mysql table of 2 million records and about 500MB.. it took about 15 minutes.. However, on the same DB now i have another huge table of 88 million records, it size is 2.2 GB and it has about 30 MB to optimize... my questions..
1.- How can I speed up the optimization process so it can take the less possible time? any tweaks to my.cnf?
2.- Should I repair it using phpmyadmin or just from the shell?
3.- Should I stop http traffic during this optimization?
This is a dedicated db mysql server that handles a large VB forum with 5-8 users online average:
Code:
Intel Xeon 3.2 x4 procs, 32 bits, 4 GB ram
/etc/my.cnf
Code:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
skip-bdb
query_cache_limit=1M
query_cache_size=48M
query_cache_type=1
max_connections=1200
interactive_timeout=100
wait_timeout=300
connect_timeout=10
thread_cache_size=128
key_buffer=48M
join_buffer=8M
max_allowed_packet=16M
table_cache=2036
sort_buffer_size=1M
read_buffer_size=1M
read_rnd_buffer_size=2M
max_connect_errors=10
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=4
myisam_sort_buffer_size=64M
# Add
max_heap_table_size = 48M
tmp_table_size = 48M
low_priority_updates=1
concurrent_insert=2
[mysqldump]
quick
max_allowed_packet=16M
[mysql.server]
user=mysql
#basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
log-slow-queries=/var/log/slow-queries.log
On the other side, i have the same hardware for the webserver..
I accidentally deleted the columns_priv table in mysql database. How can I bring it back can anyone show me the structure of that table so I can build it back.
View 4 Replies View RelatedI have a server with many db on mysql 5
Any db contains 5 table with data
This data is processed by routine
Many time routine die with the error:
"Incorrect key file for table '/var/tmp/#sql_3018_0.MYI'; try to repair it"
The table sql_3018_0.MYI not exist, think that this is refered to a temporary table but is deleted by process..
From Linux Shell, I need to back up a mysql database, JUST the data, NO Table information. Which options in mysqldump do I use?
View 14 Replies View Relatedwhat I can do about the following database error in mysql?
Incorrect key file for table '/tmp/#sql_(number of table.MYI); try to repair it
I've repaired, optimized and checked the database in phpmyadmin. Initially 2 tables were showing overhead, but the error message is for a temp table and I'm not sure how to try to repair a temp table.
I have a script and there are some modifications that I want to make
In the instructions it says ALTER TABLE and CREATE TABLE in myqsl but I dont know exactly how to do this.
I have tried to google but everything i find is very technical and doesnt explain the easiest way to do it.
Should I use phpmyadmin or whats the correct way?
I am unable to mount the 2nd disk's extended partition. Please help.
Commands I tried and returns....
Quote:
mount -t ext2 /dev/hdd2 /second
mount: wrong fs type, bad option, bad superblock on /dev/hdd2,
missing codepage or other error
In some cases useful info is found in syslog - try
dmesg | tail or so
Quote:
mount -t ext3 /dev/hdd2 /second
mount: wrong fs type, bad option, bad superblock on /dev/hdd2,
missing codepage or other error
In some cases useful info is found in syslog - try
dmesg | tail or so
Also I tried to add it to /etc/fstab but it says the same error, Disk /dev/hdd2 doesn't contain a valid partition table... I am able to mount /dev/hdd1 successfully.
In the forum [url]suddenly we got Internal Server Error. Our host claims it is because of corrupted database accorind the logs:
081128 11:44:38 [ERROR] Got error 126 when reading table './lykman_clubcento/lykman11_members'
Repairing the database from cpanel didnt work. Old available backups are not available.
ip_conntrack: table full, dropping packet
What does that error mean? It's related to iptables right? When I do this cat /proc/sys/net/ipv4/ip_conntrack_max, I get
65536
I increased it
131072
Because someone recommended me this number because I have 4gb of RAM. But I still get the table full errors or
host kernel: printk: 500 messages suppressed
What should I do? Should I keep increasing the number? How do I know how much I can increase it by?
I have 2 identical boxes with FC6 and the same settings and almost the same amount of traffic.
Kernel is 2.6.20-1.2925.fc6 SMP
One is running without problem. The other become slow after few days and from errors I get this message:
nf_conntrack: table full, dropping packet
The table do not clean up automatically as reboot solve the problem. How to flush nt_conntrack table without reboot?
The limit is 65536, setting it double seems to solve the problem but I'm not sure it is the way to go.
Any one facing any issue when Running CPanel on the VPS.
I always seem to be getting these errors only for Cpanel VPS only.
kernel: TCP: time wait bucket table overflow
kernel: TCP: too many of orphaned sockets (90 in CT****)
Even Cpanel Install by SSH or VePortal gives the same error.
How can I disable INSERT access to specific table.
The user should have full access the the DB except insert to specific table.
The tables_priv allow to set what enable and not what disable.
I'm using mysql v5