Configure CakePHP 2.* session and session cache in database

Question

When I switched to the AWS Load balancer (multiple server), Session should be maintained unique. When I used to login my site the session lost and it redirected to the home page. So I have tried to store the session in DB using following code.

Configure::write('Session', array(
    'defaults' => 'database',
    'handler' => array(
        'model' => 'cake_sessions'
    )
));

But it used to store the session data when admin used to logout. I have tried to configure cake session handler interface its fails.

How to haddle the session and cache in database.

Why you don't use the built-in session handler ? – beta-developper Feb 14 '17 at 21:53 — beta-developper, Feb 14 '17 at 21:53
@Ayaouc Is it work for Load balancer – Feb 15 '17 at 06:16 — , Feb 15 '17 at 06:16

score 0 · Answer 1 · answered Feb 15 '17 at 09:02

I don't know about the load balancer, but you can handle your sessions in serval ways, including using databases.

And this is the default configuration of CakePHP to use database for sessions.

First create this table :

CREATE TABLE `cake_sessions` (
    `id` varchar(255) NOT NULL DEFAULT '',
    `data` text,
    `expires` int(11) DEFAULT NULL,
    PRIMARY KEY (`id`)
);

Then, configure your sessions in app/core.php

Configure::write('Session', array(
    'database' => array(
            'cookie' => 'CAKEPHP',
            'timeout' => 240,
            'ini' => array(
                'session.use_trans_sid' => 0,
                'url_rewriter.tags' => '',
                'session.use_cookies' => 1,
                'session.cookie_path' => static::$path,
                'session.save_handler' => 'user',
                'session.serialize_handler' => 'php',
            ),
            'handler' => array(
                'engine' => 'DatabaseSession',
                'model' => 'Session'
            )
        )
));

I have tried your configuration but no data saved in database — , Feb 15 '17 at 09:08

Configure CakePHP 2.* session and session cache in database

1 Answers1