[HH#330752] Database not linking to Unity

[HelioHost]

Username: jopat0130, Server: Johnny, Main domain: dementia.helioho.st

Hi there, I am an A level computer science student and I'm utilising
heliohost to store information online in a database for my project. Through
Unity I am trying to write code to allow me to click a button and it will
open my Heliohost database. My teacher and myself have both written code to
try and get it to connect but it doesn't seem to work. The code has no
errors but it just won't work. I am wondering if this is because I do not
have certain permissions or if the security system in Heliohost will not
let me do this and how I can bypass this.

Thank you!
Joanne Patterson

[KazVee]

Hi Joanne! You haven't mentioned which type of database you're using. If you're using MariaDB, remote access is something you would be able to enable yourself when creating the database inside Plesk. 

If you're using PostgreSQL, Plesk (like most control panels) doesn't have great support for Postgres, and remote access to the DB is not enabled by default. You would need to request remote access, and an admin can set it up for you.We have more details on PostgreSQL connection errors here: https://wiki.helionet.org/common-errors/postgres-remote-connection-error 

To request remote access to PostgreSQL, please provide:
1) your database name and
2) the database user name you want to have remote access.

It's unusual to not get any error messages on a failed connection attempt. You may also want to check your Plesk error logs, as these may offer more information about what is going wrong: https://wiki.helionet.org/tutorials/plesk/view-error-logs 

[jopat0130]

I am using MariaDB and "remote access from any host" is enabled. I'm not sure what the issue is.

[wolstech]

The settings below are what you should use. Maybe try accessing it with a tool like HeidiSQL and confirm your PC can access the database remotely? 

Hostname: johnny.heliohost.org

Database name: jopat0130_dementia

Database username: jopat0130_database

Password: <set in plesk>

[jopat0130]

I downloaded HeidiSQL and I can now confirm my PC can access the database remotely. 

[wolstech]

If that's working, it's a problem with unity. The connection on our side is the same for everything, so if it's working, it's working.
 

You'll need to figure out why unity is unable to talk to it. We're not familiar with configuring unity, so don't really have any advice to give on this. I would simply check to make sure you're using the right database type (should be mysql/MariaDB) and that the settings are correct...