MRatWork Forum by Mustafa Ramadhan
Sawo Project - Kloxo-MR Discussions => Kloxo-MR Technical Helps => Topic started by: tolaleng on 2019-08-22, 10:20:12
-
Hello Team,
Could anyone having experience with this issue. Could you help me to fix it?
[root@ns1 ~]# sh /script/restart-mysql
*** Process for MYSQL/MARIADB service ***
Starting MariaDB.190822 15:12:50 mysqld_safe Logging to '/var/lib/mysql/xxxxx.com.err'.
190822 15:12:50 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/etc/init.d/mysql: line 264: kill: (6060) - No such process
[FAILED]
- Process: restart
MariaDB server PID file could not be found! [FAILED]
Starting MariaDB.190822 15:12:53 mysqld_safe Logging to '/var/lib/mysql/xxxx.com.err'.
190822 15:12:53 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/etc/init.d/mysql: line 264: kill: (6254) - No such process
[FAILED]
-------------------------------------------------------------------
- For help, type '/script/restart-mysql [--help|-h]'
Thank you
-
Hello Team,
Could anyone having experience with this issue. Could you help me to fix it?
[root@ns1 ~]# sh /script/restart-mysql
*** Process for MYSQL/MARIADB service ***
Starting MariaDB.190822 15:12:50 mysqld_safe Logging to '/var/lib/mysql/xxxxx.com.err'.
190822 15:12:50 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/etc/init.d/mysql: line 264: kill: (6060) - No such process
[FAILED]
- Process: restart
MariaDB server PID file could not be found! [FAILED]
Starting MariaDB.190822 15:12:53 mysqld_safe Logging to '/var/lib/mysql/xxxx.com.err'.
190822 15:12:53 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/etc/init.d/mysql: line 264: kill: (6254) - No such process
[FAILED]
-------------------------------------------------------------------
- For help, type '/script/restart-mysql [--help|-h]'
Thank you
Inform 'sh /script/sysinfo'.
-
There is not working all, CP Admin also not reachable and can't be to access. :'(
[root@ns1 ~]# sh /script/sysinfo
A. Control Panel:
- Kloxo-MR: 7.0.0.c-2019070501
- Web: --uninstalled--
- PHP: php56s - 5.6.36-1.ius.centos7 (fpm mode)
B. Plateform:
- OS: CentOS Linux release 7.6.1810 (Core) x86_64
- Hostname: xxxxxxxx.com
C. Services:
1. MySQL: MariaDB-server-10.1.41-1.el7.centos.x86_64
2. PHP:
- Installed:
- Branch: php70u-cli-7.0.33-1.ius.el7.x86_64
- Multiple:
* php54m - 5.4.45-14.mr.el7
* php55m - 5.5.38-1.ius.centos7
* php56m - 5.6.36-1.ius.centos7
* php70m - 7.0.33-1.ius.el7
* php71m - 7.1.17-1.ius.centos7
* php72m - 7.2.19-1.el7.ius
* php73m - 7.3.6-1.el7.ius
- Used: php70m-fpm
- Multiple: enable
3. Web Used: apache
- Hiawatha: --uninstalled--
- Lighttpd: lighttpd-1.4.54-1.el7.x86_64
- Nginx: nginx-1.17.3-1.el7.ngx.x86_64
- Apache: httpd24u-2.4.39-2.el7.ius.x86_64
- PHP Type: php-fpm_event (default)
- Secondary PHP: off
4. WebCache: none
- ATS: --uninstalled--
- Squid: --uninstalled--
- Varnish: --uninstalled--
5. Dns: bind
- Bind: bind-9.9.9-1.mr.el7.x86_64
- DJBDns: djbdns-1.05-17.4.mr.el7.x86_64
- NSD: nsd-4.1.27-1.mr.el7.x86_64
- PowerDNS: pdns-4.1.11-1.el7.x86_64
- Yadifa: yadifa-2.3.9-1.el7.x86_64
6. Mail: qmail-toaster-1.03-1.3.57.mr.el7.x86_64
- pop3/imap4: none
- smtp: none
- spam: bogofilter-1.2.3-6.el7.x86_64
7. FTP: pure-ftpd
- pure-ftpd: pure-ftpd-1.0.49-1.mr.el7.x86_64
8. Stats: awstats
- awstats: kloxomr-stats-awstats-7.7-1.mr.noarch
D. Memory:
total used free shared buff/cache available
Mem: 1789 368 187 32 1233 1187
Swap: 0 0 0
E. Disk Space:
Filesystem Size Used Avail Use% Mounted on
/dev/sda1 40G 31G 6.9G 82% /
*** Process Time: 00:00:00:45.45222 (dd:hh:mm:ss:xxxxxx) ***
* Note: run 'sh /script/sysinfo -y' if you want run 'fix-service-list' also
(importance after Kloxo-MR update)
[root@ns1 ~]#
-
Did you upgrade MariaDB using 'sh /script/mariadb-upgrade'?.
Try upgrade to version 10.3.
-
Installed:
MariaDB-server.x86_64 0:10.2.26-1.el7.centos
Complete!
- For help, type '/script/restart-mysql [--help|-h]'
Enter password:
Version check failed. Got the following error when calling the 'mysql' command line client
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
FATAL ERROR: Upgrade failed
- For help, type '/script/restart-mysql [--help|-h]'
- End process...
* Note:
- Format: /script/mariadb-upgrade [target-version]
where [target-version] = 10.2 (by default)
-
I tried upgrade to 10.3, but still getting an error with can't connect to mysql socket
Could you help me to check it. Thanks
Installed:
MariaDB-server.x86_64 0:10.3.17-1.el7.centos
Complete!
- For help, type '/script/restart-mysql [--help|-h]'
Enter password:
Version check failed. Got the following error when calling the 'mysql' command line client
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
FATAL ERROR: Upgrade failed
- For help, type '/script/restart-mysql [--help|-h]'
- End process...
* Note:
- Format: /script/mariadb-upgrade [target-version]
where [target-version] = 10.2 (by default)
-
Give me your ssh access.
-
Okay sir,
I already share via the message
thanks
-
Same situation here...
Any progress on it??
Thx!!
-
It seems that after make some space on disk now is starting ...
After restart ... same error!! Something is wrong! Mariadb not starting at boot.
I have to manually start it with "sh /script/restart-mysql".
-
Inform here 'systemctl status mysql -l'.
-
At new, reboot server:
systemctl status mysql -l
mysql.service - LSB: start and stop MariaDB
Loaded: loaded (/etc/rc.d/init.d/mysql; bad; vendor preset: disabled)
Active: inactive (dead)
Docs: man:systemd-sysv-generator(8)
After:
sh /script/restart-mysql
I have:
*** Process for MYSQL/MARIADB service ***
Starting MariaDB.190904 13:46:30 mysqld_safe Logging to '/var/lib/mysql/xxx.err'.
190904 13:46:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
[ OK ]
- Process: restart
Shutting down MariaDB [ OK ]
Starting MariaDB.190904 13:46:32 mysqld_safe Logging to '/var/lib/mysql/xxx.err'.
190904 13:46:32 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
[ OK ]
then I have to restart web and php:
sh /script/fixphp; sh /script/restart-web -y
I have:
systemctl status mysql -l
mysql.service - LSB: start and stop MariaDB
Loaded: loaded (/etc/rc.d/init.d/mysql; bad; vendor preset: disabled)
Active: active (exited) since Wed 2019-09-04 12:39:14 EEST; 41min ago
Docs: man:systemd-sysv-generator(8)
Process: 12256 ExecStart=/etc/rc.d/init.d/mysql start (code=exited, status=0/SUCCESS)
systemd[1]: Starting LSB: start and stop MariaDB...
mysql[12256]: Starting MariaDB[ OK ]
systemd[1]: Started LSB: start and stop MariaDB.
mysql[12256]: 190904 12:39:14 mysqld_safe Logging to '/var/lib/mysql/xxx.err
mysql[12256]: 190904 12:39:14 mysqld_safe A mysqld process already exists
-
Nothing wrong with restart process. MariaDB also restart mysqld_safe together with their main service.
-
Nothing wrong with restart process. MariaDB also restart mysqld_safe together with their main service.
Nope, it's all wrong! MariaDB is not started at boot as I showed! Moreover can't login in mysql as root: Access denied for user 'root'@'localhost' using password="yes"!
-
Did you tried 'sh /script/reset-mysql-root-password YOURNEWPASSWORD'?
-
Did you tried 'sh /script/reset-mysql-root-password YOURNEWPASSWORD'?
After that seems everything is ok! ;D
Thanks a lot!!
-
... but after restart ... I have again to restart manually mysql with: sh /script/restart-mysql
:( :( :-[
-
inform here 'chkconfig --list|grep -i mysql|grep -v grep' and 'systemctl list-unit-files|grep mysql'.
-
chkconfig --list|grep -i mysql|grep -v grep
Note: This output shows SysV services only and does not include native
systemd services. SysV configuration data might be overridden by native
systemd configuration.
If you want to list systemd services use 'systemctl list-unit-files'.
To see services enabled on particular target use
'systemctl list-dependencies [target]'.
mysql 0:off 1:off 2:on 3:on 4:on 5:on 6:off
systemctl list-unit-files|grep mysql
shows no output
-
inform here 'pgrep mysql -a' and 'ps aux|grep -i mysql|grep -v grep'
-
pgrep mysql -a
4301 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/xxx.pid
4380 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/xxx.err --pid-file=/var/lib/mysql/xxx.pid
ps aux|grep -i mysql|grep -v grep
root 4301 0.0 0.0 11816 1604 pts/0 S 19:02 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/xxx.pid
mysql 4380 0.3 1.5 1288988 188228 pts/0 Sl 19:02 0:18 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/xxx.err --pid-file=/var/lib/mysql/xxx.pid
-
Look like mysql running in your vps from 'pgrep' and 'ps aux' information.
-
Look like mysql running in your vps from 'pgrep' and 'ps aux' information.
Yes becouse I've started it with "sh /script/restart-mysql" command after server booted.
With fresh restart:
pgrep mysql -a - no output
ps aux|grep -i mysql|grep -v grep - no output
-
Try reboot and then check with 'pgrep' a couple of times.
-
Try reboot and then check with 'pgrep' a couple of times.
It starts delayed!
But my webpages shows Error 500 - Internal Server Error!
-
inform here 'cat /etc/my.cnf.d/server.cnf'.
-
cat /etc/my.cnf.d/server.cnf
#
# These groups are read by MariaDB server.
# Use it for options that only the server (but not clients) should see
#
# See the examples of server my.cnf files in /usr/share/mysql/
#
# this is read by the standalone daemon and embedded servers
[server]
# this is only for the mysqld standalone daemon
[mysqld]
performance-schema=on
default-storage-engine=myisam
skip-innodb
#OpenVZ AIO bug fix
innodb-use-native-aio=0
# this is only for embedded server
[embedded]
# This group is only read by MariaDB servers, not by MySQL.
# If you use the same .cnf file for MySQL and MariaDB,
# you can put MariaDB-only options here
[mariadb]
# This group is only read by MariaDB-10.0 servers.
# If you use the same .cnf file for MariaDB of different versions,
# use this group for options that older servers don't understand
[mariadb-10.0]
-
Try add:
socket=/var/lib/mysql/mysql.sock
bind-address=127.0.0.1
under '[mysqld]'
-
I've added but is the same. Mysql starts delayed and that for (I think) web server have to be restart for avoiding error 500.