From fa62526571d93444641264c95df688d79057ea88 Mon Sep 17 00:00:00 2001 From: Gustav Eek Date: Sun, 11 Dec 2011 15:03:37 +0100 Subject: The work with understandig MySQL was continued. --- admin-howtos.org | 2 +- admin-log.org | 37 ++++++++++++++++++++++++++++++++++++- 2 files changed, 37 insertions(+), 2 deletions(-) diff --git a/admin-howtos.org b/admin-howtos.org index 2a1449b..c63585f 100644 --- a/admin-howtos.org +++ b/admin-howtos.org @@ -17,6 +17,6 @@ : > show databases; : > use mail; : > show tables; - : > discribe ; + : > describe
; diff --git a/admin-log.org b/admin-log.org index d8966da..87f0719 100644 --- a/admin-log.org +++ b/admin-log.org @@ -35,6 +35,8 @@ The =/etc/fstab= is no longer correct since "ext4dev" is not a supported file sy * Configure Roundcube for password change <2011-11-22 tis> + From phone call with Stefan. Appache is configured differently and better on zetkin. There is one file per host which is better then having all host's configurations in one file. However, the Roundcube installation is older on zetkin, so ti could be wise to update with backports. + <2011-11-22 tis> [[http://www.roundcube.net/][Official website]]. The plugin of interest is [[http://trac.roundcube.net/browser/trunk/plugins/password][passord]] found from [[http://trac.roundcube.net/wiki/Plugin_Repository][Pugin Repository]]. <2011-11-24 tor> Found the Roundcube directory: /var/lib/roundcube/. The configuration files are in /etc/roudcube/. Also the relevant Apache2 configuration files are linked into /etc/roundcube/. Plugins are placed in /var/lib/rouncube/plugins/ and installed by editing /etc/roundcube/main.inc.php/. It took a while to figure Apache out enough to find the directories. Roudcube is not really a program; it is just some PHP script. @@ -45,4 +47,37 @@ The =/etc/fstab= is no longer correct since "ext4dev" is not a supported file sy It appears that some plugins comes with the installation. See [[http://www.roundcubeforum.net/3-news-announcements/12-general-discussion/5258-plugin-download-link.html][This post]]. - Finally the plugin is installed; I requested the full stable 0.6-version sources to my home directory and copied the plugin files into /var/lib/roundcube/plugin. Next step will be to identify how to establish a connection with the IMAP (daabase) server. + Finally the plugin is installed; I requested the full stable 0.6-version sources to my home directory and copied the plugin files into /var/lib/roundcube/plugin. Next step will be to identify how to establish a connection with the IMAP (database) server. + + <2011-12-06 tis> This is hard. It is not MySQL's MD5 algorithm that is used. The check sum is probably of base 64 and not hexadecimal (from Password.pm). Can this be a plan: + - Reproduce the fripost-passwd perl script to realise what is happening. + - Confirm how the connection is established between roundcube and imap.fripost.org + + <2011-12-10 lör> Notes from phone call with Stefan. (1) Create a user, /roudcubetunnel/, on /antilop/ and configure tunnel according to fripost-documentation. (2) the password is created together with a salt. + + <2011-12-11 sön> MySQL was installed on cantor on order to have a lab system: /root//'root', database /fripost-lab/. + : > create database fripost-lab + Log in using: + : $ mysql --user=root --password fripost_lab + + Read Section 5.3.2.2, "End-User Guidelines for Password Security". + + User created according to 5.5.2. "Adding User Accounts". + : > create user 'roundcube'@'localhost' identified by 'roundcube'; + : > create user 'roundcube'@'%' identified by 'roundcube'; -- so it can be used from all hosts + : > show grants for 'roundcube'@'localhost'; + : > show grants for 'roundcube'@'%'; + : > set password for 'roundcube'@'localhost' = password('roundcube'); + : > set password for 'roundcube'@'%' = password('roundcube'); + : > grant select, update on fripost_lab.mailbox to 'roundcube'@'localhost'; + : > grant select, update on fripost_lab.mailbox to 'roundcube'@'%'; + + + The command /grant/ gives /roundcube/ privileges to select and update table /mailbox/. There is no possibility to give privileges to just update certain columns in a table. If that is sought for a separate table has to be created. + + Next: + - create an SQL-script that tests all privileges, and try it on /roundcube@localhost/ and /roundcube@%/. + - create that user on /antilop/ + + + -- cgit v1.2.3