I have a dozen, maybe more, php scripts using mysql that have been in production for years that suddenly went down, perhaps within the last two weeks. Many of these scripts use a connection file to manage connections to mySQL databases. It looks like when they hit the line
$LyleTrap = mysql_pconnect($hostname_LyleTrap, $username_LyleTrap, $password_LyleTrap) or trigger_error(mysql_error(),E_USER_ERROR);
I get an error
Fatal error: Call to undefined function mysql_pconnect() in /home/ykfpdata/ykfp.org/Connections/LyleTrap.php on line 9
mysql_pconnect is now undefined? When did that happen? Is this related to the move to Ubuntu 12.04 and php 5.3 on Oct 12, 2014? Checked my domain settings and found PHP to be set 5.3x FastCGI.
Following instructions at http://wiki.dreamhost.com/PHP.ini#Upgrading_your_site_.28if_you.27re_moving_to_Ubuntu_from_Debian_servers.29 I changed the site’s .htaccess file by commenting out the AddHandler and Action lines:
#AddHandler php5-cgi .php
#Action php-cgi /cgi-bin/php-wrapper.fcgi
#Action php5-cgi /cgi-bin/php-wrapper.fcgi
and the table producing scripts run without error. Still, my charting scripts are producing no output. Looking at these scripts, like http://ykfp.org/php/BOR/prodbflowtempchart.php
, it looks like my charting library will not load without me creating a custom php.ini. Getting the message " Error Loading ChartDirector for PHP Extension
It appears this PHP system has not loaded the ChartDirector extension by using an extension statement in the PHP configuration file (typically called “php.ini”). An attempt has been made to dynamically load ChartDirector on the fly, but it was not successful. Please refer to the Installation section of the ChartDirector for PHP documentation on how to resolve this problem."