Not Logged in - No Account?
Don't have an account? Registering an account with us allows you to post to the forums, easily track new posts, subscribe to threads, pm (private message) other forum members, and receive periodic news letters (you can opt out if you desire). Once you are logged in this message will no longer appear. If you don't have an account, you can create one by registering here. Lost your password, request a new password. We respect your privacy which means we collect minimal information when you register and we do not resell that information or use it in any objectionable way. You can review our privacy policy for full details.
retrieve_conf failure
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
Looks like db connections
Looks like db connections problem.
Check if you can connect to asterisk* databases with user/pass supplied in /etc/amportal.conf (AMPDBUSER, AMPDBPASS)
router:~# grep AMPDBUSER
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 ?
this should be something
this should be something easy. but what ?
yep, seems ok. Actually it's
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
Same here
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-q...
[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
Looks like there's problem
Looks like there's problem with cdr (asteriskcdrdb database) only as data to asterisk table is written.
Here are the databases and
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>
I need help about this.
I need help about this. anyone ?
If you believe that this is
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.
Asterisk 1.6 is not released
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.