Upgrade instructions

[atsak]

The upgrade went fine but;

/usr/local/fop2/fop2_server --status
Unknown option: status
Flash Operator Panel 2 - White Label Version.
ERROR 1146 (42S02) at line 1: Table 'asterisk.fop2settings' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'asterisk.fop2permissions' doesn't exist
ERROR 1054 (42S22) at line 1: Unknown column 'exclude' in 'where clause'

Can't listen to port 4445

Is this important? Everything "seems" to be working OK.

[mike_flrsinc.com]

Hi I followed the steps provided by admin but I get a error. I have current FreePBX Distro.

1. fop2-2.22-centos5-i386.tgz - success!

2. tar zxvf fop2-2.22-centos5-i386.tgz
   tar: fop2-2.22-centos5-i386.tgz: Cannot open: No such file or directory
   tar: Error is not recoverable: exiting now
   tar: Child returned status 2
   tar: Error exit delayed from previous errors

Have I done something wrong? I was able to upgrade the FOP2 Admin using module admin without issue. Can you guys help I'm sure its something simple I'm missing here.

[nicolas]

The upgrade went fine but;

/usr/local/fop2/fop2_server --status
Unknown option: status
Flash Operator Panel 2 - White Label Version.
ERROR 1146 (42S02) at line 1: Table 'asterisk.fop2settings' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'asterisk.fop2permissions' doesn't exist
ERROR 1054 (42S22) at line 1: Unknown column 'exclude' in 'where clause'

Can't listen to port 4445

Is this important? Everything "seems" to be working OK.

There is no --status option in fop2_server, you have the --test option

The errors you see are due to having an old fop2admin version, you must upgrade to version 1.2.7

[nicolas]

Hi I followed the steps provided by admin but I get a error. I have current FreePBX Distro.

1. fop2-2.22-centos5-i386.tgz - success!

2. tar zxvf fop2-2.22-centos5-i386.tgz
   tar: fop2-2.22-centos5-i386.tgz: Cannot open: No such file or directory
   tar: Error is not recoverable: exiting now
   tar: Child returned status 2
   tar: Error exit delayed from previous errors

Have I done something wrong? I was able to upgrade the FOP2 Admin using module admin without issue. Can you guys help I'm sure its something simple I'm missing here.

Cannot help you much as I do not know what filename was the file saved as, it is not clear if you used wget to retrieve the file? If so, and depending on the wget version, the file might be saved with a different name, just list the directory contents, find out the actual filename and pass that to the tar zxvf command.

[atsak]

OK the upgrade to the Freepbx module has taken away those errors and I now get a connection to manager OK response.

However, I cannot access the FOP2 panel. It hangs the "connecting to server attempt number 1" screen.

I have done an amportal restart. Is there anything else I can look for?

[atsak]

buttons_custom.cfg needs to have asterisk:asterisk permissions it looks like.

[nicolas]

buttons_custom.cfg needs to have asterisk:asterisk permissions it looks like.

Not really. Fop2 run as root.

[nicolas]

OK the upgrade to the Freepbx module has taken away those errors and I now get a connection to manager OK response.

However, I cannot access the FOP2 panel. It hangs the "connecting to server attempt number 1" screen.

I have done an amportal restart. Is there anything else I can look for?

Check that fop2_server is running and that access to port tcp/4445 from your desktop machine is clear.

[atsak]

It was running.

The permissions change worked . . .

[asemaltork]

[root@localhost ~]# /usr/local/fop2/fop2_server --status
Unknown option: status
Flash Operator Panel 2 - White Label Version
PHP Fatal error: SQL Error: SELECT asterisk.users.name AS agent, cnum.count AS count, c num.talktime AS talktime FROM ( SELECT cnum, COUNT(*) AS count, SUM(sum) AS talktime FROM ( SELECT cnum, uniqueid, SUM(billsec) AS sum FROM asteriskcdrdb.cdr WHERE calldate >= CURDA TE() AND lastapp = 'Dial' GROUP BY cnum, uniqueid) AS billsec_sum GROUP BY cnum) AS cnum INNE R JOIN asterisk.users ON cnum.cnum = asterisk.users.extension WHERE 1=1
SELECT command denied to user 'qstatsUser'@'localhost' for table 'cdr' in /var/www/html/fop2/admin/dbli b.php on line 108

what is this error ?

[JaredBusch]

Exactly what it says. An invalid option.

You are using the wrong command.

[nicolas]

@asemaltork said:
[root@localhost ~]# /usr/local/fop2/fop2_server --status
Unknown option: status
Flash Operator Panel 2 - White Label Version
...
SELECT command denied to user 'qstatsUser'@'localhost' for table 'cdr' in /var/www/html/fop2/admin/dbli b.php on line 108

what is this error ?

Besides the incorrect command --status that does not exist, the error comes from the Full Wallboard plugin and not following installation instructions fully. You must grant permissions to the CDR table to the use qstatsUser as described in the Full Wallboard installation guide