Feng Forum

Support => Feng Office 1 => Older versions => 1.4 final => : Chad June 05, 2009, 06:19:13 PM

: Backup problems in 1.4
: Chad June 05, 2009, 06:19:13 PM
When I try to run the backup I get an Error Return Code 2.

I haven't seen this anywhere else in the forums.  I do have the db.sql showing up in /tmp/backup but there is nothing in the file.

Any ideas?

Thanks much all
: Re: Backup problems in 1.4
: Frits June 09, 2009, 02:21:13 PM
Yesterday I has a simular problem, but with return code 1.

Connecting to an existing database  from another installation solved the problem.
So, I reinstalled the package with a fresh datbase and now it is working. Don't ask why.



: Re: Backup problems in 1.4
: Filip June 15, 2009, 04:49:51 PM
I have the same problem (return code: -1) :-\

I can't start with a fresh database there is already to much data available.

someone has a solution?
: Re: Backup problems in 1.4
: Dutchie June 18, 2009, 08:03:41 AM
If you're having database backup issues and are using mysql on a *nix, you can do what I'm doing.
Requirements:
ssh access to your database server
vi editing skills  ::)
the script: automysqlbackup.2.5.sh (google it)
Edit the script to your liking, be sure to read it all through until you reach the actual execution part!
Try it, verify that the backups are there...
Make sure it's executed by cron every night, preferably have the files copied onto another machine.

All done...
Happy backupping!  ;D
: Re: Backup problems in 1.4
: Frits June 18, 2009, 04:58:26 PM
What you also can try is chmod 777 on the directories backup and saveatt in tmp.

When I uploaded OpenGoo via ftp, this solved my backup problem (err code 1).

: Re: Backup problems in 1.4
: Filip June 21, 2009, 06:13:11 AM
I have changed the settings but still get the same error. (An error occurred while creating the database backup: Return code -1) even after installation of OpenGoo 1.4.2  :-\

: Error while creating database backup: Return code: 1
: Karl June 29, 2009, 10:17:18 AM
I changed (chmod) folders "backup" and "saveatt" in folder "tmp" to 775 and then the backup works.
: Re: Backup problems in 1.4
: Filip June 30, 2009, 02:43:32 AM
the problem persists even after changing the folder properties  :-[

the project OpenGoo is beautiful, but it is not reliable as long as I can't take backups. (company policies)
: Re: Backup problems in 1.4
: Karl June 30, 2009, 06:48:47 AM
I have installed OpenGoo within 2 different domains on the same server (CentOS). But the group and owner of the folder "backup" differs:

The first installation: Group an owner is the site owner.

The second installation: Group and owner is "apache".

I don't know why there is this difference. But on the second installation (group and owner "apache") the backup works fine without changing the folder properties.

Maybe you should change group and owner too.
: Re: Backup problems in 1.4
: Filip June 30, 2009, 10:06:39 AM
Karl,

thanks for the reply

I'm running the OpenGoo on a Synology DS207+.
* MySQL 5.0.51b
* Apache 2.28

I get directory information with the FTP-client "FireFTP" (add-on Mozilla FireFox)
I use the default backup folder from OpenGoo
* tmp-folder
   - group = users
   - user = guest
* backup-folder
   - group = nobody
   - user = nobody
* saveatt-folder
   - group = users
   - user = guest

I do not know how I must change the owner and/or user.

Filip
: Re: Backup problems in 1.4
: Pet June 30, 2009, 05:33:18 PM
Filip, don't forget that you can always make backups from outside of OG.  Use any mysql backup tool, then all you have to do is reinstall OG and restore your db. This can at least get you around your company policy until you get OG backup working.
: Re: Backup problems in 1.4
: Filip July 01, 2009, 03:35:43 AM
yes, the unfortunate thing is that I always have to backup manually instead of automatically. (through Cron settings of OpenGoo)  :-\

Can I configure/schedule phpMyAdmin for making backups?
: Re: Backup problems in 1.4
: fcoauga July 05, 2009, 07:12:24 PM
the problem persists even after changing the folder properties  :-[

I have the same problem, nothing happens with CHMOD changes...
: Re: Backup problems in 1.4
: Pet July 06, 2009, 03:10:38 AM
Can I configure/schedule phpMyAdmin for making backups?

I don't believe so, Export is a manual procedure.