In my logs im constantly getting this error which i believe is the cause. It states a Database issue, i check my passwords in my files via SSH, They seem to match. Any Ideas? Any clue as to what all files need to be examined/edited? I currently have GUI access, and do not want that to change. The last time someone edited files, it locked me out of the GUI. what a nightmare.
Anyway thanks guys in advance! This forum rocks!
ERROR[5285] cdr_mysql.c: Cannot connect to database server localhost: (1045) Access denied for user 'admin'@'localhost' (using password: YES)
I Checked 3 Files Through SSH (I Used Bitvise SSH Client and the FTP module with it) to download and edit the files in my code editor. I found that the User & Password did not match on all 3.
DO NOT COPY THESE AND PASTE, THESE ARE NOT THE COMPLETE FILES. REFERENCE ONLY!
freepbx.conf
<?php
$amp_conf[‘AMPDBUSER’] = ‘user’;
$amp_conf[‘AMPDBPASS’] = ‘password’;
$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’);
cdr_mysql.conf
[global]
hostname = localhost
dbname=asteriskcdrdb
password = password
user = user
userfield=1
;port=3306
;sock=/tmp/mysql.sock
amportal.conf
# — CATEGORY: Bootstrapped or Legacy Settings —
AMPDBUSER=user
AMPDBPASS=password
AMPDBHOST=localhost
AMPDBNAME=asterisk
AMPDBENGINE=mysql
datasource=
AMPENABLEDEVELDEBUG=
Hope this helps, Just make sure your User and Pass match up on all 3 and it should restore your database connection in the case of a changed value. Or Disconnected Database. Thanks