← Back to team overview

c2c-oerpscenario team mailing list archive

[Bug 711084] Re: Timezone not taken into account by server, but web-client works perfectly

 

I am using Ubuntu 10.10 server (x86) with Python 2.6 and Postgres 8.4. If you want the full configuration steps, you can find them here:
http://powerphil.wordpress.com/2011/01/28/how-to-install-and-configure-an-openerp-6-0-1-server-and-web-server-on-an-ubuntu-10-10-server/

Here are the version numbers of the packages I have installed:

Package	Version
-----------  ----------
python	2.6
python-psycopg2	2.2.1
python-reportlab	2.4-3
python-egenix-mxdatetime	
python-pychart	1.39-7
python-pydot	1.0.2-1
python-lxml	2.2.6.1
python-vobject	0.8.1c-3
python-setuptools	0.6.14-3
PyYaml	3.09-py2.6
python-mako	0.3.4-2
python-yaml	3.09-4
python-dev	2.6.6
python-tz	2010o

I then ran the OpenERP GTK Client and configured OpenERP modules:

1. Created a new database; the first time I created a database, I
created it WITH Demonstration Data; I don't know if this has any
significance. Later, I also created a database WITHOUT Demonstration
Data. Both databases had a list of available Timezones  available in the
User's Preferences.

2. Selected "Extended" interface.

3. Configured Company Information.

4. Installed these Applications:
- CRM
- Warehouse Management
- Invoicing
- Purchase Management
- Point of Sale
- Sales Management
- Manufacturing
- Accounting and Finance
- Human Resources
- Advanced Reporting

5. Configured Reporting Tools:
- OpenOffice Report Designer
- QueryBuilder

6. Configured Human Resources:
- Holidays / Leave Management
- Employee's Contracts
- Payroll Accounting
- Expenses
- Timesheets
- Attendances
- Payroll

7. Configured Chart of Accounts
- Generic Chart of Accounts

8. Configured CRM:
- Claims
- Opportunity to Quotation

9. Configured Purchases:
- Purchase Requisition
- Purchase Analytic Plans

10. Configured Sales Management:
- Delivery Costs
- Sales Order Layout Improvement
- Sales Order Dates
- Invoicing Journals
- Margins in Sales Orders

11. Configured Manufacturing:
- Manufacturing Operations
- Repairs

12. Configured Report Designer

13. Configured Accounting Application:
- Voucher Management
- Suppliers Payment Management
- Anglo-Saxon Accounting
- Followups Management
- Multiple Analytic Plans

14. Configured Sales Order Logistics:
- Direct Delivery
- Invoice Based on Deliveries
- Picking List and Delivery Order

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/711084

Title:
  Timezone not taken into account by server, but web-client works
  perfectly

Status in OpenERP Server:
  Incomplete

Bug description:
  OpenERP server and web client 6.0.1 running on Ubuntu server (32-bit) 10.10
  Postgres 8.4
  Windows GTK client and web browser (Google Chrome) on WIndows 7 (64-bit)

  (Server and web client were set up as per
  http://powerphil.wordpress.com/2011/01/28/how-to-install-and-
  configure-an-openerp-6-0-1-server-and-web-server-on-an-
  ubuntu-10-10-server/).

  Problem is that the times shown in the GTK client are shown at GMT (unless the server's TZ environment variable is set), i.e. they ignore the user's Timezone preference.
  However, the web client works correctly.

  More details:
  Ubuntu server's time is correctly set to GMT. For example, if the time in London is 1am, the server's time also shows 1am (by doing a "date" on the command line, and the TZ environment variable is not set to anything).

  Both openerp-server and openerp-web processes are running without any
  TZ setting.

  Then log into OpenERP using a web browser; set the User's preference
  to Australia/Sydney; create a new Phone Call, Outbound; the time
  correctly shows 12 noon (GMT + 11 hours, Sydney currently being on
  summer time).

  Do the same in the GTK client; the time shows 1am - wrong; it should
  be 12 noon.

  ---------

  More information:

  So try to work around the problem: in the .bashrc file of the openerp user that runs the openerp-server process, set the TZ, viz:
  TZ='AEST-10AEDT-11,M10.5.0,M3.5.0'
  export TZ

  Restart the service; log into the GTK client; create a new phone call; the time now shows correctly (for the wrong reasons, admittedly).
  Go to the web browser and do the same thing; the time now shows 19 hours ahead of what it should be (on the next day!). Wrong.

  So it looks like the web client is taking timezone time into account,
  in addition to whatever the openerp-server is doing, and it should be
  the other way around: the openerp-server should be calculating the
  correct time, and the web server should just be presenting it.





References