Updated tonight and get Zend Optimizer screen

…but I dont have any of those modules installed.

Yesterday I upgraded from from freepbx 2.9 to 2.10.
The module system-admin did not want to upgrade saying that php had to be 5.3 and not 5.2.

So I manually upgraded my php to 5.3 after removing Zend optimizer ( that is not compatible with PHP 5.3) and then tried to installed ZenGuard ( yum install zend-server-ce-php-5.3 , compatible with php 5.3 )
But this installation fails with the following error :
Error: Missing Dependency: php = 5.3.8-1.w5 is needed by package php-devel-5.3.8-1.w5.i386 (installed)

So now I end-up with a nice php 5.3 that could allow me to update the system-admin module, but I broke “Zend Optimizer” and so now I manage to get to the login page but when I log in I get the “Zend Optimizer not installed” page.

So I have lost the FreePbx interface !
Please help.

Status of PHP :
[root@Freepbx3 modules]# php -v
Failed loading /usr/local/Zend/lib/ZendExtensionManager.so: /usr/local/Zend/lib/ZendExtensionManager.so: cannot open shared object file: No such file or directory
PHP 5.3.8 (cli) (built: Aug 29 2011 20:02:17)
Copyright © 1997-2011 The PHP Group
Zend Engine v2.3.0, Copyright © 1998-2011 Zend Technologies

php Modules Installed :
[root@Freepbx3 modules]# yum list installed | grep php
php.i386 5.3.8-1.w5 installed
php-cli.i386 5.3.8-1.w5 installed
php-common.i386 5.3.8-1.w5 installed
php-devel.i386 5.3.8-1.w5 installed
php-gd.i386 5.3.8-1.w5 installed
php-ldap.i386 5.3.8-1.w5 installed
php-mysql.i386 5.3.8-1.w5 installed
php-pdo.i386 5.3.8-1.w5 installed
php-pear.noarch 1:1.4.9-6.el5 installed
php-pear-DB.noarch 1.7.13-1.el5.centos installed
php-process.i386 5.3.8-1.w5 installed

Asterisk my modules installed :

Module Version Status


announcement 2.10.0.0 Enabled
asterisk-cli 2.10.0.0 Enabled
asteriskinfo 2.10.0.0 Enabled
backup 2.10.0.6 Enabled
blacklist 2.10.0.0 Enabled
builtin Enabled
bulkdids 2.10.0.2 Enabled
bulkextensions 2.10.0.0 Enabled
callback 2.10.0.0 Enabled
callforward 2.10.0.0 Enabled
callwaiting 2.10.0.0 Enabled
campon 2.10.0.0 Enabled
cdr 2.10.0.1 Enabled
cidlookup 2.10.0.0 Enabled
conferences 2.10.0.1 Enabled
core 2.10.0beta3.0 Enabled
customappsreg 2.10.0.0 Enabled
customcontexts 2.10.0.0 Enabled
dashboard 2.10.0.1 Enabled
daynight 2.10.0.0 Enabled
dictate 2.10.0.0 Enabled
directory 2.10.0.2 Enabled
disa 2.10.0.0 Enabled
donotdisturb 2.10.0.0 Enabled
dundicheck 2.10.0.0 Enabled
endpointman 2.10.1.3 Enabled
extensionsettings 2.10.0.1 Enabled
fax 2.10.0.1 Enabled
featurecodeadmin 2.10.0.1 Enabled
findmefollow 2.10.0.1 Enabled
framework 2.10.0beta3.3 Enabled
fw_ari 2.10.0.beta1.1 Enabled
fw_fop 2.10.0.2 Enabled
fw_langpacks 2.9.0.1 Enabled
googlevoice Not Installed (Locally available)
iaxsettings 2.10.0.1 Enabled
infoservices 2.10.0.0 Enabled
irc 2.10.0.1 Enabled
ivr 2.10.0.2 Enabled
javassh 2.10.0.0 Enabled
languages 2.10.0.0 Enabled
logfiles 2.10.0.0 Enabled
manager 2.10.0.0 Enabled
miscapps 2.10.0.0 Enabled
miscdests 2.10.0.0 Enabled
music 2.10.0.0 Enabled
outroutemsg 2.10.0.0 Enabled
paging 2.10.0.1 Enabled
parking 2.10.0.0 Enabled
pbdirectory 2.10.0.0 Enabled
phonebook 2.10.0.0 Enabled
phpagiconf 2.10.0.0 Enabled
phpinfo 2.10.0.0 Enabled
pinsets 2.10.0.0 Enabled
printextensions 2.10.0.1 Enabled
queueprio 2.10.0.0 Enabled
queues 2.10.0.1 Enabled
recordings 3.3.11.4 Enabled
restart 2.10.0.0 Enabled
ringgroups 2.10.0.0 Enabled
setcid 2.10.0.0 Enabled
sipsettings 2.10.0.1 Enabled
sipstation Not Installed (Locally available)
speeddial 2.10.0.0 Enabled
sysadmin 2.9.0.19 Enabled
timeconditions 2.10.0.1 Enabled
vmblast 2.10.0.1 Enabled
voicemail 2.10.0.0 Enabled
weakpasswords 2.10.0.0 Enabled

seems that it is Sysadmin itself the culprit, I upgraded it from comand line, I now I dont get the Zend Optimizer error anymore…

sysadmin 2.9.0.19 Disabled; Pending upgrade to 2.10.0.16

but Sysadmin cannot be enabled

[root@Freepbx3 modules]# /var/lib/asterisk/bin/module_admin enable sysadmin Failed loading /usr/local/Zend/lib/ZendExtensionManager.so: /usr/local/Zend/lib/ZendExtensionManager.so: cannot open shared object file: No such file or directory
The following error(s) occured:

  • Module sysadmin cannot be enabled

any help would be welcome, the interface is not quite right yet… I have tyo provide my password for every click. I wish I could post screenshots !

You should of used the Distro Upgrade scripts. At this point I would remove the php you installed and than run the upgrade script.

The reason you have to re-login is you updated php and freepbx needs php session details to be owned by the FreePBX user and php sets it up by default to be root.

I suggest following the upgrade scripts in order as found here after you remove php that you installed since they are the wrong versions

http://www.freepbx.org/forum/freepbx-distro/distro-discussion-help/release-versions

I uninstalled PHP, reinstalled the 5.2.17 one.
Then manually downloaded the full Freepbx 2.0.7 package and everything is back online as normal…
Thanks for the advice to remove php.
I will try using the upgrade script to move to 2.10 this week end, the thing is, as I have a modified version of asterisk I am a little scared not to control what is beeing installed. I don’t mind breaking the web GUI, but if Asterisk is broken I will have much bigger problems…

Thanks again fro your quick answer.

… now retrieve_conf wont work.

Upgrade was successfull.
Interface working on 2.10
No login issues.

But now Freepbx shows the “Apply config button” and it wont go away

The message on the status page is :

Critical Error retrieve_conf failed, config not applied
Reload failed because retrieve_conf encountered an error: 1
Added 1 minute ago
(freepbx.RCONFFAIL)

When trying to do it on command line ( I dont know it makes sense, but in case it was supposed to work without parameters, here is the result :slight_smile:

[root@Freepbx3 bin]# cd /var/lib/asterisk/bin/
[root@Freepbx3 bin]# ./retrieve_conf
[FATAL] SELECT dest, name, selection, a.id id FROM ivr_details a INNER JOIN ivr_ entries d ON a.id = d.ivr_id ORDER BY name [nativecode=1054 ** Unknown column ’ name’ in ‘field list’]SQL -
SELECT dest, name, selection, a.id id FROM iv r_details a INNER JOIN ivr_entries d ON a.id = d.ivr_id ORDER BY name

Trace Back:

/var/www/html/admin/libraries/sql.functions.php:11 die_freepbx()
[0]: SELECT dest, name, selection, a.id id FROM ivr_details a INNER JOIN ivr_en tries d ON a.id = d.ivr_id ORDER BY name [nativecode=1054 ** Unknown column ‘na me’ in ‘field list’]SQL -
SELECT dest, name, selection, a.id id FROM ivr_ details a INNER JOIN ivr_entries d ON a.id = d.ivr_id ORDER BY name

/var/www/html/admin/modules/ivr/functions.inc.php:599 sql()
[0]: SELECT dest, name, selection, a.id id FROM ivr_details a INNER JOIN ivr_en tries d ON a.id = d.ivr_id ORDER BY name
[1]: getAll
[2]: 2

/var/www/html/admin/libraries/usage_registry.functions.php:88 ivr_check_destinat ions()
[0]: 1

/var/www/html/admin/libraries/usage_registry.functions.php:281 framework_check_d estination_usage()
[0]: 1
[1]:

/var/lib/asterisk/bin/retrieve_conf:615 framework_list_problem_destinations()
[0]:
[1]:

By the was I applied the last upgrade patch, that moved me to centos 5.7.

This same error also happens when I want to open an extension detail in freepbx.
I get a web page with following error

FATAL ERROR
SELECT dest, name, selection, a.id id FROM ivr_details a INNER JOIN ivr_entries d ON a.id = d.ivr_id WHERE dest in (‘ext-fax,114,1’)ORDER BY name [nativecode=1054 ** Unknown column ‘name’ in ‘field list’]SQL -
SELECT dest, name, selection, a.id id FROM ivr_details a INNER JOIN ivr_entries d ON a.id = d.ivr_id WHERE dest in (‘ext-fax,114,1’)ORDER BY name
Trace Back
/var/www/html/admin/libraries/sql.functions.php:11 die_freepbx()
[0]: SELECT dest, name, selection, a.id id FROM ivr_details a INNER JOIN ivr_entries d ON a.id = d.ivr_id WHERE dest in (‘ext-fax,114,1’)ORDER BY name [nativecode=1054 ** Unknown column ‘name’ in ‘field list’]SQL -
SELECT dest, name, selection, a.id id FROM ivr_details a INNER JOIN ivr_entries d ON a.id = d.ivr_id WHERE dest in (‘ext-fax,114,1’)ORDER BY name

/var/www/html/admin/modules/ivr/functions.inc.php:599 sql()
[0]: SELECT dest, name, selection, a.id id FROM ivr_details a INNER JOIN ivr_entries d ON a.id = d.ivr_id WHERE dest in (‘ext-fax,114,1’)ORDER BY name
[1]: getAll
[2]: 2

How come the field “name” could be missing from the DB ?

http://www.freepbx.org/trac/ticket/5454

Does anybody kno how to fix it manually ?

This is because you upgraded to 2.10 so all the migration of the MySQL database for IVR’s and such was done for the new IVR. You than downgraded to 2.9 which you cant dont and than tried to go back to 2.10 and now all the migration is failing.

All you can do is uninstall IVR and reinstall. You will probally loose your IVR’s and have to re-create them.

Many many thanks, I patched manually the php file and everything is fine.
Yes next time I’ll open a new thread.
But this time it revealed usefull because you detected the “name” column issue was due to back and forth installations of FreePbx, if i had published the issue without the history of this thread I think it would have taken you more time to detect the issue.
anyway I agree, I will open one new subject per issue, or question.
Thank again, your support was very usefull.

I’ll do that

Sorry for messing arround with the version, and thanks for your support !

Now I have a last question, when I recreated the IVR I could recreate them well, but the option “0” is not saved by the system.
Before “0” was used to be send to “operator”, but as now Freex pbx does not save this option, and the recordings say “press 0 for operator”, when callers press 0 then the IVR restarts… is it normal ? the “0” entry is not valid anymore for routing a call in the IVR ?

I have seen other report the 0 bug for IVR’s and keep asking for someone to open a bug ticket so I can get a developer to address and fix it. Have not seen a bug ticket yet opened.

Also in the future try to start a new thread for a new item and keep threads on topic to their subject line. This helps keep things clean and organized and on topic.

I went ahead and created a bug ticker on the IVR issue. http://www.freepbx.org/trac/ticket/5515

Also feel free in the future to open bug tickets as that is where the developers look for things and they dont read each and every forum post and things like this would usually get missed.

Thanks