Stop Microsoft
Operating Systems => Linux and UNIX => Topic started by: Maniaman on 19 December 2002, 07:23
-
I'm having some problems with my Install of PHP and MySQL.
On a PHP sciprt I made I need it to connect to MySQL.
I keep getting this error:
Fatal error: Call to undefined function: mysql_connect() in /var/www/html/register1.php on line 21
Here's Line 21 of that file
mysql_connect("localhost", "root", "*");
*Password Removed
It works on other builds of PHP...
Also, where does MySQL keep all of it's configuration? (Stupid question)
-
What distro please? If it's Red Hat you'll need to install the "php-mysql" RPM from your CD. The equivalent of that will need to be installed on any other Linux distro. And of course MySQL has to be installed but I am sure you know that. It would depend on what distro you are using as the where it's configuration files are.
[ December 18, 2002: Message edited by: void main ]
-
Distro = Linux Mandrake 9.0
I also have installed the php-mysql rpm
[ December 19, 2002: Message edited by: Maniaman ]
-
quote:
Originally posted by Maniaman:
I'm having some problems with my Install of PHP and MySQL.
On a PHP sciprt I made I need it to connect to MySQL.
I keep getting this error:
Fatal error: Call to undefined function: mysql_connect() in /var/www/html/register1.php on line 21
Here's Line 21 of that file
mysql_connect("localhost", "root", "*");
*Password Removed
It works on other builds of PHP...
Also, where does MySQL keep all of it's configuration? (Stupid question)
Haa it connected before on another page, have you made a simple sql connection test?
-
And you have MySQL and MySQL-client RPMs installed? And the MySQL server is up and running? And you have php and php-common RPMs installed?
I don't have Mandrake 9.0, this stuff just works when installed on Red Hat. I haven't found anything on the web to indicate it should be any harder than this on Mandrake. Sorry if I haven't been much help.
P.S. You never would want to use "root" and root's real Linux password in a PHP script.
P.S.S. I notice Mandrake breaks out Apache into more RPMS. I don't know if these are needed but other RPMs you might want to make sure are installed are:
apache-common
apache-conf
apache-modules
[ December 19, 2002: Message edited by: void main ]
-
This is the first script that I've used with MySQL...
I'm a n00b when it comes to stuff like this so what's a connection test? If it's a script that just tries to connect to MySQL, then no. That doesn't work
-
Try this one:
delete the (REMOVEME)
-
Also, is mysql actually running?
can you do
$ mysqladmin ping
for me?
-
The thing that leads me to believe he doesn't have all the necessary RPMs installed is it says mysql_connect() is an undefined function. That should be part of php-mysql. I would think he would get a different error if it recognized the function but was improperly used.
-
quote:
Originally posted by void main:
The thing that leads me to believe he doesn't have all the necessary RPMs installed is it says mysql_connect() is an undefined function. That should be part of php-mysql. I would think he would get a different error if it recognized the function but was improperly used.
Hmm, good point.
Maniaman I would install Mandrake98.0 and take a look at this for you, but my mandrake 9 CD's don't work so I said fsck it...
-
and if anybody say's you can't fsck a CD I will kill you because that would be a poor attempt at comedy.
-
Maniaman, download and install this or get it off your CD.
ftp://ftp.mirror.ac.uk/sites/sunsite.uio.no/pub/unix/Linux/Mandrake/Mandrake/9.0/i586/Mandrake/RPMS/php-mysql-4.2.3-1mdk.i586.rpm (http://ftp://ftp.mirror.ac.uk/sites/sunsite.uio.no/pub/unix/Linux/Mandrake/Mandrake/9.0/i586/Mandrake/RPMS/php-mysql-4.2.3-1mdk.i586.rpm)
-
I already have that package installed Tux... It still wont work.
-
Do me a huge favor and tell me what is the output of this command:
$ rpm -qa | grep -i mysql
-
libmysql10-3.23.52-1mdk
perl-Mysql-1.22_19-5mdk
php-mysql-4.2.3-1mdk
MySQL-3.23.54a-1
-
I'm stumped but i'm sure void main has the master plan in his back pocket... :D
-
1) It looks like you have upgraded MySQL above what came on the CDs. Also I am not sure if it is necessary but you do not have "MySQL-client" installed. You will definitely need it to do command line work with MySQL. Get the MySQL-client RPM of the same version of your MySQL server, wherever you got that from.
2) Have you checked your /etc/php.ini file and make sure MySQL is enabled?
3) Is your MySQL server configured and running? Did you try the ping command that Tux asked you about earlier?
[ December 20, 2002: Message edited by: void main ]
-
I installed the same MySQL that came on the CD's. I also installed all the MySQL packages on the CD. It's enabled in the php.ini file. Still no luck :(
-
You need to give us more help, did you try the ping command that Tux referred to earlier? Is the MySQL service actually running? Can you connect to it with:
$ mysql
or
$ mysql -u root
or
$ mysql -u root -p
if you set up a root MySQL user with a password. If you don't know what any of these commands do you need to first go through a MySQL tutorial and make sure you have MySQL up and running and configured properly. Then go back to getting php-mysql working.
If none of this works I would have to suggest installing Red Hat 8.0. It works out of the box and I would be in a much better position to help you out.
-
I agree with the above, you should test out your mySQL install first. Just running the RPMs won't do it on a lot of systems, you have do some configuring. Luckily mysql.com is packed with documentation. It never fails.
Honestly, I have had a lot of problems with the RPM installs, and usually go the tarball route. Seems to work better for me.