Messages

31

Kloxo-MR Technical Helps / Re: MySQL error in Kloxo-MR 7

« on: 2015-06-06, 06:25:25 »

Try 'rm -f /tmp/phpm-install-process.sh; rm -f /tmp/multiple_php_install.tmp; sh /script/phpm-all-install'.

Thank you. it is ok
I'm don't understand after config iptables and run:

Code: [Select]

[root@bns ~]# service iptables status
Table: filter
Chain INPUT (policy ACCEPT)
num  target     prot opt source               destination
1    ACCEPT     all  --  0.0.0.0/0            0.0.0.0/0
2    ACCEPT     all  --  0.0.0.0/0            0.0.0.0/0
3    LOG        all  --  0.0.0.0/0            0.0.0.0/0           LOG flags 0 level 7 prefix `BANDWIDTH_IN:'
4    ACCEPT     tcp  --  210.8x.xx.xx/24      0.0.0.0/0           tcp dpt:xx
5    ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0           tcp dpt:xx
6    ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0           tcp dpt:xx
7    ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0           tcp dpt:80
8    ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0           tcp dpt:xx
....................
but in MR-Kloxo panel is:

32

Kloxo-MR Technical Helps / Re: MySQL error in Kloxo-MR 7

« on: 2015-06-06, 05:24:48 »

I'm select and Wait until background process to install 'multiple php' finished but show error:
Alert: Other install process still running [localhost]

And don't select php53m in PHP Used
My site show error

Code: [Select]

Mysqli prepare error: Table xf_user_change_log is marked as crashed and should be repaired

33

Kloxo-MR Technical Helps / Re: How to limit connection MySQL

« on: 2015-06-05, 19:12:46 »

Don't panic. Try 'pkill -9 mysql; sh /script/restart-mysql -y'.

Show mess:

Code: [Select]

[root@bns ~]# pkill -9 mysql; sh /script/restart-mysql -y

 ERROR! MySQL server PID file could not be found!
Starting MySQL. SUCCESS!
-------------------------------------------------------------------

- For help, type '/script/restart-mysql [--help|-h]'



34

Kloxo-MR Technical Helps / Re: How to limit connection MySQL

« on: 2015-06-05, 18:50:32 »

In most situation, 100 is enough.

Thanks!
But i'm restart MySQL show error??

Code: [Select]

[root@bns ~]# service mysql restart
 ERROR! MySQL server PID file could not be found!
Starting MySQL SUCCESS!



35

Kloxo-MR Technical Helps / Re: How to limit connection MySQL

« on: 2015-06-05, 18:41:24 »

Add 'max-connections=100' under '[mysqld]' in /etc/my.cnf.d/server.cnf

I'm edited:

Code: [Select]

[mysqld]
max_connections = 400
max_user_connections=200
performance_schema=on
default-storage-engine=myisam
skip-innodb
#OpenVZ AIO bug fix
..................................
OK?

36

Kloxo-MR Technical Helps / How to limit connection MySQL

« on: 2015-06-05, 17:56:28 »

How to limit about 200 connection MySQL?
Thanks!

Code: [Select]

A. Kloxo-MR: 7.0.0.b-2015053102
   - Web: hiawatha-9.13.0-f.6.mr.el6.x86_64
   - PHP: php54s-5.4.41-1.ius.el6 (fpm mode)
B. Plateform:
   - OS: CentOS release 6.6 (Final) x86_64
   - Hostname: bns.bachngocsach.net
C. Services:
   1. MySQL: MariaDB-server-10.0.19-1.el6.x86_64
   2. PHP:
      - Branch: php53u-5.3.29-1.ius.el6.x86_64
   3. Httpd: httpd-2.2.29-2.mr.el6.x86_64
      - PHP Type: php-fpm_event
   4. Lighttpd: --uninstalled--
   5. Hiawatha: --unused--
   6. Nginx: --uninstalled--
   7. Cache: varnish-3.0.7-1.el6.x86_64
   8. Dns: bind-9.9.5-1.el6.x86_64
   9. Qmail: qmail-toaster-1.03-1.3.55.mr.el6.x86_64
      - with: courier-imap-toaster-4.1.2-1.3.18.mr.el6.x86_64

37

Kloxo-MR Technical Helps / Re: MySQL error in Kloxo-MR 7

« on: 2015-06-05, 17:54:00 »

If database using innodb as storage-engine, modified /etc/my.cnf.d/server.conf to change 'skip-innodb' to '#skip-innodb' (before restore database). And then restart with 'sh /script/restart-mysql -y'.

Okie, thanks!

38

Kloxo-MR Technical Helps / Re: MySQL error in Kloxo-MR 7

« on: 2015-06-05, 16:17:07 »

1. Move your extract of bn.sql.gz to /tmp and then use phpmyadmin to import this sql file
2. Still wrong if using 'bachngocsach.com'. Better using 'subdom.bachngocsach.com' (change subdom like you want)
3. Wait until background process to install 'multiple php' finished

1. My DB is 2GB (gzip)

39

Kloxo-MR Technical Helps / Re: MySQL error in Kloxo-MR 7

« on: 2015-06-05, 15:34:49 »

1. Inform your step for restore data
2. Your hostname is wrong. It's must something like 'server1.domain.com' instead 'server1'
3. Instead using php branch, better install 'multiple php' via 'multiple php install' in 'webserver configure' and then use 'php53m' instead 'php branch' in 'php used'

1Restore:
gunzip < bn.sql.gz | mysql -u bachngoc_bnxen -p bachngoc_bnxen

2. Hostname is: bachngocsach.com

3. Select and update Multiple PHP Install error:
Alert: Other install process still running [localhost]

40

Kloxo-MR Technical Helps / Re: MySQL error in Kloxo-MR 7

« on: 2015-06-05, 14:41:42 »

Try login to phpmyadmin from panel and investigate this database.

Login okie with user and pass in website

A. Kloxo-MR: 7.0.0.b-2015053102
   - Web: hiawatha-9.13.0-f.6.mr.el6.x86_64
   - PHP: php54s-5.4.41-1.ius.el6 (fpm mode)
B. Plateform:
   - OS: CentOS release 6.6 (Final) x86_64
   - Hostname: bachngocsach
C. Services:
   1. MySQL: MariaDB-server-10.0.19-1.el6.x86_64
   2. PHP:
      - Branch: php53u-5.3.29-1.ius.el6.x86_64
   3. Httpd: httpd-2.2.29-2.mr.el6.x86_64
      - PHP Type: php-fpm_event
   4. Lighttpd: --uninstalled--
   5. Hiawatha: --unused--
   6. Nginx: --uninstalled--
   7. Cache: varnish-3.0.7-1.el6.x86_64
   8. Dns: bind-9.9.5-1.el6.x86_64
   9. Qmail: qmail-toaster-1.03-1.3.55.mr.el6.x86_64
      - with: courier-imap-toaster-4.1.2-1.3.18.mr.el6.x86_64

41

Kloxo-MR Technical Helps / Re: MySQL error in Kloxo-MR 7

« on: 2015-06-05, 14:40:36 »

I'm re-restore and no error, and username and password for mysql data in website ok.
I'm search google is edit file MySQL config file:

wait_timeout = 600
connect_timeout = 120
max_allowed_packet = 14MB

But i'm not found it

42

Kloxo-MR Technical Helps / Re: MySQL error in Kloxo-MR 7

« on: 2015-06-05, 14:18:32 »

I'm new install Mr-Kloxo 7 on CentOS 6.5 success!
Access panel ok.
But after restore DB is access wwebsite (bachngocsach.com) show error : An unexpected database error occurred. Please try again later.

43

Kloxo-MR Technical Helps / MySQL error in Kloxo-MR 7

« on: 2015-06-05, 14:01:18 »

Hi all!
My site show error:
An unexpected database error occurred. Please try again later.

I'm find /etc/my.cnf edit wait_timeout, connect_timeout, max_allowed_packet but not found
Pleae help!

44

Kloxo-MR Technical Helps / Re: MySQL error?

« on: 2014-12-01, 08:38:53 »

Inform here:

Code: [Select]

ulimit -a
cat /etc/security/limits.conf
cat /etc/sysctl.conf
cat /etc/my.cnf

Code: [Select]

ulimit -a
core file size          (blocks, -c) 0
data seg size           (kbytes, -d) unlimited
scheduling priority             (-e) 0
file size               (blocks, -f) unlimited
pending signals                 (-i) 71680
max locked memory       (kbytes, -l) 32
max memory size         (kbytes, -m) unlimited
open files                      (-n) 20480
pipe size            (512 bytes, -p) 8
POSIX message queues     (bytes, -q) 819200
real-time priority              (-r) 0
stack size              (kbytes, -s) 10240
cpu time               (seconds, -t) unlimited
max user processes              (-u) 71680
virtual memory          (kbytes, -v) unlimited
file locks                      (-x) unlimited
and

Code: [Select]

cat /etc/security/limits.conf
# /etc/security/limits.conf
#
#Each line describes a limit for a user in the form:
#
#<domain>        <type>  <item>  <value>
#
#Where:
#<domain> can be:
#        - an user name
#        - a group name, with @group syntax
#        - the wildcard *, for default entry
#        - the wildcard %, can be also used with %group syntax,
#                 for maxlogin limit
#
#<type> can have the two values:
#        - "soft" for enforcing the soft limits
#        - "hard" for enforcing hard limits
#
#<item> can be one of the following:
#        - core - limits the core file size (KB)
#        - data - max data size (KB)
#        - fsize - maximum filesize (KB)
#        - memlock - max locked-in-memory address space (KB)
#        - nofile - max number of open files
#        - rss - max resident set size (KB)
#        - stack - max stack size (KB)
#        - cpu - max CPU time (MIN)
#        - nproc - max number of processes
#        - as - address space limit
#        - maxlogins - max number of logins for this user
#        - maxsyslogins - max number of logins on the system
#        - priority - the priority to run user process with
#        - locks - max number of file locks the user can hold
#        - sigpending - max number of pending signals
#        - msgqueue - max memory used by POSIX message queues (bytes)
#        - nice - max nice priority allowed to raise to
#        - rtprio - max realtime priority
#
#<domain>      <type>  <item>         <value>
#

#*               soft    core            0
#*               hard    rss             10000
#@student        hard    nproc           20
#@faculty        soft    nproc           20
#@faculty        hard    nproc           50
#ftp             hard    nproc           0
#@student        -       maxlogins       4

# End of file

### begin -- add by Kloxo-MR
*                soft   nofile           20480
*                hard   nofile           40960
### end -- add by Kloxo-MR

cat /etc/sysctl.conf

Code: [Select]

]# cat /etc/sysctl.conf
# Kernel sysctl configuration file for Red Hat Linux
#
# For binary values, 0 is disabled, 1 is enabled.  See sysctl(8) and
# sysctl.conf(5) for more details.

# Controls IP packet forwarding
net.ipv4.ip_forward = 0

# Controls source route verification
net.ipv4.conf.default.rp_filter = 1

# Do not accept source routing
net.ipv4.conf.default.accept_source_route = 0

# Controls the System Request debugging functionality of the kernel
kernel.sysrq = 0

# Controls whether core dumps will append the PID to the core filename
# Useful for debugging multi-threaded applications
kernel.core_uses_pid = 1

# Controls the use of TCP syncookies
net.ipv4.tcp_syncookies = 1

# Controls the maximum size of a message, in bytes
kernel.msgmnb = 65536

# Controls the default maxmimum size of a mesage queue
kernel.msgmax = 65536

# Controls the maximum shared segment size, in bytes
kernel.shmmax = 68719476736

# Controls the maximum number of shared memory segments, in pages
kernel.shmall = 4294967296

### begin -- add by Kloxo-MR
fs.file-max = 209708
vm.swappiness = 10
vm.vfs_cache_pressure = 50
vm.dirty_background_ratio = 15
vm.dirty_ratio = 5
### end -- add by Kloxo-MR

cat /etc/my.cnf

Code: [Select]

# cat /etc/sysctl.conf
# Kernel sysctl configuration file for Red Hat Linux
#
# For binary values, 0 is disabled, 1 is enabled.  See sysctl(8) and
# sysctl.conf(5) for more details.

# Controls IP packet forwarding
net.ipv4.ip_forward = 0

# Controls source route verification
net.ipv4.conf.default.rp_filter = 1

# Do not accept source routing
net.ipv4.conf.default.accept_source_route = 0

# Controls the System Request debugging functionality of the kernel
kernel.sysrq = 0

# Controls whether core dumps will append the PID to the core filename
# Useful for debugging multi-threaded applications
kernel.core_uses_pid = 1

# Controls the use of TCP syncookies
net.ipv4.tcp_syncookies = 1

# Controls the maximum size of a message, in bytes
kernel.msgmnb = 65536

# Controls the default maxmimum size of a mesage queue
kernel.msgmax = 65536

# Controls the maximum shared segment size, in bytes
kernel.shmmax = 68719476736

# Controls the maximum number of shared memory segments, in pages
kernel.shmall = 4294967296

### begin -- add by Kloxo-MR
fs.file-max = 209708
vm.swappiness = 10
vm.vfs_cache_pressure = 50
vm.dirty_background_ratio = 15
vm.dirty_ratio = 5
### end -- add by Kloxo-MR

[root@bachngocsach ~]# cat /etc/my.cnf
##  _______________________________________________________________________
## / 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
#OpenVZ AIO bug fix
innodb_use_native_aio=0

## 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                = 200
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



45

Kloxo-MR Technical Helps / Re: MySQL error?

« on: 2014-12-01, 08:00:29 »

Look like your mysql database using old format.

The first time, run 'sh /script/mysql-convert --engine=myisam' and then run 'mysql_upgrade'

Thanks!
But after run 'htop' is:

Error 'open-files-limit  = 65535' ?