After a reboot mysql / eximstats remain failed.
I received no errors on restart eximstats, exim, mysql or cpanel.
I did a forced mysql upgrade and forced exim upgrade.
chmod 1777 /tmp did not help either.
What could be the cause? Everything else is green.
i have problem in my server exim
[root@server ~]# /scripts/restartsrv_eximstats
Failed to start eximstats at /usr/local/cpanel/bin/starteximstats line 32.
i try every thing
like
/usr/local/cpanel/bin/cppop
eximup --force
/scripts/perlinstaller Digest:HA1
/scripts/perlinstaller --force Mail
/scripts/fixspamassassinfailedupdate
/scripts/upcp --force
/scripts/installspam --force
/scripts/exim4 --force
/etc/rc.d/init.d/exim restart
/scripts/restartsrv spamd
/etc/rc.d/init.d/chkservd restart
1. What is the difference between the send & smtp tables within MySQL's eximstats?
2. What do they log?
3. Do they get cleaned up and old stats gets removed?
Sudden on my server is started getting this error relating sql
Lost connection to MySQL server during query
When i do service mysql start i get the error
/etc/init.d/mysql start
Starting MySQL................................... [FAILED]
My vps is run well, then i reboot and i see mysql no longer working. I check in WHM
mysql (5.0.67-community) failed
And when restart (by WHM )
Restarting MySQL Server
whmappname='Restarting Service'; if (self['update_ui_status']) { update_ui_status('MySQL Server'); } Waiting for mysql to restart..............finished.
mysqld_safe (/bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/server.xxxx.com.pid) running as root with PID 5275
mysql has failed, please contact the sysadmin (result was "mysql has failed").
My VPS in unmanaged, i can't access mysql.
today mysql server just went down and below is ps aux result
Quote:
khuvuich 4821 0.1 1.2 34580 24760 ? S 08:44 0:00 /usr/local/cpanel/cpanel ./frontend/x3/index.html
root 4822 0.0 0.0 1980 644 ? D 08:44 0:00 quota -v
nobody 5079 0.0 0.2 9248 4612 ? S 08:46 0:00 /usr/local/apache/bin/httpd -DSSL
root 5202 0.1 0.1 12344 4060 ? Ss 08:46 0:00 /usr/sbin/exim -Mc 1IOjnZ-0001Lt-Sq
mailnull 5207 0.0 0.1 12348 2236 ? S 08:46 0:00 /usr/sbin/exim -Mc 1IOjnZ-0001Lt-Sq
root 5233 0.3 0.2 9940 5064 ? S 08:46 0:00 /usr/bin/perl /scripts/restartsrv_mysql --restart
root 5262 0.0 0.0 4580 1200 ? S 08:46 0:00 /bin/sh /etc/rc.d/init.d/mysql start
root 5423 0.0 0.0 5796 528 ? S 08:47 0:00 sleep 1
root 5424 0.0 0.0 4288 788 pts/5 R+ 08:47 0:00 ps aux
root 5592 0.0 0.1 7612 4012 ? S Aug23 0:01 /etc/authlib/authProg
root 6889 0.0 0.0 3216 644 ? D 05:00 0:00 quota -v
root 8687 100 0.0 3360 556 ? R 01:47 419:13 /usr/sbin/repquota -auv
root 8701 0.0 0.0 2196 524 ? D 01:47 0:00 /usr/sbin/repquota -auv
root 10187 0.0 0.1 7612 4084 ? S Aug23 0:01 /etc/authlib/authProg
root 10833 0.0 0.0 0 0 ? S Aug24 0:15 [pdflush]
root 11900 0.0 0.0 3340 524 ? D 02:02 0:00 /usr/sbin/repquota -auv
root 11921 0.0 0.0 2012 524 ? D 02:02 0:00 /usr/sbin/repquota -auv
root 12142 0.0 0.1 7612 4088 ? S Aug23 0:01 /etc/authlib/authProg
root 14413 0.0 0.0 2172 524 ? D 02:15 0:00 /usr/sbin/repquota -auv
root 14437 0.0 0.0 3172 524 ? D 02:15 0:00 /usr/sbin/repquota -auv
root 14534 0.0 0.0 2888 520 ? D 02:16 0:00 /usr/sbin/repquota -auv
root 14601 0.0 0.1 7612 4012 ? S Aug23 0:02 /etc/authlib/authProg
root 14805 0.0 0.0 2564 524 ? D 02:18 0:00 /usr/sbin/repquota -auv
root 14959 0.0 0.0 1848 520 ? D 02:19 0:00 /usr/sbin/repquota -auv
root 15695 0.0 0.4 20540 10060 ? S Aug24 0:01 cpsrvd - waiting for connections
root 16091 0.0 0.0 3096 632 ? DN 02:25 0:00 quota -v kd4rumn
root 17065 0.0 0.1 7612 4088 ? S Aug23 0:01 /etc/authlib/authProg
root 18882 0.0 0.0 3416 644 ? D 02:41 0:00 quota -v
root 19232 0.0 0.0 2428 644 ? D 07:14 0:00 quota -v
root 20506 0.0 0.0 3460 644 ? D 07:26 0:00 quota -v
root 20751 0.0 0.0 2896 640 ? D 07:28 0:00 quota -v
root 20808 0.0 0.0 3760 644 ? D 02:53 0:00 quota -v
root 21143 0.0 0.0 2676 644 ? D 07:30 0:00 quota -v
root 21615 0.0 0.0 3336 644 ? D 02:58 0:00 quota -v
root 21732 0.0 0.0 2076 520 ? D 07:32 0:00 /usr/sbin/repquota -auv
root 21871 0.0 0.0 3196 524 ? D 07:33 0:00 /usr/sbin/repquota -auv
root 21885 0.0 0.0 3408 640 ? D 03:00 0:00 quota -v
root 22190 0.0 0.0 2116 640 ? D 03:02 0:00 quota -v
root 22333 0.0 0.0 3196 520 ? D 07:34 0:00 /usr/sbin/repquota -auv
root 22350 0.0 0.0 2716 524 ? D 07:34 0:00 /usr/sbin/repquota -auv
root 22959 0.0 0.0 2748 640 ? D 03:08 0:00 quota -v
root 23312 0.0 0.0 3104 576 ? D 07:35 0:00 shutdown -r 0 w
root 23712 0.0 0.0 3116 520 ? D 07:36 0:00 /usr/sbin/repquota -auv
root 23941 0.0 0.0 3856 640 ? D 07:38 0:00 quota -v
root 24197 0.0 0.0 3512 644 ? D 03:16 0:00 quota -v
root 24928 0.0 0.0 2512 640 ? D 03:20 0:00 quota -v
root 25144 0.0 0.0 3844 644 ? D 03:21 0:00 quota -v
root 25830 0.0 0.0 1980 644 ? D 07:44 0:00 quota -v
root 26838 0.0 0.0 3204 640 ? D 03:32 0:00 quota -v
root 27238 0.0 0.0 3832 640 ? D 03:34 0:00 quota -v
root 27377 0.0 0.0 2912 640 ? D 03:36 0:00 quota -v
root 27433 0.0 0.0 2752 640 ? D 03:36 0:00 quota -v
root 27503 0.0 0.0 2176 644 ? D 03:37 0:00 quota -v
root 27659 0.0 0.0 2144 644 ? D 07:52 0:00 quota -v
root 27713 0.0 0.0 3832 1080 ? S 07:52 0:00 /usr/bin/perl /scripts/quota_auto_fix
root 27714 0.0 0.0 3832 440 ? S 07:52 0:00 /usr/bin/perl /scripts/quota_auto_fix
root 27715 0.0 0.0 3340 520 ? D 07:52 0:00 /usr/sbin/repquota -a
root 28543 0.0 0.0 2500 640 ? D 03:43 0:00 quota -v
root 29352 0.0 0.0 1520 576 ? D 07:59 0:00 shutdown -r 0 w
root 29417 0.0 0.0 0 0 ? Ds 08:00 0:00 [bash]
root 29538 0.0 0.2 9240 5248 ? Ss 08:01 0:00 /usr/local/apache/bin/httpd -DSSL
nobody 29543 0.0 0.2 9520 5264 ? S 08:01 0:00 /usr/local/apache/bin/httpd -DSSL
nobody 29546 0.0 0.2 9500 5232 ? S 08:01 0:00 /usr/local/apache/bin/httpd -DSSL
nobody 29547 0.0 0.2 9520 5376 ? S 08:01 0:00 /usr/local/apache/bin/httpd -DSSL
nobody 29548 0.0 0.2 9380 5416 ? S 08:01 0:00 /usr/local/apache/bin/httpd -DSSL
nobody 29549 0.0 0.2 9380 4792 ? S 08:01 0:00 /usr/local/apache/bin/httpd -DSSL
root 29556 0.0 0.0 3180 640 ? D 03:48 0:00 quota -v
root 29597 0.0 0.0 0 0 ? S Aug24 0:09 [pdflush]
nobody 29637 0.0 0.2 10044 5624 ? S 08:01 0:00 /usr/local/apache/bin/httpd -DSSL
nobody 29763 0.0 0.2 9380 5392 ? S 08:02 0:00 /usr/local/apache/bin/httpd -DSSL
nobody 29878 0.0 0.2 9520 4868 ? S 08:02 0:00 /usr/local/apache/bin/httpd -DSSL
nobody 29939 0.0 0.2 9520 4904 ? S 08:02 0:00 /usr/local/apache/bin/httpd -DSSL
root 30271 0.0 0.0 5812 576 ? D 08:03 0:00 /sbin/quotaoff -a
root 30425 0.0 0.0 2552 644 ? D 03:54 0:00 quota -v
root 30432 0.0 0.0 2636 640 ? D 08:04 0:00 quota -v
nobody 30466 0.0 0.2 9512 4844 ? S 08:05 0:00 /usr/local/apache/bin/httpd -DSSL
root 30609 0.0 0.0 3732 640 ? D 08:06 0:00 quota -v
root 30616 0.0 0.0 2328 640 ? D 08:06 0:00 quota -v
root 30994 0.0 0.0 2464 640 ? D 08:09 0:00 quota -v
root 31071 0.0 0.0 2156 644 ? D 08:09 0:00 quota -v
root 31250 0.0 0.0 2296 644 ? D 08:10 0:00 quota -v
root 31800 0.0 0.0 3508 524 ? D 08:12 0:00 /usr/sbin/repquota -auv
root 31828 0.0 0.1 8852 2328 ? Rs 08:12 0:00 sshd: root@pts/5
root 31851 0.0 0.0 4812 1444 pts/5 Ss 08:12 0:00 -bash
root 32295 0.0 0.0 2172 644 ? D 08:15 0:00 quota -v
and top result
Quote:
8687 root 19 0 3360 556 468 R 100 0.0 422:52.37 repquota
5817 nobody 16 0 9384 4728 1288 S 0 0.2 0:00.03 httpd
6119 root 17 0 3480 1024 764 R 0 0.0 0:00.01 top
1 root 16 0 2716 548 468 S 0 0.0 0:01.37 init
2 root RT 0 0 0 0 S 0 0.0 0:02.45 migration/0
3 root 34 19 0 0 0 R 0 0.0 0:00.05 ksoftirqd/0
4 root RT 0 0 0 0 S 0 0.0 0:00.75 migration/1
5 root 34 19 0 0 0 S 0 0.0 0:00.01 ksoftirqd/1
6 root 5 -10 0 0 0 R 0 0.0 0:04.17 events/0
7 root 5 -10 0 0 0 S 0 0.0 0:00.52 events/1
8 root 8 -10 0 0 0 S 0 0.0 0:00.00 khelper
9 root 15 -10 0 0 0 S 0 0.0 0:00.00 kacpid
35 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/0
36 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/1
37 root 15 0 0 0 0 S 0 0.0 0:00.00 khubd
56 root 16 0 0 0 0 S 0 0.0 0:48.82 kswapd0
57 root 12 -10 0 0 0 S 0 0.0 0:00.00 aio/0
58 root 12 -10 0 0 0 S 0 0.0 0:00.00 aio/1
202 root 25 0 0 0 0 S 0 0.0 0:00.00 kseriod
332 root 18 0 2356 644 560 D 0 0.0 0:00.00 quota
429 root 8 -10 0 0 0 S 0 0.0 0:00.00 ata/0
430 root 8 -10 0 0 0 S 0 0.0 0:00.00 ata/1
431 root 6 -10 0 0 0 S 0 0.0 0:00.00 ata_aux
435 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_0
436 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_1
437 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_2
438 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_3
439 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_4
440 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_5
461 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_6
462 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_7
523 root 15 0 0 0 0 S 0 0.0 0:43.22 kjournald
679 root 18 0 3516 640 560 D 0 0.0 0:00.00 quota
718 root 20 0 2648 644 560 D 0 0.0 0:00.00 quota
1017 root 19 0 2388 524 448 D 0 0.0 0:00.00 repquota
1213 root 18 0 2064 644 560 D 0 0.0 0:00.00 quota
1495 root 18 0 2124 644 560 D 0 0.0 0:00.00 quota
1678 root 18 0 3464 640 560 D 0 0.0 0:00.00 quota
1694 root 19 0 3576 640 560 D 0 0.0 0:00.00 quota
It make mysql server failed and when i try to restart got this
Quote:
MySQL manager or server PID file could not be found! [FAILED]
This issue is really strange as i never put requota to run in cronjob.
I've been having trouble installing MySQL 5, strangely, on this VPS.
Upon every install, it is bound to give me the same error.
Quote:
root@host [~/src]# rpm -i --nodeps MySQL-server-community-5.0.51a-0.rhel5.i386.rpm
error: install: %pre scriptlet failed (2), skipping MySQL-server-community-5.0.51a-0.rhel5
Quote:
root@zendfree [~/src]# rpm -i --nodeps MySQL-server-5.0.51a-0.glibc23.i386.rpm
error: install: %pre scriptlet failed (2), skipping MySQL-server-5.0.51a-0.glibc23
I've tried out various RPMs - all of which gives :
error: install: %pre scriptlet failed (2), skipping MYSQL-PACKAGE-NAME.
My OS is CentOS 5.8.
Plesk is 11.0.9.
Having problems with failed daily domain backups. All databases that have been created by Plesk cannot be backed up, thus backup fails with the following message:
<?xml version="1.0" encoding="UTF-8"?>
<execution-result status="error" log-location="/usr/local/psa/PMM/sessions/2015-02-19-044701.875/migration.result">
[Code]...
Since we upgraded to Plesk 11.5 or (I'm not shure) the last Update 12, user can not import MySQL-Databases anymore.
If the user open phpMyAdmin for import and select the database and click on Ok, phpMyAdmin does nothing.
I heard that could be a problem with JQUERY and I checked the files in ParallelsadminhtdocsdomainsdatabasesphpMyAdminjsjquery and all files seems to be there.
Only if I check the source of the phpMyAdmin Import-Website it seems, there is a problem with jquery-1.6.2+fix-9521.js.
But how I can fix this problem for all Windows-Servers.
What could I fix by trying to start mysql server, recieve following errors:
plesk interface:
Code:
Failed to restart the "mysql" service.
Cannot start/stop/restart service: Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service mysql restart
Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the stop(8) and then start(8) utilities,
e.g. stop mysql ; start mysql. The restart(8) utility is also available.
start: Job failed to start
from the console:
Code:
sudo service mysql start
start: Job failed to start
Code:
mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
output of plesk_11.5.30_reset_instance_data.log:
[Code] ...
I freshly installed Plesk 12.0 on Ubuntu 14.04. Everything works accept the MySQL database creation.
When I try to create one, i get this error :
error: the test connection to the database server has failed because of network problems: connection refused...
Since my /var partition is full, so I moved /var/lib/mysql to /backup/mysql/.
Seems all the files are copied and I changed my.cnf reboot mysql, but all the web sites using db is not working anymore..
I installed the MySQL binary packages in /usr/local/mysql/ after removing the MySQL RPM package. MySQL is functioning when I executed /usr/local/mysql/bin/safe_mysqld. I reinstalled MySQL before I installed PHP. When I used a PHP script to access a MySQL database, it outputs an error:
Code:
Warning: mysqli::mysqli() [function.mysqli-mysqli]: (HY000/2002): can't connect to local mysql server through socket /var/lib/mysql/mysql.sock in index.php on line 2
However, I installed MySQL in /usr/local/mysql, not in /var/lib/mysql. How do I fix MySQL?
For some reason mysql wont start, i have tried restarting mysql but it wont, it says FAILED. The mysql.sock file seems to have disappeared and i cannot find it anywhere.
View 5 Replies View RelatedI recently had a harddrive failure and luckliy I can still access certain directories on this failed drive. I can still access the /var/lib/mysql/ directory which holds all the users databases and have backed all these up separately using tar.
Now what I need to know is how do you restore these database files to another server? I tried simply untar'ing one of these to the new servers /var/lib/mysql/ direcotry and it stuffed Mysql up - it went offline. I had to get a cpanel tech to bring Mysql back online.
how can I get these database files to fully work on a new server?
Can someone recommended me some one with knowledge of mysql exploit or mysql injection, it seem to our VB forum have issue with database load..
View 5 Replies View RelatedI've been racking my brains with this problem for the last couple of months and have made zero progress. I've asked a lot of people if they know what might be wrong here, but none of them have any idea.
Basically, the problem is that any sort of service monitor I put on my server shows MySQL as being down/offline, even when I know for sure it's up and running perfectly fine. All other services report a green light.
The mysqld service is running on port 3306, which is open both inbound and outbound on my APF config, so as far as I can tell it's nothing to do with the firewall (I won't rule that out though).
The other odd thing is that MySQL shows a green light within WHM, but not anywhere else.
Does anyone know what might be wrong here? Am I missing something entirely fundamental and obvious?
my /var partition is full,
im not sure if any files i can remove to get more free space on /var partition.
because there are more free space on /home,
i think if i can move all the /var/lib/mysql to /home/mysql,
if yes,howcan i move it and do any change,
can let the sql data do not lose,
andrun well in the feature ?
I've rented a dedicated server that comes with Red Hat Enterprise Linux 4 and MySQL 3.23 but I need at least MySQL 4.1 or higher. My knowledge about GNU/Linux is very limited, so I've read some documents at mysql.com and now I think I have to follow these steps:
1. Uninstall MySQL 3.23 with this command line:
shell> rpm -e mysql-*.rpm
2. Install the server and client RPMs of MySQL 5.0:
shell> rpm -i MySQL-server-VERSION.i386.rpm
shell> rpm -i MySQL-client-VERSION.i386.rpm
I have a number of web sites on a dedicated server. Some of these web sites are a few years old. Are there any issues upgrading from MySQL 4.1 to 5.x? Are there web sites that may have compatibility issues?
View 6 Replies View RelatedI keep getting this error :
MySQL Error : MySQL server has gone away
How do I fix it?
my.cnf contents
Quote:
[mysqld]
safe-show-database
old_passwords
back_log = 75
skip-innodb
max_connections = 800
key_buffer = 48M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 3000
thread_cache_size = 128
wait_timeout = 90
connect_timeout = 30
tmp_table_size = 128M
max_heap_table_size = 64M
max_allowed_packet = 256M
net_buffer_length = 16384
max_connect_errors = 10
thread_concurrency = 4
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 3M
query_cache_size = 48M
query_cache_type = 1
query_prealloc_size = 262144
query_alloc_block_size = 65536
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
default-storage-engine = MyISAM
max_user_connections = 500
[mysqld_safe]
nice = -5
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
[mysqlhotcopy]
interactive-timeout
i have recive many mail. 40 or up per day that :
lfd failed @ Fri May 1 13:36:14 2009. A restart was attempted automagically.
Service Check Method: [check command]
my server take ssh failed.have way for fixed without contact with data center? ( with whm)
View 12 Replies View Relatedmy VPS WHM show "lfd failed" in Service Status..
what is this and how I can fix it.
Transaction Check Error:
file /etc/fonts/conf.d/30-aliases-fedora.conf from install of fontconfig-2.4.1-7.el5 conflicts with file from package fontconfig-2.4.1-6.el5
tried to yum or even installing this manually and get this error, please help me to bypass this.