openerp-india team mailing list archive

["Olivier Dony \(OpenERP\)" <899794@xxxxxxxxxxxxxxxxxx>]

On 12/16/2011 02:48 AM, Kenneth Andresen wrote:
> I have found psycopg2 requires not only libpq-dev but gcc as well...
> That is ok in development, but normally NOT acceptable at the time of
> deployment. I believe is a huge mistake to require GCC to be required on
> a web-server. I will likely not be testing this until an acceptable
> workaround exist.

You might be overreacting here ;-)

The error with missing "pg_config" during upgrade/install shows that
there is no precompiled binary available for your platform, so
pip/easy_install have to download the source version and compile it on
the spot. psycopg2 is not a pure Python lib, it contains native C code
that depends on the platform, in order to talk to the postgres native
libs. Hence the compilation step when installing from source.
This is the only reason why postgres' development tools and gcc are
neeeded on the machine. They won't be used after psycopg2 is installed,
you could even remove them.

Now if you don't like that on a production machine, why don't you
install a precompiled binary version of psycopg2 instead? Depending on
your platform, it might be readily available in your distribution
packages. On a recent Ubuntu for example:

 $ sudo apt-cache show python-psycopg2 | grep Version
 Version: 2.4.2-1
 $ # ^^ this means I can install a binary version with apt-get

Another option is to install it with easy_install on a development
machine (with the same architecture as the prod machine) and then
transfer the resulting Python egg (easy_install will build one and
install it on the dev machine) to the prod machine.
You can install an egg directly with:
 $ sudo easy_install <egg_file>

Note that none of the above is OpenERP-specific, it's merely Python
packaging/installation stuff.

Cheers,

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Server.
https://bugs.launchpad.net/bugs/899794

Title:
  [6.1] cannot upload company logo

Status in OpenERP Server:
  Incomplete

Bug description:
  from a virtual ubuntu 10.04 server installing OpenERP from trunk:
  OpenERP-server rev: 3848
  OpenERP-addons rev: 5861
  OpenERP-web rev: 1596
  using pip for installing essentially all software except python-ldap, postgresql. 

  0) Go to http://<virtualserver>:8069
  Create a new database without demo data
  This should automatically log you in as Admin with a screen to install modules

  1) Click "SETTINGS" 
  2) Click "Set Company Header and Footer"
  3) Click folder icon to add new logo
  4) Click "Save"

  Result is:
  OpenERP Server Error

  Client Traceback (most recent call last):
    File "/opt/openerp/openerp-web/addons/web/common/http.py", line 154, in dispatch
      response["result"] = method(controller, self, **self.params)
    File "/opt/openerp/openerp-web/addons/web/controllers/main.py", line 772, in save
      r = m.write([id], data, req.session.eval_context(req.context))
    File "/opt/openerp/openerp-web/addons/web/common/openerplib/main.py", line 429, in proxy
      *args)
    File "/opt/openerp/openerp-web/addons/web/common/openerplib/main.py", line 306, in proxy
      result = self.connector.send(self.service_name, method, *args)
    File "/opt/openerp/openerp-web/addons/web/common/openerplib/main.py", line 276, in send
      raise fault

  
  Server Traceback (most recent call last):
    File "/opt/openerp/openerp-web/addons/web/common/openerplib/main.py", line 257, in send
      result = openerp.netsvc.dispatch_rpc(service_name, method, args)
    File "/opt/openerp/openerp-server/openerp/netsvc.py", line 325, in dispatch_rpc
      result = ExportService.getService(service_name).dispatch(method, params)
    File "/opt/openerp/openerp-server/openerp/service/web_services.py", line 580, in dispatch
      res = fn(db, uid, *params)
    File "/opt/openerp/openerp-server/openerp/osv/osv.py", line 120, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/opt/openerp/openerp-server/openerp/osv/osv.py", line 172, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/opt/openerp/openerp-server/openerp/osv/osv.py", line 163, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/opt/openerp/openerp-server/openerp/addons/base/res/res_company.py", line 240, in write
      return super(res_company, self).write(cr, *args, **argv)
    File "/opt/openerp/openerp-server/openerp/osv/orm.py", line 3854, in write
      'where id IN %s', upd1 + [sub_ids])
    File "/opt/openerp/openerp-server/openerp/sql_db.py", line 153, in wrapper
      return f(self, *args, **kwargs)
    File "/opt/openerp/openerp-server/openerp/sql_db.py", line 215, in execute
      res = self._obj.execute(query, params)
  TypeError: can't escape non-string object

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-server/+bug/899794/+subscriptions