!bK-      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~     None "#&'-.=?Hstrongswan-sqlThe managed IPsec configuration type encompasses a complete set of elements which are pushed and interlinked as necessary by the Managedf API (see above). Note that there are lenses available to facilitate accessing all these fields (see StrongSwan.SQL.Lenses)strongswan-sqlRFC 822 Email Address mailbox@domainstrongswan-sqlutf8mb4_unicode_ci strongswan-sqlutf8_general_ci!strongswan-sqlucs2_general_ci"strongswan-sqlutf16_general_ci#strongswan-sqlutf16le_general_ci$strongswan-sqlutf32_general_ci %&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOP&%$#"! '(*)+,CBA@?>=<;:9876543210/.-DESRQPONMLKJIHGFTUZYXWV[_^]\`dcbaegfhrqponmlkjisxwvtuy|{z}~QRSTUVWXYZ[\]^_`abcdefg#!"$ hijkNone"#7lmnopqrstuvwxyz{|}~None"#>None "#&'.=?J 0Interface Library for strongSwan (My)SQL backend(c) Erick Gonzalez, 2019BSD3erick@codemonkeylabs.deNone "#>SXB9strongswan-sqlName of the DB to usestrongswan-sql'SQL server host (defaults to localhost)strongswan-sqlTCP port (defaults to 3306)strongswan-sqlDB username (defaults to root)strongswan-sqlDB user passwordstrongswan-sql Defaults to strongswan-sql#Initialize an SQL context. Use the  instance of 2 and fine tune parameters as needed. For example: . context <- init def { dbName = "acmeDB" } strongswan-sqlZPushes an IPsec configuration into the DB specified in the given context. Note that if there are any existing elements in the configuration, they are first released (and their inter relationships in the SQL DB removed), before creating them. As a result the different IDs inside the elements etc will probably change. This is the reason why a new | value is returned as a result of the operation and the value "pushed" to the DB originally should not be used any further.strongswan-sqlRSearch for an IPsec connection configuration by its unique name. Take note of the  context, which means that unless it is desired that this function throws an asynchronous exception upon not finding a configuration, you probably want to run this inside a monadic transformer such as  or ExceptTstrongswan-sqlELookup an IPsec connection configuration by its unique name. Returns Nothingz if the connection is not found. Other errors are reported according to the Failable context the function is called on (, ExceptT, , etc).strongswan-sqlRemoves the specified  from the DB, releasing all linked elements. The returned IPSecSettings will contain now "unlinked" elements (i.e. no IDs, etc).strongswan-sqlHAdds a shared secret to a given identity. If the identity doesn't exist it will get created. If the identity already exists and it already has a secret of the same type, it will be overwritten. This means there can only be one secret of any given type per identity (which makes sense of course from strongswan's perspective).strongswan-sqlKRemoves a secret of the given type (if present) from the specified identitystrongswan-sqlBRemoves an identity and its secrets and related entries altogether  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrsutvwxyz{|}~          sutvwxDEFGHIJKLMNOPQRSyz{|hijklmnopqrTUVWXYZ +,-./0123456789:;<=>?@ABC'()*}~[\]^_ !"#$%&efg`abcd        !!"#$%&'())*+,,-./0123456789:;<=>?@ABCDDEFGHIJKLMNOPQRSSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !!"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\OLRUX]^_`abcdefghijklmnopqrstuvwxyz{|}~-strongswan-sql-1.2.2.0-5BTohnVIkvZ6RxaK9ba6uDStrongSwan.SQLStrongSwan.SQL.TypesStrongSwan.SQL.StatementsStrongSwan.SQL.LensesStrongSwan.SQL.Encoding+mysql-haskell-0.8.4.2-7wWPsh9af2D4IOd9z5hkPDatabase.MySQL.Protocol.Packet okWarningCntokStatusokLastInsertIDokAffectedRowsOK IPSecSettings_getIPSecCfgName _getIKEConfig_getChildSAConfig_getPeerConfig_getLocalTrafficSelector_getRemoteTrafficSelector_getLocalIdentity_getRemoteIdentitySharedSecretIdentity_sharedSecretId _identityId SharedSecret_ssId_ssType_ssDataChild2TSConfigc2tsChildCfgIdc2tsTrafficSelectorCfgIdc2tsTrafficSelectorKindTrafficSelector_tsId_tsType _tsProtocol _tsStartAddr _tsEndAddr _tsStartPort _tsEndPortPeer2ChildConfig p2cPeerCfgId p2cChildCfgId PeerConfig _peerCfgId _peerCfgName_peerCfgIKEVersion_peerCfgIKEConfigId_peerCfgLocalId_peerCfgRemoteId_peerCfgCertPolicy_peerCfgUniqueIds_peerCfgAuthMethod_peerCfgEAPType_peerCfgEAPVendor_peerCfgKeyingTries_peerCfgRekeyTime_peerCfgReauthTime_peerCfgJitter_peerCfgOverTime_peerCfgMobike_peerCfgDPDDelay_peerCfgVirtual _peerCfgPool_peerCfgMediation_peerCfgMediatedBy_peerCfgPeerId ChildSAConfig _childSAId _childSAName_childSALifeTime_childSARekeyTime_childSAJitter_childSAUpDown_childSAHostAccess _childSAMode_childSAStartAction_childSADPDAction_childSACloseAction_childSAIPCompression _childSAReqID _childSAMark IKEConfig_ikeId _ikeReqCert_ikeForceEncap_ikeLocalAddress_ikeRemoteAddressSharedSecretType SharedIKE SharedEAP SharedRSA SharedPINTrafficSelectorKindLocalTSRemoteTSLocalDynamicTSRemoteDynamicTSTrafficSelectorType IPv4AddrRange IPv6AddrRangeEAPTypeEAPUnspecifiedEAPMD5EAPGTCEAPTLSEAPSIMEAPTTLSEAPAKA EAPMSCHAPV2EAPTNC EAPRADIUS AuthMethodAnyAuthPubKeyPSKEAPXAUTH CertPolicy AlwaysSend SendIfAsked NeverSendSAActionNoneRouteRestartSAMode TransportTunnelBeetPassDropIdentityAnyID IPv4AddrIDNameIDEmailID IPv6AddrIDASN1IDOpaqueIDResultlastModifiedKeyresponseErrorUnknownCharacterEncoding UnknownSAModeUnknownSAActionUnknownCertPolicyUnknownAuthMethodUnknownEAPTypeUnknownTrafficSelectorTypeUnknownTrafficSelectorKindUnknownSharedSecretTypeInvalidValueForTypeSQLValuesMismatchNotFoundMultipleResultsFailedOperation ikeForceEncapikeIdikeLocalAddressikeRemoteAddress ikeReqCertchildSACloseActionchildSADPDActionchildSAHostAccesschildSAIPCompression childSAId childSAJitterchildSALifeTime childSAMark childSAMode childSANamechildSARekeyTime childSAReqIDchildSAStartAction childSAUpDownpeerCfgAuthMethodpeerCfgCertPolicypeerCfgDPDDelaypeerCfgEAPTypepeerCfgEAPVendorpeerCfgIKEConfigIdpeerCfgIKEVersion peerCfgId peerCfgJitterpeerCfgKeyingTriespeerCfgLocalIdpeerCfgMediatedBypeerCfgMediation peerCfgMobike peerCfgNamepeerCfgOverTime peerCfgPeerId peerCfgPoolpeerCfgReauthTimepeerCfgRekeyTimepeerCfgRemoteIdpeerCfgUniqueIdspeerCfgVirtual tsEndAddr tsEndPorttsId tsProtocol tsStartAddr tsStartPorttsTypessDatassIdssType identityIdsharedSecretIdgetChildSAConfig getIKEConfiggetIPSecCfgNamegetLocalIdentitygetLocalTrafficSelector getPeerConfiggetRemoteIdentitygetRemoteTrafficSelectorSQLRowSettings_dbName_dbHost_dbPort_dbUser _dbPassword _dbCharSetContext$fShowSettings dbCharSetdbHostdbName dbPassworddbPortdbUser mkContextwriteIPSecSettingsfindIPSecSettingslookupIPSecSettingsdeleteIPSecSettings addSecret removeSecretremoveIdentitywriteChildSAConfigfindChildSAConfigByNamefindChildSAConfiglookupChildSAConfigdeleteChildSAConfigwriteIKEConfig findIKEConfiglookupIKEConfigdeleteIKEConfigwritePeerConfigfindPeerConfigByNamefindPeerConfiglookupPeerConfigdeletePeerConfigwritePeer2ChildConfigfindPeer2ChildConfiglookupPeer2ChildConfigdeletePeer2ChildConfigwriteTrafficSelectorfindTrafficSelectorlookupTrafficSelectorwriteChild2TSConfiglookupChild2TSConfigdeleteChild2TSConfig writeIdentity findIdentitylookupIdentityfindIdentityBySelflookupIdentityBySelfdeleteIdentitywriteSharedSecretfindSharedSecretlookupSharedSecretdeleteSharedSecretwriteSSIdentityfindSSIdentitydeleteSSIdentity$fDefaultSettingsUTF8MB4UTF8UCS2UTF16UTF16LEUTF32PreparedStatementsdeleteIPSecStmt findIPSecStmtcreateIPSecStmtdeleteSSIdentityStmtfindSSIdentityStmtcreateSSIdentityStmtupdateSSIdentityStmtdeleteSharedSecretStmtfindSharedSecretStmtcreateSharedSecretStmtupdateSharedSecretStmtdeleteIdentityStmtfindIdentityBySelfStmtfindIdentityStmtcreateIdentityStmtupdateIdentityStmtdeleteC2TSStmt findC2TSStmtcreateC2TSStmtupdateC2TSStmt deleteTSStmt findTSStmt createTSStmt updateTSStmt deleteP2CStmt findP2CStmt createP2CStmt updateP2CStmtdeletePeerStmtfindPeerByNameStmt findPeerStmtcreatePeerStmtupdatePeerStmt deleteIKEStmt findIKEStmt createIKEStmt updateIKEStmtdeleteChildSAStmtfindChildSAByNameStmtfindChildSAStmtcreateChildSAStmtupdateChildSAStmt VarBinary fromVarBinary toVarBinaryVarChar fromVarChar toVarChar IntWord32fromInttoIntSmallInt fromSmallInt toSmallIntTinyInt fromTinyInt toTinyIntValueNullCharMySQLCharacterEncoding getIdentityId setIdentityId toSQLEnum fromSQLEnumprepareStatementsprepareupdateIKEStatementcreateIKETableStatementcreateIKEStatementfindIKEStatementdeleteIKEStatementupdateChildSAStatementcreateChildSATableStatementcreateChildSAStatementfindChildSAByNameStatementfindChildSAStatementdeleteChildSAStatementcreatePeerTableStatementcreatePeerStatementupdatePeerStatementfindPeerStatementfindPeerByNameStatementdeletePeerStatementcreateP2CTableStatementcreateP2CStatementupdateP2CStatementfindP2CStatementdeleteP2CStatementcreateTSTableStatementcreateTSStatementupdateTSStatementfindTSStatementdeleteTSStatementcreateC2TSTableStatementcreateC2TSStatementupdateC2TSStatementfindC2TSStatementdeleteC2TSStatementcreateSharedSecretTablecreateSharedSecretStatementupdateSharedSecretStatementfindSharedSecretStatementdeleteSharedSecretStatementcreateIdentityTablecreateIdentityStatementupdateIdentityStatementfindIdentityStatementfindIdentityBySelfStatementdeleteIdentityStatementcreateSSIdentityTablecreateSSIdentityStatementupdateSSIdentityStatementfindSSIdentityStatementdeleteSSIdentityStatementcreateIPSecTableStatementcreateIPSecStatementfindIPSecStatementdeleteIPSecStatementinitializeWithSQLValuefromSQLtoSQL fromValuestoValuesfromId parseEmail iDToVarChar varCharToId encodeHex1data-default-class-0.1.2.0-FeIQ5tLoVZBHMSgrT9zptQData.Default.ClassDefault&failable-1.1.0.0-EGOiIBfmD3biuh5smhI14Control.Monad.FailableFailabletransformers-0.5.5.0Control.Monad.Trans.MaybeMaybeTghc-prim GHC.TypesIO