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 El miércoles, 2 de noviembre de 2016, 8:41:08 (UTC-6), ava...@perpetualny.com escribió: > > 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 > -- You received this message because you are subscribed to the Google Groups "General Open edX discussion" group. To view this discussion on the web visit https://groups.google.com/d/msgid/edx-code/a8a13f1c-2067-42cc-94b7-9cb5c9e6ea1b%40googlegroups.com.