mysql.so - php.ini - setting up a wiki

If i do a whereis for mysql.so and come up with mult. instances, are they the same file, or different versions?

I am trying to set up a mediaWiki (LAMP), and the wiki setup page says I need to recompile using --with-mysql or install the mysql.so

I have copied a mysql.so into the exentsions_dir path designated in the php.ini file, and uncommented the extension=mysql.so line

here's the thing: i found that file in /usr/lib/perl5/vendor_perl...

I did a whereis mysql.so and came up with 3 directories, but when I went in to them, i didn't see the file. When I did a locate mysql.so, the /usr/lib/perl5 locating is the only one with the file...
LVL 1
coldchillinAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

richswyattCommented:
I've always just done --with-mysql

Did you install mysql on this server? If not - it could be in a myriad of places. Mine, for instance, on RedHat Enterprise Linux is in /usr/share/mysql

The reason that you get multiple hits when you do whereis is b/c different applications install their own versions.
0
TeRReFCommented:
What *NIX flavour are you using?
0
richswyattCommented:
RedHat Enterprise 4.0
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

coldchillinAuthor Commented:
but how about this:

I do a whereis mysql.so
and the first entry is
/usr/bin/mysql

cd /usr/bin/mysql is not a directory
and within /usr/bin, there is no mysql.so file

I did install mysql on the server, and it is currently running (yum install mysql)

let's just say i compile using --with-mysql, can you step me through that exactly? -newbie

the httpd on the server is running, and php is installed, and so is the wiki, so i can hit it, but it's just not configured properly (the mysql.so) even though there IS now a mysql.so file in the /usr/lib/php/modules directory (the mysql.so taken from /usr/lib/perl5...)
0
richswyattCommented:
So - let me get this straight - PHP is NOT installed with MYSQL, is that correct?
0
richswyattCommented:
View /foldertophpinstallsource/config.nice

Make sure you use all the same flags and then ./configure <all the flags here> and add --with-mysql
After ./configure then make and after make runs then make install

At that point if you restart Apache - you should be able to use mysql functions in PHP code
0
TeRReFCommented:
@richswyatt
I was asking coldchillin about the flavour ;-)

@coldchillin
Remove the perl mysql.so module. That won't work. Try this:
yum install php_mysql
0
richswyattCommented:
Sorry about that. :-)
0
coldchillinAuthor Commented:
I'm using CentOS 4.3, I believe it's derived from Red Hat

I tried yum install php_mysql and it said
no match for arguments: php_mysql
0
wakemupCommented:
I think it's actually php-mysql? (dash instead of underscore)
0
Steve BinkCommented:
why not just look at your phpinfo() and see if it is compiled with MySQL?
0
TeRReFCommented:
If you are using PHP 5.x it should be included per default...
0
coldchillinAuthor Commented:
wakemup - i tried php-mysql as well, no match

routinet - where/what eaactly am i looking for?

terref - i'm using 5.1.6
0
coldchillinAuthor Commented:
it's actually without-mysql

and there is no mod_sql

only mod_auth_mysql

i cannot locate a mysql.so on the machine, only the one where int he perl directory, which isn't the right one.

0
richswyattCommented:
The easiest solution is to recompile --with-mysql

Do you have the original PHP install source folder?
0
coldchillinAuthor Commented:
i don't think so...what is it usually?
0
richswyattCommented:
Could be /usr/src/php path  or anywhere - did you set it up originally?
0
coldchillinAuthor Commented:
what I did was i made a change to /etc/yum.repos.d/CentOS-Base.repo to install PHP5x
0
richswyattCommented:
Ah - so somewhere in there should be the config.nice (do a whereis or just search for it in the src folder)... Anyway - you could reconfigure it and recompile it with --with-mysql and then restart Apache and voila - you have MySQL function access.
0
coldchillinAuthor Commented:
there doesn't appear to be a source folder, or a config file.

(i'm a newbie)

this is the configuration file for the yum updater, not for php. I added the line
installonlypkgs=php*
to the [centosplus] section

then issued the command

yum install php

if i do that now it says
...
...
...
Nothing to do
0
richswyattCommented:
Check this out:

Try this

yum --enablerepo=centosplus install php-mysql

OR go to the following link

http://www.jasonlitka.com/2007/02/10/upgrading-php-521-rhel-centos/
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
coldchillinAuthor Commented:
THANK YOU!

The yum --enablerepo=centosplus install php-mysql worked like a charm!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PHP

From novice to tech pro — start learning today.