I’ve install asertisk 11 on ubuntu 14.04, install additional components and tried to install freepbx 11, but installation script gave me en error that it doesn’t found databases( Can you help me, please
nikita@nikita-notebook:/usr/src/freepbx$ sudo ./install_amp
[sudo] password for nikita:
Checking for PEAR DB..OK
Checking for PEAR Console::Getopt..OK
Checking user..OK
Checking if Asterisk is running..running with PID: 1428..OK
Checking for /etc/amportal.conf..OK
Reading /etc/amportal.conf..parsed amp_conf variables from /etc/amportal.conf:
amp_conf [AMPDBHOST] => [localhost]
amp_conf [AMPDBENGINE] => [mysql]
amp_conf [AMPENGINE] => [asterisk]
amp_conf [AMPMGRUSER] => [admin]
amp_conf [AMPMGRPASS] => [amp111]
amp_conf [AMPBIN] => [/var/lib/asterisk/bin]
amp_conf [AMPSBIN] => [/usr/local/sbin]
amp_conf [AMPWEBROOT] => [/var/www/html]
amp_conf [AMPCGIBIN] => [/var/www/cgi-bin ]
amp_conf [FOPWEBROOT] => [/var/www/html/panel]
amp_conf [FOPPASSWORD] => [passw0rd]
amp_conf [AUTHTYPE] => [database]
amp_conf [AMPEXTENSIONS] => [extensions]
amp_conf [AMPDBNAME] => [asterisk]
OK
Database settings were blank. Try again
diffrence with mine is Debian 8 using freepbx 12 asterisk 1.8 here and got same error!
any luck beyond that?
I can mysql -uroot and use the asterisk database and see clearly the database has tables in it… maybe I am not create the database tables first I will drop and try again let you all know.
I created with the two sql files in the SQL dir
:/usr/src/freepbx/SQL# ls
cdr_mysql_table.sql newinstall.sql
mysql -uroot -p asterisk < SQL/newinstall.sql
mysql -uroot -p asteriskcdrdb < SQL/cdr_mysql_table.sql
nope… just did it now I droped the databases and recreated them and gave access to them to asteriskuser and with out newinstall sql or othere files it still again it give s same error
-ppassword ( not -p password) and -u user ( not -uuser)
you are safer using the
mysql --password=password --user=user
syntax, but to save confusion you should probably disable the password for root as you install FreePBX (go figure ) or fight that as you do the ./install_amp (./install_amp --help for clarification) bit because it can get confused (just enable it later for security)
It works with -uroot my synax works. What I posted works fine how it is typed you should be able to copy and paste it and it will function as Necessary. This does not help in any way?
You are no help
Are you able to comment on the “Database settings were blank. Try again” error ?? if not or if I have spelt something wrong and it effects something let me know. i really and looking for a answer to this the “Database settings were blank. Try again” error and I can not be alone I am am sure of that?
i would use a older version but 12 seems to be available and thats it. or I have the option of 13 beta yah not going there.
No , I have nothing else to offer, you obviously know what you are doing. because you have RTFM (man mysql) and understand:-
· --password[=password], -p[password]
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. If you omit the password value following the --password or -p option
on the command line, mysql prompts for one.
does anyone else want to correct me with meaningless syntax that does not effect the result or does anyone come across this and have a answer?
“Database settings were blank. Try again” error ??
mysql> use asterisk;
Database changed
mysql> show tables;
Empty set (0.00 sec)
mysql> exit;
Bye
cd /usr/src/freepbx
/usr/src/freepbx# mysql -uroot -p asterisk < SQL/newinstall.sql
/usr/src/freepbx# mysql -uroot -p asteriskcdrdb < SQL/cdr_mysql_table.sql
mysql> use asterisk;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
mysql -uroot -p
mysql> use asterisk;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
STARTING ASTERISK
Asterisk is already running
:/usr/src/freepbx# ./install_amp
Checking for PEAR DB…OK
Checking for PEAR Console::Getopt…OK
Checking user…OK
Checking if Asterisk is running…running with PID: 1118…OK
Checking for /etc/amportal.conf…OK
Reading /etc/amportal.conf…parsed amp_conf variables from /etc/amportal.conf:
amp_conf [AMPDBHOST] => [localhost]
amp_conf [AMPDBENGINE] => [mysql]
amp_conf [AMPENGINE] => [asterisk]
amp_conf [AMPMGRUSER] => []
amp_conf [AMPMGRPASS] => []
amp_conf [AMPBIN] => [/var/lib/asterisk/bin]
amp_conf [AMPSBIN] => [/usr/local/sbin]
amp_conf [AMPWEBROOT] => [/var/www/html]
amp_conf [AMPCGIBIN] => [/var/www/cgi-bin ]
amp_conf [FOPWEBROOT] => [/var/www/html/panel]
amp_conf [FOPPASSWORD] => [**********]
amp_conf [AUTHTYPE] => [database]
amp_conf [AMPEXTENSIONS] => [extensions]
amp_conf [AMPDBNAME] => [asterisk]
OK
Database settings were blank. Try again
Anyone ?
seems to be just normal msgs in the var/log/mysql nothing stands out. i guess I will have to dig through the code for the error and see what triggers it.
) or fight that as you do the ./install_amp (./install_amp --help for clarification) bit because it can get confused (just enable it later for security)