Posted by Eric on 11/21/06 02:09

Jerry Stuckle wrote:
> eholz1 wrote:
>
>> Hello Newsgroup,
>> I have redhat 3.0 Enterprise, and mysql (3.58.xxx more or less)
>> installed from a redhat rpm,
>> and php 4.3.9 (installed from an rpm) - I can access data from my mysql
>> db using php and the "pear" Db .php. I recently upgraded my Apache to
>> 2.2 and installed (more or less) PHP 5.2 as well - neither of these
>> installs were from a Redhat rpm, I downloaded the tarballs, extracted,
>> configed, make, etc.
>> Apache seems to work fine (but not with the php 4.3.9 rpm). I set the
>> httpd.conf file to access php 5 (libphp5.so) and can display PHP 5.2.0
>> info using phpinfo(). But... I cannot access any data in my mysql
>> database (/usr/local/share/DB.php) from the "pear". And it does not
>> appear that phpinfo() is reading the php.ini file. I have two php.ini
>> files, one in /etc (redhat rpm location), and another in
>> /usr/local/lib/php.ini. I have edited and changed both these files,
>> but the "changed" items (like default
>> mysql.socket=/var/lib/mysql/mysql.sock) do not show up in the phpinfo()
>> page. I have even renamed each php.ini file so there is no php.ini
>> file (like php_ini), and the phpinfo() data still displays! this is in
>> php 5.2.0. In 4.3.9 - all is well - the file (/etc/php.ini) is read,
>> etc, and I can access the db.
>>
>> I have attempted to set the PHP 5.2 switch to the location where my
>> mysql binary is (/usr/bin/mysql), but still nothing seems to work. My
>> guess is that I am not selecting the correct place for PHP 5.2 to hook
>> up with my already installed (but old) redhat my sql rpm.
>>
>> Any ideas on how I can get PHP 5.2 to work with my version of mysql?
>> Or should I remove the existing mysql rpm, and start fresh with a later
>> version of mysql - and install it from tarball, etc Then I would at
>> least know where the mysql stuff is. Redhat seems to spread the
>> package info all over the place.
>>
>> Help!
>>
>> eric jones
>>
>
> What does phpinfo() show for the path to your php.ini file?
>
Hello I did check the location - and moved the php.ini file to this
location - /usr/local/apache2/php/lib - now it reads the file (php).

I still am unable to connect to the db -my my.cnf file seems ok.
I will make a change to my php page that accesses the db.

If I run the older version of apache (2.0) and php 4.3.9 - all is well -
i can diplay data on the php page.

any ideas here???

Thanks,

eholz1

[Back to original message]