Contents of /mod_auth_ibmdb2/scripts/sync_pwds

#!/usr/local/bin/php
<?php

// $Id: sync_pwds,v 1.3 2006/10/22 12:28:07 tessus Exp $

putenv ("DB2INSTANCE=db2inst1");
putenv ("LD_LIBRARY_PATH=:/home/db2inst1/sqllib/lib");
putenv ("LIBPATH=:/home/db2inst1/sqllib/lib");

require ('./config.php');

$handle = fopen ("/etc/shadow", "r");

while (!feof ($handle)) 
{
    $line = fgets($handle, 512);
    
    list($username,$password) = explode(":",$line);
    
    if( $username != '' && $username != 'root' && $password != '*' && $password != '!!')
    {
       $arr["$username"] = $password;
    }
}
    
fclose ($handle);

$conn = db2_connect( $dbname, $dbuser, $dbpwd );

echo "\nSyncing system users with table '$usertable' in database '$dbname'\n\n";

$i = 0;
$ni = 0;

foreach ($arr as $u => $p)
{
   $insert = "insert into $usertable ($namefield, $passwordfield) values ('$u', '$p')";
   $res=@db2_exec( $conn, $insert );
      
   if( $res != FALSE )
   {
      echo "User $u synced.\n";
      $i++;
   }
   else
   {
      $update = "update $usertable set ($passwordfield) = ('$p') where $namefield = '$u'";
      $res=@db2_exec( $conn, $update );
      
      if( $res != FALSE )
      {
         echo "User $u synced.\n";
         $i++;
      }
      else
      {
         echo "User $u NOT synced.\n";
         $ni++;
      }
   }   
}

echo "\n";
echo "Users synced: $i\n";
echo "Users rejected: $ni\n";
echo "\n";

return 0;

?>
1	#!/usr/local/bin/php
2	<?php
3
4	// $Id: sync_pwds,v 1.3 2006/10/22 12:28:07 tessus Exp $
5
6	putenv ("DB2INSTANCE=db2inst1");
7	putenv ("LD_LIBRARY_PATH=:/home/db2inst1/sqllib/lib");
8	putenv ("LIBPATH=:/home/db2inst1/sqllib/lib");
9
10	require ('./config.php');
11
12	$handle = fopen ("/etc/shadow", "r");
13
14	while (!feof ($handle))
15	{
16	$line = fgets($handle, 512);
17
18	list($username,$password) = explode(":",$line);
19
20	if( $username != '' && $username != 'root' && $password != '*' && $password != '!!')
21	{
22	$arr["$username"] = $password;
23	}
24	}
25
26	fclose ($handle);
27
28	$conn = db2_connect( $dbname, $dbuser, $dbpwd );
29
30	echo "\nSyncing system users with table '$usertable' in database '$dbname'\n\n";
31
32	$i = 0;
33	$ni = 0;
34
35	foreach ($arr as $u => $p)
36	{
37	$insert = "insert into $usertable ($namefield, $passwordfield) values ('$u', '$p')";
38	$res=@db2_exec( $conn, $insert );
39
40	if( $res != FALSE )
41	{
42	echo "User $u synced.\n";
43	$i++;
44	}
45	else
46	{
47	$update = "update $usertable set ($passwordfield) = ('$p') where $namefield = '$u'";
48	$res=@db2_exec( $conn, $update );
49
50	if( $res != FALSE )
51	{
52	echo "User $u synced.\n";
53	$i++;
54	}
55	else
56	{
57	echo "User $u NOT synced.\n";
58	$ni++;
59	}
60	}
61	}
62
63	echo "\n";
64	echo "Users synced: $i\n";
65	echo "Users rejected: $ni\n";
66	echo "\n";
67
68	return 0;
69
70	?>