Hotel Module Mysql problem

I moved recently a server under my supervision from PIAF distro to FREEPBX distro 5.211.65.

I tried to install and run the basic hotel management module that took a brief to install in PIAF and got an “Acces denied” from MySQL/

The hotel module was installed as such:

cd /var/www/html
wget http://piafhms.googlecode.com/files/hotel.tar.gz
tar zxvf hotel.tar.gz
cd hotel

That last step was
./loadmysql.sh

and than I got the following message:
ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES)

mysql -u root -p

Shows no password. Should I set password to user root in MySQL? or should I do something else tp complete the installation?

Look in /etc/freepbx.conf for the correct settings for your mysql server.

Thx for your prompt response

What should I do with it?

<?php $amp_conf['AMPDBUSER'] = 'freepbxuser'; $amp_conf['AMPDBPASS'] = 'LjmpjD5qcbE3'; $amp_conf['AMPDBHOST'] = 'localhost'; $amp_conf['AMPDBNAME'] = 'asterisk'; $amp_conf['AMPDBENGINE'] = 'mysql'; $amp_conf['datasource'] = ''; //for sqlite3 require_once('/var/www/html/admin/bootstrap.php');

#!/bin/bash
mysql -uroot -ppassw0rd < Hotel.sql

I tried to change it to the db user/pass in freepbx.conf - to no avail.

Should I change mySQL root passord to passw0rd to match it?

Locate the file:
/var/www/html/hotel/config.inc.php

and edit to match the MySQL credentials (dbuser and dbpass) for your system. Note that this project has remained basically unchanged for years, so YMMV with integrating into a newer FreePBX environment.

Did you grab the latest from github? It looks like an update for 2.11 was posted in January. Here is the thread over at the house of Mundy:

http://pbxinaflash.com/community/index.php?threads/piaf-hospitality-management-system.4992/page-5

Personally I don’y like shared SQL credentials and my personal choice would be to create a new SQL user and grant access to the DB’s that the module needs.