Thursday, 20 March 2014

roundcubemail customisation and installation


setting up roundcube mail

1. Install the RPM and dependencies.


      mysql -u root -p' .... ' < '


      create database roundcubemail;


      create user roundcube@localhost identified by 'somepass';


      grant all on roundcubemail.* to roundcube@localhost;


    flush privileges;'

3. then

mysql -u root -p roundcubemail < /usr/share/doc/roundcubemail-0.9.5/SQL/mysql.initial.sql

4. then


edit line to say

$rcmail_config['db_dsnw'] = 'mysql://roundcube:somepass@localhost/roundcubemail';

5. then


and add the following directive

      Alias /roundcube/ "/usr/share/roundcubemail/"


      <Directory "/usr/share/roundcubemail/">


      AllowOverride All


      Options Indexes All


      Order allow,deny


      Allow from all




6. Go to <your host domain name (not FQDN) > /roundcube/


1. ensure that /usr/share/roundcubemail/logs exists and is owned by apache. Create a file 'error' in there with the same ownership.

mkdir -p  /usr/share/roundcubemail/logs

touch /usr/share/roundcubemail/logs/error

chown -R apache:apache  /usr/share/roundcubemail/logs

chmod -R 775  /usr/share/roundcubemail/logs

2. set the same ownership on /etc/roundcubemail

the symptom is a white screen and this error in apache log:

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

              chown -R apache:apache    /etc/roundcubemail


      and put in the database password and username

3. Moaning about the timezone:

you have to edit the offending files and insert your timezone, e.g.


line 436 or thereabouts of file rcube_config.php is particularly different:


return $timezone; #; date_default_timezone_get();  /*jmo */

all other files you can just put


the file rcube.php (line 1023) needs this too. 

4. Moaning about missing tables:

login to mysql and create a database roundcubemail

create database roundcubemail character set utf8;

grant all on roundcubemail.* to 'roundcube'@'localhost' identified by 'somepass'; 

then on the commandline (bash):

             mysql roundcubemail -u root -p < /usr/share/doc/roundcubemail-0.9.5/SQL/mysql.initial.sql


5. Setting it to use Gmail:



and tell it

$rcmail_config['default_host'] = 'ssl://';

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

6. To customise it

             Edit /usr/share/roundcubemail/skins/larry or classic

Wednesday, 19 March 2014

php complaining about dates

If you get this error

date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier.

then just manually put the following code (With appropriate changes) into your code, just before any call to date() or anything related.


That fixes it.

Friday, 7 March 2014

the "hobbit" homo floresiensis

@katewong @sciam big diff betw. florensiensis and sediba. Face angle to start with. Age also differs by well over 2my

@johnostrowick Interested b/c both species show surprising combos of Australopithecus & Homo traits, & b/c flores ancestor is a big mystery

@katewong @sciam I "scarequoted" "new" as Jungers dates to 2009 - Vol 459|7 May 2009|doi:10.1038/nature07989 The foot of Homo floresiensis

php 7 nightmare

OK so Centos 6 insists on installing php 5.3 and even if you download other RPMs and install them, they do not replace the existing 5.3 whic...