K^FSrSSKJr SSKJr SSKJr SSKrSSKJr SSK J r SSK J r SS K Jr SSK J r SS K Jr SS K Jr SS K Jr SS KJr SSKJr SSKJ r SSKJr SS KJr SSKJr SSKJr SSKJr SSKJ r SSKJ!r! SSKJ"r" Sr#S\#S.r$S\#S.r%S(Sjr&Sr'Sr(Sr)S)Sjr*S*Sjr+S*S jr,S*S!jr-\R\\R^"\R`Rb5"S"S#\Rd555r3\R\\R^"\R`Rh5"S$S%\Rd555r5\Rl\R^"\R`Rn5"S&S'\Rd555r8g)+!Connects to a Cloud SQL instance.)absolute_import)division)unicode_literalsN)client) exceptions)api_util) constants) instances)network) operations) arg_parsers)base)flags)log) properties)files) iso_duration)retry)textz\ To connect to a Cloud SQL instance, run: $ {command} my-instance --user=root ag Connects to a Cloud SQL instance. This command temporarily changes the authorized networks for this instance to allow the connection from your IP address. This command isn't supported for Cloud SQL instances with only private IP addresses. NOTE: If you're connecting from an IPv6 address, or are constrained by certain organization policies (restrictPublicIP, restrictAuthorizedNetworks), consider running the beta version of this command to avoid error by connecting through the Cloud SQL proxy: *gcloud beta sql connect* ) DESCRIPTIONEXAMPLESz3 Connects to a Cloud SQL instance. c[R"5nSRU5nURSU[R "US9R U5RSS9R5SS9nURRURURURS95nS UlUR2R4R6R9U5 UR;UURURS 9n URR=U 5n URCS U RDURS9n SRU[FRH"US55n [JRLROXU 5 U$![Raln U R ["R$:Xa3[&R("S RUR+555e[,R."U 5eS n A ff=f![Ra1n [>R@"S 5 [,R."U 5eS n A ff=f)aAdd CLIENT_IP to the authorized networks list. Makes an API call to add CLIENT_IP to the authorized networks list. The server knows to interpret the string CLIENT_IP as the address with which the client reaches the server. This IP will be allowlisted for 1 minute. Args: instance_ref: resources.Resource, The instance we're connecting to. sql_client: apitools.BaseApiClient, A working client for the sql version to be used. sql_messages: module, The module that defines the messages for the sql version to be used. resources: resources.Registry, The registry that can create resource refs for the sql version to be used. minutes: How long the client IP will be allowlisted for, in minutes. Returns: string, The name of the authorized network rule. Callers can use this name to find out the IP the client reached the server with. Raises: HttpException: An http error response was received while executing api request. ResourceNotFoundError: The SQL instance was not found. zsql connect at time {0}z sql#aclEntry)minutesi') microsecond CLIENT_IP)kindnameexpirationTimevalueprojectinstancezMThere was no instance found at {} or you are not authorized to connect to it.N)databaseInstancer"r#aIf you're connecting from an IPv6 address, or are constrained by certain organization policies (restrictPublicIP, restrictAuthorizedNetworks), consider running the beta version of this command by connecting through the Cloud SQL proxy: gcloud beta sql connectzsql.operations) operationr"z8Allowlisting your IP for incoming connection for {0} {1}minute)(r GetCurrentTimeformatAclEntryrDurationGetRelativeDateTimereplace isoformatr GetSqlInstancesGetRequestr"r#apitools_exceptions HttpError status_code http_client FORBIDDENrResourceNotFoundError RelativeNamecalliope_exceptions HttpException serverCaCertsettingsipConfigurationauthorizedNetworksappendSqlInstancesPatchRequestPatchrwarningCreaterr Pluralizer OperationsV1Beta4WaitForOperation) instance_ref sql_client sql_messages resourcesrtime_of_connectionacl_nameuser_acloriginalerror patch_requestresult operation_refmessages lib/surface/sql/connect.py_AllowlistClientIPrSRs9:--/ & - -.@ A(  " "  !**../AB w5w!))+ # ( 3##''++ ((<3H3H , JKH( ##66==hG 3 99!$$&&:(M ! ! ' ' 6F""&++|7K7K#M-vgt~~gx'HI  // 079 /E  & &3 K111  , , !6,";";"=> @@  + +E 22 3"  & &3KK "#  + +E 223s26=F*AHH,A'HHI /,II c,URRURRURUR S95nUR RRnSnUH#nURU:XdMURn X54$ X54$)z4Retrieves given instance and extracts its client ip.r!N) r r.MESSAGES_MODULEr/r"r#r:r;r<rr )rErFrJ instance_infonetworks client_ipnets rR _GetClientIPrZs&&**  77&&1F1F8HI- # # 3 3 F F() c xx8))i  !!   !!cfURS[RSS9 URSSSSS9 g ) zDeclare flag and positional arguments for this command parser. Args: parser: An argparse parser that you can use it to add arguments that go on the command line after this command. Positional arguments are allowed. r#Cloud SQL instance ID. completerhelp--user-uF&Cloud SQL instance user to connect as.requiredr`N) add_argument sql_flagsInstanceCompleterparsers rR AddBaseArgsrksG ++ #%    3 5r[cjURS[R"SSS9[RSS9 g)zDeclare beta flag arguments for this command parser. Args: parser: An argparse parser that you can use it to add arguments that go on the command line after this command. Positional arguments are allowed. --port lower_bound upper_boundUPort number that gcloud will use to connect to the Cloud SQL Proxy through localhost.typedefaultr`N)rfr BoundedIntr DEFAULT_PROXY_PORT_NUMBERris rR AddBetaArgsrys8   ! !aU C11 ' )r[cURS[RSS9 URS[R"SSS9[ R SS 9 URS 5nURS S S S9 URSSSSS9 URSS SS9 URSS SS9 URSS SS9 URS5nURSS SS9 URSS SS9 URSS S S9 g!)"zDeclare alpha flag arguments for this command parser. Args: parser: An argparse parser that you can use it to add arguments that go on the command line after this command. Positional arguments are allowed. r#r]r^rmrnrorprsrtz7User selection settings for Cloud SQL Proxy connection.--auto-iam-authn store_truezTEnables IAM database authentication for connections to MySQL and Postgres instances.)actionr`rarbFrcrd --skip-sslz6Skip SSL certificate verification for MySQL instances.z --debug-logsz.Enable verbose debug logs for Cloud SQL Proxy.z--run-connection-testz(Run connection test for Cloud SQL Proxy.z=IP address selection settings for Cloud SQL Proxy connection.z --private-ipz3Connect to the Cloud SQL instance using private IP.z--pscz@Connect to the Cloud SQL instance using Private Service Connect.z --auto-ipz9Connect to the Cloud SQL instance with auto IP detection.N)rfrgrhrrwr rxadd_mutually_exclusive_group)rj user_groupip_groups rRAddProxyV2Argsrs} ++ #%    ! !aU C11 ' ) 22?A*   !"    3 5    CE   ;=   57  0 0EG(   @B   MO   FHr[c[R"[R5nURnURn[ R "X5n[XSUUR5n[R"SSS9nUR[XSU/SSS9upUR R"R%S5Sn [&R(R+U S 5n [,R."U 5n U (d4[R0"S R3U R55U 55e[6R8"U 5n U [6R::XaWUR<R>R@(aURBSRDnOOS n[RF"U5eU [6RH:Xa URJnO[RF"S 5e[&RLU nURN(a URNn[&RPU nU US U/nURSUSU/5 SU;aURUUS5 U(a&URS[ RV"UU55 [ RX"UU5 g![Ra [R"S5ef=f)aConnects to a Cloud SQL instance directly. Args: args: argparse.Namespace, The arguments that this command was invoked with. supports_database: Whether or not the `--database` flag needs to be accounted for. Returns: If no exception is raised this method does not return. A new process is started and the original one is killed. Raises: HttpException: An http error response was received while executing api request. UpdateError: An error occurred while updating an instance. SqlClientNotFoundError: A local SQL client could not be found. ConnectionError: An error occurred while trying to connect to the instance. ) max_retrialsexponential_sleep_multipliercUSSL$)Nrn)xss rR#RunConnectCommand..4s QqTT\r[i)should_retry_ifsleep_mszLCould not allowlist client IP. Server did not reply with the allowlisted IP._rmysql~{0} client not found. Please install a {1} client and make sure it is in PATH to be able to connect to the database instance.zIt seems your client does not have ipv6 connectivity and the database instance does not have an ipv4 address. Please request an ipv4 address for this database instance.z Could not connect to SQL server.hostnameuserpasswordN)-r SqlClientAPI_VERSION_DEFAULTrFrGinstances_command_utilGetInstanceRefrSresource_parserrRetryer RetryOnResultrZRetryExceptionr UpdateErrordatabaseVersionrsplitr DB_EXEgetrFindExecutableOnPathSqlClientNotFoundErrorr(titler GetIpVersion IP_VERSION_4r:r; ipv4Enabled ipAddresses ipAddressConnectionError IP_VERSION_6 ipv6AddressDEFAULT_SQL_USERr EXE_FLAGSextendr=GetDatabaseArgsConnectToInstance)argssupports_databaserrFrGrErJretryerrVrXdb_typeexe_nameexeip_type ip_addressrQsql_userrsql_argss rRRunConnectCommandrs|$   h:: ;&  *$$,'66tD,  , & 6 68( MMqq I'G&44 8,1 5 M  ) ) . . 4 4S 9! <'    ! !'7 3( ""8,#  + + HHN NN hI( ))   +' $$$--99 ,,Q/99jNg  & &w //'&&&**J  $ $%G HH ' ' 1( YYyyH   h '%j): 6( //5=(+,5 OOE*%& OO*::4GH**8X>[   G  "F GGGs J,,+Kc[R"[R5nURnURn[ R "X5nURRURURURS95n[R"XF5(d [X5$[R "S5nU(d["R$"S5eUR&R(R+S5Sn[,R.R1US5n [R "U 5nU(d4["R2"SR5U R75U 55e[9UR:5n [R<"Xj5n [>R@"U RB5 [,RDU n URF(a URFn [,RHU n U /nU S:Xa(S R5U 5nURKU S U/5 OURKU S S U S U /5 URKU S U /5 SU ;aURMU S5 U(a%URK[ RN"X 55 [ RP"X5 U RC5 g)aConnects to a Cloud SQL instance through the Cloud SQL Proxy. Args: args: argparse.Namespace, The arguments that this command was invoked with. supports_database: Whether or not the `--database` flag needs to be accounted for. Returns: If no exception is raised this method does not return. A new process is started and the original one is killed. Raises: HttpException: An http error response was received while executing api request. CloudSqlProxyError: Cloud SQL Proxy could not be found. SqlClientNotFoundError: A local SQL client could not be found. ConnectionError: An error occurred while trying to connect to the instance. r!cloud_sql_proxyaCloud SQL Proxy (v1) couldn't be found in PATH. Either install the component with `gcloud components install cloud_sql_proxy` or see https://github.com/GoogleCloudPlatform/cloud-sql-proxy/releases to install the v1 Cloud SQL Proxy. The v2 Cloud SQL Proxy is currently not supported by the connect command. You need to install the v1 Cloud SQL Proxy binary to use the connect command.rrrrsqlcmdtcp:127.0.0.1,{0}r 127.0.0.1portrrN))r rrrFrGrrr r.r/r"r#instances_api_util IsInstanceV2rrrrCloudSqlProxyErrorrrrr rrrr(rstrrStartCloudSqlProxyatexitregisterkillrrrrr=rr)rrrrFrGrErVrrrr proxy_processrrrrs rRRunProxyConnectCommandrfsa&   h:: ;&  *$$,'66tD,&&**))&&1F1F*HI-  ( ( E E T 55 ""#45#  ' ' & ''  ) ) . . 4 4S 9! <'    ! !'7 3( ""8,#  + + HHN NN hI( )) TYY$$77 L-//-$$% ' ' 1( YYyyH   h '%Z( "))$/H OOU:&12 OOU:& U6]DIJ //5=(+,5 OOE*%& OO*::4GH**8>r[c  [R"[R5nURnURn[ R "X5nURRURURURS95n[R"XF5(d [X5$[R "S5nU(d["R$"S5eUR&R(R+S5Sn[,R.R1US5n [R "U 5nU(d4["R2"SR5U R75U 55e[9USS 5n U (aU S :Xa[:R<"S S 5e[9US S 5n U (aU S:wa[:R<"SS5e[?UR@5n [BRDRFRHR5n [9USS 5n[9USS 5n[9USS 5n[9USS 5n[9USS 5n[RJ"UU U U UUUUUS9 n[LRN"URP5 U(aURQ5 gU (aU nU(d1[BRDRRRTRSS9nU S:XaUR+S5SnO`U S:Xa(URWS5(aURYSS5nO1URZ(a URZnO[,R\U n[,R^U nU /nU S :Xa(SR5U 5nURaUSU/5 OURaUSSUS U /5 URaUS!U/5 S"U;aU (dURcUS"5 U(ajU S:Xa(URd(a[:R<"S#S$5e[ Rf"UU5nU(d U S:XaUS%S&/nURaU5 U (aU S:XaURcS5 [ Rh"UU5 URQ5 g)'aConnects to a Cloud SQL instance through the Cloud SQL Proxy (v2). Args: args: argparse.Namespace, The arguments that this command was invoked with. supports_database: Whether or not the `--database` flag needs to be accounted for. Returns: If no exception is raised this method does not return. A new process is started and the original one is killed. Raises: HttpException: An http error response was received while executing api request. CloudSqlProxyError: Cloud SQL Proxy (v2) could not be found. SqlClientNotFoundError: A local SQL client could not be found. ConnectionError: An error occurred while trying to connect to the instance. r!zcloud-sql-proxyzCloud SQL Proxy (v2) couldn't be found in PATH. Either install the component with `gcloud components install cloud-sql-proxy` or see https://github.com/GoogleCloudPlatform/cloud-sql-proxy/rrrrauto_iam_authnFrr{zIThe --auto-iam-authn flag is only valid for MySQL and Postgres instances.skip_sslr~z6The --skip-ssl flag is only valid for MySQL instances. private_ippscauto_ip debug_logsrun_connection_test)impersonate_service_accountrrrrrrNT)re@psqlz.gserviceaccount.comrrrrrrz --databasezIThe --database flag is only valid for PostgreSQL or SQL Server instances.databasepostgres)5r rrrFrGrrr r.r/r"r#rrrrrrrrrrr rrrr(rgetattrr7InvalidArgumentExceptionrrrVALUESauthrStartCloudSqlProxyV2rrrcoreaccountendswithr,rrrrr=rrr)rrrrFrGrErVrrrrrrrrrrrrr database_userrrrdb_argss rRRunProxyV2ConnectCommandrsC$   h:: ;&  *$$,'66tD,&&**))&&1F1F*-  ( ( E E T 55 ""#45#  ' ' B   ) ) . . 4 4S 9! <'    ! !'7 3( ""8,#  + + HHN NN hI  4!159.H,  6 6   T:u -( (g%  6 6N  TYY$88<<>t\51*eU## D)U +'t\51*&;UC$99 "=# - /- //-$$% /M  '',,4488$8Gm7#))#.q1m V  6 67M N N#++,BBGm yyIIM..x8M   h '%Z( "))$/H OOU:&12 OOU:& U6]DIJ //5=-015 OOE*%&7t}}  8 8    %44T5AG x6)z"J/g OOG (g% OOL!**8]Cr[c2\rSrSrSr\r\S5rSr Sr g)ConnectiJrcH[U5 [R"US5 g)@Args is called by calliope to gather arguments for this command.z&The SQL Server database to connect to.N)rkrg AddDatabaseris rRArgs Connect.ArgsQs  8:r[c[USS9$rT)r)rselfrs rRRun Connect.RunXs TT ::r[rN) __name__ __module__ __qualname____firstlineno____doc__DETAILED_GA_HELP detailed_help staticmethodrr__static_attributes__rr[rRrrJs#*"-:: ;r[rc2\rSrSrSr\r\S5rSr Sr g) ConnectBetai]rcH[U5 [R"US5 grz4The PostgreSQL or SQL Server database to connect to.Nrrgrris rRrConnectBeta.Argsds!6 FHr[c[USS9$rrrs rRrConnectBeta.Runk #DD AAr[rN rrrrrDETAILED_ALPHA_BETA_HELPrrrrrrr[rRrr]s&**-HH Br[rc2\rSrSrSr\r\S5rSr Sr g) ConnectAlphaiprcH[U5 [R"US5 grrris rRrConnectAlpha.Argsws 6 Fr[c[USS9$rrrs rRrConnectAlpha.Runrr[rNrrr[rRr r ps$**-Br[r ))returnN)F)9r __future__rrrrhttprr3apitools.base.pyrr0googlecloudsdk.api_lib.sqlr r r rr r googlecloudsdk.callioperrr7googlecloudsdk.command_lib.sqlrrgrgooglecloudsdk.corerrgooglecloudsdk.core.utilrrrrrrrrSrZrkryrrrrDefaultUniverseOnly ReleaseTracks ReleaseTrackGACommandrBETArUniverseCompatibleALPHAr rr[rRr s(&' &>/01F.1/(E=N#**1*)  #,   ! Rj "5& )8HvQ?j.3RjL^D%%(();dll;*;"D%%**+B$,,B,B"D%%++,B4<<B-Br[