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:29:20

Author Topic: MySQL error in Kloxo-MR 7  (Read 3051 times)

0 Members and 1 Guest are viewing this topic.

Offline hoangsang

  • Valuable Member
  • *
  • Posts: 97
  • Karma: +0/-0
    • View Profile
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!

Online MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: MySQL error in Kloxo-MR 7
« Reply #1 on: 2015-06-05, 14:12:49 »
What's about panel. Also probl with login?.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline hoangsang

  • Valuable Member
  • *
  • Posts: 97
  • Karma: +0/-0
    • View Profile
Re: MySQL error in Kloxo-MR 7
« Reply #2 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.

Online MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: MySQL error in Kloxo-MR 7
« Reply #3 on: 2015-06-05, 14:30:40 »
Possible restore process was failed and or wrong username and password for mysql data in website.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Online MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: MySQL error in Kloxo-MR 7
« Reply #4 on: 2015-06-05, 14:32:01 »
Try login to phpmyadmin from panel and investigate this database.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline hoangsang

  • Valuable Member
  • *
  • Posts: 97
  • Karma: +0/-0
    • View Profile
Re: MySQL error in Kloxo-MR 7
« Reply #5 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 :(

Offline hoangsang

  • Valuable Member
  • *
  • Posts: 97
  • Karma: +0/-0
    • View Profile
Re: MySQL error in Kloxo-MR 7
« Reply #6 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

« Last Edit: 2015-06-05, 15:13:58 by hoangsang »

Online MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: MySQL error in Kloxo-MR 7
« Reply #7 on: 2015-06-05, 15:21:05 »
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'
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline hoangsang

  • Valuable Member
  • *
  • Posts: 97
  • Karma: +0/-0
    • View Profile
Re: MySQL error in Kloxo-MR 7
« Reply #8 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]

Online MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: MySQL error in Kloxo-MR 7
« Reply #9 on: 2015-06-05, 16:02:32 »
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
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline hoangsang

  • Valuable Member
  • *
  • Posts: 97
  • Karma: +0/-0
    • View Profile
Re: MySQL error in Kloxo-MR 7
« Reply #10 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) :(

Online MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: MySQL error in Kloxo-MR 7
« Reply #11 on: 2015-06-05, 16:25:06 »
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'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline hoangsang

  • Valuable Member
  • *
  • Posts: 97
  • Karma: +0/-0
    • View Profile
Re: MySQL error in Kloxo-MR 7
« Reply #12 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!

Offline hoangsang

  • Valuable Member
  • *
  • Posts: 97
  • Karma: +0/-0
    • View Profile
Re: MySQL error in Kloxo-MR 7
« Reply #13 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

Online MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: MySQL error in Kloxo-MR 7
« Reply #14 on: 2015-06-06, 05:38:53 »
Try 'rm -f /tmp/phpm-install-process.sh; rm -f /tmp/multiple_php_install.tmp; sh /script/phpm-all-install'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

 


Top 4 Global Search Engines:    Google    Bing    Baidu    Yahoo
Click Here

Page created in 0.031 seconds with 17 queries.

web stats analysis
 
Mirror created by MasterkinG32.CoM