Linux Help
guides forums blogs
Home Desktops Distributions ISO Images Logos Newbies Reviews Software Support & Resources Linuxhelp Wiki

Welcome Guest ( Log In | Register )



Advanced DNS Management
New ZoneEdit. New Managment.

FREE DNS Is Back

Sign Up Now
 
Reply to this topicStart new topic
> Php With Mysql
fobius
post Sep 2 2003, 09:34 PM
Post #1


Whats this Lie-nix Thing?
*

Group: Members
Posts: 23
Joined: 27-August 03
Member No.: 1,334



Hi,

I've been trying to install the latest version of PHP 4.3.3 and I'm having some problems when running the configure script. I've installed MySQL using the rpms provided at the MySQL website. I've installed the server, client and devel rpms:

MySQL-client-4.0.14-0.i386.rpm
MySQL-devel-4.0.14-0.i386.rpm
MySQL-server-4.0.14-0.i386.rpm

This is what I've been entering:

./configure --prefix=/usr/local/apache2/php --with-apxs2=/usr/local/apache2/bin/apxs --with-config-file-path=/usr/local/apache2/php --with-mysql=/usr/include/mysql

However the problem is that configure is saying that the MySQL header files cannot be found in that directory. I've done some checking around for where the files where installed and it seems that the header files are in /usr/include/mysql. I think quite a few other people might have this problem.

Any ideas?

-fobius
Go to the top of the page
 
+Quote Post
hughesjr
post Sep 2 2003, 09:44 PM
Post #2


Its GNU/Linuxhelp.net
*******

Group: Admin
Posts: 3,433
Joined: 25-July 03
From: Corpus Chrsiti, TX, USA
Member No.: 1,151



what is your linux distro .... if using RedHat, Mandrake or SUSE then you don't need to build anything ... just install the php and httpd rpms.

but my php is only 4.2.2 ... so if you want 4.3.3 then I guess you do need to do the manual install....


--------------------
Johnny Hughes
hughesjr@linuxhelp.net
Enterprise Alternatives: CentOS, WhiteBoxEL
Favorite Workstation Distros (in order): CentOS, Gentoo, Debian Sarge, Ubuntu, Mandrake, FedoraCore, Slackware, SUSE
Favorite Server Distros (in order): CentOS, WhiteBoxEL, Debian Sarge, Slackware, Mandrake, FedoraCore, Gentoo, SUSE
Go to the top of the page
 
+Quote Post
fobius
post Sep 2 2003, 10:16 PM
Post #3


Whats this Lie-nix Thing?
*

Group: Members
Posts: 23
Joined: 27-August 03
Member No.: 1,334



Hi,

I'm using Mandrake 9.1. I installed Apache by source and I'd prefer to install php by source as well. If the header files are in /usr/include/mysql, why doesn't --with-mysql=/usr/include/mysql work?
Go to the top of the page
 
+Quote Post
hughesjr
post Sep 3 2003, 05:36 AM
Post #4


Its GNU/Linuxhelp.net
*******

Group: Admin
Posts: 3,433
Joined: 25-July 03
From: Corpus Chrsiti, TX, USA
Member No.: 1,151



Everything I read tells me that should work ... what you might try is downloading the source for MySQL 4.0.14 (HERE). I would untar it and put it in /usr/src/mysql-4.0.14 and point there when running the configure script for apache2 ... obviously you must manually keep that directory (/usr/src/mysql-4.0.14) updated if you update the mysql rpms.


--------------------
Johnny Hughes
hughesjr@linuxhelp.net
Enterprise Alternatives: CentOS, WhiteBoxEL
Favorite Workstation Distros (in order): CentOS, Gentoo, Debian Sarge, Ubuntu, Mandrake, FedoraCore, Slackware, SUSE
Favorite Server Distros (in order): CentOS, WhiteBoxEL, Debian Sarge, Slackware, Mandrake, FedoraCore, Gentoo, SUSE
Go to the top of the page
 
+Quote Post
Joey
post Sep 3 2003, 07:03 AM
Post #5


LinuxHelp Admin
*******

Group: Admin
Posts: 1,096
Joined: 18-September 02
Member No.: 1



I see you didn't list the mysql-common rpm file. You can try installing that and seeing if it will work.
Go to the top of the page
 
+Quote Post
fobius
post Sep 6 2003, 09:47 PM
Post #6


Whats this Lie-nix Thing?
*

Group: Members
Posts: 23
Joined: 27-August 03
Member No.: 1,334



I've tried uninstalling the rpms but now i'm getting a weird error. rpm tells me that it can't uninstall:

root@localhost stuff]# rpm -e *.rpm
error: package MySQL-client-4.0.14-0.i386.rpm is not installed
error: package MySQL-devel-4.0.14-0.i386.rpm is not installed
error: package MySQL-server-4.0.14-0.i386.rpm is not installed
error: package MySQL-shared-4.0.14-0.i386.rpm is not installed

[root@localhost stuff]# rpm -Ui *.rpm
package MySQL-client-4.0.14-0 is already installed
package MySQL-devel-4.0.14-0 is already installed
package MySQL-server-4.0.14-0 is already installed
package MySQL-shared-4.0.14-0 is already installed

What's going on?
Go to the top of the page
 
+Quote Post
Joey
post Sep 6 2003, 09:53 PM
Post #7


LinuxHelp Admin
*******

Group: Admin
Posts: 1,096
Joined: 18-September 02
Member No.: 1



you have to run

rpm -e MySQL-client
rpm -e MySQL-devel etc etc
Go to the top of the page
 
+Quote Post
fobius
post Sep 6 2003, 09:58 PM
Post #8


Whats this Lie-nix Thing?
*

Group: Members
Posts: 23
Joined: 27-August 03
Member No.: 1,334



Hi,

I tried doing that, but I get a similar error:

root@localhost theo]# rpm -Uih MySQL-client-4.0.14-0.i386.rpm
########################################### [100%]
package MySQL-client-4.0.14-0 is already installed
[root@localhost theo]# rpm -e MySQL-client-4.0.14-0.i386.rpm
error: package MySQL-client-4.0.14-0.i386.rpm is not installed

wonder whats wrong..
Go to the top of the page
 
+Quote Post
Joey
post Sep 6 2003, 09:59 PM
Post #9


LinuxHelp Admin
*******

Group: Admin
Posts: 1,096
Joined: 18-September 02
Member No.: 1



its rpm -e to remove files. Check the man page for rpm.
Go to the top of the page
 
+Quote Post
fobius
post Sep 6 2003, 10:36 PM
Post #10


Whats this Lie-nix Thing?
*

Group: Members
Posts: 23
Joined: 27-August 03
Member No.: 1,334



I looked at the man pages and some other references and it seems rpm -e is the way to go. still got the same problem
Go to the top of the page
 
+Quote Post
hughesjr
post Sep 7 2003, 07:53 AM
Post #11


Its GNU/Linuxhelp.net
*******

Group: Admin
Posts: 3,433
Joined: 25-July 03
From: Corpus Chrsiti, TX, USA
Member No.: 1,151



When using rpm -e, you don't use the entire filename ... you use only the packages name ... so the command would be:

rpm -e MySQL-client-4.0.14-0 MySQL-devel-4.0.14-0 MySQL-server-4.0.14-0 MySQL-shared-4.0.14-0

When installing an rpm file, you use the full filename ... because you are working with one file; but when removing you are working with the installed package (that is, all the installed files), not the rpm file....so that's why the it's a filename for install and not the full filename for removal.


--------------------
Johnny Hughes
hughesjr@linuxhelp.net
Enterprise Alternatives: CentOS, WhiteBoxEL
Favorite Workstation Distros (in order): CentOS, Gentoo, Debian Sarge, Ubuntu, Mandrake, FedoraCore, Slackware, SUSE
Favorite Server Distros (in order): CentOS, WhiteBoxEL, Debian Sarge, Slackware, Mandrake, FedoraCore, Gentoo, SUSE
Go to the top of the page
 
+Quote Post
fobius
post Sep 14 2003, 06:49 PM
Post #12


Whats this Lie-nix Thing?
*

Group: Members
Posts: 23
Joined: 27-August 03
Member No.: 1,334



Thanks Hughes, that was very helpful. Makes sense, doesn't it?

anyone ever try installing mysql and php the way i tried? i was out of town for a few days and i'd like to try and make it work before uninstalling the rpms and installing mysql by source..

thanks
Go to the top of the page
 
+Quote Post
Joey
post Sep 14 2003, 06:59 PM
Post #13


LinuxHelp Admin
*******

Group: Admin
Posts: 1,096
Joined: 18-September 02
Member No.: 1



apache, mysql and php are pretty much the only things I don't install via RPM.
Go to the top of the page
 
+Quote Post
fobius
post Sep 15 2003, 01:03 AM
Post #14


Whats this Lie-nix Thing?
*

Group: Members
Posts: 23
Joined: 27-August 03
Member No.: 1,334



did you ever encounter the problem i described compiling php with the --with-mysql option activated? (basically everything i described in the earlier posts)?
Go to the top of the page
 
+Quote Post
Joey
post Sep 15 2003, 05:06 AM
Post #15


LinuxHelp Admin
*******

Group: Admin
Posts: 1,096
Joined: 18-September 02
Member No.: 1



Where is mysql installed? Normally it's in /usr/local/mysql when you install via tarball so your --with-mysql should point to /usr/local/mysql and not /usr/include..
Go to the top of the page
 
+Quote Post
fobius
post Sep 15 2003, 01:12 PM
Post #16


Whats this Lie-nix Thing?
*

Group: Members
Posts: 23
Joined: 27-August 03
Member No.: 1,334



Yea, I haven't tried installing mysql via tarball yet. I installed via RPM as this was the recommended way on the MySQL website. Or is it a better way to do it from source?
Go to the top of the page
 
+Quote Post
Joey
post Sep 15 2003, 01:14 PM
Post #17


LinuxHelp Admin
*******

Group: Admin
Posts: 1,096
Joined: 18-September 02
Member No.: 1



I've never had problems installing the source.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



RSS Lo-Fi Version Time is now: 22nd October 2017 - 08:55 AM