certificate timezone error

[ava...@perpetualny.com]

Hi,

I am getting below error on eucalyptus.2  tag, when trying to add a certificate html configurations in LMS admin.

Enter code here...2016-11-02 10:34:22,494 ERROR 19290 [django.request] base.py:256 - Internal Server Error: /admin/certificates/certificatehtmlviewconfiguration/

Traceback (most recent call last):

  File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/core/handlers/base.py", line 164, in get_response

    response = response.render()

  File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/response.py", line 158, in render

    self.content = self.rendered_content

  File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/response.py", line 135, in rendered_content

    content = template.render(context, self._request)

  File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/backends/django.py", line 74, in render

    return self.template.render(context)

  File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/base.py", line 210, in render

    return self._render(context)

  File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/base.py", line 202, in _render

    return self.nodelist.render(context)

  File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/base.py", line 905, in render

    bit = self.render_node(node, context)

  File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/base.py", line 919, in render_node

    return node.render(context)

  File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/loader_tags.py", line 135, in render

    return compiled_parent._render(context)

  File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/base.py", line 202, in _render

    return self.nodelist.render(context)

  File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/base.py", line 905, in render

    bit = self.render_node(node, context)

  File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/base.py", line 919, in render_node

    return node.render(context)

  File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/loader_tags.py", line 135, in render

    return compiled_parent._render(context)

  File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/base.py", line 202, in _render

    return self.nodelist.render(context)

  File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/base.py", line 905, in render

    bit = self.render_node(node, context)

  File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/base.py", line 919, in render_node

    return node.render(context)

  File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/loader_tags.py", line 65, in render

    result = block.nodelist.render(context)

  File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/base.py", line 905, in render

    bit = self.render_node(node, context)

  File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/base.py", line 919, in render_node

    return node.render(context)

  File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/loader_tags.py", line 65, in render

    result = block.nodelist.render(context)

  File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/base.py", line 905, in render

    bit = self.render_node(node, context)

  File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/base.py", line 919, in render_node

    return node.render(context)

  File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/template/base.py", line 1273, in render

    _dict = func(*resolved_args, **resolved_kwargs)

  File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/contrib/admin/templatetags/admin_list.py", line 388, in date_hierarchy

    } for month in months]

  File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/models/query.py", line 162, in __iter__

    self._fetch_all()

  File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/models/query.py", line 965, in _fetch_all

    self._result_cache = list(self.iterator())

  File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/models/query.py", line 1217, in iterator

    for row in compiler.results_iter():

  File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 800, in results_iter

    row = self.apply_converters(row, converters)

  File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 784, in apply_converters

    value = converter(value, expression, self.connection, self.query.context)

  File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/models/expressions.py", line 927, in convert_value

    "Database returned an invalid value in QuerySet.datetimes(). "

ValueError: Database returned an invalid value in QuerySet.datetimes(). Are time zone definitions for your database and pytz installed?

pytz is installed in edxapp environment.

I have tried below:

mysql_tzinfo_to_sql /usr/share/zoneinfo/GMT GMT | mysql -u root -p mysql

mysql_tzinfo_to_sql /usr/share/zoneinfo/UTC UTC | mysql -u root -p mysql

mysql -u root -p -e "flush tables;" mysql 

sudo service mysql restart

Thanks

Avadhut

[Ernesto Sanchez]

Hi, i write the step in spanish sorry and work for me

1. Igualar todos los time_zone de edx en el lms.env.json y cms.env.json

2. Poner el SO en la misma zona de tiempo

ubuntu 12.04

* dpkg-reconfigure tzdata

3. Poner el mysql en la misma zona de tiempo

- Editar /etc/my.cnf

- Agregar 

default-time-zone = 'America/Mexico_City'

5. actualizar mysql

- mysql_tzinfo_to_sql /usr/share/zoneinfo | sed -e "s/Local time zone must be set--see zic manual page/local/" | mysql -u root mysql

- mysql_tzinfo_to_sql /usr/share/zoneinfo/America/Mexico_City 'America/Mexico_City'

- mysql -u root -p -e "flush tables;" mysql

4. generar la carpeta donde se almacenan temporalmente los certificados

* Editar el archivo /etc/init/mounted-tmp.conf y agregar las siguientes lineas

mkdir /tmp/certificates

chown -R www-data:www-data /tmp/certificates

5. editar {cms/lms}.env.json agregando a features la linea

"CERTIFICATES_HTML_VIEW": true,

6. Sincronizar dbs

sudo su edxapp -s /bin/bash

cd ~

source edxapp_env

python /edx/app/edxapp/edx-platform/manage.py cms syncdb --settings=aws

python /edx/app/edxapp/edx-platform/manage.py lms syncdb --settings=aws

7. reiniciar servicios de lms y cms

[Daniel]

Thank you for this solution, Ernesto, this working for me!