Roundcube Community Forum

Miscellaneous => Roundcube Discussion => Topic started by: SipriusPT on January 13, 2017, 06:49:34 AM

Title: (SOLVED) Question about the installation of rcguard for captchas
Post by: SipriusPT on January 13, 2017, 06:49:34 AM

Hello guys,

I am trying to install the rcguard for captchas at roundcube but i dont know well how to set this with SQL.

After start to read the installation guide (https://github.com/dsoares/rcguard) i was unable to do this because i really dont know how can i do it:

Use the files within SQL/ to create the database layout required for rcguard. The table should be created in the database used by Roundcube.

My knowledge about SQL is almost none :-[

And do i have to install PHP GD to let this plugin run?

Title: Re: Question about the installation of rcguard for captchas
Post by: SKaero on January 13, 2017, 07:24:30 AM

You need to run the sql file to import it into the database. What database (MySQL, PostgreSQL, SQLite) does your Roundcube install use?

It doesn't look like you need GD library just a recaptcha api key.

Title: Re: Question about the installation of rcguard for captchas
Post by: SipriusPT on January 13, 2017, 07:45:13 AM

Hey SKaero!  :D

I am using MySQL. How can i run the sql file to import?

Yes, i have just added the API key of reCAPTCHA from google, in the rcguard config file.

Title: Re: Question about the installation of rcguard for captchas
Post by: SipriusPT on January 13, 2017, 09:35:41 AM

SKaero just confirm if the right sintax is this one please:

mysql -u <roundcubeuser> -p <dbname> < <mysql.initial.sql from rcguard>

Title: Re: Question about the installation of rcguard for captchas
Post by: SipriusPT on January 13, 2017, 10:12:58 AM

I have just done that and add the name of the plugin at:

$config['plugins'] = array('rcguard-master','emoticons');

But after doing some tests didnt show up.

Here is the config of this plugin:

Code: [Select]

// Number of failed logins before reCAPTCHA is shown
$rcmail_config['failed_attempts'] = 3;

// Release IP after how many minutes (after last failed attempt)
$rcmail_config['expire_time'] = 10;

// Reset failure count after successfull login (see bratkartoffel/rcguard@670395e)
$rcmail_config['rcguard_reset_after_success'] = true;

// reCAPTCHA API
$rcmail_config['recaptcha_api']        = 'http://www.google.com/recaptcha/api.js';
$rcmail_config['recaptcha_api_secure'] = 'https://www.google.com/recaptcha/api.js';

// Use HTTPS for reCAPTCHA
$rcmail_config['recaptcha_https'] = false;

// Log events
$rcmail_config['recaptcha_log'] = true;

// Event is not logged when set to NULL
// Parameter expansion:
// %r - Remote IP
// %u - Username
$rcmail_config['recaptcha_log_success'] = 'Verification succeeded for %u. [%r]';
$rcmail_config['recaptcha_log_failure'] = 'Error: Verification failed for %u. [%r]';
$rcmail_config['recaptcha_log_unknown'] = 'Error: Unknown log type.';

// Block IPv6 clients based on prefix length
// Use an integer between 16 and 128, 0 to disable
$rcmail_config['rcguard_ipv6_prefix'] = 0;
I have added both public and private keys from google.

UPDATE1:

At errors log file i am getting when is supposed to show:

Code: [Select]

[13-Jan-2017 15:22:32 +0000]: PHP Error: Failed to load plugin file /Library/Server/Web/Data/Sites/Default/plugins/rcguard-master/rcguard-master.php in /Library/Server/Web/Data/Sites/Default/program/lib/Roundcube/rcube_plugin_api.php on line 173 (POST /?_task=login&_action=login)

Title: Re: Question about the installation of rcguard for captchas
Post by: SKaero on January 13, 2017, 04:40:03 PM

In the plugin array it should be 'rcguard' not 'rcguard-master'

Title: Re: Question about the installation of rcguard for captchas
Post by: SipriusPT on January 16, 2017, 05:34:25 AM

Ah it was a bad path problem, this plugin folder is named as rcguard-master and the php as rcguard =/ they should have given the same name to both folder and php file, since roundcube will use the name at plugins array to build that path.

Thanks SKaero!  :D