(Migrated) Failing to create http channel

(This message has been automatically imported from the retired mailing list)

Hi all. I get an error message I do not understand. Maybe someone could
help me out.
I cloned the git repo some days ago and set up a new quick start cluster.
It works fine, except I cannot register any http channels on it.

user@zatoTest:~/zato$ zato --version
Zato 2.0.0pre0.rev-3a804fec

Failing to register my own service(I was hoping to experiment with sql
server via pyodbc), I decided to try a simple SIO example from the
documentation.
I hot-deploy the sample SIO service from here:
https://zato.io/docs/progguide/sio.html

sio_example.py:

from zato.server.service import Service
class MyService(Service):
class SimpleIO:
input_required = (‘name’, ‘type’)
output_required = (‘is_allowed’,)

def get_data(self):
    if self.request.input.name == 'wendy' and

self.request.input.type == ‘AXC’:
return True

def handle(self):
    self.response.payload.is_allowed = self.get_data()

When I try to create the http channel(following the example on same web
page). I do notice that the register http channel form has changed since
1.1 and differs from the docs. I get this error when clicking OK after
filling in what I believe is the right details:

Could not create the object, e:
[Traceback(most recent call last) : File
"/home/user/zato/code/zato-web-admin/src/zato/admin/web/views/http_soap.py",
line 189, in create response =
req.zato.client.invoke(‘zato.http-soap.create’,
get_edit_create_message(req.POST))File
"/home/user/zato/code/zato-web-admin/src/zato/admin/middleware.py", line
70, in invoke raise Exception(response.inner.text)Exception : {
“zato_env” : {
“details” : “Traceback (most recent call last):\n File
”/home/user/zato/code/zato-server/src/zato/server/connection/http_soap/channel.py",
line 183, in dispatch\n payload, worker_store, self.simple_io_config,
post_data)\n File
"/home/user/zato/code/zato-server/src/zato/server/connection/http_soap/channel.py",
line 323, in handle\n params_priority=channel_item.params_pri)\n File
"/home/user/zato/code/zato-server/src/zato/server/service/init.py",
line 326, in update_handle\n service.handle()\n File
"/home/user/zato/code/zato-server/src/zato/server/service/internal/service.py",
line 271, in handle\n response = func(id
, payload, channel, data_format,
transport, serialize=True)\n File
"/home/user/zato/code/zato-server/src/zato/server/service/init.py",
line 370, in invoke\n return
self.invoke_by_impl_name(self.server.service_store.name_to_impl_name[name],
*args, **kwargs)\n File
"/home/user/zato/code/zato-server/src/zato/server/service/init.py",
line 357, in invoke_by_impl_name\n **kwargs)\n File
"/home/user/zato/code/zato-server/src/zato/server/service/init.py",
line 326, in update_handle\n service.handle()\n File
"/home/user/zato/code/zato-server/src/zato/server/service/internal/http_soap.py",
line 185, in handle\n session.commit()\n File
"/home/user/zato/code/eggs/SQLAlchemy-0.9.4-py2.7-linux-x86_64.egg/sqlalchemy/orm/session.py",
line 765, in commit\n self.transaction.commit()\n File
"/home/user/zato/code/eggs/SQLAlchemy-0.9.4-py2.7-linux-x86_64.egg/sqlalchemy/orm/session.py",
line 370, in commit\n self._prepare_impl()\n File
"/home/user/zato/code/eggs/SQLAlchemy-0.9.4-py2.7-linux-x86_64.egg/sqlalchemy/orm/session.py",
line 350, in _prepare_impl\n self.session.flush()\n File
"/home/user/zato/code/eggs/SQLAlchemy-0.9.4-py2.7-linux-x86_64.egg/sqlalchemy/orm/session.py",
line 1903, in flush\n self._flush(objects)\n File
"/home/user/zato/code/eggs/SQLAlchemy-0.9.4-py2.7-linux-x86_64.egg/sqlalchemy/orm/session.py",
line 2021, in _flush\n transaction.rollback(_capture_exception=True)\n File
"/home/user/zato/code/eggs/SQLAlchemy-0.9.4-py2.7-linux-x86_64.egg/sqlalchemy/util/langhelpers.py",
line 57, in exit\n compat.reraise(exc_type, exc_value, exc_tb)\n File
"/home/user/zato/code/eggs/SQLAlchemy-0.9.4-py2.7-linux-x86_64.egg/sqlalchemy/orm/session.py",
line 1985, in _flush\n flush_context.execute()\n File
"/home/user/zato/code/eggs/SQLAlchemy-0.9.4-py2.7-linux-x86_64.egg/sqlalchemy/orm/unitofwork.py",
line 370, in execute\n rec.execute(self)\n File
"/home/user/zato/code/eggs/SQLAlchemy-0.9.4-py2.7-linux-x86_64.egg/sqlalchemy/orm/unitofwork.py",
line 523, in execute\n uow\n File
"/home/user/zato/code/eggs/SQLAlchemy-0.9.4-py2.7-linux-x86_64.egg/sqlalchemy/orm/persistence.py",
line 64, in save_obj\n mapper, table, insert)\n File
"/home/user/zato/code/eggs/SQLAlchemy-0.9.4-py2.7-linux-x86_64.egg/sqlalchemy/orm/persistence.py",
line 594, in _emit_insert_statements\n execute(statement, params)\n File
"/home/user/zato/code/eggs/SQLAlchemy-0.9.4-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py",
line 720, in execute\n return meth(self, multiparams, params)\n File
"/home/user/zato/code/eggs/SQLAlchemy-0.9.4-py2.7-linux-x86_64.egg/sqlalchemy/sql/elements.py",
line 317, in _execute_on_connection\n return
connection._execute_clauseelement(self, multiparams, params)\n File
"/home/user/zato/code/eggs/SQLAlchemy-0.9.4-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py",
line 817, in _execute_clauseelement\n compiled_sql, distilled_params\n File
"/home/user/zato/code/eggs/SQLAlchemy-0.9.4-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py",
line 947, in _execute_context\n context)\n File
"/home/user/zato/code/eggs/SQLAlchemy-0.9.4-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py",
line 1108, in _handle_dbapi_exception\n exc_info\n File
"/home/user/zato/code/eggs/SQLAlchemy-0.9.4-py2.7-linux-x86_64.egg/sqlalchemy/util/compat.py",
line 185, in raise_from_cause\n reraise(type(exception), exception,
tb=exc_tb)\n File
"/home/user/zato/code/eggs/SQLAlchemy-0.9.4-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py",
line 940, in _execute_context\n context)\n File
"/home/user/zato/code/eggs/SQLAlchemy-0.9.4-py2.7-linux-x86_64.egg/sqlalchemy/engine/default.py",
line 435, in do_execute\n cursor.execute(statement, parameters)\n File
"/home/user/zato/code/eggs/pg8000-1.9.10-py2.7.egg/pg8000/core.py",
line 531, in execute\n self._c.execute(self, operation, args)\n File
"/home/user/zato/code/eggs/pg8000-1.9.10-py2.7.egg/pg8000/core.py",
line 1554, in execute\n self.handle_messages(cursor)\n File
"/home/user/zato/code/eggs/pg8000-1.9.10-py2.7.egg/pg8000/core.py",
line 1631, in handle_messages\n raise error\nProgrammingError:
(ProgrammingError) (‘ERROR’, ‘22P02’, ‘invalid input syntax for integer:
“ZATO_NONE”’) u"INSERT INTO http_soap (id, name, is_active, is_internal,
connection, transport, host, url_path, method, soap_action, soap_version,
data_format, ping_method, pool_size, merge_url_params_req, url_params_pri,
params_pri, audit_enabled, audit_back_log, audit_max_payload,
audit_repl_patt_type, serialization_type, timeout, sec_tls_ca_cert_id,
has_rbac, service_id, cluster_id, security_id) VALUES
(nextval(‘http_soap_seq’), %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s,
%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s) RETURNING
http_soap.id" (u’my-service.json’, True, False, u’channel’, u’plain_http’,
None, u’/json/sio-example.my-service’, u’’, u’’, None, u’json’, u’HEAD’,
20, True, u’qs-over-path’, u’channel-params-over-msg’, False, 1440, 0,
u’json-pointer’, u’string’, 10, u’ZATO_NONE’, False, 1577, 1, None)\n",
“result” : “ZATO_ERROR”,
“cid” : “K05FHDRM94Q7S2088TG6W9FE3BKK”
}
}
]

On 16/10/14 19:26, Baad Sequel wrote:

user@zatoTest:~/zato$ zato --version
Zato 2.0.0pre0.rev-3a804fec

When I try to create the http channel(following the example on same web
page). I do notice that the register http channel form has changed since
1.1 and differs from the docs. I get this error when clicking OK after
filling in what I believe is the right details:

Hi Baad,

you’re on a recent version so can you please do the following?

  • Open /path/to/server/logs/admin.log
  • Find the CID K05FHDRM94Q7S2088TG6W9FE3BKK you received in response
  • Send the contents of admin.log related to that call from web-admin?
    Both request and response.

All the calls to admin services are now stored in admin.log so it’s easy
to find them.

On 16/10/14 19:26, Baad Sequel wrote:

user@zatoTest:~/zato$ zato --version
Zato 2.0.0pre0.rev-3a804fec

When I try to create the http channel(following the example on same web
page). I do notice that the register http channel form has changed since
1.1 and differs from the docs. I get this error when clicking OK after
filling in what I believe is the right details:

Hi Baad,

you’re on a recent version so can you please do the following?

  • Open /path/to/server/logs/admin.log
  • Find the CID K05FHDRM94Q7S2088TG6W9FE3BKK you received in response
  • Send the contents of admin.log related to that call from web-admin?
    Both request and response.

All the calls to admin services are now stored in admin.log so it’s easy
to find them.