Linux, Php, and Sql Oh My...

[JeC]

I've had my computer setup behind an old Linux box for probably about a month now, and ever since I got it up and running I wanted to get a webserver running on it.

As far as the webserver goes, Its working
(http://211.28.221.90:180/), and so is the PHP.

But the Mysql Isn't. I can login remotly from my windows box to the mysql server, and I've already imported all my databases into it... but when it comes to actually accessing the Mysql from the PHP, nothing happens.

- As you can see if you go to the webserver address above, the page looks like its not finished. If you check the source, it stopps just before the first line of Mysql (you cant see it in the source, but you can see it just stopps).

There is no error message, nothing...

I find this wierd, any ideas?

I may need to change something in the php.ini ? (where is it btw?).

[sde]

which distro are you using/

[JeC]

Mandrake 8.2

[Ilya020]

Post the source either here or make a .txt file and put it on your server...

Ilya.

[sde]

i think it is a configuration problem. the best way to verify this is to make a phpinfo page

PHP Code:

<?
phpinfo();
?>

about 3/4 the way down you should see a table with MYSQL at the top. if you don't, then mysql support has not been added with your php install.

i'm not familiar with mandrake, .. i might assume it is an rpm type of os.

i know for redhat and debian, the package name for this is 'php-mysql'

even then, getting all of them to install correctly is tricky.

was mysql installed first? it should be installed before apache and php.

i wish i was more familiar with mandrake

[JeC]

sde, Mandrake uses RPMs just like Redhat as far as I know.

I will check the phpinfo(), that never crossed my mind. I may need to install a newer version of PHP, because since I had the OS installed, I added Mysql too it, over the PHP install that was already there.

Anyway, I'm at school at the moment, so I'll try all this when I get home.

[sde]

with redhat, php/mysql/apache never work together with a regular install.

what i do is gather all the php/mysql/apache related rpms off the install cd, and copy them into a directory.

then i remove all php/mysql/apache rpms from the system. usually a 'rpm -e apache' will error out and show you all the depends you need to remove.

then, i install all the php/mysql/apache rpms all at the same time. usually that will assure that they get compiled together and work nicely. like i said though .. make sure you have the 'php-mysql' package.

good luck, .. keep us posted.

[JeC]

Ok, ran phpinfo()

Heres the page w/ it

http://211.28.221.90:180/test.php

There's no SQL there yet,

What do you think should be my first action?

Reinstall PHP? (remove first)
- or something else :S

Edit - Where can I D/l PHP from in like an RPM format? Or will I have to learn how to compile now....

[sde]

yeah, i see that mysql is definately not there.

like i said, i'm not that familiar with mandrake, .. if it were redhat or debian, .. i would remove php & apache

then i'd re-install apache & php, and make sure i have the php-mysql package when i install them together.

wish i could be more help .. good luck

[schotty]

Originally posted by JeC
sde, Mandrake uses RPMs just like Redhat as far as I know.

I will check the phpinfo(), that never crossed my mind. I may need to install a newer version of PHP, because since I had the OS installed, I added Mysql too it, over the PHP install that was already there.

Anyway, I'm at school at the moment, so I'll try all this when I get home.

I am not an apache guru, but cruise on over to apache's site and see if there is docs there to assist you. Perhaps the MySQL page has a pointer or two. Chances are that you are at leat the 1,000th person to have that exact problem. And because fo that there is an answer that is out there. (**** that last line sounded like something from the XFiles ....)

Ill take a look later on today to see what is up.