apache, php, mysql on linux

MrSako · 07-15-2006, 03:02 AM

ooooooooooooooooooooooooooooo i figured out what i was doing wrong, i wasnt really in the right directory

i did ./configure and it said

Quote:

NOTE: This is a MySQL binary distribution. It's ready to run, you don't
need to configure it!

To help you a bit, I am now going to create the needed MySQL databases
and start the MySQL server for you. If you run into any trouble, please
consult the MySQL manual, that you can find in the Docs directory.

Installing all prepared tables
Fill help tables

To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h vps.mydomain.com password 'new-password'
See the manual for more instructions.

You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the ./bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
Starting the mysqld server. You can test that it is up and running
with the command:
./bin/mysqladmin version
Starting mysqld daemon with databases from /home/mysql/mysql-standard-5.0.22-linux-i686/data
STOPPING server from pid file /home/mysql/mysql-standard-5.0.22-linux-i686/data/vps.mydomain.com.pid
060715 03:10:22 mysqld ended

so it turns out its a binary. so i dont know what to do now

jstephens84 · 07-15-2006, 06:21 AM

Ok here we go.

Code:

groupadd mysql
useradd -g mysql mysql
cd /usr/local
tar -zxvf < /path/to/mysql-VERSION-OS.tar.gz 
cp mysql-version-OS.tar.gz /usr/local/mysql
cd /usr/local/mysql
scripts/mysql_install_db --user=mysql
chown -R root  .
chown -R mysql data
chgrp -R mysql .
bin/mysqld_safe --user=mysql &

this should get you going. Now this will be different due to the information will now be in /usr/local/mysql. Databases will not be in /var. However you can work around this and get your databases there but That is beyond me. It normally takes me sitting in front of the screen to do this. Any problems let me know.

MrSako · 07-15-2006, 02:22 PM

when i typed in the scripts/mysql_install_db part i got a bunch of this

Quote:

> scripts/mysql_install_db --user=mysql
Installing all prepared tables
Fill help tables
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_topic.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_topic.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_keyword.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_keyword.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)

and went over and on with a whole bunch of help related files with frm extensions but at the very bottom it prints out

Quote:

To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h vps.mydomain.com password 'new-password'
See the manual for more instructions.

NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
the ./bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the ./bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com

im going ot keep fallowing the instructions but i just didnt expect that

also is this normal?

Quote:

> bin/mysqld_safe --user=mysql &
Starting mysqld daemon with databases from /usr/local/mysql/data
STOPPING server from pid file /usr/local/mysql/data/vps.mydomain.com.pid
060715 14:26:16 mysqld ended

jstephens84 · 07-15-2006, 02:35 PM

Could you post your my.cnf file.

MrSako · 07-15-2006, 05:31 PM

i looked around for it, but i dont see where my "my.cnf" file is

jstephens84 · 07-15-2006, 05:52 PM

It should either be in /usr/local/mysql or /etc. It also maybe that you have to rename something like my-huge.cnf or my-small.cnf to my.cnf or my.conf. Can't remember off the top of my head.

MrSako · 07-15-2006, 06:25 PM

i found the cnf files you were talking about,

/usr/local/mysql/mysql-test/std_data/ndb_config_mycnf1.cnf
/usr/local/mysql/mysql-test/std_data/ndb_config_mycnf1.cnf
/usr/local/mysql/support-files/my-huge.cnf
/usr/local/mysql/support-files/my-innodb-heavy-4G.cnf
/usr/local/mysql/support-files/my-large.cnf
/usr/local/mysql/support-files/my-medium.cnf
/usr/local/mysql/support-files/my-small.cnf

what are the differences between them? and where do i place the one i want?

jstephens84 · 07-15-2006, 06:37 PM

This depends on how this machine will be used. If it is for development purposes then You may just want to go with my-small.cnf. If you are using this in a production environment then you may want to choose medium - huge. The difference is how much the optimization of each of them.

You will need to copy them probably to either /etc or /usr/local/mysql. I am probably going to say copy them to /etc. Then try to run mysql_install_db --user=mysql again. I am currently installing CentOS 4.3 on a test server at my house so once it finishes I will be able to get a better look at what is going on.

MrSako · 07-15-2006, 09:56 PM

i try putting it in /usr/local/mysql and /etc each time it did the same thing

> bin/mysqld_safe --user=mysql &
Starting mysqld daemon with databases from /usr/local/mysql/data
STOPPING server from pid file /usr/local/mysql/data/vps.myfomain.com.pid
060715 21:57:14 mysqld ended

jstephens84 · 07-16-2006, 01:50 AM

can you post the my.cnf file that is used? I think I came acrossed this error before.

MrSako · 07-16-2006, 01:49 PM

this is my.cnf which currently resides in /usr/local/mysql/my.cnf

http://rafb.net/paste/results/PVaFHx57.html

jstephens84 · 07-16-2006, 02:45 PM

What are the permissions for /usr/local/mysql/data. Is mysql the owner and the group for that directory. If not then do the following to change the permissions on the folder.

Code:

chown -R /usr/local/mysql/data mysql
chgrp -R /usr/local/mysql/data mysql

the issue a mysql_install_db --user=mysql

MrSako · 07-16-2006, 03:06 PM

> chown -R /usr/local/mysql/data mysql
chown: `/usr/local/mysql/data': invalid user

but i did create the mysql user....

MrSako · 07-16-2006, 04:36 PM

nevermind it seems it was just the wrong syntax
> chown -R mysql:mysql /usr/local/mysql/data
> chgrp -R mysql /usr/local/mysql/data
> mysql_install_db --user=mysql
bash: mysql_install_db: command not found

thats what i just did

i also did this again no luck

> bin/mysqld_safe --user=mysql &
Starting mysqld daemon with databases from /usr/local/mysql/data
STOPPING server from pid file /usr/local/mysql/data/vps.mydomain.com.pid
060716 16:39:27 mysqld ended

MrSako · 07-16-2006, 05:26 PM

ok i got mysql to start!!!!

idunno how but its running but unfourtnatly i still get this in my httpd error log

[client 24.163.113.48] PHP Fatal error: Call to undefined function mysql_connect() in /var/www/html/phpinfo.php on line 8