when installing first time hesk database is not created

[alfonsSF]

Script URL: /var/www/html/hesk/install/install.php
Version of script: 3.1.2
Hosting company: Local
URL of phpinfo.php: /var/www/html/php.info
URL of session_test.php: /var/www/html/session_test.php passed Ok
What terms did you try when SEARCHING for a solution: install database hesk

Write your message below:
I try to install Hesk for my first time.
I put the zip file in /var/www/html/hesk and descompress it
chmod 666 hesk_settings.inc.php
chmod 777 atachments
chmod 777 cache
ok

Navigate with the browser to serverIP/hesk/install/install.php and run it
At database settings,

Code: Select all

Database Host:	localhost
Database Name: hesk
Database User (login): root  
User Password:	**********
Table prefix: hesk_

HESK login details
Username and password you will use to login into HESK administration.

Choose a Username:	Administrator
Choose a Password:	**********

And get :

Code: Select all

Database connection failed:
Double-check all the information below. Contact your hosting company for the correct information to use!
MySQL said: Unknown database 'hesk'

In MySql there is no dabase called hesk,
So, how must the database be created?

Sorry for eventual mitakes in english, I am catalan

Thanks in advanced

[alfonsSF]

Edition:

After a change: serverip insteat of "localhost" the error is

MySQL said: Connection refused

Fot testing, the userhas superadmin role

[Klemen]

You need to create the database in your MySQL.

Login to MySQL via CLI and

Code: Select all

CREATE DATABASE hesk;

Here are some helpful tutorials to get you started with MySQL (teaching it is outside of the scope of my support):
https://www.digitalocean.com/community/ ... l-tutorial
https://www.digitalocean.com/community/ ... s-in-mysql

[thedigitaltinker]

New user. Installing Hesk on my own Ubuntu Server 22.04 Virtual Machine on my own hardware under Windows Server 2016 hyper-V. All required components going to run within the Ubuntu VM, mySQL and all.
(Done something similar before installing wordpress or OTRS on to Ubuntu servers).

Therefore I need to create my own database.

Very grateful for this post explicitly telling me that the script does not create its own mySQL user and requires a bit of mySQL work beforehand. Instructions assume all hosting done online by a hosting company, when not always the case -- is it even the most common scenario?!

Wish instructions were clearer. Wish I didn't have to dig in to this post to find the answer to the question.

Following instructions on Digital Ocean doesn't tell me requirements specific to Hesk for the mySQL database -- character encoding?

I feel that Hesk just telling us 'connect it to a working mySQL server' not clear enough guidance.

[Klemen]

Installing and configuring MySQL is beyond the scope of our support.

There is a huge amount of different servers and configurations available online, it is impossible for us to cover all the scenarios. If you run your own server, you should have the expertise to create and set up a MySQL database, otherwise you may want to outsource that to someone else.

For security reasons, most hosting companies do not provide a way to create MySQL users and databases via a PHP script; their control panel must be used (just like you also cannot create an email account from within Hesk, for example). You then enter those MySQL details into Hesk.

Hesk will automatically set the correct character base when connecting to the database, no need to worry about that.