retrieve_conf failure

FreePBX Installation / Upgrade
1

Hi,

I am trying to install FreePBX on my Debian Lenny installation with Asterisk 1.6
Unfortunately I don’t have all the modules running.
When I made a search I found that my retrieve_conf script is failing as in below output.

How can I solve this issue ?

Thanks

/var/lib/asterisk/bin/retrieve_conf

Checking for PEAR DB…OK
Checking for PEAR Console::Getopt…OK
Checking for /etc/amportal.conf …OK
Bootstrapping /etc/amportal.conf …OK
Parsing /etc/amportal.conf …OK
Parsing /etc/asterisk/asterisk.conf …OK
Connecting to database…OK
Connecting to Asterisk manager interface…OK
Added to globals: ASTETCDIR = /etc/asterisk
Added to globals: ASTMODDIR = /usr/lib/asterisk/modules
Added to globals: ASTVARLIBDIR = /var/lib/asterisk
Added to globals: ASTAGIDIR = /var/lib/asterisk/agi-bin
Added to globals: ASTSPOOLDIR = /var/spool/asterisk
Added to globals: ASTRUNDIR = /var/run/asterisk
Added to globals: ASTLOGDIR = /var/log/asterisk
Added to globals: CWINUSEBUSY = true
Added to globals: AMPMGRUSER = admin
Added to globals: AMPMGRPASS = amp111
Use of uninitialized value in string eq at /var/lib/asterisk/bin/retrieve_op_conf_from_mysql.pl line 415.
DB Error: no such table

2

Looks like db connections problem.

Check if you can connect to asterisk* databases with user/pass supplied in /etc/amportal.conf (AMPDBUSER, AMPDBPASS)

3

router:~# grep AMPDBUSER /etc/amportal.conf
AMPDBUSER=asteriskuser

router:~# grep AMPDBPASS /etc/amportal.conf
AMPDBPASS=amp109

router:~# mysql -uasteriskuser asterisk -pamp109
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 73
Server version: 5.0.51a-5 (Debian)

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.

mysql> use asterisk;
Database changed
mysql>

so it seems fine, no ?

4

this should be something easy. but what ?

5

yep, seems ok.
Actually it’s indicated above - Connecting to database…OK

You can make sure all tables in asterisk and asteriskcdrdb were imported properly (show_tables;)
Other than that it maybe something in Asterisk 1.6 as I’m using 1.4 and have this uninitialized variable errors

(Use of uninitialized value in concatenation (.) or string at /var/lib/asterisk/bin/retrieve_op_conf_from_mysql.pl line 383.
Use of uninitialized value in string eq at /var/lib/asterisk/bin/retrieve_op_conf_from_mysql.pl line 415.)

as well but FreePBX works

6

ok,…
Looks like I have the same error when running retrieve_conf.
And there was someone else complaining about this issue: http://www.freepbx.org/forum/freepbx/users/critical-error-cannot-write-queues-configurations

[root@localhost bin]# /var/lib/asterisk/bin/retrieve_conf

Checking for PEAR DB…OK
Checking for PEAR Console::Getopt…OK
Checking for /etc/amportal.conf …OK
Bootstrapping /etc/amportal.conf …OK
Parsing /etc/amportal.conf …OK
Parsing /etc/asterisk/asterisk.conf …OK
Connecting to database…OK
Connecting to Asterisk manager interface…OK
Added to globals: ASTETCDIR = /etc/asterisk
Added to globals: ASTMODDIR = /usr/lib/asterisk/modules
Added to globals: ASTVARLIBDIR = /var/lib/asterisk
Added to globals: ASTAGIDIR = /var/lib/asterisk/agi-bin
Added to globals: ASTSPOOLDIR = /var/spool/asterisk
Added to globals: ASTRUNDIR = /var/run/asterisk
Added to globals: ASTLOGDIR = /var/log/asterisk
Added to globals: CWINUSEBUSY = true
Added to globals: AMPMGRUSER = xxx
Added to globals: AMPMGRPASS = xxx
Use of uninitialized value in concatenation (.) or string at /var/lib/asterisk/bin/retrieve_op_conf_from_mysql.pl line 383.
Use of uninitialized value in string eq at /var/lib/asterisk/bin/retrieve_op_conf_from_mysql.pl line 415.
DB Error: no such table

7

Looks like there’s problem with cdr (asteriskcdrdb database) only as data to asterisk table is written.

8

Here are the databases and tables that I currently have.
Do you see what’s missing ?

mysql> show databases;
±-------------------+
| Database |
±-------------------+
| information_schema |
| asterisk |
| asteriskcdrdb |
±-------------------+
3 rows in set (0.00 sec)

mysql> use asterisk;
Database changed
mysql> show tables;
±--------------------+
| Tables_in_asterisk |
±--------------------+
| admin |
| ampusers |
| cronmanager |
| custom_destinations |
| custom_extensions |
| devices |
| extensions |
| featurecodes |
| freepbx_log |
| globals |
| iax |
| incoming |
| module_xml |
| modules |
| notifications |
| recordings |
| sip |
| users |
| zap |
| zapchandids |
±--------------------+
20 rows in set (0.00 sec)

mysql> use asteriskcdrdb;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
±------------------------+
| Tables_in_asteriskcdrdb |
±------------------------+
| cdr |
±------------------------+
1 row in set (0.00 sec)

mysql>

9

I need help about this. anyone ?

10

If you believe that this is because of Asterisk version etc. , I can change the version I am using.
Please let me know, so that I can proceed further.

11

Asterisk 1.6 is not released but listed as Beta. It’s really in Alpha testing and not ready for production. Please use latest Asterisk 1.4 instead.

If you had searched the forum pages before you posted you would have noticed several posting about asterisk 1.6 not working with FreePBX properly due it it’s alpha like state.

12

retrieve_conf failed, config not applied
FreePBX 2.8.1.4
after updating freepbx following error …

i need help