Hi Mai,
I'm a bit stumped! Every time I've seen an error like
"django.db.utils.ProgrammingError:
relation "concepts" does not exist" it invariably means that the table
hasn't been created or is somehow inaccessible.
My only other suggestion would be to change your db settings to this and
test again:
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.postgresql_psycopg2',
'NAME': 'arches_%s' % (PACKAGE_NAME),
'USER': 'd********',
'PASSWORD': '****',
'HOST': '127.0.0.1',
'PORT': '5432',
'POSTGIS_TEMPLATE' : 'template_postgis'
}
}
See if that works.
Cheers,
Alexei
Director of Web Development - Farallon Geographics, Inc. - 971.227.3173
On Thu, Aug 27, 2015 at 5:51 AM, Mai Abdelaziz El Kady <
[email protected]> wrote:
> Hi Alexei,
>
> Thanks for your suggestions.
> I have tried loading the system using the "postgres" user and checked that
> there is indeed a scheme called "concepts", and within it a table called
> "concepts" as well (shown in the screenshot attached), and yet still the
> same error remains unchanged.
>
> I really appreciate your help.
>
> --
> Sincerely,
> Mai Abdelaziz
>
> On Wed, Aug 26, 2015 at 6:39 PM, Alexei Peters <[email protected]> wrote:
>
>> Hi Mai,
>> It appears that your database called "arches_my_hip_app" wasn't installed
>> correctly. If you have pgadmin3 or access to a terminal can you confirm
>> that you have a schema called "concepts" and within that a table called
>> "concepts".
>> Your database user "django" needs to have the privilege to create tables,
>> functions, etc.. Can you confirm that as well. As a test you might
>> temporarily load the system using the "postgres" user.
>> Thanks,
>> Alexei
>>
>>
>> Director of Web Development - Farallon Geographics, Inc. - 971.227.3173
>>
>> On Wed, Aug 26, 2015 at 12:43 AM, 'Mai Abdelaziz El Kady' via Arches
>> Project <[email protected]> wrote:
>>
>>> Hi Cyrus,
>>>
>>> My name is Mai and I am working with Asmaa in installing Arches.
>>> Thank you for your quick reply.
>>> We tried your suggestion but unfortunately the error remained the same,
>>> so do you have any more ideas about what could be the cause of it?
>>>
>>> Thanks a lot for your help and support
>>>
>>> --
>>> Sincerely,
>>> Mai Abdelaziz
>>>
>>>
>>> On Mon, Aug 24, 2015 at 5:01 PM, Cyrus Hiatt <[email protected]>
>>> wrote:
>>>
>>>> Hi Asmaa -
>>>>
>>>> Glad to hear you got a bit further.
>>>>
>>>> Sorry I didn't catch this last time, but I see that the paths (e.g.
>>>> 'os.path....') in: RESOURCE_GRAPH_LOCATIONS, CONCEPT_SCHEME_LOCATIONS, and
>>>> BUSINESS_DATA_FILES have been uncommented. You should try commenting those
>>>> lines back out again until you are ready to modify or add to the files in
>>>> those directories. The settings for those variables should look like this:
>>>>
>>>>
>>>> # RESOURCE_GRAPH_LOCATIONS = (
>>>> # # Put strings here, like "/home/data/resource_graphs" or
>>>> "C:/data/resource_graphs".
>>>> # # Always use forward slashes, even on Windows.
>>>> # # Don't forget to use absolute paths, not relative paths.
>>>> # os.path.join(PACKAGE_ROOT, 'source_data', 'resource_graphs'),
>>>> # )
>>>>
>>>> CONCEPT_SCHEME_LOCATIONS = (
>>>> # Put strings here, like "/home/data/authority_files" or
>>>> "C:/data/authority_files".
>>>> # Always use forward slashes, even on Windows.
>>>> # Don't forget to use absolute paths, not relative paths.
>>>>
>>>> #'absolute/path/to/authority_files',
>>>> # os.path.normpath(os.path.join(PACKAGE_ROOT, 'source_data',
>>>> 'concepts', 'authority_files')),
>>>> )
>>>>
>>>> BUSISNESS_DATA_FILES = (
>>>> # Put strings here, like "/home/html/django_templates" or
>>>> "C:/www/django/templates".
>>>> # Always use forward slashes, even on Windows.
>>>> # Don't forget to use absolute paths, not relative paths.
>>>> # os.path.normpath(os.path.join(PACKAGE_ROOT, 'source_data',
>>>> 'business_data', 'sample.arches')),
>>>> )
>>>>
>>>>
>>>>
>>>> Cheers,
>>>>
>>>> Cyrus
>>>>
>>>> On Mon, Aug 24, 2015 at 3:18 AM, Asmaa Ayman <[email protected]>
>>>> wrote:
>>>>
>>>>> Hi Cyrus,
>>>>>
>>>>> Thanks a lot for the help! We did what you said and it passed that
>>>>> error but now we are facing this one:
>>>>>
>>>>> django.db.utils.ProgrammingError: relation "concepts" does not exist
>>>>> LINE 1: ...concepts"."nodetype", "concepts"."legacyoid" FROM
>>>>> "concepts"...
>>>>>
>>>>> You can find below a more informative log, and I am also attaching the
>>>>> entire log.
>>>>>
>>>>>
>>>>> LOADING GRAPHS
>>>>> (/usr/share/sandboxes/egyarch/my_hip_app/my_hip_app/source_data/resource_graphs)
>>>>> ---------------
>>>>>
>>>>> INDEXING ENTITY NODES
>>>>> ---------------------
>>>>> Traceback (most recent call last):
>>>>> File "manage.py", line 28, in <module>
>>>>> execute_from_command_line(sys.argv)
>>>>> File
>>>>> "/usr/lib/python2.7/site-packages/django/core/management/__init__.py",
>>>>> line
>>>>> 399, in execute_from_command_line
>>>>> utility.execute()
>>>>> File
>>>>> "/usr/lib/python2.7/site-packages/django/core/management/__init__.py",
>>>>> line
>>>>> 392, in execute
>>>>> self.fetch_command(subcommand).run_from_argv(self.argv)
>>>>> File
>>>>> "/usr/lib/python2.7/site-packages/django/core/management/base.py", line
>>>>> 242, in run_from_argv
>>>>> self.execute(*args, **options.__dict__)
>>>>> File
>>>>> "/usr/lib/python2.7/site-packages/django/core/management/base.py", line
>>>>> 285, in execute
>>>>> output = self.handle(*args, **options)
>>>>> File
>>>>> "/usr/lib/python2.7/site-packages/arches/management/commands/packages.py",
>>>>> line 67, in handle
>>>>> self.install(package_name)
>>>>> File
>>>>> "/usr/lib/python2.7/site-packages/arches/management/commands/packages.py",
>>>>> line 114, in install
>>>>> install()
>>>>> File "/usr/share/sandboxes/egyarch/my_hip_app/my_hip_app/setup.py",
>>>>> line 6, in install
>>>>> setup.install()
>>>>> File "/usr/lib/python2.7/site-packages/arches_hip/setup.py", line
>>>>> 24, in install
>>>>> load_resource_graphs()
>>>>> File "/usr/lib/python2.7/site-packages/arches_hip/setup.py", line
>>>>> 47, in load_resource_graphs
>>>>> resource_graphs.load_graphs(break_on_error=True)
>>>>> File
>>>>> "/usr/lib/python2.7/site-packages/arches/management/commands/package_utils/resource_graphs.py",
>>>>> line 69, in load_graphs
>>>>> concepts.index_entity_concept_lables()
>>>>> File
>>>>> "/usr/lib/python2.7/site-packages/arches/management/commands/package_utils/concepts.py",
>>>>> line 17, in index_entity_concept_lables
>>>>> domains_concept = Concept('00000000-0000-0000-0000-000000000003')
>>>>> File
>>>>> "/usr/lib/python2.7/site-packages/arches/app/models/concept.py", line 60,
>>>>> in __init__
>>>>> self.get(args[0])
>>>>> File
>>>>> "/usr/lib/python2.7/site-packages/arches/app/models/concept.py", line 97,
>>>>> in get
>>>>> self.load(models.Concepts.objects.get(pk=id))
>>>>> File "/usr/lib/python2.7/site-packages/django/db/models/manager.py",
>>>>> line 151, in get
>>>>> return self.get_queryset().get(*args, **kwargs)
>>>>> File "/usr/lib/python2.7/site-packages/django/db/models/query.py",
>>>>> line 304, in get
>>>>> num = len(clone)
>>>>> File "/usr/lib/python2.7/site-packages/django/db/models/query.py",
>>>>> line 77, in __len__
>>>>> self._fetch_all()
>>>>> File "/usr/lib/python2.7/site-packages/django/db/models/query.py",
>>>>> line 857, in _fetch_all
>>>>> self._result_cache = list(self.iterator())
>>>>> File "/usr/lib/python2.7/site-packages/django/db/models/query.py",
>>>>> line 220, in iterator
>>>>> for row in compiler.results_iter():
>>>>> File
>>>>> "/usr/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line
>>>>> 713, in results_iter
>>>>> for rows in self.execute_sql(MULTI):
>>>>> File
>>>>> "/usr/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line
>>>>> 786, in execute_sql
>>>>> cursor.execute(sql, params)
>>>>> File "/usr/lib/python2.7/site-packages/django/db/backends/util.py",
>>>>> line 69, in execute
>>>>> return super(CursorDebugWrapper, self).execute(sql, params)
>>>>> File "/usr/lib/python2.7/site-packages/django/db/backends/util.py",
>>>>> line 53, in execute
>>>>> return self.cursor.execute(sql, params)
>>>>> File "/usr/lib/python2.7/site-packages/django/db/utils.py", line 99,
>>>>> in __exit__
>>>>> six.reraise(dj_exc_type, dj_exc_value, traceback)
>>>>> File "/usr/lib/python2.7/site-packages/django/db/backends/util.py",
>>>>> line 53, in execute
>>>>> return self.cursor.execute(sql, params)
>>>>> django.db.utils.ProgrammingError: relation "concepts" does not exist
>>>>> LINE 1: ...concepts"."nodetype", "concepts"."legacyoid" FROM
>>>>> "concepts"...
>>>>> ^
>>>>>
>>>>>
>>>>> I, my colleagues and everyone here at AUC really appreciate your help.
>>>>>
>>>>>
>>>>> All the best,
>>>>>
>>>>> Asmaa
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Stay Focused. Stay Productive!
>>>>>
>>>>> On Sun, Aug 23, 2015 at 6:29 PM, Cyrus Hiatt <[email protected]>
>>>>> wrote:
>>>>>
>>>>>> Hi Asmaa -
>>>>>>
>>>>>> I see your RESOURCE_MODEL and RESOURCE_TYPE_CONFIGS are uncommented
>>>>>> in settings.py overriding the hip resource model. Could you re-comment
>>>>>> them
>>>>>> and run the install command again?
>>>>>>
>>>>>> Thanks,
>>>>>>
>>>>>> Cyrus
>>>>>>
>>>>>> On Sun, Aug 23, 2015 at 8:13 AM, Asmaa Ayman <[email protected]>
>>>>>> wrote:
>>>>>>
>>>>>>> Hi Cyrus,
>>>>>>>
>>>>>>> I am using a different user and password, but all written in the
>>>>>>> settings.py file. my postgis template database matches the one in the
>>>>>>> settings.py file. It is 'template_postgis'. What do you advise.
>>>>>>>
>>>>>>> I am attaching the entire output file, starting from the
>>>>>>> installation command and including the error I am stuck at. Also
>>>>>>> attached
>>>>>>> the settings.py file.
>>>>>>>
>>>>>>> I really appreciate your help!
>>>>>>>
>>>>>>> Thanks a lot,
>>>>>>>
>>>>>>> Asmaa
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Stay Focused. Stay Productive!
>>>>>>>
>>>>>>> On Sun, Aug 23, 2015 at 4:30 PM, Cyrus Hiatt <[email protected]>
>>>>>>> wrote:
>>>>>>>
>>>>>>>> Hi Asmaa -
>>>>>>>>
>>>>>>>> Are you using the default user ('postgres') and password
>>>>>>>> ('postgis') for your postgres connection? If so, does the name of your
>>>>>>>> postgis template database match what's in your Django database settings
>>>>>>>> (probably 'template_postgis_20'?
>>>>>>>>
>>>>>>>> Cheers,
>>>>>>>>
>>>>>>>> Cyrus
>>>>>>>>
>>>>>>>> On Sun, Aug 23, 2015 at 6:36 AM, 'Asmaa Ayman' via Arches Project <
>>>>>>>> [email protected]> wrote:
>>>>>>>>
>>>>>>>>> Dear Adam,
>>>>>>>>>
>>>>>>>>> Yes, we are using a virtual Environment and it was active, my
>>>>>>>>> colleague followed the exact steps in the link you provided and still
>>>>>>>>> the
>>>>>>>>> error remained unchanged.
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> Your advice is highly appreciated!
>>>>>>>>>
>>>>>>>>> >>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> On Wed, Aug 19, 2015 at 12:05 PM, Asmaa Ayman <[email protected]
>>>>>>>>> > wrote:
>>>>>>>>>
>>>>>>>>>> Dear Mai,
>>>>>>>>>>
>>>>>>>>>> Kindly check the reply of Arches' Support. Can you please
>>>>>>>>>> re-install Arches again following the instructions sent
>>>>>>>>>>
>>>>>>>>>> Server: 10.2.2.33
>>>>>>>>>> username: django
>>>>>>>>>> pwd: AUC$123
>>>>>>>>>>
>>>>>>>>>> directory: /usr/share/sandboxes/egyarch
>>>>>>>>>>
>>>>>>>>>> you can download PuTTY from here: http://www.putty.org/
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> Many thanks for your invaluable help and continuous support!
>>>>>>>>>>
>>>>>>>>>> Asmaa
>>>>>>>>>>
>>>>>>>>>> --
>>>>>>>>>> Stay Focused. Stay Productive!
>>>>>>>>>>
>>>>>>>>>> On Mon, Aug 17, 2015 at 8:38 PM, Adam Cox <[email protected]>
>>>>>>>>>> wrote:
>>>>>>>>>>
>>>>>>>>>>> HI Asmaa, are you using a virtual environment? It looks like
>>>>>>>>>>> you are using the default python installation. You should make a
>>>>>>>>>>> virtual
>>>>>>>>>>> environment, activate it, and then install arches-hip there.
>>>>>>>>>>> Here's more
>>>>>>>>>>> information on that:
>>>>>>>>>>> https://arches-hip.readthedocs.org/en/latest/getting-started/#installating-arches-hip
>>>>>>>>>>> .
>>>>>>>>>>>
>>>>>>>>>>> Good luck!
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> On Sunday, August 16, 2015 at 10:59:07 AM UTC-5,
>>>>>>>>>>> [email protected] wrote:
>>>>>>>>>>>>
>>>>>>>>>>>> Dear All,
>>>>>>>>>>>>
>>>>>>>>>>>> I am trying to install Arches-HIP and I am getting an error at
>>>>>>>>>>>> the last step before running arches: *(ENV)$ python manage.py
>>>>>>>>>>>> packages -o install*
>>>>>>>>>>>>
>>>>>>>>>>>> I tried it on Centos 7 and on ubuntu, using the install
>>>>>>>>>>>> dependencies script; yet both give me the same error.
>>>>>>>>>>>>
>>>>>>>>>>>> *Centos 7*
>>>>>>>>>>>> VACUUM
>>>>>>>>>>>> deleting index : concept_labels
>>>>>>>>>>>> deleting index : term
>>>>>>>>>>>> Traceback (most recent call last):
>>>>>>>>>>>> File "manage.py", line 28, in <module>
>>>>>>>>>>>> execute_from_command_line(sys.argv)
>>>>>>>>>>>> File
>>>>>>>>>>>> "/usr/lib/python2.7/site-packages/django/core/management/__init__.py",
>>>>>>>>>>>> line
>>>>>>>>>>>> 399, in execute_from_command_line
>>>>>>>>>>>> utility.execute()
>>>>>>>>>>>> File
>>>>>>>>>>>> "/usr/lib/python2.7/site-packages/django/core/management/__init__.py",
>>>>>>>>>>>> line
>>>>>>>>>>>> 392, in execute
>>>>>>>>>>>> self.fetch_command(subcommand).run_from_argv(self.argv)
>>>>>>>>>>>> File
>>>>>>>>>>>> "/usr/lib/python2.7/site-packages/django/core/management/base.py",
>>>>>>>>>>>> line
>>>>>>>>>>>> 242, in run_from_argv
>>>>>>>>>>>> self.execute(*args, **options.__dict__)
>>>>>>>>>>>> File
>>>>>>>>>>>> "/usr/lib/python2.7/site-packages/django/core/management/base.py",
>>>>>>>>>>>> line
>>>>>>>>>>>> 285, in execute
>>>>>>>>>>>> output = self.handle(*args, **options)
>>>>>>>>>>>> File
>>>>>>>>>>>> "/usr/lib/python2.7/site-packages/arches/management/commands/packages.py",
>>>>>>>>>>>> line 67, in handle
>>>>>>>>>>>> self.install(package_name)
>>>>>>>>>>>> File
>>>>>>>>>>>> "/usr/lib/python2.7/site-packages/arches/management/commands/packages.py",
>>>>>>>>>>>> line 114, in install
>>>>>>>>>>>> install()
>>>>>>>>>>>> File
>>>>>>>>>>>> "/usr/share/sandboxes/Projects/my_hip_app/my_hip_app/setup.py",
>>>>>>>>>>>> line 6, in
>>>>>>>>>>>> install
>>>>>>>>>>>> setup.install()
>>>>>>>>>>>> File "/usr/lib/python2.7/site-packages/arches_hip/setup.py",
>>>>>>>>>>>> line 22, in install
>>>>>>>>>>>> Resource().prepare_term_index(create=True)
>>>>>>>>>>>> File
>>>>>>>>>>>> "/usr/lib/python2.7/site-packages/arches/app/models/resource.py",
>>>>>>>>>>>> line 53,
>>>>>>>>>>>> in __new__
>>>>>>>>>>>> mod = __import__(modulename, globals(), locals(),
>>>>>>>>>>>> [classname], -1)
>>>>>>>>>>>> ImportError: No module named resource
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> *Ubuntu *
>>>>>>>>>>>> VACUUM
>>>>>>>>>>>> deleting index : concept_labels
>>>>>>>>>>>> deleting index : term
>>>>>>>>>>>> Traceback (most recent call last):
>>>>>>>>>>>> File "manage.py", line 28, in <module>
>>>>>>>>>>>> execute_from_command_line(sys.argv)
>>>>>>>>>>>> File
>>>>>>>>>>>> "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py",
>>>>>>>>>>>> line 338, in execute_from_command_line
>>>>>>>>>>>> utility.execute()
>>>>>>>>>>>> File
>>>>>>>>>>>> "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py",
>>>>>>>>>>>> line 330, in execute
>>>>>>>>>>>> self.fetch_command(subcommand).run_from_argv(self.argv)
>>>>>>>>>>>> File
>>>>>>>>>>>> "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py",
>>>>>>>>>>>> line 393, in run_from_argv
>>>>>>>>>>>> self.execute(*args, **cmd_options)
>>>>>>>>>>>> File
>>>>>>>>>>>> "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py",
>>>>>>>>>>>> line 444, in execute
>>>>>>>>>>>> output = self.handle(*args, **options)
>>>>>>>>>>>> File
>>>>>>>>>>>> "/usr/local/lib/python2.7/dist-packages/arches/management/commands/packages.py",
>>>>>>>>>>>> line 67, in handle
>>>>>>>>>>>> self.install(package_name)
>>>>>>>>>>>> File
>>>>>>>>>>>> "/usr/local/lib/python2.7/dist-packages/arches/management/commands/packages.py",
>>>>>>>>>>>> line 114, in install
>>>>>>>>>>>> install()
>>>>>>>>>>>> File
>>>>>>>>>>>> "/usr/share/sandboxes/Projects/my_hip_app/my_hip_app/setup.py",
>>>>>>>>>>>> line 6, in
>>>>>>>>>>>> install
>>>>>>>>>>>> setup.install()
>>>>>>>>>>>> File
>>>>>>>>>>>> "/usr/local/lib/python2.7/dist-packages/arches_hip/setup.py", line
>>>>>>>>>>>> 22, in
>>>>>>>>>>>> install
>>>>>>>>>>>> Resource().prepare_term_index(create=True)
>>>>>>>>>>>> File
>>>>>>>>>>>> "/usr/local/lib/python2.7/dist-packages/arches/app/models/resource.py",
>>>>>>>>>>>> line 53, in __new__
>>>>>>>>>>>> mod = __import__(modulename, globals(), locals(),
>>>>>>>>>>>> [classname], -1)
>>>>>>>>>>>> ImportError: No module named resource
>>>>>>>>>>>> (ENV)arches@mediathread
>>>>>>>>>>>> :/usr/share/sandboxes/Projects/my_hip_app$
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> and I couldn't find the database arches_my_hip_app
>>>>>>>>>>>>
>>>>>>>>>>>> Can you please help me out with that? I will be working on the
>>>>>>>>>>>> Centos server.
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> Thanks a lot,
>>>>>>>>>>>>
>>>>>>>>>>>> Asmaa
>>>>>>>>>>>>
>>>>>>>>>>> --
>>>>>>>>>>> -- To post, send email to [email protected]. To
>>>>>>>>>>> unsubscribe, send email to
>>>>>>>>>>> [email protected]. For more
>>>>>>>>>>> information, visit
>>>>>>>>>>> https://groups.google.com/d/forum/archesproject?hl=en
>>>>>>>>>>> ---
>>>>>>>>>>> You received this message because you are subscribed to the
>>>>>>>>>>> Google Groups "Arches Project" group.
>>>>>>>>>>> To unsubscribe from this group and stop receiving emails from
>>>>>>>>>>> it, send an email to [email protected].
>>>>>>>>>>> For more options, visit https://groups.google.com/d/optout.
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> -- To post, send email to [email protected]. To
>>>>>>>>> unsubscribe, send email to
>>>>>>>>> [email protected]. For more information,
>>>>>>>>> visit https://groups.google.com/d/forum/archesproject?hl=en
>>>>>>>>> ---
>>>>>>>>> You received this message because you are subscribed to the Google
>>>>>>>>> Groups "Arches Project" group.
>>>>>>>>> To unsubscribe from this group and stop receiving emails from it,
>>>>>>>>> send an email to [email protected].
>>>>>>>>> For more options, visit https://groups.google.com/d/optout.
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>>> --
>>> -- To post, send email to [email protected]. To
>>> unsubscribe, send email to [email protected].
>>> For more information, visit
>>> https://groups.google.com/d/forum/archesproject?hl=en
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "Arches Project" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to [email protected].
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>
>
--
-- To post, send email to [email protected]. To unsubscribe, send
email to [email protected]. For more information,
visit https://groups.google.com/d/forum/archesproject?hl=en
---
You received this message because you are subscribed to the Google Groups
"Arches Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
