[Phpgroupware-tracker] [Bug #1672] Timestamps & Database issues

[nobody]

=================== BUG #1672: FULL BUG SNAPSHOT ===================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=1672&group_id=509

Submitted by: biker                     Project: phpGroupWare                   
Submitted on: 2002-Nov-10 20:40
Category:  None                         Bug Group:  0.9.14 release              
Severity:  5 - Major                    Priority:  None                         
Resolution:  None                       Assigned to:  None                      
Status:  Open                           Component Version:  None                
Platform Version:  Linux - RedHat       Reproducibility:  Every Time            

Summary:  Timestamps  & Database issues

Original Submission:  I am running  phpgroupware 0.9.14 and have run the cvs 
update so that groupware will run under Apache 2.0.40 (see bug on registration 
and login pages not working(#1420 I believe) and are still having some problems 
with the system.

1) We have a problem with Timestamps on posts. The whole redhat 8 system is 
synced and set to MST (Arizona) timezone. Redhat and system time work fine 
using ntp. Groupware is setup to use port 13 but we have tried disapled (00) 
and http (80). Setting the timezone offset value appears to work erradically, 
but never stablizes on the same time. I have tried several offset values (-7 
which is MST in several other ntp implementations I am accustomed to) but to no 
avail. It's always right on the minutes, just a wrong hour.

2)Unless DB-Type is set to 'db' instead of PHP4 (for better performance) the 
user session management aspects do not appear to work. The 'current users' 
feature for admins always shows 0 and no session log data is available. 
Incidently, back to the time issue in this section, the login times and post 
timestamp times do both change as setting timezone offset value changes, but 
the two times never correspond with each other) 

3) Speed Issues: It is a relatively small system, roughly 40 users and maybe a 
max of 5 to 10 simultaneous. When getting more than 1 or 2 users, performance 
really drops. Using pgsql 7.2.2-1 on redhat 8. Is there some tuning that can be 
done to pgsql to speed groupware up? The machine is a Pentium class 300mhz with 
256 mb RAM and login times are 30-45 seconds with a single user. Screen changes 
are 15 seconds or so. This drops significantly with more than 2 users.





No Followups Have Been Posted


CC list is empty


No files currently attached


For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=1672&group_id=509