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...
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.
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] c1osticket@localhost 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.
There should be another c1osticket@ 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.
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.
One more question about remote control - Actually hanging on this tutorial @ creating remote user: https://www.howtoforge.com/tutorial/roundcube-installation-on-debian-8-jessie/ Where did he need remote access? To the control, db, mail?
A remote user is an ISPConfig API user, this exists on the control panel server only, see System Remote Users in ISPConfig interface.
