Hi Alexei, Adam,
Finally I was able to solve the database error but hit the roadblock at the
end while executing the command - python manage.py packages -o
setup_elasticsearch
The error I am getting is -
File "D:\ARCHES\ENV\lib\site-packages\django\db\models\base.py", line
264, in add_to_class
value.contribute_to_class(cls, name)
File "D:\ARCHES\ENV\lib\site-packages\django\db\models\options.py", line
124, in contribute_to_class
self.db_table = truncate_name(self.db_table,
connection.ops.max_name_length())
File "D:\ARCHES\ENV\lib\site-packages\django\db\__init__.py", line 34, in
__getattr__
return getattr(connections[DEFAULT_DB_ALIAS], item)
File "D:\ARCHES\ENV\lib\site-packages\django\db\utils.py", line 198, in
__getitem__
backend = load_backend(db['ENGINE'])
File "D:\ARCHES\ENV\lib\site-packages\django\db\utils.py", line 113, in
load_backend
return import_module('%s.base' % backend_name)
File "D:\ARCHES\ENV\lib\site-packages\django\utils\importlib.py", line
40, in import_module
__import__(name)
File
"D:\ARCHES\ENV\lib\site-packages\django\contrib\gis\db\backends\postgis\base.py",
line 4, in <module>
from django.contrib.gis.db.backends.postgis.introspection import
PostGISIntrospection
File
"D:\ARCHES\ENV\lib\site-packages\django\contrib\gis\db\backends\postgis\introspection.py",
line 2, in <module>
from django.contrib.gis.gdal import OGRGeomType
File
"D:\ARCHES\ENV\lib\site-packages\django\contrib\gis\gdal\__init__.py", line
41, in <module>
from django.contrib.gis.gdal.driver import Driver
File "D:\ARCHES\ENV\lib\site-packages\django\contrib\gis\gdal\driver.py",
line 5, in <module>
from django.contrib.gis.gdal.prototypes import ds as capi
File
"D:\ARCHES\ENV\lib\site-packages\django\contrib\gis\gdal\prototypes\ds.py",
line 8, in <module>
from django.contrib.gis.gdal.libgdal import lgdal
File
"D:\ARCHES\ENV\lib\site-packages\django\contrib\gis\gdal\libgdal.py", line
47, in <module>
lgdal = CDLL(lib_path)
File "c:\python27\Lib\ctypes\__init__.py", line 365, in __init__
self._handle = _dlopen(self._name, mode)
*WindowsError: [Error 193] %1 is not a valid Win32 application*
On Tue, Jun 14, 2016 at 4:19 PM, Basav Biradar <[email protected]> wrote:
> Hi Alexei,
>
> I got the same error -
>
> C:\Windows\system32>createdb -p 5433 -U postgres -E UTF8 -T template0
> template_p
> ostgis_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 5433?
> could not connect to server: Connection refused (0x0000274D/10061)
> Is the server running on host "localhost" (127.0.0.1) and accepting
> TCP/IP connections on port 5433?
>
>
> I think the problem is when I install PostgreSQL - at the end it gives me
> a message "Database cluster initialization failed"
>
> Could that be the cause?
>
> It is a little frustrating that I am not able to cross the first step of
> installing dependencies successfully.
>
> Rgds
> Basav
>
>
>
> On Mon, Jun 13, 2016 at 10:27 PM, Alexei Peters <[email protected]>
> 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.
>>>
>>
>>
>
>
> --
> 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.
>
--
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.
