All pastes #748179 Raw Edit

Anonymous

public text v1 · immutable
#748179 ·published 2007-10-24 17:20 UTC
rendered paste body
    origin.ORIGIN.c.deleted == False))
  File "build/bdist.linux-i686/egg/sqlalchemy/util.py", line 595, in func_with_warning
  File "build/bdist.linux-i686/egg/sqlalchemy/orm/query.py", line 1031, in select
  File "build/bdist.linux-i686/egg/sqlalchemy/orm/query.py", line 571, in all
  File "build/bdist.linux-i686/egg/sqlalchemy/orm/query.py", line 619, in __iter__
  File "build/bdist.linux-i686/egg/sqlalchemy/orm/query.py", line 622, in _execute_and_instances
  File "build/bdist.linux-i686/egg/sqlalchemy/orm/session.py", line 527, in execute
  File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 779, in execute
  File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 829, in _execute_clauseelement
  File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 841, in _execute_compiled
  File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 852, in __execute_raw
  File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 869, in _cursor_execute
OperationalError: (OperationalError) (1054, "Unknown column 'ORIGIN.prefix' in 'field list'") u'SELECT `ORIGIN`.id AS `ORIGIN_id`, `ORIGIN`.ip AS `ORIGIN_ip`, `ORIGIN`.billing AS `ORIGIN_billing`, `ORIGIN`.description AS `ORIGIN_description`, `ORIGIN`.prefix AS `ORIGIN_prefix`, `ORIGIN`.money AS `ORIGIN_money`, `ORIGIN`.max_calls AS `ORIGIN_max_calls`, `ORIGIN`.available_calls AS `ORIGIN_available_calls`, `ORIGIN`.enabled AS `ORIGIN_enabled`, `ORIGIN`.deleted AS `ORIGIN_deleted` \nFROM `ORIGIN`, `UserOrigin`, `USER` \nWHERE `UserOrigin`.id_user = `USER`.id AND `UserOrigin`.id_node = `ORIGIN`.id AND `USER`.enabled = %s AND `USER`.deleted = %s AND `ORIGIN`.ip = %s AND (`ORIGIN`.billing = %s AND `ORIGIN`.money > %s OR `ORIGIN`.billing = %s) AND `ORIGIN`.available_calls > %s AND `ORIGIN`.enabled = %s AND `ORIGIN`.deleted = %s ORDER BY `ORIGIN`.id' [1, 0, '200.68.67.83', 'pre-paid', 0, 'post-paid', 0, 1, 0]
*** (('User-Password', 'O'), ('NAS-IP-Address', '200.68.67.84'), ('User-Name', 'O'), ('h323-gw-id', 'gk'), ('h323-call-type', 'VoIP'), ('Framed-IP-Address', '200.68.67.83'), ('Called-Station-Id', '0055493516688187'), ('Service-Type', 'Login-User'), ('NAS-Identifier', 'gk'), ('Client-IP-Address', '127.0.0.1'), ('h323-conf-id', '2128140 CBC2F7CC A770004 F002F20'), ('h323-call-origin', 'originate'), ('NAS-Port-Type', 'Virtual'), ('Calling-Station-Id', 'O')) ***
*** 200.68.67.83 ***
200.68.67.83
<class 'db.user.USER'>.moneyOk
Traceback (most recent call last):
  File "/usr/local/share/bs/controller.py", line 49, in authorize
    origin = self._get_origin(ipAddress, now)
  File "/usr/local/share/bs/controller.py", line 293, in _get_origin
    o = self._find_origin(ipAddress, now)
  File "/usr/local/share/bs/controller.py", line 314, in _find_origin
    origin.ORIGIN.c.deleted == False))
  File "build/bdist.linux-i686/egg/sqlalchemy/util.py", line 595, in func_with_warning
  File "build/bdist.linux-i686/egg/sqlalchemy/orm/query.py", line 1031, in select
  File "build/bdist.linux-i686/egg/sqlalchemy/orm/query.py", line 571, in all
  File "build/bdist.linux-i686/egg/sqlalchemy/orm/query.py", line 619, in __iter__
  File "build/bdist.linux-i686/egg/sqlalchemy/orm/query.py", line 622, in _execute_and_instances
  File "build/bdist.linux-i686/egg/sqlalchemy/orm/session.py", line 527, in execute
  File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 779, in execute
  File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 829, in _execute_clauseelement
  File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 841, in _execute_compiled
  File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 852, in __execute_raw
  File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 869, in _cursor_execute
OperationalError: (OperationalError) (1054, "Unknown column 'ORIGIN.prefix' in 'field list'") u'SELECT `ORIGIN`.id AS `ORIGIN_id`, `ORIGIN`.ip AS `ORIGIN_ip`, `ORIGIN`.billing AS `ORIGIN_billing`, `ORIGIN`.description AS `ORIGIN_description`, `ORIGIN`.prefix AS `ORIGIN_prefix`, `ORIGIN`.money AS `ORIGIN_money`, `ORIGIN`.max_calls AS `ORIGIN_max_calls`, `ORIGIN`.available_calls AS `ORIGIN_available_calls`, `ORIGIN`.enabled AS `ORIGIN_enabled`, `ORIGIN`.deleted AS `ORIGIN_deleted` \nFROM `ORIGIN`, `UserOrigin`, `USER` \nWHERE `UserOrigin`.id_user = `USER`.id AND `UserOrigin`.id_node = `ORIGIN`.id AND `USER`.enabled = %s AND `USER`.deleted = %s AND `ORIGIN`.ip = %s AND (`ORIGIN`.billing = %s AND `ORIGIN`.money > %s OR `ORIGIN`.billing = %s) AND `ORIGIN`.available_calls > %s AND `ORIGIN`.enabled = %s AND `ORIGIN`.deleted = %s ORDER BY `ORIGIN`.id' [1, 0, '200.68.67.83', 'pre-paid', 0, 'post-paid', 0, 1, 0]
*** (('User-Password', 'O'), ('NAS-IP-Address', '200.68.67.84'), ('User-Name', 'O'), ('h323-gw-id', 'gk'), ('h323-call-type', 'VoIP'), ('Framed-IP-Address', '200.68.67.83'), ('Called-Station-Id', '0055493516688187'), ('Service-Type', 'Login-User'), ('NAS-Identifier', 'gk'), ('Client-IP-Address', '127.0.0.1'), ('h323-conf-id', '2128140 CBC2F7CC A770004 F002F20'), ('h323-call-origin', 'originate'), ('NAS-Port-Type', 'Virtual'), ('Calling-Station-Id', 'O')) ***
*** 200.68.67.83 ***
200.68.67.83
<class 'db.user.USER'>.moneyOk
Traceback (most recent call last):
  File "/usr/local/share/bs/controller.py", line 49, in authorize
    origin = self._get_origin(ipAddress, now)
  File "/usr/local/share/bs/controller.py", line 293, in _get_origin
    o = self._find_origin(ipAddress, now)
  File "/usr/local/share/bs/controller.py", line 314, in _find_origin
    origin.ORIGIN.c.deleted == False))
  File "build/bdist.linux-i686/egg/sqlalchemy/util.py", line 595, in func_with_warning
  File "build/bdist.linux-i686/egg/sqlalchemy/orm/query.py", line 1031, in select
  File "build/bdist.linux-i686/egg/sqlalchemy/orm/query.py", line 571, in all
  File "build/bdist.linux-i686/egg/sqlalchemy/orm/query.py", line 619, in __iter__
  File "build/bdist.linux-i686/egg/sqlalchemy/orm/query.py", line 622, in _execute_and_instances
  File "build/bdist.linux-i686/egg/sqlalchemy/orm/session.py", line 527, in execute
  File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 779, in execute
  File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 829, in _execute_clauseelement
  File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 841, in _execute_compiled
  File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 852, in __execute_raw
  File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 869, in _cursor_execute
OperationalError: (OperationalError) (1054, "Unknown column 'ORIGIN.prefix' in 'field list'") u'SELECT `ORIGIN`.id AS `ORIGIN_id`, `ORIGIN`.ip AS `ORIGIN_ip`, `ORIGIN`.billing AS `ORIGIN_billing`, `ORIGIN`.description AS `ORIGIN_description`, `ORIGIN`.prefix AS `ORIGIN_prefix`, `ORIGIN`.money AS `ORIGIN_money`, `ORIGIN`.max_calls AS `ORIGIN_max_calls`, `ORIGIN`.available_calls AS `ORIGIN_available_calls`, `ORIGIN`.enabled AS `ORIGIN_enabled`, `ORIGIN`.deleted AS `ORIGIN_deleted` \nFROM `ORIGIN`, `UserOrigin`, `USER` \nWHERE `UserOrigin`.id_user = `USER`.id AND `UserOrigin`.id_node = `ORIGIN`.id AND `USER`.enabled = %s AND `USER`.deleted = %s AND `ORIGIN`.ip = %s AND (`ORIGIN`.billing = %s AND `ORIGIN`.money > %s OR `ORIGIN`.billing = %s) AND `ORIGIN`.available_calls > %s AND `ORIGIN`.enabled = %s AND `ORIGIN`.deleted = %s ORDER BY `ORIGIN`.id' [1, 0, '200.68.67.83', 'pre-paid', 0, 'post-paid', 0, 1, 0]
*** (('User-Password', 'O'), ('NAS-IP-Address', '200.68.67.84'), ('User-Name', 'O'), ('h323-gw-id', 'gk'), ('h323-call-type', 'VoIP'), ('Framed-IP-Address', '200.68.67.83'), ('Called-Station-Id', '0055493516688187'), ('Service-Type', 'Login-User'), ('NAS-Identifier', 'gk'), ('Client-IP-Address', '127.0.0.1'), ('h323-conf-id', '2128140 CBC2F7CC A770004 F002F20'), ('h323-call-origin', 'originate'), ('NAS-Port-Type', 'Virtual'), ('Calling-Station-Id', 'O')) ***
*** 200.68.67.83 ***
200.68.67.83
<class 'db.user.USER'>.moneyOk
Traceback (most recent call last):
  File "/usr/local/share/bs/controller.py", line 49, in authorize
    origin = self._get_origin(ipAddress, now)
  File "/usr/local/share/bs/controller.py", line 293, in _get_origin
    o = self._find_origin(ipAddress, now)
  File "/usr/local/share/bs/controller.py", line 314, in _find_origin
    origin.ORIGIN.c.deleted == False))
  File "build/bdist.linux-i686/egg/sqlalchemy/util.py", line 595, in func_with_warning
  File "build/bdist.linux-i686/egg/sqlalchemy/orm/query.py", line 1031, in select
  File "build/bdist.linux-i686/egg/sqlalchemy/orm/query.py", line 571, in all
  File "build/bdist.linux-i686/egg/sqlalchemy/orm/query.py", line 619, in __iter__
  File "build/bdist.linux-i686/egg/sqlalchemy/orm/query.py", line 622, in _execute_and_instances
  File "build/bdist.linux-i686/egg/sqlalchemy/orm/session.py", line 527, in execute
  File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 779, in execute
  File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 829, in _execute_clauseelement
  File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 841, in _execute_compiled
  File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 852, in __execute_raw
  File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 869, in _cursor_execute
OperationalError: (OperationalError) (1054, "Unknown column 'ORIGIN.prefix' in 'field list'") u'SELECT `ORIGIN`.id AS `ORIGIN_id`, `ORIGIN`.ip AS `ORIGIN_ip`, `ORIGIN`.billing AS `ORIGIN_billing`, `ORIGIN`.description AS `ORIGIN_description`, `ORIGIN`.prefix AS `ORIGIN_prefix`, `ORIGIN`.money AS `ORIGIN_money`, `ORIGIN`.max_calls AS `ORIGIN_max_calls`, `ORIGIN`.available_calls AS `ORIGIN_available_calls`, `ORIGIN`.enabled AS `ORIGIN_enabled`, `ORIGIN`.deleted AS `ORIGIN_deleted` \nFROM `ORIGIN`, `UserOrigin`, `USER` \nWHERE `UserOrigin`.id_user = `USER`.id AND `UserOrigin`.id_node = `ORIGIN`.id AND `USER`.enabled = %s AND `USER`.deleted = %s AND `ORIGIN`.ip = %s AND (`ORIGIN`.billing = %s AND `ORIGIN`.money > %s OR `ORIGIN`.billing = %s) AND `ORIGIN`.available_calls > %s AND `ORIGIN`.enabled = %s AND `ORIGIN`.deleted = %s ORDER BY `ORIGIN`.id' [1, 0, '200.68.67.83', 'pre-paid', 0, 'post-paid', 0, 1, 0]
*** (('User-Password', 'O'), ('NAS-IP-Address', '200.68.67.84'), ('User-Name', 'O'), ('h323-gw-id', 'gk'), ('h323-call-type', 'VoIP'), ('Framed-IP-Address', '200.68.67.83'), ('Called-Station-Id', '0055493516688187'), ('Service-Type', 'Login-User'), ('NAS-Identifier', 'gk'), ('Client-IP-Address', '127.0.0.1'), ('h323-conf-id', '2128140 CBC2F7CC A770004 F002F20'), ('h323-call-origin', 'originate'), ('NAS-Port-Type', 'Virtual'), ('Calling-Station-Id', 'O')) ***
*** 200.68.67.83 ***
200.68.67.83
<class 'db.user.USER'>.moneyOk
Traceback (most recent call last):
  File "/usr/local/share/bs/controller.py", line 49, in authorize
    origin = self._get_origin(ipAddress, now)
  File "/usr/local/share/bs/controller.py", line 293, in _get_origin
    o = self._find_origin(ipAddress, now)
  File "/usr/local/share/bs/controller.py", line 314, in _find_origin
    origin.ORIGIN.c.deleted == False))
  File "build/bdist.linux-i686/egg/sqlalchemy/util.py", line 595, in func_with_warning
  File "build/bdist.linux-i686/egg/sqlalchemy/orm/query.py", line 1031, in select
  File "build/bdist.linux-i686/egg/sqlalchemy/orm/query.py", line 571, in all
  File "build/bdist.linux-i686/egg/sqlalchemy/orm/query.py", line 619, in __iter__
  File "build/bdist.linux-i686/egg/sqlalchemy/orm/query.py", line 622, in _execute_and_instances
  File "build/bdist.linux-i686/egg/sqlalchemy/orm/session.py", line 527, in execute
  File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 779, in execute
  File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 829, in _execute_clauseelement
  File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 841, in _execute_compiled
  File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 852, in __execute_raw
  File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 869, in _cursor_execute
OperationalError: (OperationalError) (1054, "Unknown column 'ORIGIN.prefix' in 'field list'") u'SELECT `ORIGIN`.id AS `ORIGIN_id`, `ORIGIN`.ip AS `ORIGIN_ip`, `ORIGIN`.billing AS `ORIGIN_billing`, `ORIGIN`.description AS `ORIGIN_description`, `ORIGIN`.prefix AS `ORIGIN_prefix`, `ORIGIN`.money AS `ORIGIN_money`, `ORIGIN`.max_calls AS `ORIGIN_max_calls`, `ORIGIN`.available_calls AS `ORIGIN_available_calls`, `ORIGIN`.enabled AS `ORIGIN_enabled`, `ORIGIN`.deleted AS `ORIGIN_deleted` \nFROM `ORIGIN`, `UserOrigin`, `USER` \nWHERE `UserOrigin`.id_user = `USER`.id AND `UserOrigin`.id_node = `ORIGIN`.id AND `USER`.enabled = %s AND `USER`.deleted = %s AND `ORIGIN`.ip = %s AND (`ORIGIN`.billing = %s AND `ORIGIN`.money > %s OR `ORIGIN`.billing = %s) AND `ORIGIN`.available_calls > %s AND `ORIGIN`.enabled = %s AND `ORIGIN`.deleted = %s ORDER BY `ORIGIN`.id' [1, 0, '200.68.67.83', 'pre-paid', 0, 'post-paid', 0, 1, 0]
*** (('User-Password', 'O'), ('NAS-IP-Address', '200.68.67.84'), ('User-Name', 'O'), ('h323-gw-id', 'gk'), ('h323-call-type', 'VoIP'), ('Framed-IP-Address', '200.68.67.83'), ('Called-Station-Id', '0055493516688187'), ('Service-Type', 'Login-User'), ('NAS-Identifier', 'gk'), ('Client-IP-Address', '127.0.0.1'), ('h323-conf-id', '2128140 CBC2F7CC A770004 F002F20'), ('h323-call-origin', 'originate'), ('NAS-Port-Type', 'Virtual'), ('Calling-Station-Id', 'O')) ***
*** 200.68.67.83 ***
200.68.67.83
Killed
leviatan:~#