19 replies to this topic

[phpforfun]

Has anyone configured MYSQL with PHP after they are both already installed? I found that installing a simple LAMP server on ubuntu 8.10 is not so simple, the php doesnt even come with a php.ini file, but john helped me with that one. I am however having problems getting MySQL to work. I know how to compile it when im installing everything, but how about once they are already installed? Im a bit scared to uninstall anything, it was crazy hard to get it to all work together as it is.

Justin

[morefood2001]

I normally use apt-get commands to install php, php-mysql, mysql-client, mysql-server. Apt-get does the rest of the configuration.

It sounds like you did a manual compile, but version 8.10 doesn't exist, are you using 8.04 or 7.10? If you compiled manually, you need to go into the php.ini and enable the php-mysql extension. If you didn't install the module files, you are going to have to recompile php with mysql support.

I trust that mysql works correctly out of the box as I have never had to configure it, even after a build compile.

[phpforfun]

morefood2001 said:

I normally use apt-get commands to install php, php-mysql, mysql-client, mysql-server. Apt-get does the rest of the configuration.

It sounds like you did a manual compile, but version 8.10 doesn't exist, are you using 8.04 or 7.10? If you compiled manually, you need to go into the php.ini and enable the php-mysql extension. If you didn't install the module files, you are going to have to recompile php with mysql support.

I trust that mysql works correctly out of the box as I have never had to configure it, even after a build compile.

It seems that LAMP for 8.10 is pretty much screwed, unless its installed on 7.04 then you upgrade your OS.

I installed it just like you said, and also tried it with the SPM, neither provided the php.ini file where it should be, I did however manage to restore that, but not the MySQL support.

Heh, I VNC'd to my pc from work and copied the php.ini to php.txt in the public_html folder, lol.
http://68.165.192.156/php.txt

[morefood2001]

Mysql is enabled in php from that txt file.

Apt get makes most everything easier and does the configuration for you, so you don't have to think lol. Why not attempt uninstalling it? I'm sure there must be a way to uninstall it.

If not, just try installing it from apt-get, I'm sure the server will fix the conf files to point to the apt-get install version.

If you aren't that far into configuring the server, perhaps starting over is the best way. To install apache, I believe its apt-get install httpd or apache2. In centos, I know that will also enable service restart httpd (a command I frequently use lol).

Hope this helps!

[phpforfun]

I have un installed it and installed it, every way I can think of, apt-get, and even the install manager.

The installs arent meant for ubuntu 8.10 is my guess...

[morefood2001]

Thats strange. Must be since you already compiled it, apt-get won't let you uninstall it.

Try apt-get remove php etc. See if its already installed. Feel free to contact me when I get on IM later tonight (I'm kind of on the road atm), maybe I can help you then :)

[phpforfun]

I have removed MySQL and PHP multiple times, and each time I do a complete install, it wont install the php.ini file. which puts me back to step 1.

I didnt even know php would work without php.ini. lol

php.ini is fixed tho, its about getting php to work with MySQL

[phpforfun]

is it possible to downgrade ubuntu? lol

[John]

As mentioned last month (when you first started setting up a LAMP), why not compile it from source?

[morefood2001]

John said:

As mentioned last month (when you first started setting up a LAMP), why not compile it from source?

I rarely have luck building from source, but I would recommend it at this point.

[phpforfun]

I just would rather not start from step one from the 10th time, but I suppose I will try it. Should I install EVERYTHING from source or just php?

[phpforfun]

I think Ubuntu Desktop is sh*t to install LAMP on, atleast 8.10 is.

Where he hell is the apache configuration apxs? When I had 7.04 on my laptop, It was in /usr/local/apache2/bin/apxs.. but not in this version.

Edit: And yes, I did a search on my local box