[Resolved] MySQL faulty installation (Linux)

Norman_Graham

Hi all

I'm working on setting up LAMP. I'm not a PHP newbie, but I am a Linux newbie. I installed Apache 2.0.52 from source and also PHP 5.0.2 from source. This worked fine. However, prior to installing PHP, I installed MySQL from RPMs. I'm afraid I was misled by the MySQL manual, which recommends installing from RPMs. However, I was in a bookshop yesterday, leafing through the latest O'Reilly edition of PHP and MySQL and it recommends building from source.

So ... I ran ./configure on PHP using the following statement:

./configure
--with-apxs2=/usr/local/apache2/bin/apxs
--with-mysqli
--without-sqlite
--with-xsl=/usr/lib
--enable-soap
--with-libxml-dir=/usr/lib

Perhaps I should also have added --without-mysql, because I want mysqli as you can see. Whatever - the configuration ran successfully but ended with the following note:

checking for MySQLi support... yes
checking whether to enable embedded MySQLi support... no
mysql_config not found
configure: error: Please reinstall the mysql distribution

So I want to uninstall my client and server installation and do it again from source. I installed the following packages:

MySQL-server-4.1.7-0.i386.rpm
MySQL-client-4.1.7-0.i386.rpm

I tried doing: rpm -e /package/.rpm, but it says that these RPMs are not installed - weird.

Any suggestions as to how to get rid of MySQL cleanly so that I can start again? I have read several threads and I have consulted the MySQL manual closely. I really have spent several hours looking for the answers myself.

Distro: SuSE 9.0 Pro, kernel 2.4

Thanks

Norm 😕

chyan

to check whether mysql is installed on your system or not,
use the command

rpm -qd mysql

if the result say mysql is not installed, then maybe you actually never
installed mysql

but i recommend you to installed mysql,apache, and php from you linux
source distribution, just choose to add aplication menu and choose
these item to be installed, as you installed it from your linux distribution
you could free yourself from difficulty to configure these one by one,
which is diffilcut for a newbie
if you installed from your linux distribution, linux will automaticaly integrated
php,apache,mysql to working together, and no need to configure anymore

Norman_Graham

Hi Chyan

Thanks for the advice. MySQL is certainly installed - I didn't just imagine it. I can run MySQL 4.1.7 without difficulty from the shell - all ship-shape and ready to sail. I spent a whole evening doing it carefully - it wasn't a dream.

I don't want to use the distro packages because they are out of date. I want LAMP with mysqli and simple XML, as well as the new PHP5 OO facilities. You don't get any of these features using the on-board distro versions, all of which were released towards the end of 2003.

The other reason for installing things myself is to learn how to do it properly, since I'm in this to learn.

So, back to my question: why does RPM say that it isn't installed, although I installed the packages from the RPMs and how can cleanly uninstall the whole shebang and start again using a source package?

Thanks

Norm 😕

tsinka

Hi,

don't use the filename with rpm -e, take the output of e.g. rpm --query --all |grep -i mysql . That prints the package names to use with rpm -e.

I think the problem in your case might be that you need to install the mysql-devel package in order to compile php yourself. Same for all other packages needed by php.

Thomas

Norman_Graham

Hi Thomas

Thanks for that suggestion. I did that already - I had noted down this useful command when you gave it to me the other night. But it produces nothing, which I think is weird, because MySQL is installed and working.

What could be the reason for this?

However, I'll try it again this evening to make doubly sure. Perhaps I just mistyped the command and didn't notice.

Thanks

Norm

Norman_Graham

Hi Thomas

I guess I must have mistyped the command because I did it again this evening and it produced the client and server packages thus:

rpm -q -a|grep -i mysql
MySQL-server-4.1.7-0
MySQL-client-4.1.7-0

I then did this ...

rpm -e  MySQL-client-4.1.7-0

... and ditto for the server and the shell returned silently to the prompt. I wish the shell was a bit more talkative sometimes! (I suppose I should have used the -v thing to make it talk some more).

Anywayz - I'm assuming this means success. The only MySQL files left are a handful under /var/lib. Everything else seems to have gone apart from a completely empty directory under /usr/lib. So ... I'm assuming I can safely delete these stragglers and get on with the job of doing the whole thing again from source.

Thanks

Norm

PS: Now marking this resolved for the time being.

tsinka

One last note (not really neccessary because you want to compile from sources but I think that was the problem):

Additionally, install MySQL-devel-4.1.7-0.i386.rpm because you need the header files and libraries. If PHP needs the dynamic client libraries -> install MySQL-shared-4.1.7-0.i386.rpm, too.

At least without the devel package you can't compile PHP with MySQL support.

Good luck with compiling MySQL from sources 🙂

Thomas

Norman_Graham

Thanks, Thomas. I may need it!

Norm 🆒