Log in Server behavior not working.

3/18/2015 8:16 am | #1 anonymous

Have record set established and have completed the behavior requirements per your form. I have been through the help files and nothing solves the issue. Authentication not working. success nor failure redirects working. It seems as if the app isn't checking form entries against the database. I have tried every option available with no luck. Your help is required.

3/18/2015 8:24 am | #3 anonymous

Originally Said By: Jason Byrnes

please send a copy of the page so i can see the code.

3/18/2015 8:24 am | #4 Jason ByrnesWebAssist

in the login behavior, you have bound the user_id and password column to the fields from the recordset, you should be using the login form bindings.

also, i'm not sure why you are using the user_id column, you should be using the user name and password columns and binding them to the corresponding form elements.

3/18/2015 8:35 am | #5 anonymous

So what you are saying is on the "Find record" tab in your server behavior I should not use the dynamic selector to select my database fields to be compared against and should instead use the form field ID's ? Also, the usr_id is the user name field in the database.

3/18/2015 8:40 am | #8 anonymous

<?php require_once('Connections/ADPOPi.php'); ?>
<?php require_once('webassist/mysqli/rsobj.php'); ?>
<?php require_once('webassist/mysqli/authentication.php'); ?>
<?php
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$Authenticate = new WA_MySQLi_Auth($ADPOPi);
$Authenticate->Action = "authenticate";
$Authenticate->Name = "";
$Authenticate->Table = "sys_user";
$Authenticate->addFilter("usr_id", "=", "s", "".($rs_users->getColumnVal("usr_id")) ."");
$Authenticate->addFilter("usr_pwd", "=", "s", "".($rs_users->getColumnVal("usr_pwd")) ."");
$Authenticate->storeResult("usr_id", "usr");
$Authenticate->storeResult("usr_pwd", "pass");
$Authenticate->storeResult("usr_site_id", "site");
$Authenticate->AutoReturn = true;
$SuccessRedirect = "success.php";
$FailedRedirect = "failure.php";
if (function_exists("rel2abs")) $SuccessRedirect = $SuccessRedirect?rel2abs($SuccessRedirect,dirname(__FILE__)):"";
if (function_exists("rel2abs")) $FailedRedirect = $FailedRedirect?rel2abs($FailedRedirect,dirname(__FILE__)):"";
$Authenticate->SuccessRedirect = $SuccessRedirect;
$Authenticate->FailRedirect = $FailedRedirect;
$Authenticate->execute();
}
?>

<?php
$rs_users = new WA_MySQLi_RS("rs_users",$ADPOPi,1);
$rs_users->setQuery("SELECT * FROM sys_user");
$rs_users->execute();
?>
<!doctype html>
<html>
<head>
<meta charset="UTF-8">
<title>/title>
<link href="CSS/adpop.css" rel="stylesheet" type="text/css">
</head>

<body id="loginbg">
<form METHOD="post" id="login" title="Login"><table class="centered" width="300" border="0" cellpadding="1">
<tbody>
<tr>
<td bgcolor="#000000"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td height="20"><font color="#CAC6C6" face="Gotham, Helvetica Neue, Helvetica, Arial, sans-serif" > Please Login </font></td>
</tr>
<tr>
<td bgcolor="#CAC6C6"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td width="26%"> </td>
<td width="8%"> </td>
<td width="66%" colspan="2"> </td>
</tr>
<tr>
<td> Username:</td>
<td width="8%"> </td>
<td width="33%"><input type="text" name="user" id="user"></td>
<td width="33%" rowspan="2"><img src="images/aad_logo_v3_6001.png" width="150" height="55" alt=""/></td>
</tr>
<tr>
<td> Password:</td>
<td> </td>
<td><input type="password" name="pass" id="pass"></td>
</tr>
<tr>
<td colspan="4" height="3"></td>
</tr>
<tr>
<td colspan="1">  <input type="submit" name="submit" id="submit" value="Log In"></td><td></td><td> </td><td align="center"><font size="-1" face="Gotham, Helvetica Neue, Helvetica, Arial, sans-serif">Forgot Password?</font></td>
</tr>
<tr>
<td colspan="4" height="3"></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table></form>

</body>
</html>

3/18/2015 9:09 am | #9 Jason ByrnesWebAssist

you are still using the recordset bindings on the Find Record tab:
$Authenticate->addFilter("usr_id", "=", "s", "".($rs_users->getColumnVal("usr_id")) ."");
$Authenticate->addFilter("usr_pwd", "=", "s", "".($rs_users->getColumnVal("usr_pwd")) ."");

These should be using the user and pass form element bindings instead of the recordset bindings.

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Log in Server behavior not working.

3/18/2015 8:16 am | #1 anonymous