Upgrading from 2.5.3 to 2.6.2 - can't connect to dataase

[mauripop]

Script URL: http://synergyhelpdesk.net/gtel/install
Version of script: 2.6.2
Hosting company: private server
URL of phpinfo.php: http://synergyhelpdesk.net/gtel/phpinfo.php
URL of session_test.php: http://synergyhelpdesk.net/gtel/session_test.php
What terms did you try when SEARCHING for a solution:
hesk (1045) access denied for user
Write your message below:

I was upgrading to the latest version like I've done several times before, except now the installation script cannot connect to the mysql dataase.

The database section on hesk_settings.inc.php is:

// --> Database settings
$hesk_settings['db_host']='localhost:3307';
$hesk_settings['db_name']='hesk';
$hesk_settings['db_user']='root';
$hesk_settings['db_pass']='*****';
$hesk_settings['db_pfix']='heskgtel_';
$hesk_settings['db_vrsn']=1;

The install script gives me this error:

Mysql (1045) access denied for user root

I verified the database and was able to connect with same port, user name and password.

The only special thing about my connection settings is I am not using the standard mysql port (3306) but instead port 3307. This has worked in the past, just on this update it's not working.

Help?

[Klemen]

It's an error MySQL gives so HESK did connect to MySQL, but then MySQL gave the "access denied for user root" error.

If it works over MySQL CLI then you probably need to grant user root access from localhost (or localhost:3307)?

[mauripop]

User root already has access to this database, it always has.
I have 3 other Hesk help desks running under this same database, just on version 2.5.3
I tried to upgrade one of them to version 2.6.2 and then this happened.

All the help desks on version 2.5.3 are still connecting using the same database parameters, did something change on 2.6.2 that is causing this?

I do think the localhost:3307 port issue is what is causing this on 2.6.2

[Klemen]

You know what, this indeed seems to be a bug.

Could you please try uploading these files over your HESK 2.6.2 and see if you can run the update successfully then?
http://www.hesk.com/extras/hesk_mysqli_port.zip

(note these are just few files, not entire 2.6.2, so upload 2.6.2 first then these modified files over)

[mauripop]

Yes!

That patch did the trick. I am now able to install a new help desk or upgrade existing ones successfully.

Thanks!

[curiosus]

I am currently on 2.5.2-p5, before I upgrade I was wondering if I also need this patch?

[Klemen]

This is only needed if you run MySQL on a non-standard port (other than 3306).