| 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 : /Program Files/MySQL/MySQL Workbench 6.3 CE/modules/ |
Upload File : |
2zXc
@ s d d l Z d d l Z d d l Z d d l Z d d l Z d d l Z d d l Z d d l Z d d l Z d d l m Z m
Z
m Z m Z m
Z
m Z m Z m Z m Z m Z m Z m Z m Z m Z m Z d d l m Z m 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 d l& Z& d d l' m( Z( d d d
d d d
g Z) d d d d d d d d d d g
Z* d d d g Z+ d Z, i i d d 6d d 6e- d 6e- d! 6d 6i d d 6d d 6e- d 6e- d! 6e. 6i d" d 6d d 6e- d 6e- d! 6d# 6i d$ d 6d% e j/ p)d& d 6e- d 6e0 d! 6d' 6i d( d 6d) d 6e- d 6e0 d! 6d* 6i d+ d 6d d 6e- d 6e- d! 6d, 6i e. d 6d- d 6e- d 6e- d! 6d. 6Z1 d/ Z2 d0 Z3 d1 e4 f d2 YZ5 d3 e j6 f d4 YZ7 d5 e j8 f d6 YZ9 d7 f d8 YZ: d9 e j8 f d: YZ; d; e; f d< YZ< d= e j6 f d> YZ= d? e; f d@ YZ> dA e j8 f dB YZ? dC e j8 f dD YZ@ d S(E iN( t newBoxt newLabelt newButtont newTextEntryt newTreeViewt newTablet newRadioButtont newSelectort newPanelt
newTabViewt Utilitiest newCheckBoxt newImageBoxt newScrollPanelt App( t not_running_warning_labelt make_panel_header( t
AdminSecurityt
PrivilegeInfot PrivilegeReverseDictt SecurityAdminRolest WBSecurityValidationError( t PermissionDeniedError( t log_errort
log_debug3( t db_utilst Select_privt Insert_privt Update_privt Delete_privt Execute_privt Show_view_privt Create_privt
Alter_privt References_privt
Index_privt Create_view_privt Create_routine_privt Alter_routine_privt
Event_privt Drop_privt Trigger_privt
Grant_privt Create_tmp_table_privt Lock_tables_privt mysql_native_passwordt Standardt namet t auth_string_labelt enable_hostt enable_passwords Standard (old)t mysql_old_passwords Windows Natives Supply the Windows username and/or group names that are allowed to use this account, separated by a comma (,)
This account will be usable by these users whenever they are logged into Windows, without additional passwords.
Example: Administrator, %st joet authentication_windowst PAMs Syntax: <pam_service_name>[,<group_name1>=<sql_user_name1> [,<group_name2>=<sql_user_name2> ...]]
See documentation for details.t authentication_pams SHA256 Passwordt sha256_passwords: See the plugin documentation for valid values and details.t *c C s t | } | j t j | S( N( R t set_text_alignt mformst MiddleRight( t textt l( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt rLabelk s c C s t | } | j t j | S( N( R t set_styleR< t SmallHelpTextStyle( R> R? ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt dLabelp s t ThreadedInputValidatorc B sA e Z d Z d d d Z d Z d Z d Z d Z RS(
s This class validates the changes in the associated text entry widget displaying the result in a validation label
Usage:
Instantiate this class and set is callback method to be the callback of the associated text entry.
i s #33aa33s #aa3333c C s | | _ | | _ | | _ | | _ | | _ | | _ d | _ d | _ t j
| _ d | _ d d d d g | _
d | _ d S( Nt Blankt Weaks Medium strengtht Strongs %s password.( t ownert
text_entryt validation_labelt ctrl_bet delayt colorst Nonet last_keypress_timet text_to_validatet threadingt Lockt lockt timert strengtht message( t selfRH RI RJ RK RL RM ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt __init__} s c C s} | j | d k r d n d } | d k r8 | j d n | j | j | } | j j | | j j | | j j d S( Ni i ( RM RU RV RJ t set_colort set_textRH t set_dirty( RW t estimatet colorRV ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt update_validation_label s
-c C sz | j & t j | _ | j j | _ Wd QX| j sK | j j rv t j | j
| j | _ | j j n d S( N(
RS t timeRO RI t get_string_valueRP RT t is_aliveRQ t TimerRL t validatet start( RW ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt callback s
c C s | j r | j j n d S( N( RT t cancel( RW ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt shutdown s c s d f d } j j o9 d j j k } | rH | n } x t r j j } j } Wd QXt j | j k r | d k r Pn j d _ Wd QX| | } t
j j t
j j d | t n t j d qQ Wt
j j d S( Nc S s | d k r d St | d k r& d Sd } t | d k rK | d 7} n t j d | rj | d 7} n t j d | r t j d | r | d 7} n t j d | r | d 7} n | d
k r d S| d k r d Sd
S(
NR0 i i i i s \d+s [a-z]s [A-Z]s (\W|_)+i i i ( t lent ret search( t passwdR\ ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt compute_password_strength s
$
c s | d k r d S j j d t j | } | rS | j rS | j d } n
| S| d k rm d S| d k r} d Sd S( NR0 i s' SELECT VALIDATE_PASSWORD_STRENGTH('%s')i i2 iK i i ( RK t
exec_queryR t escape_sql_stringt nextRowt
intByIndex( Rk t resultR\ ( Rl RW ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt query_password_strength s
t validate_passwords VALIDATE PASSWORDR\ g?( Rs s VALIDATE PASSWORD( RK t is_sql_connectedt server_active_pluginst TrueRS RO RP R_ RL RN R< R
t perform_from_main_threadt functoolst partialR^ t Falset sleept driver_shutdown( RW Rr t query_strengtht strength_functionRO RP R\ ( ( Rl RW sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyRc s$ !
( s #33aa33s #aa3333( t __name__t
__module__t __doc__RX R^ Re Rg Rc ( ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyRD w s t AddSchemaPrivilegeFormc B s/ e Z d d Z d Z d Z d Z RS( R0 c
C sN t j j | d t j t j B | j d | | _ t t } | j
d | j d | j | t
d | j d } | j | t t t t j } | j d | j | t t t } | j | | j
d | j d | j d | j d | j d t t j j | _ | j j t | j j | j | j j d | j | j d
d d
d t j | j t! d d
d d
d t j" t j B t | j j# | _$ | j$ j | j | j$ j d | j | j$ d
d d d
t j | j t! d d
d d d
t j" t j B t% | _& | j | j& d d
d d
t j t j' B t | j j# | _( | j( j | j | j( j d t j t } | j | j( t t | j | d
d d
d t j" t j B t! d } | j) t j* | j | d
d d
d t j" t j B t+ | _, | j | j, d d
d
d t j t j' B x$ | j j- D] } | j, j. | q|Wt t } | j | t t | j d t/ | _0 | j0 j d | j1 | j0 t t t/ | _2 | j2 j d | j1 | j2 t t | j3 d d | j | j4 d S( Ns New Schema Privilege Definitioni i sV Select the Schema for which the user '%s' will have the privileges you want to define.s utf-8t Schemai i s All Schema (%)i i s( This rule will apply to any schema name.i s Schemas matching pattern:s This rule will apply to schemas that match the given name or pattern.
You may use _ and % as wildcards in a pattern.
Escape these characters with \ in case you want their literal value.s Selected schema:s7 Select a specific schema name for the rule to apply to.t OKt CanceliR i (5 R< t FormRX RN t
FormResizablet FormMinimizablet set_titlet secmanR Rz t set_paddingt set_spacingt set_contentR t encodet addRv R t TitledBoxPanelR t
set_row_countt set_column_countt set_row_spacingt set_column_spacingR t RadioButtont new_idt schema1t
set_activet add_clicked_callbackt schema_radio_changedRZ t HFillFlagRC t VFillFlagt group_idt schema2R t schema2entryt HExpandFlagt schema3R; t TopLeftR t
schema3selt schema_namest add_itemR t okt add_endRf t set_sizet center(
RW R t usert boxt labelt panelt tablet alignboxt itemt bbox( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyRX sr
",", )& & )
c C sI | j j | j j | j j | j j | j j | j d S( N( R t set_enabledR t
get_activeR R R t
async_refresht update_schemas( RW ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR " s c C s | j j } | j j x$ | j j D] } | j j | q) WxK t d | j j D]1 } | j j | | k r\ | j j
| q\ q\ Wd S( Ni ( R R` R t clearR R R t ranget get_item_countt get_item_titlet set_index( RW t selected_schemaR t index( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR ( s
c C sh | j | j | j rd | j j r0 d } n0 | j j rQ | j j } n | j j } | Sd S( Nt %(
t run_modalR Rf R R R R R` R RN ( RW t schema( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt run3 s ( R R RX R R R ( ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR s L t SecuritySchemaPrivilegesc B st e Z 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 t j j | t | j | j | | _ t | _ | j | j d | j
d i | _ t t j
| _ | j j t j d d t | j j t j d d t | j j | j j | j t t } | j d | j | j t t t j t } t t } | j d | j t d t t t | _ | j j d | j | j t t | j j | j t | _ | j j d | j | j t t | j j | j t | _! | j! j d | j | j! t t | j! j | j j" | j! j# d
| j | t t t$ d | _% | j | j% t t | j | d t t } | j d | j& t t' t j( | _) } | j* d
t t } | j
d | | _+ | j | | j | t t t' t j( | _, } | j* d t t } | j
d | | _- | j | | j | t t t' t j( | _. } | j* d t t } | j
d | | _/ | j | | j | t t t0 d } | j | | j | d | j | t t t t } | j d t | _1 | j1 j d | j | j1 t t | j1 j | j2 t | _" | j" j d | j | j" t t | j" j | j3 | j | t t | j4 | j5 d d S( Ni R i t
Privilegesi sp Schema and Host fields may use % and _ wildcards.
The server will match specific entries before wildcarded ones.s Add Entry...s Delete Entrys Revoke All Privilegess Immediately remove all privileges from the account, from every object at all levels.
The account itself will be left untouched and logins will still be possible.R0 i s
Object Rightss
DDL Rightss Other Rightsi s Select "ALL"s Unselect All(6 R< t BoxRX Rz t set_managedt set_release_on_addt _ownert dirtyt suspend_layoutR R t schema_rights_checksR t TreeFlatListt
privs_listt
add_columnt StringColumnTypeRv t end_columnst add_changed_callbackt schema_priv_selectedR R t newSplitterRC R t add_entry_buttonRZ R R t add_entryt del_entry_buttont del_entryt revoke_all_buttont
revoke_allt set_tooltipR t schema_priv_labelt set_homogeneousR R t schema_object_privs_panelR t object_rights_boxt schema_ddl_privs_panelt ddl_rights_boxt schema_other_privs_panelt other_rights_boxR
t grant_allt grant_all_schema_privst revoke_all_schema_privst
resume_layoutt set_divider_position(
RW RH t topboxt splitterR t hboxR R t scrollboxt
bottom_box( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyRX C s
c C s | j r
d S| j j j j } x t D] } | | k r> q& n t } t j | d \ } } | j
| | r | j | n | j | j
| j j | t t | | j | <q& Wx t D] } | | k r q n t } t j | d \ } } | j
| | r | j | n | j | j
| j j | t t | | j | <q Wx t D] } | | k rrqZn t } t j | d \ } } | j
| | r| j | n | j | j
| j j | t t | | j | <qZWd S( NR0 ( R0 N( R0 N( R0 N( R R RH R t global_privilege_namest SCHEMA_OBJECT_RIGHTSR R t getRN RZ R R t schema_priv_checkedR R Rz t SCHEMA_DDL_RIGHTSR t SCHEMA_OTHER_RIGHTSR ( RW R R/ t cbR t desc( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt update sH
c C s g } x9 | j j D]( \ } } | j r | j | q q W| j j } | d k r t | | j j j j
| _ g | D] } t j
| d d ^ q } | j | j j | j d d j | p d n | j j d S( Ni t i s , t none( R t iteritemsR t appendR t get_selected_rowt setR t _selected_usert schema_privst entriest
privilegesR R t sortt node_at_rowt
set_stringt joinR[ ( RW t privsR/ R t selt pt plist( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR s )
.c C s t | j j j | j j j } | j } | d k r | j j j j | t
} | j | j j j | j | | j
j | j
j t | j j j j d | j | j j n d S( Ni ( R R RH R R t usernameR RN R R R t refresh_entry_listt show_privilegesR t select_nodeR Rh R R R[ ( RW t addformR t entry( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR s !
2
c C s | j j } | s d S| j j j j | j j | | j | j | j j | j
j t | j
j t | j j j t d S( N( R t get_selected_nodeR R R R t row_for_nodet remove_from_parentR R[ R R Rv R t refresh_button( RW R ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR s "
c C sf | j j } | s# | j j r3 | j d n/ | j j j j | j j | } | j | d S( N( R R R R R RN R R R
( RW R R ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR s
"c C sd xF | j j D]5 \ } } | d k r8 | j t q | j t q W| j | j j d S( NR* ( R R R Rv Rz R R R[ ( RW R/ R ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR s
c C sB x$ | j j D] } | j t q W| j | j j d S( N( R t
itervaluesR Rz R R R[ ( RW R ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR ( s
c C sm | j | d k | j j | j | | d k r\ | j j t | j j t n | j d d S( N(
R RN R t unset_dirtyR R Rv R Rz R ( RW R ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt show_user/ s
c C s | j j x | r | j p" g D]} } | j j } | j d | j g | j D] } t j | d d ^ qU } | j | j d d j
| p d q# Wd S( Ni R i s , R ( R R R t add_nodeR t dbR R R R R ( RW R R t rowR R ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR > s
,
c C s | j j | d k | j j | d k | j j | d k | rC| j | j } } d | j j j | j j j
f } d | k s d | k r | d k r | d 7} q | d | 7} n | d | 7} | j j | | j
j t | j j t | j j t x | j j D] \ } } | j | | k q Wnm | j j d | j
j t | j j t | j j t x* | j j D] \ } } | j t qWd S( Ns The user '%s'@'%s' t _R s4 will have the following access rights to any schema:s? will have the following access rights to schemas matching '%s':s9 will have the following access rights to the schema '%s':R0 ( R R RN R R R R R R R t hostR RZ R Rv R R R R R Rz ( RW R R R R> t privt check( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR I s. "
c C s | j d d S( N( R RN ( RW ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt refreshm s ( R R RX R R R R R R R R R R R ( ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR B s { *
$t FirewallCommandsc B s e Z d Z d Z d Z d Z d Z d Z d Z d Z d Z
d Z e d
Z
d Z d Z d
Z d Z d Z RS( c C s, | | _ | j | _ d d d Y} d S( Nt CommandTypec B s e Z d Z d Z d Z RS( i i i ( R R t
simple_resultt simple_result_with_countt multi_result( ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR u s ( ( RH RK ( RW RH R ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyRX r s c C sd d } | j j sB t d t j d d d d d t d f S| j j | \ } } | | f S( Ni s4 Executing firewall command. The connection is down.
s Execute firewall commandsJ The connection is down. Please check if you have connection to the server.t OkR0 ( RK t sql_pingR R
t
show_errorRz t exec_sql( RW t commandt affcted_record_countRq ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt execute_command{ s
c C s | j j s6 t d t j d d d d d t S| j j | } | t k rX t S| d k r t d t j d d d d d t S| S( Ns4 Executing firewall command. The connection is down.
s Execute firewall commandsJ The connection is down. Please check if you have connection to the server.R R0 sE Executing firewall command. There was no resultset from the command.
s1 There was a problem executing a Firewall command.( RK R! R R
R" Rz Rm RN ( RW R$ Rq ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt execute_result_command s
c C s | j j s6 t d t j d d d d d t S| j j | } | t k rX t S| s t d t j d d d d d t Sx; | D]3 } | s t d t j d d d d d t Sq W| S(
Ns4 Executing firewall command. The connection is down.
s Execute firewall commandsJ The connection is down. Please check if you have connection to the server.R R0 sE Executing firewall command. There was no resultset from the command.
s1 There was a problem executing a Firewall command.sJ Executing firewall command with multiple resultsets. Resultset is 'None'.
s Resultset is 'None'.( RK R! R R
R" Rz t exec_query_multi_result( RW R$ R Rq ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt execute_multiresult_command s"
c C sP g } | j d | } | s# | Sx& | j rK | j | j d q& W| S( Ns= SELECT RULE FROM mysql.firewall_whitelist WHERE USERHOST='%s'i ( R' Ro R t
stringByIndex( RW t userhostRq t query_result( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt get_user_rules s c C sP g } | j d | } | s# | Sx& | j rK | j | j d q& W| S( NsP SELECT RULE FROM information_schema.mysql_firewall_whitelist WHERE USERHOST='%s'i ( R' Ro R R* ( RW R+ Rq R, ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt get_cached_user_rules s c C s4 | j d | } | s d S| j | j d S( NsE SELECT COUNT(*) CNT FROM mysql.firewall_whitelist WHERE USERHOST='%s'i i ( R' Ro R* ( RW R+ Rq ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt get_rule_count s
c C s* | j d | } | j | j d S( NsX SELECT COUNT(*) CNT FROM information_schema.mysql_firewall_whitelist WHERE USERHOST='%s'i ( R' Ro R* ( RW R+ Rq ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt get_cached_rule_count s
c C s | j d | d S( Ns) CALL mysql.sp_reload_firewall_rules('%s')( R) ( RW R+ ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt reload_rules s c C sN | j d | t j | f \ } } | d k } | rJ | j | n | S( NsF DELETE FROM mysql.firewall_whitelist WHERE USERHOST='%s' AND RULE='%s'i ( R& R Rn R1 ( RW R+ t ruleRq t cntt deleted_something( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt delete_user_rule s
( c C sn | s | j | } n | } | r` | j d | t j | f } | r\ | j | n t St d t S( NsI INSERT INTO mysql.firewall_whitelist (USERHOST, RULE) VALUES ('%s', '%s')s Adding a firewall user rule failed to normalize the query. Probably, the inserted query does not translate to a firewall rule.
( t normalize_queryR& R Rn R1 Rv R Rz ( RW R+ R2 t
normalizedt
firewall_ruleRq ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt
add_user_rule s "
c C sS | j d t j | } | s& t S| j | j d } | d k rO t S| S( Ns SELECT normalize_statement('%s')i R0 ( R' R Rn Rz Ro R* ( RW t queryR, Rq ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR6 s
c C s: | j d | } | s t S| j r6 | j d Sd S( Ns9 SELECT mode FROM mysql.firewall_users WHERE userhost='%s't modet OFF( R' Rz Ro t stringByName( RW R+ Rq ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt
get_user_mode s
c C se | j d | | f } | s# t S| t | d } y] | j r | j d j d r t d | | | j d f t Sn t d t SWn t k
r} | j
j j r | j
j j j
d d d r t d | j
j j t Sd
d l } t d t | j
j j n3 t k
rL} d
d l } t d | j n Xt d
| | f t S( Ns+ CALL mysql.sp_set_firewall_mode('%s', '%s')i t ERRORs9 Firewall: Failed to set user mode (user=%s, mode=%s): %s
s: Firewall: Returning 'True' due to lack of 'ERROR' records
i i i s] Firewall: Returning 'True' due to server ('%s') not responding with the 'OK' record any more
isZ Exception while setting firewall user mode: Expecting 'OK' record for this version ('%s')
s/ Exception while setting firewall user mode: %s
sC Firewall: Failed to set user mode (user=%s, mode=%s): Unknow error
( R) Rz Rh Ro R* t
startswithR R Rv t SystemErrorRH RK t target_versiont# is_supported_mysql_version_at_leastt tracebackt strt Exceptiont
format_exc( RW R+ R; R Rq t errRD t exc( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt
set_user_mode s,
- c C s | j | d S( Nt RESET( RJ ( RW R+ ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt
reset_user s c C s< | j d } | s t S| j r8 | j d d k St S( Ns SELECT @@mysql_firewall_modei ( R' Rz Ro Rp ( RW Rq ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt
is_enabled s ( R R RX R& R' R) R- R. R/ R0 R1 R5 Rz R9 R6 R> RJ RL RM ( ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR q s
t FirewallUserInterfaceBasec B sk e 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 s8 t j j | t d | _ | | _ | j j | _ d S( Ni ( R< R RX Rz t
rule_countRH RK ( RW RH ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyRX * s c C s d S( N( ( RW R R t new_user( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR 0 s c C s d S( N( ( RW R R ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt update_rules3 s c C s | j S( N( RO ( RW ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR/ 6 s c C s d S( N( ( RW t users( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt
refresh_users9 s c C s d S( N( ( RW ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt change_state< s c C s d S( N( ( RW t current_rowR R ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt refresh_row? s c C s d S( N( ( RW ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt
change_layoutB s c C s d S( N( ( RW ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt tweak_user_listE s c C s d S( N( ( RW t tabView( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt
tweak_tabsH s c C s d S( N( ( RW ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt saveK s (
R R RX R RQ R/ RS RT RV RW RX RZ R[ ( ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyRN ) s t FirewallUserInterfaceDummyc B s e Z d Z RS( c C s d S( N( ( RW RH ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyRX P s ( R R RX ( ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR\ O s t FirewallAddRuleDialogc B s5 e Z d Z d Z d Z d Z d Z RS( c C s t j j | d t j t j B | j d | j d d | j t j t
| _ | j | j | j j
t j d t
t t j t j | _ | j j d d | j j
| j t t t
| _ t j t
| _ | j j d | j j | j | j j
| j t t t j t } | j j
| t
t | j d t j | _ | j j d | j j | j | j | j t
t t j | _ | j j d | j j | j | j | j t
t d S(
Ns Add new rule or SQL statementi i, s.
Type the rule you want to add for this user.
i s This is a normalized rulei R R ( R< R RX RN R R R R R R Rz t contentR R R Rv t
newTextBoxt SmallScrollBarst query_boxR7 R t normalized_checkboxRZ R t normalized_clickedR R t ok_buttont ok_button_pressedR t
cancel_buttont cancel_button_pressed( RW RH t
button_box( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyRX U s4
c C s | j j | _ d S( N( Rb R R7 ( RW ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyRc | s c C s | j t d S( N( t end_modalRv ( RW ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyRe s c C s | j t d S( N( Ri Rz ( RW ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyRg s c C s | j d d S( N( R RN ( RW ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR s ( R R RX Rc Re Rg R ( ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR] T s
' t FirewallUserInterfacec B s e Z d Z d Z d Z 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 sv t j | | | j | j | j d | j d t | | _ t | _ t
j t } | j d | j d t
j d | _
| j | j | j
t t t
j t } t
j d } | j | t t | j | t t t
j t } t
j | _ | j j d | j j d | j j d | j j d | j j d d
| j j | j | j t
j d t t | j | j t t | j | t t t
j t } | j d t
j t | _ | j j d d
t
j t } t
j | _ | j j d
| j j | j t
j | _ | j j d | j j | j t
j | _ | j j d | j j | j! t
j | _" | j" j d | j" j | j# t
j | _$ | j$ j d | j$ j | j% | j | j t t | j | j" t t | j | j t t | j | j t t | j | j$ t t | j | j t t | j | t t t
j d | _& | j | j& t t | j | t t t
j t } t
j t | _' | j' j d d | j | j' t t t
j d | _( | j | j( t t | j | t t | j | t t d S( Ni i R0 s Manage the rules for the current user. Changing the mode to RECORDING will start collecting the SQL commands used by your application.
When all the necessary rules were collected, you should set the mode to PROTECTING. You can then fine-tune the set of rules by adding or deleting them.R< t
PROTECTINGt RECORDINGt DETECTINGix is Mode:i t Adds
Add From Files Save To Filet Deletet Resets
Active rules:i s Rules being recorded:() RN RX R R R R R t commandsRz RP R< R R t notet
build_noteR Rv R t stateR R R RT t
newListBoxt
white_listR t white_list_add_buttonRZ R t add_button_clickt white_list_add_from_file_buttont add_from_file_button_clickt white_list_save_to_file_buttont save_to_file_button_clickt white_list_delete_buttont delete_button_clickt white_list_clear_buttont reset_button_clickt available_rules_labelt
cache_listt cached_rules_label( RW RH t firewall_rules_main_boxt info_boxt
info_labelt state_boxt white_list_boxt white_list_button_boxt cache_list_box( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyRX s
c C s d } | j j t | j j t k rD d } | j j t n | j rf d } | j j t n d | } | j j | d S( NR0 s The firewall is currently disabled. You can still manage user rules and modes, but changes will not have any effect until the firewall is enabled again.sS The user is not created yet. Please finish creating the user to makes changes here.s %s
( Rr t showRz Rq RM Rv RP RZ ( RW R> ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyRs s
c C s d t j | | f } | j d t | j j | | j d t | j j | | j d t | j j | d S( Ns %s@%si i i ( R Rn R RE Rq R> R/ R0 ( RW RU R R R+ ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyRV s ""c C sn | | _ | | _ d t j | | f | _ | | _ | j | | j | j j | j
j | j S( Ns %s@%s( t current_usert current_hostR Rn t current_userhostRP R RQ Rt t set_valueRq R> ( RW R R RP ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR s
c C s | j j | j j | j j d t | j j | j x- | j j | j D] } | j j
| qY W| j j d t | j j | j x- | j j
| j D] } | j j
| q W| j d S( NsL Active rules (%s) - These are the rules used in PROTECTED mode for this usersP Rules being recorded (%s) - These are the rules gathered while in RECORDING mode( Rv R R R RZ RE Rq R/ R R- R R R0 R. Rs ( RW R2 ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyRQ s
) ) c C sa | j j j t j d d t | j j j t j d d t | j j j t j d d t d S( Ns FW StateiP s
# FW Ruless
# FW Recorded( RH t user_listR R< R Rz ( RW ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyRX s c C s | j | d d S( Ns Firewall Rules( t add_page( RW RY ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyRZ s c C s d S( N( ( RW RR ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyRS s c C s | j j d S( N( RH R[ ( RW ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyRT s c C s{ t | } | j rw | j j } | j j | j | | j } | sg t j d d d d d n | j
j n d S( Ns
Add user rules^ Add a new rule for this user failed to be inserted. Please check the log for more information.R R0 ( R] R Ra R` Rq R9 R R7 R
R" RH R ( RW t dialogR2 Rq ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyRx " s c C s+ t j t j } | j d | j d d | j r'| j } | j d r\ t n t } t
| / } g | j D] } | j d ^ q~ } Wd QX| j
j | j d s d Sg } x: | D]2 } | j
j | j | | s Pn | j | q W| j
j | j d | j j | n d S( Ns Load firewall ruless9 Firewall Rules (*.fwr)|*.fwr|SQL Statements (*.sql)|*.sqls .fwrs
R< Rl ( R< t FileChoosert OpenFileR t set_extensionsR t get_patht endswithRv Rz t opent readlinest stripRq RJ R R9 R Rv t add_items( RW R t patht
is_rules_filet ft xR^ t added_rulesR2 ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyRz , s"
.
c C s t j t j } | j d | j d d | j r t | j d } xC t d | j j
D]) } | j j | } | j d | qi W| j
n d S( Ns Save firewall ruless Firewall Rules (*.fwr)|*.fwrs .fwrt wi s %s
( R< R t SaveFileR R R R R R Rv t get_countt get_string_value_from_indext writet close( RW R R R R2 ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR| C s
c C sz | j j } g } xN | D]F } | j j | } | j j | j | } | r | j | q q W| j j | d S( N( Rv t get_selected_indicesR Rq R5 R R t remove_indexes( RW t indexest deleted_indexesR R2 Rq ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR~ N s
c C sM t j d d d d d } | rI | j j | j rI | j j qI n d S( Ns Reset user rulessA Reseting the user rules will delete all rules that were collectedt Yest NoR0 ( R
t show_warningRq RL R RH R ( RW Rq ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR X s c C sA | j j | j | j j s= t j d d d d d n d S( Ns Setting user modesQ There was a problem setting the user mode. Please check the log for more details.R R0 ( Rq RJ R Rt R` R
R" ( RW ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR[ ^ s !( R R RX Rs RV R RQ RX RZ RS RT Rx Rz R| R~ R R[ ( ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyRj s _
t SecurityAccountc B s. e Z d Z 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 d Z d Z d Z d Z d Z d Z 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 st t j j | t | j | j | j d | | _ t | _ d | _
d | _ | j | j
d | j d | j j j j d r t j j j j d k r t | | _ n t | | _ t j t | _ t t } | j d t | _ | j j d | j! | j t t | j j" | j# t | _$ | j$ j d | j! | j$ t t | j$ j" | j% t | _& | j& j d | j& j" | j j' | j! | j& t t t | _( | j( j d | j) | j( t t | j( j" | j* t | _+ | j+ j d | j) | j+ t t | j+ j" | j, t t } | j d | j- d
d t. d } | j! | t t t/ t j0 | _1 | j1 j2 t j3 d
d t | j1 j2 t j3 d d t | j j4 | j1 j5 | j1 j6 | j7 | j1 j8 t | j! | j1 t t | j j! | d t t t | _9 } | j d t. d | _: | j: j; t j< | j! | j: t t t= t } | | _> t t } | j d | j
d t? } | j! | t t | j@ d | jA d | jB d | jC d tD | _E | jE j- d d | jE j6 | jF | j j jG r| j j jG jH d d d r| jE jI d n | jE jI d tD t jJ | _K | jK j- d d d | _L tM | jL | _N tO | | jK | jN | j j | _P | jK j6 | jP jQ tD t jJ | _R | jR j- d d | jR j6 | jF tD | _S | jS j- d d | jS j6 | jT | j! tU d d d d d t jV | j! | jE d d d d t jV | j! tM d d d d d t jV t jW B tX g | jY D] } | ^ q d k | _Z | jZ rTtU d! | _[ | j! | j[ d d d d t jV t\ | _] | j] j- d d | j! | j] d d d d t jV | j! tM d" d d d d t jV | j] j6 | j^ g | __ xp | jY D]P }
t` ja |
r-| j] jb t` |
d# n | j] jb |
| j_ jc |
qWn d | __ d | _d tU d$ | _e | j! | je d d d d t jV | j! | jS d d d d t jV t t | _f tg | _h | jf j! | jh t t tM d% | _i | jf j! | ji t t | j! | jf d d d d t jV t jW B tU d& | _j | j! | jj d d d d' t jV | j! | jK d d d d' t jV tM d( | _i | j! | ji d d d d' t jV t jW B | j! | jN d d d' d t jV tU d) | _k | j! | jk d d d d* t jV | j! | jR d d d d* t jV tM d+ | _l | j! | jl d d d d* t jV t jW B | j j jG r
| j j jG jH d d* d r
t | _m | jm j d, | jm jn d- | j! | jm d d d* d t jV | jm j" | jo n d | _m | j! t. d. d d d d t jV | jZ r tD | _d | jd j6 | jF tU d/ | _p tM d0 | _q | j! | jp d d d d t jV | j! | jd d d d d t jV | j! | jq d d d d t jV t jW B t. d. | _r | j! | jr t t n t t | _s | js j d t. d. | _t | jt ju d1 t | _v | jv j d2 | jv jn d3 | jv j" | jw | js j! | jt t t | js j! | jv t t | j) | js t | js jx t | jy | d4 t? } | j
d | jC d | jB d | j@ d' | jA d | j! tU d5 d d d d t jV tD | _z | jz j- d6 d | jz j6 | jF | j! | jz d d d d t jV | j! tM d7 d d d d t jV t jW B | j! tU d8 d d d d t jV tD | _{ | j{ j- d6 d | j{ j6 | jF | j! | j{ d d d d t jV | j! tM d9 d d d d t jV t jW B | j! tU d: d d d d t jV tD | _| | j| j- d6 d | j| j6 | jF | j! | j| d d d d t jV | j! tM d; d d d d t jV t jW B | j! tU d< d d d d' t jV tD | _} | j} j- d6 d | j} j6 | jF | j! | j} d d d d' t jV | j! tM d= d d d d' t jV t jW B | jy | d> t t } t t } | j! | t t | j d | j
d t | _~ | j~ j d? | j! | j~ t t | j~ j" | j | j~ jn d@ t/ t j0 | _ | j j2 t j d. dA t | j j2 t j3 dB dC t | j j2 t j3 dD dE t | j j5 | j! | j t t | j j | j t/ t j0 | _ | j j2 t j d. dA t | j j2 t j3 dF d t | j j5 | j j- d
d | j j | j | j! | j t t | jy | dG t | | _ | jy | j dH | j j | | j! | t t | j j! | d | j! | j t t | j! | t t | j t j j dI | dJ d. | _ | j7 d S(K NR i t mysql_firewall_modet Communitys Add AccountRo t Refresht Applyt Reverti is
User Accountst Userix s From Hostid i sB Select an account to edit or click Add Account to create a new onei i i i i i i i sk Consider using a password with 8 or more characters with
mixed case letters, numbers and punctuation marks.s Login Name:i i i sT You may create multiple accounts with the same name
to connect from different hosts.s Authentication Type:sP
For the standard password and/or host based authentication,
select 'Standard'.
R/ s Limit to Hosts Matching:s % and _ wildcards may be useds Password:i s Type a password to reset it.s Confirm Password:i s Enter password again to confirm.s Expire Passwordsu Force user to change password after next login. The user will be unable to issue any command other than SET PASSWORD.R0 s Authentication String:s* Authentication plugin specific parameters.s #aa3333t Upgrades Upgrade the authentication type of the account, from the obsolete format to the newer, safer one. You must set the password for the account before clicking this button.t Logins
Max. Queries:i< s: Number of queries the account can execute within one hour.s
Max. Updates:s: Number of updates the account can execute within one hour.s Max. Connections:sC The number of times the account can connect to the server per hour.s Concurrent Connections:sJ The number of simultaneous connections to the server the account can have.s Account Limitss Revoke All Privilegess Immediately remove all privileges from the account, from every object at all levels.
The account itself will be left untouched and logins will still be possible.i t Rolei t Descriptioni, s Global Privilegess Administrative Roless Schema Privilegesg?c S s | j j d S( Ni ( R R ( RW ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt <lambda> s ( R< R RX Rz R R t set_nameRH R RN R t _selected_user_originalR R R RK t server_variablesR t grtt roott wbt infot editionRj t firewall_rulesR\ R Rv R R R t
add_buttonRZ R R t add_accountt
del_buttont del_accountR R t save_buttonR t committ
revert_buttont revertR R R R R R R RX R R t
user_selectedt set_allow_sortingt content_boxt
account_labelRA t BoldStyleR t
inner_tabviewR R R R R R R R[ RB RC t set_max_lengtht
PasswordEntryt passwordt password_adviceRC t password_labelRD t password_validatorRe t confirmt
hostlimithostt hostlimithost_changedR@ R R Rh t active_pluginst has_extra_pluginst auth_type_labelR t
auth_type_selt auth_type_changedt auth_type_listt AUTHENTICATION_PLUGIN_TYPESt has_keyR R t auth_string_paramt hostlimithost_captiont
hostlimit_boxR t hostlimithost_valid_icont password_caption2t password_captiont confirm_captiont confirm_caption2t
expire_buttonR t expireR1 t auth_string_desct auth_string_helpt bottom_message_hboxt bottom_message_captionRY t upgrade_account_buttont upgrade_accountR R t
max_questionst max_updatest max_connectionst max_uconnectionsR R t role_listt CheckColumnTypet set_cell_edited_callbackt role_list_toggledt role_priv_listt role_priv_list_toggledR R RZ R R
t add_timeoutt current_action(
RW RH R t account_list_boxR t aboxRY t vboxR R t pluginR t lbox( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyRX e s
1
- $ %",+ " "% "" )"")""")- " % "")
% ",% ",% ",% ",
c C s | j j d S( N( R Rg ( RW ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyRg s c C s2 g | j j j D] \ } } | d k r | ^ q S( Nt AUTHENTICATION( RH RK Ru ( RW R/ t ptype( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR s c C s* | j r& | j t | j j d Sd S( Ni ( R t maxR t get_selected_indexRN ( RW ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt selected_plugin_type s c C s t j | } | s" t d } n | r | j j t | d | j j t | d | j j t | d | j j t | d | j j t | d | j j t | d | j
j t | d | j j t | d | j j t | d | j
r | d r| j j t | j j | d | j j t | j
j t | j j t | r| j j t | j
j t q| j j t | j
j t q| j j t | j j t | j
j t | j j t q n d S( NR: R3 R2 R1 ( R R R R t boolR R R R R R R R R R R Rv RZ R1 R Rz ( RW t auth_typet is_new_userR ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt! update_enable_state_for_auth_type s:
c C s | j j | | j d S( N( R R t validate_hostlimithost( RW t value( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt set_hostlimithost s c C s | j | j d S( N( R R[ ( RW ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR s
c C s | j s
d S| j } | j | t t j | } | sK t d } n | r | d s~ | j j d | j j d n | d s | j d q n | j
d S( NR: R3 R0 R2 R ( R R R Rv R R R R R R R[ ( RW R R ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR s
c C s | j r | j j | j j } | j j s4 t n t d d g f g } x_ | D]T \ } } } | j j } | j d | | k | j d | | j d | qQ Wn d S( Nt Customs custom rolei i i ( R R R t admin_rolest is_custom_role_neededR R t set_boolR ( RW t rolest TheRolesR/ R R R ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt refresh_role_list s
(c C sf | j rb | j | | d k | j d } | j j t | | d k | j | j n d S( Nt 1i ( R R t
get_stringt toggle_privR R R[ ( RW t nodet colR
R ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR s
c C sl | j rh | j | t | | j d } | j j | | d k | j | j | j n d S( Ni R ( R t set_intt intR t toggle_roleR R[ t refresh_priv_list( RW R R R
t role( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR s
c C s' | j j | j j | j d S( N( R R t hostlimitR R[ ( RW ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt host_limit_clicked s c C sg | j j } d } d } | j d k rR | j s7 d S| j j } | j j } n! | rs t | j \ } } n d | _ d | _ | j
d | j j t
| rS| j j d | | f | j j j | | r | j | | qcy | j j j | j
| | Wqct k
rO} t | j d rPt d | | f d SqcXn | j j d d S( NR0 s commit accounts Details for account %s@%ss& Could not load account information fors} Unable to load the account information for %s@%s. Probably the user was not created in the server yet and revert was pressed.sD Select an account to edit or click [Add Account] to create a new one( R R R R R R t evalt get_tagRN R R R R Rz R RZ RH R t is_zombiet show_zombie_usert async_get_accountRF RE R@ R ( RW R R R t e( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR s2
c C s | j j t | j j t | j r< | j j t n | j j t | j j j
| | } | j j d | | d j
| f d S( Ns Account %s@%s does not exist but it still has privileges defined for the following objects:
%s
Click the [Delete] button to completely remove the account.s
( R R Rv R R Rz R R RH R t get_zombie_privsR RZ R ( RW R R R ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR% / s c C s4 | j j t | j j } | r0 | r0 d S| rY t | j d | j k rY d S| j j | d k | j j t | d k o | j
| j | | _ | o | j | _ | r| j j t | j r| j j t | j
o | j n | j j | j | j j | j p)d | j j | j pBd | j | j | j r y | j j | j pwt } WnA t k
rt j j! d d | j" | j f d d d d SX| j# j$ | | j# j | j
| j% j | j& pd | j' | j pd | j
n | j( j t) | j( | j* j t) | j* | j+ j t) | j+ | j, j t) | j- | j. | j/ | j0 j1 | j0 | j2 j1 | j | j | j r| j j
rt3 n t n | j j d | j j d | j j d | j r0| j j t3 n | j d | j% rY| j% j d n | j( j d | j* j d | j+ j d | j, j d xT t4 | j5 j6 D]= } | j5 j7 | } | r| j5 j7 | j8 d t3 qqW| j0 j1 d | j9 j: | j; | j9 j< d | j= | d S( Ni R0 s Invalid Authentication Plugins_ User %s has plugin type %s, which is not listed as a known authentication plugin by the server.R s #000000(> R R Rv R R R" R# R R R RN R R t is_commitedR R t snapshot_for_revertR R R t password_expiredR R R R R R R t auth_plugint DEFAULT_AUTH_PLUGINt
ValueErrorR< R
R t formatted_nameR t set_selectedR t auth_stringR R RE R R R t max_user_connectionsR R R R R Rz R R t countR R R RZ R RY t setup_bottom_message_box( RW R R R t it role_list_node( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR < sv
%%
&
:
#c C st t | j j j } xT t | D]F } | j j | } | | f | j d | j d f k r" | Sq" W| d S( Ni i ( Rh RH R t
account_namesR R R R ( RW R R t users_countR R ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt _find_user_position s *c C s d | _ | j j j } | j | j j d | j | j | j } | d k r | d k r | j j | j j
| n | j | j | j j t | j j t | j j t d | _ d S( Ns add accounti R0 ( R RH R t create_accountR R t set_active_tabR9 R R RN R R R R R[ R R Rz R R ( RW t accountt pos( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR s
c s2 d d } f d } j j j j k rd g } d } j j j r j j j j d d d r | j d d
} n t j
d d j | d
d | } | t j
k r | } | | | t j d d | d
d d j q!d Sn | j j j j j t d S( Ni c sI t j t j d t j d t _ d j f d t | D S( Ns
!@#$%^&*()i R0 c 3 s | ] } t j Vq d S( N( t randomt choice( t .0R5 ( t chars( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pys <genexpr> s ( t stringt
ascii_letterst digitst ost urandomR> t seedR R ( t length( ( RA sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt generate_password s c s | j _ | j _ y j j Wn t k
r^ } t j d t | d d d d St k
r } d d l } t
d | j t j d t | d d d d SXd S( NR R R0 is0 Exception while upgrading account auth type: %s
s% Error Upgrading Authentication Method( R R t confirm_passwordt upgrade_password_formatR R
R" RE RF RD R RG ( R RJ RI RD ( RW ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt change_password s si A password must be provided for the account (either the original or a new one) before it can be upgraded.R0 i i i sx Click [Reset to Expired] to set a random password and expire it, so the user will have to reset it next time they login.s Reset to Expireds Upgrade Authentication Methods
R s Random Generated Passwords Password changed to: %s( R R` R t _orig_passwordRH RK RB RC R R
R R R< t ResultOthert show_messageR R t reload_userRz ( RW RI RL t upgrade_account_msgt reset_to_expire_captionRq t gen_password( ( RW sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR s" -
$
c C s | j r | j j j | j } | j | j | j | j } | rt | d k rt | j j | j j
| n | j n d S( Ni ( R RH R t copy_accountR R9 R R R R R R ( RW R< R= ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt dup_account s
c C s d | _ | j r`| j j sP t j d d | j j d d d t j k rE| j j } y | j j j
| j Wn t k
r } t d t
| t | j d k r | j d n d
t
| f \ } } t j d d | | f d
d d d | _ d SXd | _ d | _ | j j | j j | j t j j j d | qEn | j j } | rEt | j \ } } y$ | j | j j j | | WqEt k
rA} t d t
| t | j d k r| j d n d
t
| f \ } } t j d d | | f d
d d d | _ d SXn | j j t! | j" j t! | j# j t! d | _ d S( Ns delete accounts Delete Accounts= The account '%s' will be permanently removed. Please confirm.Ro R R0 s% Exception while removing account: %s
i i s Error:s Delete accounts %s
%sR s Account '%s' was deleteds+ Exception while removing zombi account: %s
($ R R R) R
RO R/ R< t ResultOkRH R t delete_accountRF R RE Rh t argsR" RN R R t clear_selectiont
do_refreshR R R t set_status_textR R" R# R t do_delete_accountR R Rv R R ( RW t the_nameR' t titleRV R R R ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR sH :#
:# c C s d } | j } | j } | j j | j j | j j | j j j
x | j j j
D] \ } } | j j } | j j j | | r | j
d d | p d n | j
d | p d | j
d | | j t | | f | j j | | | | r[ | | j k r[ | | j k r[ | } q[ q[ W| j j | | _ | | _ | d k ry| j j | | j n | j j | j | j j d | j | d S( Ni s (!) s <anonymous>i s #000000( RN R R R t freeze_refreshR R RS RH R R7 R R$ R t set_tagt reprRV R R t thaw_refreshR R R RZ R RY R4 ( RW t selected_rowt sut suoR R R ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR s2
$
c C s | j j | j r t g t j D]+ \ } } | | j j j k r& | d ^ q& } | j j } xF | D]; } | j j
} | j d | | k | j d | qm Wn d S( Ni i (
R R R t sortedR R RH R R t raw_privilege_namesR R R ( RW t keyt valt all_supported_privsR R R ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR & s
D
c C s | j j } t | _ t | _ t | d k r? t | _ n d } d | k r~ | j d \ } } } | s~ t | _ q~ n | j r t j d t j
} t j d } t j d t j
} | j | | _ | j | p | j | p | j | _ n | j r| r| j r<d t
| k o7d k n p| j rsd t
| k oed k n rs| j pt j d
| ot d | j d D | _ n | j r| j j t n- | j j d
| j j | j j d d S( Ni R0 t /s/ ([a-z]|([%_]\.))(([\-_\.]?[a-z0-9]+)*)[a-z0-9]$s ^(((%|_)?|25[0-5%_]|(%|_)?|2[0-4%_][0-9%_]|[01%_]?[0-9%_][0-9%_]?)\.){0,3}((%|_)?|25[0-5%_]|2[0-4%_][0-9%_]|[01%_]?[0-9%_][0-9%_]?)$s ^\s*(?!.*::.*::)(?:(?!:)|:(?=:))(?:[0-9a-f%_]{0,4}(?:(?<=::)|(?<!::):)){6}(?:[0-9a-f%_]{0,4}(?:(?<=::)|(?<!::):)[0-9a-f%_]{0,4}(?:(?<=::)|(?<!:)|(?<=:)(?<!::):)|(?:25[0-4%_]|2[0-4%_]\d|1\d\d|[1-9%_]?\d)(?:\.(?:25[0-4%_]|2[0-4%_]\d|1\d\d|[1-9%_]?\d)){3})\s*$i i i s \d{1,3}(\.\d{1,3}){3}c s s! | ] } t | d k Vq d S( i N( R ( R@ R ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pys <genexpr>I s t .s mini_error.pngs' Host name contains incorrect characters( R R` Rv t
valid_nameRz t
valid_ipv6Rh t
rpartitionRi t compilet
IGNORECASEt matcht isdigitR t allt splitR R t set_imageR ( RW R t subnet_maskR t allowedt allowed_ipv4t allowed_ipv6( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR 0 s6 -.7%
c C s= | j j t | j j t | j j t t | _ d S( N( R R Rv R R Rz R ( RW ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR[ T s c C s= | j j t | j j t | j j t t | _ d S( N( R R Rz R R Rv R ( RW ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR [ s c C s | j r y | j j Wq t k
r } t | j d k rN | j d n d t | f \ } } t j | | d d d q Xn | j d S( Ni i s Error:R R0 ( R t expire_passwordRF Rh RX RE R
R" R ( RW R' R^ RV ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR b s : c C s | j r t j d d | j j | j j f d d d t j k r y@ | j j | j j | j j | j j | j | j Wq t
k
r } t | j d k r | j d n d t
| f \ } } t j | | d d d q Xq n d S(
Ns Revoke All Privilegess Please confirm revocation of all privileges for the account '%s'@'%s'.
Note: the account itself will be maintained.
Add new privileges afterwards or the user will not be able to access any schema object.t RevokeR R0 i i s Error:R ( R R
RO R R R< RV R t loadR RF Rh RX RE R" ( RW R' R^ RV ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR l s
:c C s | j r1 | j | j j j | j | j n | j j sV | j j j | j n | j | j j
s| | j n | j j
t | j j
t | j j
t | j j d S( N( R R RH R t revert_accountR R) RW R R R R R R Rv R R ( RW ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR z s (
c C s d | _ | j r| j j } | j j } | j sY t j d d | d d d n | j j } t } | j
j | j j r d n | j
t j | j i } | j r | j d t r t } n | r)| j j r)| r)t j d d | | f d
d d t j k r)d | _ d Sn | j } | | k rxt j d d d
d d d d rx| j j | qxn | j j | j _ | j j | j _ | j j | j _ | j j | j _ y: t | j j | j _ | j j d k rt n WnA t k
rIt j d d | j j d d d d | _ d SXy: t | j j | j _ | j j d k rt n WnA t k
rt j d d | j j d d d d | _ d SXy: t | j! j | j _! | j j! d k rt n WnA t k
rEt j d d | j! j d d d d | _ d SXy: t | j" j | j _# | j j# d k rt n WnA t k
rt j d d | j" j d d d d | _ d SX| r| j r| j | j _$ n d | j _& | j j$ r,t | j j$ d r,| j' j | j _& n y | j j( Wn t) k
r{} t j d t* | d d d d | _ d St+ k
r} t j d t* | d d d d | _ d St, k
r} d d l- } t. d | j/ t j d t* | d d d d | _ d SXy | j0 j( Wn\ t, k
r} d d l- } t. d | j/ t j d t* | d d d d | _ d SX| j1 | n | j2 j3 t | j4 j3 t | j5 j3 t d | _ d S( Ns commit accounts Invalid host specificationsJ The host specification "%s" is not valid. Please correct it and try again.R R0 sC Password has expired. User must change password to use the account.R3 s Save Account Changessu It is a security hazard to create an account with no password.
Please confirm creation of '%s'@'%s' with no password.t CreateR sc MySQL only allows lowercase characters for hostnames, the account host will be updated accordingly.R s wb.admin.warn_ucase_hostnamess Don't show this message againi s Wrong Value for Max. Queriess] Cannot convert "%s" to a valid non-negative integer.
Please correct this value and try again.s Wrong Value for Max. Updatess Wrong Value for Max. Connectionss& Wrong Value for Concurrent ConnectionsR1 s Permission Errorsis# Exception while saving account: %s
s Error Saving Account(6 R R R R` R Rm R
R" R) Rz R RZ R+ R R R R R Rv R R R< RV t lowert show_message_and_rememberR R RJ R R R R. R R R R2 R, RN R1 R R[ R RE R RF RD R RG R RP R R R R ( RW R R R
t password_unneededt plugin_infot
lcase_hostRI RD ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR s
%
c C s | j j d S( N( R R ( RW ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR s c C s | s
d Sd } | j r" d } n6 | j r4 d } n$ | j sF d } n | j rX d } n | j j | | j j t | j p | j p | j p | j | j j t | j d S( NR0 s This account is using the pre-mysql-4.1.1 password hashing type.
The user will not be able to login if the secure_auth option is enabled.
Please click [Upgrade Account] to fix that.
Either the account password must be provided to reset it
or a new password must be supplied.sC Password has expired. User must change password to use the account.sM This is an anonymous account. It is usually advisable to delete this account.s$ No password is set for this account.(
t old_authenticationR+ R t blank_passwordR RZ R R R R ( RW R t caption( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR4 s 5c C s | j j } | j j | j j | j j | j | j j | rh t j j
j d | n t j j
j d | d S( Ns Created account '%s's Updated account '%s'( R R/ R} R R R RH R R< R R R[ ( RW R
R] ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyRP s
(# R R RX Rg t propertyR R R R R R R R R R! R R% R R9 R R RU R R R R R[ R R R R R R R4 RP ( ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR d sB 0 #
#
S (
) %
$
} t WbAdminSecurityc B s e Z g 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 RS( c C s | j | d d d S( Nt wba_managements Users and Privileges( t
register_page( t clst
admin_context( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt wba_register3 s c C s d S( Nt admin_manage_privs( ( R ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt
identifier7 s c C s | j j d S( N( t account_tabRg ( RW ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyRg ; s c C ss t j j | t | j | j | | _ d | _ | | _ | | _
t | _ d | _ d | _
d | _ d S( N( R< R RX Rz R R RK RN R t server_profilet main_viewt firewall_enabledt headingt warningR ( RW RK R R ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyRX > s
c C s1 | j j j d } | | j k } | | _ | S( NR ( RK R R R ( RW t current_statust changed( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt firewall_status_changedM s c C s | j | j d | j d | j rI | j | j d | _ n t d | j j d | _ | j | j t
t | j r | j | j d | _ n t
| _ | j | j t
t | j r | j | j d | _ n t | | _ | j | j t t | j d S( Ni i s title_users.pngs Users and Privileges( R R R R t removeRN R R R/ R Rz Rv R R R R R ( RW ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt create_uiS s&
c C s4 | j j d | j j t | j j t d S( Nsz
The account you are currently using does not have sufficient privileges to make changes to MySQL users and privileges.( R RZ R Rv R Rz ( RW ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt show_no_permissionp s c C sq | j j rD t | j | _ | j j t | j j t n) d | _ | j j t | j j t d S( N(
RK Rt R R R R Rz R Rv RN ( RW ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt update_uiv s c C s | j s | j r, | j t | _ n | j | j | j j ry g | j j D]$ \ } } | d k r_ | | f ^ q_ } | r | j
j d t r | j j
j j d } | j j
j j } | j j } n Wqg } d | k sd | k rwt j d d | d d d d
| d | d t j k rx3 | D]( \ } } | j j | j j | | qEWqn3 t j d d
| d d d d
| d d | d t | _ qXn d S( NR0 t already_asked_for_anon_accountst userNamet DELETEs CREATE USERs Anonymous accounts detecteds Anonymous accounts were detected in the server %s.
Anonymous accounts can cause great confusion and are also a potential security issue and are advised to be removed. Would you like Workbench to delete them now?.Ro s Leave Accountss# wb.admin.delete_anonymous_accounts:t @s Don't show this message agains Anonymous accounts were detected in the server %s.
Anonymous accounts can cause great confusion and are also a potential security issue and are advised to be removed. Please ask a DBA to delete them.R s |no_privileges|( t
ui_createdR R Rv R R RK Rt R R7 t __dict__R Rz R t db_connection_paramst parameterValuest hostIdentifiert get_valid_privilegesR
R R< RV R& RW R ( RW R R t
anon_accountst logged_usernamet logged_servernameR R/ ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt page_activated s8
7 & c C sX | j j rT y | j j | j Wn t k
rC | j n Xt j j n d S( N(
RK Rt R R RZ R R R< R
R| ( RW ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR s
c C s- | j j s) | j j | j j n d S( N( R R R R ( RW ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyRZ s
( R R t _schema_priv_entriesRz R t classmethodR R Rg RX R R R R R R RZ ( ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyR / s $
(A Ri R_ t getpassRQ Rx R> RB RE R< R R R R R R R R R R R
R R R
R t wb_admin_utilsR R t wb_admin_security_beR R R R R t wb_commonR t
workbench.logR R R t workbenchR R R R R- Rv RN t getuserRz R R@ RC t objectRD R R R R R RN R\ R] Rj R R ( ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_security.pyt <module> s d(
^m 0&5