ARGOMENTO: Installazione di 6.1 in ubuntu 12.04 LTS

alle prime installazioni fa bene al morale vedere che partono subito, poi sicuramente è meglio optare su bzr per avere istantaneamente gli aggiornamenti...

Seguendo theopensourcerer sono arrivato ad avere il DB funzionante, ci entro con pgadminIII.
Ho il file openerp-server.conf in /etc con user e passw. Faccio partire openerp-server, vado sul localhost/8069 e compaiono una serie di errori che per il momento no riporto. Mi sembrano più significative le righe che compaiono sulla shell:
2012-05-16 15:04:18,717 3817 ERROR template1 openerp.sql_db: Connection to the database failed
Traceback (most recent call last):
File "/opt/openerp/server/openerp/sql_db.py", line 421, in borrow
result = psycopg2.connect(dsn=dsn, connection_factory=PsycoConnection)
File "/usr/lib/python2.7/dist-packages/psycopg2/__init__.py", line 179, in connect
connection_factory=connection_factory, async=async)
OperationalError: fe_sendauth: no password supplied

Ad occhio direi che non legge la password in openerp-server.conf
Capisco bene?

si, parrebbe anche a me

come la passi nel file di conf?

[options]
; This is the password that allows database operations:
; admin_passwd = admin
db_host = False
db_port = False
db_user = openerp
db_password = Lamiapassword111
logfile = /var/log/openerp/openerp-server.log

ad occhio mi pare corretto.

prova ad avviare openerp a mano passando -r openerp -w Lamiapassword111

openerp@server:~$ /opt/openerp/server/openerp-server -r openerp -w Lamiapassword111
2012-05-17 11:06:00,848 32484 INFO ? openerp: OpenERP version 6.1-1
2012-05-17 11:06:00,849 32484 INFO ? openerp: addons paths: /opt/openerp/server/openerp/addons
2012-05-17 11:06:00,849 32484 INFO ? openerp: database hostname: localhost
2012-05-17 11:06:00,849 32484 INFO ? openerp: database port: 5432
2012-05-17 11:06:00,849 32484 INFO ? openerp: database user: openerp
2012-05-17 11:06:00,849 32484 INFO ? openerp.service.netrpc_server: starting NET-RPC service on 0.0.0.0:8070
2012-05-17 11:06:00,850 32484 INFO ? openerp.netsvc: Starting 1 services
2012-05-17 11:06:00,876 32484 INFO ? openerp.wsgi.core: HTTP service (werkzeug) running on 0.0.0.0:8069
2012-05-17 11:06:01,008 32484 INFO ? openerp.addons.web: embedded mode
2012-05-17 11:06:01,414 32484 INFO ? openerp: OpenERP server is running, waiting for connections...
2012-05-17 11:06:14,302 32484 INFO ? werkzeug: 127.0.0.1 - - [17/May/2012 11:06:14] "GET /web/webclient/home HTTP/1.1" 200 -
2012-05-17 11:06:14,396 32484 INFO ? werkzeug: 127.0.0.1 - - [17/May/2012 11:06:14] "GET /web/webclient/css HTTP/1.1" 304 -
2012-05-17 11:06:14,416 32484 INFO ? werkzeug: 127.0.0.1 - - [17/May/2012 11:06:14] "GET /web/webclient/js HTTP/1.1" 304 -
2012-05-17 11:06:14,717 32484 INFO ? werkzeug: 127.0.0.1 - - [17/May/2012 11:06:14] "POST /web/session/get_session_info HTTP/1.1" 200 -
2012-05-17 11:06:14,756 32484 INFO ? werkzeug: 127.0.0.1 - - [17/May/2012 11:06:14] "POST /web/webclient/qweblist HTTP/1.1" 200 -
2012-05-17 11:06:14,873 32484 INFO ? werkzeug: 127.0.0.1 - - [17/May/2012 11:06:14] "POST /web/proxy/load HTTP/1.1" 200 -
2012-05-17 11:06:14,970 32484 INFO ? werkzeug: 127.0.0.1 - - [17/May/2012 11:06:14] "POST /web/session/get_lang_list HTTP/1.1" 200 -
2012-05-17 11:06:14,974 32484 INFO template1 werkzeug: 127.0.0.1 - - [17/May/2012 11:06:14] "POST /web/database/get_list HTTP/1.1" 200 -
2012-05-17 11:06:14,991 32484 INFO template1 werkzeug: 127.0.0.1 - - [17/May/2012 11:06:14] "POST /web/database/get_list HTTP/1.1" 200 -
2012-05-17 11:06:15,001 32484 INFO ? werkzeug: 127.0.0.1 - - [17/May/2012 11:06:15] "GET /web/static/src/img/logo2.png HTTP/1.1" 304 -
2012-05-17 11:06:15,002 32484 INFO ? werkzeug: 127.0.0.1 - - [17/May/2012 11:06:15] "GET /web/static/src/img/pattern.png HTTP/1.1" 304 -
2012-05-17 11:06:50,936 32484 INFO ? werkzeug: 127.0.0.1 - - [17/May/2012 11:06:50] "GET /web/static/lib/jquery.ui/css/smoothness/images/ui-icons_cd0a0a_256x240.png HTTP/1.1" 304 -

Non va, non aggacia il db. Nemmeno lo spazio "database:" in localhost:8069/web/webclient/home e utilizzabile.


Il db mi sembra corretto:

openerp@server:~$ psql -l
Password:
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges

---

+

---

+

---

+

---

+

---

+

---

postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
(3 rows)


Aggiungo righe significative di pg_hba.conf
# DO NOT DISABLE!
# If you change this first entry you will need to make sure that the
# database superuser can access the database using some other method.
# Noninteractive access to all databases is required during automatic
# maintenance (custom daily cronjobs, replication, and similar tasks).
#
# Database administrative login by Unix domain socket
#local all postgres peer
local all postgres ident


# TYPE DATABASE USER ADDRESS METHOD
local all openerp md5

# "local" is for Unix domain socket connections only
#local all all peer
local all all ident
# IPv4 local connections:
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.
#local replication postgres peer
host replication postgres 127.0.0.1/32 md5
host replication postgres ::1/128 md5