MRatWork Forum by Mustafa Ramadhan
Sawo Project - Kloxo-MR Discussions => Kloxo-MR Technical Helps => Topic started by: hoangsang 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!
-
What's about panel. Also probl with login?.
-
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.
-
Possible restore process was failed and or wrong username and password for mysql data in website.
-
Try login to phpmyadmin from panel and investigate this database.
-
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 :(
-
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
-
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'
-
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]
-
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. 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) :(
-
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'.
-
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!
-
I'm select and Wait until background process to install 'multiple php' finished but show error:
Alert: Other install process still running [localhost]
(http://s18.postimg.org/3ve140puh/Untitled.png)
And don't select php53m in PHP Used
My site show error :(
Mysqli prepare error: Table xf_user_change_log is marked as crashed and should be repaired
-
Try 'rm -f /tmp/phpm-install-process.sh; rm -f /tmp/multiple_php_install.tmp; sh /script/phpm-all-install'.
-
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:
[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:
(http://s15.postimg.org/edsfilw3v/Untitled.png)
-
Kloxo-MR inactivated iptables in install process with rename /etc/sysconfig/iptables to iptables.kloxosave and /etc/sysconfig/ip6tables to ip6tables.kloxosave.
-
Kloxo-MR inactivated iptables in install process with rename /etc/sysconfig/iptables to iptables.kloxosave and /etc/sysconfig/ip6tables to ip6tables.kloxosave.
So i'm cofig iptables in /etc/sysconfig/iptables.kloxosave ????
and restart with cm: service iptables restart ????
-
rename iptables.kloxosave to iptables and ip6tables.kloxosave to ip6tables and then restart iptables.
Remember, restart iptables will be blocked certain port like kloxo port (7777/7778) itself.