cant connect to server

[c001os]

I cannt connect to the trunk server from trunk client (from bazaar) i get the following error:

[2010-03-06 09:37:37,746] INFO:server:Starting 2 services
[2010-03-06 09:37:37,753] INFO:web-services:the server is running, waiting for connections...
[2010-03-06 09:41:52,054] ERROR:http:code 400, message Bad request syntax (' 340(lp1')
[2010-03-06 09:41:54,618] ERROR:http:code 400, message Bad request syntax ('\x80d\x01\x03\x01\x00K\x00\x00\x00\x10\x00\x009\x00\x008\x00\x005\x00\x00\x16\x00\x00\x13\x00\x00')
[2010-03-06 09:42:00,026] ERROR:http:code 400, message Bad request syntax ('\x80d\x01\x03\x01\x00K\x00\x00\x00\x10\x00\x009\x00\x008\x00\x005\x00\x00\x16\x00\x00\x13\x00\x00')
[2010-03-06 09:50:44,870] ERROR:http:code 400, message Bad request syntax ('\x80d\x01\x03\x01\x00K\x00\x00\x00\x10\x00\x009\x00\x008\x00\x005\x00\x00\x16\x00\x00\x13\x00\x00')
[2010-03-06 09:50:52,655] ERROR:http:code 400, message Bad request syntax ('\x80d\x01\x03\x01\x00K\x00\x00\x00\x10\x00\x009\x00\x008\x00\x005\x00\x00\x16\x00\x00\x13\x00\x00')
[2010-03-06 09:51:44,021] ERROR:http:code 400, message Bad request syntax ('\x80d\x01\x03\x01\x00K\x00\x00\x00\x10\x00\x009\x00\x008\x00\x005\x00\x00\x16\x00\x00\x13\x00\x00')
[2010-03-06 09:52:29,272] ERROR:http:code 400, message Bad request syntax ('\x80d\x01\x03\x01\x00K\x00\x00\x00\x10\x00\x009\x00\x008\x00\x005\x00\x00\x16\x00\x00\x13\x00\x00')
[2010-03-06 09:52:53,601] ERROR:http:code 400, message Bad request syntax (' 340(lp1')

[Willem Bouma (wbouma)]

Could you check what port the server is using and what port the database is running on.

We also had the problem that the pgsql service was suddenly running on port 5433 instead of the default 5432. This was probably caused by an update of pgsql.

[Jay Vora (Serpent Consulting Services) (jayvora)]

I guess, Its the problem with --secure option? Please recheck.

[c001os (c001os)]

Thx the help. The server port is 5432. I dont run with --secure option. I tried but no luck. I cant connect with web.-client too. (Could not connect to server! message)

server-log
openerp-server start
[2010-03-18 18:17:29,719] INFO:server:version - 5.2dev
[2010-03-18 18:17:29,719] INFO:server:addons_path - /usr/local/lib/python2.6/dist-packages/openerp-server/addons
[2010-03-18 18:17:29,719] INFO:server:database hostname - localhost
[2010-03-18 18:17:29,719] INFO:server:database port - 5432
[2010-03-18 18:17:29,720] INFO:server:database user - c001os
[2010-03-18 18:17:29,720] INFO:objects:initialising distributed objects services
[2010-03-18 18:17:29,897] INFO:web-services:starting HTTPS service at 0.0.0.0 port 8069
[2010-03-18 18:17:29,898] INFO:web-services:Registered XML-RPC over HTTP
[2010-03-18 18:17:29,898] INFO:web-services:starting NET-RPC service at 0.0.0.0 port 8070
[2010-03-18 18:17:29,898] INFO:server:Starting 2 services
[2010-03-18 18:17:29,899] INFO:web-services:the server is running, waiting for connections...

------------------
web-client log:

[18/Mar/2010:18:14:30] ENGINE Bus STARTING
[18/Mar/2010:18:14:30] ENGINE Started monitor thread '_TimeoutMonitor'.
[18/Mar/2010:18:14:30] ENGINE Started monitor thread 'Autoreloader'.
[18/Mar/2010:18:14:30] ENGINE Serving on 0.0.0.0:8080
[18/Mar/2010:18:14:30] ENGINE Bus STARTED
[18/Mar/2010:18:14:53] ENGINE Started monitor thread 'Monitor'.
[18/Mar/2010:18:14:53] INFO Loading module 'openerp'
[18/Mar/2010:18:14:54] INFO Loading module 'view_calendar'
[18/Mar/2010:18:14:55] INFO Loading module 'view_graph'
192.168.1.101 - - [18/Mar/2010:18:14:55] "GET / HTTP/1.1" 200 8406 "http://192.168.1.104:8080/database/do_create" "Mozilla/5.0 (X11; U; Linux i686; en-US) AppleWebKit/532.9 (KHTML, like Gecko) Chrome/5.0.307.11 Safari/532.9"

[j_ K (jkamau30034)]

I have a new install running on Fedora 11 _x84-64 while running python2.6. I can make this error (code 400, message Bad request syntax (' 340(lp1')) go away by modifying tinySocket.py from:

import cPickle

statement to:

try:
    import cPickle as pickle
except ImportError:
    import pickle # fall back on Python version

I suspect cPickle.so has malformed data pickled from ["db","list"].

At least this seems to clear that problem, but still no dice connecting to server.

[j_ K (jkamau30034)]

Retraction:(
Turned out cPickle is not the culprit. The error is comming from baseHTTPServer.py. This module should not be handling the connection because the protocol is not HTTP at least for my case. There is a misdirection somewhere. Stay tuned for fix.

[Jay Vora (Serpent Consulting Services) (jayvora)]

It doesn't appear at our end.
Would you please recheck and let us know more about it?
Thanks.

[allan_registos (allan-registos)]

Hi guys, fast forward 2012, is this but still alive? I have the same error, but I solve this bug with additional parameters to openerp-server:
openerp-server --db_host=localhost --db_user=myname --db_password=mypassword --db_port=5432 --database=openerp

Then openerp initialize the database openerp and now I can finally connect.

The problem left is what is the default username and password.

[allan_registos (allan-registos)]

The password admin will not work. I am on a 11.10's openerp default install.

[allan_registos (allan-registos)]

It seems this is still a but in version 5.x, the default version in Ubuntu 11.10. I reset the default super admin password with 'admin' and then recreate another database with username 'admin' with password 'admin' and have followed the wizard configuration.

I have another error to note after following the configuration wizard:

Environment Information :
System : Linux-3.0.0-15-generic-x86_64-with-Ubuntu-11.10-oneiric
OS Name : posix
Distributor ID: Ubuntu
Description: Ubuntu 11.10
Release: 11.10
Codename: oneiric
Operating System Release : 3.0.0-15-generic
Operating System Version : #26-Ubuntu SMP Fri Jan 20 17:23:00 UTC 2012
Operating System Architecture : 64bit
Operating System Locale : en_US.UTF-8
Python Version : 2.7.2+
OpenERP-Client Version : 5.0.15
Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last):
  File "/usr/share/pyshared/openerp-server/netsvc.py", line 299, in dispatch
    result = LocalService(service_name)(method, *params)
  File "/usr/share/pyshared/openerp-server/netsvc.py", line 77, in __call__
    return getattr(self, method)(*params)
  File "/usr/share/pyshared/openerp-server/service/web_services.py", line 582, in execute
    res = service.execute(db, uid, object, method, *args)
  File "/usr/share/pyshared/openerp-server/osv/osv.py", line 58, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/usr/share/pyshared/openerp-server/osv/osv.py", line 119, in execute
    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/usr/share/pyshared/openerp-server/osv/osv.py", line 111, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/usr/share/pyshared/openerp-server/addons/profile_service/profile_service.py", line 67, in action_install
    db, pool = pooler.restart_pool(cr.dbname, update_module=True)
  File "/usr/share/pyshared/openerp-server/pooler.py", line 61, in restart_pool
    return get_db_and_pool(db_name, force_demo, status, update_module=update_module)
  File "/usr/share/pyshared/openerp-server/pooler.py", line 40, in get_db_and_pool
    addons.load_modules(db, force_demo, status, update_module)
  File "/usr/share/pyshared/openerp-server/addons/__init__.py", line 736, in load_modules
    r = load_module_graph(cr, graph, status, report=report)
  File "/usr/share/pyshared/openerp-server/addons/__init__.py", line 618, in load_module_graph
    tools.convert_csv_import(cr, m, os.path.basename(filename), fp.read(), idref, mode=mode)
  File "/usr/share/pyshared/openerp-server/tools/convert.py", line 852, in convert_csv_import
    pool.get(model).import_data(cr, uid, fields, datas,mode, module,noupdate,filename=fname_partial)
  File "/usr/share/pyshared/openerp-server/osv/orm.py", line 861, in import_data
    process_liness(self, datas, [], current_module, self._name, fields_def)
  File "/usr/share/pyshared/openerp-server/osv/orm.py", line 690, in process_liness
    raise ValueError('No references to %s.%s' % (module, xml_id))
ValueError: No references to purchase.group_purchase_user

[allan_registos (allan-registos)]

Sorry for the successive posts, I just want to clarify that I can now finally connect.
Regards,
Allan