| Server IP : 209.209.40.120 / Your IP : 216.73.217.112 Web Server : Microsoft-IIS/10.0 System : Windows NT NEWWWW 10.0 build 17763 (Windows Server 2019) i586 User : NEWWWW$ ( 0) PHP Version : 8.3.30 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/Program Files/MySQL/MySQL Workbench 6.3 CE/modules/ |
Upload File : |
�
�"�Xc @ s d d l Z d d l Z d d l Z d d l Z d d l m Z d d l m Z m Z d d l m Z d d l
m Z m Z d d l
m Z d d l m Z m Z m Z d d l m Z d � Z d
� Z d � Z d � Z d
e j f d � � YZ d e j f d � � YZ d S( i����N( t Thread( t Queuet Empty( t MySQLScriptImporter( t make_panel_headert MessageButtonPanel( t Version( t log_infot log_errort log_warning( t FileChooserc
C sU | j } | j } | j | j d d � } yM | j | � sJ t d � d S| j | � sg t d � d S| j | � } Wn2 t k
r� d d l
} t d | j � � d SXt
j j t j j � j � d � } t | d � } xe | j d � D]T } d
} | j d � r,t j d d
| � } d | } n | } | j d | � q� W| j � | S( Nt shares mysql_sys_schema.sqls9 The server does not supply the sys schema install script
sI The server supplies the sys schema install script, but it's not readable
i����s3 There was an exception when making validations:
%s
s install_sys_script.sqlt ws
t s! CREATE DEFINER='root'@'localhost's (.*);s \1$$s
DELIMITER $$
%s
DELIMITER ;
s %s
( t
server_helpert profilet
join_pathst basedirt file_existsR t Nonet check_file_readablet get_file_contentt Exceptiont tracebackR t
format_exct ost patht joint mformst Appt gett get_user_data_foldert opent splitt
startswitht ret subt writet close(
t ctrl_beR R t install_script_patht install_script_contentR t local_install_script_patht ft linet content( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema.pyt download_server_install_script* s4
$
c C sm t j j | � s t d � d SxF t | � D]8 } | j d � r- t j d | � } | re | d Sq- q- Wd S( sA Gets the version of the sys schema that's shipped with Workbench.s No sys script found
s CREATE OR REPLACEs SELECT '(.*)' AS sys_versioni N( R R t existsR R R R" R# t findall( t file_pathR, t m( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema.pyt get_sys_version_from_scriptR s
c C s7 t j j � j d � } t j j | d � } t | � S( sA Gets the version of the sys schema that's shipped with Workbench.t syss before_setup.sql( R R R t get_resource_pathR R R R3 ( t server_versiont syspathR ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema.pyt get_current_sys_version^ s c C s� y/ | j d d � } | j � r. | j d � SWnU t j k
r� } t d | � | j d d k ri d S| j d d k r� d S� n Xd S( s: Checks whether the sys schema is installed and up to date.s# SELECT sys_version FROM sys.versioni s+ MySQL error getting sys schema version: %s
i iz iv t
access_deniedN( t executeManagementQueryt goToFirstRowt stringFieldValuet grtt DBErrorR t argsR ( t
sql_editort rest e( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema.pyt get_installed_sys_versione s t HelperInstallPanelc B sh e Z d � Z d � Z e d � � Z d � Z d � Z d � Z d � Z d � Z
d � Z d � Z RS(
c C sB t j j | � | j � | j � | j d � | j d � | j d � t j d � | _ | j
| j d d d d t j � t j � | _
| j
| j
d d d d t j � | j
j d d � | | _ | | _ t | j � | _ | j | j _ | j | j _ t � | _ d | _ d | _ d | _ d | _ g | _ d S( Ni i i����s
Installing...i i� ( R t Tablet __init__t set_managedt set_release_on_addt
set_row_countt set_column_countt set_paddingt newLabelt labelt addt HFillFlagt newProgressBart progresst set_sizet ownerR' R t
connectiont importert report_progresst
report_outputR t
_worker_queueR t _workert _progress_statust _progress_valuet
_update_timert _messages( t selfRS t editorR' ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema.pyRF u s,
"" c C s# | j r t j j | j � n d S( N( R\ R t Utilitiest cancel_timeout( R^ ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema.pyt __del__� s c C s
| j d k S( N( RY R ( R^ ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema.pyt is_busy� s c C s/ | | _ | d k r+ t | � | | _ n d S( Ni ( RZ t floatR[ ( R^ t statust currentt total( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema.pyRV � s c C s" t d | � | j j | � d S( Ns %s
( R R] t append( R^ t message( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema.pyRW � s c C s� y>| j j � } | d k r� | j j � d | _ | j j � d | _ | j r� t j
j d d d j | j � d d d � n t St
| t � r=t
| t j � r� | j d d k r� t j
j d d d d d � q=t
| t j � rt j
j d d t | � d d d � q=t j
j d d t | � d d d � n Wn t k
rQn X| j d k rw| j j | j � n | j j | j � t S(
Ns Install sys Schemas Import output:
%ss
t OKR
i i s� The current MySQL account does not have enough privileges to create the sys schema.
Please use an account with schema creation privileges or ask an administrator to install sys.s Error installing sys Schema.
( RX t
get_nowaitR RY R RS t page_activatedR\ R] R R` t show_messaget Falset
isinstanceR R= R> R? t
show_errort DBLoginErrort strR RZ RM t set_textRQ t set_valueR[ t True( R^ t data( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema.pyt update_ui� s2
/% !
c C s yT xC | D]; \ } } d | | f | _ d | _ | j j | | � q
Wt d � Wn� t j k
r� } t d | � | j j | � n| t j
k
r� } t d | � | j j | � nI t k
r} d d l } t d | | j
� f � | j j | � n X| j j d � d S( Ns %s %s...i s! sys schema installation finished
s, MySQL login error installing sys schema: %s
s& MySQL error installing sys schema: %s
i����s2 Unexpected exception installing sys schema: %s
%s
( RZ R[ RU t
import_scriptR R= Rq R RX t putR> R R R R ( R^ t filesRi R+ t dbRB R ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema.pyt install_scripts� s" c C s� yI| j j t d d d � k r1 | j j � nt | j � } | r.t d � } t | � } g | j d � D] } t
| � ^ qn \ } } } t | | | � } g | j d � D] } t
| � ^ q� \ } } } t | | | � }
|
| k r!t d t | � � | j
| d f g d � d St d � n t d � | j
| d � Wn7 t k
r�} t d
t | � � | j j | � n X| j j d � d S( Ni i i
t .s1 Installing sys schema supplied by the server: %s
s Installing server scriptsg Server sys schema install script exists but it's outdated compared to the one supplied by Workbench...
s, Installing sys schema supplied by workbench
s Installing Workbench scripts1 Runtime error when installing the sys schema: %s
( R' t target_versionR RU t
reset_schemasR. R8 R R3 R! t intR Rr R| R R RX Ry ( R^ Rz t locationt workbench_version_stringt server_version_stringt it majt mint relt workbench_versionR6 RB ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema.pyt work� s, 11
c
C s | j j j } | j j } | d } | so | d } | j j } t j j d | | t � \ } } | so d Sn | j
j | � t j j
� j d � } | j j j } d | j | j f } t d | j d t j j | | � d f g f � | _ | j j � t j j d | j � | _ d S( Nt passwordt userNames Install sys SchemaR4 s sys_%i%i.sqlt targetR? g�������?( RS R' t server_profilet db_connection_paramst parameterValuest hostIdentifierR R` t find_or_ask_for_passwordRn RU t set_passwordR R R5 R~ t majorNumbert minorNumberR R� R R R R RY t startt add_timeoutRw R\ (
R^ R� R� t pwdt usernamet hostt acceptedR7 R6 t main_sys( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema.pyR� � s
!6
c C s | j j | | � d S( N( RU Rx ( R^ t whatt
default_db( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema.pyt install s (
t __name__t
__module__RF Rb t propertyRc RV RW Rw R| R� R� R� ( ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema.pyRD t s ! ! t WbAdminPSBaseTabc B sh e Z d Z e Z d � Z d
d � Z d � Z d � Z d � Z
d � Z d � Z d � Z
d � Z RS( R4 c C s{ t j j | t � | j � | j � | j d � | j d � | | _ | | _ | | _
d | _ d | _
d | _ d S( Ni ( R t BoxRF Rn RG RH t set_spacingRK t
instance_infoR' t main_viewR t installer_panelt
warning_panelR- ( R^ R' R� R� ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema.pyRF s
c C sQ t | | j j | | � | _ | j j d � | j | j t t � d | _ d S( Ni (
R R� t namet headingRK RN Rn Ru R R- ( R^ t icont titlet button( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema.pyt create_basic_ui2 s c C s; | j j j | d � } | r7 | j � r7 | j d � Sd S( Ni ( R� R_ R: R; t
intFieldValueR ( R^ t queryRA ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema.pyt get_select_int_result: s
c C s y�| j j � t | j j � } d } | j � } d } t } t | � d k r� t } | d k rm d } n d | t | � f } n | s� d d | | f S| d k r� d d | | f St
| j j � } g | j d
� D] } t
| � ^ q� \ } } } g | j d
� D] } t
| � ^ q
\ }
} } |
| k ra| | k s�| | k ra| | k ran@ | |
k r�d d | | | f | f Sd
d | | | f | f SWng t j k
r�}
d d |
j f St k
r }
d d l } t d | j � � d t |
� d f SXd S( NR
s�
To be able to install the performance schema helper, you'll need the following privileges:
- SELECT, INSERT, CREATE, DROP, ALTER, SUPER, CREATE VIEW, CREATE ROUTINE, ALTER ROUTINE and TRIGGERi R9 s, %s
The following grants are missing:
- %ss; The Performance Schema helper schema (sys) is not installeds Click the [Install Helper] button to install it.
You must have at least the following privileges to use Performance Schema functionality:
- SELECT on performance_schema.*
- UPDATE on performance_schema.setup* for configuring instrumentation
%ss; The Performance Schema helper schema (sys) is not accesibles� You must have at least the following privileges to use Performance Schema functionality:
- SELECT on performance_schema.*
- UPDATE on performance_schema.setup* for configuring instrumentation
%sR} sI Installed Performance Schema helper (sys) version is newer than supportedsP MySQL Workbench needs to downgrade it.
(current version is %s, server has %s).%ss2 Performance Schema helper schema (sys) is outdatedsN MySQL Workbench needs to upgrade it.
(current version is %s, server has %s%s).s7 Unable to access Performance Schema helper schema (sys)s� %s (error %s)
If the sys schema is already installed, make sure you have SELECT privileges on it.
If not, you will need privileges to create the `sys` schema and populate it with views and stored procedures for PERFORMANCE_SCHEMA.i����s! Error checking for PS helper: %s
s0 Unable to access Performance Schema helper (sys)s�
If the sys schema is already installed, make sure you have SELECT privileges on it.
If not, you will need privileges to create the `sys` schema and populate it with views and stored procedures for PERFORMANCE_SCHEMA.( R' t acquire_admin_accessRC R� R_ t get_missing_grantsRu t lenRn Rr R8 R~ R! R� R= R> R? R R R R R ( R^ t installed_versiont install_textt missing_grantst can_installt
curversionR� t xt yt zt ixt iyt izRB R ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema.pyt ps_helper_needs_installation@ sB
110 c C sw t } yF | j j j d d � } | j � rK | j d � } | d k } n Wn$ t j k
rr } t d | � n X| S( s! Checks if performance is enabled.s select @@performance_schemai t 1s; MySQL error retrieving the performance_schema variable: %s
( Rn R� R_ R: R; R< R= R> R ( R^ t ret_valRA t valueRB ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema.pyt ps_usablex s c C s d S( N( NN( R ( R^ ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema.pyt check_usable� s c
C s� d d d d d d d d d d
g
} g } d } y: | j j j d d
� } | j � ri | j d
� } n Wn$ t j k
r� } t d | � n X| j d � d k r� | Sx3 | D]+ } | j | � d k r� | j | � q� q� W| S( Nt SELECTt INSERTt CREATEt DROPt ALTERt SUPERs CREATE VIEWs CREATE ROUTINEs
ALTER ROUTINEt TRIGGERR
s show grantsi s' MySQL error retrieving user grants: %s
t ALLi����(
R� R_ R: R; R< R= R> R t findRh ( R^ t required_grantsR� t current_user_grantsRA RB t grant( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema.pyR� � s $
c C s� | j r% | j | j � d | _ n t | _ d } | j j � sU d d t f } nw | j � ss d d t f } nY | j � } | j
r� | j
j r� d S| j | j
� d | _
n | r� d | j f } n | s� | j
� \ } } n | rX| \ } } } | s d } n t d | | | � | _ | j | j t t � | j r�| j j t � q�nM | j � | j s�| j � t | _ n | j j t � | j � | j � d S( Ns+ There is no connection to the MySQL Server.sC This functionality requires a connection to a MySQL server to work.s Performance Schema Unavailables� Performance Schema is either unavailable or disabled on this server.
You need a MySQL server version 5.6 or newer, with the performance_schema feature enabled.s Install HelperR
( R� t removeR Ru t page_activeR' t is_sql_connectedRn R� R� R� Rc t install_helperR� R RN R- t showt suspend_layoutt
ui_createdt create_uit relayoutt
resume_layout( R^ t button_datat textR� R� ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema.pyRl � sD
c C s� | j | j � d | _ t | | j j | j � | _ | j | j t t � | j
� | j j t d d d � k r� t
t j � } | j d � | j � r� | j � | j j _ q� n | j j j | j j � � | j j � d S( Ni i i
s% Specify the location of mysql_upgrade( R� R� R RD R� R_ R' R� RN Ru R� R~ R R
R t OpenFilet set_titlet run_modalt get_pathRU t _upgrade_tool_pathR� t get_mysql_passwordR� ( R^ t filechooser( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema.pyR� � s
N( R� R� R4 Rn R� RF R R� R� R� R� R� R� Rl R� ( ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema.pyR� s 8 /( R R= R# R t threadingR R R t workbench.client_utilsR t wb_admin_utilsR R t workbench.utilsR t
workbench.logR R R R
R. R3 R8 RC RE RD R� R� ( ( ( sL C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema.pyt <module> s ( �