Gestione rete

Question

Anch'io ho il problema, dopo aver installato postgresql, che non si avvia.

Ti allego il file log:

2016-08-31 08:20:32,861 - sagra - ERROR - Uncaught exception:
Traceback (most recent call last):
  File "<string>", line 19, in <module>
  File "c:\python27\lib\site-packages\PyInstaller-2.1dev_71a4ce2-py2.7.egg\PyInstaller\loader\pyi_importers.py", line 270, in load_module
  File "C:\git\gestionesagra\src\build\sagra\out00-PYZ.pyz\splashscreen", line 5, in <module>
  File "c:\python27\lib\site-packages\PyInstaller-2.1dev_71a4ce2-py2.7.egg\PyInstaller\loader\pyi_importers.py", line 270, in load_module
  File "C:\git\gestionesagra\src\build\sagra\out00-PYZ.pyz\guiutil", line 3, in <module>
  File "c:\python27\lib\site-packages\PyInstaller-2.1dev_71a4ce2-py2.7.egg\PyInstaller\loader\pyi_importers.py", line 270, in load_module
  File "C:\git\gestionesagra\src\build\sagra\out00-PYZ.pyz\bo", line 4, in <module>
  File "c:\python27\lib\site-packages\PyInstaller-2.1dev_71a4ce2-py2.7.egg\PyInstaller\loader\pyi_importers.py", line 270, in load_module
  File "C:\git\gestionesagra\src\build\sagra\out00-PYZ.pyz\database", line 220, in <module>
  File "C:\git\gestionesagra\src\build\sagra\out00-PYZ.pyz\database", line 29, in get_version
  File "C:\git\gestionesagra\src\build\sagra\out00-PYZ.pyz\sqlalchemy.engine.base", line 2471, in connect
  File "C:\git\gestionesagra\src\build\sagra\out00-PYZ.pyz\sqlalchemy.engine.base", line 878, in __init__
  File "C:\git\gestionesagra\src\build\sagra\out00-PYZ.pyz\sqlalchemy.engine.base", line 2557, in raw_connection
  File "C:\git\gestionesagra\src\build\sagra\out00-PYZ.pyz\sqlalchemy.pool", line 184, in unique_connection
  File "C:\git\gestionesagra\src\build\sagra\out00-PYZ.pyz\sqlalchemy.pool", line 401, in __init__
  File "C:\git\gestionesagra\src\build\sagra\out00-PYZ.pyz\sqlalchemy.pool", line 746, in _do_get
  File "C:\git\gestionesagra\src\build\sagra\out00-PYZ.pyz\sqlalchemy.pool", line 189, in _create_connection
  File "C:\git\gestionesagra\src\build\sagra\out00-PYZ.pyz\sqlalchemy.pool", line 282, in __init__
  File "C:\git\gestionesagra\src\build\sagra\out00-PYZ.pyz\sqlalchemy.pool", line 344, in __connect
  File "C:\git\gestionesagra\src\build\sagra\out00-PYZ.pyz\sqlalchemy.engine.strategies", line 80, in connect
  File "C:\git\gestionesagra\src\build\sagra\out00-PYZ.pyz\sqlalchemy.engine.default", line 281, in connect
  File "C:\git\gestionesagra\src\build\sagra\out00-PYZ.pyz\psycopg2", line 164, in connect
OperationalError: (OperationalError) 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?
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 5432?
 None None

Answer 1

Domanda: ma sei sul PC con installato PostGreSql o su un client? Mi viene da pensare che sei sul PC con PostGreSql.

Mandami il file "sagra.ini" e "log.log" alla mail mrsmyle su gmail (spero sia chiaro). Ho la sensazione che si tratti di un errore di sintassi.
Ciao.

Mauro.

Answer 2

Ciao Mauro,

ho risolto ieri sera il problema, è bastato inserire la riga "host    all             all             127.0.0.1/32            md5" nel file pg_hba e tutto funziona.

Senza la riga "host    all             all             127.0.0.1/32            md5" funzionava dal client ma non dal server.

Ti invio comunque i file per un tuo eventuale controllo.

Grazie per la pronta risposta e ti saluto cordialmente.

Renato.

PG_HBA.CONF

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# IPv4 local connections:

host    sagra           sagra           192.168.0.0/16          md5
host    all             all             127.0.0.1/32            md5

# IPv6 local connections:
#host    all             all             ::1/128                 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
#host    replication     postgres        127.0.0.1/32            md5
#host    replication     postgres        ::1/128                 md5

LOG.LOG

2016-09-03 08:41:23,671 - sagra - ERROR - Uncaught exception:
Traceback (most recent call last):
  File "<string>", line 19, in <module>
  File "c:\python27\lib\site-packages\PyInstaller-2.1dev_71a4ce2-py2.7.egg\PyInstaller\loader\pyi_importers.py", line 270, in load_module
  File "C:\git\gestionesagra\src\build\sagra\out00-PYZ.pyz\splashscreen", line 5, in <module>
  File "c:\python27\lib\site-packages\PyInstaller-2.1dev_71a4ce2-py2.7.egg\PyInstaller\loader\pyi_importers.py", line 270, in load_module
  File "C:\git\gestionesagra\src\build\sagra\out00-PYZ.pyz\guiutil", line 3, in <module>
  File "c:\python27\lib\site-packages\PyInstaller-2.1dev_71a4ce2-py2.7.egg\PyInstaller\loader\pyi_importers.py", line 270, in load_module
  File "C:\git\gestionesagra\src\build\sagra\out00-PYZ.pyz\bo", line 4, in <module>
  File "c:\python27\lib\site-packages\PyInstaller-2.1dev_71a4ce2-py2.7.egg\PyInstaller\loader\pyi_importers.py", line 270, in load_module
  File "C:\git\gestionesagra\src\build\sagra\out00-PYZ.pyz\database", line 220, in <module>
  File "C:\git\gestionesagra\src\build\sagra\out00-PYZ.pyz\database", line 29, in get_version
  File "C:\git\gestionesagra\src\build\sagra\out00-PYZ.pyz\sqlalchemy.engine.base", line 2471, in connect
  File "C:\git\gestionesagra\src\build\sagra\out00-PYZ.pyz\sqlalchemy.engine.base", line 878, in __init__
  File "C:\git\gestionesagra\src\build\sagra\out00-PYZ.pyz\sqlalchemy.engine.base", line 2557, in raw_connection
  File "C:\git\gestionesagra\src\build\sagra\out00-PYZ.pyz\sqlalchemy.pool", line 184, in unique_connection
  File "C:\git\gestionesagra\src\build\sagra\out00-PYZ.pyz\sqlalchemy.pool", line 401, in __init__
  File "C:\git\gestionesagra\src\build\sagra\out00-PYZ.pyz\sqlalchemy.pool", line 746, in _do_get
  File "C:\git\gestionesagra\src\build\sagra\out00-PYZ.pyz\sqlalchemy.pool", line 189, in _create_connection
  File "C:\git\gestionesagra\src\build\sagra\out00-PYZ.pyz\sqlalchemy.pool", line 282, in __init__
  File "C:\git\gestionesagra\src\build\sagra\out00-PYZ.pyz\sqlalchemy.pool", line 344, in __connect
  File "C:\git\gestionesagra\src\build\sagra\out00-PYZ.pyz\sqlalchemy.engine.strategies", line 80, in connect
  File "C:\git\gestionesagra\src\build\sagra\out00-PYZ.pyz\sqlalchemy.engine.default", line 281, in connect
  File "C:\git\gestionesagra\src\build\sagra\out00-PYZ.pyz\psycopg2", line 164, in connect
OperationalError: (OperationalError) FATALE:  nessuna voce in pg_hba.conf per l'host "127.0.0.1", utente "sagra", database "festa", SSL non abilitato
 None None