MySQL error in Kloxo-MR 7

[hoangsang]

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!

[MRatWork]

What's about panel. Also probl with login?.

[hoangsang]

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.

[MRatWork]

Possible restore process was failed and or wrong username and password for mysql data in website.

[MRatWork]

Try login to phpmyadmin from panel and investigate this database.

[hoangsang]

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

[hoangsang]

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

[MRatWork]

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'

[hoangsang]

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]

[MRatWork]

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

[hoangsang]

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)

[MRatWork]

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'.

[hoangsang]

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!

[hoangsang]

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

[MRatWork]

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