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-07, 21:51:04

Author Topic: Problem Restoring Database  (Read 2827 times)

0 Members and 1 Guest are viewing this topic.

Offline djscooby

  • Valuable Member
  • *
  • Posts: 119
  • Karma: +0/-0
    • View Profile
Problem Restoring Database
« on: 2013-08-07, 23:47:52 »
Hello guys,

I am on latest  Kloxo-MR: 6.5.0.f-2013080701 but it seems there is a bug at least for me,

The problem is when i try to restore database backups from browser i always get empty response and kloxo cp is unacessible after...

I also tried restoring through phpmyadmin,but the same problem, in order to get kloxo cp to work i need to restart "service kloxo restart"

PS: I cant upload any backup databases even small ones..
PS2: Tried both a clean kloxo install and on another vps after upgrading to todays version, i have no clue on whats wrong since i dont have anything inside mysql log...
 
A. Kloxo-MR: 6.5.0.f-2013080701

B. OS: CentOS release 5.9 (Final) i686

C. Apps:
   1. MySQL: mysql-5.0.95-5.el5_9
   2. PHP: php53u-5.3.27-1.ius.el5
   3. Httpd: httpd-2.2.25-1.el5
   4. Lighttpd: --uninstalled--
   5. Nginx: --uninstalled--
   6. Qmail: qmail-toaster-1.03-1.3.27.mr.el5
      - with: courier-imap-toaster-4.1.2-1.3.14.mr.el5
   7. Dns: bind-9.9.3-5.P2.el5

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

E. Memory:
                total       used       free     shared    buffers     cached
   Mem:          3000       1952       1047          0         64        965
   -/+ buffers/cache:        922       2078
   Swap:         1999          0       1999


Mr any idea on whats the problem ?
« Last Edit: 1970-01-01, 01:00:00 by Guest »

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Problem Restoring Database
« Reply #1 on: 2013-08-08, 00:42:53 »
You mean restore from 'backup home' facility or from phpmyadmin.

Backup/restore from 'backup home' running in background (using php-wrapper) and must be no effect for panel (using php-cgi). With phpmyadmin, backup/restore also using php-cgi and possible effect for panel (need 'service kloxo restart').

For using php-cgi, parameter like max_timeout_limit is crucial. Maybe need increasing this values.
« Last Edit: 1970-01-01, 01:00:00 by Guest »
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline djscooby

  • Valuable Member
  • *
  • Posts: 119
  • Karma: +0/-0
    • View Profile
Re: Problem Restoring Database
« Reply #2 on: 2013-08-08, 00:49:34 »
Hi Mr thanks for replying,

I mean restore from   Home (admin)->admin {Mysql Databases}-->"click on databse" and restore the same one..

Exactly the same thing i tried doing it within php-myadmin and it gives the same error...


((Havent tried yet if restore from backup/restore is working as i want resetup clients from the begining...))

-It doesnt have to do anything with cgi-timeout as the moment i select the backup file and hit "update" kloxo is blocked the connection imediatelly...

PS: No firewall etc installed its pretty clean install...
Any idea on how to restore and whats wrong?
Can u try to restore on your server and see if its working with latest upload ?
« Last Edit: 1970-01-01, 01:00:00 by Guest »

Offline djscooby

  • Valuable Member
  • *
  • Posts: 119
  • Karma: +0/-0
    • View Profile
Re: Problem Restoring Database
« Reply #3 on: 2013-08-08, 00:58:25 »
Also forgot to tell you that i already tried reseting mysql pass just in case and now when i try to add database i get this "Alert: Could Not Connect to Database: The error has been logged. Please contact the administrator."

This error is on a new clean install... I reset the pass again through kloxo again the same problem, then i tried form ssh nothing again the same...

Any idea on this one too would be great..
« Last Edit: 1970-01-01, 01:00:00 by Guest »

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Problem Restoring Database
« Reply #4 on: 2013-08-08, 01:00:58 »
Quote from: "djscooby"
Hi Mr thanks for replying,

I mean restore from   Home (admin)->admin {Mysql Databases}-->"click on databse" and restore the same one..

Exactly the same thing i tried doing it within php-myadmin and it gives the same error...


((Havent tried yet if restore from backup/restore is working as i want resetup clients from the begining...))

-It doesnt have to do anything with cgi-timeout as the moment i select the backup file and hit "update" kloxo is blocked the connection imediatelly...

PS: No firewall etc installed its pretty clean install...
Any idea on how to restore and whats wrong?
Can u try to restore on your server and see if its working with latest upload ?
So, it's mean using php-cgi for process. Timeout is crucial for this situation.

BTW, need to know sql file size.
« Last Edit: 1970-01-01, 01:00:00 by Guest »
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline djscooby

  • Valuable Member
  • *
  • Posts: 119
  • Karma: +0/-0
    • View Profile
Re: Problem Restoring Database
« Reply #5 on: 2013-08-08, 01:04:19 »
Quote from: "MRatWork"
So, it's mean using php-cgi for process. Timeout is crucial for this situation.

BTW, need to know sql file size.

22Mbytes sql file size..

Also if it helps during new clean install i get this errors
Code: [Select]
error: permission denied on key 'fs.file-max'
error: permission denied on key 'fs.file-max'
m: command not found

Modified MRatWork repos and then install some packages...

m: command not found
m: command not found
m: command not found
Loaded plugins: fastestmirror, priorities, protectbase, replace
Cleaning up Everything
Cleaning up list of fastest mirrors
Prepare installation directory

Creating Vpopmail database...
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Prepare /home/kloxo/httpd...

And at the end of install
error reading information on service hiawatha: No such file or directory
Unknown option. Use '-h' for help.

« Last Edit: 1970-01-01, 01:00:00 by Guest »

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Problem Restoring Database
« Reply #6 on: 2013-08-08, 01:06:33 »
Try restore from phpmyadmin or 'backup facility' (select certain parts want to restoring after click 'start restore process').
« Last Edit: 1970-01-01, 01:00:00 by Guest »
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline djscooby

  • Valuable Member
  • *
  • Posts: 119
  • Karma: +0/-0
    • View Profile
Re: Problem Restoring Database
« Reply #7 on: 2013-08-08, 01:13:18 »
The same exact problem from phpmyadmin already tried it-exactly after i hit upload to the file connection drops and i need to restart kloxo in order to have acess again to cp...
Now i tried
Code: [Select]
yum remove mysql 
 yum remove kloxomr
 yum install kloxomr
then run the setup and now i have "Kloxo-MR: error 503 found!" when i try to login... Tried then  
Code: [Select]
sh /script/cleanup
/script/cleanup: line 14: lxphp.exe: command not found
[root@testvps ~]#

So now cant try anything as kloxomr is not working... :(
« Last Edit: 1970-01-01, 01:00:00 by Guest »

Offline djscooby

  • Valuable Member
  • *
  • Posts: 119
  • Karma: +0/-0
    • View Profile
Re: Problem Restoring Database
« Reply #8 on: 2013-08-08, 01:32:25 »
MR I will reinstall my new vps tomorrow and try back and let u know, but in the mean time can u try if it works on your servers if its possible ?
Thanks for helping me...
« Last Edit: 1970-01-01, 01:00:00 by Guest »

Offline prandah

  • Senior Member
  • *
  • Posts: 343
  • Karma: +0/-0
    • View Profile
    • https://www.bowo.name
Re: Problem Restoring Database
« Reply #9 on: 2013-08-08, 17:10:24 »
i always bacup/restore on ssh
and make sure your my.cnf
allowed max size bigger then 1M
« Last Edit: 1970-01-01, 01:00:00 by Guest »

 


Top 10 Social Networking:    Facebook    Twitter    LinkedIn    Pinterest    Google Plus    Tumblr    Instagram    VK    Flickr    Vine

Page created in 0.038 seconds with 17 queries.

web stats analysis
 
Mirror created by MasterkinG32.CoM