[CentOS] CentOS 4 with MySQL 4.1

[Chris Hammond]

Sorry for taking so long to reply but was unable over the weekend.

It is working.  I did forget to restart apache.  All is now well!

Thanks for all the replies and the assistance.

Chris

Troy Engel wrote:

> Ideas:
>
> 1) restart Apache, test again
> 2) install phpMyAdmin, and use that to ensure php-mysql works
>
> -te
>
> Chris Hammond wrote:
>
>> I should have mentioned that JFFNMS on another server CAN talk to the 
>> DB so it is running properly.
>>
>> Thanks
>> Chris
>>
>> Chris Hammond wrote:
>>
>>> Thanks, makes perfect sense but due to my lack of DB knowledge, I 
>>> would have never thought of it. :(  I downloaded
>>> the binary package, removed all traces of mysql packages and brought 
>>> up the binary version of 4.0 in /usr/local/mysql
>>> using the script in support-files.  I then yum installed php-mysql 
>>> which brought in all the dependencies.  I can connect
>>> with the "mysql" client in /usr/bin which is the 4.1 versions.  
>>> However, JFFNMS still says that php-mysql is not loaded
>>> and cannot talk to the DB.   How would you go about testing the 
>>> php-mysql piece?
>>>
>>> Thanks!!!
>>> Chris
>>>
>>> Troy Engel wrote:
>>>
>>>> Chris Hammond wrote:
>>>>
>>>>> Greetings all!
>>>>>
>>>>> I have built a new server with MySQL and have noticed that before 
>>>>> even doing anything
>>>>> to it I found that the MySQL logins were much slower than the 4.0 
>>>>> server I used prior to it.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> Just as a note, I have not noticed this problem at all -- my logins 
>>>> are just as fast/fine/snappy as always. Not sure what's wrong with 
>>>> your stuff..
>>>>
>>>>> I am at a loss of what to do.  I would prefere to go with MySQL 
>>>>> 4.1 just because that is what
>>>>> comes with CentOS 4, short of that I need php-mysql to work with 
>>>>> 4.0.  Databases and
>>>>> custome building of RPM's is beyond my capabilities.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> You can use the builtin 4.1 *client* binaries (which are what php 
>>>> and it's ilk are linked to), while using the 4.0 server binaries. 
>>>> All you need to do is uninstall "mysql-server" RPM, install your 
>>>> downloaded 4.0 binary package to /usr/local/mysql/ (eg), and run 
>>>> the server from there using it's custom initscript.
>>>>
>>>> Make sure the /etc/my.cnf is all configured nicely before 
>>>> bootstrapping the downloaded 4.0 install, and everything should 
>>>> just click (within reason). Most importantly, make sure the socket 
>>>> path and database path is set.
>>>>
>>>> -te
>>>>
>>>
>>> _______________________________________________
>>> CentOS mailing list
>>> CentOS at centos.org
>>> http://lists.centos.org/mailman/listinfo/centos
>>
>>
>>
>>
>> _______________________________________________
>> CentOS mailing list
>> CentOS at centos.org
>> http://lists.centos.org/mailman/listinfo/centos
>
>