Page 1 of 1

Install port problem

Posted: Mon Sep 16, 2024 9:23 am
by jsolisar
Script URL: http://10.203.15.2/Helpdesk/install/install.php
Version of script: 3.4.6
Hosting company: non applicable
URL of phpinfo.php: non applicable
URL of session_test.php: non applicable
What terms did you try when SEARCHING for a solution:
port, install port, install sql port
Write your message below:
I'm trying to install a new Hesk instance and, for reasons, I cannot use the port 3306 because is already being used by another MySQL instance to which I don't have access to.

My instance is on port 3308 and is up and running with some other services working there.

The thing is, it fails to install because:
MySQL said: Access denied for user 'hesk'@'%' to database 'hesk'

And I believe that is because is connecting to the MySQL on port 3306 not on 3308. I have tried both 10.203.15.2:3308 and localhost:3308 but I still get the same message.

Is there any way to tell Hesk to go to the 3308 MySQL instance?

Thanks.

Re: Install port problem

Posted: Tue Sep 17, 2024 8:56 am
by Klemen
The "Access denied" message means that the connection was successful, but MySQL denied the user (or password).

Double-check the username and password and make sure the user has permission to access the database (GRANT privileges).

Re: Install port problem

Posted: Wed Sep 18, 2024 4:53 am
by jsolisar
I understand that, that's because there is a MySQL server on 3306 without the Hesk user.

The server I need to use which has the hesk user and is ready, is on the 3308 port, but I see no way of changing the port during installation.

I have no way or control over the server using the 3306 port

Re: Install port problem

Posted: Wed Sep 18, 2024 12:47 pm
by Klemen
Hesk will detect the "hostname:port" format and use the specified port, so localhost:3308 is indeed the correct format to use in the MySQL host field. If you used localhost:3308, Hesk will use the 3308 port.

You can double-check this by temporarily disabling port 3306 and trying to use localhost:3308 - the connection should still work (with the "Access denied" message if the user is not set up properly).