Databases
StackOverflow2013
Postsdbo
PONO QUERY using CakePHP Authentication component
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PONO QUERY using CakePHP Authentication component
    primarykey
    data
    text
    <p>I'm using CakePHP 2.2.4, and I have started to work with Atuh Componenet.</p> <p>This is my AppController:</p> <pre><code>class AppController extends Controller { public $components = array('Auth', 'Session'); public function beforeFilter() { $this-&gt;Auth-&gt;authorize = array('Controller'); $this-&gt;Auth-&gt;authenticate = array( 'Form' =&gt; array ( 'scope' =&gt; array('User.active' =&gt; 1), 'fields' =&gt; array('username' =&gt; 'email', 'password' =&gt; 'password'), ) ); } public function isAuthorized($user) { debug($user); return true; } } </code></pre> <p>This is my User.php model</p> <pre><code>class User extends AppModel { public $name = 'User'; /* Relazioni */ public $hasOne = 'Profile'; public $belongsTo = 'Role'; public $hasMany = array( 'Lead' =&gt; array( 'className' =&gt; 'Lead' ) ); } </code></pre> <p>and this is my UserController.php</p> <pre><code>&lt;?php App::uses('AppController', 'Controller'); class UsersController extends AppController { public $name = 'Users'; public $uses = array(); public function beforeFilter() { parent::beforeFilter(); } public function login() { if ($this-&gt;request-&gt;is('post')) { if ($this-&gt;Auth-&gt;login()) { debug('Logged'); } else { $this-&gt;Session-&gt;setFlash('Login non autorizzato', 'default', array('class' =&gt; 'errore'), 'login'); } } } public function logout() { $this-&gt;redirect($this-&gt;Auth-&gt;logout()); } } </code></pre> <p>I have a strange problem using Auth Component, because at the end of the layout I have sql_dump element, that prints NO QUERY.</p> <p>However, If i put correct values I do not login</p> <p>Why does Auth component is not working ?</p> <p><strong>EDIT:</strong></p> <p>The data of the request is:</p> <pre><code>Array ( [User] =&gt; Array ( [email] =&gt; test@test.it [pwd] =&gt; abc ) ) </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USDail
    1. USDail
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PONO QUERY using CakePHP Authentication component
      1. This table or related slice is empty.
      1. VTDownMod
    2. VO
      singulars
      1. PONO QUERY using CakePHP Authentication component
      1. This table or related slice is empty.
      1. VTDownMod
    1. COare you sure the user you are logging in as `active` is set to true?
      singulars
      1. PONO QUERY using CakePHP Authentication component
      1. USTim Joyce
    2. CO@TimJoyce sure, i ma sure..it is set to 1. Btw i think the query is not execute, as i told you in sql_dump element i do not see any output (in other pages i see the dump correctly)
      singulars
      1. PONO QUERY using CakePHP Authentication component
      1. USDail
    3. COadd `pr($this->request->data);` to your appController before filter at the top then attempt to login and let's see the output there.
      singulars
      1. PONO QUERY using CakePHP Authentication component
      1. USTim Joyce
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload