Can't upgrade mySQL as directed.. problems in general with IMAP

[kinesis]

I cant do this
/opt/lampp/bin/mysql -u root -p mysql < mysql.upgrade.sql

result is:
[root@lunar SQL]# /opt/lampp/bin/mysql -u root -p mysql < mysql.update.sql
Enter password:
ERROR 1146 (42S02) at line 4: Table 'mysql.messages' doesn't exist
[root@lunar SQL]#


Then I also have problems logging in and reading email...

[02-Oct-2009 22:55:51 -0700]: IMAP Error: Empty startup greeting (mail.xxx.com:143) (GET /?_task=mail&_action=getunread&_remote=1&_=1254549682750&_unlock=0)
[02-Oct-2009 22:55:59 -0700]: IMAP Error: Empty startup greeting (mail.xxx.com:143) (GET /?_task=mail&_action=getunread&_remote=1&_=1254549690405&_unlock=0)
[02-Oct-2009 22:58:00 -0700]: IMAP Error: Empty startup greeting (mail.xxx.com:143) (GET /?_task=mail&_action=getunread&_remote=1&_=1254549811165&_unlock=0)


Also at one point i saw a cool new blue roundcube logo, but it vanished, now i have the old red one.. how do ig et the new logo back?

Also let it be known that, I am currently running my backup folder of doc-root for 0.2.2 and it works fine, only when I try to replace all the files in doc-root with the ones for 0.3 does it break! It wont connect to my IMAP for some reason.

[martensson]

kinesis,

First of all, you should select the right database on which you will perform the upgrade (probably roundcube or roundcubemail), so:

/opt/lampp/bin/mysql -D roundcube -u root -p mysql < mysql.upgrade.sql

I sincerely hope so this isn't your real password behind the -p , that would be foolish to publish on the internet.

Please first fix the database connection, then post the status back to the forum.. The other message provided could be a lot of things...

[kinesis]

[root@lunar SQL]# /opt/lampp/bin/mysql -D roundcube -u root < mysql.update.sql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[root@lunar SQL]# /opt/lampp/bin/mysql -D roundcube -u root -p mysql < mysql.update.sql
Enter password:
ERROR 1146 (42S02) at line 4: Table 'mysql.messages' doesn't exist
[root@lunar SQL]# /opt/lampp/bin/mysql -D roundcubemail -u root -p mysql < mysql.update.sql
Enter password:
ERROR 1146 (42S02) at line 4: Table 'mysql.messages' doesn't exist
[root@lunar SQL]# nano mysql.update.sql
---- i edit the .sql file to remove the old stuff, and leave stuff strictly for 0.2 ----
[root@lunar SQL]# /opt/lampp/bin/mysql -D roundcubemail -u root -p mysql < mysql.update.sql
Enter password:
ERROR 1146 (42S02) at line 1: Table 'mysql.cache' doesn't exist
[root@lunar SQL]# /opt/lampp/bin/mysql -D roundcube -u root -p mysql < mysql.update.sql
Enter password:
ERROR 1146 (42S02) at line 1: Table 'mysql.cache' doesn't exist
[root@lunar SQL]#

[kinesis]

ok I got the mysql portion to work (i think...)


now this error:
IMAP connect:  NOT OK(Empty startup greeting (mail.xxx.com:143))


Ok used "localhost" instead
now it says IMAP connect: OK

However, when I try to login to the webmail (PM me for URL if you like)

I get a red box on top that says "Your session is invalid or expired" and the login fields reset to blank...

[kinesis]

Now I can login OK, but as soon as I double click an email message in my INBOX I get "Your session is Invalid or Expired" then I get booted back to the login screen!


Error log indicates:
[root@lunar doc-root]# cat logs/errors
[03-Oct-2009 11:52:29 -0700]: IMAP Error: Empty startup greeting (localhost:143) (GET /?_task=mail&_action=getunread&_remote=1&_=1254596282459&_unlock=0)
[03-Oct-2009 11:52:40 -0700]: IMAP Error: Empty startup greeting (localhost:143) (POST /?_task=&_action=login)
[03-Oct-2009 11:53:12 -0700]: IMAP Error: Empty startup greeting (localhost:143) (GET /?_task=mail&_action=getunread&_remote=1&_=1254596325477&_unlock=0)
[03-Oct-2009 11:53:45 -0700]: IMAP Error: Empty startup greeting (localhost:143) (GET /?_task=mail&_action=show&_uid=4050&_mbox=INBOX)
[03-Oct-2009 11:53:45] PHP Warning:  fputs(): supplied argument is not a valid stream resource in /mnt/extra/www/roundcube.xxx.com/doc-root/program/lib/imap.inc on line 205
[03-Oct-2009 11:53:45 -0700]: IMAP Error: Empty startup greeting (localhost:143) (GET /?_task=mail&_action=getunread&_remote=1&_=1254596358495&_unlock=0)
[root@lunar doc-root]#

Now, in attempting to login again, it says "Connection to IMAP server failed" and it clears the login/password box and refuses to login!

Here is my IMAP:

[root@lunar doc-root]# telnet 0 143
Trying 0.0.0.0...
Connected to 0 (0.0.0.0).
Escape character is '^]'.
* OK dovecot ready.
^]
telnet> cl
Connection closed.


EDIT: Appears to be a bug, wget of http://trac.roundcube.net/export/2972/trunk/roundcubemail/program/lib/imap.inc  and replacing program/lib/imap.inc has fixed. Works fine now. Thank you.


EDIT: ALL MY IDENTITIES ARE GONE - where did they go?!