*sigh* No joy here. I have successfully set the "Session_handler_class" to null from "modSessionHandler"
mysql> select * from modx_system_settings where `key` = "session_handler_class";
+-----------------------+-------------------+-----------+-----------+---------+---------------------+
| key | value | xtype | namespace | area | editedon |
+-----------------------+-------------------+-----------+-----------+---------+---------------------+
| session_handler_class | modSessionHandler | textfield | core | session | 0000-00-00 00:00:00 |
+-----------------------+-------------------+-----------+-----------+---------+---------------------+
1 row in set (0.00 sec)
mysql> update modx_system_settings set `value` = "" where `key` = "session_handler_class";
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select * from modx_system_settings where `key` = "session_handler_class";
+-----------------------+-------+-----------+-----------+---------+---------------------+
| key | value | xtype | namespace | area | editedon |
+-----------------------+-------+-----------+-----------+---------+---------------------+
| session_handler_class | | textfield | core | session | 2014-06-30 14:07:59 |
+-----------------------+-------+-----------+-----------+---------+---------------------+
1 row in set (0.00 sec)
But, when trying to log into the manager, I still get looped back to the manager login, with four successively more detailed efforts to write to the database, all failing with an error telling me that the "sessionid" is too long:
[2014-06-30 14:10:16] (ERROR @ /manager/index.php) Error 22001 executing statement:
UPDATE `modx_user_attributes` SET `logincount` = 5,`lastlogin` = 1404140284,`thislogin` = 1404151816,`sessionid` = '3qe1a62sogm6j3dp3r6gevm6r9c0c3flf6rthol9bf34s4074t1ost0o0rl5c6i30qjr1cma6dnmlsvh496j4htuvlg30986j912531' WHERE `id` = 3
Array
(
[0] => 22001
[1] => 1406
[2] => Data too long for column 'sessionid' at row 1
)
[2014-06-30 14:10:16] (ERROR @ /manager/index.php) Error 22001 executing statement:
INSERT INTO `modx_session` (`id`, `access`, `data`) VALUES ('3qe1a62sogm6j3dp3r6gevm6r9c0c3flf6rthol9bf34s4074t1ost0o0rl5c6i30qjr1cma6dnmlsvh496j4htuvlg30986j912531', 1404151816, 'modx.user.contextTokens|a:1:{s:3:\"mgr\";i:3;}usertype|s:7:\"manager\";mgrShortname|s:4:\"furd\";mgrFullname|s:11:\"Frank Field\";mgrEmail|s:12:\"
[email protected]\";mgrValidated|i:1;mgrInternalKey|i:3;mgrFailedlogins|i:0;mgrLastlogin|i:1404139743;mgrLogincount|i:4;modx.mgr.session.cookie.lifetime|i:0;ip|s:11:\"18.48.0.121\";')
Array
(
[0] => 22001
[1] => 1406
[2] => Data too long for column 'id' at row 1
)
[2014-06-30 14:10:16] (ERROR @ /manager/index.php) Error 22001 executing statement:
INSERT INTO `modx_session` (`id`, `access`, `data`) VALUES ('3qe1a62sogm6j3dp3r6gevm6r9c0c3flf6rthol9bf34s4074t1ost0o0rl5c6i30qjr1cma6dnmlsvh496j4htuvlg30986j912531', 1404151816, 'modx.user.contextTokens|a:0:{}')
Array
(
[0] => 22001
[1] => 1406
[2] => Data too long for column 'id' at row 1
)
[2014-06-30 14:10:16] (ERROR @ /connectors/lang.js.php) Error 22001 executing statement:
INSERT INTO `modx_session` (`id`, `access`, `data`) VALUES ('3qe1a62sogm6j3dp3r6gevm6r9c0c3flf6rthol9bf34s4074t1ost0o0rl5c6i30qjr1cma6dnmlsvh496j4htuvlg30986j912531', 1404151816, 'modx.user..attributes|a:1:{s:3:\"mgr\";a:3:{s:16:\"modAccessContext\";a:1:{s:3:\"web\";a:1:{i:0;a:3:{s:9:\"principal\";i:0;s:9:\"authority\";s:1:\"0\";s:6:\"policy\";a:1:{s:4:\"load\";b:1;}}}}s:22:\"modAccessResourceGroup\";a:0:{}s:17:\"modAccessCategory\";a:0:{}}}mgrDocgroups|a:0:{}')
Array
(
[0] => 22001
[1] => 1406
[2] => Data too long for column 'id' at row 1
)
Note that, by Excel's count, that sessionid is "only" 103 characters in length.
☆ A M B ☆
MODX Staff