Can't create database users nor databases

Discussion in 'Installation/Configuration' started by neoartur35, Jan 13, 2025 at 12:49 PM.

  1. neoartur35

    neoartur35 New Member

    When logged in as a client and trying to create database user I get error:
    The max. number of database users is reached.

    Also, when creating database and clicking 'save' I get empty error container with no message inside. Seems like it's related to no user.

    How can I resolve this? My ISPconfig installation was done with root mysql user and in config files it's configured correctly.
     
    neoartur35, Jan 13, 2025 at 12:49 PM
    #1
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    The error message indicates that you have set a limit on database users or databases in the client limits which is too low. Set a higher limit in client limits in ISPConfig.
     
    till, Jan 13, 2025 at 12:52 PM
    #2
  3. neoartur35

    neoartur35 New Member

    Okay it worked. I've create new limits template at clients page. Just a little bit strange that default limits allow creation of FTP, SSH users but not MySQL databases. What's the reason behind such decision?
     
    neoartur35, Jan 13, 2025 at 1:05 PM
    #3
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    The default is unlimited mysql users and unlimited databases when you create a new client. Newly created client:

    2025-01-13 13_08_58-ISPConfig.png
     
    till, Jan 13, 2025 at 1:10 PM
    #4
  5. neoartur35

    neoartur35 New Member

    My users are created with FOSSbilling, so maybe that's the issue?
     
    neoartur35, Jan 13, 2025 at 1:13 PM
    #5
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    That#s probably the case, as no such issue exists in ISPConfig. When you use an external application to create users, then this external application also controls the limits.
     
    till, Jan 13, 2025 at 1:15 PM
    #6

Share This Page