Posts by vafecitos

    First of all, thank you for taking the time to read. I am experiencing some problems wanting to add a subdomain to a domain, the panel is left with the legend "Creation in progress ...", but it does not come from there, from the console and the database I see the following:


    Any help I will be very grateful

    The solution remove the phpswitcher record in the plugins table along with the php_switcher_version and php_switcher_version_admin tables and reinstall the plugin


    Thank you all for the answers.

    Thanks for your answer, my config.php is:


    Without having requested any action in the plugin manager today I found the following error. to force retry always follows the same error.


    Any help you can give me is appreciated.


    Code
    1. Modules::Plugin::_executePluginAction: An unexpected error occurred: Missing or undefined `php_fpm_log_file_pattern' plugin configuration parameter at /var/www/imscp/gui/plugins/PhpSwitcher/backend/PhpSwitcher.pm line 795.


    pasted-from-clipboard.png

    Before executing the installation process I run these commands so that the user has the permissions from the host that connects

    Code
    1. GRANT ALL PRIVILEGES ON * . * TO 'imscp_srv_user'@'172.28.201.29' WITH GRANT OPTION;
    2. GRANT ALL PRIVILEGES ON * . * TO 'imscp_user'@'172.28.201.29' WITH GRANT OPTION;
    3. GRANT ALL PRIVILEGES ON * . * TO 'imscp_srv_user'@'%' WITH GRANT OPTION;
    4. GRANT ALL PRIVILEGES ON * . * TO 'imscp_user'@'%' WITH GRANT OPTION;


    Then in the server log (binlogs) I see that the installation process executes these grants:


    Code
    1. GRANT USAGE ON mysql.* TO 'imscp_srv_user'@'localhost'
    2. GRANT SELECT ON mysql.db TO 'imscp_srv_user'@'localhost'
    3. TO 'imscp_srv_user'@'localhost'
    4. GRANT SELECT ON mysql.user TO 'imscp_srv_user'@'localhost'
    5. GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv) ON mysql.tables_priv TO'imscp_srv_user'@'localhost'
    6. GRANT ALL PRIVILEGES ON `imscp\_pma`.* TO 'imscp_srv_user'@'localhost'

    Thanks por answer


    maxscale log:

    2019-03-12 23:41:11 error : (260) Invalid authentication message from backend 'master1'. Error code: 1045, Msg : #28000Access denied for user 'imscp_srv_user'@'172.28.250.20' (using password: YES)

    2019-03-12 23:41:11 error : Unable to write to backend 'master1' due to authentication failure. Server in state RUNNING MASTER.


    IMSCP Message maxscale remote :

    Code
    1. [ERROR] Error while performing step: Executing Servers::sqld preinstall tasks... Error was: iMSCP::Stepper::_callback: Couldn't drop the imscp_user@localhost SQL user: DBD::mysql::db do failed: Operation DROP USER failed for 'imscp_user'@'localhost' at /var/www/imscp/engine/setup/../PerlLib/Servers/sqld/mysql.pm line 248. Please have a look at http://i-mscp.net/forum if you need help.

    thanks for answering


    I am trying to make load balancing between the master and the slave since I have databases that are very large and when the backup runs blocks writes, that is affecting my clients.


    my idea is that the select be executed in the slave and that's why I decided to try to put maxscale


    Try these two ways, but the problem appears when the installation process attempts to configure user permissions on the database engine


    imscp.png


    Maxscale config:


    Dear, is it possible to use maxscale as a load balancer? between a master / slave in imscp?


    I consult them because I try to do it, but I can not configure it because it tries to modify all the time the ips from where the users that the panel uses can connect and ends up producing an error in the installation.

    It also conflicts with the forced installation of mysql locally.


    Any suggestions on how this could be done ?.


    Thank you very much to all.

    Dear, sorry to bother again but I'm experiencing a small problem when using the Lets Encrypt plugin when it is done by a client, not when I do it from administrator and then change to client mode.


    Attached the error mail that came from the panel.


    Thank you so much for everything.


    -------------------
    This is an automatic email sent by your i-MSCP control panel:



    Server name: XXXXXXX
    Server IP: XXXXXXXXX
    Client IP: XXXXXXX
    Version: 1.5.1
    Build: 20170908
    Severity: Error



    ==========================================================================
    [XXXXXXXX] Could not write in
    /var/www/imscp/gui/data/tmp/28-openssl.cnfefZCXk openssl temporary
    configuration file.
    ==========================================================================


    Please do not reply to this email.