Odoo Server (MOVED TO GITHUB)

Error trying to connect to server

Asked by Cristian Salamea

Hi folks, i run the server-sa ok, but when i try to connect with clients get this out put from client:

Traceback (most recent call last):
  File "bin/openerp-client.py", line 135, in <module>
    win.sig_login()
  File "/home/ovnicraft/development/openerp/trunk/bin/modules/gui/main.py", line 1026, in sig_login
    res = l.run(dbname=dbname, parent=self.window)
  File "/home/ovnicraft/development/openerp/trunk/bin/modules/gui/main.py", line 496, in run
    res = self.refreshlist(None, db_widget, label, url, but_connect)
  File "/home/ovnicraft/development/openerp/trunk/bin/modules/gui/main.py", line 433, in refreshlist
    res = _refresh_dblist(db_widget, url)
  File "/home/ovnicraft/development/openerp/trunk/bin/modules/gui/main.py", line 344, in _refresh_dblist
    for db_num, db_name in enumerate(result):
TypeError: 'NoneType' object is not iterable

And in server output:

[2009-07-19 22:58:48,614] ERROR:dbpool:Unable to connect to template1: __init__() got an unexpected keyword argument 'autocommit'
Exception __init__() got an unexpected keyword argument 'autocommit'

best regards,

Question information

Language:
English Edit question
Status:
Solved
For:
Odoo Server (MOVED TO GITHUB) Edit question
Assignee:
No assignee Edit question
Solved by:
Cristian Salamea
Solved:
Last query:
Last reply:

This question was reopened

Revision history for this message
Rucha (Open ERP) (rpa-openerp) said : 		#1

Hello Cristian,
Its a problem of version of sqlalchemy,
I think you have 0.4.2,
You need to install newer version of sqlalchemy from 0.5.x series,
You can download this:
http://sourceforge.net/projects/sqlalchemy/files/sqlalchemy/SQLAlchemy-0.5.3.tar.gz/download
It will work fine,

regards,

Revision history for this message
Cristian Salamea (ovnicraft) said : 		#2

Hi, i have installed 0.5.4p2 version of SQLAlchemy, upgraded 0.5.3 and solved my prob.

thanks in advance

Revision history for this message
Cristian Salamea (ovnicraft) said : 		#3

Thanks rpa (Open ERP), that solved my question.

Revision history for this message
Cristian Salamea (ovnicraft) said : 		#4

New error, Exception exceptions must be classes, instances, or strings (deprecated), not NoneType
 i run
./openerp-server --engine='postgresql' -r ovnicraft

Trying to connect with client from trunk

Revision history for this message
Rucha (Open ERP) (rpa-openerp) said : 		#5

Hello Cristian,
The problem is with the engine configuration (--engine='postgresql')
You need to specify like this:

--engine='postgres://USER:PASSWORD@HOSTNAME:PORT'

Where,
USER : Postgres user (Super User)
PASSWORD : Password of USER
HOSTNAME : Host on which Postgres server is running (By Default : localhost)
PORT : Port on which Postgres server is running (By Default : 5432)

This will solve your problem,

Also for this server you need to use Stable5.0 client,(https://code.launchpad.net/~openerp/openobject-client/5.0)

regards,

Revision history for this message
Cristian Salamea (ovnicraft) said : 		#6

Ok that solve my prob, thanks

Revision history for this message
Cristian Salamea (ovnicraft) said : 		#7

Hi i was testing with mysql and was working ok, i pull my branch and the error in the client is again the same and in server tell me:

Exception exceptions must be classes or instances, not NoneType

Following from http://openerp-team.blogspot.com/2009/08/open-erp-server-with-mysql.html.

waiting you reply,

thanks in advance

Cristian

Revision history for this message
Cristian Salamea (ovnicraft) said : 		#8

Fix error in url server