SquirrelMail - Webmail for Nuts!

When saving, enter the following:

   ____  _______  ##   ## ZZZ  ZZZ  ##   ## 
  / ___|(  ____ \ ##   ##  ZZZ  Z   ##   ## 
 | |    | (    \/  ## ##   Z ZZ Z    ## ##  
 | |___ | (__      ## ##   Z ZZ Z    ## ##  
  \____||  __)      ###    Z  ZZZ     ###   
        | (         ###    Z   ZZ     ###   
        | (____/\    #    ZZZ   ZZ     #    
        (_______/

Visit Preferences to set your user name

The PHP session information is by default stored in a directory that's set with the PHP {{session.save_path}} setting. This setting can be set in {{php.ini}}, the web server configuration or {{.htaccess}} files (for web servers supporting them).

If you want to share session information between two web servers, you can use a shared network directory.

If you prefer using a database, the PHP session extension provides functions that allow overriding default session storage back-end with custom back-end functions. See [http://www.php.net/session-set-save-handler session-set-save-handler].

[http://adodb.sf.net ADOdb] libraries provide an easy way to use this function.  You only have to load ADOdb includes, session database configuration and ADOdb session includes before every {{session_start()}} function call.

In order to avoid need to hunt every {{session_start()}} call and modify every script that uses it, you can also use the PHP {{auto_prepend_file}} setting and load ADOdb code in that included file.

For example:
1. You create file {{/some-path/sessiondb.php}} that contains:

2. Also edit {{config/config_local.php}}, adding the things explained in [http://squirrelmail.org/docs/stable-code/__filesource/fsource_squirrelmail__srclogin.php.html#a60 src/login.php] in the comment on line 60 (at least in version 1.4.21). You'll need to duplicate the contents of {{session_set_save_handler()}} in the {{_init()}} function of "ADODB_DIR . '/session/adodb-session.php" in {{$custom_session_handlers}}.

<code>
<?php

/**
 * Local config overrides.
 *
 * You can override the config.php settings here.
 * Don't do it unless you know what you're doing.
 * Use standard PHP syntax, see config.php for examples.
 *
 * @copyright &copy; 2002-2007 The SquirrelMail Project Team
 * @license http://opensource.org/licenses/gpl-license.php GNU Public License
 * @version $Id: config_local.php 12522 2007-07-10 14:52:53Z kink $
 * @package squirrelmail
 * @subpackage config
 */

$custom_session_handlers = array(
         'my_open_handler',
         'my_close_handler',
         'my_read_handler',
         'my_write_handler',
         'my_destroy_handler',
         'my_gc_handler',
     );

session_module_name('user');

session_set_save_handler(
                        array('ADODB_Session', 'open'),
                        array('ADODB_Session', 'close'),
                        array('ADODB_Session', 'read'),
                        array('ADODB_Session', 'write'),
                        array('ADODB_Session', 'destroy'),
                        array('ADODB_Session', 'gc')
                );

?>
</code>

3. Then you prepare database for session information. ADOdb v.4.60 provides SQL dumps for !MySQL and Oracle.

4. Then you add the {{auto_prepend_file}} setting to your web server configuration.

<code>
<directory /usr/share/squirrelmail>
   php_value auto_prepend_file "/some-path/sessiondb.php"
   # ... other directory options ...
</directory>
</code>

5. Restart the web server in order to apply modifications in configuration and see how your !SquirrelMail installation starts using database to store session info.

ADOdb session functions also support encryption and compression of session data.

WARNING: it is possible that sessions on networked filesystem or database are slower and there might be some problems with some IMAP servers.

Summary of change:
Add document to category:

Editing SessionsInDatabase