Hi;
I appologize in advance to purists who think the question is an
appache one, or a mysql question.
I have a virtual domain hosted by domainavenue.com, owned by wyith.net
in Hong Kong.
I want to use a web content management system
(http://www.phpwebsite.appstate.edu/) which requires php 4.2.2 or
higher. My provider offers perl561, php412, apache (I don't know
which), MySQL3.23.22-beta.
I believe my provider uses a standard linux redhat 7.x distribution,
but their /etc/redhat-release file is not user readable, and I don't
have access to gcc, make etc.
What is the best solution?
Below is an outline of my (unsuccessful) approach:
I compiled php4.3.3 at home (with mysql and static and
cgi.force_redirect) options. Using a '.htaccess' file, I redirect php
requests from the appache module, to my personal executable. Now,
phpwebsite is no longer complaining about insufficient php version,
but the database connectivity is broken, whether initiated by
phpwebsite, or phpMyAdmin. An phpwebsite8.3 error message is included
below:
"Warning: mysql_connect(): Can't connect to local MySQL server through
socket '/tmp/mysql.sock' (2) in /var/www/b1243/php83/dbconnect.php on
line 11
Unable to select database"
The phpMyAdmin message is included below:
Warning: Cannot modify header information - headers already sent by
(output started at /var/www/b1243/phpMyAdmin/libraries/auth/config.auth.lib.php:92)
in /var/www/b1243/phpMyAdmin/header.inc.php on line 23
Error
MySQL said:
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
(2)
The 9.x version of php website simply says:
Unable to connect to your server's database.
Please reenter your settings.
// End error messages, begin questions:
What am I doing wrong? I know I probably don't have the exact same
c-libraries as the web host site, is that a requirement?
Is my executable (3.6MB) truly static, such that there is no
dependence on host libraries?
Do I need to add some mysql path options?
Jan Fure