source: install/scripts/upgrades/0.9.2.php @ 420

#!/usr/bin/php4 -q
<?php

// Set the available memory to a large enough variable to be able to handle quite busy servers :) 
ini_set("memory_limit","128M");

// Script de migration des données LDAP vers les bases MYSQL de mx/imap
# dépendances de ce script:
# php4-cgi + php4-ldap + php4-mysql pour la migration ldap=>mysql du mail
# donc le script "0.9.1_migrationldap.php"

$config = "/var/alternc/bureau/class/local.php";
$bar = @include($config);
if ($bar === FALSE) {
  echo "cannot find the PHP config file: $config, aborting\n";
  exit(0);
}

function graceful_failure() {
  echo "assuming accounts have already been transfered\n";
  echo "if that is not the case:\n";
  echo " - make sure the LDAP server is running\n";
  echo " - make sure the login information is correct (in $config)\n";
  echo " - restart this script (".$_SERVER['argv'][0].")\n";
  exit(0);
}

// On a chargé un fichier de local.php version antérieure, donc AVEC LDAP et SANS mysql_host (surement)

// Connect to the ldap server

if (!($ds=ldap_connect($L_LDAP_HOST))) {
  echo "cannot connect to ldap server \"$L_LDAP_HOST\"\n";
  graceful_failure();
}

if (!(ldap_bind($ds,$L_LDAP_ROOT,$L_LDAP_ROOTPWD))) {
  ldap_close($ds);
  echo "cannot bind to ldap server \"$L_LDAP_HOST\" with user \"$L_LDAP_ROOT\"\n";
  graceful_failure();
}

// Connect to the mysql server
if (!mysql_connect($L_MYSQL_HOST,$L_MYSQL_LOGIN,$L_MYSQL_PWD)) {
   echo "cannot connect to mysql server\n";
   return 1;
}
if (!mysql_select_db($L_MYSQL_DATABASE)) {
   echo "cannot connect to mysql database\n";
   return 1;
}

// Now enumerate the data for each base.
$sr=ldap_search($ds,"dc=domains,".$L_LDAP_POSTFIX,"(objectclass=mail)",
                array("mail","uid","account","pop","type"));
$info = ldap_get_entries($ds, $sr);
if ($info["count"]==0) {
    echo "INFO : Aucun mail dans la base DOMAINS \n";
}

echo "Transferring ".$info["count"]." Entries from domains ";
for($i=0;$i<$info["count"];$i++) {
  if ($info[$i]["type"][0]=="mail") $type=0; else $type=1;

    mysql_query("INSERT INTO mail_domain (mail,alias,uid,pop,type) VALUES ('".
                addslashes($info[$i]["mail"][0])."','".
                addslashes(join("\n", $info[$i]["account"]))."','".
                addslashes($info[$i]["uid"][0])."','".
                addslashes($info[$i]["pop"][0])."','$type');");
    if (($i/10.0)==intval($i/10)) { echo "."; flush(); }
}
echo " done\n";

$sr=ldap_search($ds,"dc=aliases,".$L_LDAP_POSTFIX,"(objectClass=alias)",
                array("mail","alias"));
$info = ldap_get_entries($ds, $sr);
if ($info["count"]==0) {
    echo "INFO : Aucun mail dans la base ALIASES \n";
}

echo "Transferring ".$info["count"]." Entries from aliases ";
for($i=0;$i<$info["count"];$i++) {
    mysql_query("INSERT INTO mail_alias (mail,alias) VALUES ('".
                addslashes($info[$i]["mail"][0])."','".
                addslashes($info[$i]["alias"][0])."');");
    if (($i/10.0)==intval($i/10)) { echo "."; flush(); }
}
echo " done\n";


$sr=ldap_search($ds,"dc=users,".$L_LDAP_POSTFIX,"(objectClass=posixAccount)",
                array("uid","gidNumber","homeDirectory","userPassword"));
$info = ldap_get_entries($ds, $sr);
if ($info["count"]==0) {
    echo "INFO : Aucun mail dans la base USERS \n";
}


echo "Transferring ".$info["count"]." Entries from users ";
for($i=0;$i<$info["count"];$i++) {
  // echo serialize($info[$i])."\n";
  $pass=substr($info[$i]["userpassword"][0],7);
  mysql_query("INSERT INTO mail_users (uid,alias,path,password) VALUES ('".
              addslashes($info[$i]["gidnumber"][0])."','".
              addslashes($info[$i]["uid"][0])."','".
              addslashes($info[$i]["homedirectory"][0])."','".
              addslashes($pass)."');");
    if (($i/10.0)==intval($i/10)) { echo "."; flush(); }
}
echo " done\n";

mysql_close();
ldap_close($ds);

?>