Changeset 5460 in subversion

Timestamp:

Nov 22, 2011 3:36:29 AM (18 months ago)

Author:

alec

Message:

• Fixed bug where session ID's length was limited to 40 characters. Since PHP5.3 it's possible to set session.hash_function to any hash algorithm that would produce strings up to 128 characters long (#1488196)

Location:

trunk/roundcubemail

Files:

• CHANGELOG (modified) (1 diff)
• SQL/mssql.initial.sql (modified) (1 diff)
• SQL/mssql.upgrade.sql (modified) (1 diff)
• SQL/mysql.initial.sql (modified) (1 diff)
• SQL/mysql.update.sql (modified) (1 diff)
• SQL/postgres.initial.sql (modified) (1 diff)
• SQL/postgres.update.sql (modified) (1 diff)
• SQL/sqlite.initial.sql (modified) (1 diff)
• SQL/sqlite.update.sql (modified) (1 diff)

trunk/roundcubemail/CHANGELOG

@@ -2 +2 @@
 ===========================
 
+- Fixed bug where session ID's length was limited to 40 characters (#1488196)
 - Added About tab in Settings
 - TinyMCE:

trunk/roundcubemail/SQL/mssql.initial.sql

@@ -82 +82 @@
 
 CREATE TABLE [dbo].[session] (
-        [sess_id] [varchar] (32) COLLATE Latin1_General_CI_AI NOT NULL ,
+        [sess_id] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,
         [created] [datetime] NOT NULL ,
         [changed] [datetime] NULL ,

trunk/roundcubemail/SQL/mssql.upgrade.sql

@@ -240 +240 @@
 GO
 
+ALTER TABLE [dbo].[session] ALTER COLUMN [sess_id] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL
+GO
+

trunk/roundcubemail/SQL/mysql.initial.sql

@@ -7 +7 @@
 
 CREATE TABLE `session` (
- `sess_id` varchar(40) NOT NULL,
+ `sess_id` varchar(128) NOT NULL,
  `created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',

trunk/roundcubemail/SQL/mysql.update.sql

@@ -209 +209 @@
  PRIMARY KEY (`user_id`, `mailbox`, `uid`)
 ) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;
+
+ALTER TABLE `session` CHANGE `sess_id` `sess_id` varchar(128) NOT NULL;

trunk/roundcubemail/SQL/postgres.initial.sql

@@ -38 +38 @@
 
 CREATE TABLE "session" (
-    sess_id varchar(40) DEFAULT '' PRIMARY KEY,
+    sess_id varchar(128) DEFAULT '' PRIMARY KEY,
     created timestamp with time zone DEFAULT now() NOT NULL,
     changed timestamp with time zone DEFAULT now() NOT NULL,

trunk/roundcubemail/SQL/postgres.update.sql

@@ -166 +166 @@
 
 CREATE INDEX cache_messages_changed_idx ON cache_messages (changed);
+
+ALTER TABLE "session" ALTER sess_id TYPE varchar(128);

trunk/roundcubemail/SQL/sqlite.initial.sql

@@ -111 +111 @@
 
 CREATE TABLE session (
-  sess_id varchar(40) NOT NULL PRIMARY KEY,
+  sess_id varchar(128) NOT NULL PRIMARY KEY,
   created datetime NOT NULL default '0000-00-00 00:00:00',
   changed datetime NOT NULL default '0000-00-00 00:00:00',

trunk/roundcubemail/SQL/sqlite.update.sql

@@ -283 +283 @@
 
 CREATE INDEX ix_cache_messages_changed ON cache_messages (changed);
+
+DROP TABLE session;
+CREATE TABLE session (
+  sess_id varchar(128) NOT NULL PRIMARY KEY,
+  created datetime NOT NULL default '0000-00-00 00:00:00',
+  changed datetime NOT NULL default '0000-00-00 00:00:00',
+  ip varchar(40) NOT NULL default '',
+  vars text NOT NULL
+);
+
+CREATE INDEX ix_session_changed ON session (changed);