Differences

This shows you the differences between two versions of the page.

--- roundcube [2022/07/19 19:52] – created 85.134.209.200
+++ roundcube [2022/07/27 20:56] (current) – verify_peer_name to false also admin
@@ Line 4: / Line 4: @@
 I did think of using ilohamail as it was on apt-get, but I heard and used roundcube before, so I said I'd go with that, even though it wasn't on apt-get for lenny.
+====== Setup Roundcube on Debian Bullseye with SQLite ======
+==== Install ====
+<code>
+apt-get install roundcube-core roundcube-sqlite3
+Configure database for roundcube with dbconfig-common?
+YES
+When prompted choose
+sqlite
+</code>
+That should be it installed.
+==== Configure Apache ====
+By default roundcube gets enabled in apache and its config is placed in: /etc/apache2/conf-enabled/roundcube.conf
+<code>
+vi /etc/apache2/conf-enabled/roundcube.conf
+#uncomment
+#Alias /roundcube /var/lib/roundcube/public_html
+/etc/init.d/apache2 reload
+</code>
+In your browser navigate to: http://server/roundcube and it should show.
+==== Config Roundcube ====
+Need to config for imaps and to ignore self-signed cert.
+<code>
+vi /etc/roundcube/config.inc.php
+$config['default_host'] = 'ssl://server.com';
+$config['default_port'] = 993;
+$config['imap_conn_options'] = array(
+  'ssl'         => array(
+     'verify_peer'  => false,
+     'verify_depth' => 3,
+     'cafile'       => '/etc/ssl/certs/ca-certificates.crt',
+   ),
+ );
+</code>
+Now you should be able to login.
+=== Sending Emails with Roundcube Config ===
+I was getting error: **SMTP Error (250): Authentication failed**
+Config used:
+<code>
+vi /etc/roundcube/config.inc.php
+#add/set/amend to
+$config['smtp_server'] = 'tls://server.domain.com';
+$config['smtp_port'] = 25;
+$config['smtp_conn_options'] = array(
+   'ssl'         => array(
+     'verify_peer'  => false,
+     'verify_peer_name' => false,
+     'verify_depth' => 3,
+     'cafile'       => '/etc/ssl/certs/ca-certificates.crt',
+   ),
+ );
+$config['smtp_user'] = '%u';
+$config['smtp_pass'] = '%p';
+$config['smtp_auth_type'] = PLAIN;
+</code>
+I tried to get roundcube to send without auth, but it wouldn't work.
+The above works. This works with postfix setup [[setup-config-debian-bullseye#secure_smtpd_using_postfix_and_sasl|here]]
 ====== Setup Roundcube on Debian Lenny with SQLite ======
@@ Line 9: / Line 78: @@
 http://sourceforge.net/export/rss2_projnews.php?group_id=139281 and http://roundcube.net/news
+<code>
  cd /var/www/
  mkdir roundcube
@@ Line 61: / Line 131: @@
  #Couple of tweaks.
  Login: Settings - Identities
+</code>
 ===== Notes =====
 I was happy I could use ssl on 993 as I have imap 143 blocked at the firewall. I think roundcube bottom posts (as opposed to top post) when replying to emails. I think this will be fixed down the line. It wasn't much of an issue.
@@ Line 67: / Line 137: @@
 ===== Issues =====
 chmod 777 or setting the permissions on sqlite.db was unsufficient on its own. The folder in which sqlite.db is located must be writable by the server (to create temp lock files). As a result I chose to create a db folder and to place sqlite.db in that! Otherwise you might get this error:
+<code>
  [[08-Jan-2010|01:19:38 +0000]]: DB Error: MDB2 Error: unknown error Query: _doQuery: [[Error|message: Could not execute statement]] [Last executed query: INSERT INTO users (created, last_login, username, mail_host, alias, language) VALUES (now(), now(), 'sburke', 'localhost', //, 'en_US')] [[Native|code: 14]] [Native message: unable to open database file]  in /home/sburke/public_html/rc/roundcubemail-0.3.1/program/include/rcube_mdb2.php on line 627 (POST /stephen/rc/roundcubemail-0.3.1/?_task=&_action=login)
  [[08-Jan-2010|01:19:38]] MDB2 Error: unknown error (-1): lastInsertID: [[Error|message: Could not get last insert ID]]
@@ Line 74: / Line 145: @@
  [[Native|code: 14]]
  [[Native|message: unable to open database file]]
+</code>
 The actual config for sqlite is:
+<code>
  $rcmail_config[['db_dsnw']] = 'sqlite:/<nowiki>//</nowiki>/var/www/roundcube/db/sqlite.db?mode=0646';
  #thats 4 forward slashes!!
+</code>
 Dont use sqlite3 to create the sqlite.db. It wont work.
 Looks good apart from that.
 References:
-http://fak3r.com/2005/11/15/howto-install-roundcube-webmail-from-svn-was-cvs-on-freebsd/  <br>
+  * http://fak3r.com/2005/11/15/howto-install-roundcube-webmail-from-svn-was-cvs-on-freebsd/  <br>
-http://www.roundcubeforum.net/5-release-support/18-resolved-issues/2247-sqlite-problem-solved.html   <br>
+  * http://www.roundcubeforum.net/5-release-support/18-resolved-issues/2247-sqlite-problem-solved.html   <br>
-http://www.howtoforge.com/forums/archive/index.php/t-27452.html  <br>
+  * http://www.howtoforge.com/forums/archive/index.php/t-27452.html  <br>
-http://trac.roundcube.net/wiki/Howto_Install  <br>
+  * http://trac.roundcube.net/wiki/Howto_Install  <br>