Eugene's questions

I have Sphinx installed and have around 40 indexes which connect to external mysql database to pull data. I have cronjobs set up for these indexes and re-index them every 5 minutes. So in other words every 5 minutes my server does 40 connections to an external mysql server.

The problem is that in approximately 10 minutes this stops working and if I ssh to sphinx server and try to connect to mysql database from command line, it returns

ERROR: index '...': sql_connect: Can't connect to MySQL server on '...' (110) (DSN=mysql://...:***@...:3306/...).

If I do the same from my local machine, I can connect so the mysql server itself is perfectly fine. Now if I SSH to the sphinx server and restart iptables, everything starts working again and it can once again connect to external mysql server. I am not very familiar with iptables so if anyone could give me some clues how to debug this or what could be causing this, I'd highly appreciate this!

For ion cube I need this line

zend_extension = /usr/lib/php5/20060613+lfs/ioncube_loader_lin_5.2.so

while for zend I need this one

zend_extension = /etc/php5/ZendOptimizer.so

Are these loaders mutually exclusive and if no, what line do I need to have them both running?

I want to both keep the latest PHP provided with Ubuntu and to have a specific PHP version installed somewhere. Is it doable? Can I just compile the PHP in some folder and then somewhere in Apache configs (I mean the apache provided with Ubuntu) switch between PHP dirs when needed.

I am using Ubuntu 10.04 and for some time I had to keep a downgraded PHP 5.2 package because I need to run Zend encrypted scripts. Recently I noticed that Zend released beta version of their loader (http://forums.zend.com/viewtopic.php?f=57&t=1365&start=80#p22073) so I updated to the native PHP 5.3 package, downloaded the .so file, added this to php.ini

;zend_extension=/etc/php5/ZendOptimizer.so
zend_extension=/etc/php5/ZendGuardLoader.so
zend_loader.enable=1
zend_loader.disable_licensing=0
zend_loader.obfuscation_level_support=3

and restarted the server. Now I am getting this error:

Fatal error: Incompatible file format: The encoded file has format major ID 1, whereas the Loader expects 4 in ... on line 0

Do you by chance know an easy fix for this? Or should I downgrade back and wait till when they release something more stable?

I've updated from 9.10 to 10.04, but unfortunately the PHP provided with 10.04 is not yet supported by zend optimizer.

As far as I understand, I need to somehow replace the PHP 5.3 package provided under 10.04 with an older PHP 5.2 package provided under 9.10. However I'm not sure whether this is the right way to downgrade PHP and if yes, I don't know how to replace the 10.04 package with 9.10 package.

Could you please help me with that?

I've just updated from 9.10 to 10.04. Everything seems to run fine except for zend optimizer which is throwing "Zend Optimizer not installed" error. I went to php.ini and the following line is still there Code:

zend_extension=/etc/php5/ZendOptimizer.so

Also I checked that the file does exist and that the php.ini I am looking at is in fact the php.ini file that is being used by the server. Please let me know if you have any ideas about how to fix or debug this.

Thanks, Eugene