Also, you'll have to add this to settings.py in order to accommodate your
non-default postgres port:
DATABASES['default']['port'] = '5433'
If you have a lot of non-default configurations in your postgres
installation, you may want to copy the entire set of database settings from
..\ENV\Lib\site-packages\arches\settings.py into your own settings file:
DATABASES = {
'default': {
'ENGINE': 'django.contrib.gis.db.backends.postgis', # Add
'postgresql_psycopg2', 'postgresql', 'mysql', 'sqlite3' or 'oracle'.
'NAME': 'arches', # Or path to database file
if using sqlite3.
'USER': 'postgres', # Not used with sqlite3.
'PASSWORD': 'postgis', # Not used with sqlite3.
'HOST': 'localhost', # Set to empty string for
localhost. Not used with sqlite3.
'PORT': '5432', # Set to empty string for
default. Not used with sqlite3.
'POSTGIS_TEMPLATE': 'template_postgis_20',
}
}
As for trouble with editing settings.py, what you described is very
strange. If you continue to have trouble editing with IDLE, there are lots
of other text editors that work well, I use Notepad++
<https://notepad-plus-plus.org/> a lot, which works well for all languages
(not just python).
I have noticed a funny bug with IDLE where sometimes ctrl+s stops working
as a shortcut for saving. But if you close the program it will still warn
you to save before closing and I've never encountered a problem with that...
Adam
On Monday, June 13, 2016 at 10:57:14 AM UTC-6, Alexei Peters wrote:
>
> Hi Basav,
> If you're not on the default port you can add it to your command line call.
>
> createdb -p 5433 -U postgres -E UTF8 -T template0 template_postgis_20
>
> -Alexei
>
>
> Director of Web Development - Farallon Geographics, Inc. - 971.227.3173
>
> On Mon, Jun 13, 2016 at 9:39 AM, Basav Biradar <[email protected]> wrote:
>
>> Hi Adam,
>>
>> I did try adding the same in the settings.py file in EDIT mode (EDIT with
>> IDLE option) but once I have saved the file and closed it, I see that it
>> disappears again.
>>
>> Sorry, I sound very low-tech :) but I could not figure out this issue.
>>
>> Also, I keep getting the following error on executing "createdb" command
>> -
>>
>> *C:\Users\User>createdb -U postgres -E UTF8 -T template0
>> template_postgis_20*
>> *createdb: could not connect to database template1: could not connect to
>> server:*
>> *Connection refused (0x0000274D/10061)*
>> * Is the server running on host "localhost" (::1) and accepting*
>> * TCP/IP connections on port 5432?*
>> *received invalid response to SSL negotiation: -*
>>
>>
>> The installation is 5433 port (it does not allow me to do it on 5432) but
>> when I execute createdb command it throws this error.
>>
>> I think the primary failure is because of the DB not setup correctly
>> since the createdb command is not executed.
>>
>> Thanks
>> Basav
>>
>>
>>
>> On Mon, Jun 13, 2016 at 7:31 PM, Adam Cox <[email protected]> wrote:
>>
>>> Apologies, looks like it's *GDAL_LIBRARY_PATH*.
>>>
>>> On Mon, Jun 13, 2016 at 7:58 AM, Adam Cox <[email protected]> wrote:
>>>
>>>> Hi Basav, it looks like you still need to add the GDAL_PATH variable to
>>>> your settings.py file. This is mentioned in step #6 here:
>>>> http://arches-hip.readthedocs.io/en/latest/getting-started/#installating-arches-hip.
>>>>
>>>> Try that out and see it if helps.
>>>>
>>>> Adam
>>>>
>>>> On Mon, Jun 13, 2016 at 3:48 AM, Basav Biradar <[email protected]>
>>>> wrote:
>>>>
>>>>> An update -
>>>>>
>>>>> I think the issue is with database setup.
>>>>>
>>>>> Since the Createdb is command is failing, i am getting the following
>>>>> error at the end -
>>>>> *File
>>>>> "C:\Projects\ENV\lib\site-packages\arches\app\utils\data_management\resou*
>>>>> *rces\importer.py", line 22, in <module>*
>>>>> * from formats.shpfile import ShapeReader*
>>>>> * File
>>>>> "C:\Projects\ENV\lib\site-packages\arches\app\utils\data_management\resou*
>>>>> *rces\formats\shpfile.py", line 5, in <module>*
>>>>> * from django.contrib.gis.gdal import DataSource*
>>>>> *ImportError: cannot import name DataSource*
>>>>>
>>>>> *`*
>>>>> *Please help.*
>>>>>
>>>>> On Monday, 13 June 2016 11:04:48 UTC+5:30, Basav Biradar wrote:
>>>>>>
>>>>>> Hi Alexei, Adam, Alison,
>>>>>>
>>>>>> I am trying to install Arches on Windows from last few days with no
>>>>>> success.
>>>>>>
>>>>>> Issue # 1 : After I install PostgreSQL 9.3 and try to run the
>>>>>> commands createdb -U postgres -E UTF8 -T template0
>>>>>> template_postgis_20
>>>>>>
>>>>>> I get the following error-
>>>>>>
>>>>>> *C:\Users\User>createdb -U postgres -E UTF8 -T template0
>>>>>> template_postgis_20*
>>>>>>
>>>>>> *createdb: could not connect to database template1: could not connect to
>>>>>> server:
>>>>>> Connection refused (0x0000274D/10061)
>>>>>> Is the server running on host "localhost" (::1) and accepting
>>>>>> TCP/IP connections on port 5432?
>>>>>> received invalid response to SSL negotiation: -*
>>>>>>
>>>>>>
>>>>>> *Issue # 2: If i ignore and go ahead the arches installation command
>>>>>> does not execute*
>>>>>>
>>>>>>
>>>>>> *Can you please help?*
>>>>>>
>>>>>>
>>>>>> *Please note: I have successfully installed PostgreSQL and updated the
>>>>>> PATH file*
>>>>>>
>>>>>> --
>>>>> -- 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.
>>>>>
>>>>
>>>>
>>>
>>
>>
>> --
>> Books are legacies that a great genius leaves for mankind, which are
>> delivered from generation to generation as presents to the posterity of
>> those who are as yet unborn.
>>
>> --
>> -- 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.
