[CentOS] CentOS 4 with MySQL 4.1
Troy Engel
tengel at fluid.com
Sun Apr 3 19:17:59 UTC 2005
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
More information about the CentOS
mailing list