| 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 m Z d d l
m Z m Z d d l
Z
d d l Z d d l
m Z d d l m Z m Z m Z d d l Z d d l m Z m Z d d l m Z m Z e d d d
d d d
Z d d l Z d d l Z d Z e j d d d e j e
j d Z! e j d d d e j e
j d Z" e j e
j# e
j$ j% d Z& e j e
j$ j% e
j# d Z' e j d d d d e j( g d d e j e
j e
j$ j% d Z) e j d d d d e j( g d d e j e
j e
j$ j% d Z* e j d! d d" d g d d e j e
j d# Z+ e j d$ d d% d g d d e j e
j d& Z, e j d' d d( d e j( g d d e j e
j e
j$ j% d) Z- e j. d* k rue j e
j d+ Z/ nZ e j. d, k re j e
j d- Z/ n- e j. d. k re j e
j d/ Z/ n d0 Z0 e j d1 d d2 d3 d4 g e j e
j d5 Z1 d6 e j2 f d7 YZ3 e3 a4 e j d8 d d9 e j e
j d: Z5 d; dH d< YZ6 d= e f d> YZ7 d? e f d@ YZ8 dA e f dB YZ9 dC e f dD YZ: dE e f dF YZ; e j e
j e j< e
j$ j% e
j# dG Z= d S(I iN( t get_exe_path( t DefineModulet wbinputs( t log_warning( t log_infot log_errort
log_debug2( t
WizardFormt
WizardPage( t newButtont newCheckBoxt namet PyWbUtilst authors Sun Microsystems Inc.t versions 1.0c C s t j d j d } | s0 d d d g } n xV d d d d g D]B } x9 | D]1 } t j j | | } t j j | rP | SqP WqC Wd S(
Nt PATHt :s /usr/bins /usr/local/bins /bins gnome-terminalt konsolet xtermt rxvt( t ost getenvt splitt patht joint existst None( t pathst termt dt full_path( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyt get_linux_terminal_program1 s
s wb.tools.backupConnectionst captions Backup existing connectionsc C sn t j j j } t j j | d } t j j | d } t j t j j t j
} | j d | j d d | j
t j k rj| j } t | t r | j d } n y t j | d t j } Wn. t k
rt j j d d d
d d d SX| j | d | j | d t j j d
d | d
d d t j k rjt j j | qjn d S( Ns connections.xmls server_instances.xmls Export Connections Ass ZIP Files (*.zip)|*.zipt imports utf-8t ws Backup file creation errorsR Could not create the backup file. Please check path and permissions and try again.t OKt i s Connections saveds0 Your connections were successfully backed up to s Show Filei ( t mformst Appt gett get_user_data_folderR R R t newFileChoosert Formt main_formt SaveFilet set_titlet set_extensionst run_modalt ResultOkt get_patht
isinstancet unicodet encodet zipfilet ZipFilet ZIP_DEFLATEDt Exceptiont Utilitiest
show_errort writet show_messaget ResultOthert reveal_file( t
user_data_dirt connections_patht instances_patht file_choosert backup_patht backup_file( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyt backupConnections? s0
s wb.tools.restoreConnectionss& Restore connections from a backup filec C s d } t j t j j t j } | j d | j d d | j r | j } y,t j
| d } yh t j d t
} | j | j d | j t j d t
} | j | j d | j WnN t k
r)} t j j d d
| j d d d t j d
d
| j d SXt j | j } t | t j s~t j j d d d d d t j d
d d Si } t d t j j j j D } t d t j j j j D }
d } x | D] } | j |
k r| d } qn | | j | | _ | j! | j t j j j | _" | | | j <t j j j j j# | qWt j | j }
t |
t j st j j d d d d d t j d
d t$ | d St d t j j j j% D } t } d } x |
D] } | j& j | k r| d } qn | j! | j& j | | j | | _ | j! | j | j' | j& j d } | j) } | | _& t j j j j% j# | qWt j* j+ j, t j* j+ j- t j* j+ j. | d k s| d k rg } | j# d | d k r| j# d | n | d k rR| d k r>| j# d n | j# d | n | j# d t j j/ d d j0 | d d d n Wq t j1 k
r} t j j d d d d d t j d
d | q t2 k
r} t j j d d d d d t j d
d t3 | q Xn d S( Nc S sE | } d } x2 t r@ | | k r% | S| d | } | d 7} q Wd S( Ni s (%d)( t True( R t name_sett new_namet idx( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyt generate_unique_nameb s s Select a Connections Backup Files ZIP Files (*.zip)|*.zipR! t rt deletes server_instances.xmls connections.xmls Restore Connections ErrorsJ The selected file is not a valid backup file or the file is corrupted: %s.R# R$ t restoreConnectionssF The selected file is not a valid backup file or the file is corrupted.sC The selected archive does not have a valid connection backup file.
c s s | ] } | j Vq d S( N( R ( t .0t conn( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pys <genexpr> s c s s | ] } | j Vq d S( N( t __id__( RN RO ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pys <genexpr> s i i sj Workbench restored %i valid connections but server configuration data could not be found or is not valid.
c s s | ] } | j Vq d S( N( R ( RN t instance( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pys <genexpr> s s Workbench detected s %i duplicated connectionss and s %i duplicated instancess , which were not restored.s Restore ConnectionssJ The selected file is not a valid backup file or the file is corrupted: %s
sH Cannot read from file. Please check this file permissions and try again.s %s
(4 R% R) R* R+ t OpenFileR- R. R/ R1 R5 R6 t tempfilet NamedTemporaryFilet FalseR; t readt closet KeyErrorR9 R: t messaget grtR t unserializeR R2 t Listt sett roott wbt rdbmsMgmtt storedConnsRP t addt ownert appendt lent storedInstancest
connectionR' R t shallow_copyt modulest Workbencht refreshHomeConnectionst saveConnectionst
saveInstancest show_warningR t
BadZipfilet IOErrort str( RJ RB RC RD t instances_filet connections_filet errort connectionst inserted_connectionst existent_connection_namest existent_connection_idst duplicate_connection_countt candidate_connectiont instancest existent_instance_namest previous_instances_connst duplicated_instance_countt candidate_instancet new_connRY ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyRM _ s
""
"
,
!c C s d } | j j d k rC d | j d | j d | j d f } nz | j j d k r d | j d | j d | j d f } n= | j j d
k r d | j d | j d | j d f } n | S( NR$ t MysqlNatives %s@%s:%st userNamet hostNamet portt MysqlNativeSockets %s@%s::%st sockett MysqlNativeSSH( t driverR t parameterValues( RO t connstr( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyt connectionStringFromConnection s +++c C s t } d } t j d | } | rK | j \ } } } } } t } nd \ } } } } } t j | j } | rM| d j d s | d j d rMd }
t } x|
t
| k rF| |
d k r |
d 7}
| |
} nP| |
j d r
| |
d } n,| |
d k r4|
d 7}
| |
} n| |
j d rX| |
d } n | |
d
k r|
d 7}
| |
} n | |
j d
r| |
d } n | |
d k r|
d 7}
| |
} no | |
j d r| |
d } nK | |
d k r|
d 7}
| |
} n$ | |
j d r9| |
d } n |
d 7}
q WqMn | r| ry t | } Wqt
d
d | d } qXn | sd } n t j j } t j j j | _ | | _ | r| d | _ n | d | _ | r| | j d <n | r| | j d <n | r/| | j d <n | rE| | j d <n | j j } x= | j j D], \ }
} | j d |
d t | } qaW| | _ | Sd S( Nc S s; x4 t j j j j d j D] } | j | k r | Sq Wd S( Ni ( RZ R^ R_ R` t rdbmst driversR R ( R R ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyt
get_driver s s0 (.*?)(?::(.*))?@(.*?)(?::([0-9]+|)(?::(.+|))?)?$i t mysqls mysql.exei s -ui s -hs -ps -Ps -St wb_utilss= Error parsing connstring; port value '%s' should be a number
i R R R R R R t %( NNNNN( RU t ret matcht groupsRF R t shlexR t stript endswithRe t
startswitht intR RZ t classest db_mgmt_ConnectionR^ R_ R` Rc R R R t hostIdentifierTemplatet itemst replaceRq t hostIdentifier( R t validR t gt usert passwordt hostR R t tokenst iRO R t keyt value( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyt connectionFromString s &
$ s wb.tools.copyConnectionStrings# Copy Connection String to Clipboardt inputt
pluginMenus Home/Connectionsc C s t | } t j j | d S( N( R R% R9 t set_clipboard_text( RO R ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyt copyConnectionString5 s s! wb.tools.copyJDBCConnectionStrings( Copy JDBC Connection String to Clipboardc C s | j j d r& d | j d } n d } | d | j d 7} | j j d k rt d | j d | j d f } nl | j j d k r d | j d | j d
f } n9 | j j d k r t j j d d
| j d d d d St j j | | d S( Nt schemat /s ?user=%sR R s jdbc:mysql://%s:%sR R R R R s Copy JDBC Connection StringsN Cannot create JDBC connection string for %s. The connection uses a SSH tunnel.R# R$ ( R t has_keyR R R% R9 R: R ( RO t paramsR ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyt copyJDBCConnectionString< s !!
s& wb.tools.createMissingLocalConnectionss Rescan for Local MySQL Instancesc C s t j j j } t j j j | d k rM t j j d d d d d nK | d k rx t j j d d d d d n t j j d d | d d d d S( Ni s Rescan for Local MySQL Serverss% Rescan for local MySQL servers failedR# R$ s No servers were found.s Found %s servers.i ( RZ Ri Rj t createInstancesFromLocalServersRk R% R9 R: R< ( t found_instances( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyt createMissingLocalConnectionsQ s s wb.tools.connectionFromClipboards Add Connection(s) from Clipboardc s t j j } | s d St } x- t j j j j D] } | j t
| q5 Wt } d } xE| j d j
d D]+} t | } | r | r t j j d d | d d d t } qw n t
| | k r t j j d d | d d d qw n d } | j j d
d } xF t f d t j j j j D rdd
| | f | d 7} q W | _ t d | j | d } t j j j j j | qw Wt j j j | d k rt j j d d | d d d n d S( Ni t utf8s
s Add Connection(s) from Clipboards6 Could not parse connection parameters from string '%s'R# R$ s3 The connection %s already exists and was not added.i R t localc 3 s | ] } | j k Vq d S( N( R ( RN RO ( R ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pys <genexpr>~ s s %s (%i)s# Added connection %s from clipboard
s Found %s servers.( R% R9 t get_clipboard_textR] RZ R^ R_ R` Ra Rb R RU R4 R R R: RF R R' t anyR R Rd Ri Rj Rk R< ( t textt existingt cont parse_errorsR t lineRO R t prefix( ( R sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyt newConnectionFromClipboardb s@
+
#s wb.tools.cmdlineClients Start Command Line Clientc
C s d d l } d d l } d | j j j k r d } t j j j | } | d k rw t j
j d d d d d d St j j j | } d } n d | j j j k r| j
d
k r d } n d } d } | j d } | d k r d
} n d | } n8 | j d j d d j d d } | j d } d } | j d j d d j d d } | d k rud } n | j d } | r| j d d j d d } n d } t j j j j j d d }
| j
j d k rB|
st j j j d }
n d | j j |
| | | | | f } | j
d | no| j
j d k r|
s{t j j j d }
n d |
j d d! | | | | | f } t j | d" t n |
st j j j d }
n |
sd }
n d |
| | | | | f } t j d# d$ t d% d& | d' g | j j } d( | k rY| d( d) k sed* | k r|| d+ r|d) | d+ <n t j d# d$ t d% d& | d' g d" t d, | d S(- Nit sshs 127.0.0.1i s Start Command Line Clients" Could not open SSH tunnel to host.R# R$ R t Windowst .t localhostt MySQLs --socket=R s \s \\t "s \"R R i R t mysqlclientt darwinR s& \"%s\" \"-u%s\" \"-h%s\" -P%i %s -p %ss< osascript -e 'tell application "Terminal" to do script "%s"'t windowss mysql.exes3 start cmd /C "%s -u%s -h%s -P%i %s -p %s || pause" t s \ t shells /bin/shs -cs -e 'sf sh -c "while :; do %s && break || read -p \"Press Enter to retry or Ctrl+C to quit\" DUMMY_VAR; done" s ' &t XDG_SESSION_TYPEt waylandt WAYLAND_DISPLAYt GDK_BACKENDt env(! t platformR R R t lowerRZ Ri t DbMySQLQueryt
openTunnelR% R9 R: t
getTunnelPortt systemR R R R^ R_ t optionsR' R& t get_executable_pathR t
expandusert
subprocesst PopenRF t callR t environt copyRU (
RO R R R t tunR R t
socketNameR R t bundled_client_patht commandt my_env( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyt# startCommandLineClientForConnection sl
%
%
! ((
t linux2c C sL t d } | s! t d } n | rD t j | d t d t d Sd Sd S( Ns iodbcadm-gtkt ODBCManageDataSourcesQ4R t close_fdsi i ( R R R RF ( R ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyt startODBCAdmin s R c C sM t j d d t } | d k r9 t j d d t } n | d k rI d Sd S( Ns open -a 'ODBC Administrator'R i s open -a 'ODBC Manager'i ( R R RF ( t ret( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyR s t win32c C s^ t j d k r4 t j d d t d t j d t n& t j d d t d t j d t d Sd S(
Ni i s" %SYSTEMROOT%\SysWOW64\odbcad32.exeR t
creationflagsR s" %SYSTEMROOT%\System32\odbcad32.exei l ( t syst maxintR R RF t CREATE_NEW_PROCESS_GROUP( ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyR s %"c C s t j j j j d k r d n d } t j j j j d k rB d n d } t j j d d | d d d
t j k r t j j | n d S( Nt Communitys) http://dev.mysql.com/downloads/utilities/s> https://edelivery.oracle.com/EPD/Search/get_form?product=18251s
www.mysql.comt eDeliverys MySQL Utilitiess The command line MySQL Utilities could not be located.
To use them, you must download and install the utilities package for your system from %s.
Click on the Download button to proceed.s Download...t CancelR$ (
RZ R^ R_ t infot editionR% R9 R< R0 t open_url( t
utilities_urlt source_description( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyt process_not_found_utils s $s wb.tools.utilitiesShells Start Shell for MySQL UtilitiesR s Others/Menu/Ungroupedc s d d l } d d l | j d k rd } xi d d g D][ } j | sX q= n j j j | d d d } j j | r= | } Pq= q= Wt f d j d j d
D r d } t
j | d t q | r d
| } t
j | d t q t
n| j d k rwt f d j d j d d g D rm j d q t
nt f d j d j d D st
n]t } | r d d l } | j d d d t j j j \ } } j | d } | j d | j d | j d | | j d | j j | d d | k rt
j | d d | g q j j }
d |
k r|
d d! k sd" |
k r|
d# rd! |
d# <n t
j d d$ d% | | f g d t d& |
n t d' d S(( NiR s ProgramFiles(x86)t ProgramFilesR s MySQL Utilitiess mysqluc.exec 3 s0 | ]& } j j j j | d Vq d S( s mysqluc.exeN( R R R ( RN t f( R ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pys <genexpr> s R t ;s start cmd /K "mysqluc"R s start cmd /K "%s"t Darwinc 3 s% | ] } j j | d Vq d S( s /mysqlucN( R R ( RN R ( R ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pys <genexpr>' s R s /usr/local/bins osascript -e 'tell application "Terminal" to do script "mysqluc -e \"help utilities\""' -e 'tell front window of application "Terminal" to set custom title to "MySQL Utilities"'c 3 s% | ] } j j | d Vq d S( s /mysqlucN( R R ( RN R ( R ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pys <genexpr>, s R s delme.t dirs w+s4 echo "The following MySQL Utilities are available:"
s mysqluc -e "help utilities"
s rm -f "%s"
s sh -i
i R s -es /bin/shR R R R s -cs
%s -e %s &R s# Terminal program could not be found( R R R R R R R R R R R R RF R R RS t mkstempR% R& R' R( t fdopenR; RW t chmodR R R RU t RuntimeError( R t guessed_patht varnameR R R RS t fdt setup_scriptR R ( ( R sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyt startUtilitiesShell sV $.
5
.
-
/t CheckForUpdateThreadc B s# e Z d Z d Z d Z RS( c C s) t | _ t | _ t t | j d S( N( RU t
is_runningt finishedt superR t __init__( t self( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyR
H s c C s | j r
d St | _ y7 d d l } d d l } | j | j d | _ Wn/ t k
r~ } d | _ d t | | _ n Xd S( Nis* http://workbench.mysql.com/current-releases8 %s
Please verify your internet connection is available.(
R RF t urllib2t jsont loadt urlopenR8 R Rq Rt ( R R R
Rt ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyt runM s c C s | j r t S| j sS t | d r|t j j d t | j d d d q|n)y t j
j j j
j t j
j j j
j t j
j j j
j f } t d | j d j d D } | | k r't j j d d d j g | D] } t | ^ q d
d d t j k rCt j j d qCn t j j d
d d d d Wn5 t k
r{} t j j d t | d d d n Xt j j j d t | _ t | _ t S( NRt s Check for updates failedR# R$ c s s | ] } t | Vq d S( N( R ( RN R ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pys <genexpr>e s t fullversionR s New Version Availables The new MySQL Workbench %s has been released.
You can download the latest version from
http://www.mysql.com/downloads/workbench.s
Get it Nows Maybe Laters( http://www.mysql.com/downloads/workbenchs MySQL Workbench is Up to Dates< You are already using the latest version of MySQL Workbench.s Ready.( t isAliveRF R
t hasattrR% R9 R: Rq Rt RZ R^ R_ R R t majorNumbert minorNumbert
releaseNumbert tupleR R< R R0 R R8 R& R' t set_status_textRU R R ( R t current_versiont newest_versiont numRt ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyt checkForUpdatesCallback[ s& +<& 5 & ( t __name__t
__module__R
R R ( ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyR G s s wb.tools.checkForUpdatess Check for Updatesc C s^ t j r
d St j r" t a n t j t j j j d t j j
d t j } d S( Ni s Checking for updates...g ?( t threadR R R t startR% R& R' R R9 t add_timeoutR ( t ignore( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyt checkForUpdatesz s
t SSLWizard_GenerationTaskc B sY e Z d Z d Z d Z d Z d d Z e j d Z d Z
d Z RS( c C s | | _ | | _ i | _ d S( N( t mainR t config_file( R R% R ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyR
s c C s4 t d | | f t j j | | d d d d S( Ns %s
%s
R# R$ ( R R% R9 R: ( R t titleRY ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyt
display_error s c C sl y t j j | j j s5 t j j | j j rb t d | j j t j | j j d n t j j | j r t j j | j r | j d d t St j j | j st
j j d d d d d t
j
k r | j d d
t St j | j d n t SWnY t k
rg} | j d d | j t | t t j f | j d k rct St SXd S(
Ns( Creating certificates toor directory[%s]i s Checking requirementss; The selected path is a file. You should select a directory.s Create directorysE The directory you selected does not exists. Do you want to create it?t CreateR R$ s The operation was canceled.s There was an error (%d) - %s
%si ( R R R R% t certificates_roott isdirR t mkdirR( RU R% R9 R< t ResultCancelRF t OSErrort errnoRq t tracebackt
format_exc( R t e( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyt verify_preconditions s$ 2+'2c C s t j j | j d | | j | <t | j | d } | j d | j d j d g | j j j | d | j d S( Ns attribs-%s.txts w+s6 [req]
distinguished_name=distinguished_name
prompt=no
s
s [distinguished_name](
R R R R& t openR; R% t
generate_paget get_attributesRW ( R t targetR ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyt generate_config_file s
#
0i c C sv t j j | | d } t j j | | d } t j j | | d }
t j j | | d } | d d d d t | d d
| d | d | g
} | j | s t d
t | | |
f S| d d | d | g }
| j |
st d
t | | |
f S| d d d | d t | d | d | d | d d |
g }
| j |
sft d t | | |
f St | | |
f S( Ns -key.pems -req.pems -cert.pems .serialt reqs -newkeys rsa:2048s -dayss -nodess -keyouts -outs -configs Unable to generate key.
t rsas -int x509s -reqs -CAs -CAkeys -CAserials -CAcreateserials' Unable to generate certificate serial.
( R R R Rq t run_commandR RU RF ( R t toolt out_patht out_namet ca_certt ca_keyR& t daysR R9 t certt serial_filet req_cmdt rsa_cmd( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyt generate_certificate s& 3
'
c C s y t j d k r t n t } t j | d | d t j d | } | j } | j d k r t d t
| | j t
| f t St SWn^ t k
r } t d t
| j t St
k
r } t d t
| t
| f t SXd S( NR t stdoutt stderrR i s, Running command: %s
Output(retcode: %d):
%s
s) Running command: %s
ValueError exception
s" Running command: %s
Exception:
%s
( R R RF RU R R t PIPEt communicatet
returncodeR Rq t
ValueErrort cmdR. ( R R t output_tot set_shellt pt outR2 ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyR< s $ & c C si d } d } t j j | d } t j j | d } t d | | j | d g s | j d d | t d d d d d f St j j | j s | j d d t d d d d d f St d
t | d } | j | d d
g | s| j d d t d d d d d f St d | d d d d d t
| d | d | d | j d g
} | j | s| j d d t d d d d d f St d | j | | d | | | j d \ } }
} } | s| j d d t |
| | f St d | j | | d | | | j d! \ } }
} } | sS| j d" d t |
| | f St
| | |
| |
f S(# Ni t openssls
ca-key.pems ca-cert.pems Checking tool availability(%s)
R s Checking requirementss The SSL tool (%s) is not available. Please verify if it's installed and the installation directory is in the PATH environment variables' The specified directory does not exist.s Creating CA certificate...
R" t genrsat 2048s Creating CA certificate...s" Could not generate RSA certificates Creating CA key...
R9 s -news -x509s -nodess -dayss -keys -outs -configt CAs Could not generate keyss( Create server certificate and self-sign
t servert Servers' Create server certificate and self-signs) Create client certificates and self-sign
t clientt Clients( Create client certificates and self-sign( R R R R R< R( RU R R R4 Rq R& RG RF ( R R R& RB R= RA R@ R RE t resultt
server_keyt
server_reqt server_certt
client_keyt
client_reqt client_cert( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyt generate s@
:
1
1c C s t | _ | j s t S| j d | j d | j d | j | j | j \ | _ | _ | _ | _ | _
| _ t S( NRV RX RZ (
RU R[ R3 R8 Rb R R& R@ R^ R\ Ra R_ RF ( R ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyR s
<( R R R
R( R3 R8 RG R RJ R< Rb R ( ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyR$ s /t SSLWizard_IntroPagec B s# e Z d Z d Z d Z RS( c C s t j | | d d S( Ns% Welcome to MySQL Workbench SSL Wizard( R R
( R Rc ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyR
s c C s | j j d S( N( R% t finish( R ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyt go_cancel s c C s t j t } | j d | j d d } | d 7} | d 7} t j | } | j | t t | j j | t t | j t d S( Ni sj This wizard will assist you to generate a set of SSL certificates and self-signed keys that are required
sd by the MySQL server to enable SSL. Other files will also be generated so that you can check how to
sR configure your server and clients as well as the attributes used to generate them.(
R% t newBoxRU t set_paddingt set_spacingt newLabelRb RF t contentt show( R t boxRY t label( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyt create_ui# s
( R R R
Re Rn ( ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyRc s t SSLWizard_OptionsPagec B s5 e Z d Z d Z d Z d Z d Z RS( c C s t j | | d t | _ | j j d | j j | j | j j | j t | _ | j j d | j j t t | _
| j
j d | j
j t t | _
| j
j d | j
j | j | j
j t j j | j j d S( Nt Optionss. Generate new certificates and self-signed keyss Update the connections Use default parameterss Clear Files( R R
R
t generate_filest set_textt
set_activet check_all_files_availabilityt set_enabledt update_connectionRF t use_default_parametersRU R t clear_buttont add_clicked_callbackt clear_button_clickedR R R+ R% t results_path( R Rc ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyR
3 s c C s | j j d S( N( R% Rd ( R ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyRe H s c C s t j j | j j s t St j j t j j | j j d sG t St j j t j j | j j d sr t St j j t j j | j j d s t St S( Ns ca-cert.pems client-cert.pems client-key.pem( R R R+ R% R{ RU t isfileR RF ( R ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyRt K s '''c C s x t j | j j D]x } t j j | j j | } y& t j j | r\ t j | n Wq t k
r } t d | t
| f d SXq W| j j t
| j j t | j j d S( Ns' SSL Wizard: Unable to remove file %s
%s( R t listdirR% R{ R R R| t unlinkR8 R Rq Rq Rs RF Ru RU t generate_files_changed( R t filenamet filepathR2 ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyRz W s c C s# t j t } | j d | j d d } | d 7} | d 7} t j | } | j | t t | j | j t t | j | j t t | j | j
t t t j t } | j d | j d | j | j t t | j j | t t | j j | t t | j
t d S( Ni sQ These options allow you to configure the process. You can use default parameters
sV instead of providing your own, allow the generation of the certificates and determine
s1 whether to update the connection settings or not.( R% Rf RU Rh Rg Ri Rb RF Rw Rq Rv Rx Rj Rk ( R Rl RY Rm t
button_box( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyRn e s$
( R R R
Re Rt Rz Rn ( ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyRo 2 s
t SSLWizard_GeneratePagec B sG e Z d Z d Z d Z d Z d Z d Z d Z RS( c C s t j | | d t j j | j j d j d d | _ t j j | j j d j d d | _ t j j | j j d j d d | _
t j j | j j d j d d | _ t j j | j j d j d d | _ t
j | _ | j j d | j j d
| j j d | j j d | j j d
| j d d d \ } | _ | j | d d \ } | _ | j | d d \ } | _ | j | d d \ } | _ | j | d d \ } | _ | j | d d \ } | _ | j | d d \ } | _ d } | d 7} t
j t | _ | j j d | j j d t
j! | | _" t
j# t
j$ | _% | j% j& d | j% j' | j | j j' | j" t t( | j j' | j% t t( t
j! d! | _) d S(" Ns* Generate certificates and self-signed keyss ca-cert.pems \R s server-cert.pems server-key.pems client-cert.pems client-key.pemi i i i i i s Country:s 2 letter country code (eg, US)s State or Province:s Full state or province names Locality:s eg, citys
Organization:s eg, companys
Org. Unit:s eg, section, departments Email Address:R$ s Common:sA eg, put the FQDN of the server
to allow server address validations_ Now you must specify the parameters to use in the certificates and self-signed key generation.
sh This may include some data refering to youself and/or the company you work for. All fields are optional.i s Optional Parameterss| The wizard is ready to generate the files for you. Click 'Next >' to generate
the certificates and self-signed key files...(* R R
R R R R% R{ R R@ R^ R\ Ra R_ R% t newTablet tableRg t set_column_countt
set_row_countt set_row_spacingt set_column_spacingt
add_label_rowt country_codet
state_namet
locality_namet org_namet org_unitt
email_addresst common_nameRf RU t parameters_boxRh Ri t parameters_labelt newPanelt TitledBoxPanelt parameters_panelR- Rb RF t
default_label( R Rc t rowRY ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyR
s> *****
c C s t j } | j j t j | t d d | | d t j | j j | d d | | d t j t j B t j | } | j t j | j j | d d | | d t j | j
d d | d | f S( Ni i i i id i( R% t newTextEntryR Rb Ri RF t HFillFlagt HExpandFlagt set_stylet SmallHelpTextStylet set_size( R R Rm t helpt controlt l( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyR s 2-&c C s+ | j j t | | j j | d S( N( R Rk t boolR ( R R ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyt set_show_parameters s c C sG g } | j d | j j j d | j d | j j j d | j d | j j j d | j d | j j j d | j d | j j j d | j d | j j j d | f | j d | j j j d g | D] } | j
d d
r| ^ q} | sC| j d n | S( Ns C=%ss utf-8s ST=%ss L=%ss O=%ss OU=%ss CN=%s-%ss emailAddress=%st =is C=US( Rd R t get_string_valueR4 R R R R R R t partition( R R7 R t s( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyR6 s #####)#,c C s6 | j j | j t t | j j | j t t d S( N( Rj Rb R RU RF R ( R ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyRn s c C s | j j d S( N( R% Rd ( R ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyRe s c C s t d | j j t | j | j j } | j | j t k rI d S| j | _ | j | _ | j | _ | j
| _
| j | _ t t
j j | j j d d } | j d i t
j j d t
j j | j j d d d 6t
j j d t
j j | j j d d d 6t
j j d t
j j | j j d d d
6t
j j d t
j j | j
j d d d 6t
j j d t
j j | j j d d d 6 | j t d
t | j | j j d S( Ns Setting up in path %s
s
my.cnf.samples w+s # Copy this to your my.cnf file. Please change <directory> to the corresponding
# directory where the files were copied.
[client]
ssl-ca=%(ca_cert)s
ssl-cert=%(client_cert)s
ssl-key=%(client_key)s
[mysqld]
ssl-ca=%(ca_cert)s
ssl-cert=%(server_cert)s
ssl-key=%(server_key)s
s <directory>s \R R@ R^ R\ Ra R_ s& SSL Wizard generation task result: %s
( R R% R{ R$ R R[ RU R@ R^ R\ Ra R_ R4 R R R R; t basenameR RW Rq t go_next_page( R t taskR ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyt go_next s(
$ 71116
( R R R
R R R6 Rn Re R ( ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyR s +
t SSLWizard_ResultsPagec B s, e Z d Z d Z d Z d Z RS( c C s t j | | d t | _ d S( Nt Results( R R
RF Rv ( R Rc ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyR
s c C s
| | _ d S( N( Rv ( R R ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyt set_update_connection s c C s | j r | j j j j d d | j j j d <| j j j j d d | j j j d <| j j j j d d | j j j d <d | j j j d <n | j j d S( Ns \R t sslCAt sslCertt sslKeyi t useSSL(
Rv R% R5 R@ R RO R Ra R_ R ( R ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyR s (((c C s d } | j r | d 7} n | d | j j j d 7} | d t t j j | j j d j d d 7} | d t t j j | j j d j d d 7} | d t t j j | j j d
j d d 7} | d 7} t
j | } | j j
| t t t t j j | j j d d
} t
j t
j } | j | j | j d d | j j
| t t | j t
j d t t j j | j j d j d d } | j j
| t t d S( Ns The wizard was successful. s5 Click on the finish button to update the connection. sW To setup the server, you should
copy the following files to a <directory> inside %s:
R s - %s
s ca-cert.pems \R s server-cert.pems server-key.pems;
and edit the config file to use the following parameters:s
my.cnf.sampleRK ii s' A copy of this file can be found in:
%s( Rv R% RO R Rq R R R R{ R R% Ri Rj Rb RU RF R4 t
newTextBoxt VerticalScrollBart set_valueRV R RW ( R RY Rm R R& ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyRn s&
555
$
:( R R R
R R Rn ( ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyR s t SSLWizardc B s e Z d Z d Z RS( c s t j | | _ | _ t j j t j j j
d _ t j j j j _ j
d t _ j j t _ j j t _ j j t _ j j j j j j j j j j j j j j j j j j j j f d j j j f d j j j f d d S( Nt certificatess
SSL Wizardc s j j j j j S( N( R5 R t options_pageRw t
get_active( ( R ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyt <lambda>? s c s j j j j j S( N( t results_pageR R Rv R ( ( R ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyR @ s c s
j S( N( R ( ( R ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyR A s ( R R
RO t conn_idR R R R% R& R' R( R* R{ R- Rc t
intro_paget add_pageRo R R R5 R R R Rw R R Rv t skip_pageRq Ry ( R t parentRO R ( ( R sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyR
# s( '
c C s! | j j | j j j d S( N( R5 R R Rq R ( R ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyR C s ( R R R
R ( ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyR " s c C s y~ t d t | t j j j t | j | f t j | } t d t | t | | | } | j t
Wn3 t k
r } t d t | t
j f n Xd S( NsN Running SSL Wizard
Parent: %s
User Folder: %s
Conn Parameters: %s
Conn ID: %s
s Running SSL Wizard
%s
s1 There was an exception running SSL Wizard.
%s
%s( R Rq R% R& R' R( R t fromgrtR R RF R8 R R0 R1 ( R RO R RQ RK R2 ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyt generateCertificatesG s 8( (> R R R R t threadingR5 RS R t workbench.utilsR R_ R R RZ R% R t
workbench.logR R R R0 t workbench.uiR R R R
t
ModuleInfot wb_model_utilst wb_catalog_utilsR t plugint exportt INTRE RM t STRINGR R R R t selectedConnectionR R R R R R R R R t ThreadR R R# R$ Rc Ro R R R R* R ( ( ( sE C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_utils_grt.pyt <module> sp q$$V'''' +''K :1 Mv-%