MRatWork Forum by Mustafa Ramadhan
Sawo Project - Kloxo-MR Discussions => Kloxo-MR Technical Helps => Topic started by: South on 2019-08-20, 04:57:47
-
Hi when first using my index.php I got 111 mysql error
Could not connect: Can't connect to MySQL server on (111 "Connection refused")
it wasnt my ip address that appeared there however I went to configuration files on kloxo knowing it might shut me off so I went to conf.d on those grops of mariaDB ovbious made alteration on mysql about bind address but it didnt work it just brought Kloxo Disabled Page
gIMME Clues pls
I also resetted mysql root pass in order to access phpmyAdmin and I cant login
-
Try 'sh /script/reset-mysql-root-password YourNewPassword'.
-
Output:
Stop MySQL service...
env: /etc/init.d/mysqld: Permission denied
MySQL ROOT password reset...
Start MySQL service...
env: /etc/init.d/mysqld: Permission denied
Connect failed: Access denied for user 'root'@'localhost' (using password: YES)
It depict some mysqld file which I did not alter with stuff like:
# Short-Description: start and stop MySQL server
# Description: MySQL database server
### END INIT INFO
# Source function library.
. /etc/rc.d/init.d/functions
# Source networking configuration.
. /etc/sysconfig/network
exec="/usr/bin/mysqld_safe"
prog="mysqld"
# Set timeouts here so they can be overridden from /etc/sysconfig/mysqld
STARTTIMEOUT=120
STOPTIMEOUT=60
[ -e /etc/sysconfig/$prog ] && . /etc/sysconfig/$prog
lockfile=/var/lock/subsys/$prog
# extract value of a MySQL option from config files
# Usage: get_mysql_option SECTION VARNAME DEFAULT
# result is returned in $result
# We use my_print_defaults which prints all options from multiple files,
# with the more specific ones later; hence take the last match.
Can this file be altered?
-
Inform here 'sh /script/sysinfo'.
-
Thank you very much for taking the time to read
Output:
A. Control Panel:
- Kloxo-MR: 7.0.0.c-2019070501
- Web: hiawatha-10.9.0-f.2.mr.el6.x86_64
- PHP: php56s - 5.6.40-1.ius.el6 (fpm mode)
B. Plateform:
- OS: CentOS release 6.10 (Final) x86_64
- Hostname: SERVER.MYSERV.COM
C. Services:
1. MySQL: MariaDB-server-10.0.38-1.el6.x86_64
2. PHP:
- Installed:
- Branch: php52-cli-5.2.17-102.mr.el6.x86_64
- Multiple:
* php52m - 5.2.17-102.mr.el6
- Used: --PHP Branch--
- Multiple: enable
3. Web Used: apache
- Hiawatha: hiawatha-10.9.0-f.2.mr.el6.x86_64
- Lighttpd: lighttpd-1.4.47-2.el6.x86_64
- Nginx: nginx-1.17.2-1.el6.ngx.x86_64
- Apache: httpd24u-2.4.39-2.el6.ius.x86_64
- PHP Type: php-fpm_event
- Secondary PHP: on
4. WebCache: none
- ATS: --uninstalled--
- Squid: --uninstalled--
- Varnish: --uninstalled--
5. Dns: bind
- Bind: bind-9.9.9-1.mr.el6.x86_64
- DJBDns: djbdns-1.05-17.4.mr.el6.x86_64
- NSD: nsd-4.1.27-1.mr.el6.x86_64
- PowerDNS: pdns-4.1.8-1.el6.MIND.x86_64
- Yadifa: yadifa-2.2.5-1.mr.el6.x86_64
6. Mail: qmail-toaster-1.03-1.3.57.mr.el6.x86_64
- pop3/imap4: courier-imap-toaster-4.1.2-1.3.20.mr.el6.x86_64
- smtp: qmail-toaster-1.03-1.3.57.mr.el6.x86_64
- spam: bogofilter-1.2.4-1.el6.x86_64
7. FTP: pure-ftpd
- pure-ftpd: pure-ftpd-1.0.49-1.mr.el6.x86_64
8. Stats: awstats
- awstats: kloxomr-stats-awstats-7.7-1.mr.noarch
-
Inform 'dir /etc/init.d/ -l ; dir /var/lib/ -l ; dir /var/lib/mysql/ -l '
-
Many thank yous
dir /etc/init.d/ -l
Output:
dir /etc/init.d/ -l
total 284
-rwxr-xr-x 1 root root 2062 Mar 21 2017 atd
-rwxr-xr-x 1 root root 2826 Aug 23 2016 crond
-rwxr-xr-x 1 root root 3034 Apr 9 10:52 cups
-rwxr-xr-x 1 root root 1505 May 26 2014 dc_client
-rwxr-xr-x 1 root root 1347 May 26 2014 dc_server
-rwxr-xr-x 1 root root 3416 Aug 31 2014 djbdns
-rwxr-xr-x 1 root root 1987 Mar 29 2014 dovecot
-rw-r--r-- 1 root root 25592 Apr 20 14:00 functions
-rwxr-xr-x 1 root root 5985 Apr 20 14:00 halt
-rwxr-xr-x 1 root root 1503 Jun 28 00:16 hiawatha
-rwxr-xr-x 1 root root 2001 Jun 13 13:57 htcacheclean
-rwxr-xr-x 1 root root 3136 Jun 13 13:57 httpd
-rwxr-xr-x 1 root root 1916 Aug 21 22:47 httpry
-rwxr-xr-x 1 root root 11123 Apr 20 14:00 iptables
-rw-r--r-- 1 root root 1366 Apr 20 14:00 iptables.save
-rwxr-xr-x 1 root root 652 Apr 20 14:00 killall
-rwxrwxr-x 1 root root 3011 Aug 21 22:46 kloxo-php
-rwxrwxr-x 1 root root 3265 Aug 21 22:46 kloxo-web
-rwxrwxr-x 1 root root 1157 Aug 21 22:46 kloxo-wrap
-rwxr-xr-x 1 root root 2361 Aug 13 2018 lighttpd
-rwxr-xr-x 1 root root 3046 May 26 2017 maldet
-rwxr-xr-x 1 root root 2200 Jul 10 17:41 messagebus
-rwxr-xr-x 1 root root 1128 Apr 20 14:00 modules_dep
-rwxr-xr-x 1 root root 11587 Jan 29 2019 mysql
-rw-r--r-- 1 root root 7026 Apr 20 14:00 mysqld
-rwxr-xr-x 1 root root 7992 Apr 20 14:00 named
-rwxr-xr-x 1 root root 4334 Apr 20 14:00 netconsole
-rwxr-xr-x 1 root root 5309 Apr 20 14:00 netfs
-rwxr-xr-x 1 root root 6742 Apr 20 14:00 network
-rwxr-xr-x 1 root root 3615 Jul 23 08:30 nginx
-rwxr-xr-x 1 root root 3646 Jul 23 08:30 nginx-debug
-rwxr-xr-x 1 root root 3478 May 11 03:20 nsd
-rwxr-xr-x 1 root root 3635 Mar 23 17:25 pdns
-rwxr-xr-x 1 root root 1968 Aug 21 22:46 php-fpm
-rwxr-xr-x 1 root root 1994 Aug 21 22:46 php52m-fpm
-rwxr-xr-x 1 root root 2023 Apr 20 14:00 portreserve
-rwxr-xr-x 1 root root 1549 Aug 21 22:47 pure-ftpd
-rwxr-xr-x 1 root root 4431 Aug 21 22:47 qmail
-rwxr-xr-x 1 root root 2034 Apr 20 14:00 quota_nld
-rwxr-xr-x 1 root root 1513 Apr 20 14:00 rdisc
-rwxr-xr-x 1 root root 1822 Apr 20 14:00 restorecond
-rwxr-xr-x 1 root root 2011 Apr 20 14:00 rsyslog
-rwxr-xr-x 1 root root 1698 Apr 20 14:00 sandbox
-rw-r--r-- 1 root root 2056 Apr 20 14:00 saslauthd
-rwxr-xr-x 1 root root 647 Apr 20 14:00 single
-rwxr-xr-x 1 root root 2162 Mar 22 2017 snmpd
-rwxr-xr-x 1 root root 1738 Mar 22 2017 snmptrapd
-rwxr-xr-x 1 root root 2129 Jul 8 2010 spawn-fcgi
-rwxr-xr-x 1 root root 4621 Apr 20 14:00 sshd
-rwxr-xr-x 1 root root 2276 Aug 4 2015 svnserve
-rwxr-xr-x 1 root root 2294 Apr 20 14:00 udev-post
-rwxr-xr-x 1 root root 3555 May 10 2016 xinetd
-rwxr-xr-x 1 root root 2624 Aug 6 2017 yadifad
dir /var/lib/ -l
Output:
total 96
drwxr-xr-x 2 root root 4096 Jul 15 03:46 alternatives
drwx------ 2 apache apache 4096 Jun 13 13:57 dav
drwxr-xr-x 2 root root 4096 Jul 16 19:27 dbus
drwxr-xr-x 2 root root 4096 Aug 2 23:21 dhclient
drwxr-x--- 2 dovecot dovecot 4096 Jun 18 2016 dovecot
drwxr-xr-x 2 root root 4096 Sep 23 2011 games
-rw-r--r-- 1 root root 1674 Aug 23 03:18 logrotate.status
drwxr-xr-x 2 root root 4096 Sep 23 2011 misc
drwxr-xr-x 33 mysql mysql 4096 Aug 21 22:47 mysql
drwxr-xr-x 2 mysql mysql 4096 Jul 15 03:39 mysqltmp
drwxr-xr-x 3 root root 4096 Jul 15 03:43 net-snmp
drwxr-xr-x 3 nsd nsd 4096 Jul 15 03:50 nsd
drwxr-xr-x 2 root root 4096 Jul 22 05:32 pear
drwxr-xr-x 3 root root 4096 Jun 4 2014 php
drwxr-xr-x 2 root root 4096 Mar 21 2017 plymouth
drwx------ 3 root root 4096 Jul 15 03:40 polkit-1
-rw------- 1 root root 4096 Aug 21 22:06 random-seed
drwx------ 3 root root 4096 Aug 23 03:22 rkhunter
drwxr-xr-x 2 root root 4096 Aug 21 22:37 rpm
drwx------ 2 root root 4096 Jun 19 2018 rsyslog
drwxr-xr-x 4 root root 4096 Jun 19 2018 stateless
drwxr-xr-x 3 root root 4096 Nov 26 2016 udev
drwxr-xr-x 5 webalizer root 4096 Jul 22 04:57 webalizer
drwxr-xr-x 6 root root 4096 Aug 17 18:24 yum
dir /var/lib/mysql/ -l
Output:
total 111052
-rw-rw---- 1 mysql mysql 239618 Aug 23 12:35 SERVER.MYSERV.COM.err
-rw-rw---- 1 mysql mysql 6 Aug 21 22:47 SERVER.MYSERV.COM.pid
drwx------ 2 mysql mysql 4096 Aug 6 23:07 Sstats
drwx------ 2 mysql mysql 12288 Aug 17 18:29 afterlogic
-rw-rw---- 1 mysql mysql 16384 Aug 21 22:47 aria_log.00000001
-rw-rw---- 1 mysql mysql 52 Aug 21 22:47 aria_log_control
drwx------ 2 mysql mysql 4096 Aug 6 23:07 au
drwx------ 2 mysql mysql 4096 Jul 22 04:57 au4
drwx------ 2 mysql mysql 4096 Jul 22 04:57 au44
drwx------ 2 mysql mysql 20480 Aug 6 23:07 b
drwx------ 2 mysql mysql 4096 Aug 6 23:07 bi
drwx------ 2 mysql mysql 4096 Aug 6 23:07 bright
drwx------ 2 mysql mysql 4096 Aug 6 23:07 chat
drwx------ 2 mysql mysql 4096 Aug 6 23:07 clever
drwx------ 2 mysql mysql 4096 Jul 22 04:57 craig
drwx------ 2 mysql mysql 4096 Aug 6 23:07 dual
-rw-rw---- 1 mysql mysql 50331648 Aug 21 22:47 ib_logfile0
-rw-rw---- 1 mysql mysql 50331648 Jul 15 03:39 ib_logfile1
-rw-rw---- 1 mysql mysql 12582912 Aug 21 22:47 ib1
drwx------ 2 mysql mysql 12288 Aug 21 22:45 kloxo
drwx------ 2 mysql mysql 4096 Aug 6 23:07 lin
drwx------ 2 mysql mysql 4096 Jul 22 04:57 lin1
drwx------ 2 mysql mysql 4096 Aug 6 23:07 msg
-rw-rw---- 1 mysql mysql 0 Jul 15 03:47 multi-master.info
drwx------ 2 mysql mysql 4096 Jul 22 04:57 m
drwx------ 2 mysql mysql 4096 Aug 6 23:07 m5
drwx--x--x 2 mysql mysql 4096 Jul 15 03:39 mysql
srwxrwxrwx 1 mysql mysql 0 Aug 21 22:47 mysql.sock
drwx------ 2 mysql mysql 4096 Jul 15 03:39 performance_schema
drwx------ 2 mysql mysql 4096 Aug 17 18:28 powerdns
drwx------ 2 mysql mysql 4096 Jul 22 04:57 reb
drwx------ 2 mysql mysql 4096 Jul 15 03:52 round
drwx------ 2 mysql mysql 4096 Jul 22 04:57 s1
drwx------ 2 mysql mysql 4096 Jul 22 04:57 sm
drwx------ 2 mysql mysql 36864 Aug 6 23:07 super
drwx------ 2 mysql mysql 4096 Aug 6 23:07 sweet
drwxr-xr-x 2 mysql mysql 4096 Jul 15 03:39 test
drwx------ 2 mysql mysql 12288 Aug 6 23:07 th
drwx------ 2 mysql mysql 4096 Jul 22 04:57 unix
drwx------ 2 mysql mysql 4096 Jul 22 05:00 vpopmail
-
Inform here 'dir /etc/init.d/* -l | grep -i mysql | grep -v grep'
-
Output:
-rwxr-xr-x 1 root root 11587 Jan 29 2019 /etc/init.d/mysql
-rw-r--r-- 1 root root 7026 Apr 20 14:00 /etc/init.d/mysqld
Thanks plenty
-
You just watcha me like an opus of art and you dont tell me anything
-
Because strange info about your server. So, it's weird.
-
Hello I gave more gratifying permission to file mysqld and then restarted mysqld and got diferent error:
Stopping mysqld: [ OK ]
Socket file /var/lib/mysql/mysql.sock exists. Is another MySQL daemon already running with the same unix socket?
Starting mysqld: [FAILED]
Perhaps you can tell me which is the other entity using the same socket,and how to fix this cris crossed isue
Thank you for reading have nice day
-
Try 'pkill mysqld; pkill mysqld_safe; sh /script/restart'.
-
We are coming back to Graceland .Thank you a lot for reading.
It worked Mustafa you would not believe it.I could restet my mysql root pass
Output:
sh /script/reset-mysql-root-password myrootpass
Stop MySQL service...
MySQL ROOT password reset...
Start MySQL service...
Then I can login effectively to phpMyAdmin but I still get kloxo disabled page with index.php and with index.html .
Inside phpMyAdmin I got this issue
The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why.
Or alternately go to 'Operations' tab of any database to set it up there.
General relation features Disabled
Create a database named 'phpmyadmin' and setup the phpMyAdmin configuration storage there.
Could this be the issue I still get Kloxo disabled page?.I guess Im close to the edge
-
How my DNS settings have to do with the famous tables.sql script or with web cache is it possible?
-
Hello I guess that kloxo disabled page goes more with hostname rather than any other issue in 1st instance since I had to add a pid file since mysql restarted but then it didnt stop,well I guess I got an isuue with hostname that randomly would be fixed on etc/hosts meaning more /usr/sbin/resolveip issue so my question would be whats the way to do it inside kloxo thank you yes
-
Change hostname with FQDN qualification in your VPS panel (especially if using OpenVZ).
-
Hello yo I had as hostname SERVER.MYDOMAIN.COM
Now as FQDN I have WWW.MYDOMAIN.COM ,still kloxo disabled page
It is strange but after rebooting the server I still get at times
regarding mysql MariaDB server PID file could not be found!
and MariaDB server process #2316 is not running!
I had no webcache I added squid and moved to pdns from bind still kloxo
disabled page
On php info I get error 403
ERROR: Looks like you have less than 2 nameservers. According to RFC2182
section 5 you must have at least 3 nameservers, and no more than 7. Having
2 nameservers is also ok by me.
tHANK You For Reading
-
Inform here 'hostname; hostname -f; hostname -s'
-
www.MyDomain.Com
www.MyDomain.Com
www
Thank you MR I must make notice that now that I added FQDN instead of server.MyDomain.Com I cant login via ssh using my domain ,I have to use my ip
-
Nothing wrong with 'server.MyDomain.com' if you added 'CNAME Record' for 'server' in 'MyDomain.com' dns.
-
added where?
-
In your 'MyDomain.com' dns setting.
-
You are talking °inside kloxo admin° on domains?
-
Kloxo-MR will try disable all features under domains which disabled page.
Don't know what mean 'How my DNS settings have to do with the famous tables.sql script or with web cache is it possible?'?
-
I dont know what you meant MR but inside kloxo admin for CNAME I only have
ftp CN which resolved to wwww.mydomain.com
lists CN which resolved to wwww.mydomain.com
webmail CN which resolved to wwww.mydomain.com
www CN which resolved to wwww.mydomain.com
It blew me away Mustafa now I dont even have apache life neither disabled page
The famous tables.sql script came from errors like this
MariaDB server PID file could not be found!
Mustafa I need to locate my PID file firstmost
-------where?
how do I write this line on my.cnf?
pid-file = /usr/local/var/mysql/{username}.pid
please tell me where is my username on kloxo
thanks a lot
-
Go to 'admin > all > all domains > (select mydomain.com) > Manage DNS'. Click 'Add CName' and then add 'server' for 'hostname' and '__base__' for 'value'.
-
Somehow it made good in that I can login via ssh with mydomain.com
Wasnt that also Add cname for agriayperesosa.dnst ?
Im actually off apache even off my so attached disabled page ,how do I find my pid file for my.cnf Mustafa?
i guess the fact of fix criscross with mysqld and mysql is not enough for mysql .Something might happen with PHP relating mysql but I wont fix til I find PID file
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Kloxo stands on one wheel and it dont start til I restart MariaDB
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
T H A N K YOU
-
Inform here 'df -h' and 'sh /script/restart-mysql'.
-
Hi output for
'df -h'
Filesystem Size Used Avail Use% Mounted on
/dev/ploop30745p1 500G 74G 420G 28% /
none 512M 4.0K 512M 1% /dev
none 512M 0 512M 0% /dev/shm
Output for
sh /script/restart-mysql
** Process for MYSQL/MARIADB service ***
MySQL Daemon failed to start.
Starting mysqld: [FAILED]
- Process: restart
Stopping mysqld: [ OK ]
MySQL Daemon failed to start.
Starting mysqld: [FAILED]
-------------------------------------------------------------------
*** Process for MYSQL/MARIADB service ***
MySQL Daemon failed to start.
Starting mysqld: [FAILED]
- Process: restart
Stopping mysqld: [ OK ]
MySQL Daemon failed to start.
Starting mysqld: [FAILED]
-------------------------------------------------------------------
- For help, type '/script/restart-mysql [--help|-h]'
service mysql restart
MariaDB server PID file could not be found! [FAILED]
Starting MariaDB.191007 21:39:38 mysqld_safe Logging to '/var/lib/mysql/SERVER.mijey.err'.
191007 21:39:38 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
[ OK ]
$$$$$$$$$$$$$SSSSSSSSSSSSSSSSSSSSsssssSSS$$$$$$$$$$$$$$$$$$$$$$$$SSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSsssssSSSS
$$$$$$$$$$$$$SSSSSSSSSSSSSSSSSSSSsssssSSS$$$$$$$$$$$$$$$$$$$$$$$$SSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSsssssSSSS
thanks
-
Find out information in '/var/lib/mysql/SERVER.mijey.err'.
-
Hello Lamborgini
190715 03:47:43 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
190715 3:47:43 [Note] /usr/sbin/mysqld (mysqld 10.0.38-MariaDB) starting as process 28339 ...
190715 3:47:43 [Note] Plugin 'InnoDB' is disabled.
190715 3:47:43 [Note] Plugin 'FEEDBACK' is disabled.
190715 3:47:43 [Note] Server socket created on IP: '::'.
190715 3:47:43 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1286: Unknown storage engine 'InnoDB'
190715 3:47:43 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.0.38-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
190715 3:47:44 [Note] /usr/sbin/mysqld: Normal shutdown
190715 3:47:44 [Note] Event Scheduler: Purging the queue. 0 events
190715 3:47:44 [Note] /usr/sbin/mysqld: Shutdown complete
190715 03:48:12 mysqld_safe mysqld from pid file /var/lib/mysql/SERVER.4Mickey.COM.pid ended
190715 03:48:13 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
190715 3:48:13 [Note] /usr/sbin/mysqld (mysqld 10.0.38-MariaDB) starting as process 29014 ...
190715 3:48:13 [Note] Plugin 'InnoDB' is disabled.
190715 3:48:13 [Note] Plugin 'FEEDBACK' is disabled.
190715 3:48:13 [Note] Server socket created on IP: '::'.
190715 3:48:13 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1286: Unknown storage engine 'InnoDB'
190715 3:48:13 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.0.38-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
190715 3:52:31 [Note] /usr/sbin/mysqld: Normal shutdown
190719 23:45:42 mysqld_safe mysqld from pid file /var/lib/mysql/SERVER.4Mickey.COM.pid ended
190719 23:46:23 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
190719 23:46:24 [Note] /usr/sbin/mysqld (mysqld 10.0.38-MariaDB) starting as process 922 ...
190719 23:46:24 [Note] Plugin 'InnoDB' is disabled.
190719 23:46:24 [Note] Plugin 'FEEDBACK' is disabled.
190719 23:46:24 [Note] Server socket created on IP: '::'.
190719 23:46:25 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1286: Unknown storage engine 'InnoDB'
190719 23:46:25 [Note] /usr/sbin/mysqld: ready for connections.
190720 00:18:59 mysqld_safe mysqld from pid file /var/lib/mysql/SERVER.4Mickey.COM.pid ended
190720 00:19:40 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
190720 0:19:41 [Note] /usr/sbin/mysqld (mysqld 10.0.38-MariaDB) starting as process 922 ...
190720 0:19:41 [Note] Plugin 'InnoDB' is disabled.
190720 0:19:41 [Note] Plugin 'FEEDBACK' is disabled.
190720 0:19:41 [Note] Server socket created on IP: '::'.
190930 15:48:29 [Note] InnoDB: Completed initialization of buffer pool
190930 15:48:29 [Note] InnoDB: Highest supported file format is Barracuda.
190930 15:48:29 [Note] InnoDB: The log sequence numbers 1617243 and 1617243 in ibdata files do not match the log sequence number 1617253 in the ib_logfiles!
190930 15:48:29 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
190930 15:48:29 [Note] InnoDB: 128 rollback segment(s) are active.
190930 15:48:29 [Note] InnoDB: Waiting for purge to start
190930 15:48:29 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.42-84.2 started; log sequence number 1617253
190930 15:48:29 [Note] Plugin 'FEEDBACK' is disabled.
190930 15:48:29 [Note] Server socket created on IP: '::'.
190930 15:48:29 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.0.38-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
190930 15:51:38 [Note] /usr/sbin/mysqld: Normal shutdown
190930 15:51:38 [Note] Event Scheduler: Purging the queue. 0 events
190930 15:51:38 [Note] InnoDB: FTS optimize thread exiting.
190930 15:51:38 [Note] InnoDB: Starting shutdown...
190930 15:51:39 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
190930 15:51:40 [Note] InnoDB: Shutdown completed; log sequence number 1617263
190930 15:51:40 [Note] /usr/sbin/mysqld: Shutdown complete
191007 21:50:55 mysqld_safe mysqld from pid file /var/lib/mysql/SERVER.4Mickey.COM.pid ended
191009 19:11:59 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
191009 19:12:00 [Note] /usr/sbin/mysqld (mysqld 10.0.38-MariaDB) starting as process 942 ...
191009 19:12:00 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
191009 19:12:00 [Note] InnoDB: Using mutexes to ref count buffer pool pages
191009 19:12:00 [Note] InnoDB: The InnoDB memory heap is disabled
191009 19:12:00 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
191009 19:12:00 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
191009 19:12:00 [Note] InnoDB: Compressed tables use zlib 1.2.3
191009 19:12:00 [Note] InnoDB: Using CPU crc32 instructions
191009 19:12:00 [Note] InnoDB: Initializing buffer pool, size = 128.0M
191009 19:12:00 [Note] InnoDB: Completed initialization of buffer pool
191009 19:12:00 [Note] InnoDB: Highest supported file format is Barracuda.
191009 19:12:00 [Note] InnoDB: 128 rollback segment(s) are active.
191009 19:12:00 [Note] InnoDB: Waiting for purge to start
191009 19:12:00 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.42-84.2 started; log sequence number 1617273
191009 19:12:00 [Note] Plugin 'FEEDBACK' is disabled.
191009 19:12:00 [Note] Server socket created on IP: '::'.
191009 19:12:00 [ERROR] mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 2 "No such file or directory")
191009 19:12:00 [ERROR] Can't start server: can't create PID file: No such file or directory
191009 19:12:00 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
T H A N K YOU
-
Inform 'dir /etc/my.cnf.d/* -l ; cat /etc/my.cnf.d/server.cnf'