| Server IP : 180.180.241.3 / Your IP : 216.73.216.252 Web Server : Microsoft-IIS/7.5 System : Windows NT NETWORK-NHRC 6.1 build 7601 (Windows Server 2008 R2 Standard Edition Service Pack 1) i586 User : IUSR ( 0) PHP Version : 5.3.28 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/Program Files (x86)/MySQL/MySQL Workbench 6.1 CE/modules/ |
Upload File : |
,2Sc @ s d Z d d l m Z m Z m Z m Z m Z d d l Z d d l m Z m Z d d l
m Z m Z m
Z
m Z m Z d d l Z d d l m Z m Z m Z m Z m Z d d l m Z d d l m Z m Z d e j f d
YZ d e j f d YZ d S(
s
How to handle MySQL logs
*************************
Among other things this module needs to establish:
1. Which of the logs (if any) are enabled.
2. Whether the output of the enabled logs are stored in a table or in a log file.
Determining the state of the logs
-----------------------------------
There are two possible scenarios:
the server is down:
In this case all logs are assumed to be **disabled** since the server won't
be logging anything unless it's running.
the server is up:
Starting with MySQL Server 5.1.29 the relevant server variables changed.
This derives in two new scenarios:
server version < 5.1.29:
:general query log:
The state of this log is reflected in the server variable ``log``
which will be set to ``'OFF'`` if the log is disabled or to either
``'ON'`` or to ``'1'`` or to a file path if the log is enabled.
:slow query log:
Its state is reflected in the server variable ``log_slow_queries``
which will be set to ``'OFF'`` if the log is disabled or to
``'ON'`` or to ``'1'`` if the log is enabled.
:error log:
Its state is reflected in the server variable ``log_error``
which will be set to ``''`` (the empty string) if the log is disabled
or to the path to the error log file if the log is enabled.
.. note::
The error logs are not going to be written to the error log file
if the server was started with the ``--console`` command line
option on Windows, even if ``log_error`` has a path set up. In
this case error logs are written to stderr.
It seems that there's no way to query the server to determine if
this ``--console`` option is in place.
.. note::
The ``log_slow_queries`` and ``log`` variable were removed in MySQL
Server 5.6.
server version >= 5.1.29:
:general query log:
If enabled the ``general_log`` variable will be set to ``'ON'`` or
to ``'1'``. Otherwise it will be set to ``'OFF'`` or to ``'0'``.
:slow query log:
If enabled the ``slow_query_log`` variable will be set to ``'ON'`` or
to ``'1'``. Otherwise it will be set to ``'OFF'`` or to ``'0'``.
:error log:
Its state is reflected in the server variable ``log_error`` as
explained for server version < 5.1.29.
.. note::
For MySQL Server versions >= 5.1.6, if the variable ``log_output``
contains the value ``'NONE'``, the general query log and the slow
query log will not record any new log entry.
The general log can also be disabled by setting to ``'1'`` the session
variable ``sql_log_off``.
Determining where the logs are being written
---------------------------------------------
Starting from MySQL Server 5.1.6 there's the possibility of sending the logs
from the general query log or from the slow query log to a server table instead
of to a log file. This is controlled by the value of the variable ``log_output``
which can be a combination of the values ``'FILE'`` (log into log files),
``'TABLE'`` (log into a server table) or ``'NONE'`` (don't log). If given, ``'NONE'``
takes precedence over the other values.
.. warning::
For MySQL Server versions older than 5.1.29 there's no reliable way to know
where the general and slow query logs are being written (if they are logged
to a file). Their default values are ``$datadir + $hostname + '.log'`` and
``$datadir + $hostname + '-slow.log'``, respectively. This can be changed
in the command line or in the configuration file and the real paths will not
be exposed in any server variable.
Starting from MySQL Server 5.1.29 the paths to the general and slow query log
files are stored in the ``general_query_log_file`` and in the``slow_query_log_file``
variables, respectively. *The server creates the file in the data directory unless
an absolute path name is given to specify a different directory.*
Use cases for the server logs
---------------------------------
1. The server is running. All logs are enabled and WB can precisely determine their
sources. Every log is shown in its corresponding tab.
2. The ``log_output`` server variable contains both ``'FILE'`` and ``'TABLE'``.
WB will select on a per log basis which source should be chosen. Will select
table logs if the server is local or if the server is remote and any of these
happen:
* Cannot reliably determine the paths to the log file.
* The user running WB has no read permissions on the log file.
* The log file does not exist.
* The user explicitly requested to read from log table.
3. ``log_output`` contains ``'NONE'``. Nonetheless WB will check for log sources
and will show them, alerting the user about log not being updated because of
that. *What to do if there are log files and log tables available in this case?*
4. The server is logging to files and WB can precisely determine their paths but
the log file is missing in the file system. The situation will be reported to
the user (advising him to ``FLUSH LOGS`` or restart the server and start querying)
The log will not be shown as long as this situation persists.
5. The server is logging to tables and the connection to the server is lost. If the
server is also logging to files, and a log file exists in the file system, the
log file will be shown and the user will be warned about this change.
6. The server is logging to files and WB cannot precisely determine the path to the
log file (i.e. server version < 5.1.29). WB will try to get the path from these
sources in this order:
1. The server's configuration file.
2. The default path assumed by the server when no log path is specified.
If no such file is found in the file system the log will not be shown.
7. The user changed the source of a log or the path to a log file while WB was
showing the previous source/path. WB will switch to the new source/path and will
inform the user of the change.
8. [Postponed] The user clicks on a *Add new log* button. A dialog will be shown in
which the user will select the type of log to be added (error, general or slow),
the log source (a database table or a log file) and the name of the log table/file.
A new tab showing the user selected log will be shown and will persist during the
session or until the user clicks on the tab's *Close* button.
i( t newBoxt newLabelt newTreeNodeViewt
newTabViewt newButtonN( t not_running_warning_labelt make_panel_header( t GeneralQueryLogReadert SlowQueryLogReadert GeneralLogFileReadert SlowLogFileReadert ErrorLogFileReader( t LogFileAccessErrort
ServerIOErrort OperationCancelledErrort InvalidPasswordErrort log_error_decorator( t WorkerThreadHelper( t log_errort log_debugt LogViewc B s e Z d Z d Z e d Z d Z d Z d Z d
d Z
d Z d Z d Z
d
Z d Z d Z RS( s|
Main front end view class for displaying log entries.
Each page in the Tab View is an instance of this class.
c G s t t | j t | j | j | | _ | | _ | | _ d | _
d | _ d | _ d | _
d | _ | j d | _ d S( s
The arguments following BackendLogReaderClass will be passed to
BackendLogReaderClass to instantiate it in order to get a log
reader object.
N( t superR t __init__t Falset set_managedt set_release_on_addt ownert BackendLogReaderClasst argst Nonet
log_readert error_boxt treet bboxt warning_boxt update_uit worker( t selfR R R ( ( sL C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_logs.pyR s
c C s | j r% | j | j d | _ n t t | _ | j j d t t | } | j j | t t t
} | j d | j j | t t | j | j
| j | j t t d S( Ni s Try again( R t removeR R t Truet set_spacingR t strt addR R t set_textt add_clicked_callbackR# ( R% t errort error_labelt try_again_button( ( sL C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_logs.pyt _show_error s
c
C s | j r% | j | j d | _ n | j rJ | j | j d | _ n | j ro | j | j d | _ n | j r | j | j d | _ n | j d | j d y | j | j | _
WnA t t t
t t t f k
r
} t d | | j | d SX| j
j rwt t | _ | j j d t | j
j } | j j | t t | j | j t t n t t j | _ | j j t j x8 | j
j D]* } | j j t j | d | d t qW| j j! | j | j t t t j" } | j# d | j$ d | j% d | j& d | j t d d d d d t j' | j
j( rt | j
j( j) } n t d } | j* t j+ | j | d d d d t j' t j, B | j t d d d
d d t j' t | j
j( rd n d | _- | j- j* t j+ | j | j- d
d d d t j' t j, B | j t d
d d d d t j' t d | _. | j. j* t j+ | j | j. d d d d t j' | j | t t t t | _ | j j d | j/ | j t t t j0 | _1 | j1 j2 d | j3 d | j1 j2 d | j4 d | j j5 | j1 | j j t d t t t6 | _7 | j7 j8 d | j j | j7 t t | j7 j9 | j: t6 | _; | j; j8 d | j j | j; t t | j; j9 | j< t6 | _= | j= j8 d | j j | j= t t | j= j9 | j> t6 | _? | j? j8 d | j j | j? t t | j? j9 | j@ t6 | _A | jA j8 d | j j | jA t t | jA j9 | jB d S( Ni s" Exception creating log reader: %s
i i i i s Log File Location:t TABLEs Log File Size:i s
retrieving...t -s Showing:s retrieving data...t Copyt copy_records Copy Detailst copy_detailst t Oldests < Previous Pages Next Page >s Most Recentt Refresh(C R R& R R R! R" t set_paddingR( R R R R
R R R t IOErrort
ValueErrorR R0 t partial_supportR R' R R* R R t mformst TreeFlatListt set_selection_modet TreeSelectMultiplet column_specst
add_columnt StringColumnTypet end_columnst newTablet set_row_spacingt set_column_spacingt set_column_countt
set_row_countt HFillFlagt log_filet patht set_stylet BoldStylet HExpandFlagt
size_labelt range_labelt add_endt newContextMenut _menut add_item_with_titleR4 R5 t set_context_menuR t
bof_buttonR+ R, t go_boft back_buttont go_backt next_buttont go_nextt
eof_buttont go_eoft refresh_buttont refresh( R% R- t
warning_labelt colspect tablet label( ( sL C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_logs.pyR# s
!
% &%!)%" c C s | | j j d S( N( R t current( R% t out( ( sL C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_logs.pyt read_data_workerN s c C s | j | d | _ d S( N( R` R R$ ( R% t data( ( sL C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_logs.pyt handle_worker_dataQ s
c C s | j ry| j j | d k r | j s | j j t | j j t | j j t | j j t | j
j t t | j | j
| _ | j j d n d S| j j xP | D]H } | j j } x0 t | D]" \ } } | j | | j q Wq W| j j | j j | j j | j j | j j | j j | j j | j j | j j | j j | j j | j j | j
j t Wqt t t t t! t" t# f k
r} | j$ | qXn d S( Ni (% R R` R R$ RW t set_enabledR RY R] R[ R_ R Rg Ri t startR t cleart add_nodet enumeratet
set_stringt stripRQ R+ t
range_textRP t size_textt has_previoust has_nextR' R
t RuntimeErrorR R R R: R; R0 ( R% t recordst rect rowt idxt colR- ( ( sL C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_logs.pyR` U s6
$c C s | j j } d j g | j j D] } | d ^ q" g } xc | D][ } g } x6 t t | j j D] } | j | j | qj W| j d j | qE W| r t j
j d j | n d S( Ns , i s
( R t
get_selectiont joinR RA t ranget lent appendt
get_stringR= t Utilitiest set_clipboard_text( R% t selectiont rt textt nodet recordt i( ( sL C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_logs.pyR4 u s /
c C sh | j j } g } x* | D]" } | j | j | j j q W| rd t j j d j | n d S( Ns
(
R R{ R R R t
detail_columnR= R R R| ( R% R R R ( ( sL C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_logs.pyR5 s
c C sV y | j | j j Wn5 t t t t t t t f k
rQ } | j
| n Xd S( N( R` R t firstR
Ru R R R R: R; R0 ( R% R- ( ( sL C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_logs.pyRX s $c C sV y | j | j j Wn5 t t t t t t t f k
rQ } | j
| n Xd S( N( R` R t lastR
Ru R R R R: R; R0 ( R% R- ( ( sL C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_logs.pyR^ s $c C sq y5 | j j r! | j j n d } | j | Wn5 t t t t t t
t f k
rl } | j | n Xd S( N(
R Rs t previousR R` R
Ru R R R R: R; R0 ( R% Rv R- ( ( sL C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_logs.pyRZ s
$$c C sq y5 | j j r! | j j n d } | j | Wn5 t t t t t t
t f k
rl } | j | n Xd S( N(
R Rt t nextR R` R
Ru R R R R: R; R0 ( R% Rv R- ( ( sL C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_logs.pyR\ s
$$N( t __name__t
__module__t __doc__R R R0 R# Rg Ri R R` R4 R5 RX R^ RZ R\ ( ( ( sL C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_logs.pyR s l t WbAdminLogsc B s e Z e Z e d Z e d Z d Z d Z d Z d Z
d Z d Z d Z
d Z d
Z d Z d Z RS(
c C s | j | d d t d S( Nt wba_instances Server Logs( t
register_pageR' ( t clst
admin_context( ( sL C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_logs.pyt wba_register s c C s d S( Nt admin_server_logs( ( R ( ( sL C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_logs.pyt
identifier s c C sH t t | j t | j | | _ | | _ | | _ t | _ d S( N( R R R R R t ctrl_bet server_profilet main_viewt disable_log_refresh( R% R R R ( ( sL C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_logs.pyR s
c C s | j d | j d t d | j j d | _ | j | j t t t | _
| j | j
t t | j
j t t t | _
| j | j
t t d | _ d | _ d | _ d | _ d | _ d S( Ni i s title_logs.pngs Server Logs( R9 R( R R t namet headingR* R R' R t warningt showR t tabViewR t general_log_tabt slow_log_tabt general_file_log_tabt slow_file_log_tabt error_file_log_tab( R% ( ( sL C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_logs.pyt create_ui s
c s i } j j r j j j d d d s y& j j d } | j sU | SWn | SX| j d d k r| d n d j _ t d j
j j j f qy& j j d
} | j s | SWn | SX| j d j _ d j j k rd j j k r f d } j j sbd | d
<d | d <t d j
j | f | St
d d s j j ry< j j rt j j n | j j d | d
<Wqd | d
<qXn
d | d
<| d
_ n
j | d
<t
d d s j j rky< j j r9t j j n | j j d | d <Wqud | d <quXn
d | d <| d _ q j | d <n t d j
j | f n | S( Ni i i s SHOW VARIABLES LIKE 'log't Valuet ONt FILEt NONEs %s: log_output = %s
s SHOW VARIABLES LIKE 'log_output'R1 c s{ d d l } d d l } | j } | j j | j j | j j } | j sj t d n | j
| d S( NiR6 ( t wb_admin_ssht wb_server_controlt
WbAdminSSHt wrapped_connectR t PasswordHandlert clientt open_sftpt is_connectedR: t open( RL R R t ssht sftp( R% ( sL C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_logs.pyt open_remote_file s t general_logt slow_logt stored_general_log_source_choicet stored_slow_log_source_choice( R t is_sql_connectedt target_versiont# is_supported_mysql_version_at_leastt
exec_queryt nextRowt stringByNameR t
log_outputR t __class__R t
admin_enabledt getattrR t general_log_file_patht is_localR R t slow_log_file_pathR ( R% t destt resultR ( ( R% sL C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_logs.pyt get_log_destination s^ '# $
.
.
c C s4 | j j | | j j t | j j t d S( N( R R+ R R' R R ( R% t msg( ( sL C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_logs.pyt show_message_panel s c G sR d | k r% t | d d g } n d | k rJ t | d d g } n d | k r~ | j r~ | j j | j d | _ n d | k r | j r | j j | j d | _ n d | k r | j r | j j | j d | _ n d | k r| j r| j j | j d | _ n d | k rN| j rN| j j | j d | _ n d S( NR1 t general_tabt slow_tabR t general_file_tabt
slow_file_tabt error_file_tab( t listR R t remove_pageR R R R R ( R% t source( ( sL C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_logs.pyt _remove_tabs s& c G s d | k r% t | d d g } n d | k rJ t | d d g } n d | k r | j j r | j r y; t | t | j | j j | _ | j j | j d Wq t k
r | j
d | j j d | _ q Xn d | k r~| j j r~| j j
r~| j r~y; t | t | j | j j
| _ | j j | j d
Wq~t k
rz| j
d | j j
d | _ q~Xn d | k r | j j r | j j r | j r y; t | t | j | j j | _ | j j | j d Wq t k
r| j
d | j j d | _ q Xn d | k rq| j j rq| j rqt | t | j | _ | j j | j d
n d | k r| j j r| j rt | t | j | _ | j j | j d n d S( NR1 R R R R R R s Error Log FilesY There was a problem reading %s. Please verify that you have read permissions on that files General Log FilesY There was a problem reading %s.
Please verify that you have read permissions on that files
Slow Log Files General Log Tables Slow Query Log Table( R R t error_log_file_pathR R R R R t add_pageR: R R t general_log_enabledR R R t slow_log_enabledR R R
R R R R ( R% R ( ( sL C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_logs.pyt _add_tabs* s> "!
.!
.!
""c C s | j } | j d | j j s4 d | j _ n d | j j k rY | j d d nX| j j d k r | j d | j d n)| j j d k r | j d | j d n | j j d k s | j j d k rt d d d d
g } g } | j j sd d
g } nF | j | d d k r3d n d | j | d d k rVd
n d | j t | t | | j t | n! d
| j j } | j
| d S| j j t
| j j t d S( NR s
TABLE,FILER R1 R s
FILE,TABLER R R R R R s We have detected a problem in your current Log Destination.
It is set to %s. Please refer to the documentation for further information:
http://dev.mysql.com/doc/refman/5.1/en/log-destinations.html( R R R R R t setR R R t tupleR R R R R R' ( R% R t tabst to_be_addedR ( ( sL C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_logs.pyR# R s4
$##
c C s | j s) | j | j t | _ n | j y | j WnP t k
r } t j j d d | d d d } | t j
k r t | _ q n Xd S( Ns Log Refreshs8 An error occurred while displaying MySQL server logs: %st Ignoret CancelR6 ( t
ui_createdt detect_pathsR R' R# R` t ExceptionR= R t show_warningt ResultCancelR ( R% t eR ( ( sL C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_logs.pyt page_activatedz s
"c C s | j j d d } | d k rt | j j | j j | j j | j j g rt j | j | j } | j
| j j d t t
| j | j j } | j j r | j d r | d | j _ n | j j s2| j d r | d n | j d r | d n d } | r2| j d
| j _ q2n | j j s| j d rW| d n | j d rp| d n d } | r| j d
| j _ qn | j j r| j d
r| d
j d
| j _ qn d S( Nt verbosei t stoppedt unknownt warn_missings
log-outputt general_log_filet logR6 t "t slow_query_log_files log-slow-queriess log-error( s stoppeds unknown( R t is_server_runningt allR R R R R t wb_admin_config_file_bet WbAdminConfigFileBEt open_configuration_filet config_file_pathR t dictt get_optionst config_file_sectiont has_keyt log_ouputRp ( R% t statust cfg_bet optionsRL ( ( sL C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_logs.pyR s. c C s | j r
d S| j j rQ | j r5 | j j n | j rQ | j j qQ n | j rj | j j n | j r | j j n | j r | j j n d S( N( R R R R R` R R R R ( R% ( ( sL C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_logs.pyR` s c C s d S( N( ( R% ( ( sL C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_logs.pyt
do_refresh s ( R R R R t classmethodR R R R R R R R R# R R R` R ( ( ( sL C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_logs.pyR s C ( ( ( R R= R R R R R t wb_admin_utilsR R t
wb_log_readerR R R R
R R t wb_commonR R
R R R t workbench.utilsR t
workbench.logR R t BoxR R ( ( ( sL C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_logs.pyt <module> s ( ( (