[Python-es] la autentificaci?n Ident fall? para el usuario <<postgres>>
Gustavo Garay
chauria en gmail.com
Mar Oct 4 20:31:41 CEST 2011
si pero postgis es una extensión spacial para postgresql
El 4 de octubre de 2011 15:04, Diego Uribe Gamez <
diego.uribe.gamez en gmail.com> escribió:
> ni idea? lo estoy instalando desde los repositorios de debian
>
> postgis - geographic
> objects support for PostgreSQL -- common files
>
> Aunque cuando hago el comando "psql" me sale:
>
> postgres en servidor:~$ psql
> psql (8.4.8)
>
> El 4 de octubre de 2011 13:01, Gustavo Garay <chauria en gmail.com> escribió:
>
> ahi esta buscando postgis, que versión tenes instalado o tenes instalado ?
>>
>> saludos
>>
>>
>>
>> El 4 de octubre de 2011 14:53, Diego Uribe Gamez <
>> diego.uribe.gamez en gmail.com> escribió:
>>
>> Ya arregle esa parte y me dejo autenticar, lo que hice fue especificar
>>> localhost en settings.py "'HOST': 'localhost'," pero sigo con problemas y es
>>> que me saca un nuevo error, creo que es el ultimo o eso espero:
>>>
>>> django.core.exceptions.ImproperlyConfigured: Cannot determine PostGIS
>>> version for database "olwidget_dev". GeoDjango requires at least PostGIS
>>> version 1.3. Was the database created from a spatial database template?
>>>
>>> El 4 de octubre de 2011 12:46, Gustavo Garay <chauria en gmail.com>escribió:
>>>
>>> esta tratando de conectarte como socket de unix no via tcp
>>>> este es el error que arroja
>>>>
>>>>
>>>> psycopg2.OperationalError: FATAL: la autentificaci?n Ident fall? para
>>>> el usuario <<postgres>>
>>>>
>>>>
>>>> tenes que ver si tenes configurado para uso de ident en pg_hba.conf
>>>>
>>>> local all postgres ident
>>>> # TYPE DATABASE USER CIDR-ADDRESS METHOD
>>>> # "local" is for Unix domain socket connections only
>>>> local all all ident
>>>>
>>>> algo asi tiene que tener tu archivos
>>>>
>>>>
>>>> saludos
>>>>
>>>>
>>>> El 4 de octubre de 2011 14:34, Diego Uribe Gamez <
>>>> diego.uribe.gamez en gmail.com> escribió:
>>>>
>>>> si logre hacer lo que me comentaste, pero nada ya ahora creo que el
>>>>> problema esta en django? aunque la verdad no se?
>>>>>
>>>>> El problema:
>>>>>
>>>>> ---------------------------------------------------------------------------------------------------
>>>>> Traceback (most recent call last):
>>>>> File "manage.py", line 11, in <module>
>>>>> execute_manager(settings)
>>>>> File
>>>>> "/usr/local/lib/python2.6/dist-packages/django/core/management/__init__.py",
>>>>> line 438, in execute_manager
>>>>> utility.execute()
>>>>> File
>>>>> "/usr/local/lib/python2.6/dist-packages/django/core/management/__init__.py",
>>>>> line 379, in execute
>>>>> self.fetch_command(subcommand).run_from_argv(self.argv)
>>>>> File
>>>>> "/usr/local/lib/python2.6/dist-packages/django/core/management/__init__.py",
>>>>> line 261, in fetch_command
>>>>> klass = load_command_class(app_name, subcommand)
>>>>> File
>>>>> "/usr/local/lib/python2.6/dist-packages/django/core/management/__init__.py",
>>>>> line 67, in load_command_class
>>>>> module = import_module('%s.management.commands.%s' % (app_name,
>>>>> name))
>>>>> File
>>>>> "/usr/local/lib/python2.6/dist-packages/django/utils/importlib.py", line 35,
>>>>> in import_module
>>>>> __import__(name)
>>>>> File
>>>>> "/usr/local/lib/python2.6/dist-packages/django/core/management/commands/syncdb.py",
>>>>> line 7, in <module>
>>>>> from django.core.management.sql import custom_sql_for_model,
>>>>> emit_post_sync_signal
>>>>> File
>>>>> "/usr/local/lib/python2.6/dist-packages/django/core/management/sql.py", line
>>>>> 6, in <module>
>>>>> from django.db import models
>>>>> File "/usr/local/lib/python2.6/dist-packages/django/db/__init__.py",
>>>>> line 78, in <module>
>>>>> connection = connections[DEFAULT_DB_ALIAS]
>>>>> File "/usr/local/lib/python2.6/dist-packages/django/db/utils.py",
>>>>> line 94, in __getitem__
>>>>> conn = backend.DatabaseWrapper(db, alias)
>>>>> File
>>>>> "/usr/local/lib/python2.6/dist-packages/django/contrib/gis/db/backends/postgis/base.py",
>>>>> line 11, in __init__
>>>>> self.ops = PostGISOperations(self)
>>>>> File
>>>>> "/usr/local/lib/python2.6/dist-packages/django/contrib/gis/db/backends/postgis/operations.py",
>>>>> line 91, in __init__
>>>>> vtup = self.postgis_version_tuple()
>>>>> File
>>>>> "/usr/local/lib/python2.6/dist-packages/django/contrib/gis/db/backends/postgis/operations.py",
>>>>> line 445, in postgis_version_tuple
>>>>> version = self.postgis_lib_version()
>>>>> File
>>>>> "/usr/local/lib/python2.6/dist-packages/django/contrib/gis/db/backends/postgis/operations.py",
>>>>> line 425, in postgis_lib_version
>>>>> return self._get_postgis_func('postgis_lib_version')
>>>>> File
>>>>> "/usr/local/lib/python2.6/dist-packages/django/contrib/gis/db/backends/postgis/operations.py",
>>>>> line 406, in _get_postgis_func
>>>>> cursor = self.connection._cursor()
>>>>> File
>>>>> "/usr/local/lib/python2.6/dist-packages/django/db/backends/postgresql_psycopg2/base.py",
>>>>> line 140, in _cursor
>>>>> self.connection = Database.connect(**conn_params)
>>>>>
>>>>> psycopg2.OperationalError: FATAL: la autentificaci?n Ident fall? para
>>>>> el usuario <<postgres>>
>>>>>
>>>>> ---------------------------------------------------------------------------------------------------
>>>>>
>>>>> La ultima solución anterior:
>>>>>
>>>>> ----------------------------------------------------------------------------------------------------
>>>>> postgres en servidor:~$ psql
>>>>> psql (8.4.8)
>>>>> Digite «help» para obtener ayuda.
>>>>>
>>>>> postgres=# \password postgres
>>>>> Ingrese la nueva contraseña:
>>>>> Ingrésela nuevamente:
>>>>> postgres=# help
>>>>> Está usando psql, la interfaz de línea de órdenes de PostgreSQL.
>>>>> Digite: \copyright para ver los términos de distribución
>>>>> \h para ayuda de órdenes SQL
>>>>> \? para ayuda de órdenes psql
>>>>> \g o punto y coma («;») para ejecutar la consulta
>>>>> \q para salir
>>>>> postgres=# \q
>>>>> postgres en servidor:~$ exit
>>>>>
>>>>> ---------------------------------------------------------------------------------------------------
>>>>>
>>>>> El 4 de octubre de 2011 12:12, Gustavo Garay <chauria en gmail.com>escribió:
>>>>>
>>>>> si pero ahi vos cambiaste de la cuenta del servicio, no del usuario de
>>>>>> la base de datos
>>>>>>
>>>>>> estando como usuario postgres
>>>>>>
>>>>>> proba algo asi
>>>>>>
>>>>>> psql
>>>>>>
>>>>>> y te vas a conectar en modo consola en la base
>>>>>>
>>>>>> \password postgres <enter>
>>>>>>
>>>>>>
>>>>>> y va pedir el nuevo
>>>>>>
>>>>>> saludos
>>>>>>
>>>>>>
>>>>>> El 4 de octubre de 2011 13:56, Diego Uribe Gamez <
>>>>>> diego.uribe.gamez en gmail.com> escribió:
>>>>>>
>>>>>>> No logro entrar a la base de datos, no se que hacer, ya intente
>>>>>>> cambiar la contraseña del usuario en Linux Debia y nada?
>>>>>>>
>>>>>>> root en servidor:/var/django/test_project# su postgres -c passwd
>>>>>>> Cambiando la contraseña de postgres.
>>>>>>> (actual) contraseña de UNIX:
>>>>>>> Introduzca la nueva contraseña de UNIX:
>>>>>>> Vuelva a escribir la nueva contraseña de UNIX:
>>>>>>> passwd: contraseña actualizada correctamente
>>>>>>> root en servidor:/var/django/test_project# psql -U postgres -W
>>>>>>> Contraseña para usuario postgres:
>>>>>>> psql: FATAL: la autentificaci?n Ident fall? para el usuario
>>>>>>> <<postgres>>
>>>>>>>
>>>>>>> Ayuda por favor.
>>>>>>>
>>>>>>> Gracias.
>>>>>>> --
>>>>>>> *Diego Alonso Uribe Gamez*
>>>>>>> ------------------------------
>>>>>>>
>>>>>>> *Desarrollador web*
>>>>>>>
>>>>>>> Twitter: @DiegoUG <http://www.twitter.com/DiegoUG>
>>>>>>>
>>>>>>> Google+: http://gplus.to/diegoug
>>>>>>> ------------------------------
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> Python-es mailing list
>>>>>>> Python-es en python.org
>>>>>>> http://mail.python.org/mailman/listinfo/python-es
>>>>>>> FAQ: http://python-es-faq.wikidot.com/
>>>>>>>
>>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> Python-es mailing list
>>>>>> Python-es en python.org
>>>>>> http://mail.python.org/mailman/listinfo/python-es
>>>>>> FAQ: http://python-es-faq.wikidot.com/
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> *Diego Alonso Uribe Gamez*
>>>>> ------------------------------
>>>>>
>>>>> *Desarrollador web*
>>>>>
>>>>> Twitter: @DiegoUG <http://www.twitter.com/DiegoUG>
>>>>>
>>>>> Google+: http://gplus.to/diegoug
>>>>> ------------------------------
>>>>>
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> Python-es mailing list
>>>>> Python-es en python.org
>>>>> http://mail.python.org/mailman/listinfo/python-es
>>>>> FAQ: http://python-es-faq.wikidot.com/
>>>>>
>>>>>
>>>>
>>>> _______________________________________________
>>>> Python-es mailing list
>>>> Python-es en python.org
>>>> http://mail.python.org/mailman/listinfo/python-es
>>>> FAQ: http://python-es-faq.wikidot.com/
>>>>
>>>>
>>>
>>>
>>> --
>>> *Diego Alonso Uribe Gamez*
>>> ------------------------------
>>>
>>> *Desarrollador web*
>>>
>>> Twitter: @DiegoUG <http://www.twitter.com/DiegoUG>
>>>
>>> Google+: http://gplus.to/diegoug
>>> ------------------------------
>>>
>>>
>>>
>>> _______________________________________________
>>> Python-es mailing list
>>> Python-es en python.org
>>> http://mail.python.org/mailman/listinfo/python-es
>>> FAQ: http://python-es-faq.wikidot.com/
>>>
>>>
>>
>> _______________________________________________
>> Python-es mailing list
>> Python-es en python.org
>> http://mail.python.org/mailman/listinfo/python-es
>> FAQ: http://python-es-faq.wikidot.com/
>>
>>
>
>
> --
> *Diego Alonso Uribe Gamez*
> ------------------------------
>
> *Desarrollador web*
>
> Twitter: @DiegoUG <http://www.twitter.com/DiegoUG>
>
> Google+: http://gplus.to/diegoug
> ------------------------------
>
>
>
> _______________________________________________
> Python-es mailing list
> Python-es en python.org
> http://mail.python.org/mailman/listinfo/python-es
> FAQ: http://python-es-faq.wikidot.com/
>
>
------------ próxima parte ------------
Se ha borrado un adjunto en formato HTML...
URL: <http://mail.python.org/pipermail/python-es/attachments/20111004/e945f655/attachment.html>
Más información sobre la lista de distribución Python-es