Running Mysql With Apahce And PHP

pcuser · 2011-07-23 18:53:53

hello I recently installed apache php and mysql on my arch linux system, but mysql dosnt seem to be running with the apahce server. when I run the mysql command everything works find, I can run commands setup databases and all that, but It seems that I cannot connect to mysql via PHP. for example when I try to install joomla on my server It tells me that there is no mysql support. If mysql works fine when I use it through the command line why wont it work through PHP/web server? Thanks in advance

Pierre · 2011-07-23 18:55:40

Make sure to have the needed mysql module loaded in php.ini.

litemotiv · 2011-07-23 18:55:56

Is mysql support enabled in your php.ini?

pcuser · 2011-07-23 19:03:12

How do I enable it? what line in php.ini do I need to change? and by the way, is it possible to change the apahce root directory from /srv/http to something in my home directory? thanks

litemotiv · 2011-07-23 19:11:45

https://wiki.archlinux.org/index.php/LAMP#MySQL

pcuser · 2011-07-23 19:31:38

I actually have read through the documentation and i did figure out how to enable mysql but am having some issues with setting the document root. I have changed the DocumentRoot and the Directory line in httpd.conf to a folder in my home directory but when I type local host into a web browser I get the following message:

Access forbidden!
You don't have permission to access the requested directory. There is either no index document or the directory is read-protected.
If you think this is a server error, please contact the webmaster.
Error 403
localhost
Sat Jul 23 12:35:16 2011
Apache/2.2.15 (Unix) PHP/5.3.2 with Suhosin-Patch mod_ssl/2.2.15 OpenSSL/1.0.0 DAV/2

I didnt recieve this message when the document root was set as /srv/http. I'm missing a step here. thanks.

lifeafter2am · 2011-07-23 19:35:22

pcuser wrote:

I actually have read through the documentation and i did figure out how to enable mysql but am having some issues with setting the document root. I have changed the DocumentRoot and the Directory line in httpd.conf to a folder in my home directory but when I type local host into a web browser I get the following message:
Access forbidden!
You don't have permission to access the requested directory. There is either no index document or the directory is read-protected.
If you think this is a server error, please contact the webmaster.
Error 403
localhost
Sat Jul 23 12:35:16 2011
Apache/2.2.15 (Unix) PHP/5.3.2 with Suhosin-Patch mod_ssl/2.2.15 OpenSSL/1.0.0 DAV/2
I didnt recieve this message when the document root was set as /srv/http. I'm missing a step here. thanks.

That's because the user "apache" doesn't have access to your user's home folder.

pcuser · 2011-07-23 19:50:23

oh ok. is there a way I can resolve that? if sow how? thanks

lifeafter2am · 2011-07-23 19:55:54

pcuser wrote:

oh ok. is there a way I can resolve that? if sow how? thanks

Literally 10 seconds of googling: http://httpd.apache.org/docs/1.3/misc/F … #forbidden

pcuser · 2011-07-23 23:43:58

only 10 seconds? nice..however I still would like someone to explain this if possible because I am still lost. on that link you gave me it said the user/group that apahce is on is not allowed to access those files/folders. How do I change that? the page also said something about chmod, but not I am not sure what to chmod the files to. Excuse the noobieness, but can someone lead me to the solution? google hasn't helped so far. thanks for the help so far guys.

Last edited by pcuser (2011-07-23 23:48:32)

lifeafter2am · 2011-07-24 02:22:49

pcuser wrote:

only 10 seconds? nice..however I still would like someone to explain this if possible because I am still lost. on that link you gave me it said the user/group that apahce is on is not allowed to access those files/folders. How do I change that? the page also said something about chmod, but not I am not sure what to chmod the files to. Excuse the noobieness, but can someone lead me to the solution? google hasn't helped so far. thanks for the help so far guys.

Honestly, this would be the better way to do it; as chmod'ing your entire home directory just so you can use it for apache is a security risk.

http://httpd.apache.org/docs/2.0/howto/public_html.html

The reason I mention google is because, by nature, Arch is a distro for learning and trying things out yourself. You should get comfortable with basic commands, learn how to search / use man pages, etc. Hand holding is not something that is usually done around here.

Last edited by lifeafter2am (2011-07-24 02:24:10)

pcuser · 2011-07-24 18:38:18

Lol so what are these forums for then anyways? I am a noobie to arch not to linux. after a stage 1 gentoo installation i've become more then comfortable using linux and its commands, but I dont like "guessing" what lines a file to edit. I have also done my fair share of googling in my day lol, however this issue had me stumped. perhaps this is the wrong place seek help? I wish my old computer could properly run a more userfriendly distro like ubuntu, that would make things easy lol.

lifeafter2am · 2011-07-24 21:33:00

pcuser wrote:

Lol so what are these forums for then anyways? I am a noobie to arch not to linux. after a stage 1 gentoo installation i've become more then comfortable using linux and its commands, but I dont like "guessing" what lines a file to edit. I have also done my fair share of googling in my day lol, however this issue had me stumped. perhaps this is the wrong place seek help? I wish my old computer could properly run a more userfriendly distro like ubuntu, that would make things easy lol.

If your from back in the day when we used to do Stage 1 Gentoo installs, then honestly you should have no issue editing config files by hand. I used Gentoo for over 7 years, and it was where most of my hard learning came from. Arch should be a breeze comparatively.

These aren't Arch specific files here, they are Apache files, which are the same across systems.

It may seem like it, but I am really not being a dick or anything ... just saying that most of what is being said here is easily accessible from the Apache documentation.

Last edited by lifeafter2am (2011-07-24 21:37:13)

Arch Linux

#1 2011-07-23 18:53:53

Running Mysql With Apahce And PHP

#2 2011-07-23 18:55:40

Re: Running Mysql With Apahce And PHP

#3 2011-07-23 18:55:56

Re: Running Mysql With Apahce And PHP

#4 2011-07-23 19:03:12

Re: Running Mysql With Apahce And PHP

#5 2011-07-23 19:11:45

Re: Running Mysql With Apahce And PHP

#6 2011-07-23 19:31:38

Re: Running Mysql With Apahce And PHP

#7 2011-07-23 19:35:22

Re: Running Mysql With Apahce And PHP

#8 2011-07-23 19:50:23

Re: Running Mysql With Apahce And PHP

#9 2011-07-23 19:55:54

Re: Running Mysql With Apahce And PHP

#10 2011-07-23 23:43:58

Re: Running Mysql With Apahce And PHP

#11 2011-07-24 02:22:49

Re: Running Mysql With Apahce And PHP

#12 2011-07-24 18:38:18

Re: Running Mysql With Apahce And PHP

#13 2011-07-24 21:33:00

Re: Running Mysql With Apahce And PHP

Board footer