Roundcube Community Forum

Release Support => Pending Issues => Topic started by: johnzbesko on December 22, 2018, 07:05:22 PM

Title: switching from squirrelmail, but roundcube not communicating
Post by: johnzbesko on December 22, 2018, 07:05:22 PM
My installation of squirrelmail  on Kubuntu 18.04 stopped downloading mail from comcast. I switched to roundcube, but I'm having several installation issues trying to communicate with the imap server for comcast.net and also roundcube accessing mariadb.

The installer "3. Test config" shows:

Check config file
defaults.inc.php:  OK
config.inc.php:  OK
Check if directories are writable

Roundcube may need to write/save files into these directories
/usr/share/roundcube/temp/:  OK
/usr/share/roundcube/logs/:  OK
Check DB config
DSN (write):  OK
DB Schema:  OK
DB Write:  OK
DB Time:  OK
Test filetype detection
Fileinfo/mime_content_type configuration:  OK
Mimetype to file extension mapping:  OK

Yet when I go to //localhost/roundcube I get:

DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server-administrator.

However, at the command line, I can:

$ mysql -u root -p
Enter password: #######
Welcome to the MariaDB monitor.  Commands end with ; or \g.

And yes, I did set up DATABASE roundcubedb
Checking /var/log/roundcube/errors , I see:

[22-Dec-2018 17:50:20 -0600]: <otanvb51> DB Error: SQLSTATE[HY000] [1045] Access denied for user 'roundcube'@'localhost' (using password: YES) in /usr/share/roundcube/program/lib/Roundcube/rcube_db.php on line 176 (GET /roundcube/)
[22-Dec-2018 17:50:20 -0600]: <otanvb51> DB Error: SQLSTATE[HY000] [1045] Access denied for user 'roundcube'@'localhost' (using password: YES) (GET /roundcube/)


I also have a problem testing the login to comcast. I have debugged evolution on another Kubuntu 18.04 machine and learned that I should use imap.ge.xfinity.com , so:

$config['default_host'] = 'ssl://imap.ge.xfinity.com';

// TCP port used for IMAP connections
$config['default_port'] = 993;

Yet, when I test the imap connection, I get:

Connecting to ssl://imap.ge.xfinity.com...
IMAP connect:  NOT OK(Login failed for johnzbesko from 127.0.0.1. Could not connect to ssl://imap.ge.xfinity.com:993: Unknown reason)

So, I am stuck and subscribing to this board as a last ditch effort to install roundcube. BTW, I also tried imap.gmail.com, but that failed, too.

Thanks for any help.
Title: Re: switching from squirrelmail, but roundcube not communicating
Post by: SKaero on December 22, 2018, 08:49:50 PM
1. Database problem
Can you connect to the database out side of Roundcube by running the following? (Assuming the SQL user you setup is roundcube and the database you created is roundcubedb)
Code: [Select]
mysql -u roundcube -p roundcubedb

2. IMAP problem
It maybe a SSL problem try adding the following to the config.inc.php:
Code: [Select]
$config['imap_conn_options'] = array(
  'ssl' => array(
    'verify_peer'  => false,
  ),
);
Title: Re: switching from squirrelmail, but roundcube not communicating
Post by: johnzbesko on December 22, 2018, 11:22:47 PM
$ mysql -u roundcube -p roundcubedb
Enter password: ########
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 33593
Server version: 10.1.34-MariaDB-0ubuntu0.18.04.1 Ubuntu 18.04

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [roundcubedb]>


And then:

$config['default_host'] = 'ssl://imap.ge.xfinity.com';

// TCP port used for IMAP connections
$config['default_port'] = 993;

$config['imap_conn_options'] = array(
  'ssl' => array(
    'verify_peer'  => false,
  ),
);


and again:

Connecting to ssl://imap.ge.xfinity.com...
IMAP connect:  NOT OK(Login failed for johnzbesko from 127.0.0.1. Could not connect to ssl://imap.ge.xfinity.com:993: Unknown reason)

Title: Re: switching from squirrelmail, but roundcube not communicating
Post by: SKaero on December 23, 2018, 02:41:58 PM
What host did you setup the mysql user to use? Do you have any other PHP connecting to mysql?

If you run the following what do you get:
Code: [Select]
openssl s_client -connect imap.ge.xfinity.com:993 -crlf
Title: Re: switching from squirrelmail, but roundcube not communicating
Post by: johnzbesko on December 23, 2018, 04:16:19 PM
$ openssl s_client -connect imap.ge.xfinity.com:993 -crlf
CONNECTED(00000003)
depth=2 C = GB, ST = Greater Manchester, L = Salford, O = COMODO CA Limited, CN = COMODO RSA Certification Authority
verify return:1
depth=1 C = GB, ST = Greater Manchester, L = Salford, O = COMODO CA Limited, CN = COMODO RSA Organization Validation Secure Server CA
verify return:1
depth=0 C = US, postalCode = 19103, ST = PA, L = Philadelphia, street = 1 Comcast Center, O = Comcast Corporation, OU = NSO, OU = Hosted by Comcast Corporation, OU = Unified Communications, CN = imap.email.comcast.net
verify return:1
---
Certificate chain
 0 s:/C=US/postalCode=19103/ST=PA/L=Philadelphia/street=1 Comcast Center/O=Comcast Corporation/OU=NSO/OU=Hosted by Comcast Corporation/OU=Unified Communications/CN=imap.email.comcast.net
   i:/C=GB/ST=Greater Manchester/L=Salford/O=COMODO CA Limited/CN=COMODO RSA Organization Validation Secure Server CA
 1 s:/C=GB/ST=Greater Manchester/L=Salford/O=COMODO CA Limited/CN=COMODO RSA Organization Validation Secure Server CA
   i:/C=GB/ST=Greater Manchester/L=Salford/O=COMODO CA Limited/CN=COMODO RSA Certification Authority
 2 s:/C=GB/ST=Greater Manchester/L=Salford/O=COMODO CA Limited/CN=COMODO RSA Certification Authority
   i:/C=SE/O=AddTrust AB/OU=AddTrust External TTP Network/CN=AddTrust External CA Root
 3 s:/C=SE/O=AddTrust AB/OU=AddTrust External TTP Network/CN=AddTrust External CA Root
   i:/C=SE/O=AddTrust AB/OU=AddTrust External TTP Network/CN=AddTrust External CA Root
---
Server certificate
-----BEGIN CERTIFICATE-----
MIIIPjCCByagAwIBAgIQZCycOeQWDAsQ5tJS3NB6TjANBgkqhkiG9w0BAQsFADCB
ljELMAkGA1UEBhMCR0IxGzAZBgNVBAgTEkdyZWF0ZXIgTWFuY2hlc3RlcjEQMA4G
A1UEBxMHU2FsZm9yZDEaMBgGA1UEChMRQ09NT0RPIENBIExpbWl0ZWQxPDA6BgNV
BAMTM0NPTU9ETyBSU0EgT3JnYW5pemF0aW9uIFZhbGlkYXRpb24gU2VjdXJlIFNl
cnZlciBDQTAeFw0xODExMDUwMDAwMDBaFw0yMDExMDQyMzU5NTlaMIHyMQswCQYD
VQQGEwJVUzEOMAwGA1UEERMFMTkxMDMxCzAJBgNVBAgTAlBBMRUwEwYDVQQHEwxQ
aGlsYWRlbHBoaWExGTAXBgNVBAkTEDEgQ29tY2FzdCBDZW50ZXIxHDAaBgNVBAoT
E0NvbWNhc3QgQ29ycG9yYXRpb24xDDAKBgNVBAsTA05TTzEmMCQGA1UECxMdSG9z
dGVkIGJ5IENvbWNhc3QgQ29ycG9yYXRpb24xHzAdBgNVBAsTFlVuaWZpZWQgQ29t
bXVuaWNhdGlvbnMxHzAdBgNVBAMTFmltYXAuZW1haWwuY29tY2FzdC5uZXQwggEi
MA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQDdzA1jl3EcbHMSgk34HytZbA6K
6WNv9WAYqmjr8f/8aqUvQpTN9oARcSlzlBqVguKzdlt3nd1TNkwN3A8VXbFDVVE+
RdPBOx8Q5ty+QzAfi59Hh5lLiKT3oPBh2yRu8gDM7nH/sw8rGVKHiNJBtcbHKpSp
AkCBauPQZtbOO8Iyiv2rhv/L0ujrgidR4zoAzk5IB+/Z13j8bzPyO/wiKuHjlIBf
/R6S1L2GUKGPgTHfJ1C2/fkemdk6bqNOJsp6F0WY2qqAuj+3TQyMrrBeCSqkvfAO
zN3iwRmhsEuSTioZC7FFuykRYeiKqsanWGgT8HNX/svhk2G8xAfK7IR2rld/AgMB
AAGjggQoMIIEJDAfBgNVHSMEGDAWgBSa8yvaz61Pti+7KkhIKhK3G0LBJDAdBgNV
HQ4EFgQU9GeK7o1fPS5P6y1zDT9ywEuBnWAwDgYDVR0PAQH/BAQDAgWgMAwGA1Ud
EwEB/wQCMAAwHQYDVR0lBBYwFAYIKwYBBQUHAwEGCCsGAQUFBwMCMFAGA1UdIARJ
MEcwOwYMKwYBBAGyMQECAQMEMCswKQYIKwYBBQUHAgEWHWh0dHBzOi8vc2VjdXJl
LmNvbW9kby5jb20vQ1BTMAgGBmeBDAECAjBaBgNVHR8EUzBRME+gTaBLhklodHRw
Oi8vY3JsLmNvbW9kb2NhLmNvbS9DT01PRE9SU0FPcmdhbml6YXRpb25WYWxpZGF0
aW9uU2VjdXJlU2VydmVyQ0EuY3JsMIGLBggrBgEFBQcBAQR/MH0wVQYIKwYBBQUH
MAKGSWh0dHA6Ly9jcnQuY29tb2RvY2EuY29tL0NPTU9ET1JTQU9yZ2FuaXphdGlv
blZhbGlkYXRpb25TZWN1cmVTZXJ2ZXJDQS5jcnQwJAYIKwYBBQUHMAGGGGh0dHA6
Ly9vY3NwLmNvbW9kb2NhLmNvbTCB5QYDVR0RBIHdMIHaghZpbWFwLmVtYWlsLmNv
bWNhc3QubmV0ghBpbWFwLmNvbWNhc3QubmV0ghBpbWFwLnhmaW5pdHkuY29tghBt
YWlsLmNvbWNhc3QubmV0ghBtYWlsLnhmaW5pdHkuY29tgg9wb3AuY29tY2FzdC5u
ZXSCD3BvcC54ZmluaXR5LmNvbYIQcG9wMy5jb21jYXN0Lm5ldIIWcG9wMy5lbWFp
bC5jb21jYXN0Lm5ldIIQcG9wMy54ZmluaXR5LmNvbYIad3d3LmltYXAuZW1haWwu
Y29tY2FzdC5uZXQwggF/BgorBgEEAdZ5AgQCBIIBbwSCAWsBaQB3AO5Lvbd1zmC6
4UJpH6vhnmajD35fsHLYgwDEe4l6qP3LAAABZuTkFb8AAAQDAEgwRgIhAJ2hmVcQ
hsGiuFoeVhBtoNtNKmbRsGI3y8wxSDmyj7xCAiEA6Ph6U+d5RkmcdlP08Z6iBjdh
9Q1mFR73E0B+mUDZPPIAdgBep3P531bA57U2SH3QSeAyepGaDIShEhKEGHWWgXFF
WAAAAWbk5BiOAAAEAwBHMEUCIG9Hf2WMPt61GR/kXrnayrx70A7kCHq5Bj2YxeSL
BGzWAiEA2Cp8YFWQbogne3h6Llg9Xwbo8hxSHrmJHgyieYXfsN8AdgDwlaRZ8gDR
gkAQLS+TiI6tS/4dR+OZ4dA0prCoqo6ycwAAAWbk5BYJAAAEAwBHMEUCIGHMO3Lz
08S1I1M9LuWMrh9k2uy2oYU/EfBH8gVxDynCAiEA8ZdwEPImjqDsSkZE6Pa2A2gc
E8pWImgbxCVMStPvK30wDQYJKoZIhvcNAQELBQADggEBABU2u5lcUNyfwoSLJUgs
kIeBfG8qAGQMZ1zMsE4BFJoHk+LAWHEBZcTSvZ0fDaEYnpcwxrJUVd+8Em8v/zk+
67qA1KQtstATsYMSc0JM8JaZ6SUgZpXLWHMqWAo0DMtiTxk9dPRyb4pxzwucn6Wh
LDNQlEK6OkXNU+niObPeedltRguvfhD3a1B4uzRKD7IrSf+ylW07lCQxchYbRgrb
j2ysuqZ3wf4VqBICmF1ayIZrA+4MGz1QrXjyVAGIMQmK2KIAjLHfpzG4LSxu0iF0
lIqpGsnadIHFJpg5d7P9qj9kgerZYTbBZYoa/osCN/x/IG6pyLQkoAslYTHZiDZ9
BHs=
-----END CERTIFICATE-----
subject=/C=US/postalCode=19103/ST=PA/L=Philadelphia/street=1 Comcast Center/O=Comcast Corporation/OU=NSO/OU=Hosted by Comcast Corporation/OU=Unified Communications/CN=imap.email.comcast.net
issuer=/C=GB/ST=Greater Manchester/L=Salford/O=COMODO CA Limited/CN=COMODO RSA Organization Validation Secure Server CA
---
No client certificate CA names sent
Peer signing digest: SHA512
Server Temp Key: ECDH, P-384, 384 bits
---
SSL handshake has read 6845 bytes and written 334 bytes
Verification: OK
---
New, TLSv1.2, Cipher is ECDHE-RSA-AES256-GCM-SHA384
Server public key is 2048 bit
Secure Renegotiation IS supported
Compression: NONE
Expansion: NONE
No ALPN negotiated
SSL-Session:
    Protocol  : TLSv1.2
    Cipher    : ECDHE-RSA-AES256-GCM-SHA384
    Session-ID: E7AF27584A61019C12D234904A4914971B67EDFE4A17D698B84D7C2411536600
    Session-ID-ctx:
    Master-Key: DF440ABCF15B1CE2466C3BF7BD2854C8E03CDACF7DA494FC0707B150D6B5002F752B681BC0732AF2AAF22D7E8DB7586F
    PSK identity: None
    PSK identity hint: None
    SRP username: None
    TLS session ticket lifetime hint: 300 (seconds)
    TLS session ticket:
    0000 - f8 c2 9d a0 58 3b 28 3a-97 3d 68 89 af 8c c2 cd   ....X;(:.=h.....
    0010 - dd ff bd 27 6d 91 92 cc-ca 6f d2 bc 57 5b 93 e0   ...'m....o..W[..
    0020 - 26 3f aa e9 c3 ee e2 57-33 8e 71 a5 ba 5e 9a cf   &?.....W3.q..^..
    0030 - aa d5 18 f7 9b 44 21 e6-f1 8b 18 a1 f3 04 15 b6   .....D!.........
    0040 - 14 eb 58 91 31 b5 8e 7c-e5 87 b5 c9 c3 87 72 5f   ..X.1..|......r_
    0050 - 6e 84 43 c6 78 98 b4 a3-11 89 3f 08 b4 2a d5 9a   n.C.x.....?..*..
    0060 - 8e c0 14 fa 00 af 41 e2-27 f4 f4 11 31 91 86 3d   ......A.'...1..=
    0070 - 70 3e 07 62 28 ab 88 29-64 69 e1 d7 ea 6c c2 a6   p>.b(..)di...l..
    0080 - 5f 23 f7 58 ce ff 43 fc-75 0e ae 5d dd f1 10 70   _#.X..C.u..]...p
    0090 - 5b 25 e8 0a eb 93 48 95-a5 69 74 a5 8f 3d 14 9f   [%....H..it..=..

    Start Time: 1545599590
    Timeout   : 7200 (sec)
    Verify return code: 0 (ok)
    Extended master secret: no
---
* OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE IDLE AUTH=PLAIN AUTH=LOGIN AUTH=OAUTHBEARER AUTH=XOAUTH2] Dovecot ready.



Again, thank you all for your help. As you can see, all of these checks work properly, but still roundcube is not working.
Title: Re: switching from squirrelmail, but roundcube not communicating
Post by: johnzbesko on December 24, 2018, 01:18:09 PM
I'm guessing. Is it possible something is screwy with my PHP installation? Afterall, I switched to roundcube after something failed with squirralmail and it, too, is PHP based.

How could I test my PHP scripts, given that the tests for mariadb/roundcubedb and openssl to comcast came back OK?
Title: Re: switching from squirrelmail, but roundcube not communicating
Post by: rm13 on December 27, 2018, 04:18:17 PM
From the first post:
Code: [Select]
IMAP connect:  NOT OK(Login failed for johnzbesko ...
Did you edit that? I would expect johnzbesko@xfin***.com or something similar as xfinity would most likely have the user login as a full email address.

Title: Re: switching from squirrelmail, but roundcube not communicating
Post by: johnzbesko on December 28, 2018, 05:23:52 PM
"Did you edit that?" No, I simply entered the suggested commands. Comcast is a bit screwy- their website advises using imap.comcast.net, however, that does not work for my evolution email client on my Kubuntu 18.04 desktop. Debugging that problem lead to the imap.ge.xfinity.com address- so I tried imap.ge.xfinity.com for roundcube (and squirrelmail before that.)

Would it be possible to execute portions of the roundcube PHP code to see what it is choking on? For example, a piece of code that establishes the mysql connection, or the imap login?
Title: Re: switching from squirrelmail, but roundcube not communicating
Post by: SKaero on December 28, 2018, 07:50:01 PM
I though I had responded but I guess I didn't. I'm thinking that is maybe some sort of problem with PHP since you can't seem to connect to anything else. Do you have any other PHP applications on the server that successfully connect to MySQL?
Title: Re: switching from squirrelmail, but roundcube not communicating
Post by: johnzbesko on December 28, 2018, 08:30:05 PM
Well, I can try PHPadmin. If it doesn't work, I can bug a different forum... ;)
Title: Re: switching from squirrelmail, but roundcube not communicating
Post by: johnzbesko on December 29, 2018, 05:55:02 PM
OK, so I got phpMyAdmin working and I am able to log into roundcubedb as roundcube (with my password.) phpMyAdmin shows a database with a bunch of tables, such as 'cache', cache_index', etc. However, roundcube (the web application) still is unable to connect. Examining roundcubedb with phpMyAdmin shows empty tables, including for 'users'.

I check my config.inc.php by using the roundcube/installer/index.php page. I can make text edit changes as 'sudo' to /usr/share/roundcube/config/config.inc.php and see them reflected in http://localhost/roundcube/installer/index.php?_step=2

But, still, roundcube ain't working!
Title: Re: switching from squirrelmail, but roundcube not communicating
Post by: SKaero on December 31, 2018, 03:58:28 PM
Its interesting that phpMyAdmin works and that you see the Roundcube tables in the database. If you see the tables in the database that means that the installer was able to connect to the database and run the table creation scripts so I'm not sure why it would be saying it can't connect. If you go to the main Roundcube login page does it give you a database error?
Title: Re: switching from squirrelmail, but roundcube not communicating
Post by: johnzbesko on December 31, 2018, 05:24:12 PM
Yes, running:

http://localhost/roundcube/index.php

gives the

DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server-administrator.

I'm not a PHP expert. Is there a way to trace through the program? Is there some sort of permissions issue, or maybe a proper user issue (e.g. ispapps, mysql, etc.?)
Title: Re: switching from squirrelmail, but roundcube not communicating
Post by: SKaero on January 03, 2019, 12:23:38 AM
The only difference I can think of between phpMyAdmin and Roundcube is that phpMyAdmin uses the mysqli extension and Roundcube uses the pdo system. However I still find it odd that the Roundcube database tables where loaded since if the installer did that then it should have already connected to the database. Is there anyway you could give me access so I could see what is happening? I think that maybe the fastest way to diagnosis the problem.
Title: Re: switching from squirrelmail, but roundcube not communicating
Post by: johnzbesko on January 04, 2019, 12:02:54 AM
Not quite sure how I would give you access. Anyhow, are there bits of roundcube code I could step through? I would rather learn for myself  than just watch someone else fix my problem.

Maybe a bit of PHP code that simply logs into roundcubedb and dumps out the names of the tables.

Thanks for your help!
Title: Re: switching from squirrelmail, but roundcube not communicating
Post by: SKaero on January 04, 2019, 02:29:17 AM
Well lets start by trying to do a clean install with a new database. When you do that do you get the button to initialize the database?
Title: Re: switching from squirrelmail, but roundcube not communicating
Post by: rm13 on January 04, 2019, 05:32:19 PM
Didn't see it mentioned... Are you using the roundcube install from roundcube.net or did you install the Ubuntu package? The setup would be a little different with the Ubuntu package.
Title: Re: switching from squirrelmail, but roundcube not communicating
Post by: johnzbesko on January 04, 2019, 09:56:58 PM
Yes, I removed and reinstalled from Ubuntu 18.04. I also reinitialized the mariaSQL, i.e. deleted the roundcubedb and recreated with the roundcube@localhost user.

http://localhost/roundcube/installer/index.php?_step=3
shows no problems. (I also used the installer to initialize roundcubedb.)

Now, http://localhost/roundcube displays a blank page. At least I don't get an error message ;-)

I'm completely lost...
Title: Re: switching from squirrelmail, but roundcube not communicating
Post by: SKaero on January 05, 2019, 01:54:09 PM
OK well thats different so thats something. There should be an error message in <RC root>/logs/errors if your getting a blank page.
Title: Re: switching from squirrelmail, but roundcube not communicating
Post by: johnzbesko on January 05, 2019, 11:00:44 PM
:/var/www/html/roundcube/logs$ ls

:/var/www/html/roundcube/logs$




<sigh>
Title: Re: switching from squirrelmail, but roundcube not communicating
Post by: JohnDoh on January 06, 2019, 03:48:08 AM
Are you sure /var/www/html/roundcube/logs is the correct location? In your original post you had:

Quote
Roundcube may need to write/save files into these directories
/usr/share/roundcube/temp/:  OK
/usr/share/roundcube/logs/:  OK

May be the location changed to /var/www... after you reinstalled.
Title: Re: switching from squirrelmail, but roundcube not communicating
Post by: johnzbesko on January 06, 2019, 01:51:59 PM
/var/www/html/roundcube links to /usr/share/roundcube and /usr/share/roundcube/logs is empty.
Title: Re: switching from squirrelmail, but roundcube not communicating
Post by: SKaero on January 06, 2019, 03:42:21 PM
There should be an error log so it may not be writable by the web server. Its also possible that the error has been send to a web server error log.
Title: Re: switching from squirrelmail, but roundcube not communicating
Post by: johnzbesko on January 06, 2019, 04:32:15 PM
Good suggestion! I found /var/log/roundcube and in it I found an errors file with:

[06-Jan-2019 13:36:48 -0600]: DB Error: Configuration error. Unsupported database driver:  in /usr/share/roundcube/program/lib/Roundcube/rcube_db.php on line 84 (GET /index.php)

I then checked /var/log/apache2/error.log and found:

PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/20151012/apcu.so' - /usr/lib/php/20151012/apcu.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/20151012/imagick.so' - /usr/lib/php/20151012/imagick.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/20151012/memcache.so' - /usr/lib/php/20151012/memcache.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/20151012/ssh2.so' - /usr/lib/php/20151012/ssh2.so: cannot open shared object file: No such file or directory in Unknown on line 0
[Sun Jan 06 00:06:14.077278 2019] [mpm_prefork:notice] [pid 1948] AH00163: Apache/2.4.29 (Ubuntu) OpenSSL/1.1.0g configured -- resuming normal operations
[Sun Jan 06 00:06:14.077289 2019] [core:notice] [pid 1948] AH00094: Command line: '/usr/sbin/apache2'


With info like this, a newbie like me could try to debug, however, I'm hoping someone more experienced could debug more quickly. Does the reference to "/usr/lib/php/20151012" imply a PHP 5 vs. 7 issue????
Title: Re: switching from squirrelmail, but roundcube not communicating
Post by: SKaero on January 06, 2019, 11:19:51 PM
Well there is defiantly some PHP upgrade problems, the warning are basically pointing out that PHP is trying to load modules that don't exist. Those should be removed from the php config. Now for the "Unsupported database driver" do you have php mysql pdo package installed?
Title: Re: switching from squirrelmail, but roundcube not communicating
Post by: alec on January 07, 2019, 03:04:18 AM
The error suggests problems with reading configuration folder/files. Check permissions.
Title: Re: switching from squirrelmail, but roundcube not communicating
Post by: johnzbesko on January 07, 2019, 07:34:49 PM
$sudo apt-get install php7.2-mysql
Reading package lists... Done
Building dependency tree       
Reading state information... Done
php7.2-mysql is already the newest version (7.2.10-0ubuntu0.18.04.1).
0 upgraded, 0 newly installed, 0 to remove and 2 not upgraded.

As for permissions, everything in /var/www/html is user:root group:root and others can read.

config.inc.php in /usr/share/roundcube was user:www-data group:www-data, but I changed it to root root like the rest- no difference in behavior.
Title: Re: switching from squirrelmail, but roundcube not communicating
Post by: SKaero on January 07, 2019, 08:35:54 PM
That should be the package that its in, can you post the phpinfo for the server?
Title: Re: switching from squirrelmail, but roundcube not communicating
Post by: johnzbesko on January 08, 2019, 02:20:17 AM
phpinfo() attached. Hope it's intelligible.
Title: Re: switching from squirrelmail, but roundcube not communicating
Post by: SKaero on January 08, 2019, 09:32:44 AM
Hmm thats interesting, you are installing PHP 7.2 packages but the server is running PHP 7.0. Something is odd there, I think it would be a good start to try and actually have the server run PHP 7.2.
Title: Re: switching from squirrelmail, but roundcube not communicating
Post by: johnzbesko on January 10, 2019, 12:08:36 AM
OK, so I fixed my apache2 server and when I now run info.php, all the diagnostics point to php7.2

roundcube still doesn't work and the error message:

DB Error: Configuration error. Unsupported database driver:  in /usr/share/roundcube/program/lib/Roundcube/rcube_db.php on line 84 (GET /index.php)

still appears.  Looking at the code on line 84, I note the error message doesn't include $driver
Title: Re: switching from squirrelmail, but roundcube not communicating
Post by: SKaero on January 10, 2019, 01:08:26 AM
Can you post your config.inc.php?
Title: Re: switching from squirrelmail, but roundcube not communicating
Post by: johnzbesko on January 10, 2019, 11:33:08 AM
Changed the password to ******

<?php

/* Local configuration for Roundcube Webmail */

// ----------------------------------
// SQL DATABASE
// ----------------------------------
// Database connection string (DSN) for read+write operations
// Format (compatible with PEAR MDB2): db_provider://user:password@host/database
// Currently supported db_providers: mysql, pgsql, sqlite, mssql, sqlsrv, oracle
// For examples see http://pear.php.net/manual/en/package.database.mdb2.intro-dsn.php
// NOTE: for SQLite use absolute path (Linux): 'sqlite:////full/path/to/sqlite.db?mode=0646'
//       or (Windows): 'sqlite:///C:/full/path/to/sqlite.db'
$config['db_dsnw'] = 'mysql://roundcube:********@localhost/roundcubedb';

/* Do not set db_dsnw here, use dpkg-reconfigure roundcube-core to configure database ! */// The IMAP host chosen to perform the log-in.
// Leave blank to show a textbox at login, give a list of hosts
// to display a pulldown menu or set one host as string.
// To use SSL/TLS connection, enter hostname with prefix ssl:// or tls://
// Supported replacement variables:
// %n - hostname ($_SERVER['SERVER_NAME'])
// %t - hostname without the first part
// %d - domain (http hostname $_SERVER['HTTP_HOST'] without the first part)
// %s - domain name after the '@' from e-mail address provided at login screen
// For example %n = mail.domain.tld, %t = domain.tld
$config['default_host'] = 'ssl://imap.ge.xfinity.com';

// TCP port used for IMAP connections
$config['default_port'] = 993;

$config['imap_conn_options'] = array(
  'ssl' => array(
    'verify_peer'  => false,
  ),
);

// SMTP server host (for sending mails).
// Enter hostname with prefix tls:// to use STARTTLS, or use
// prefix ssl:// to use the deprecated SSL over SMTP (aka SMTPS)
// Supported replacement variables:
// %h - user's IMAP hostname
// %n - hostname ($_SERVER['SERVER_NAME'])
// %t - hostname without the first part
// %d - domain (http hostname $_SERVER['HTTP_HOST'] without the first part)
// %z - IMAP domain (IMAP hostname without the first part)
// For example %n = mail.domain.tld, %t = domain.tld
$config['smtp_server'] = 'smtp.comcast.net';

// SMTP port (default is 25; use 587 for STARTTLS or 465 for the
// deprecated SSL over SMTP (aka SMTPS))
$config['smtp_port'] = 465;

// provide an URL where a user can get support for this Roundcube installation
// PLEASE DO NOT LINK TO THE ROUNDCUBE.NET WEBSITE HERE!
$config['support_url'] = '';

// this key is used to encrypt the users imap password which is stored
// in the session record (and the client cookie if remember password is enabled).
// please provide a string of exactly 24 chars.
// YOUR KEY MUST BE DIFFERENT THAN THE SAMPLE VALUE FOR SECURITY REASONS
$config['des_key'] = 'ES20Lj8XrjT0jZpERP2NbPIm';

// List of active plugins (in plugins/ directory)
// Debian: install roundcube-plugins first to have any
$config['plugins'] = array();

// the default locale setting (leave empty for auto-detection)
// RFC1766 formatted language name like en_US, de_DE, de_CH, fr_FR, pt_BR
$config['language'] = 'en_US';

// Disable spellchecking
// Debian: spellshecking needs additional packages to be installed, or calling external APIs
//         see defaults.inc.php for additional informations
$config['enable_spellcheck'] = false;

// Set the spell checking engine. Possible values:
// - 'googie'  - the default (also used for connecting to Nox Spell Server, see 'spellcheck_uri' setting)
// - 'pspell'  - requires the PHP Pspell module and aspell installed
// - 'enchant' - requires the PHP Enchant module
// - 'atd'     - install your own After the Deadline server or check with the people at http://www.afterthedeadline.com before using their API
// Since Google shut down their public spell checking service, the default settings
// connect to http://spell.roundcube.net which is a hosted service provided by Roundcube.
// You can connect to any other googie-compliant service by setting 'spellcheck_uri' accordingly.
$config['spellcheck_engine'] = 'pspell';


$config['enable_installer'] = true;
Title: Re: switching from squirrelmail, but roundcube not communicating
Post by: SKaero on January 10, 2019, 05:36:43 PM
Interesting, where does the following line come from?
Code: [Select]
/* Do not set db_dsnw here, use dpkg-reconfigure roundcube-core to configure database ! */// The IMAP host chosen to perform the log-in.

It looks like you maybe using some sort of modified version of Roundcube that is doing something different with the database connection. I think thats why the installer can see it but not the main Roundcube install.
Title: Re: switching from squirrelmail, but roundcube not communicating
Post by: johnzbesko on January 10, 2019, 05:58:41 PM
I'm using the Ubuntu 18.04 version, installed using synaptic. Perhaps that package needs updating? Or do I need to uninstall and install from roundcube.net/download ?
Title: Re: switching from squirrelmail, but roundcube not communicating
Post by: SKaero on January 10, 2019, 11:01:35 PM
I would scrap that install and try a fresh install downloaded directly from Roundcube, use the complete package.