URGENT mysql and httpd errors

RickDeckard · Nov 7, 2013

Hi, my server is down on both httpd and services, look at least www.southmodel.it

i've read here http://help.directadmin.com/item.php?id=242 and tried

PHP:

cd /usr/local/directadmin/custombuild
./build rewrite_confs

but i've this error:

PHP:

-bash-4.1# cd /usr/local/directadmin/custombuild
-bash-4.1#  ./build rewrite_confs
Using 95.211.129.78 for your server IP
Checking to ensure /etc/httpd/conf/ssl.crt/server.ca is set.
Restarting apache.
Stopping httpd:                                            [FAILED]
Starting httpd: httpd: Syntax error on line 50 of /etc/httpd/conf/httpd.conf: Syntax error on line 3 of /etc/httpd/conf/extra/httpd-phpmodules.conf: Cannot load /usr/lib/apache/mod_htscanner2.so into server: /usr/lib/apache/mod_htscanner2.so: cannot open shared object file: No such file or directory

also on mysql i've tried

PHP:

cd /usr/local/directadmin/custombuild
./build update
./build mysql

./build php n

but i've this error:

PHP:

...
FATAL ERROR: Upgrade failed
Warning: Using a password on the command line interface can be insecure.
/usr/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
cp: `/usr/lib/libmysqlclient.so' and `/usr/lib/mysql/libmysqlclient.so' are the same file
Restarting MySQL.
 ERROR! MySQL server PID file could not be found!
Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/srv02.hostmart.it.pid).

please help i'm really worried....

DennisNL · Nov 7, 2013

Looks like you miss allot of files.
I dont know allot of DA yet but im not seeing your using ./build clean

mabe that works? so:

cd /usr/local/directadmin/custombuild
./build clean
./build all

BUT are you sure you have your server correct? i see -bash-4.1# but my centos never start like that but with
[root@server ~]#

Looks like your in a jailshell or something?

RickDeckard · Nov 7, 2013

I've tried many times but now i've always:

Apache is functioning normally

and also i can't login to directadmin.

At this time i'm request a professional support, please mp me soon as possible, thanks

RickDeckard · Nov 7, 2013

Now i've this error:

PHP:

-bash-4.1# ./build rewrite_confs
Using 95.211.129.78 for your server IP
Restarting apache.
Stopping httpd:                                            [  OK  ]
Starting httpd: [Thu Nov 07 21:13:45 2013] [warn] NameVirtualHost 95.211.129.105:80 has no VirtualHosts
[Thu Nov 07 21:13:45 2013] [warn] NameVirtualHost 95.211.129.105:443 has no VirtualHosts
[Thu Nov 07 21:13:45 2013] [warn] NameVirtualHost 95.211.129.104:80 has no VirtualHosts
[Thu Nov 07 21:13:45 2013] [warn] NameVirtualHost 95.211.129.104:443 has no VirtualHosts
[Thu Nov 07 21:13:45 2013] [warn] NameVirtualHost 95.211.129.103:80 has no VirtualHosts
[Thu Nov 07 21:13:45 2013] [warn] NameVirtualHost 95.211.129.103:443 has no VirtualHosts
[Thu Nov 07 21:13:45 2013] [warn] NameVirtualHost 95.211.129.102:80 has no VirtualHosts
[Thu Nov 07 21:13:45 2013] [warn] NameVirtualHost 95.211.129.102:443 has no VirtualHosts

-bash-4.1#

DennisNL · Nov 7, 2013

This is not actualy a error but a warning, apache should start fine

RickDeckard · Nov 7, 2013

I've always

Apache is functioning normally

for all domains......

DennisNL · Nov 7, 2013

With what account cant you login?
Since you got SSH use

Passwd <username>

Dont forget after doing this to login in DA and change the password again.

scsi · Nov 7, 2013

Try this:

Code:

echo "action=rewrite&value=httpd" >> /usr/local/directadmin/data/task.queue
/usr/local/directadmin/dataskq d400

If it still doesnt work then you have more issues like miss-matched dns to your virtual hosts.

RickDeckard · Nov 7, 2013

Tried

but da login as admin is no longer working in any case.....

RickDeckard · Nov 7, 2013

Code:

echo "action=rewrite&value=httpd" >> /usr/local/directadmin/data/task.queue
/usr/local/directadmin/dataskq d400

result

Code:

-bash-4.1# echo "action=rewrite&value=httpd" >> /usr/local/directadmin/data/task.queue
-bash-4.1# /usr/local/directadmin/dataskq d400
Debug mode. Level 400

pidfile written
staring queue
dataskq: command: action=rewrite&value=httpd
Error writing ./data/admin/brute_ip.data: Unable to stat ./data/admin/brute_ip.data.temp for filesize after write<br>
ConfigFile::removeFile(./data/admin/brute_ip.data) filename does not match<br>

Error writing ./data/admin/brute_user.data: Unable to stat ./data/admin/brute_user.data.temp for filesize after write<br>
ConfigFile::removeFile(./data/admin/brute_user.data) filename does not match<br>

done queue

RickDeckard · Nov 7, 2013

now i'm really frustrating, please write me in pm to solve the problems by payment, Thanks

DennisNL · Nov 7, 2013

Could you give us the output of the following commands

uname -a
df -h
who
uptime
ps ax

RickDeckard · Nov 7, 2013

Code:

-bash-4.1# uname -a
Linux srv02.hostmart.it 2.6.32-358.23.2.el6.x86_64 #1 SMP Wed Oct 16 18:37:12 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux

Code:

-bash-4.1# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda2             911G  865G     0 100% /
tmpfs                 7.8G     0  7.8G   0% /dev/shm
/dev/sda1              97M   75M   17M  82% /boot
/dev/sda4             2.0G   53M  1.9G   3% /tmp
-bash-4.1#

Code:

-bash-4.1# who
root     pts/1        2013-11-07 22:33 (adsl-ull-144-135.41-151.net24.it)

Code:

-bash-4.1# uptime
 23:05:08 up  9:29,  1 user,  load average: 0.00, 0.06, 0.22

Code:

-bash-4.1# ps ax
  PID TTY      STAT   TIME COMMAND
    1 ?        Ss     0:00 /sbin/init
    2 ?        S      0:00 [kthreadd]
    3 ?        S      0:03 [migration/0]
    4 ?        S      0:00 [ksoftirqd/0]
    5 ?        S      0:00 [migration/0]
    6 ?        S      0:00 [watchdog/0]
    7 ?        S      0:01 [migration/1]
    8 ?        S      0:00 [migration/1]
    9 ?        S      0:00 [ksoftirqd/1]
   10 ?        S      0:00 [watchdog/1]
   11 ?        S      0:00 [migration/2]
   12 ?        S      0:00 [migration/2]
   13 ?        S      0:00 [ksoftirqd/2]
   14 ?        S      0:00 [watchdog/2]
   15 ?        S      0:00 [migration/3]
   16 ?        S      0:00 [migration/3]
   17 ?        S      0:00 [ksoftirqd/3]
   18 ?        S      0:00 [watchdog/3]
   19 ?        S      0:01 [migration/4]
   20 ?        S      0:00 [migration/4]
   21 ?        S      0:02 [ksoftirqd/4]
   22 ?        S      0:00 [watchdog/4]
   23 ?        S      0:04 [migration/5]
   24 ?        S      0:00 [migration/5]
   25 ?        S      0:04 [ksoftirqd/5]
   26 ?        S      0:00 [watchdog/5]
   27 ?        S      0:03 [migration/6]
   28 ?        S      0:00 [migration/6]
   29 ?        S      0:01 [ksoftirqd/6]
   30 ?        S      0:00 [watchdog/6]
   31 ?        S      0:02 [migration/7]
   32 ?        S      0:00 [migration/7]
   33 ?        S      0:02 [ksoftirqd/7]
   34 ?        S      0:00 [watchdog/7]
   35 ?        S      0:02 [events/0]
   36 ?        S      0:01 [events/1]
   37 ?        S      0:01 [events/2]
   38 ?        S      0:00 [events/3]
   39 ?        S      0:01 [events/4]
   40 ?        S      0:00 [events/5]
   41 ?        S      0:02 [events/6]
   42 ?        S      0:01 [events/7]
   43 ?        S      0:00 [cgroup]
   44 ?        S      0:02 [khelper]
   45 ?        S      0:00 [netns]
   46 ?        S      0:00 [async/mgr]
   47 ?        S      0:00 [pm]
   48 ?        S      0:00 [sync_supers]
   49 ?        S      0:00 [bdi-default]
   50 ?        S      0:00 [kintegrityd/0]
   51 ?        S      0:00 [kintegrityd/1]
   52 ?        S      0:00 [kintegrityd/2]
   53 ?        S      0:00 [kintegrityd/3]
   54 ?        S      0:00 [kintegrityd/4]
   55 ?        S      0:00 [kintegrityd/5]
   56 ?        S      0:00 [kintegrityd/6]
   57 ?        S      0:00 [kintegrityd/7]
   58 ?        S      0:00 [kblockd/0]
   59 ?        S      0:03 [kblockd/1]
   60 ?        S      0:00 [kblockd/2]
   61 ?        S      0:07 [kblockd/3]
   62 ?        S      0:00 [kblockd/4]
   63 ?        S      0:00 [kblockd/5]
   64 ?        S      0:00 [kblockd/6]
   65 ?        S      0:00 [kblockd/7]
   66 ?        S      0:00 [kacpid]
   67 ?        S      0:00 [kacpi_notify]
   68 ?        S      0:00 [kacpi_hotplug]
   69 ?        S      0:00 [ata/0]
   70 ?        S      0:00 [ata/1]
   71 ?        S      0:00 [ata/2]
   72 ?        S      0:00 [ata/3]
   73 ?        S      0:00 [ata/4]
   74 ?        S      0:00 [ata/5]
   75 ?        S      0:00 [ata/6]
   76 ?        S      0:00 [ata/7]
   77 ?        S      0:00 [ata_aux]
   78 ?        S      0:00 [ksuspend_usbd]
   79 ?        S      0:00 [khubd]
   80 ?        S      0:00 [kseriod]
   81 ?        S      0:00 [md/0]
   82 ?        S      0:00 [md/1]
   83 ?        S      0:00 [md/2]
   84 ?        S      0:00 [md/3]
   85 ?        S      0:00 [md/4]
   86 ?        S      0:00 [md/5]
   87 ?        S      0:00 [md/6]
   88 ?        S      0:00 [md/7]
   89 ?        S      0:00 [md_misc/0]
   90 ?        S      0:00 [md_misc/1]
   91 ?        S      0:00 [md_misc/2]
   92 ?        S      0:00 [md_misc/3]
   93 ?        S      0:00 [md_misc/4]
   94 ?        S      0:00 [md_misc/5]
   95 ?        S      0:00 [md_misc/6]
   96 ?        S      0:00 [md_misc/7]
   97 ?        S      0:00 [khungtaskd]
   98 ?        S      0:00 [kswapd0]
   99 ?        SN     0:00 [ksmd]
  100 ?        SN     0:02 [khugepaged]
  101 ?        S      0:00 [aio/0]
  102 ?        S      0:00 [aio/1]
  103 ?        S      0:00 [aio/2]
  104 ?        S      0:00 [aio/3]
  105 ?        S      0:00 [aio/4]
  106 ?        S      0:00 [aio/5]
  107 ?        S      0:00 [aio/6]
  108 ?        S      0:00 [aio/7]
  109 ?        S      0:00 [crypto/0]
  110 ?        S      0:00 [crypto/1]
  111 ?        S      0:00 [crypto/2]
  112 ?        S      0:00 [crypto/3]
  113 ?        S      0:00 [crypto/4]
  114 ?        S      0:00 [crypto/5]
  115 ?        S      0:00 [crypto/6]
  116 ?        S      0:00 [crypto/7]
  121 ?        S      0:00 [kthrotld/0]
  122 ?        S      0:00 [kthrotld/1]
  123 ?        S      0:00 [kthrotld/2]
  124 ?        S      0:00 [kthrotld/3]
  125 ?        S      0:00 [kthrotld/4]
  126 ?        S      0:00 [kthrotld/5]
  127 ?        S      0:00 [kthrotld/6]
  128 ?        S      0:00 [kthrotld/7]
  129 ?        SN     0:12 [kipmi0]
  131 ?        S      0:00 [kpsmoused]
  132 ?        S      0:00 [usbhid_resumer]
  162 ?        S      0:00 [kstriped]
  319 ?        S      0:00 [scsi_eh_0]
  320 ?        S      0:00 [scsi_eh_1]
  321 ?        S      0:00 [scsi_eh_2]
  322 ?        S      0:00 [scsi_eh_3]
  323 ?        S      0:00 [scsi_eh_4]
  324 ?        S      0:00 [scsi_eh_5]
  433 ?        S      0:18 [jbd2/sda2-8]
  434 ?        S      0:00 [ext4-dio-unwrit]
  435 ?        S      0:00 [ext4-dio-unwrit]
  436 ?        S      0:00 [ext4-dio-unwrit]
  437 ?        S      0:00 [ext4-dio-unwrit]
  438 ?        S      0:00 [ext4-dio-unwrit]
  439 ?        S      0:00 [ext4-dio-unwrit]
  440 ?        S      0:00 [ext4-dio-unwrit]
  441 ?        S      0:00 [ext4-dio-unwrit]
  528 ?        S<s    0:00 /sbin/udevd -d
  993 ?        S      0:02 [jbd2/sda4-8]
  994 ?        S      0:00 [ext4-dio-unwrit]
  995 ?        S      0:00 [ext4-dio-unwrit]
  996 ?        S      0:00 [ext4-dio-unwrit]
  997 ?        S      0:00 [ext4-dio-unwrit]
  998 ?        S      0:00 [ext4-dio-unwrit]
  999 ?        S      0:00 [ext4-dio-unwrit]
 1000 ?        S      0:00 [ext4-dio-unwrit]
 1001 ?        S      0:00 [ext4-dio-unwrit]
 1105 ?        S      0:11 [flush-8:0]
 1121 ?        S      0:00 [kauditd]
 1256 ?        S<     0:00 /sbin/udevd -d
 1257 ?        S<     0:00 /sbin/udevd -d
 1305 ?        S      0:00 dovecot/imap-login [1 connections (1 TLS)]
 1308 ?        S<sl   0:00 auditd
 1326 ?        Ss     0:00 /sbin/portreserve
 1552 ?        Sl     0:01 /sbin/rsyslogd -i /var/run/syslogd.pid -c 5
 1575 ?        S      0:27 [kondemand/0]
 1576 ?        S      0:08 [kondemand/1]
 1577 ?        S      0:06 [kondemand/2]
 1578 ?        S      0:11 [kondemand/3]
 1579 ?        S      0:13 [kondemand/4]
 1580 ?        S      0:11 [kondemand/5]
 1581 ?        S      0:13 [kondemand/6]
 1582 ?        S      0:13 [kondemand/7]
 1603 ?        Ss     0:01 irqbalance
 1912 ?        Ss     0:08 lfd - sleeping
 1929 ?        Ss     0:00 dbus-daemon --system
 1958 ?        Ss     0:00 /usr/sbin/acpid
 1967 ?        Ss     0:00 hald
 1968 ?        S      0:00 hald-runner
 1996 ?        S      0:00 hald-addon-input: Listening on /dev/input/event3 /dev
 2010 ?        S      0:00 hald-addon-acpi: listening on acpid socket /var/run/a
 2072 ?        Ss     0:00 /usr/sbin/sshd
 2083 ?        Ss     0:00 xinetd -stayalive -pidfile /var/run/xinetd.pid
 2266 ?        Ss     0:02 /usr/local/directadmin/da-popb4smtp
 2338 ?        S      0:00 dovecot/imap-login
 2366 ?        Ss     0:00 /usr/sbin/abrtd
 2374 ?        Ss     0:00 abrt-dump-oops -d /var/spool/abrt -rwx /var/log/messa
 2401 ?        Ss     0:00 crond
 2412 ?        Ss     0:00 /usr/sbin/atd
 2425 tty1     Ss+    0:00 /sbin/mingetty /dev/tty1
 2427 tty2     Ss+    0:00 /sbin/mingetty /dev/tty2
 2429 tty3     Ss+    0:00 /sbin/mingetty /dev/tty3
 2431 tty4     Ss+    0:00 /sbin/mingetty /dev/tty4
 2433 tty5     Ss+    0:00 /sbin/mingetty /dev/tty5
 2435 tty6     Ss+    0:00 /sbin/mingetty /dev/tty6
 2483 ?        S      0:00 dovecot/imap-login
 2484 ?        S      0:00 dovecot/imap-login
 2485 ?        S      0:00 dovecot/imap-login
 2487 ?        S      0:00 dovecot/imap-login
 2583 ?        Ssl    0:01 named -u named
 2755 ?        S      0:00 dovecot/imap-login
 3517 ?        Ss     0:05 sshd: root@notty
 4351 ?        Ss     0:00 /usr/libexec/openssh/sftp-server
 7331 ?        S      0:00 dovecot/pop3-login
 7985 ?        Ss     0:00 /usr/sbin/dovecot
 8010 ?        S      0:00 dovecot/pop3-login
 8011 ?        S      0:00 dovecot/imap-login [1 connections (1 TLS)]
 8012 ?        S      0:00 dovecot/anvil [40 connections]
 8013 ?        S      0:00 dovecot/log
 8015 ?        S      0:00 dovecot/config
 8016 ?        S      0:00 dovecot/pop3-login
 8017 ?        S      0:00 dovecot/pop3-login
 8018 ?        S      0:00 dovecot/pop3-login
 8019 ?        S      0:00 dovecot/pop3-login
 8020 ?        S      0:00 dovecot/pop3-login
 8021 ?        S      0:00 dovecot/pop3-login
 8022 ?        S      0:00 dovecot/pop3-login
 8023 ?        S      0:00 dovecot/pop3-login
 8025 ?        S      0:00 dovecot/pop3-login
 8037 ?        S      0:00 dovecot/pop3-login
 8038 ?        S      0:00 dovecot/pop3-login
 8044 ?        S      0:00 dovecot/imap-login
 8047 ?        S      0:00 dovecot/auth [0 wait, 0 passdb, 0 userdb]
 9799 ?        S      0:00 dovecot/imap-login
12692 ?        S      0:00 dovecot/imap-login
17946 ?        S      0:00 dovecot/imap-login
18744 ?        S      0:00 dovecot/imap-login
21069 ?        Ss     0:00 /usr/local/directadmin/directadmin d
23717 ?        Ss     0:00 /usr/sbin/httpd -k start -DSSL
23774 ?        S      0:00 /usr/sbin/httpd -k start -DSSL
23775 ?        S      0:00 /usr/sbin/httpd -k start -DSSL
23776 ?        S      0:00 /usr/sbin/httpd -k start -DSSL
23777 ?        S      0:00 /usr/sbin/httpd -k start -DSSL
23778 ?        S      0:00 /usr/sbin/httpd -k start -DSSL
23816 ?        S      0:00 /usr/sbin/httpd -k start -DSSL
24349 ?        S      0:00 /usr/sbin/httpd -k start -DSSL
25215 ?        Ss     0:00 /usr/sbin/exim -bd -q15m -oP /var/run/exim.pid
25384 ?        Ss     0:01 /usr/bin/spamd -d -c -m 5
25949 ?        S      0:00 dovecot/imap [[email protected] 21
26688 ?        S      0:00 dovecot/imap-login [1 connections (1 TLS)]
26873 ?        S      0:00 spamd child
26879 ?        S      0:00 spamd child
26938 ?        S      0:00 dovecot/imap-login
26982 ?        S      0:00 dovecot/pop3-login
27100 ?        S      0:00 dovecot/imap-login
27734 ?        Ss     0:01 sshd: root@pts/1
27779 pts/1    Ss     0:00 -bash
27799 ?        S      0:00 dovecot/pop3-login
27876 ?        Ss     0:00 proftpd: (accepting connections)
28408 ?        S      0:00 dovecot/imap-login [1 connections (1 TLS)]
28504 ?        S      0:00 dovecot/imap-login [1 connections (1 TLS)]
28506 ?        S      0:00 dovecot/imap [[email protected] 217.200.185.
28554 ?        S      0:00 dovecot/imap-login [1 connections (1 TLS)]
28564 ?        S      0:00 dovecot/imap [[email protected] 93.66.186.164
28567 ?        S      0:00 /usr/local/directadmin/directadmin d
28568 ?        S      0:00 /usr/local/directadmin/directadmin d
28570 ?        S      0:00 /usr/local/directadmin/directadmin d
28576 ?        S      0:00 /usr/local/directadmin/directadmin d
28577 ?        S      0:00 /usr/local/directadmin/directadmin d
30796 ?        S      0:00 /usr/sbin/httpd -k start -DSSL
31098 ?        S      0:00 dovecot/imap-login
31101 ?        S      0:00 dovecot/imap-login
31102 ?        S      0:00 dovecot/ssl-params
31103 ?        S      0:00 dovecot/imap [[email protected] 91.255.27.133]
31119 ?        S      0:00 dovecot/imap-login [1 connections (1 TLS)]
31392 ?        S      0:00 dovecot/pop3-login
31394 ?        S      0:00 dovecot/auth worker: idling
31452 ?        S      0:00 dovecot/imap-login
31454 ?        S      0:00 /usr/sbin/httpd -k start -DSSL
31503 pts/1    R+     0:00 ps ax
-bash-4.1#

DennisNL · Nov 7, 2013

But thats clear....

Code:

-bash-4.1# df -h
Filesystem            Size  Used Avail Use% Mounted on
[B]/dev/sda2             911G  865G     0 100% /[/B]
tmpfs                 7.8G     0  7.8G   0% /dev/shm
/dev/sda1              97M   75M   17M  82% /boot
/dev/sda4             2.0G   53M  1.9G   3% /tmp
-bash-4.1#

Your disk is full.. You first need to clean that up. See your PM.

DennisNL · Nov 7, 2013

I think the problem is solved.

755G /var

There was a error log of apache for one site of 755GB .....

Can someone explain to me how this is possible?

Also the phpmyadmin and squirrelmail stays white, i rebuiled it but no luck any clue anyone? roundcube works fine..

Code:

Error of phpmyadmin Fatal error: session_start(): Failed to initialize storage module: files (path: ) in /var/www/html/phpMyAdmin-3.5.8.2-all-languages/libraries/session.inc.php on line 78

Squirrelmail dont give me a error just blank

Mysql, apache, dovecot are all fixed after hours of work..

Edit:

NVM i fixed the last part... ;session.save_path = "/tmp" in php.ini was not set.. weird...

RickDeckard · Nov 8, 2013

Many many thanks to DennisNL, now the server is working again

URGENT mysql and httpd errors

RickDeckard

Verified User

DennisNL

Verified User

RickDeckard

Verified User

RickDeckard

Verified User

DennisNL

Verified User

RickDeckard

Verified User

DennisNL

Verified User

scsi

Verified User

RickDeckard

Verified User

RickDeckard

Verified User

RickDeckard

Verified User

DennisNL

Verified User

RickDeckard

Verified User

DennisNL

Verified User

DennisNL

Verified User

RickDeckard

Verified User