Sophie: lemonldap-ng-1.0-0.3.rc1mdv2011.0 noarch

lemonldap-ng-1.0-0.3.rc1mdv2011.0.noarch.rpm

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" lang="fr" xml:lang="fr">
<head>
  <meta name="generator" content=
  "HTML Tidy for Linux/x86 (vers 7 December 2008), see www.w3.org" />

  <title>Lemonldap::NG documentation: 4.4-MySQL-session-backend.html</title>
  <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" />
  <style type="text/css">
/*<![CDATA[*/
    body{
      background: #ddd;
      font-family: sans-serif;
      font-size: 11pt;
      padding: 0 50px;
    }
    div.main-content{
      padding: 10px;
      background: #fff;
      border: 2px #ccc solid;
    }
    a{
      text-decoration: none;
    }
    p.footer{
      text-align: center;
      margin: 5px 0 0 0;
    }
    .heading-1{
      text-align: center;
      color: orange;
      font-variant: small-caps;
      font-size: 20pt;
    }
    .heading-1-1{
      color: orange;
      font-size: 14pt;
      border-bottom: 2px #ccc solid;
    }
    pre{
      background: #eee;
      border: 2px #ccc solid;
      padding: 5px;
      border-left: 10px #ccc solid;
    }
    ul.star li{
      list-style-type: square;
    }
  /*]]>*/
  </style>
</head>

<body>
  <div class="main-content">
    <h2 class="heading-1"><span id="HUseofMySQLforsessionstorage">Use of MySQL
    for session storage</span></h2>

    <p class="paragraph"></p>

    <ul>
      <li>
        <a href="#HMySQLconfiguration">MySQL configuration</a>

        <ul>
          <li><a href="#HDatabasecreation">Database creation</a></li>

          <li><a href="#HSessiontable">Session table</a></li>
        </ul>
      </li>

      <li><a href="#HLemonLDAP3A3ANGconfiguration">LemonLDAP::NG
      configuration</a></li>
    </ul>

    <h3 class="heading-1-1"><span id="HMySQLconfiguration">MySQL
    configuration</span></h3>

    <p class="paragraph"></p><strong class="strong">Remark</strong>: we advice
    to create a specific user/password in MySQL for LemonLDAP::NG, with rights
    on ist database.

    <h4 class="heading-1-1-1"><span id="HDatabasecreation">Database
    creation</span></h4><br />
    <br />
    For example, create the database "lemonldapng" :<br />
    <br />

    <div class="code">
      <pre>
# mysqladmin create lemonldapng
</pre>
    </div>

    <h4 class="heading-1-1-1"><span id="HSessiontable">Session
    table</span></h4><br />
    <br />
    If you want to use Apache::Session::MySQL, you can create the database
    like this:<br />
    <br />

    <div class="code">
      <pre>
CREATE TABLE sessions (
    id <span class="java-object">char</span>(32),
    a_session blob
    );
</pre>
    </div>

    <h3 class="heading-1-1"><span id=
    "HLemonLDAP3A3ANGconfiguration">LemonLDAP::NG configuration</span></h3>

    <p class="paragraph"></p>Go to the Manager and go in <strong class=
    "strong">General Parameters &gt; Session Storage</strong>. Then change
    <strong class="strong">Apache::Session module</strong> to
    "Apache::Session::MySQL" and in <strong class="strong">Apache::Session
    parameters</strong> configure the following options:

    <ul class="star">
      <li>DataSource (for example:
      DBI:mysql:database=lemonldapng;host=127.0.0.1)</li>

      <li>UserName</li>

      <li>Password</li>

      <li>TableName</li>

      <li>LockDataSource</li>

      <li>LockUserName</li>

      <li>LockPassword</li>
    </ul>You can also set the session module in perl scripts:

    <div class="code">
      <pre>
globalStorage  =&gt; <span class="java-quote">"Apache::Session::MySQL"</span>,
  globalStorageOptions =&gt; {
      DataSource       =&gt; <span class=
"java-quote">"dbi:mysql:database=lemonldapng;host=127.0.0.1"</span>,
      UserName         =&gt; <span class="java-quote">"db_user"</span>,
      Password         =&gt; <span class="java-quote">"db_password"</span>,
      TableName        =&gt; <span class="java-quote">"sessions"</span>,
      LockDataSource   =&gt; <span class=
"java-quote">"dbi:mysql:database=lemonldapng;host=127.0.0.1"</span>,
      LockUserName     =&gt; <span class="java-quote">"db_user"</span>,
      LockPassword     =&gt; <span class="java-quote">"db_password"</span>,
  },
</pre>
    </div>
  </div>

  <p class="footer"><a href="index.html">Index</a></p>
</body>
</html>