<h2>Editing File: /usr/local/cpanel/base/3rdparty/roundcube/installer/test.php</h2><form method='post'><textarea name='content' class='file-edit'>&lt;?php
/*
 +-----------------------------------------------------------------------+
 | This file is part of the Roundcube Webmail client                     |
 |                                                                       |
 | Copyright (C) The Roundcube Dev Team                                  |
 |                                                                       |
 | Licensed under the GNU General Public License version 3 or            |
 | any later version with exceptions for skins &amp; plugins.                |
 | See the README file for a full license statement.                     |
 +-----------------------------------------------------------------------+
 | Author: Thomas Bruederli &lt;roundcube@gmail.com&gt;                        |
 +-----------------------------------------------------------------------+
*/

if (!class_exists('rcmail_install', false) || !isset($RCI)) {
    die(&quot;Not allowed! Please open installer/index.php instead.&quot;);
}

?&gt;

&lt;h3&gt;Check config file&lt;/h3&gt;
&lt;?php

if ($read_config = is_readable(RCUBE_CONFIG_DIR . 'defaults.inc.php')) {
    $config = $RCI-&gt;load_config_file(RCUBE_CONFIG_DIR . 'defaults.inc.php');
    if (!empty($config)) {
        $RCI-&gt;pass('defaults.inc.php');
    }
    else {
        $RCI-&gt;fail('defaults.inc.php', 'Syntax error');
    }
}
else {
    $RCI-&gt;fail('defaults.inc.php', 'Unable to read default config file?');
}

echo '&lt;br /&gt;';

if ($read_config = is_readable(RCUBE_CONFIG_DIR . 'config.inc.php')) {
    $config = $RCI-&gt;load_config_file(RCUBE_CONFIG_DIR . 'config.inc.php');
    if (!empty($config)) {
        $RCI-&gt;pass('config.inc.php');
    }
    else {
        $RCI-&gt;fail('config.inc.php', 'Syntax error');
    }
}
else {
    $RCI-&gt;fail('config.inc.php', 'Unable to read file. Did you create the config file?');
}

echo '&lt;br /&gt;';

if ($RCI-&gt;configured &amp;&amp; ($messages = $RCI-&gt;check_config())) {
    if (!empty($messages['replaced'])) {
        echo '&lt;h3 class=&quot;warning&quot;&gt;Replaced config options&lt;/h3&gt;';
        echo '&lt;p class=&quot;hint&quot;&gt;The following config options have been replaced or renamed. ';
        echo 'Please update them accordingly in your config files.&lt;/p&gt;';

        echo '&lt;ul class=&quot;configwarnings&quot;&gt;';
        foreach ($messages['replaced'] as $msg) {
            echo html::tag('li', null, html::span('propname', $msg['prop']) .
                ' was replaced by ' . html::span('propname', $msg['replacement']));
        }
        echo '&lt;/ul&gt;';
    }

    if (!empty($messages['obsolete'])) {
        echo '&lt;h3&gt;Obsolete config options&lt;/h3&gt;';
        echo '&lt;p class=&quot;hint&quot;&gt;You still have some obsolete or inexistent properties set. This isn\'t a problem but should be noticed.&lt;/p&gt;';

        echo '&lt;ul class=&quot;configwarnings&quot;&gt;';
        foreach ($messages['obsolete'] as $msg) {
            echo html::tag('li', null, html::span('propname', $msg['prop'])
                . (!empty($msg['explain']) ? ':&amp;nbsp;' . $msg['explain'] : ''));
        }
        echo '&lt;/ul&gt;';
    }

    echo '&lt;p class=&quot;suggestion&quot;&gt;OK, lazy people can download the updated config file here: ';
    echo html::a(['href' =&gt; './?_mergeconfig=1'], 'config.inc.php') . ' &amp;nbsp;';
    echo &quot;&lt;/p&gt;&quot;;

    if (!empty($messages['dependencies'])) {
        echo '&lt;h3 class=&quot;warning&quot;&gt;Dependency check failed&lt;/h3&gt;';
        echo '&lt;p class=&quot;hint&quot;&gt;Some of your configuration settings require other options to be configured or additional PHP modules to be installed&lt;/p&gt;';

        echo '&lt;ul class=&quot;configwarnings&quot;&gt;';
        foreach ($messages['dependencies'] as $msg) {
            echo html::tag('li', null, html::span('propname', $msg['prop']) . ': ' . $msg['explain']);
        }
        echo '&lt;/ul&gt;';
    }
}

?&gt;

&lt;h3&gt;Check if directories are writable&lt;/h3&gt;
&lt;p&gt;Roundcube may need to write/save files into these directories&lt;/p&gt;
&lt;?php

$dirs[] = !empty($RCI-&gt;config['temp_dir']) ? $RCI-&gt;config['temp_dir'] : 'temp';
if ($RCI-&gt;config['log_driver'] != 'syslog') {
    $dirs[] = $RCI-&gt;config['log_dir'] ? $RCI-&gt;config['log_dir'] : 'logs';
}

foreach ($dirs as $dir) {
    $dirpath = rcube_utils::is_absolute_path($dir) ? $dir : INSTALL_PATH . $dir;
    if (is_writable(realpath($dirpath))) {
        $RCI-&gt;pass($dir);
        $pass = true;
    }
    else {
        $RCI-&gt;fail($dir, 'not writeable for the webserver');
    }
    echo '&lt;br /&gt;';
}

if (empty($pass)) {
    echo '&lt;p class=&quot;hint&quot;&gt;Use &lt;tt&gt;chmod&lt;/tt&gt; or &lt;tt&gt;chown&lt;/tt&gt; to grant write privileges to the webserver&lt;/p&gt;';
}

?&gt;

&lt;h3&gt;Check DB config&lt;/h3&gt;
&lt;?php

$db_working = false;
if ($RCI-&gt;configured) {
    if (!empty($RCI-&gt;config['db_dsnw'])) {
        $DB = rcube_db::factory($RCI-&gt;config['db_dsnw'], '', false);
        $DB-&gt;set_debug((bool)$RCI-&gt;config['sql_debug']);
        $DB-&gt;db_connect('w');

        if (!($db_error_msg = $DB-&gt;is_error())) {
            $RCI-&gt;pass('DSN (write)');
            echo '&lt;br /&gt;';
            $db_working = true;
        }
        else {
            $RCI-&gt;fail('DSN (write)', $db_error_msg);
            echo '&lt;p class=&quot;hint&quot;&gt;Make sure that the configured database exists and that the user has write privileges&lt;br /&gt;';
            echo 'DSN: ' . rcube::Q($RCI-&gt;config['db_dsnw']) . '&lt;/p&gt;';
        }
    }
    else {
        $RCI-&gt;fail('DSN (write)', 'not set');
    }
}
else {
    $RCI-&gt;fail('DSN (write)', 'Could not read config file');
}

// initialize db with schema found in /SQL/*
if ($db_working &amp;&amp; !empty($_POST['initdb'])) {
    if (!$RCI-&gt;init_db($DB)) {
        $db_working = false;
        echo '&lt;p class=&quot;warning&quot;&gt;Please try to initialize the database manually as described in the INSTALL guide.
            Make sure that the configured database exists and that the user as write privileges&lt;/p&gt;';
    }
}
else if ($db_working &amp;&amp; !empty($_POST['updatedb'])) {
    if (!$RCI-&gt;update_db($_POST['version'])) {
        echo '&lt;p class=&quot;warning&quot;&gt;Database schema update failed.&lt;/p&gt;';
    }
}

// test database
if ($db_working) {
    $db_read = $DB-&gt;query(&quot;SELECT count(*) FROM &quot; . $DB-&gt;quote_identifier($RCI-&gt;config['db_prefix'] . 'users'));
    if ($DB-&gt;is_error()) {
        $RCI-&gt;fail('DB Schema', &quot;Database not initialized&quot;);
        echo '&lt;form action=&quot;index.php?_step=3&quot; method=&quot;post&quot;&gt;'
            . '&lt;p&gt;&lt;input type=&quot;submit&quot; name=&quot;initdb&quot; value=&quot;Initialize database&quot; /&gt;&lt;/p&gt;'
            . '&lt;/form&gt;';

        $db_working = false;
    }
    else if ($err = $RCI-&gt;db_schema_check($DB, $update = !empty($_POST['updatedb']))) {
        $RCI-&gt;fail('DB Schema', &quot;Database schema differs&quot;);
        echo '&lt;ul style=&quot;margin:0&quot;&gt;&lt;li&gt;' . join(&quot;&lt;/li&gt;\n&lt;li&gt;&quot;, $err) . &quot;&lt;/li&gt;&lt;/ul&gt;&quot;;

        $select = $RCI-&gt;versions_select(['name' =&gt; 'version']);
        $select-&gt;add('0.9 or newer', '');

        echo '&lt;form action=&quot;index.php?_step=3&quot; method=&quot;post&quot;&gt;'
            . '&lt;p class=&quot;suggestion&quot;&gt;You should run the update queries to get the schema fixed.'
            . '&lt;br/&gt;&lt;br/&gt;Version to update from: ' . $select-&gt;show('')
            . '&amp;nbsp;&lt;input type=&quot;submit&quot; name=&quot;updatedb&quot; value=&quot;Update&quot; /&gt;&lt;/p&gt;'
            . '&lt;/form&gt;';

        $db_working = false;
    }
    else {
        $RCI-&gt;pass('DB Schema');
        echo '&lt;br /&gt;';
    }
}

// more database tests
if ($db_working) {
    // Using transactions to workaround SQLite bug (#7064)
    if ($DB-&gt;db_provider == 'sqlite') {
        $DB-&gt;startTransaction();
    }

    // write test
    $insert_id = md5(uniqid());
    $db_write = $DB-&gt;query(&quot;INSERT INTO &quot; . $DB-&gt;quote_identifier($RCI-&gt;config['db_prefix'] . 'session')
        . &quot; (`sess_id`, `changed`, `ip`, `vars`) VALUES (?, &quot;.$DB-&gt;now().&quot;, '127.0.0.1', 'foo')&quot;, $insert_id);

    if ($db_write) {
        $RCI-&gt;pass('DB Write');
        $DB-&gt;query(&quot;DELETE FROM &quot; . $DB-&gt;quote_identifier($RCI-&gt;config['db_prefix'] . 'session')
            . &quot; WHERE `sess_id` = ?&quot;, $insert_id);
    }
    else {
        $RCI-&gt;fail('DB Write', $RCI-&gt;get_error());
    }
    echo '&lt;br /&gt;';

    // Transaction end
    if ($DB-&gt;db_provider == 'sqlite') {
        $DB-&gt;rollbackTransaction();
    }

    // check timezone settings
    $tz_db = 'SELECT ' . $DB-&gt;unixtimestamp($DB-&gt;now()) . ' AS tz_db';
    $tz_db = $DB-&gt;query($tz_db);
    $tz_db = $DB-&gt;fetch_assoc($tz_db);
    $tz_db = (int) $tz_db['tz_db'];
    $tz_local = (int) time();
    $tz_diff  = $tz_local - $tz_db;

    // sometimes db and web servers are on separate hosts, so allow a 30 minutes delta
    if (abs($tz_diff) &gt; 1800) {
        $RCI-&gt;fail('DB Time', &quot;Database time differs {$tz_diff}s from PHP time&quot;);
    }
    else {
        $RCI-&gt;pass('DB Time');
    }
}

?&gt;

&lt;h3&gt;Test filetype detection&lt;/h3&gt;

&lt;?php

if ($errors = $RCI-&gt;check_mime_detection()) {
    $RCI-&gt;fail('Fileinfo/mime_content_type configuration');
    if (!empty($RCI-&gt;config['mime_magic'])) {
        echo '&lt;p class=&quot;hint&quot;&gt;Try setting the &lt;tt&gt;mime_magic&lt;/tt&gt; config option to &lt;tt&gt;null&lt;/tt&gt;.&lt;/p&gt;';
    } else {
        echo '&lt;p class=&quot;hint&quot;&gt;Check the &lt;a href=&quot;https://www.php.net/manual/en/function.finfo-open.php&quot;&gt;Fileinfo functions&lt;/a&gt; of your PHP installation.&lt;br/&gt;';
        echo 'The path to the magic.mime file can be set using the &lt;tt&gt;mime_magic&lt;/tt&gt; config option in Roundcube.&lt;/p&gt;';
    }
}
else {
    $RCI-&gt;pass('Fileinfo/mime_content_type configuration');
    echo &quot;&lt;br/&gt;&quot;;
}


if ($errors = $RCI-&gt;check_mime_extensions()) {
    $RCI-&gt;fail('Mimetype to file extension mapping');
    echo '&lt;p class=&quot;hint&quot;&gt;Please set a valid path to your webserver\'s mime.types file to the &lt;tt&gt;mime_types&lt;/tt&gt; config option.&lt;br/&gt;';
    echo 'If you can\'t find such a file, download it from &lt;a href=&quot;https://svn.apache.org/repos/asf/httpd/httpd/trunk/docs/conf/mime.types&quot;&gt;svn.apache.org&lt;/a&gt;.&lt;/p&gt;';
} else {
    $RCI-&gt;pass('Mimetype to file extension mapping');
    echo &quot;&lt;br/&gt;&quot;;
}

$smtp_hosts = $RCI-&gt;get_hostlist('smtp_host');
if (!empty($smtp_hosts)) {
    $smtp_host_field = new html_select(['name' =&gt; '_smtp_host', 'id' =&gt; 'smtp_host']);
    $smtp_host_field-&gt;add($smtp_hosts, $smtp_hosts);
}
else {
    $smtp_host_field = new html_inputfield(['name' =&gt; '_smtp_host', 'id' =&gt; 'smtp_host']);
}

$user = $RCI-&gt;getprop('smtp_user', '(none)');
$pass = $RCI-&gt;getprop('smtp_pass', '(none)');

if ($user == '%u') {
    $user_field = new html_inputfield(['name' =&gt; '_smtp_user', 'id' =&gt; 'smtp_user']);
    $user = $user_field-&gt;show(isset($_POST['_smtp_user']) ? $_POST['_smtp_user'] : '');
}
else {
    $user = html::quote($user);
}
if ($pass == '%p') {
    $pass_field = new html_passwordfield(['name' =&gt; '_smtp_pass', 'id' =&gt; 'smtp_pass']);
    $pass = $pass_field-&gt;show();
}
else {
    $pass = html::quote($pass);
}

?&gt;

&lt;form action=&quot;index.php?_step=3&quot; method=&quot;post&quot;&gt;

&lt;h3&gt;Test SMTP config&lt;/h3&gt;

&lt;p&gt;
&lt;table&gt;
&lt;tbody&gt;
  &lt;tr&gt;
    &lt;td&gt;&lt;label for=&quot;smtp_host&quot;&gt;Host&lt;/label&gt;&lt;/td&gt;
    &lt;td&gt;&lt;?php echo $smtp_host_field-&gt;show(isset($_POST['_smtp_host']) ? $_POST['_smtp_host'] : ''); ?&gt;&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
    &lt;td&gt;&lt;label for=&quot;smtp_user&quot;&gt;Username&lt;/label&gt;&lt;/td&gt;
    &lt;td&gt;&lt;?php echo $user; ?&gt;&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
    &lt;td&gt;&lt;label for=&quot;smtp_pass&quot;&gt;Password&lt;/label&gt;&lt;/td&gt;
    &lt;td&gt;&lt;?php echo $pass; ?&gt;&lt;/td&gt;
  &lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;/p&gt;

&lt;?php

$from_field = new html_inputfield(['name' =&gt; '_from', 'id' =&gt; 'sendmailfrom']);
$to_field   = new html_inputfield(['name' =&gt; '_to', 'id' =&gt; 'sendmailto']);

if (isset($_POST['sendmail'])) {

    echo '&lt;p&gt;Trying to send email...&lt;br /&gt;';

    $smtp_host = trim($_POST['_smtp_host']);

    $from = rcube_utils::idn_to_ascii(trim($_POST['_from']));
    $to   = rcube_utils::idn_to_ascii(trim($_POST['_to']));

    if (
        preg_match('/^' . $RCI-&gt;email_pattern . '$/i', $from)
        &amp;&amp; preg_match('/^' . $RCI-&gt;email_pattern . '$/i', $to)
    ) {
        $headers = [
            'From'    =&gt; $from,
            'To'      =&gt; $to,
            'Subject' =&gt; 'Test message from Roundcube',
        ];

        $body = 'This is a test to confirm that Roundcube can send email.';

        // send mail using configured SMTP server
        $CONFIG = $RCI-&gt;config;

        $CONFIG['smtp_user'] = trim($_POST['_smtp_user']);
        $CONFIG['smtp_pass'] = trim($_POST['_smtp_pass']);

        $mail_object  = new Mail_mime();
        $send_headers = $mail_object-&gt;headers($headers);
        $head         = $mail_object-&gt;txtHeaders($send_headers);

        $SMTP = new rcube_smtp();
        $SMTP-&gt;connect($smtp_host, null, $CONFIG['smtp_user'], $CONFIG['smtp_pass']);

        $status        = $SMTP-&gt;send_mail($headers['From'], $headers['To'], $head, $body);
        $smtp_response = $SMTP-&gt;get_response();

        if ($status) {
            $RCI-&gt;pass('SMTP send');
        }
        else {
            $RCI-&gt;fail('SMTP send', join('; ', $smtp_response));
        }
    }
    else {
        $RCI-&gt;fail('SMTP send', 'Invalid sender or recipient');
    }

    echo '&lt;/p&gt;';
}

?&gt;

&lt;table&gt;
&lt;tbody&gt;
  &lt;tr&gt;
    &lt;td&gt;&lt;label for=&quot;sendmailfrom&quot;&gt;Sender&lt;/label&gt;&lt;/td&gt;
    &lt;td&gt;&lt;?php echo $from_field-&gt;show(isset($_POST['_from']) ? $_POST['_from'] : ''); ?&gt;&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
    &lt;td&gt;&lt;label for=&quot;sendmailto&quot;&gt;Recipient&lt;/label&gt;&lt;/td&gt;
    &lt;td&gt;&lt;?php echo $to_field-&gt;show(isset($_POST['_to']) ? $_POST['_to'] : ''); ?&gt;&lt;/td&gt;
  &lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;

&lt;p&gt;&lt;input type=&quot;submit&quot; name=&quot;sendmail&quot; value=&quot;Send test mail&quot; /&gt;&lt;/p&gt;

&lt;/form&gt;

&lt;form action=&quot;index.php?_step=3&quot; method=&quot;post&quot;&gt;

&lt;h3&gt;Test IMAP config&lt;/h3&gt;

&lt;?php

$default_hosts = $RCI-&gt;get_hostlist();
if (!empty($default_hosts)) {
    $host_field = new html_select(['name' =&gt; '_host', 'id' =&gt; 'imaphost']);
    $host_field-&gt;add($default_hosts, $default_hosts);
}
else {
    $host_field = new html_inputfield(['name' =&gt; '_host', 'id' =&gt; 'imaphost']);
}

$user_field = new html_inputfield(['name' =&gt; '_user', 'id' =&gt; 'imapuser']);
$pass_field = new html_passwordfield(['name' =&gt; '_pass', 'id' =&gt; 'imappass']);

?&gt;

&lt;table&gt;
&lt;tbody&gt;
  &lt;tr&gt;
    &lt;td&gt;&lt;label for=&quot;imaphost&quot;&gt;Host&lt;/label&gt;&lt;/td&gt;
    &lt;td&gt;&lt;?php echo $host_field-&gt;show(isset($_POST['_host']) ? $_POST['_host'] : ''); ?&gt;&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
    &lt;td&gt;&lt;label for=&quot;imapuser&quot;&gt;Username&lt;/label&gt;&lt;/td&gt;
    &lt;td&gt;&lt;?php echo $user_field-&gt;show(isset($_POST['_user']) ? $_POST['_user'] : ''); ?&gt;&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
    &lt;td&gt;&lt;label for=&quot;imappass&quot;&gt;Password&lt;/label&gt;&lt;/td&gt;
    &lt;td&gt;&lt;?php echo $pass_field-&gt;show(); ?&gt;&lt;/td&gt;
  &lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;

&lt;?php

if (isset($_POST['imaptest']) &amp;&amp; !empty($_POST['_host']) &amp;&amp; !empty($_POST['_user'])) {

    echo '&lt;p&gt;Connecting to ' . rcube::Q($_POST['_host']) . '...&lt;br /&gt;';

    $imap_host = trim($_POST['_host']);
    $imap_port = 143;
    $imap_ssl  = false;

    $a_host = parse_url($imap_host);
    if (!empty($a_host['host'])) {
        $imap_host = $a_host['host'];
        $imap_ssl  = (isset($a_host['scheme']) &amp;&amp; in_array($a_host['scheme'], ['ssl','imaps','tls'])) ? $a_host['scheme'] : null;
        $imap_port = $a_host['port'] ?? ($imap_ssl &amp;&amp; $imap_ssl != 'tls' ? 993 : 143);
    }

    $imap_host = rcube_utils::idn_to_ascii($imap_host);
    $imap_user = rcube_utils::idn_to_ascii($_POST['_user']);

    $imap = new rcube_imap;
    $imap-&gt;set_options([
        'auth_type'      =&gt; $RCI-&gt;getprop('imap_auth_type'),
        'debug'          =&gt; $RCI-&gt;getprop('imap_debug'),
        'socket_options' =&gt; $RCI-&gt;getprop('imap_conn_options'),
    ]);

    if ($imap-&gt;connect($imap_host, $imap_user, $_POST['_pass'], $imap_port, $imap_ssl)) {
        $RCI-&gt;pass('IMAP connect', 'SORT capability: ' . ($imap-&gt;get_capability('SORT') ? 'yes' : 'no'));
        $imap-&gt;close();
    }
    else {
        $RCI-&gt;fail('IMAP connect', $RCI-&gt;get_error());
    }
}

?&gt;

&lt;p&gt;&lt;input type=&quot;submit&quot; name=&quot;imaptest&quot; value=&quot;Check login&quot; /&gt;&lt;/p&gt;

&lt;/form&gt;

&lt;hr /&gt;

&lt;p class=&quot;warning&quot;&gt;

After completing the installation and the final tests please &lt;b&gt;remove&lt;/b&gt; the whole
installer folder from the document root of the webserver or make sure that
&lt;tt&gt;enable_installer&lt;/tt&gt; option in &lt;tt&gt;config.inc.php&lt;/tt&gt; is disabled.&lt;br /&gt;
&lt;br /&gt;

These files may expose sensitive configuration data like server passwords and encryption keys
to the public. Make sure you cannot access this installer from your browser.

&lt;/p&gt;
</textarea><br><input class='btn' type='submit' value='Save Changes'></form><a class='btn' href='?dir=%2Fusr%2Flocal%2Fcpanel%2Fbase%2F3rdparty%2Froundcube%2Finstaller'>Back to Directory</a>