LinuxQuestions.org - Apache, mySQL, php

- Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)

- - Apache, mySQL, php (https://www.linuxquestions.org/questions/linux-software-2/apache-mysql-php-350675/)

Apache, mySQL, php

I compiled these from source by
./configure
make
make install

just wondering how i can set these up to work together, like a PHP-NUKE system or similar

Did you add mysql support to apache;
http://www.linuxhelp.net/guides/lamp/
down at the bottom is how to get apache to load php support
For mysql;

http://www.webdevelopersnotes.com/tu..._on_linux.php3
http://dev.gentoo.org/~chriswhite/mysql.html
lots of guides on google

hmm.. thanks for the guides, while i was following the first one and after i did
[root@server bin]# /usr/local/mysql//bin/mysqld_safe --skip-networking >> /dev/null &
[1] 10411

i got

[root@server bin]# chown: `mysql': invalid user

any help would be great, thanks :) :Pengy:

Once i have it installed all I do is;

Code:

/usr/bin/mysqladmin -u root -h localhost password 'new-password'

$ mysql -u root  -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 4 to server version: 4.0.24-debug



Type 'help;' or '\h' for help. Type '\c' to clear the buffer.



mysql>quit

Just to see if it is working. Then I install phpmyadmin.

Tried /usr/bin/mysqladmin -u root -h localhost password 'new-password'

and got

[root@server ~]# /usr/local/mysql/bin/mysqladmin -u root -h localhost password 'linux'
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!

:(

Re: Apache, mySQL, php

Quote:

Originally posted by Kupo
I compiled these from source by
./configure
make
make install

just wondering how i can set these up to work together, like a PHP-NUKE system or similar

Why didn't you just install it from the fedora cd or yum?

trying to learn how to install it from source

What did you find when you:
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!

Whats the command to find out that?

I'm not sure so all this is just a guess,

Quote:

[root@server bin]# /usr/local/mysql//bin/mysqld_safe --skip-networking >> /dev/null &
[1] 10411

i got

[root@server bin]# chown: `mysql': invalid user

Try

Code:

cd /usr/local/mysql/bin

ls (do you see mysql_safe? if yes try)



./mysql_safe --user=mysql &

http://dev.mysql.com/doc/mysql/en/mysqld-safe.html

Here is some more info on fedora and apache2,mysql and php;
http://www.neowin.net/forum/lofivers...p/t296612.html

hmm i got mysql to work now when i try to configure php to work with apache and mysql with this command

./configure --with-apache=../httpd-2.0.54 --with-mysql=/usr/local/mysql/

it returns

(after the normal ./configure stuff)

Configuring SAPI modules
checking for AOLserver support... no
checking for Apache 1.x module support via DSO through APXS... no
checking for Apache 1.x module support... configure: error: Use --with-apxs2 with Apache 2.x!

so i did

./configure --with-apxs2=../httpd-2.0.54 --with-mysql=/usr/local/mysql/

and it returned

Configuring SAPI modules
checking for AOLserver support... no
checking for Apache 1.x module support via DSO through APXS... no
checking for Apache 1.x module support... no
checking for mod_charset compatibility option... no
checking for Apache 2.0 filter-module support via DSO through APXS... no
checking for Apache 2.0 handler-module support via DSO through APXS...

Sorry, I cannot run apxs. Possible reasons follow:

1. Perl is not installed
2. apxs was not found. Try to pass the path using --with-apxs2=/path/to/apxs
3. Apache was not built using --enable-so (the apxs usage page is displayed)

The output of /usr/local/src/httpd-2.0.54 follows:
./configure: line 5467: /usr/local/src/httpd-2.0.54: is a directory
configure: error: Aborting

Thanks for the help :)