Wrong data are returned when querying mon$attachments through ES/EDS:
mon$remote_os_user is non-ascii (and its value is equal to the word: "SYSTEM");
mon$remote_address is broken ("::1")
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Key: CORE-5071
URL: http://tracker.firebirdsql.org/browse/CORE-5071
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 RC1
Environment: Windows 8.1, x64
WI-V3.0.0.32266 64 bit, any arch (CS, SC, SS).
Reporter: Pavel Zotov
Attachments: wrong-mon-data.png
shell echo Check OS environment variable 'username': %username%;
create or alter user tmp$c3323 password '456';
commit;
create or alter view v_mon as
select
mon$attachment_id att,
mon$user who,
mon$remote_protocol prot,
mon$remote_address addr,
mon$remote_process rm_proc,
mon$client_version cl_vers,
mon$remote_version rm_vers,
mon$remote_os_user os_user,
mon$auth_method auth
from mon$attachments;
commit;
grant select on v_mon to tmp$c3323;
commit;
set list on;
set term ^;
execute block returns (
msg varchar(80),
att int,
who varchar(31),
prot varchar(31),
addr varchar(50),
rm_proc varchar(255),
cl_vers varchar(255),
rm_vers varchar(31),
os_user varchar(255),
auth varchar(31)
) as
begin
msg = 'Get from ES/EDS';
for
execute statement 'select * from v_mon'
on external 'localhost:' || rdb$get_context('SYSTEM','DB_NAME')
as user 'TMP$C3323' password '456'
into
att
,who
,prot
,addr
,rm_proc
,cl_vers
,rm_vers
,os_user
,auth
do
suspend;
end
^
set term ;^
commit;
connect '/3333:e30' user 'TMP$C3323' password '456';
select 'Get by direct query to view' as msg, v.* from v_mon v;
The screen can be seen in attached file.
Note that is we make connect using '-ch win1251' then field os_user can be easy
translated ("система" = "система" = "system" -- I've got this result
here: https://www.artlebedev.ru/tools/decoder/ ).
PS. When try:
chcp 866
C:\fbtesting\qa\fbt-repo\tmp>isql /3333:e30 -i remote.sql -ch dos866
-- then get:
Statement failed, SQLSTATE = 42000
Execute statement error at isc_dsql_fetch :
335544321 : arithmetic exception, numeric overflow, or string truncation
335544565 : Cannot transliterate character between character sets
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
