Help - I need somebody, Help - not just anybody, Help - I need somebody nnnoooooowwwww.<br><br>I&#39;ve been working through dovecot.conf and main.inc.php and db.inc.php and have tried various changes but nothing I do has been able to resolve this problem.<br>
<br>The MySQL connection is clearly working as the session and user tables are being populated.<br>The Dovecot connection appears to be working as the log indicates a &quot;secured&quot; access.<br>There is data in the /home/postmaster/Maildir directory and I&#39;m logging in with &quot;postmaster&quot;.<br>
I&#39;ve reset the password for &quot;postmaster&quot; so I know I&#39;m entering the correct details.<br><br>Yet still I get &quot;Login failed&quot;.<br><br>I must be missing something - are you able to give me any clues as to where to look?<br>
<br>Cheers<br>Murray<br><br><br><div class="gmail_quote">On 19 April 2011 23:56, Murray Collingwood <span dir="ltr">&lt;<a href="mailto:murray@focus-computing.com.au">murray@focus-computing.com.au</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi folks<br><br>I would appreciate some ideas of where to look to try and solve my problem.<br>
<br>I am setting up a new server (have RoundCube installed on my old server and has been working perfectly for over 2 years).<br>
I have run the install on Debian Squeeze using aptitude, including &#39;roundcube&#39;, &#39;roundcube-core&#39; and &#39;roundcube-mysql&#39;.<br><br>The database has been created and contains 6 tables.<br><br>I have Apache2 and MySQL5 running and they seem to be working fine.  <br>

<br>In my browser I type <a href="http://server-url/roundcube" target="_blank">http://server-url/roundcube</a> and the login page appears.<br><br>I enter &quot;postmaster&quot; as the username and the password but I get the message &quot;Login failed&quot;<br>

<br>In the &quot;syslog&quot; I get messages that indicate the IMAP login was successful (to Dovecot), however it immediately logs out:<br><blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">

Apr 19 23:10:41 ds5683 dovecot: imap-login: Login: user=&lt;postmaster&gt;, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured<br>Apr 19 23:10:41 ds5683 dovecot: IMAP(postmaster): Disconnected: Logged out bytes=39/443<br>

</blockquote><br>In the roundcube &quot;errors&quot; log (the php log file) I get messages indicating the database connection may not be working as in these:<br><blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">

[19-Apr-2011 23:05:10 +1000]: PHP Error: Failed to create new user in /usr/share/roundcube/program/include/rcube_user.php on line 451 (POST /roundcube/?_task=&amp;_action=login)<br>[19-Apr-2011 23:05:10 +1000]: PHP Error: Failed to create a user record. Maybe aborted by a plugin? (POST /roundcube/?_task=&amp;_action=login)<br>

</blockquote><br>However in the database there are actually records being created in the &#39;users&#39; table:<br><table><thead><tr>
            <th>user_id
</th><th>username
</th><th>mail_host
</th><th>alias
</th><th>created
</th><th>last_login
</th><th>language
</th><th>preferences
</th></tr>
</thead>
        <tbody>
    <tr>
    
    
    
<td align="right">1</td>
<td>postmaster</td>
<td>localhost</td>
    <td> </td>
<td>2011-04-19 23:22:23</td>
<td>2011-04-19 23:22:23</td>
<td>en_US</td>
    <td><i>NULL</i></td></tr></tbody></table><br>There&#39;s data in the &#39;session&#39; table also:<br><table><thead><tr>
            <th>sess_id
</th><th>created
</th><th>changed
</th><th>ip
</th><th>vars
</th></tr>
</thead>
        <tbody>
    <tr>
    
    
    
<td>mm6ld61j9ekan5fief4ocikig3</td>
<td>2011-04-19 23:22:23</td>
<td>2011-04-19 23:22:23</td>
<td>122.148.149.28</td>
    <td>language|s:5:&quot;en_US&quot;;auth_time|i:1303219343;temp|b...</td></tr></tbody></table><br><br>The Apache log shows me a little more detail about the error but essentially indicates that the database error was an attempt to add a duplicate primary key:<br>

<blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">[Tue Apr 19 23:10:23 2011] [error] [client 122.148.149.28] MDB2 Error: constraint violation (-3): _doQuery: [Error message: Could not execute statement]\n[Last executed query: EXECUTE mdb2_statement_mysql_3d2cec1a51699f95fdead7b1b9c2cc9f52dd15da3 USING @0, @1, @2]\n[Native code: 1062]\n[Native message: Duplicate entry &#39;mm6ld61j9ekan5fief4ocikig3&#39; for key &#39;PRIMARY&#39;]\n<br>

</blockquote><br><br>The question is why is RoundCube trying to add a duplicate entry... what is making it think it needs to add this user again???<br><br>If somebody can point me in the right direction as to what I should be looking for that would be really helpful.<br>

<br>I&#39;ve Googled all over the place and while there are a few articles about this problem of creating new users there was no definitive solution, and none of the suggestions offered seemed to help me at all.  I tried looking for security issues but couldn&#39;t find any.  Found some table fields that were not supposed to be &#39;null&#39; and allowed them to be hoping that this may solve the problem as one website suggested, but again no luck.<br>

<br>Cheers<br>Murray<br><font color="#888888"><br clear="all"><br>-- <br>Murray Collingwood<br>Focus Computing<br>p +61 415 24 26 24<br><a href="http://www.focus-computing.com.au" target="_blank">http://www.focus-computing.com.au</a><br>

</font></blockquote></div><br><br clear="all"><br>-- <br>Murray Collingwood<br>Focus Computing<br>p +61 415 24 26 24<br><a href="http://www.focus-computing.com.au">http://www.focus-computing.com.au</a><br>