How to use the mysql users with external access?

Discussion in 'Installation/Configuration' started by Frankenstein, Sep 29, 2018.

  1. Frankenstein

    Frankenstein Member

    Good morning in the morning,

    actually i try to install osTicket as HelpDesk and Ticket System to my created Domain support.domain.tld.

    I've created a database user with a database and tried on the osTicket installation to use it. But "localhost" failed cauz there is no user with this informations - right - but db.domain.tld (multi server) should work?

    So i tried to connect with host to db.domain.tld but its throw the error " Unable to connect to MySQL server: Access denied for user 'c1osticket'@'control.techgods.biz' (using password: YES)"

    Did i forgot anything to configure?

    Best regards
    Frankenstein

    //edit
    On db.domain.tld there is the user "c1osticket" with the host "127.0.1.1" and also the database "c1osticket". I dont understand why it isnt working...
     
    Last edited: Sep 29, 2018
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Basically, you do an external access and not an access through localhost in that case. Did you select the correct corresponding website in the database settings= This should enable access from the IP of the web server. You should see then a second MySQL user on the db server for the IP address or hostname of the web server.
     
  3. Frankenstein

    Frankenstein Member

    Yes - created database user and database over control.domain.tld to db.domain.tld and selected the support.domain.tld as website for this database.

    on db.domain.tld he created the following users
    [email protected]
    [email protected]

    on control.dimain.tld there is no c1osticket - just all the root to the hostnames and ip addresses created in setup and ispcsrv1/2/3/4/5 with 127.0.1.1 and each also with each hostname.
     
    Last edited: Sep 29, 2018
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    There should be another [email protected] added on the db server with the hostname and IP of the web server that hosts the site. Try adding the IP address of the web server (control.dimain.tld ?) in the remote access IP field of the database and enable remote access. Then wait until the changes are written to DB server and check on DB server if you have a mysql c1osticket user then for the IP of the web hosting server.
     
  5. Frankenstein

    Frankenstein Member

    #solved

    did any customer need to do this when he creates a database/user? (for our help desk)
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    Normally, the external IP should be added automatically by ispconfig as when website and DB are not on the same server. Not sure why this did not happen in your case.
     
  7. Frankenstein

    Frankenstein Member

  8. till

    till Super Moderator Staff Member ISPConfig Developer

    A remote user is an ISPConfig API user, this exists on the control panel server only, see System Remote Users in ISPConfig interface.
     
    Frankenstein likes this.

Share This Page