Hi:

My records in the sessions DB seem strange.

id 7032f2c7f5a2c721a483dc75fc29595e a_session $D = {'_SESSION_ID' => '7032f2c7f5a2c721a483dc75fc...

The id field contains the SID while the second field is a mystery to me.

Some record contain names and/or expiration while others are like the one above with partial SID. It has ... following the data which implied more to follow but I cant see or find anymore.

Even the last record posted/updated did not contain the updated information that was put in the $session before flush().

Expiration appears in cookie fine but not in database record.

In the cpan documentation on session table it says two records minimum required. id and a_session, id being 32 characters and a_session a text field of undetermined length. Is that text where all the added/updated params are supposed to be? 

    Name    Type    Collation    Attributes    Null    Default    Extr
+a    Action
    1    id    varchar(32)    latin1_swedish_ci        No             
+Change Change    Drop Drop    

    Primary Primary
    Unique Unique
    Index Index
    Spatial Spatial
    More

    2    a_session    text    latin1_swedish_ci        No     None    
+    Change Change    Drop Drop    

    Primary Primary
    Unique Unique
    Index Index
    Spatial Spatial
    More

[download]

My experience with DB requires set field length.

MySQL says BLOB, TEXT L + 2 bytes, where L < 2^16 (64 Kilobytes)

So do you set a size or it just floats?

In reply to MySQL Session database record by tultalk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.