На тестовом стенде перестали нормально добавляться пользователи. Помогите разобраться в чем может быть причина.
Создаю пользователя, заношу логин и имя, жму Применить.
Админка думает дольше обычного. Выдается минусовый UID (что-то типа -1118873992). Поле лиц. счет пустое. При нажатии ОК вылезают окна:
Error add user (DBA): RPC-End-Of-Stream (R-EoS)recieved
и
Error add user: while calling core function
При нажатии Отмена у пользователя в списке пользователей отображается лицевой счет. При повторном открытии окна пользователя все поля пустые (в том числе логин, наименование и лиц.счет).
После рестарта ЮТМа пользователи с отрицательным UID не отображаются в админке.
Вот выдержки из debug.log.
Код: Выделить всё
?Debug : Nov 25 16:50:13 RPCConn[SSL]<init@192.168.100.123>: Call: 0x2005 (rpcf_add_user)
?Debug : Nov 25 16:50:13 RPCConn[SSL]<init@192.168.100.123>: Real Call: 0x2005 (rpcf_add_user)
?Debug : Nov 25 16:50:13 UTM5 DBA: DBAccess instance created
?Debug : Nov 25 16:50:13 DBA:Ctx: Looking for free context
?Debug : Nov 25 16:50:13 DBCtx: <138836992> SQL query: INSERT INTO users(login,password,basic_account,create_date,last_change_date,who_create,who_change,is_juridical,full_name,juridical_address,actual_address,flat_number,entrance,floor,district,building,passport,work_telephone,home_telephone,mobile_telephone,web_page,icq_number,tax_number,kpp_number,email,bank_id,bank_account,comments,house_id,is_send_invoice,advance_payment,personal_manager) VALUES('in1','00c7d3','0','1259149813','1259149813','-1','-1','0','\xd0\xba\xd0\xbe\xd1\x81\xd1\x8f\xd0\xba','','','','','','','','','','','','','','','','','0','','','0','0','1','')
?Debug : Nov 25 16:50:13 DBCtx: <138836992> MySQL query failed:<Access denied; you need the SUPER privilege for this operation> Trying to reconnect: 0
?Debug : Nov 25 16:50:15 DBCtx: <138836992> MySQL query failed:<Access denied; you need the SUPER privilege for this operation> Trying to reconnect: 1
?Debug : Nov 25 16:50:17 DBCtx: <138836992> MySQL query failed:<Access denied; you need the SUPER privilege for this operation> Trying to reconnect: 2
?Debug : Nov 25 16:50:19 DBCtx: <138836992> MySQL query failed:<Access denied; you need the SUPER privilege for this operation> Trying to reconnect: 3
?Debug : Nov 25 16:50:21 DBCtx: <138836992> MySQL query failed:<Access denied; you need the SUPER privilege for this operation> Trying to reconnect: 4
ERROR : Nov 25 16:50:23 DBCtx: <138836992> MySQL query failed:
ERROR : Nov 25 16:50:23 DBASQLError: MySQL query failed:
ERROR : Nov 25 16:50:23 DBCtx: Exception while doing SQL insert/update !
?Debug : Nov 25 16:50:23 DBCtx: <138836992> SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='card_user_prefix'
?Debug : Nov 25 16:50:23 DBCtx: <138686464> SQL SELECT query: SELECT is_for_all, uid, group_id, tariff_id, rule_on, rule_off, rule_block, router_id, and_logic, add_user, edit_user, del_user FROM firewall_rules WHERE is_deleted='0' AND (add_user!=0 OR edit_user!=0 OR del_user!=0)
?Debug : Nov 25 16:50:23 ModFWMan: Ready to execute 0 FW rules for UID -1117821320. Action:1
?Debug : Nov 25 16:50:23 DBCtx: <138836992> SQL query: INSERT INTO user_log(user_id,date,who,what,comment) VALUES('-1117821320', '1259149823', '-1', 'user_add', 'in1')
?Debug : Nov 25 16:50:23 DBA:Ctx: Pushing back free context
-Stats : Nov 25 16:50:23 UTM5 DBA: Stats: Uptime: 00:00:10. Events: 0; Errors: 0
?Debug : Nov 25 16:50:23 RPCConn[SSL]<init@192.168.100.123>: Call 0x2005 (rpcf_add_user) finished...
?Debug : Nov 25 16:50:23 RPCConn[SSL]<init@192.168.100.123>: Stream cleared
?Debug : Nov 25 16:50:24 RPCConn[SSL]<init@192.168.100.123>: Call: 0x2031 (rpcf_add_account)
?Debug : Nov 25 16:50:24 RPCConn[SSL]<init@192.168.100.123>: Real Call: 0x2031 (rpcf_add_account)
?Debug : Nov 25 16:50:24 DBCtx: <138686464> SQL query: INSERT INTO accounts(balance,credit,flags,int_status,block_recalc_abon,block_recalc_prepaid) VALUES('0','0','3','0','0','0')
?Debug : Nov 25 16:50:24 DBCtx: <138686464> SQL query: INSERT into users_accounts(uid,account_id) VALUES(-1117821320,197)
?Debug : Nov 25 16:50:24 DBCtx: <138686464> MySQL query failed:<Access denied; you need the SUPER privilege for this operation> Trying to reconnect: 0
?Debug : Nov 25 16:50:26 DBCtx: <138686464> MySQL query failed:<Access denied; you need the SUPER privilege for this operation> Trying to reconnect: 1
?Debug : Nov 25 16:50:28 DBCtx: <138686464> MySQL query failed:<Access denied; you need the SUPER privilege for this operation> Trying to reconnect: 2
?Debug : Nov 25 16:50:30 DBCtx: <138686464> MySQL query failed:<Access denied; you need the SUPER privilege for this operation> Trying to reconnect: 3
?Debug : Nov 25 16:50:32 DBCtx: <138686464> MySQL query failed:<Access denied; you need the SUPER privilege for this operation> Trying to reconnect: 4
ERROR : Nov 25 16:50:34 DBCtx: <138686464> MySQL query failed:
ERROR : Nov 25 16:50:34 DBASQLError: MySQL query failed:
ERROR : Nov 25 16:50:34 DBCtx: Exception while doing SQL insert/update !
?Debug : Nov 25 16:50:34 DBCtx: <138686464> SQL query: UPDATE users SET basic_account=197 WHERE id=-1117821320
?Debug : Nov 25 16:50:34 RPCConn[SSL]<init@192.168.100.123>: Call 0x2031 (rpcf_add_account) finished...
?Debug : Nov 25 16:50:34 RPCConn[SSL]<init@192.168.100.123>: Stream cleared Info : Nov 25 16:50:34 RPCServer@0.0.0.0: Client connecting: 192.168.100.123:1402
Info : Nov 25 16:50:34 RPCConn: Connection from: 192.168.100.123:1402
Info : Nov 25 16:50:34 RPCConn: Card user <init@192.168.100.123> is connecting
?Debug : Nov 25 16:50:34 DBA Groups: Group: -1 from 1
Код: Выделить всё
+-------------------------------------------------------------------------------------------------------------+
| Grants for UTM5@localhost |
+-------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'UTM5'@'localhost' IDENTIFIED BY PASSWORD '*****' |
| GRANT ALL PRIVILEGES ON `UTM5`.* TO 'UTM5'@'localhost' |
+-------------------------------------------------------------------------------------------------------------+