search

gianlucagiacometti / roundcube-toolbox

Set of tools for Roundcube webmail
15 stars 10 forks source link

Notworking #17

Closed aloksinha3110 closed 3 years ago

aloksinha3110 commented 3 years ago

image

What is the issue with this? when I click on options it will not show any things, please recheck it.

aloksinha3110 commented 3 years ago

I am using Roundcube v 1.4.11 with virtualmin

gianlucagiacometti commented 3 years ago

Which database are you using? Did you create the SQL tables?

aloksinha3110 commented 3 years ago

I created a new DB but not a table, can you tell me the proper setup? I am new to Roundcube

gianlucagiacometti commented 3 years ago

Folder SQL contains the SQL table structures. Please, read carefully the readme file, everything is explained in details. Let me know if instructions are not clear

gianlucagiacometti commented 3 years ago

Please note that Aliases, Forward and Out of office are designed for postfixamin. If your postfix install does not use a database backend you can't use them. Purge and Customise do not need postfixadmin, but they need additional tables in roundcube database (structure in SQL folder). Moreover, Attachment and Customise need a writable folder. It's all in the readme.

aloksinha3110 commented 3 years ago

Hello Still not working, I have restored the.sql file. MariaDB [aloktools]> show tables; +------------------------------+ | Tables_in_aloktools | +------------------------------+ | toolbox_customise_domains | | toolbox_customise_skins | | toolbox_customise_skins_view | +------------------------------+

Please tell me what wrong i am doing?

gianlucagiacometti commented 3 years ago

What error? Can you please post your logs? You can check toolbox.log and increase the debug level in the config file. Without information I cannot help you.

On 6 June 2021 06:10:13 Alok @.***> wrote:

Hello Still not working, I have restored the.sql file. MariaDB [aloktools]> show tables; +------------------------------+ | Tables_in_aloktools | +------------------------------+ | toolbox_customise_domains | | toolbox_customise_skins | | toolbox_customise_skins_view | +------------------------------+Please tell me what wrong i am doing? — You are receiving this because you commented. Reply to this email directly, view it on GitHub, or unsubscribe.

gianlucagiacometti commented 3 years ago

By the way, with roundcube 1.4.11 use the git version of toolbox

aloksinha3110 commented 3 years ago

abc.in/?_task=settings&_action=plugin.toolbox.edit&_section=attachments&_framed=1 all the url of this plugin giving me HTTP ERROR 500

aloksinha3110 commented 3 years ago 
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> STEP in [function init]: initialise plugin
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> STEP in [function init]: load user's preferences
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> STEP in [function init]: 'preview' tool active and loaded
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> STEP in [function init]: skin: elastic
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> STEP in [function init]: load customised skin configuration from config
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> STEP in [function init]: load customised skin configuration from database
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> STEP in [storage].[sql].[function load_customised_config]: connecting to roundcube database in read mode
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> SQL in [storage].[sql].[function load_customised_config]: execute query [SELECT domain_name`, `skin`, `customise_blankpage`, `blankpage_type`, `blankpage_image` `blankpage_url`, `blankpage_custom`, `customise_css`, `additional_css`, `customise_logo`, `customised_logo` FROM `toolbox_customise_skins_view` WHERE `domain_name` = '' AND `skin` = 'elastic';]
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> SQL in [storage].[sql].[function load_customised_config]: 0 rows matching
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> STEP in [function init]: 'customise blank page' database option selected: override config
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> STEP in [function init]: customised blank page type: Roundcube default
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> STEP in [function init]: 'customise additional css' database option not selected: loading from config
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> STEP in [function init]: customised additional css file not found, empty or not defined
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> STEP in [function init]: 'customise logo' database option not selected: loading from config
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> STEP in [function init]: 'attachments' tool active and loaded
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> STEP in [function init]: initialise storage to check if domain admin (blank section)
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> STEP in [storage].[sql].[function is_domain_admin]: connecting to postfix database in read mode
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> SQL in [storage].[sql].[function is_domain_admin]: execute query [SELECT `domain` FROM `domain_admins` WHERE `username` = 'alok@abcs.in';]
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> ERROR in [storage].[sql].[function is_domain_admin]: cannot read domain admins from database: [1146] Table 'aloktools.domain_admins' doesn't exist
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> SQL in [storage].[sql].[function is_domain_admin]: found 0 domains ()
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> STEP in [function init]: load plugin tool aliases
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> STEP in [function init]: load plugin tool forward
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> STEP in [function init]: load plugin tool vacation
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> STEP in [function init]: load plugin tool purge
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> STEP in [function init]: load plugin tool preview
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> STEP in [function init]: load plugin tool attachments
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> STEP in [function init]: create toolbox tab in the list of settings
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> STEP in [function init]: register actions
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> STEP in [function init]: load calendar script
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> STEP in [function init_html]: prepare html output for action edit
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> STEP in [function init_html]: load jquery plugin
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> STEP in [function init_html]: initialise html editor
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> STEP in [function init]: set calendar date format
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> STEP in [function init_html]: selected tool: attachments
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> STEP in [function init_html]: render template for action plugin.toolbox.edit
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> STEP in [function tool_section_name]: generate section title
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> STEP in [function tool_render_form]: selected tool: attachments
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> STEP in [function tool_render_form]: initialise storage for tool attachments
[06-Jun-2021 15:03:38 +0530]: <ls57ne6l> STEP in [function tool_render_form]: prepare form for tool attachments
gianlucagiacometti commented 3 years ago

[06-Jun-2021 15:03:38 +0530]: ERROR in [storage].[sql].[function is_domain_admin]: cannot read domain admins from database: [1146] Table 'aloktools.domain_admins' doesn't exist

This is the mistake. Indeed it is looking for a postfixadmin table for domain admins.

If you are not using postfixadmin, you should put in the config file: $config[toolbox_use_postfixadmin_domain_admins] = false; Instead of the default 'true'

Try and let me know

aloksinha3110 commented 3 years ago 
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> STEP in [function init]: initialise plugin
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> STEP in [function init]: load user's preferences
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> STEP in [function init]: 'preview' tool active and loaded
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> STEP in [function init]: skin: elastic
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> STEP in [function init]: load customised skin configuration from config
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> STEP in [function init]: load customised skin configuration from database
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> STEP in [storage].[sql].[function load_customised_config]: connecting to roundcube database in read mode
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> SQL in [storage].[sql].[function load_customised_config]: execute query [SELECT domain_name`, `skin`, `customise_blankpage`, `blankpage_type`, `blankpage_image` `blankpage_url`, `blankpage_custom`, `customise_css`, `additional_css`, `customise_logo`, `customised_logo` FROM `toolbox_customise_skins_view` WHERE `domain_name` = '' AND `skin` = 'elastic';]
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> SQL in [storage].[sql].[function load_customised_config]: 0 rows matching
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> STEP in [function init]: 'customise blank page' database option selected: override config
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> STEP in [function init]: customised blank page type: Roundcube default
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> STEP in [function init]: 'customise additional css' database option not selected: loading from config
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> STEP in [function init]: customised additional css file not found, empty or not defined
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> STEP in [function init]: 'customise logo' database option not selected: loading from config
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> STEP in [function init]: 'attachments' tool active and loaded
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> STEP in [function init]: initialise storage to check if domain admin (blank section)
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> STEP in [function init]: load plugin tool aliases
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> STEP in [function init]: load plugin tool forward
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> STEP in [function init]: load plugin tool vacation
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> STEP in [function init]: load plugin tool purge
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> STEP in [function init]: load plugin tool preview
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> STEP in [function init]: load plugin tool attachments
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> STEP in [function init]: create toolbox tab in the list of settings
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> STEP in [function init]: register actions
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> STEP in [function init]: load calendar script
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> STEP in [function init_html]: prepare html output for action edit
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> STEP in [function init_html]: load jquery plugin
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> STEP in [function init_html]: initialise html editor
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> STEP in [function init]: set calendar date format
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> STEP in [function init_html]: selected tool: forward
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> STEP in [function init_html]: render template for action plugin.toolbox.edit
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> STEP in [function tool_section_name]: generate section title
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> STEP in [function tool_render_form]: selected tool: forward
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> STEP in [function tool_render_form]: initialise storage for tool forward
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> STEP in [function tool_render_form]: prepare form for tool forward
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> STEP in [storage].[sql].[function load_tool_data]: enter forward section
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> STEP in [storage].[sql].[function load_tool_data]: connecting to postfix database in read mode
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> SQL in [storage].[sql].[function load_tool_data]: execute query [SELECT `address`, `goto` FROM `alias` WHERE `address` = 'alok@abc.in';]
[06-Jun-2021 16:35:45 +0530]: <ubkr6hli> ERROR in [storage].[sql].[function load_tool_data]: cannot read alias from database: [1146] Table 'aloktools.alias' doesn't exist
aloksinha3110 commented 3 years ago

[06-Jun-2021 16:38:23 +0530]: <ubkr6hli> ERROR in [storage].[sql].[function load_tool_data]: cannot read vacation from database: [1146] Table 'aloktools.vacation' doesn't exist

gianlucagiacometti commented 3 years ago

As I said, to use Aliases, Vacation and forward you should use postfix with mysql backend with tables as in postfixadmin. If you don't have such a configuration you cannot use those three tools and you must deactivate them in the config.

If you just need forward with rules you should use managesieve plugin shipped with roundcube, which anyway needs a sieve configuration in the server (with dovecot or similar software).

On 6 June 2021 13:09:40 Alok @.***> wrote:

[06-Jun-2021 16:38:23 +0530]: ERROR in [storage].[sql].[function load_tool_data]: cannot read vacation from database: [1146] Table 'aloktools.vacation' doesn't exist — You are receiving this because you commented. Reply to this email directly, view it on GitHub, or unsubscribe.