Hi folks
I would appreciate some ideas of where to look to try and solve my problem.
I am setting up a new server (have RoundCube installed on my old server and
has been working perfectly for over 2 years).
I have run the install on Debian Squeeze using aptitude, including
'roundcube', 'roundcube-core' and 'roundcube-mysql'.
The database has been created and contains 6 tables.
I have Apache2 and MySQL5 running and they seem to be working fine.
In my browser I type http://server-url/roundcube and the login page appears.
I enter "postmaster" as the username and the password but I get the message
"Login failed"
In the "syslog" I get messages that indicate the IMAP login was successful
(to Dovecot), however it immediately logs out:
> Apr 19 23:10:41 ds5683 dovecot: imap-login: Login: user=<postmaster>,
> method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured
> Apr 19 23:10:41 ds5683 dovecot: IMAP(postmaster): Disconnected: Logged out
> bytes=39/443
>
In the roundcube "errors" log (the php log file) I get messages indicating
the database connection may not be working as in these:
> [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=&_action=login)
> [19-Apr-2011 23:05:10 +1000]: PHP Error: Failed to create a user record.
> Maybe aborted by a plugin? (POST /roundcube/?_task=&_action=login)
>
However in the database there are actually records being created in the
'users' table:
user_id username mail_host alias created last_login language preferences 1
postmaster localhost 2011-04-19 23:22:23 2011-04-19 23:22:23 en_US *NULL*
There's data in the 'session' table also:
sess_id created changed ip vars mm6ld61j9ekan5fief4ocikig3 2011-04-19
23:22:23 2011-04-19 23:22:23 122.148.149.28
language|s:5:"en_US";auth_time|i:1303219343;temp|b...
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:
> [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
> 'mm6ld61j9ekan5fief4ocikig3' for key 'PRIMARY']\n
>
The question is why is RoundCube trying to add a duplicate entry... what is
making it think it needs to add this user again???
If somebody can point me in the right direction as to what I should be
looking for that would be really helpful.
I'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't find any. Found some table fields that
were not supposed to be 'null' and allowed them to be hoping that this may
solve the problem as one website suggested, but again no luck.
Cheers
Murray
--
Murray Collingwood
Focus Computing
p +61 415 24 26 24
http://www.focus-computing.com.au
--
List info: http://lists.roundcube.net/users/
BT/9b404e9e
Dear Roundcube users and lovers,
We're happy to announce another release of the Roundcube webmail
suite. This service update brings some more bug fixes and stability
improvements and it includes an updated version of the TinyMCE editor
which is now supposed to work correctly in IE9.
It is considered stable and we recommend to update all existing
Roundcube installation with this release. For a complete list of
changes see http://trac.roundcube.net/wiki/Changelog. Packages can be
downloaded from the usual place: http://roundcube.net/download
Have fun and happy easter,
Thomas
--
List info: http://lists.roundcube.net/users/
BT/9b404e9e
Hi,
> [27-Apr-2011 19:15:25] PHP Deprecated: Assigning the return value of
> new by reference is deprecated in /usr/share/php/MDB2.php on line 2647
This is an error message from the PEAR MDB2 package not from Roundcube
itself.
Roundcube seems to use PEAR MDB2 package for database connectivity. The
current stable release of MDB2 uses assignments by reference (=& new ).
There is a newer beta of the MDB2 package available where changelog says
dropped php4 support and php5.3 fixes. It can be installed by shell command
"pear upgrade MDB2-beta" or you can grab it from
http://pear.php.net/package/MDB2/download/
--Martin
--
List info: http://lists.roundcube.net/users/
BT/9b404e9e
Platform: Debian 6.0 Squeeze i386
RC rev: 0.3.1-6
Symptom: Immediately after RC login and seeing the mailbox view I am
instantly redirected back to the login page. This occurs via http and
https, with or without https redirection enabled. I did not have this
problem immediately after the Squeeze upgrade when I tested all apps on
the server to make sure they were all working.
Relevant Log entries:
...
[27-Apr-2011 19:15:25] PHP Deprecated: Assigning the return value of
new by reference is deprecated in /usr/share/php/MDB2.php on line 2647
[27-Apr-2011 19:15:28] PHP Deprecated: Assigning the return value of
new by reference is deprecated in /usr/share/php/MDB2.php on line 393
[27-Apr-2011 19:15:28] PHP Deprecated: Assigning the return value of
new by reference is deprecated in /usr/share/php/MDB2.php on line 2647
Related information:
I can't recall the exact details, but an issue unrelated to Roundcube
forced me to remove and reinstall one of the php packages on the system.
I'm guessing this is the source of the problem. There are 234 php and
related packages in Debian 6.0 and I have no idea which one(s) I need to
reinstall to fix this problem.
Any help would be greatly appreciated.
Thanks.
--
Stan
--
List info: http://lists.roundcube.net/users/
BT/9b404e9e
On 2011-04-20 1:03 PM, Arthur Titeica wrote:
>
>
> On Thu, 17 Mar 2011 14:53:00 -0700, Jim Pazarena wrote:
>
>> I recently discovered a hacker (IP: 41.211.223.83)
>> ALL SHOULD BLACKLIST who signed on to my roundcube system
>> with login credentials of a legitimate user, and used
>> roundcube to send out 82 emails (junk "I have a proposal for
>> you") to hundreds of recipients EACH.
>>
>> comments please!
>
> What roundcube version you have?
this was 0.5
I recently upgraded to 0.5.1
Incidentally, I found a SECOND roundcube 'hack'. Hundreds more
spam sent out thru roundcube.
What concerns me is that the attack seemed automated in that
the number of emails in the short time spam could not have
been injected manually. Suggesting a bot of some sort automatically
inserting the spam thru the web interface.
--
List info: http://lists.roundcube.net/users/
BT/9b404e9e
I was receiving a "Server Error (OK)" when trying to look at any
folder. The contents of the folder were not displayed. Mail could be
sent, settings could be viewed, but no messages were displayed. This
occurred after an upgrade of PHP, Apache and several other applications
on my Ubuntu server.
Alec, the Roundcube developer extraordinaire, saw what appeared to be
an issue with compression. We were able to determine that mod_deflate
was the culprit. Commenting out "SetOutputFilter DEFLATE" in the
.htaccess file solved the issue and now folders can be viewed. I'm
working to track down where the exact issue with mod_deflate lies, but
this appears to have solved the issue.
Thanks for everyone's help!
Chris
--
List info: http://lists.roundcube.net/users/
BT/9b404e9e
Hello.
I would like to know is there any effort to implement SQLite 3.x support
in Roundcube?
--
List info: http://lists.roundcube.net/users/
BT/9b404e9e
Whenever I try yo login, it instantly gives "Your session is invalid or
expired".
May I know what I'm doing wrong?
Regards,
Test
--
List info: http://lists.roundcube.net/users/
BT/9b404e9e
By the way, I did make the change to the app.js.src file and it doesn't
seem to make a difference.
Chris
--
List info: http://lists.roundcube.net/users/
BT/9b404e9e
debug_level is 8 and I've turned debugging options "on" across the
board. No errors are showing up anywhere. The imap log shows
everything working right. Apache doesn't show anything weird.
Silly question about the patch you link to. It shows modifying app.js,
but the line is in app.js.src. Also, it's not at line 5390 in
app.js.src - it's at 5166 ($Id: app.js 4666 2011-04-17 09:34:02Z alec).
Am I supposed to be modifying it there? I can't see where app.js.src and
app.js relate, but once again - I'm not a programmer.
Thanks!
Chris
>On 21.04.2011 04:01, Chris wrote:
>
>> I've tried a million things. The Dovecot maildir issues are
>> resolved.
>> No errors show up in the roundcube sql or imap logs, nor in the
>> Apache
>> or Dovecot logs. As a matter of fact, the imap log shows the
>> complete
>> imap transaction as functioning correctly. Yet I can't view the
>> contents of any mailbox or folder - I get "Server Error (OK)"
>> consistently. I'm assuming this is a Javascript/HTTP error of some
>> sort. I'm not sure where the "OK" comes from. Anyway, it's driving
>> me insane. Any suggestions on how to debug this?
>
>What's your debug_level setting? Check with this patch
>http://trac.roundcube.net/changeset/4681
--
List info: http://lists.roundcube.net/users/
BT/9b404e9e