Topics

1

How To's / Writing my own iCal output for OpenGoo

« on: January 15, 2009, 11:35:32 pm »

Hey all;

I'm getting into the back end portion of writing the code to come up with an ICS file.  The wife is reluctant to use OpenGoo until I see the events daily.  I tend to use my mail client more than OpenGoo. heh

Anyways, I'm creating some sample data and have found that I am unsure of how OpenGoo decides when a calendar event is an "ALL DAY" event.  I don't see a particular field being set true or false, and the time stamps for start and duration in the ??_project_events table is only one hour different.

Where/how do I consider an event as an ALL DAY event?

Thanks.

PS> If its all the same to the admins, I'd like to keep this thread going for any other questions I have.   Thanks!

2

Feature requests / Document Default Font

« on: December 14, 2008, 05:39:00 pm »

Have the ability to select what default font I write in when there is nothing selected in the FONT drop box.  I prefer writing in Courier New or a fixed-width font.  (Back from the good 'ol DOS days. )

3

Feature requests / Note Font Type

« on: December 14, 2008, 05:36:27 pm »

I'd like to have the ability when entering Notes that whats displayed both in the text area, as well as when I preview the note, to have the option of selecting a variable width font, or fixed width font.  This could maybe be set on a per-note basis by storing that preference in the DB for that particular note.

4

Feng Office 1 / Another minor annoyance

« on: December 14, 2008, 05:34:25 pm »

When working on a very long document that spans pages, if I scroll up a few pages or to the near beginning of the document, then press ENTER to insert a new line, what displays in the document ends up scrolling down to the bottom of the page.  However, the cursor stays in the same spot, so if I start typing, the window scrolls back up to where the cursor is.

5

Feng Office 1 / *VERY* minor issue with document editor

« on: December 13, 2008, 06:42:32 pm »

I'm doing some work with OpenGoo in the Document Writer, and noticed that there are two scroll bars along the right side of the document part.  It seems that the frame that contains the formatting tools as well as the actual document is set just a tad bit too tall by just a few pixels.

This is true for Windows and Linux FireFox.  I'm not trying in IE, as I don't want to get a virus when going to http://localhost.

6

Feng Office 1 / EMail issues causing lockups with OpenGOO

« on: December 10, 2008, 11:57:26 am »

Hey all;

About my systems.  OpenGoo is running under Ubuntu with no GUI installed, and is running very well with the exclusion of the email services.  Its a young install (Less than two weeks old) so there still may be some tuning that needs to be tuned up.

I am also running an email server on a Win2K Svr machine.  The EMail server runs just fine, and has been for over a year now.  It supports IMAP and POP3.

The mail server is PURELY for internal use only.  Up until this time, I've just used it to for a web application to email me when new registrations come in, and thats it.  It does NOT send email outside my LAN.  It never WILL send outside of my LAN.  It also does not RECEIVE external email as well.  Its 100% in house (No pun intended. )

Now that I've setup OpenGoo to run with the the server, I've found OpenGoo gets into an infinite loop and just HAMMERS the mail server with requests.  At one point, when running

Code: [Select]

netstat -ao | grep -i pop3 | wcI would find that there were around 53 attempts to connect to the mail server within the last 60 seconds.  I had to stop the mail service running in order to get the communications to stop, even with Apache turned off!  OpenGoo also stops responding entirely.  Closing/terminating the web browser (FireFox)  and then relogging in does not fix the issue.

What I have in OpenGoo EMail account settings is the following:

EMail address: stephen@somedomain.dyndns.org
Account ID: stephen@somedomain.dyndns.org
Password: ......
Pop3 Server Address: Server hosting the internal mail server
SMTP Server Port: 25
SMTP Server Authentication: Input SMTP Username and Password
SMTP Username: stephen@somedomain.dyndns.org
SMTP Password: ....

I've checked the mail log on the server, and it APPEARS that its logging in, getting the mail, and successfully logging out.  (Note that somedomain.dyndns.org isn't really mine.  I just changed the hostname here)

Code: [Select]

"DEBUG" 1484 "2008-12-10 09:33:58.054" "TransparentTransmissionBuffer::Initialize()"
"POP3D" 1484 390 "2008-12-10 09:33:58.054" "192.168.2.252" "SENT: +OK POP3"
"POP3D" 1484 390 "2008-12-10 09:33:58.054" "192.168.2.252" "RECEIVED: USER stephen@somedomain.dyndns.org"
"POP3D" 1484 390 "2008-12-10 09:33:58.054" "192.168.2.252" "SENT: +OK Send your password"
"POP3D" 1484 390 "2008-12-10 09:33:58.064" "192.168.2.252" "RECEIVED: PASS ***"
"POP3D" 1484 390 "2008-12-10 09:33:58.064" "192.168.2.252" "SENT: +OK Mailbox locked and ready"
"POP3D" 1484 390 "2008-12-10 09:33:58.064" "192.168.2.252" "RECEIVED: STAT"
"POP3D" 1484 390 "2008-12-10 09:33:58.064" "192.168.2.252" "SENT: +OK 2 1055"
"POP3D" 1484 390 "2008-12-10 09:33:58.074" "192.168.2.252" "RECEIVED: UIDL"
"POP3D" 1484 390 "2008-12-10 09:33:58.074" "192.168.2.252" "SENT: +OK 2 messages (1055 octets)[nl]1 666[nl]2 673[nl]."
"POP3D" 1484 390 "2008-12-10 09:33:58.074" "192.168.2.252" "RECEIVED: LIST"
"POP3D" 1484 390 "2008-12-10 09:33:58.074" "192.168.2.252" "SENT: +OK 2 messages (1055 octets)"
"POP3D" 1484 390 "2008-12-10 09:33:58.074" "192.168.2.252" "SENT: 1 520[nl]2 535[nl]."
"POP3D" 1484 390 "2008-12-10 09:33:58.114" "192.168.2.252" "RECEIVED: UIDL"
"POP3D" 1484 390 "2008-12-10 09:33:58.114" "192.168.2.252" "SENT: +OK 2 messages (1055 octets)[nl]1 666[nl]2 673[nl]."
"POP3D" 1484 390 "2008-12-10 09:33:58.124" "192.168.2.252" "RECEIVED: QUIT"
"POP3D" 1484 390 "2008-12-10 09:33:58.124" "192.168.2.252" "SENT: +OK POP3 server saying goodbye..."
"TCPIP" 1484 "2008-12-10 09:33:58.134" "Disconnecting socket 1760 for session 390"'

The other thing I noticed just this morning is that if I shut down the mail server software, and completely stop Apache, then restart all the services, I can go in and check the mail in OpenGOO and everything works perfectly fine.  I can go and poke the mail server from within OpenGOO, and it tells me it was successful, and that there were zero new messages downloaded.  But as a test, once I put a test email to the email account, the next time I check the mail, OpenGoo gets into a weird state, and I notice the hits from netstat.  I also noticed that after I restart all the services, the test mail I sent this morning does show up in the OpenGoo email account.

What else do I need to check to get this working?  For now, I'm just going to disable the email accounts on the server until I can get some headway.

I am not totally against installing a mail server on the Ubuntu machine for this purpose, but I personally would rather not have the same kinds of services running on multiple machines.

7

How To's / Backups

« on: December 08, 2008, 09:31:50 am »

So I've downloaded and installed OpenGoo 1.0.  So far I'm quite pleased with it.  I really do look forward to the spreadsheet functionality already in works.

I've currently got OpenGoo setup to store files within the DB, and not in the file system.  I ran a backup, and downloaded the produced zip file.  I open the archive, and I see everything as I should, except the actual database, or at least the SQL statements to recreate the SQL Data.

Am I missing something?  Where can I find that data?