[SOLVED] Reload issues following upgrade to 2.11

FreePBX Installation / Upgrade
1

Hi All,

I recently upgraded from 2.10 to 2.11 using module admin. All went smoothly until the final reload. Now I am getting the following errors upon trying to reload:

Reload failed because retrieve_conf encountered an error: 1

exit: 1
found language dir fr for directory, not installed on system, skipping
Added to globals:  =
Added to globals:  =
Added to globals:  =
Added to globals:  = u
Added to globals:  =
Added to globals:  =
Added to globals:  = 2
Added to globals:  = 1
Added to globals:  = 1
[FATAL] SELECT data FROM parkinglot WHERE keyword='parkext' [nativecode=1146 ** Table 'asterisk.parkinglot' doesn't exist]SQL - 
 SELECT data FROM parkinglot WHERE keyword='parkext'

Trace Back:

/var/www/html/admin/libraries/sql.functions.php:25 die_freepbx()
 [0]: SELECT data FROM parkinglot WHERE keyword='parkext' [nativecode=1146 ** Table 'asterisk.parkinglot' doesn't exist]SQL - 
 SELECT data FROM parkinglot WHERE keyword='parkext'

/var/www/html/admin/modules/fop2admin/functions.inc.php:68 sql()
 [0]: SELECT data FROM parkinglot WHERE keyword='parkext'
 [1]: getRow
 [2]: 2

/var/lib/asterisk/bin/retrieve_conf:683 fop2admin_get_config()
 [0]: asterisk
1 error(s) occurred, you should view the notification log on the dashboard or main screen to check for more details.

I’m also getting a symlink from modules failed error:

retrieve_conf failed to sym link: 
   /etc/asterisk/cel_odbc.conf from cdr/etc (Already exists, not a link)
   /etc/asterisk/cel.conf from cdr/etc (Already exists, not a link)
This can result in FATAL failures to your PBX. If the target file exists and not identical, the symlink will not occur and you should rename the target file to allow the automatic sym link to occur and remove this error, unless this is an intentional customization.
Added 2 days, 20 hours, 29 minutes ago
(retrieve_conf.SYMLINK)

My setup is not a distro, but manually built consisting basically of
[List=1]
[] CentOS 6.4, 64-bit with 2.6.32-358.6.2.el6.x86_64 kernel
[] Asterisk 1.8.12.1 with
[List=I]
[] Asterisk patch Presence Subscription on Cisco Phones as listed on JIRA
[] Asterisk patch video format ‘negotiation’ as published in the Asterisk-Video mailing list from Artem Makhutov
[/List]
[] Dahdi 2.6.2
[] FOP2 v2.26
[/List]

So it appears some errors to do with SQL table for the parking lot and FOP2. Not sure about the symlink errors.

Has anyone seen anything like this, or any ideas for a fix before I go digging under the hood?

Cheers

2

I did an uninstall on fop2 was still getting the error. The second time I tried to reload, it loaded with no error but I notice FOB2 is still “there”. I even rebooted but I can still access it at IP/fop2/ which is strange. Under Module Admin it says it’s Not Installed (Locally available).
I guess it’s not a problem any longer as the error message is gone.
Related quick question: I understand the old FOP panel was abandoned a couple of updates ago which was why I switched to FOP2, but I notice the FreePBX FOP Framework is in version 2.10.0.2 Does that mean it’s supported again? I still have it disabled.

3

Update or delete the fop2 module. Its third party. We do not control it.

4

I get the same error however deleting the files didn’t solve my issue.
Reload failed because retrieve_conf encountered an error: 1

exit: 1
found language dir fr for directory, not installed on system, skipping
Added to globals: OPERATOR_XTN = xxx
Added to globals: VM_OPTS = s
Added to globals: VM_GAIN =
Added to globals: VM_DDTYPE = u
Added to globals: VMX_OPTS_LOOP =
Added to globals: VMX_OPTS_DOVM =
Added to globals: VMX_TIMEOUT = 2
Added to globals: VMX_REPEAT = 1
Added to globals: VMX_LOOPS = 1
[FATAL] SELECT data FROM parkinglot WHERE keyword=‘parkext’ [nativecode=1146 ** Table ‘asterisk.parkinglot’ doesn’t exist]SQL -
SELECT data FROM parkinglot WHERE keyword=‘parkext’

Trace Back:

/var/www/html/admin/libraries/sql.functions.php:25 die_freepbx()
[0]: SELECT data FROM parkinglot WHERE keyword=‘parkext’ [nativecode=1146 ** Table ‘asterisk.parkinglot’ doesn’t exist]SQL -
SELECT data FROM parkinglot WHERE keyword=‘parkext’

/var/www/html/admin/modules/fop2admin/functions.inc.php:68 sql()
[0]: SELECT data FROM parkinglot WHERE keyword=‘parkext’
[1]: getRow
[2]: 2

/var/lib/asterisk/bin/retrieve_conf:709 fop2admin_get_config()
[0]: asterisk

5

Oops just spotted this thread:

http://www.freepbx.org/forum/installation/reload-failed-because-retrieveconf-encountered-an-error-1

So have now disabled the FOP Admin module, which clears up the retrieveconf errors, but still getting the symlink errors…

6

Just simply deleted the offending files:

/etc/asterisk/cel_odbc.conf
/etc/asterisk/cel.conf

The auto symlinks have now re-created, and no more errors in FPBX notices pane…

Bit weird, maybe its just one of those things, but problem simply solved in the end.