Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - ksorbo

Pages: [1]
1
Installation problems / Re: Backup & Restore fail
« on: September 08, 2011, 12:14:47 pm »
THANKS!

The connect_timeout setting did the trick.

2
Installation problems / Re: Backup & Restore fail
« on: July 14, 2011, 03:58:19 pm »
Which timeout are you referring to? Here are my settings:

max_allowed_packet = 1048576
connect_timeout = 10
interactive_timeout = 28800
net_read_timeout = 30
net_write_timeout = 60
wait_timeout = 28800

max_connections = 100
net_retry_count = 10

This app is not running on localhost. It is running on a dedicated db server.

3
Installation problems / Re: Backup & Restore fail
« on: July 06, 2011, 05:09:59 pm »
I  can change the time outs.

Unfortunately, many of the single insert statements are more than 100 lines (wrapped) each!

I wonder if anyone else faces the issue of having large tables caused by including file content in the blobs. It is really scary not being able to restore from backup.

What I may have to do is to actually write a php script to read each record from the old server and insert into the new server.

4
Installation problems / Re: Backup & Restore fail
« on: July 06, 2011, 12:13:11 pm »
It gives the Mysql error,"Mysql has gone away". I have about 700+ files in this table but it stops restoring at around 300+

5
Installation problems / Backup & Restore fail
« on: July 05, 2011, 10:33:48 am »
I am moving our Feng installation from one server to another.

I backed-up all data using mysqldump. (The resultant sql file was around 50Mb in size) Upon investigation, the og_file_repo table was about 40 mb of this total.

When I attempted to restore, I was not able to successfully restore to the new server. It would always error out right around the og_file_repo table. This is really scary because I have run daily backups using mysqldump. If I cannot restore from a backup, this system becomes very unreliable.

By separating out the og_file_repo table portion of the backup file, I was able to get the majority of the restore process to work.  I ran the og_file_repo table portion of the sql backup file on its own and it APPEARED to work.

However, now, when I attempt to view ANY document in the system, I get an error:

Error
We are sorry, but Feng Office is not currently able to execute your request. An Error Report has been sent to the administrator.


I am not able to access ANY of our documents and there are many.

What are my options?  Is there any way to export all documents and reimport them into the new system?

6
How To's / Repeating Task
« on: June 15, 2010, 01:54:22 pm »
This is a dumb question but once I have created a repeating task, do I ALSO have to click the Generate Repeated Task for each repetition of the task or does the system do that automatically?

7
How To's / Change Permissions of All Sub-workspaces
« on: May 20, 2010, 03:53:32 pm »
Is there a way to change permissions of all sub-workspaces of a workspace all at once? I.e., force the subfolders to inherit the permissions of the parent?

8
1.4 final / Hangs on display of html document
« on: June 25, 2009, 03:23:45 pm »
Since upgrading to 1.4.1, I have found that opengoo hangs on the display of any html document (in the documents section). This is the case for the standard preview as well as the expanded view.

The only way I have to view documents is to edit the document.

9
Older versions / Re: Database empty in Backup file
« on: April 13, 2009, 10:08:46 pm »
I wonder if the problems is that my mysql password contains some non-letter characters, e.g. / and }.

My cpanel insists on generating passwords which include symbols. If the password strength is not high enough it will not allow that password.

Perhaps the password in the backup command needs to quoted.

10
Older versions / Re: Database empty in Backup file
« on: April 13, 2009, 09:59:47 pm »
I made the change to the config file as you suggeste. (I tested the program path and mysqldump is there and works)

I tested to see if exec would work and it appears to work.

Still an empty $db.sql file.

Is the the same reason my calendar export results in an empty file as well?

11
Older versions / Database empty in Backup file
« on: April 10, 2009, 11:50:11 am »
Using OG 1.3.1

Just ran the backup twice. In both cases the db.sql file was 0 length.  :'(

All the other files appear to have backuped properly. Sadly, the database base is the primary reason for a backup.

Could it have anything to do with folder permissions? My folder permissions all passed on install


Pages: [1]