Please help ?

[smallhagrid]

Hi Folks.
I've been using my hosting's installation of RoundCube for some time, but it kept throwing errors and the hosting support was no help - so I used the Softaculous there to install my own.
(It is Roundcube 0.7.2)

Great - much faster and more stable than theirs, but...

1. Upon log-in I get a momentary pink banner saying 'Server Error !' - which vanishes and all seems well...?

2. At 1st log-in it was already filled with 'admin', but I've seen no mention of this - is there a way to log-in as admin ?

3. I keep getting 'Session Invalid or Expired' and thrown back to the log-in, and it seems to happen randomly.

Searched here and found references to this:

Code: [Select]

in main.inc.php :
// Session lifetime in minutes
// must be greater than 'keep_alive'/60
$rcmail_config['session_lifetime'] = 10;
I've tried 10000 - 144000 - 0; restarted my browser - logged in/out - and it's been days now so the PC has been on/off as well.

I want it to just stay logged in - is there some way to make this work, please ?

Thanks !

[SKaero]

1. Whats in your RoundCube error log (<RC root>/logs/errors)
2. RoundCube has no admin user you can only login with email account. My guess is the "admin" was something Softaculous did.

[smallhagrid]

Hello SKaero and thanks !
(My car is called an Aero...funny coincidence...)

It's long, I'll paste it in as I see no means to attach it:

1. Whats in your RoundCube error log (<RC root>/logs/errors)

OK, understood:

2. RoundCube has no admin user you can only login with email account. My guess is the "admin" was something Softaculous did.

OK, here is the log=>

Code: [Select]

[25-Apr-2012 07:19:39 UTC] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_3fd8d69541ec1b981bf49739749a08b57d6c5a571 FROM 'SELECT vars, ip, changed FROM session WHERE sess_id = ?']
[Native code: 2006]
[Native message: MySQL server has gone away]

[25-Apr-2012 03:19:39 -0400]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_3fd8d69541ec1b981bf49739749a08b57d6c5a571 FROM 'SELECT vars, ip, changed FROM session WHERE sess_id = ?']
[Native code: 2006]
[Native message: MySQL server has gone away]
 in /home/tinfoilh/tw/sillyname/program/include/rcube_mdb2.php on line 293 (GET /sillyname/?_task=mail&_action=check-recent&_mbox=INBOX&_list=1&_quota=1&_remote=1&_unlock=0&_=1335341904990)
[25-Apr-2012 07:19:39 UTC] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_40a76b97a29e1ddc62b2235bc9953fefeafeecba0 FROM 'INSERT INTO session (sess_id, vars, ip, created, changed) VALUES (?, ?, ?, \'2012-04-25 03:19:39\', \'2012-04-25 03:19:39\')']
[Native code: 2006]
[Native message: MySQL server has gone away]

[25-Apr-2012 03:19:39 -0400]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_40a76b97a29e1ddc62b2235bc9953fefeafeecba0 FROM 'INSERT INTO session (sess_id, vars, ip, created, changed) VALUES (?, ?, ?, \'2012-04-25 03:19:39\', \'2012-04-25 03:19:39\')']
[Native code: 2006]
[Native message: MySQL server has gone away]
 in /home/tinfoilh/tw/sillyname/program/include/rcube_mdb2.php on line 293 (GET /sillyname/?_task=mail&_action=check-recent&_mbox=INBOX&_list=1&_quota=1&_remote=1&_unlock=0&_=1335341904990)
[25-Apr-2012 07:31:20 UTC] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_39365f8f3d3c91a7a0c087dd4d0de66a9e93ec36f FROM 'SELECT vars, ip, changed FROM session WHERE sess_id = ?']
[Native code: 2006]
[Native message: MySQL server has gone away]

[25-Apr-2012 03:31:20 -0400]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_39365f8f3d3c91a7a0c087dd4d0de66a9e93ec36f FROM 'SELECT vars, ip, changed FROM session WHERE sess_id = ?']
[Native code: 2006]
[Native message: MySQL server has gone away]
 in /home/tinfoilh/tw/sillyname/program/include/rcube_mdb2.php on line 293 (GET /sillyname/?_task=mail&_action=preview&_uid=8948&_mbox=INBOX&_framed=1)
[25-Apr-2012 07:31:20 UTC] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_4ee10f0ea47ca5c018c98a885296e6798d11c54cf FROM 'INSERT INTO session (sess_id, vars, ip, created, changed) VALUES (?, ?, ?, \'2012-04-25 03:31:20\', \'2012-04-25 03:31:20\')']
[Native code: 2006]
[Native message: MySQL server has gone away]

[25-Apr-2012 03:31:20 -0400]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_4ee10f0ea47ca5c018c98a885296e6798d11c54cf FROM 'INSERT INTO session (sess_id, vars, ip, created, changed) VALUES (?, ?, ?, \'2012-04-25 03:31:20\', \'2012-04-25 03:31:20\')']
[Native code: 2006]
[Native message: MySQL server has gone away]
 in /home/tinfoilh/tw/sillyname/program/include/rcube_mdb2.php on line 293 (GET /sillyname/?_task=mail&_action=preview&_uid=8948&_mbox=INBOX&_framed=1)
[25-Apr-2012 21:17:37 UTC] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_367d3c8356c2f56acec228affc5c24dae13c8a95a FROM 'SELECT vars, ip, changed FROM session WHERE sess_id = ?']
[Native code: 2006]
[Native message: MySQL server has gone away]

[25-Apr-2012 17:17:37 -0400]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_367d3c8356c2f56acec228affc5c24dae13c8a95a FROM 'SELECT vars, ip, changed FROM session WHERE sess_id = ?']
[Native code: 2006]
[Native message: MySQL server has gone away]
 in /home/tinfoilh/tw/sillyname/program/include/rcube_mdb2.php on line 293 (GET /sillyname/?_task=mail&_action=check-recent&_mbox=INBOX&_list=1&_quota=1&_search=9517182aabf70e906f96d32bc21fc2dc&_remote=1&_unlock=0&_=1335392163392)
[25-Apr-2012 21:17:37 UTC] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_41d257a6fc9d145c4614df844d0c87caebafd4d0d FROM 'INSERT INTO session (sess_id, vars, ip, created, changed) VALUES (?, ?, ?, \'2012-04-25 17:17:36\', \'2012-04-25 17:17:36\')']
[Native code: 2006]
[Native message: MySQL server has gone away]

[25-Apr-2012 17:17:37 -0400]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_41d257a6fc9d145c4614df844d0c87caebafd4d0d FROM 'INSERT INTO session (sess_id, vars, ip, created, changed) VALUES (?, ?, ?, \'2012-04-25 17:17:36\', \'2012-04-25 17:17:36\')']
[Native code: 2006]
[Native message: MySQL server has gone away]
 in /home/tinfoilh/tw/sillyname/program/include/rcube_mdb2.php on line 293 (GET /sillyname/?_task=mail&_action=check-recent&_mbox=INBOX&_list=1&_quota=1&_search=9517182aabf70e906f96d32bc21fc2dc&_remote=1&_unlock=0&_=1335392163392)
[25-Apr-2012 21:24:09 -0400]: IMAP Error: Login failed for scorn4yoohoo@tinfoilhatclub.info from 64.223.106.128. AUTHENTICATE PLAIN: * OK Waiting for authentication process to respond.. in /home/tinfoilh/tw/sillyname/program/include/rcube_imap.php on line 205 (GET /sillyname/?_task=mail&_action=check-recent&_mbox=INBOX&_list=1&_quota=1&_remote=1&_unlock=0&_=1335406925164)
[26-Apr-2012 01:24:09 UTC] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_3958e3f61fb9316042ec11e3376add73078861902 FROM 'DELETE FROM session WHERE sess_id = ?']
[Native code: 2006]
[Native message: MySQL server has gone away]

[25-Apr-2012 21:24:09 -0400]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_3958e3f61fb9316042ec11e3376add73078861902 FROM 'DELETE FROM session WHERE sess_id = ?']
[Native code: 2006]
[Native message: MySQL server has gone away]
 in /home/tinfoilh/tw/sillyname/program/include/rcube_mdb2.php on line 293 (GET /sillyname/?_task=mail&_action=check-recent&_mbox=INBOX&_list=1&_quota=1&_remote=1&_unlock=0&_=1335406925164)
[26-Apr-2012 01:24:09 UTC] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_446bf7fdfe0d0b0340e2bbe6d96f71a723a6a1013 FROM 'INSERT INTO session (sess_id, vars, ip, created, changed) VALUES (?, ?, ?, \'2012-04-25 21:24:09\', \'2012-04-25 21:24:09\')']
[Native code: 2006]
[Native message: MySQL server has gone away]

[25-Apr-2012 21:24:09 -0400]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_446bf7fdfe0d0b0340e2bbe6d96f71a723a6a1013 FROM 'INSERT INTO session (sess_id, vars, ip, created, changed) VALUES (?, ?, ?, \'2012-04-25 21:24:09\', \'2012-04-25 21:24:09\')']
[Native code: 2006]
[Native message: MySQL server has gone away]
 in /home/tinfoilh/tw/sillyname/program/include/rcube_mdb2.php on line 293 (GET /sillyname/?_task=mail&_action=check-recent&_mbox=INBOX&_list=1&_quota=1&_remote=1&_unlock=0&_=1335406925164)
[26-Apr-2012 07:21:19 UTC] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_31febedc277a914466544f3d88deb484f1d676cb9 FROM 'SELECT vars, ip, changed FROM session WHERE sess_id = ?']
[Native code: 2006]
[Native message: MySQL server has gone away]

[26-Apr-2012 03:21:19 -0400]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_31febedc277a914466544f3d88deb484f1d676cb9 FROM 'SELECT vars, ip, changed FROM session WHERE sess_id = ?']
[Native code: 2006]
[Native message: MySQL server has gone away]
 in /home/tinfoilh/tw/sillyname/program/include/rcube_mdb2.php on line 293 (GET /sillyname/?_task=mail&_action=check-recent&_mbox=INBOX&_list=1&_quota=1&_remote=1&_unlock=0&_=1335428357789)
[26-Apr-2012 07:21:19 UTC] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_4d7fe276c8b4f9a573c78672bc4ff36e273dcb861 FROM 'INSERT INTO session (sess_id, vars, ip, created, changed) VALUES (?, ?, ?, \'2012-04-26 03:21:19\', \'2012-04-26 03:21:19\')']
[Native code: 2006]
[Native message: MySQL server has gone away]

[26-Apr-2012 03:21:19 -0400]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_4d7fe276c8b4f9a573c78672bc4ff36e273dcb861 FROM 'INSERT INTO session (sess_id, vars, ip, created, changed) VALUES (?, ?, ?, \'2012-04-26 03:21:19\', \'2012-04-26 03:21:19\')']
[Native code: 2006]
[Native message: MySQL server has gone away]
 in /home/tinfoilh/tw/sillyname/program/include/rcube_mdb2.php on line 293 (GET /sillyname/?_task=mail&_action=check-recent&_mbox=INBOX&_list=1&_quota=1&_remote=1&_unlock=0&_=1335428357789)
[26-Apr-2012 12:36:50 -0400]: IMAP Error: Login failed for scorn4yoohoo@tinfoilhatclub.info from 64.223.106.128. AUTHENTICATE PLAIN: * OK Waiting for authentication process to respond.. in /home/tinfoilh/tw/sillyname/program/include/rcube_imap.php on line 205 (GET /sillyname/?_task=mail&_action=check-recent&_mbox=INBOX&_list=1&_quota=1&_remote=1&_unlock=0&_=1335461668452)
[26-Apr-2012 16:36:52 UTC] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_3d8af48900a724f81b58de887c340ca659ff7cde4 FROM 'DELETE FROM session WHERE sess_id = ?']
[Native code: 2006]
[Native message: MySQL server has gone away]

[26-Apr-2012 12:36:52 -0400]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_3d8af48900a724f81b58de887c340ca659ff7cde4 FROM 'DELETE FROM session WHERE sess_id = ?']
[Native code: 2006]
[Native message: MySQL server has gone away]
 in /home/tinfoilh/tw/sillyname/program/include/rcube_mdb2.php on line 293 (GET /sillyname/?_task=mail&_action=check-recent&_mbox=INBOX&_list=1&_quota=1&_remote=1&_unlock=0&_=1335461668452)
[26-Apr-2012 16:36:52 UTC] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_4bfbb72664e240906a5255b3d7d9a452ac4c37548 FROM 'INSERT INTO session (sess_id, vars, ip, created, changed) VALUES (?, ?, ?, \'2012-04-26 12:36:52\', \'2012-04-26 12:36:52\')']
[Native code: 2006]
[Native message: MySQL server has gone away]

[26-Apr-2012 12:36:52 -0400]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_4bfbb72664e240906a5255b3d7d9a452ac4c37548 FROM 'INSERT INTO session (sess_id, vars, ip, created, changed) VALUES (?, ?, ?, \'2012-04-26 12:36:52\', \'2012-04-26 12:36:52\')']
[Native code: 2006]
[Native message: MySQL server has gone away]
 in /home/tinfoilh/tw/sillyname/program/include/rcube_mdb2.php on line 293 (GET /sillyname/?_task=mail&_action=check-recent&_mbox=INBOX&_list=1&_quota=1&_remote=1&_unlock=0&_=1335461668452)
[26-Apr-2012 17:04:40 -0400]: IMAP Error: Login failed for scorn4yoohoo@tinfoilhatclub.info from 64.223.106.128. AUTHENTICATE PLAIN: * OK Waiting for authentication process to respond.. in /home/tinfoilh/tw/sillyname/program/include/rcube_imap.php on line 205 (GET /sillyname/?_task=mail&_action=preview&_uid=8980&_mbox=INBOX&_framed=1)
[26-Apr-2012 21:04:40 UTC] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_34dd4849815b84b436dbd9ef957a56f3a067e99d8 FROM 'DELETE FROM session WHERE sess_id = ?']
[Native code: 2006]
[Native message: MySQL server has gone away]

[26-Apr-2012 17:04:40 -0400]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_34dd4849815b84b436dbd9ef957a56f3a067e99d8 FROM 'DELETE FROM session WHERE sess_id = ?']
[Native code: 2006]
[Native message: MySQL server has gone away]
 in /home/tinfoilh/tw/sillyname/program/include/rcube_mdb2.php on line 293 (GET /sillyname/?_task=mail&_action=preview&_uid=8980&_mbox=INBOX&_framed=1)
[26-Apr-2012 21:04:41 UTC] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_4cf56c28932fa475e0ceaa7c2edcf87d7e5cbfde5 FROM 'INSERT INTO session (sess_id, vars, ip, created, changed) VALUES (?, ?, ?, \'2012-04-26 17:04:41\', \'2012-04-26 17:04:41\')']
[Native code: 2006]
[Native message: MySQL server has gone away]

[26-Apr-2012 17:04:41 -0400]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_4cf56c28932fa475e0ceaa7c2edcf87d7e5cbfde5 FROM 'INSERT INTO session (sess_id, vars, ip, created, changed) VALUES (?, ?, ?, \'2012-04-26 17:04:41\', \'2012-04-26 17:04:41\')']
[Native code: 2006]
[Native message: MySQL server has gone away]
 in /home/tinfoilh/tw/sillyname/program/include/rcube_mdb2.php on line 293 (GET /sillyname/?_task=mail&_action=preview&_uid=8980&_mbox=INBOX&_framed=1)
I had to snip a few days off it as the site told me this:

The following error or errors occurred while posting this message:
The message exceeds the maximum allowed length (20000 characters).

[SKaero]

The mysql error "MySQL server has gone away" tends to mean that the mysql connection is timing out. The fact that this is occurring on simple queries could mean that the mysql server is overloaded or miss configured. It would also account for the "Session Invalid or Expired" error your getting since RoundCube can't update the existing session. If you don't have root access to the sever there isn't to much you can do, if your on a shared host check and see if they provide PostgreSQL or SQLite as they will offen be less overloaded.

[smallhagrid]

Thanks !
I am on shared hosting and I'll ask them about these things - but otherwise it looks like I'll just have to put up and shut up...

[smallhagrid]

I've asked, and they do offer PostgreSQL.

Now I must ask if changing from MySQL to PostgreSQL can be done easily enough so a simple soul such as myself may succeed in the attempt ?!

Thanks.

[SKaero]

Its simple(ish) it depends on how many user are on your system. I'd recommend doing a fresh install with PostgreSQL but you will need to backup your contacts and identities.