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

Title: Mysql 111 ERROR _-_Kloxo Disabled page
Post 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
Title: Re: Mysql 111 ERROR _-_Kloxo Disabled page
Post by: MRatWork on 2019-08-21, 03:22:15
Try 'sh /script/reset-mysql-root-password YourNewPassword'.
Title: Re: Mysql 111 ERROR _-_Kloxo Disabled page
Post by: South on 2019-08-22, 05:37:40
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?
Title: Re: Mysql 111 ERROR _-_Kloxo Disabled page
Post by: MRatWork on 2019-08-22, 05:42:00
Inform here 'sh /script/sysinfo'.
Title: Re: Mysql 111 ERROR _-_Kloxo Disabled page
Post by: South on 2019-08-22, 06:04:37
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
Title: Re: Mysql 111 ERROR _-_Kloxo Disabled page
Post by: MRatWork on 2019-08-22, 07:13:37
Inform 'dir /etc/init.d/ -l ; dir /var/lib/ -l ; dir /var/lib/mysql/ -l '
Title: Re: Mysql 111 ERROR _-_Kloxo Disabled page
Post by: South on 2019-08-23, 21:59:07
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






Title: Re: Mysql 111 ERROR _-_Kloxo Disabled page
Post by: MRatWork on 2019-08-24, 05:48:19
Inform here 'dir /etc/init.d/* -l | grep -i mysql | grep -v grep'
Title: Re: Mysql 111 ERROR _-_Kloxo Disabled page
Post by: South on 2019-08-26, 09:03:43
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
Title: Re: Mysql 111 ERROR _-_Kloxo Disabled page
Post by: South on 2019-08-28, 19:12:33
You just watcha me like an opus of art and you dont tell me anything
Title: Re: Mysql 111 ERROR _-_Kloxo Disabled page
Post by: MRatWork on 2019-08-29, 02:45:08
Because strange info about your server. So, it's weird.
Title: Re: Mysql 111 ERROR _-_Kloxo Disabled page
Post by: South on 2019-08-29, 04:03:17
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
Title: Re: Mysql 111 ERROR _-_Kloxo Disabled page
Post by: MRatWork on 2019-08-29, 04:20:13
Try 'pkill mysqld; pkill mysqld_safe; sh /script/restart'.
Title: Re: Mysql 111 ERROR _-_Kloxo Disabled page
Post by: South on 2019-08-30, 09:15:12
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

Title: Re: Mysql 111 ERROR _-_Kloxo Disabled page
Post by: South on 2019-09-09, 15:28:09
How my DNS settings have to do with the famous tables.sql script or with web cache is it possible?
Title: Re: Mysql 111 ERROR _-_Kloxo Disabled page
Post by: South on 2019-09-13, 09:50:33
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
Title: Re: Mysql 111 ERROR _-_Kloxo Disabled page
Post by: MRatWork on 2019-09-13, 15:35:58
Change hostname with FQDN qualification in your VPS panel (especially if using OpenVZ).
Title: Re: Mysql 111 ERROR _-_Kloxo Disabled page
Post by: South on 2019-09-16, 18:00:27
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
Title: Re: Mysql 111 ERROR _-_Kloxo Disabled page
Post by: MRatWork on 2019-09-17, 09:39:01
Inform here 'hostname; hostname -f; hostname -s'
Title: Re: Mysql 111 ERROR _-_Kloxo Disabled page
Post by: South on 2019-09-18, 09:10:40

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
Title: Re: Mysql 111 ERROR _-_Kloxo Disabled page
Post by: MRatWork on 2019-09-19, 05:43:42

Nothing wrong with 'server.MyDomain.com' if you added 'CNAME Record' for 'server' in 'MyDomain.com' dns.
Title: Re: Mysql 111 ERROR _-_Kloxo Disabled page
Post by: South on 2019-09-19, 11:09:55
added where?
Title: Re: Mysql 111 ERROR _-_Kloxo Disabled page
Post by: MRatWork on 2019-09-19, 13:22:59
In your 'MyDomain.com' dns setting.
Title: Re: Mysql 111 ERROR _-_Kloxo Disabled page
Post by: South on 2019-09-20, 22:29:54
You are talking °inside kloxo admin° on domains? 
Title: Re: Mysql 111 ERROR _-_Kloxo Disabled page
Post by: MRatWork on 2019-09-21, 10:18:49
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?'?
Title: Re: Mysql 111 ERROR _-_Kloxo Disabled page
Post by: South on 2019-09-29, 20:08:39

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
Title: Re: Mysql 111 ERROR _-_Kloxo Disabled page
Post by: MRatWork on 2019-09-30, 01:47:29
Go to 'admin > all > all domains > (select mydomain.com) > Manage DNS'. Click 'Add CName' and then add 'server' for 'hostname' and '__base__' for 'value'.
Title: Re: Mysql 111 ERROR _-_Kloxo Disabled page
Post by: South on 2019-09-30, 21:59:51
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
Title: Re: Mysql 111 ERROR _-_Kloxo Disabled page
Post by: MRatWork on 2019-10-01, 02:00:03
Inform here 'df -h' and 'sh /script/restart-mysql'.
Title: Re: Mysql 111 ERROR _-_Kloxo Disabled page
Post by: South on 2019-10-08, 03:55:34
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


Title: Re: Mysql 111 ERROR _-_Kloxo Disabled page
Post by: MRatWork on 2019-10-08, 05:44:33
Find out information in '/var/lib/mysql/SERVER.mijey.err'.
Title: Re: Mysql 111 ERROR _-_Kloxo Disabled page
Post by: South on 2019-10-10, 04:24:45
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
Title: Re: Mysql 111 ERROR _-_Kloxo Disabled page
Post by: MRatWork on 2019-10-10, 05:12:06
Inform 'dir /etc/my.cnf.d/* -l ; cat /etc/my.cnf.d/server.cnf'