[CentOS] CentOS 4 with MySQL 4.1

Sun Apr 3 19:17:59 UTC 2005
Troy Engel <tengel at fluid.com>

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

-- 
Troy Engel | Systems Engineer
Fluid Inc. | http://www.fluid.com