Botan::TLS::Session_Manager_SQLite Class Reference

#include <tls_session_manager_sqlite.h>

Inheritance diagram for Botan::TLS::Session_Manager_SQLite:

Public Member Functions
virtual std::optional< std::pair< Session, uint16_t > >	choose_from_offered_tickets (const std::vector< PskIdentity > &tickets, std::string_view hash_function, Callbacks &callbacks, const Policy &policy)
bool	emits_session_tickets () override
virtual std::optional< Session_Handle >	establish (const Session &session, const std::optional< Session_ID > &id=std::nullopt, bool tls12_no_ticket=false)
	Save a new Session and assign a Session_Handle (TLS Server)
virtual std::vector< Session_with_Handle >	find (const Server_Information &info, Callbacks &callbacks, const Policy &policy)
	Find all sessions that match a given server info.
size_t	remove (const Session_Handle &handle) override
size_t	remove_all () override
virtual std::optional< Session >	retrieve (const Session_Handle &handle, Callbacks &callbacks, const Policy &policy)
	Retrieves a specific session given a handle.
	Session_Manager_SQLite (std::string_view passphrase, const std::shared_ptr< RandomNumberGenerator > &rng, std::string_view db_filename, size_t max_sessions=1000)
void	store (const Session &session, const Session_Handle &handle) override
	Save a Session under a Session_Handle (TLS Client)

Protected Member Functions
virtual bool	database_is_threadsafe () const
std::vector< Session_with_Handle >	find_some (const Server_Information &info, size_t max_sessions_hint) override
	Internal retrieval function to find sessions to resume.
recursive_mutex_type &	mutex ()
std::optional< Session >	retrieve_one (const Session_Handle &handle) override
	Internal retrieval function for a single session.

Protected Attributes
std::shared_ptr< RandomNumberGenerator >	m_rng

Detailed Description

An implementation of Session_Manager that saves values in a SQLite3 database file, with the session data encrypted using a passphrase.

Warning

For clients, the hostnames associated with the saved sessions are stored in the database in plaintext. This may be a serious privacy risk in some situations.

Definition at line 27 of file tls_session_manager_sqlite.h.

Constructor & Destructor Documentation

Session_Manager_SQLite()

Botan::TLS::Session_Manager_SQLite::Session_Manager_SQLite	(	std::string_view	passphrase,
		const std::shared_ptr< RandomNumberGenerator > &	rng,
		std::string_view	db_filename,
		size_t	max_sessions = 1000 )

Parameters

passphrase	used to encrypt the session data
rng	a random number generator
db_filename	filename of the SQLite database file. The table names tls_sessions and tls_sessions_metadata will be used
max_sessions	a hint on the maximum number of sessions to keep in memory at any one time. (If zero, don't cap)

Definition at line 14 of file tls_session_manager_sqlite.cpp.

                                                                    :
      Session_Manager_SQL(std::make_shared<Sqlite3_Database>(db_filename), passphrase, rng, max_sessions) {}

References Botan::TLS::Session_Manager_SQL::Session_Manager_SQL().

Member Function Documentation

choose_from_offered_tickets()

std::optional< std::pair< Session, uint16_t > > Botan::TLS::Session_Manager::choose_from_offered_tickets ( const std::vector< PskIdentity > & tickets, std::string_view hash_function, Callbacks & callbacks, const Policy & policy )

virtualinherited

Lets the server application choose a PSK to use for a new TLS connection. Implementers must make sure that the PSK's associated hash function is equal to the passed hash_function.

RFC 8446 4.2.11 The server MUST ensure that it selects a compatible PSK (if any) and cipher suite.

The default implementation simply tries to retrieve all tickets in the order offered by the peer and picks the first that is found and features a matching hash algorithm.

This method is called only by TLS 1.3 servers.

Parameters

tickets	a list of tickets that were offered by the client
hash_function	the hash algorithm name we are going to use for the to-be-negotiated connection
callbacks	callbacks to be used for session policy decisions
policy	policy to be used for session policy decisions

Returns

a std::pair of the Session associated to the choosen PSK and the index of the selected ticket; std::nullopt if no PSK was chosen for usage (will result in a full handshake)

Note

if no PSK is chosen, the server will attempt a regular handshake.

Definition at line 202 of file tls_session_manager.cpp.

                         {
   // Note that the TLS server currently does not ensure that tickets aren't
   // reused. As a result, no locking is required on this level.
 
   for(uint16_t i = 0; const auto& ticket : tickets) {
      auto session = retrieve(Opaque_Session_Handle(ticket.identity()), callbacks, policy);
      if(session.has_value() && session->ciphersuite().prf_algo() == hash_function &&
         session->version().is_tls_13_or_later()) {
         return std::pair{std::move(session.value()), i};
      }
 
      // RFC 8446 4.2.10
      //    For PSKs provisioned via NewSessionTicket, a server MUST validate
      //    that the ticket age for the selected PSK identity [...] is within a
      //    small tolerance of the time since the ticket was issued.  If it is
      //    not, the server SHOULD proceed with the handshake but reject 0-RTT,
      //    and SHOULD NOT take any other action that assumes that this
      //    ClientHello is fresh.
      //
      // TODO: The ticket-age is currently not checked (as 0-RTT is not
      //       implemented) and we simply take the SHOULD at face value.
      //       Instead we could add a policy check letting the user decide.
 
      ++i;
   }
 
   return std::nullopt;
}

References retrieve().

Referenced by Botan::TLS::PSK::select_offered_psk(), and store().

database_is_threadsafe()

virtual bool Botan::TLS::Session_Manager_SQL::database_is_threadsafe ( ) const

inlineprotectedvirtualinherited

Decides whether the underlying database is considered threadsafe in the context the Session_Manager is used. If this returns false, accesses to the database are serialized with the base class' recursive mutex.

Definition at line 62 of file tls_session_manager_sql.h.

{ return m_db->is_threadsafe(); }

Referenced by find_some(), retrieve_one(), and store().

emits_session_tickets()

bool Botan::TLS::Session_Manager_SQL::emits_session_tickets ( )

inlineoverridevirtualinherited

Declares whether the given Session_Manager implementation may emit session tickets. Note that this does not mean that the implementation must always emit tickets.

Concrete implementations should declare this, to allow the TLS implementations to act accordingly. E.g. to advertise support for session tickets in their Server Hello.

Returns

true if the Session_Manager produces session tickets

Reimplemented from Botan::TLS::Session_Manager.

Definition at line 51 of file tls_session_manager_sql.h.

{ return false; }

establish()

std::optional< Session_Handle > Botan::TLS::Session_Manager::establish ( const Session & session, const std::optional< Session_ID > & id = std::nullopt, bool tls12_no_ticket = false )

virtualinherited

Save a new Session and assign a Session_Handle (TLS Server)

Save a new session on a best effort basis; the manager may not in fact be able to save the session for whatever reason; this is not an error. Callers cannot assume that calling establish() followed immediately by retrieve() or choose_from_offered_tickets() will result in a successful lookup. In case no session was stored, std::nullopt is returned.

This method is only called on TLS servers.

Note that implementations will silently refrain from sending session tickets to the client when this method returns std::nullopt.

Parameters

session	to save
id	to use (instead of an ID chosen by the manager)
tls12_no_ticket	disable tickets for this establishment (set when TLS 1.2 client does not support them)

Returns

a Session_Handle containing either an ID or a ticket if the session was saved, otherwise std::nullopt

Reimplemented in Botan::TLS::Session_Manager_Hybrid, Botan::TLS::Session_Manager_Noop, and Botan::TLS::Session_Manager_Stateless.

Definition at line 23 of file tls_session_manager.cpp.

                                                                               {
   // Establishing a session does not require locking at this level as
   // concurrent TLS instances on a server will create unique sessions.
 
   // By default, the session manager does not emit session tickets anyway
   BOTAN_UNUSED(tls12_no_ticket);
   BOTAN_ASSERT(session.side() == Connection_Side::Server, "Client tried to establish a session");
 
   Session_Handle handle(id.value_or(m_rng->random_vec<Session_ID>(32)));
   store(session, handle);
   return handle;
}

References BOTAN_ASSERT, BOTAN_UNUSED, m_rng, Botan::TLS::Server, Botan::TLS::Session_Base::side(), and store().

find()

std::vector< Session_with_Handle > Botan::TLS::Session_Manager::find ( const Server_Information & info, Callbacks & callbacks, const Policy & policy )

virtualinherited

Find all sessions that match a given server info.

TLS clients use this to obtain session resumption information for a server they are wishing to handshake with. Typically, session info will have been received in prior connections to that same server and stored using Session_Manager::store().

The default implementation will invoke Session_Manager::find_some() and filter the result against a policy. Most notably an expiry check. Expired sessions will be removed via Session_Manager::remove().

The TLS client implementations will query the session manager exactly once per handshake attempt. If no reuse is desired, the session manager may remove the sessions internally when handing them out to the client. The default implementation adheres to Policy::reuse_session_tickets().

For TLS 1.2 the client implementation will attempt a resumption with the first session in the returned list. For TLS 1.3, it will offer all found sessions to the server.

Applications that wish to implement their own Session_Manager may override the default implementation to add further policy checks. Though, typically implementing Session_Manager::find_some() and relying on the default implementation is enough.

Parameters

info	the info about the server we want to handshake with
callbacks	callbacks to be used for session policy decisions
policy	policy to be used for session policy decisions

Returns

a list of usable sessions that might be empty if no such session exists or passed the policy validation

Reimplemented in Botan::TLS::Session_Manager_Hybrid.

Definition at line 157 of file tls_session_manager.cpp.

                                                                             {
   auto allow_reusing_tickets = policy.reuse_session_tickets();
 
   // Session_Manager::find() must be an atomic getter if ticket reuse is not
   // allowed. I.e. each ticket handed to concurrently requesting threads must
   // be unique. In that case we must hold a lock while retrieving a ticket.
   // Otherwise, no locking is required on this level.
   std::optional<lock_guard_type<recursive_mutex_type>> lk;
   if(!allow_reusing_tickets) {
      lk.emplace(mutex());
   }
 
   auto sessions_and_handles = find_and_filter(info, callbacks, policy);
 
   // std::vector::resize() cannot be used as the vector's members aren't
   // default constructible.
   const auto session_limit = policy.maximum_session_tickets_per_client_hello();
   while(session_limit > 0 && sessions_and_handles.size() > session_limit) {
      sessions_and_handles.pop_back();
   }
 
   // RFC 8446 Appendix C.4
   //    Clients SHOULD NOT reuse a ticket for multiple connections. Reuse of
   //    a ticket allows passive observers to correlate different connections.
   //
   // When reuse of session tickets is not allowed, remove all tickets to be
   // returned from the implementation's internal storage.
   if(!allow_reusing_tickets) {
      // The lock must be held here, otherwise we cannot guarantee the
      // transactional retrieval of tickets to concurrently requesting clients.
      BOTAN_ASSERT_NOMSG(lk.has_value());
      for(const auto& [session, handle] : sessions_and_handles) {
         if(!session.version().is_pre_tls_13() || !handle.is_id()) {
            remove(handle);
         }
      }
   }
 
   return sessions_and_handles;
}

References BOTAN_ASSERT_NOMSG, Botan::TLS::Policy::maximum_session_tickets_per_client_hello(), mutex(), remove(), and Botan::TLS::Policy::reuse_session_tickets().

Referenced by store().

find_some()

std::vector< Session_with_Handle > Botan::TLS::Session_Manager_SQL::find_some ( const Server_Information & info, size_t max_sessions_hint )

overrideprotectedvirtualinherited

Internal retrieval function to find sessions to resume.

Try to find saved sessions using info about the server we're planning to connect to. It should return a list of sessions in preference order of the session manager.

Applications that wish to implement their own Session_Manager will have to provide an implementation for it.

Note that the TLS client implementations do not perform any checks on the validity of the session for a given info. Particularly, it is the Session_Manager's responsibility to ensure the restrictions posed in RFC 8446 4.6.1 regarding server certificate validity for the given info.

This is called for TLS clients only.

Parameters

info	the information about the server
max_sessions_hint	a non-binding guideline for an upper bound of sessions to return from this method (will be at least 1 but potentially more)

Returns

the found sessions along with their handles (containing either a session ID or a ticket)

Implements Botan::TLS::Session_Manager.

Definition at line 202 of file tls_session_manager_sql.cpp.

                                                                                                {
   std::optional<lock_guard_type<recursive_mutex_type>> lk;
   if(!database_is_threadsafe()) {
      lk.emplace(mutex());
   }
 
   auto stmt = m_db->new_statement(
      "SELECT session_id, session_ticket, session FROM tls_sessions"
      " WHERE hostname = ?1 AND hostport = ?2"
      " ORDER BY session_start DESC"
      " LIMIT ?3");
 
   stmt->bind(1, info.hostname());
   stmt->bind(2, info.port());
   stmt->bind(3, max_sessions_hint);
 
   std::vector<Session_with_Handle> found_sessions;
   while(stmt->step()) {
      auto handle = [&]() -> Session_Handle {
         auto ticket_blob = stmt->get_blob(1);
         if(ticket_blob.second > 0) {
            return Session_Ticket(std::span(ticket_blob.first, ticket_blob.second));
         } else {
            return Session_ID(Botan::hex_decode(stmt->get_str(0)));
         }
      }();
 
      std::pair<const uint8_t*, size_t> blob = stmt->get_blob(2);
 
      try {
         found_sessions.emplace_back(
            Session_with_Handle{Session::decrypt(blob.first, blob.second, m_session_key), std::move(handle)});
      } catch(...) {}
   }
 
   return found_sessions;
}

References database_is_threadsafe(), Botan::TLS::Session::decrypt(), Botan::hex_decode(), Botan::TLS::Server_Information::hostname(), Botan::TLS::Session_Manager::mutex(), and Botan::TLS::Server_Information::port().

mutex()

recursive_mutex_type & Botan::TLS::Session_Manager::mutex ( )

inlineprotectedinherited

Returns the base class' recursive mutex for reuse in derived classes

Definition at line 267 of file tls_session_manager.h.

{ return m_mutex; }

Referenced by find(), Botan::TLS::Session_Manager_In_Memory::find_some(), Botan::TLS::Session_Manager_SQL::find_some(), Botan::TLS::Session_Manager_In_Memory::remove(), Botan::TLS::Session_Manager_SQL::remove(), Botan::TLS::Session_Manager_In_Memory::remove_all(), Botan::TLS::Session_Manager_SQL::remove_all(), Botan::TLS::Session_Manager_In_Memory::retrieve_one(), Botan::TLS::Session_Manager_SQL::retrieve_one(), Botan::TLS::Session_Manager_In_Memory::store(), and Botan::TLS::Session_Manager_SQL::store().

remove()

size_t Botan::TLS::Session_Manager_SQL::remove ( const Session_Handle & handle )

overridevirtualinherited

Remove a specific session from the cache, if it exists. The handle might contain either a session ID or a ticket.

Parameters

handle

a Session_Handle of the session to be removed

Returns

the number of sessions that were removed

Implements Botan::TLS::Session_Manager.

Definition at line 241 of file tls_session_manager_sql.cpp.

                                                               {
   // The number of deleted rows is taken globally from the database connection,
   // therefore we need to serialize this implementation.
   lock_guard_type<recursive_mutex_type> lk(mutex());
 
   if(const auto id = handle.id()) {
      auto stmt = m_db->new_statement("DELETE FROM tls_sessions WHERE session_id = ?1");
      stmt->bind(1, hex_encode(id->get()));
      stmt->spin();
   } else if(const auto ticket = handle.ticket()) {
      auto stmt = m_db->new_statement("DELETE FROM tls_sessions WHERE session_ticket = ?1");
      stmt->bind(1, ticket->get());
      stmt->spin();
   } else {
      // should not happen, as session handles are exclusively either an ID or a ticket
      throw Invalid_Argument("provided a session handle that is neither ID nor ticket");
   }
 
   return m_db->rows_changed_by_last_statement();
}

References Botan::hex_encode(), Botan::TLS::Session_Handle::id(), Botan::TLS::Session_Manager::mutex(), and Botan::TLS::Session_Handle::ticket().

Referenced by operator=().

remove_all()

size_t Botan::TLS::Session_Manager_SQL::remove_all ( )

overridevirtualinherited

Remove all sessions from the cache

Returns

the number of sessions that were removed

Implements Botan::TLS::Session_Manager.

Definition at line 262 of file tls_session_manager_sql.cpp.

                                       {
   // The number of deleted rows is taken globally from the database connection,
   // therefore we need to serialize this implementation.
   lock_guard_type<recursive_mutex_type> lk(mutex());
 
   m_db->exec("DELETE FROM tls_sessions");
   return m_db->rows_changed_by_last_statement();
}

References Botan::TLS::Session_Manager::mutex().

Referenced by operator=().

retrieve()

std::optional< Session > Botan::TLS::Session_Manager::retrieve ( const Session_Handle & handle, Callbacks & callbacks, const Policy & policy )

virtualinherited

Retrieves a specific session given a handle.

This is typically used by TLS servers to obtain resumption information for a previous call to Session_Manager::establish() when a client requested resumption using the handle.

Even if the session is found successfully, it is returned only if it passes policy validations. Most notably an expiry check. If the expiry check fails, the default implementation calls Session_Manager::remove() for the provided handle.

Applications that wish to implement their own Session_Manager may override the default implementation to add further policy checks. Though, typically implementing Session_Manager::retrieve_one() and relying on the default implementation is enough.

Parameters

handle	the Session_Handle to be retrieved
callbacks	callbacks to be used for session policy decisions
policy	policy to be used for session policy decisions

Returns

the obtained session or std::nullopt if no session was found or the policy checks failed

Reimplemented in Botan::TLS::Session_Manager_Hybrid.

Definition at line 38 of file tls_session_manager.cpp.

                                                                       {
   // Retrieving a session for a given handle does not require locking on this
   // level. Concurrent threads might handle the removal of an expired ticket
   // more than once, but removing an already removed ticket is a harmless NOOP.
 
   auto session = retrieve_one(handle);
   if(!session.has_value()) {
      return std::nullopt;
   }
 
   // A value of '0' means: No policy restrictions.
   const std::chrono::seconds policy_lifetime =
      (policy.session_ticket_lifetime().count() > 0) ? policy.session_ticket_lifetime() : std::chrono::seconds::max();
 
   // RFC 5077 3.3 -- "Old Session Tickets"
   //    A server MAY treat a ticket as valid for a shorter or longer period of
   //    time than what is stated in the ticket_lifetime_hint.
   //
   // RFC 5246 F.1.4 -- TLS 1.2
   //    If either party suspects that the session may have been compromised, or
   //    that certificates may have expired or been revoked, it should force a
   //    full handshake.  An upper limit of 24 hours is suggested for session ID
   //    lifetimes.
   //
   // RFC 8446 4.6.1 -- TLS 1.3
   //    A server MAY treat a ticket as valid for a shorter period of time than
   //    what is stated in the ticket_lifetime.
   //
   // Note: This disregards what is stored in the session (e.g. "lifetime_hint")
   //       and only takes the local policy into account. The lifetime stored in
   //       the sessions was taken from the same policy anyways and changes by
   //       the application should have an immediate effect.
   const auto ticket_age =
      std::chrono::duration_cast<std::chrono::seconds>(callbacks.tls_current_timestamp() - session->start_time());
   const bool expired = ticket_age > policy_lifetime;
 
   if(expired) {
      remove(handle);
      return std::nullopt;
   } else {
      return session;
   }
}

References remove(), retrieve_one(), Botan::TLS::Policy::session_ticket_lifetime(), and Botan::TLS::Callbacks::tls_current_timestamp().

Referenced by choose_from_offered_tickets(), and store().

retrieve_one()

std::optional< Session > Botan::TLS::Session_Manager_SQL::retrieve_one ( const Session_Handle & handle )

overrideprotectedvirtualinherited

Internal retrieval function for a single session.

Try to obtain a Session from a Session_Handle that contains either a session ID or a session ticket. This method should not apply any policy decision (such as ticket expiry) but simply be a storage interface.

Applications that wish to implement their own Session_Manager will have to provide an implementation for it.

This method is called only by servers.

Parameters

handle

a Session_Handle containing either an ID or a ticket

Returns

the obtained session or std::nullopt if none can be obtained

Implements Botan::TLS::Session_Manager.

Definition at line 179 of file tls_session_manager_sql.cpp.

                                                                                   {
   std::optional<lock_guard_type<recursive_mutex_type>> lk;
   if(!database_is_threadsafe()) {
      lk.emplace(mutex());
   }
 
   if(auto session_id = handle.id()) {
      auto stmt = m_db->new_statement("SELECT session FROM tls_sessions WHERE session_id = ?1");
 
      stmt->bind(1, hex_encode(session_id->get()));
 
      while(stmt->step()) {
         std::pair<const uint8_t*, size_t> blob = stmt->get_blob(0);
 
         try {
            return Session::decrypt(blob.first, blob.second, m_session_key);
         } catch(...) {}
      }
   }
 
   return std::nullopt;
}

References database_is_threadsafe(), Botan::TLS::Session::decrypt(), Botan::hex_encode(), Botan::TLS::Session_Handle::id(), and Botan::TLS::Session_Manager::mutex().

store()

void Botan::TLS::Session_Manager_SQL::store ( const Session & session, const Session_Handle & handle )

overridevirtualinherited

Save a Session under a Session_Handle (TLS Client)

Save a session on a best effort basis; the manager may not in fact be able to save the session for whatever reason; this is not an error. Callers cannot assume that calling store() followed immediately by find() will result in a successful lookup.

In contrast to establish(), this stores sessions that were created by the server along with a Session_Handle also coined by the server.

This method is only called on TLS clients.

Parameters

session	to save
handle	a Session_Handle on which this session shoud by stored

Implements Botan::TLS::Session_Manager.

Definition at line 148 of file tls_session_manager_sql.cpp.

                                                                                    {
   std::optional<lock_guard_type<recursive_mutex_type>> lk;
   if(!database_is_threadsafe()) {
      lk.emplace(mutex());
   }
 
   if(session.server_info().hostname().empty()) {
      return;
   }
 
   auto stmt = m_db->new_statement(
      "INSERT OR REPLACE INTO tls_sessions"
      " VALUES (?1, ?2, ?3, ?4, ?5, ?6)");
 
   // Generate a random session ID if the peer did not provide one. Note that
   // this ID will not be returned on ::find(), as the ticket is preferred.
   const auto id = handle.id().value_or(m_rng->random_vec<Session_ID>(32));
   const auto ticket = handle.ticket().value_or(Session_Ticket());
 
   stmt->bind(1, hex_encode(id.get()));
   stmt->bind(2, ticket.get());
   stmt->bind(3, session.start_time());
   stmt->bind(4, session.server_info().hostname());
   stmt->bind(5, session.server_info().port());
   stmt->bind(6, session.encrypt(m_session_key, *m_rng));
 
   stmt->spin();
 
   prune_session_cache();
}

References database_is_threadsafe(), Botan::TLS::Session::encrypt(), Botan::hex_encode(), Botan::TLS::Server_Information::hostname(), Botan::TLS::Session_Handle::id(), Botan::TLS::Session_Manager::m_rng, Botan::TLS::Session_Manager::mutex(), Botan::TLS::Server_Information::port(), Botan::TLS::Session_Base::server_info(), Botan::TLS::Session_Base::start_time(), and Botan::TLS::Session_Handle::ticket().

Referenced by operator=().

Member Data Documentation

m_rng

std::shared_ptr<RandomNumberGenerator> Botan::TLS::Session_Manager::m_rng

protectedinherited

Definition at line 275 of file tls_session_manager.h.

Referenced by establish(), Botan::TLS::Session_Manager_Stateless::establish(), Session_Manager(), Botan::TLS::Session_Manager_In_Memory::store(), and Botan::TLS::Session_Manager_SQL::store().

---

The documentation for this class was generated from the following files:

• src/lib/tls/sessions_sqlite3/tls_session_manager_sqlite.h
• src/lib/tls/sessions_sqlite3/tls_session_manager_sqlite.cpp