Home / user-109515

Spacedust's questions

Martin Hope
Spacedust
Asked: 2014-09-15 15:08:06 +0800 CST
  • 0

Each time I add new domain inside my server's control panel the Apache server and nginx as frontend proxy should restart - nginx as reload, apache as graceful.

However it throws nginx error page, then everything is dying (no such page found) so nginx goes down too, then all services are starting again and everything is working fine till next domain is added/removed.

Why it's showing No such file or directory ?

[Mon Sep 15 00:48:55 2014] [notice] Apache/2.2.29 (Unix) DAV/2 mod_fastcgi/mod_fastcgi-SNAP-0910052141 mod_python/3.3.1 Python/2.6.6 mod_rpaf/0.6 mod_ssl/2.2.29 OpenSSL/1.0.1e-fips mod_perl/2.0.4 Perl/v5.10.1 configured -- resuming normal operations
[Mon Sep 15 00:49:39 2014] [error] child process 22371 still did not exit, sending a SIGKILL
[Mon Sep 15 00:50:06 2014] [alert] (2)No such file or directory: FastCGI: read() from pipe failed (0)
[Mon Sep 15 00:50:06 2014] [alert] (2)No such file or directory: FastCGI: the PM is shutting down, Apache seems to have disappeared - bye
[Mon Sep 15 00:50:10 2014] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)

Another tests:

nginx -t
nginx: the configuration file /etc/nginx/nginx.conf syntax is ok
nginx: configuration file /etc/nginx/nginx.conf test is successful

and

httpd -t
Syntax OK
apache-2.2
Martin Hope
Spacedust
Asked: 2014-03-18 11:37:20 +0800 CST
  • 0

I've enabled mysqlnd on my PHP 5.4.26 server using MariaDB 10.0.8.

My SQL config contained this:

[mysqlnd]
character-set-server = utf8
collation-server = utf8_general_ci

It was all working fine when no mysqlnd was enabled. Since enabling it all special polish UTF-8 characters gone missing.

When I disable these two lines in server.cnf config all is working well again.

Since I don't like latin-1 encoding and I would like to keep UTF-8 I have a question does mysqlnd got UTF-8 by default and there is not need for these options ?

mysql
Martin Hope
Spacedust
Asked: 2013-12-06 11:10:54 +0800 CST
  • 1

I'm trying to send e-mail to one of the biggest polish hosting companies and their servers are refusing to receive it with message:

TLS connect failed: error:140943FC:SSL routines:SSL3_READ_BYTES:sslv3 alert bad record mac; connected to 89.161.199.168.
I'm not going to try again; this message has been in the queue too long.

I've contacted this company and got reply:

"Our verification showed that server mail.domainhere.pl is trying to connect to our server via SSL/TLS protocol. Such form of connection is not supported by our server, but I would like to note that our servers are configured properly and match current RFC standards. The following method of establishing connection is non-standard for communication between the servers."

I'm using Qmailtoaster on CentOS 6.5 64-bit. It happens even if I don't use SSL in my mail client !

Example of my SMTP config:

    #!/bin/sh

QMAILDUID=`id -u qmaild`
NOFILESGID=`id -g qmaild`
MAXSMTPD=`cat /var/qmail/control/concurrencyincoming`
BLACKLIST=`cat /var/qmail/control/blacklists`
SMTPD="/var/qmail/bin/qmail-smtpd"
TCP_CDB="/etc/tcprules.d/tcp.smtp.cdb"
RBLSMTPD="/usr/bin/rblsmtpd"
HOSTNAME=`hostname`
VCHKPW="/home/vpopmail/bin/vchkpw"
RECORDIO="/usr/bin/recordio"

### MR -- incresing SOFTLIMITVAR if not enough (example: because 'login fail')
if [ `uname -m` = 'x86_64' ] ; then
        SOFTLIMITVAR="72000000"
else
        SOFTLIMITVAR="18000000"
fi

IP=0
PORT=25

### MR -- SSL must using SMTPS=1 and SSL=1 but non-SSL only SSL=0 (without SMTPS=0)
export SMTPAUTH="!" \
        SSL=0 \
        REQUIRE_AUTH=0 \
        FORCE_TLS=0 \
        DENY_TLS=0 \
        AUTH=1 \
        REQUIRE_AUTH=0 \
        ALLOW_INSECURE_AUTH=1

### MR -- spamhaus.org recommended for not using $RBLSMTPD $BLACKLIST entry before $SMTPD
exec /usr/bin/softlimit -m $SOFTLIMITVAR \
        /usr/bin/tcpserver -v -R -H -l $HOSTNAME -x $TCP_CDB -c "$MAXSMTPD" \
        -u "$QMAILDUID" -g "$NOFILESGID" $IP $PORT $RECORDIO \
        $SMTPD $VCHKPW /bin/true 2>&1

How to correct this ?

smtp
Martin Hope
Spacedust
Asked: 2013-10-11 11:27:43 +0800 CST
  • 2
/etc/init.d/php-fpm restart
Stopping php-fpm:                                          [FAILED]
Starting php-fpm: [10-Oct-2013 21:24:37] ERROR: An another FPM instance seems to already listen on /home/php-fpm/sock/gosianozka.sock
[10-Oct-2013 21:24:37] ERROR: FPM initialization failed
                                                           [FAILED]

It happens from time to time and I don't have any idea how to fix it.

I'm using PHP 5.4.20 from ius repo on CentOS 6.4 64-bit.

PHP 5.4.20 (cli) (built: Sep 20 2013 10:06:51)
Copyright (c) 1997-2013 The PHP Group
Zend Engine v2.4.0, Copyright (c) 1998-2013 Zend Technologies
    with the ionCube PHP Loader v4.4.3, Copyright (c) 2002-2013, by ionCube Ltd., and
    with SourceGuardian v9.5, Copyright (c) 2000-2013, by Inovica Ltd.
    with Zend Guard Loader v3.3, Copyright (c) 1998-2013, by Zend Technologies

My init.d script:

#! /bin/sh
#
# chkconfig: - 84 16
# description:  PHP FastCGI Process Manager
# processname: php-fpm
# config: /etc/php-fpm.conf
# pidfile: /var/run/php-fpm/php-fpm.pid

# Standard LSB functions
#. /lib/lsb/init-functions

# Source function library.
. /etc/init.d/functions

# Check that networking is up.
. /etc/sysconfig/network

# Additional environment file
if [ -f /etc/sysconfig/php-fpm ]; then
      . /etc/sysconfig/php-fpm
fi

if [ "$NETWORKING" = "no" ]
then
    exit 0
fi

RETVAL=0
prog="php-fpm"
pidfile=${PIDFILE-/var/run/php-fpm/php-fpm.pid}
lockfile=${LOCKFILE-/var/lock/subsys/php-fpm}

start () {
    echo -n $"Starting $prog: "
    dir=$(dirname ${pidfile})
    [ -d $dir ] || mkdir $dir
    daemon --pidfile ${pidfile} php-fpm --daemonize
    RETVAL=$?
    echo
    [ $RETVAL -eq 0 ] && touch ${lockfile}
}
stop () {
    echo -n $"Stopping $prog: "
    killproc -p ${pidfile} php-fpm
    RETVAL=$?
    echo
    if [ $RETVAL -eq 0 ] ; then
        rm -f ${lockfile} ${pidfile}
    fi
}

restart () {
        stop
        start
}

reload () {
    echo -n $"Reloading $prog: "
    killproc -p ${pidfile} php-fpm -USR2
    RETVAL=$?
    echo
}


# See how we were called.
case "$1" in
  start)
    start
    ;;
  stop)
    stop
    ;;
  status)
    status -p ${pidfile} php-fpm
    RETVAL=$?
    ;;
  restart)
    restart
    ;;
  reload|force-reload)
    reload
    ;;
  condrestart|try-restart)
    [ -f ${lockfile} ] && restart || :
    ;;
  *)
    echo $"Usage: $0 {start|stop|status|restart|reload|force-reload|condrestart|try-restart}"
    RETVAL=2
        ;;
esac

exit $RETVAL
php
Martin Hope
Spacedust
Asked: 2013-09-26 03:39:15 +0800 CST
  • 1

My PowerDNS DNS server 3.3 does not resolve TXT records.

Database looks like this:

PowerDNS database

When I try to dig my server for TXT entry they are not being shown:

[root@nowosci powerdns]# dig @ns1.nowosci.org private._domainkey.nowosci.org TXT

; <<>> DiG 9.9.3-rpz2+rl.13208.13-P2-RedHat-9.9.3-4.P2.el6 <<>> @ns1.nowosci.org private._domainkey.nowosci.org TXT
; (1 server found)
;; global options: +cmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NXDOMAIN, id: 58314
;; flags: qr aa rd; QUERY: 1, ANSWER: 0, AUTHORITY: 1, ADDITIONAL: 1
;; WARNING: recursion requested but not available

;; OPT PSEUDOSECTION:
; EDNS: version: 0, flags:; udp: 2800
;; QUESTION SECTION:
;private._domainkey.nowosci.org.        IN      TXT

;; AUTHORITY SECTION:
nowosci.org.            1800    IN      SOA     ns1.nowosci.org. admin.adminonline.gr. 2013092526 3600 1800 604800 1800

;; Query time: 9 msec
;; SERVER: 62.21.44.49#53(62.21.44.49)
;; WHEN: śro wrz 25 13:36:45 CEST 2013
;; MSG SIZE  rcvd: 119

and

[root@nowosci powerdns]# dig @ns1.nowosci.org nowosci.org TXT

; <<>> DiG 9.9.3-rpz2+rl.13208.13-P2-RedHat-9.9.3-4.P2.el6 <<>> @ns1.nowosci.org nowosci.org TXT
; (1 server found)
;; global options: +cmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 3920
;; flags: qr aa rd; QUERY: 1, ANSWER: 0, AUTHORITY: 1, ADDITIONAL: 1
;; WARNING: recursion requested but not available

;; OPT PSEUDOSECTION:
; EDNS: version: 0, flags:; udp: 2800
;; QUESTION SECTION:
;nowosci.org.                   IN      TXT

;; AUTHORITY SECTION:
nowosci.org.            1800    IN      SOA     ns1.nowosci.org. admin.adminonline.gr. 2013092526 3600 1800 604800 1800

;; Query time: 3 msec
;; SERVER: 62.21.44.49#53(62.21.44.49)
;; WHEN: śro wrz 25 13:37:31 CEST 2013
;; MSG SIZE  rcvd: 100

How to resolve this ?

domain-name-system
Martin Hope
Spacedust
Asked: 2013-07-26 01:33:52 +0800 CST
  • 0

I use the following code on my site elixnews.com to remove php extension from:

RewriteEngine On
RewriteBase /
RewriteCond %{HTTP_HOST} ^www\.(.+)$ [NC]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d 
RewriteRule ^([^\.]+)$ $1.php [NC,L]

To remove www and php extension from my links, but it doesn't work: http://elixnews.com/todays_news - What's wrong ?

apache-2.2
Martin Hope
Spacedust
Asked: 2013-06-26 08:39:41 +0800 CST
  • 1

When adding a new domain inside my server's control panel it takes much longer than usual since some time.

CPU shows 100% usage on one core and strace reports something like this:

poll([{fd=7, events=POLLIN|POLLERR|POLLHUP}], 1, -64771072) = 1 ([{fd=7, revents=POLLIN}])
recvfrom(7, "OiJsb2NhbCI7fWk6NTQ0O2E6NTp7czo1"..., 8192, MSG_DONTWAIT, NULL, NULL) = 8192
poll([{fd=7, events=POLLIN|POLLERR|POLLHUP}], 1, -64771072) = 1 ([{fd=7, revents=POLLIN}])
recvfrom(7, "bm5hbWUiO3M6MjI6ImJhZHppZXdpYXJ6"..., 8192, MSG_DONTWAIT, NULL, NULL) = 8192
poll([{fd=7, events=POLLIN|POLLERR|POLLHUP}], 1, -64771072) = 1 ([{fd=7, revents=POLLIN}])
recvfrom(7, "IjtzOjExOiJ3ZWJtYWlscHJvZyI7czow"..., 8192, MSG_DONTWAIT, NULL, NULL) = 8192

What might be the reason ?

My OS is CentOS 5.9 64-bit. Tried different hardware and kernels and always the same...

hosting
Martin Hope
Spacedust
Asked: 2013-04-08 14:09:39 +0800 CST
  • 2

My Apache is throwing Internal Server Error 500 errors and logs like this:

> [Sun Apr 07 23:35:24 2013] [error] [client 124.162.30.45] (2)No such
> file or directory: FastCGI: failed to connect to server
> "/home/magda_00aa/sportxxx.pl/sportxxx.pl.0fake": socket file
> descriptor (1063) is larger than FD_SETSIZE (1024), you probably need
> to rebuild Apache with a larger FD_SETSIZE, referer:
> http://www.surf4web.com/surfing.php?id=haoduodeng2012

I've upped FD limits inside:

cat /usr/include/bits/typesizes.h | grep FD
#define __FD_SETSIZE            65536

and

cat /usr/include/linux/posix_types.h | grep FD_SETSIZE
#undef __FD_SETSIZE
#define __FD_SETSIZE    65536
#define __FDSET_LONGS   (__FD_SETSIZE/__NFDBITS)

and also

/sbin/sysctl fs.file-max
fs.file-max = 512000

ulimit -n
1000000

but it didn't helped. My Apache is still crashing if more than 350 virtualhosts :/

I'm on CentOS 5.9 64-bit - kernel 3.0.65-1.el5.elrepo

linux
Martin Hope
Spacedust
Asked: 2013-02-12 13:31:03 +0800 CST
  • 3

I'm using php-fpm with customer separate pools.

Sometimes page are freezing, then showing 500 internal server error, and I'm getting such errors in error log:

[11-Feb-2013 22:12:39] ERROR: unable to read what child say: Bad file descriptor (9)
[11-Feb-2013 22:12:39] ERROR: unable to read what child say: Bad file descriptor (9)
[11-Feb-2013 22:12:42] WARNING: [pool oferty] child 31186 exited on signal 11 (SIGSEGV) after 198.250454 seconds from start

My current settings are:

    [admin]
listen = 127.0.0.1:51006
listen.backlog = -1
listen.allowed_clients = 127.0.0.1
user = admin
group = admin
pm = dynamic
pm.max_children = 10
pm.start_servers = 2
pm.min_spare_servers = 1
pm.max_spare_servers = 2
pm.max_requests = 1000
;pm.status_path = /status
;ping.path = /ping
;ping.response = pong
request_terminate_timeout = 180s
request_slowlog_timeout = 180s
slowlog = /var/log/php-fpm/slow.log
rlimit_files = 1024
rlimit_core = 0
;chroot =
;chdir = /var/www
catch_workers_output = yes
security.limit_extensions = .php .php3 .php4 .php5

env[HOSTNAME] = $HOSTNAME
env[PATH] = /usr/local/bin:/usr/bin:/bin
env[TMP] = /tmp
env[TMPDIR] = /tmp
env[TEMP] = /tmp

;php_admin_value[sendmail_path] = /usr/sbin/sendmail -t -i -f [email protected]
;php_flag[display_errors] = off
php_admin_value[error_log] = /var/log/php-fpm/error.log
php_admin_value[session.save_path] = /var/lib/php/session
php_admin_flag[log_errors] = on
php_admin_value[memory_limit] = 128M

What should be increased ? My server is using Intel Core i7 2600 3.4 GHz (8 threads) + 32 GB RAM, 2xSSD 120 GB Software RAID1 + 2x HDD 3 TB Software RAID

php
Martin Hope
Spacedust
Asked: 2012-12-05 03:25:43 +0800 CST
  • 2

I'm getting such kernel panics:

    EXT4-fs error (device md2): ext4_ext_find_extent: bad header/extent in inode #97911179: invalid magic - magic 5f69, entries 28769, max 26988(0), depth 24939(0)
----------- [cut here ] --------- [please bite here ] ---------
Kernel BUG at fs/ext4/extents.c:1973
invalid opcode: 0000 [1] SMP
last sysfs file: /devices/pci0000:00/0000:00:00.0/irq
CPU 6
Modules linked in: iptable_filter ipt_REDIRECT ip_nat_ftp ip_conntrack_ftp iptable_nat ip_nat ip_tables xt_state ip_conntrack_netbios_ns ip_conntrack nfnetlink netconsole ipt_iprange xt_tcpudp autofs4 hwmon_vid coretemp cpufreq_ondemand acpi_cpufreq freq_table mperf x_tables be2iscsi ib_iser rdma_cm ib_cm iw_cm ib_sa ib_mad ib_core ib_addr iscsi_tcp bnx2i cnic ipv6 xfrm_nalgo crypto_api uio cxgb3i libcxgbi cxgb3 8021q libiscsi_tcp libiscsi2 scsi_transport_iscsi2 scsi_transport_iscsi ext3 jbd dm_mirror dm_multipath scsi_dh video backlight sbs power_meter hwmon i2c_ec dell_wmi wmi button battery asus_acpi acpi_memhotplug ac lp joydev sg shpchp parport_pc parport r8169 mii serio_raw tpm_tis tpm tpm_bios i2c_i801 i2c_core pcspkr dm_raid45 dm_message dm_region_hash dm_log dm_mod dm_mem_cache raid10 raid456 xor raid0 sata_nv aacraid 3w_9xxx 3w_xxxx sata_sil sata_via ahci libata sd_mod scsi_mod raid1 ext4 jbd2 crc16 uhci_hcd ohci_hcd ehci_hcd
Pid: 9374, comm: httpd Not tainted 2.6.18-308.20.1.el5debug 0000001
RIP: 0010:[<ffffffff8806ccda>] [<ffffffff8806ccda>] :ext4:ext4_ext_put_in_cache+0x21/0x6a
RSP: 0018:ffff8101c2df7678 EFLAGS: 00010246
RAX: 00000000fffffbf1 RBX: ffff810758115dc8 RCX: 0000000000000000
RDX: 0000000000000000 RSI: 0000000000000000 RDI: ffff810758115958
RBP: ffff810758115958 R08: 0000000000000002 R09: 0000000000000000
R10: ffff8101c2df75a0 R11: 0000000000000100 R12: 0000000000000000
R13: 0000000000000002 R14: 0000000000000000 R15: 0000000000000000
FS: 00002ab948d31f70(0000) GS:ffff81081f4ba4c8(0000) knlGS:0000000000000000
CS: 0010 DS: 0000 ES: 0000 CR0: 000000008005003b
CR2: 000000001de9e4e0 CR3: 000000014ae88000 CR4: 00000000000006a0
Process httpd (pid: 9374, threadinfo ffff8101c2df6000, task ffff8101cdf74d80)
Stack: 000181070000040f ffff810758115dc8 ffff8103f15d7ff4 ffff8107581157f0
 ffff810758115958 000000000000040f 0000000000000000 ffffffff8806f621
 ffff8101c2df76d8 ffff8101c2df7738 0000000000000000 ffff81034900c310
Call Trace:
 [<ffffffff8806f621>] :ext4:ext4_ext_get_blocks+0x258/0x16f3
 [<ffffffff80013994>] poison_obj+0x26/0x2f
 [<ffffffff800331e2>] cache_free_debugcheck+0x20b/0x21a
 [<ffffffff8805b4ac>] :ext4:ext4_get_blocks+0x43/0x1d2
 [<ffffffff8805b4cf>] :ext4:ext4_get_blocks+0x66/0x1d2
 [<ffffffff8805c16a>] :ext4:ext4_get_block+0xa7/0xe6
 [<ffffffff8805c3be>] :ext4:ext4_block_truncate_page+0x215/0x4f1
 [<ffffffff8806e832>] :ext4:ext4_ext_truncate+0x65/0x909
 [<ffffffff8805b4f9>] :ext4:ext4_get_blocks+0x90/0x1d2
 [<ffffffff8805ccfc>] :ext4:ext4_truncate+0x91/0x53b
 [<ffffffff80041e5d>] pagevec_lookup+0x17/0x1e
 [<ffffffff8002d3cf>] truncate_inode_pages_range+0x1f3/0x2d5
 [<ffffffff8803b78b>] :jbd2:jbd2_journal_stop+0x1f1/0x201
 [<ffffffff8805f3c1>] :ext4:ext4_da_write_begin+0x1ea/0x25b
 [<ffffffff80010896>] generic_file_buffered_write+0x151/0x6c3
 [<ffffffff800174b1>] __generic_file_aio_write_nolock+0x36c/0x3b9
 [<ffffffff800482ab>] do_sock_read+0xcf/0x110
 [<ffffffff80022d49>] generic_file_aio_write+0x69/0xc5
 [<ffffffff88056c0a>] :ext4:ext4_file_write+0xcb/0x215
 [<ffffffff8001936b>] do_sync_write+0xc7/0x104
 [<ffffffff8000d418>] dnotify_parent+0x1f/0x7b
 [<ffffffff800efead>] do_readv_writev+0x26e/0x291
 [<ffffffff800a8192>] autoremove_wake_function+0x0/0x2e
 [<ffffffff80035b9f>] do_setitimer+0x62a/0x692
 [<ffffffff8002e6a5>] mntput_no_expire+0x19/0x8d
 [<ffffffff80049aa0>] sys_chdir+0x55/0x62
 [<ffffffff800178c6>] vfs_write+0xce/0x174
 [<ffffffff800181ba>] sys_write+0x45/0x6e
 [<ffffffff80060116>] system_call+0x7e/0x83


Code: 0f 0b 68 3e 27 08 88 c2 b5 07 eb fe 48 8d 9f 08 05 00 00 48
RIP [<ffffffff8806ccda>] :ext4:ext4_ext_put_in_cache+0x21/0x6a
 RSP <ffff8101c2df7678>
 <0>Kernel panic - not syncing: Fatal exception
 <0>Rebooting in 1 seconds..

My system is CentOS 5.8 64-bit.

/dev/md2        /home   ext4    rw,noatime,nodiratime,usrjquota=aquota.user,grpjquota=aquota.group,usrquota,grpquota,jqfmt=vfsv0     0       0

Kernel: 2.6.18-308.20.1.el5debug

md2 : active raid1 sdc3[0] sdd3[1]
      2914280100 blocks super 1.0 [2/2] [UU]
      [>....................]  resync =  0.2% (7252288/2914280100) finish=13468.3min speed=3595K/sec

/dev/md2              2,7T  1,8T  908G  67% /home

How can I fix this ?

Even when resync my array, unmount filesystems and then check and fix all errors it all works fine for about a week of time and then small ext4 errors showing and finally it starts kernel panicing.

linux
Martin Hope
Spacedust
Asked: 2012-08-31 12:45:14 +0800 CST
  • 6

I'm trying to import 641 MB MySQL database with a command:

mysql -u root -p ddamiane_fakty < domenyin_damian_fakty.sql

but I got an error:

ERROR 1064 (42000) at line 2351406: 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 '<br />
<b>Fatal error</b>:  Maximum execution time of 300 seconds exceeded in <b' at line 253

However limits are set much higher:

mysql> show global variables like "interactive_timeout";
+---------------------+-------+
| Variable_name       | Value |
+---------------------+-------+
| interactive_timeout | 28800 |
+---------------------+-------+
1 row in set (0.00 sec)

and

mysql> show global variables like "wait_timeout";
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| wait_timeout  | 28800 |
+---------------+-------+
1 row in set (0.00 sec)
mysql
Martin Hope
Spacedust
Asked: 2012-06-30 09:56:38 +0800 CST
  • 1

I'm currently running my MySQL backup script on every day of the week:

0 1 * * 1 sh /root/mysql_monday.sh
0 1 * * 2 sh /root/mysql_tuesday.sh
0 1 * * 3 sh /root/mysql_wednesday.sh
0 1 * * 4 sh /root/mysql_thursday.sh
0 1 * * 5 sh /root/mysql_friday.sh
0 1 * * 6 sh /root/mysql_saturday.sh
0 1 * * 0 sh /root/mysql_sunday.sh

Now I would like to keep backups for one week more so two weeks in total just to be more secure.

For example: I though I can create one backup file on monday in the even days and then again in the odd-numbered days.

For even days I can just use:

0 1 */2 * 1 sh /root/mysql_monday_even.sh
0 1 */2 * 2 sh /root/mysql_tuesday_even.sh
0 1 */2 * 3 sh /root/mysql_wednesday_even.sh
0 1 */2 * 4 sh /root/mysql_thursday_even.sh
0 1 */2 * 5 sh /root/mysql_friday_even.sh
0 1 */2 * 6 sh /root/mysql_saturday_even.sh
0 1 */2 * 0 sh /root/mysql_sunday_even.sh

But what about the odd-numbered days ?

mysql cron
Martin Hope
Spacedust
Asked: 2012-03-13 15:15:53 +0800 CST
  • 4

Check the logs:

    httpd: page allocation failure. order:4, mode:0xd0

Call Trace:
[<ffffffff8000f696>] __alloc_pages+0x2ef/0x308
[<ffffffff80017a40>] cache_grow+0x139/0x3c7
[<ffffffff8005bd54>] cache_alloc_refill+0x138/0x188
[<ffffffff800df358>] __kmalloc+0x95/0x9f
[<ffffffff800f0bba>] alloc_fd_array+0x18/0x28
[<ffffffff800306c8>] expand_files+0x124/0x2cb
[<ffffffff800226c5>] dup_fd+0x133/0x281
[<ffffffff80049050>] copy_files+0x47/0x64
[<ffffffff8001f632>] copy_process+0x590/0x15db
[<ffffffff800a11c4>] alloc_pid+0x228/0x2c4
[<ffffffff80030f6c>] do_fork+0x69/0x1c1
[<ffffffff8005d116>] system_call+0x7e/0x83
[<ffffffff8005d427>] ptregscall_common+0x67/0xac

Mem-info:
Node 0 DMA per-cpu:
cpu 0 hot: high 0, batch 1 used:0
cpu 0 cold: high 0, batch 1 used:0
cpu 1 hot: high 0, batch 1 used:0
cpu 1 cold: high 0, batch 1 used:0
cpu 2 hot: high 0, batch 1 used:0
cpu 2 cold: high 0, batch 1 used:0
cpu 3 hot: high 0, batch 1 used:0
cpu 3 cold: high 0, batch 1 used:0
cpu 4 hot: high 0, batch 1 used:0
cpu 4 cold: high 0, batch 1 used:0
cpu 5 hot: high 0, batch 1 used:0
cpu 5 cold: high 0, batch 1 used:0
cpu 6 hot: high 0, batch 1 used:0
cpu 6 cold: high 0, batch 1 used:0
cpu 7 hot: high 0, batch 1 used:0
cpu 7 cold: high 0, batch 1 used:0
Node 0 DMA32 per-cpu:
cpu 0 hot: high 186, batch 31 used:14
cpu 0 cold: high 62, batch 15 used:57
cpu 1 hot: high 186, batch 31 used:29
cpu 1 cold: high 62, batch 15 used:58
cpu 2 hot: high 186, batch 31 used:30
cpu 2 cold: high 62, batch 15 used:57
cpu 3 hot: high 186, batch 31 used:30
cpu 3 cold: high 62, batch 15 used:56
cpu 4 hot: high 186, batch 31 used:26
cpu 4 cold: high 62, batch 15 used:13
cpu 5 hot: high 186, batch 31 used:8
cpu 5 cold: high 62, batch 15 used:42
cpu 6 hot: high 186, batch 31 used:30
cpu 6 cold: high 62, batch 15 used:50
cpu 7 hot: high 186, batch 31 used:157
cpu 7 cold: high 62, batch 15 used:59
Node 0 Normal per-cpu:
cpu 0 hot: high 186, batch 31 used:13
cpu 0 cold: high 62, batch 15 used:50
cpu 1 hot: high 186, batch 31 used:66
cpu 1 cold: high 62, batch 15 used:49
cpu 2 hot: high 186, batch 31 used:3
cpu 2 cold: high 62, batch 15 used:55
cpu 3 hot: high 186, batch 31 used:104
cpu 3 cold: high 62, batch 15 used:55
cpu 4 hot: high 186, batch 31 used:2
cpu 4 cold: high 62, batch 15 used:2
cpu 5 hot: high 186, batch 31 used:87
cpu 5 cold: high 62, batch 15 used:3
cpu 6 hot: high 186, batch 31 used:15
cpu 6 cold: high 62, batch 15 used:55
cpu 7 hot: high 186, batch 31 used:113
cpu 7 cold: high 62, batch 15 used:12
Node 0 HighMem per-cpu: empty
Free pages: 76972kB (0kB HighMem)
Active:3061605 inactive:620399 dirty:68055 writeback:0 unstable:0 free:19243 slab:283635 mapped-file:33024 mapped-anon:2758457 pagetables:91114
Node 0 DMA free:10032kB min:8kB low:8kB high:12kB active:0kB inactive:0kB present:9628kB pages_scanned:0 all_unreclaimable? yes
lowmem_reserve[]: 0 3451 16066 16066
Node 0 DMA32 free:53992kB min:3484kB low:4352kB high:5224kB active:2704704kB inactive:367984kB present:3534588kB pages_scanned:268 all_unreclaimable? no
lowmem_reserve[]: 0 0 12615 12615
Node 0 Normal free:12948kB min:12732kB low:15912kB high:19096kB active:9541756kB inactive:2113612kB present:12917900kB pages_scanned:423 all_unreclaimable? no
lowmem_reserve[]: 0 0 0 0
Node 0 HighMem free:0kB min:128kB low:128kB high:128kB active:0kB inactive:0kB present:0kB pages_scanned:0 all_unreclaimable? no
lowmem_reserve[]: 0 0 0 0
Node 0 DMA: 4*4kB 2*8kB 3*16kB 3*32kB 2*64kB 2*128kB 1*256kB 0*512kB 1*1024kB 0*2048kB 2*4096kB = 10032kB
Node 0 DMA32: 0*4kB 59*8kB 45*16kB 82*32kB 0*64kB 6*128kB 5*256kB 0*512kB 1*1024kB 1*2048kB 11*4096kB = 53992kB
Node 0 Normal: 47*4kB 187*8kB 356*16kB 148*32kB 1*64kB 0*128kB 1*256kB 1*512kB 0*1024kB 0*2048kB 0*4096kB = 12948kB
Node 0 HighMem: empty
923737 pagecache pages
Swap cache: add 180089, delete 179928, find 2859/3518, race 0+0
Free swap = 8304596kB
Total swap = 8388600kB
Free swap: 8304596kB
4322816 pages of RAM
230069 reserved pages
14241581 pages shared
117 pages swap cached

My /etc/fstab (SWAP is a file on an SSD):

proc /proc proc defaults 0 0
none /dev/pts devpts gid=5,mode=620 0 0
tmpfs /dev/shm        tmpfs   defaults        0       0
/dev/md0 /boot ext3           defaults 0 0
/dev/md1        /       ext4    rw,noatime,nodiratime,usrjquota=aquota.user,grpjquota=aquota.group,usrquota,grpquota,jqfmt=vfsv0       0       0
/dev/md2        /home   ext4    rw,noatime,nodiratime,usrjquota=aquota.user,grpjquota=aquota.group,usrquota,grpquota,jqfmt=vfsv0       0       0
UUID=b422827c-9f2f-4bc5-ab5a-3cc921924daa /var/lib/mysql ext4 rw,noatime,nodiratime,usrjquota=aquota.user,grpjquota=aquota.group,usrquota,grpquota,jqfmt=vfsv0,  1      1
/var/lib/mysql/swapfile1 swap swap defaults 0 0

Swapiness is set to 20:

cat /proc/sys/vm/swappiness
20

There is only a few RAM left and still using very low SWAP till it crashes and the RAM is freeded and I got another crash in a few hours:

Mem:  16370988k total, 16200724k used,   170264k free,   250340k buffers
Swap:  8388600k total,    83356k used,  8305244k free,   859484k cached
apache-2.2 memory httpd pagefile swap
Martin Hope
Spacedust
Asked: 2012-03-11 06:49:21 +0800 CST
  • 1

When I was using Lighttpd I can easily achieve this by such entries. So all websites were protected.

Wget robots: 

$HTTP["useragent"] =~ "Wget" {
        $HTTP["url"] =~ "^/tagi(.*)" {
#       $HTTP["url"] =~ "" {
                url.access-deny = ( "" )
        }

        $HTTP["url"] =~ "^/tags(.*)" {
                url.access-deny = ( "" )
        }

        $HTTP["url"] =~ "^/kom.php(.*)" {
                url.access-deny = ( "" )
        }

        $HTTP["querystring"] =~ "^(.*)strony(.*)" {
                url.access-deny = ( "" )
        }

        $HTTP["querystring"] =~ "^(.*)page(.*)" {
                url.access-deny = ( "" )
        }

        $HTTP["url"] =~ "^(.*)/www/delivery/lg.php(.*)" {
                url.access-deny = ( "" )
        }

        $HTTP["url"] =~ "^(.*)/reklamy/(.*)" {
                url.access-deny = ( "" )
        }

        $HTTP["url"] =~ "^(.*)/ads/(.*)" {
                url.access-deny = ( "" )
        }

        $HTTP["url"] =~ "^(.*)/www/delivery/ck.php(.*)" {
                url.access-deny = ( "" )
        }
  }

Sites with fake traffic: 

$HTTP["referer"] =~ "(.*)surfing.php(.*)" {
        url.access-deny = ( "" )
}

$HTTP["referer"] =~ "(.*)promote.php(.*)" {
        url.access-deny = ( "" )
}

$HTTP["referer"] =~ "(.*)trafficadder.php(.*)" {
        url.access-deny = ( "" )
}

$HTTP["referer"] =~ "(.*)traffic.php(.*)" {
        url.access-deny = ( "" )
}

$HTTP["referer"] =~ ".*loic*." {
       url.access-deny = ( "" )
}

$HTTP["referer"] =~ ".*autosurf*." {
       url.access-deny = ( "" )
}

How to do this the same in Apache ? I don't want to add this to .htaccess.

apache-2.2 rewrite httpd wget
Martin Hope
Spacedust
Asked: 2012-03-08 14:55:51 +0800 CST
  • 1

I've setup Varnish as a reverse proxy on port 80 before Apache 2.2.22 + VirtualHosts on port 81.

When I enter my websites from port 81 it's all ok, then when I try to enter from port 80 I got Apache2 Test Page.

I'm running only one backend (all on the same machine).

What should I add to my Varnish config to support all Apache VirtualHosts ? I would like to have such universal rule that will add all new domains without having to change my Varnish config each time.

On Lighttpd + virtual hosts everything was running out of a box.

apache-2.2 virtualhost varnish reverse-proxy
Martin Hope
Spacedust
Asked: 2012-03-02 14:40:41 +0800 CST
  • 1

When I try to build rpm from src rpm (Apache 2.4.1) I got this error:

rpmbuild -tb httpd-2.4.1.tar.bz2 --ba httpd.spec

+ ./configure --build=x86_64-redhat-linux-gnu --host=x86_64-redhat-linux-gnu --target=noarch-redhat-linux-gnu --program-prefix= --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --includedir=/usr/include --libdir=/usr/lib64 --libexecdir=/usr/libexec --localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/share/man --infodir=/usr/share/info --enable-layout=RPM --libdir=/usr/lib64 --sysconfdir=/etc/httpd/conf --includedir=/usr/include/httpd --libexecdir=/usr/lib64/httpd/modules --datadir=/var/www --with-installbuilddir=/usr/lib64/httpd/build --enable-mpms-shared=all --with-apr=/usr --with-apr-util=/usr --enable-suexec --with-suexec --with-suexec-caller=apache --with-suexec-docroot=/var/www --with-suexec-logfile=/var/log/httpd/suexec.log --with-suexec-bin=/usr/sbin/suexec --with-suexec-uidmin=500 --with-suexec-gidmin=100 --enable-pie --with-pcre --enable-mods-shared=all --enable-ssl --with-ssl --enable-socache-dc --enable-bucketeer --enable-case-filter --enable-case-filter-in --disable-imagemap
checking for chosen layout... RPM
checking for working mkdir -p... yes
checking for grep that handles long lines and -e... /bin/grep
checking for egrep... /bin/grep -E
checking build system type... x86_64-redhat-linux-gnu
checking host system type... x86_64-redhat-linux-gnu
checking target system type... Invalid configuration `noarch-redhat-linux-gnu': machine `noarch-redhat' not recognized
configure: error: /bin/sh build/config.sub noarch-redhat-linux-gnu failed
błąd: Błędny stan wyjścia z /var/tmp/rpm-tmp.48153 (%build)


Błędy budowania RPM-a:
    Błędny stan wyjścia z /var/tmp/rpm-tmp.48153 (%build)
centos redhat apache-2.2 httpd