MYSQL Database Problem

ps2cho · Apprentice Joined: 27 Jun 2005 Posts: 196

Hey guys.
I rescently set up a gentoo linux box and i did the following:

#emerge mod_php
#USE="foo" emerge mysql
#ebuild /var/db/pkg/dev-db/mysql-version*/mysql-version*.ebuild config
#emerge apache
# emerge php -av
# ebuild /var/db/pkg/dev-php/mod_php-version*/mod_php-version*.ebuild config

#/usr/bin/mysql_install_db
#/usr/bin/mysql -u root
mysql>SET PASSWORD FOR 'root'@'localhost' = PASSWORD('mypw');

File: /etc/conf.d/apache2
APACHE2_OPTS="-D SSL -D PHP5"

phpMyAdmin was put into the htdocs folder and i created a user.
Downloaded PHPNUke + Put all of the folder from the HTML folder into the htdocs folder.
Ran the SQL Script from a folder onto this comp (it wouldnt find the right directory to do it from the server)
It completed successfully.

I do http://localhost:89/index.php (for phpnuke) and i just get

Quote:
There seems to be a problem with the MySQL server, sorry for the inconvenience.

We should be back shortly.

I have done PHPNuke successfully on win32 platform, first time on linux. What did i do wrong?

(i didnt put the parts where i started up mysql,apache etc because thats something simple i did do)

Oh and here is my config.php

mikejr · Tux's lil' helper Joined: 07 Nov 2004 Posts: 107

You might try emerging phpmyadmin, at least it will help with databases in the future for you (just make sure you secure it via .htpasswd).

You said you started it right? Every time I've installed mySQL on a box, it just ran. What happens if you create a page info.php with the the following in it:

ter_roshak · Posted: Sun Jul 17, 2005 2:32 am Post subject:

A couple of good tools to use with MySQL that will aid in troubleshooting, setup, and configuration are the MySQL-query-browser, and MySQL-administrator. Both of these tools are available from the MySQL.com website: http://dev.mysql.com/downloads/. I think that these tools are better than using phpmyadmin because you don't have to have Apache and PHP working to interact with your database.
_________________
Josh Miller -- RHCE, VCP
Ditree Consulting
http://ditree.com/
Registered Linux User #318200

mikejr · Tux's lil' helper Joined: 07 Nov 2004 Posts: 107

Exactly, but with phpNuke he'll need them working together. Webmin works ok too... My guess is that php is not running, given the php5 reference. I'm not even sure if Nuke will run well under php5...

ter_roshak · Posted: Sun Jul 17, 2005 4:26 am Post subject:

ps2cho · Apprentice Joined: 27 Jun 2005 Posts: 196

I got e107 to work. Its PHPNuke that is the problem.

What have i done wrong?

ter_roshak · Posted: Sun Jul 17, 2005 5:11 am Post subject:

srlinuxx · l33t Joined: 22 Nov 2003 Posts: 627

Did you make sure the mysql server was running?
_________________
--You talk the talk, but do you waddle the waddle?
-Gentoo Monthly Screenshots

ps2cho · Apprentice Joined: 27 Jun 2005 Posts: 196

Well right now im getting a wierd error and im trying so hard but i cant get it to go away!
Iv posted on several different forums and nobody has replied anything basically.

mikejr · Tux's lil' helper Joined: 07 Nov 2004 Posts: 107

Both phpNuke and e107 require php/MySQL.

What happens if you add :80 after your sites address? http://localhost:80 ?

What USE flags are you using? Did you verify that php was working?

The permission issue is usually the Allow setting in your apache config. Are you running your server on port 89?