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.
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...
[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]#
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...
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?!