<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
pre
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:595.3pt 841.9pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-GB link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Hello<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I’m attempting to pull user accounts/passwords from a
mySQL database to use in my pmwiki installation.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I have followed the steps described by AuthUser-Dbase and
have added the following to the local/config.php file (passwords replaced with
*):<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt;background:#D9D9D9'><font size=2
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'>##
Create a database connection for adodb-connect.php<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt;background:#D9D9D9'><font size=2
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'>$Databases['dbase_usrs']
= array(<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt;background:#D9D9D9'><font size=2
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'> 'driver'
=> 'mysql',<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt;background:#D9D9D9'><font size=2
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'> 'hostname'
=> 'localhost',<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt;background:#D9D9D9'><font size=2
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'> 'database'
=> 'sourcera_sourceradio',<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt;background:#D9D9D9'><font size=2
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'> 'username'
=> 'sourcera_sourcer',<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt;background:#D9D9D9'><font size=2
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'> 'password'
=> '********');<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt;background:#D9D9D9'><font size=2
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'>#<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt;background:#D9D9D9'><font size=2
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'>//
which table contains the username & password data?<o:p></o:p></span></font></p>
<pre style='margin-left:36.0pt;background:#D9D9D9'><font size=2
face="Courier New"><span style='font-size:10.0pt'>$AUDBaseTable['database'] = 'sourcera_sourceradio';<o:p></o:p></span></font></pre>
<p class=MsoNormal style='margin-left:36.0pt;background:#D9D9D9'><font size=2
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'>$AUDBaseTable['user_table']
= 'sfm_users';<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt;background:#D9D9D9'><font size=2
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'>#<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt;background:#D9D9D9'><font size=2
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'>$AUDBaseTable['user_field']
= 'username';<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt;background:#D9D9D9'><font size=2
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'>$AUDBaseTable['pw_field']
= 'password';<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt;background:#D9D9D9'><font size=2
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'>#<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt;background:#D9D9D9'><font size=2
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'>//
which password encryption scheme to use<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt;background:#D9D9D9'><font size=2
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'>//
normally "md5" or "sha1".<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt;background:#D9D9D9'><font size=2
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'>//
May also be admin-defined function; use the name of the function,<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt;background:#D9D9D9'><font size=2
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'>//
and define the function in config.php<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt;background:#D9D9D9'><font size=2
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'>$AUDBaseTable['encrypt_f']
= 'md5';<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt;background:#D9D9D9'><font size=2
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt;background:#D9D9D9'><font size=2
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'>include_once("$FarmD/cookbook/AuthUserDbase-2.0.0.php");<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt;background:#D9D9D9'><font size=2
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt;background:#D9D9D9'><font size=2
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'>#
Must be at the end!!!!!!<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt;background:#D9D9D9'><font size=2
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'>include_once('scripts/authuser.php');<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New"'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I have also added this in Site.AuthUser:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>AUD: required for
AuthUserDatabase<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New"'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>However, when setting a password via the action=attr page,
and then reloading it and typing a valid user, I get this error:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span
style='font-size:12.0pt;font-weight:bold'>Fatal error</span></font></b>: Call
to undefined function: adodbconnect() in <b><span style='font-weight:bold'>/home/sourcera/public_html/members/wiki/pmwiki-2.1.26/cookbook/AuthUserDbase-2.0.0.php</span></b>
on line <b><span style='font-weight:bold'>280<o:p></o:p></span></b></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span
style='font-size:12.0pt;font-weight:bold'><o:p> </o:p></span></font></b></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Any help or suggestions appreciated.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Lawrie</span></font><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'><o:p></o:p></span></font></p>
</div>
</body>
</html>