DB user script

Discussion in 'Installation/Configuration' started by quartist, Aug 7, 2018.

  1. quartist

    quartist New Member

    Hi,
    Where I find template of creation db user?
    I need to change a remote IP value. Now clients are created with value:
    allow connection from: AAA.BBB.CCC.DDD (in most cases - www server)
    I need to modify this to:
    allow connection from: AAA.BBB.CCC.*

    How to do this?
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    There is no template for this, you'll have to change the code if you want to allow whole subnets.
     
  3. quartist

    quartist New Member

    Not so good. How and where change this in code?
    After update ISPConfig, I lost my changes in code?
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Changes that you do in the code will get lost on update. Or you write a custom ispconfig plugin which binds to the mysql user insert / update / delete events to add another mysql user instead of changing the one that get's added by ispconfig. Serverside plugins can be found in /usr/local/ispconfig/server/plugins-available/
     
  5. florian030

    florian030 Well-Known Member HowtoForge Supporter

    you can allow mysql-remote-access in general and restrict the access with your firewall and allow AAA.BBB.CCC.* only
     

Share This Page