Sponsor:

Server and Web Integrator
Link:
Kloxo-MR logo
6.5.0 or 7.0.0
Click for "How to install"
Donation/Sponsorship:
Kloxo-MR is open-source.
Donate and or Sponsorship always welcome.
Click to:
Click Here
Please login or register. 2024-03-28, 23:12:03

Author Topic: Mysql 111 ERROR _-_Kloxo Disabled page  (Read 16551 times)

0 Members and 1 Guest are viewing this topic.

Offline South

  • Valuable Member
  • *
  • Posts: 108
  • Karma: +0/-0
    • View Profile
Mysql 111 ERROR _-_Kloxo Disabled page
« 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
« Last Edit: 2019-08-20, 04:59:46 by South »

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Mysql 111 ERROR _-_Kloxo Disabled page
« Reply #1 on: 2019-08-21, 03:22:15 »
Try 'sh /script/reset-mysql-root-password YourNewPassword'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline South

  • Valuable Member
  • *
  • Posts: 108
  • Karma: +0/-0
    • View Profile
Re: Mysql 111 ERROR _-_Kloxo Disabled page
« Reply #2 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?

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Mysql 111 ERROR _-_Kloxo Disabled page
« Reply #3 on: 2019-08-22, 05:42:00 »
Inform here 'sh /script/sysinfo'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline South

  • Valuable Member
  • *
  • Posts: 108
  • Karma: +0/-0
    • View Profile
Re: Mysql 111 ERROR _-_Kloxo Disabled page
« Reply #4 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

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Mysql 111 ERROR _-_Kloxo Disabled page
« Reply #5 on: 2019-08-22, 07:13:37 »
Inform 'dir /etc/init.d/ -l ; dir /var/lib/ -l ; dir /var/lib/mysql/ -l '
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline South

  • Valuable Member
  • *
  • Posts: 108
  • Karma: +0/-0
    • View Profile
Re: Mysql 111 ERROR _-_Kloxo Disabled page
« Reply #6 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







Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Mysql 111 ERROR _-_Kloxo Disabled page
« Reply #7 on: 2019-08-24, 05:48:19 »
Inform here 'dir /etc/init.d/* -l | grep -i mysql | grep -v grep'
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline South

  • Valuable Member
  • *
  • Posts: 108
  • Karma: +0/-0
    • View Profile
Re: Mysql 111 ERROR _-_Kloxo Disabled page
« Reply #8 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

Offline South

  • Valuable Member
  • *
  • Posts: 108
  • Karma: +0/-0
    • View Profile
Re: Mysql 111 ERROR _-_Kloxo Disabled page
« Reply #9 on: 2019-08-28, 19:12:33 »
You just watcha me like an opus of art and you dont tell me anything

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Mysql 111 ERROR _-_Kloxo Disabled page
« Reply #10 on: 2019-08-29, 02:45:08 »
Because strange info about your server. So, it's weird.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline South

  • Valuable Member
  • *
  • Posts: 108
  • Karma: +0/-0
    • View Profile
Re: Mysql 111 ERROR _-_Kloxo Disabled page
« Reply #11 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

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Mysql 111 ERROR _-_Kloxo Disabled page
« Reply #12 on: 2019-08-29, 04:20:13 »
Try 'pkill mysqld; pkill mysqld_safe; sh /script/restart'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline South

  • Valuable Member
  • *
  • Posts: 108
  • Karma: +0/-0
    • View Profile
Re: Mysql 111 ERROR _-_Kloxo Disabled page
« Reply #13 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


Offline South

  • Valuable Member
  • *
  • Posts: 108
  • Karma: +0/-0
    • View Profile
Re: Mysql 111 ERROR _-_Kloxo Disabled page
« Reply #14 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?

 


Top 10 Social Networking:    Facebook    Twitter    LinkedIn    Pinterest    Google Plus    Tumblr    Instagram    VK    Flickr    Vine

Page created in 0.067 seconds with 19 queries.

web stats analysis