Posts by vafecitos

    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.

    thanks for thr answer, im need the pluging ownDDNS work in the lastest version of i-mscp, I am not a developer to repair this plugin, so I asked the cost of performing that task.


    It is simple, I need a dynamic DNS service for i-MSCP


    Thanks for all