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. 2017-11-08, 02:25:12

Author Topic: mysql error  (Read 4536 times)

0 Members and 1 Guest are viewing this topic.

Offline spurpose35

  • Junior Member
  • *
  • Posts: 22
  • Karma: +0/-0
    • View Profile
mysql error
« on: 2014-08-03, 18:45:50 »
Hello,

i have issues with mysql in Kloxo MR even after updating..

Below is the screenshot of the error. when i restart mysqld service everything will be normal.

http://pokit.org/get/?49fdc4af4622bfd2d184af13ad41398f.jpg

Online MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: mysql error
« Reply #1 on: 2014-08-04, 19:36:22 »
Investigate '/etc/my.cnf'. It's must have 'socket= /var/lib/mysql/mysql.sock' under '[mysqld]'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline spurpose35

  • Junior Member
  • *
  • Posts: 22
  • Karma: +0/-0
    • View Profile
Re: mysql error
« Reply #2 on: 2014-08-05, 09:40:26 »
Investigate '/etc/my.cnf'. It's must have 'socket= /var/lib/mysql/mysql.sock' under '[mysqld]'.

i don't see exactly the same value, here is my my.cnf contents
Please let me know if any changes are require

Code: [Select]
##  _______________________________________________________________________ 
## / Rackspace MySQL 5.5 Terse Configuration File                          \
## |                                                                       |
## | This is a base configuration file containing the most frequently used |
## | settings with reasonably defined default values for configuring and   |
## | tuning MySQL. Note that these settings can likely be further tuned in |
## | order to get optimum performance from MySQL based upon the database   |
## | configuration and hardware platform.                                  |
## |                                                                       |
## | While the settings provided are likely sufficient for most            |
## | situations, an exhaustive list of settings (with descriptions) can be |
## | found at:                                                             |
## | http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html   |
## |                                                                       |
## | Take care to only add/remove/change a setting if you are comfortable  |
## | doing so! For Rackspace customers, if you have any questions or       |
## | concerns, please contact the MySQL Database Services Team. Be aware   |
## | that some work performed by this team can involve additional billable |
## \ fees.                                                                 /
##  -----------------------------------------------------------------------
##         \   ^__^
##          \  (oo)\_______
##             (__)\       )\/\
##                 ||----w |
##                 ||     ||

[mysqld]
skip-innodb
default-storage-engine=myisam

## General
datadir                         = /var/lib/mysql
tmpdir                          = /var/lib/mysqltmp
socket                          = /var/lib/mysql/mysql.sock
skip-name-resolve
sql-mode                        = NO_ENGINE_SUBSTITUTION
#event-scheduler                = 1

## Cache
thread-cache-size               = 16
table-open-cache                = 4096
table-definition-cache          = 2048
query-cache-size                = 32M
query-cache-limit               = 1M

## Per-thread Buffers
sort-buffer-size                = 1M
read-buffer-size                = 1M
read-rnd-buffer-size            = 1M
join-buffer-size                = 1M

## Temp Tables
tmp-table-size                  = 32M
max-heap-table-size             = 64M

## Networking
back-log                        = 100
max-connections                 = 300
max-connect-errors              = 10000
max-allowed-packet              = 16M
interactive-timeout             = 3600
wait-timeout                    = 600

### Storage Engines
innodb                          = FORCE

## MyISAM
key-buffer-size                 = 64M
myisam-sort-buffer-size         = 128M

## InnoDB
#innodb-buffer-pool-size        = 128M
#innodb-log-file-size           = 100M
#innodb-log-buffer-size         = 8M
#innodb-file-per-table          = 1
#innodb-open-files              = 300

## Replication
server-id                       = 1
#log-bin                        = /var/log/mysql/bin-log
#relay-log                      = /var/log/mysql/relay-log
relay-log-space-limit           = 16G
expire-logs-days                = 7
#read-only                      = 1
#sync-binlog                    = 1
#log-slave-updates              = 1
#binlog-format                  = STATEMENT
#auto-increment-offset          = 1
#auto-increment-increment       = 2

## Logging
#log-output                      = FILE
#slow-query-log                  = 1
#slow-query-log-file             = /var/log/mysql/slow-log
#log-slow-slave-statements
#long-query-time                 = 2

[mysqld_safe]
log-error                       = /var/log/mysqld.log
open-files-limit                = 65535

[mysql]
no-auto-rehash

Online MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: mysql error
« Reply #3 on: 2014-08-05, 14:24:38 »
Modified:
Code: [Select]
[mysqld]
skip-innodb
default-storage-engine=myisam
to:
Code: [Select]
[mysqld]
socket= /var/lib/mysql/mysql.sock
skip-innodb
default-storage-engine=myisam
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline spurpose35

  • Junior Member
  • *
  • Posts: 22
  • Karma: +0/-0
    • View Profile
Re: mysql error
« Reply #4 on: 2014-08-05, 20:28:03 »
Modified:
Code: [Select]
[mysqld]
skip-innodb
default-storage-engine=myisam
to:
Code: [Select]
[mysqld]
socket= /var/lib/mysql/mysql.sock
skip-innodb
default-storage-engine=myisam

But i can see these lines already in my.cnf file, see below

Code: [Select]
[mysqld]
skip-innodb
default-storage-engine=myisam

## General
datadir                         = /var/lib/mysql
tmpdir                          = /var/lib/mysqltmp
socket                          = /var/lib/mysql/mysql.sock

Online MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: mysql error
« Reply #5 on: 2014-08-05, 23:33:23 »
Inform here 'sh /script/sysinfo'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline spurpose35

  • Junior Member
  • *
  • Posts: 22
  • Karma: +0/-0
    • View Profile
Re: mysql error
« Reply #6 on: 2014-08-07, 08:46:59 »
Inform here 'sh /script/sysinfo'.

Please find below output for the suggested command

Code: [Select]
[root@servername ~]# sh /script/sysinfo

A. Kloxo-MR: 6.5.1.b-2014072901

B. OS: CentOS release 6.5 (Final) x86_64

C. Apps:
   1. MySQL: mysql55-5.5.38-1.ius.el6.x86_64
   2. PHP: php54-5.4.30-1.ius.el6.x86_64
   3. Httpd: httpd-2.2.27-1.mr.e6.x86_64
   4. Lighttpd: --uninstalled--
   5. Hiawatha: hiawatha-9.7.b-1.mr.el6.x86_64
   6. Nginx: --uninstalled--
   7. Cache: varnish-3.0.5-1.el6.x86_64
   8. Dns: bind-9.8.2-0.23.rc1.el6_5.1.x86_64
   9. Qmail: qmail-toaster-1.03-1.3.38.mr.el6.x86_64
      - with: courier-imap-toaster-4.1.2-1.3.16.mr.el6.x86_64

D. Php-type (for Httpd/proxy): php-fpm_event

E. Memory:
                total       used       free     shared    buffers     cached
   Mem:          1974       1645        329          0        187       1036
   -/+ buffers/cache:        421       1553
   Swap:         1022         20       1002

[root@servername ~]#


Online MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: mysql error
« Reply #7 on: 2014-08-07, 09:43:53 »
Try add inside /etc/my.cnf with:
Code: [Select]
[client]
socket=/var/lib/mysql/mysql.sock

Also running 'sh /script/mysql-convert --engine=myisam'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline spurpose35

  • Junior Member
  • *
  • Posts: 22
  • Karma: +0/-0
    • View Profile
Re: mysql error
« Reply #8 on: 2014-08-08, 08:54:10 »
Try add inside /etc/my.cnf with:
Code: [Select]
[client]
socket=/var/lib/mysql/mysql.sock

Also running 'sh /script/mysql-convert --engine=myisam'.

i have added as per your suggestion. i will keep this under observation for a week and will all let you know

thanks

Offline spurpose35

  • Junior Member
  • *
  • Posts: 22
  • Karma: +0/-0
    • View Profile
Re: mysql error
« Reply #9 on: 2014-08-09, 18:42:14 »
Try add inside /etc/my.cnf with:
Code: [Select]
[client]
socket=/var/lib/mysql/mysql.sock

Also running 'sh /script/mysql-convert --engine=myisam'.

i have added as per your suggestion. i will keep this under observation for a week and will all let you know

thanks


i was not receiving sql error but noticed sometimes it takes almost 20 seconds to load website, so thought to switch webserver to nginx, unfortunately site is not opening after that and instead opening as below. Please help ASAP

Note : I am using later version of kloxo MR

http://pokit.org/get/?903e08a8aef3af994fa61d590875364b.jpg

Online MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: mysql error
« Reply #10 on: 2014-08-09, 23:01:29 »
Maybe you optimize mysql. Try install mysqltuner with 'yum install mysqltuner' and then run 'mysqltuner'.

Also, inform here 'dir -l /var/lib/mysql'
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline spurpose35

  • Junior Member
  • *
  • Posts: 22
  • Karma: +0/-0
    • View Profile
Re: mysql error
« Reply #11 on: 2014-08-10, 08:16:25 »
Maybe you optimize mysql. Try install mysqltuner with 'yum install mysqltuner' and then run 'mysqltuner'.

Also, inform here 'dir -l /var/lib/mysql'

ok

1. i have installed mysqltuner but when ran 'mysqltuner' it asks for admin username/password. -> after this do i have to run any commands?

2. below is the screenshot for 'dir -l /var/lib/mysql'

http://gyazo.com/a4fa19aed2299df2e70cc6d31e09e6d1

Online MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: mysql error
« Reply #12 on: 2014-08-10, 08:26:11 »
You can see the password inside /usr/local/lxlabs/kloxo/etc/slavedb/dbadmin.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline spurpose35

  • Junior Member
  • *
  • Posts: 22
  • Karma: +0/-0
    • View Profile
Re: mysql error
« Reply #13 on: 2014-08-10, 09:33:57 »
You can see the password inside /usr/local/lxlabs/kloxo/etc/slavedb/dbadmin.

everything done but still if i change webserver to nginx, page is not loading..

http://pokit.org/get/?903e08a8aef3af994fa61d590875364b.jpg

Online MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: mysql error
« Reply #14 on: 2014-08-10, 17:03:44 »
If you able to access to cp.yourdomain.com and webmail.yourdomain.com that mean something wrong with your php code in your website.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

 


MRatWork Affiliates:    BIGRAF(R) Inc.    House of LMAR    EFARgrafix

Page created in 0.033 seconds with 17 queries.

web stats analysis
 
Mirror created by MasterkinG32.CoM