DB Error: not found

Hi,

I finally installed freepbx and have few problems.

FATAL ERROR
DB Error: not found
Trace Back
/Shares/INTERNET/HTTP/PUBLIC/FreePBX/admin/libraries/db_connect.php:63 die_freepbx()
[0]: DB Error: not found

/Shares/INTERNET/HTTP/PUBLIC/FreePBX/admin/bootstrap.php:98 require_once()
[0]: /Shares/INTERNET/HTTP/PUBLIC/FreePBX/admin/libraries/db_connect.php

/etc/freepbx.conf:9 require_once()
[0]: /Shares/INTERNET/HTTP/PUBLIC/FreePBX/admin/bootstrap.php

/Shares/INTERNET/HTTP/PUBLIC/FreePBX/admin/config.php:109 include_once()
[0]: /etc/freepbx.conf

And my /etc/freepbx.conf is :

<?php $amp_conf['AMPDBUSER'] = 'asteriskuser'; $amp_conf['AMPDBPASS'] = 'amp109'; $amp_conf['AMPDBHOST'] = 'localhost'; $amp_conf['AMPDBNAME'] = 'asterisk'; $amp_conf['AMPDBENGINE'] = 'mysql'; $amp_conf['datasource'] = ''; //for sqlite3 require_once('/Shares/INTERNET/HTTP/PUBLIC/FreePBX/admin/bootstrap.php'); And when i tried this : mysql -u asteriskuser -p asterisk Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 56 Server version: 5.5.31-0+wheezy1 (Debian) Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> Someone have an idea ?

mysql -u asteriskuser -p asterisk

does not agree with

$amp_conf[‘AMPDBUSER’] = ‘asteriskuser’;
$amp_conf[‘AMPDBPASS’] = ‘amp109’;

you need to fix one or the other.

Dicko, if you read my post you can see that :

mysql -u asteriskuser -p asterisk
Enter password:

And i can enter my password, amp109, after “Enter password:”.

asterisk is database name and i can connect on this database with “mysql -u asteriskuser -p asterisk” but not with freepbx … That is my problem …

I did read your post, freepbx thinks the asterkskuser password is amp109

and my command line do the same things … because mysql -u username -p db OR mysql -u username -ppassword db … With password amp109 when prompt ask to me for the first command and amp109 instead of “password” without space :slight_smile:

http://www.manpagez.com/man/1/mysql/
“The password to use when connecting to the server. If you use the
short option form (-p), you cannot have a space between the option
and the password.”

the confusion is you are unnecessarily using the -p option mysql will ask for it if it not used

mysql -u asteriskuser -pamp109 -D asterisk

should work.

mysql -u asteriskuser

and interactively supply the password, then use the asterisk database

mysql -u asteriskuser astsdisk

Yes off course for the first line :
mysql -u asteriskuser -pamp109 -D asterisk

But for your second line nooooooooooo :
mysql -u asteriskuser
ERROR 1045 (28000): Access denied for user ‘asteriskuser’@‘localhost’ (using password: NO)

And the question stay same that on my first post :

FATAL ERROR
DB Error: not found
Trace Back
/Shares/INTERNET/HTTP/PUBLIC/FreePBX/admin/libraries/db_connect.php:63 die_freepbx()
[0]: DB Error: not found

/Shares/INTERNET/HTTP/PUBLIC/FreePBX/admin/bootstrap.php:98 require_once()
[0]: /Shares/INTERNET/HTTP/PUBLIC/FreePBX/admin/libraries/db_connect.php

/etc/freepbx.conf:9 require_once()
[0]: /Shares/INTERNET/HTTP/PUBLIC/FreePBX/admin/bootstrap.php

/Shares/INTERNET/HTTP/PUBLIC/FreePBX/admin/config.php:109 include_once()
[0]: /etc/freepbx.conf

Problem solved, i forgot to install this paquet : php5-curl php-db
… sorry and thanks